Hey everyone! I was wondering if I could get some advice... I have a legal internship coming up and a friend who did it last year said that they got a lot of tasks looking at companies house and making a spreadsheet with all the information. I was wondering if anyone had any good resources to help!
@Abbie Whitlock @Jaysen any help or ideas would be greatly appreciated!
Hey!
This is a great question - I used Companies House quite a lot when I was a paralegal, so I can share some small tips that might help you navigate it when completing tasks!
If you are going to be using Companies House a lot, the main thing is getting comfortable with what to look for and how to extract it efficiently, so I'd definitely take a look at the website itself. I'd recommend just picking a random company and having a play around so you can get familiar with the layout.
In terms of what you are likely to be pulling into spreadsheets, it'll probably be things such as:
- Company number, incorporation date, and status
- Registered office address
- Directors (appointments/resignations)
- Persons with Significant Control (PSCs)
- Filing history (especially things such as confirmation statements and accounts)
- Charges
A few general tips that really helped me:
- Use the filing history tab - this is where most of the useful detail is (e.g. shareholder information in confirmation statements, accounts for financials, etc.)
- Open documents in new tabs so that you don't keep losing your place
- Be consistent with formatting in your spreadsheet (dates, names, etc) - it sounds really basic, but it makes your work look much more professional!
- Don't overcomplicate it too much - they are usually looking for accuracy and clarity, rather than anything overly analytical
If you wanted to go a step further, it might be worth brushing up on basic Excel skills (e.g. sorting, filtering, formatting, etc.). However, I don't think anything advanced would be expected, and I am definitely no Excel expert and seemed to manage just fine!
I'm sure you'll pick it really quickly once you are doing it day-to-day, so I wouldn't stress too much - just getting familiar with the website beforehand will already put you in a good position. Best of luck with the internship!
