Need a book on completing Ltd company accounts

Kerwin

Free Member
Dec 1, 2018
894
188
I'm in need of a book to help me manually handle the majority of my accounting for a private limited company registered in England. At the moment I just have an Excel spreadsheet but I'm looking at cloud accounting software to be a bit more organised but I have to wait for the company details to be confirmed by Companies House before I can open a business bank account to pay for things.

So a book that explained things to me in a simple and (most importantly) concise manner would be excellent. Happy to hear all suggestions.
 
  • Like
Reactions: RandomQ's
HI Kerwin
Companies House has guidance on what is needed for statutory micro accounts.
but HMRC have some great guidance on what you need to do, what you can claim etc
Basic rules:
- record everything you use for your business (keep receipts for expenses and record mileage)
- raise dated sales invoices with sequential numbering and company details for every sale.
- open a business bank account, but in the early stages remember to keep track of any expenses that you pay privately due to cashflow constraints (these represent money you are loaning the business, which can be repaid once funds are available).
- When taking money out of the business (in payroll or dividend), don't forget to leave enough profit to cover the corporation tax (roughly 19% or pre-dividend, post payroll profit).
- Late filings of accounts and tax returns incur penalties. Companies House accounts filings can be done via HMRC filings. CT payable 9 months after year end. HMRC does have free accounts and tax return online filing functionality, but a friend of mine did find it very difficult to do on their own.
- think carefully before registering for VAT. The additional administration costs/responsibilities may mean that its not worthwhile. It depends on what you are selling, who you are selling to and how much VAT you pay within the expenses supplied to your business. Once you reach £85k annual turnover it is compulsory, before then it is your decision.

If you are only just setting up, I would recommend that you consider a Tide Banking Account. All the set up in online, with no monthly bank fees, which includes sales invoicing and expenses categorisation capability. This basic accounting functionality may keep you going for a little while, unless you need payroll or project management functionality.

If you want more comprehensive accounting software then ask an accountant to provide it. We often get special deals on software licences, plus you have someone on hand to set you up and to ask the odd question during the year. Other accountants may use other software, just make sure you choose cloud software.

Re Buying a book.... hmmm... even as an accountant, I find them deathly boring. I'm more of a hands on sort of girl and with things moving into the cloud, some books may be becoming outdated. Just remember evidence and document what, when, where, who and why.

Good luck with your new exciting adventure.
 
Last edited by a moderator:
Upvote 0
I didn't use it myself in my accoubting studies but Frank Wood's Business Accounting is susposed to be the best.

https://www.amazon.co.uk/Frank-Woods-Business-Accounting-v/dp/0273712128
https://www.amazon.co.uk/Frank-Woods-Business-Accounting-v/dp/0273712128

Thanks. I'll get that then.

When you say you are using an Excel spreadsheet at the moment I assume that this is for pre trading expenses that the compnay will reimburse you for?

Yep. It has two transactions on it.
 
Upvote 0
Because I'm tight, I'm happy to turn by hand to most things, but I would never try to prepare by own accounts. It simply isn't cost effective.

Keep detailed records. I used Excel for a few years then moved on to Xero, mainly because of MTD and to save a few quid a month by doing my own payroll (I said I was tight). Xero is just a fancy record keeper though, it won't help you prepare your accounts.

Speak to an accountant. Most will give you a free consultation and will run through the key points around records, taxation, how to pay yourself and so on.
 
Upvote 0
Why?

The subscription model for accountancy is a con.

OP, find a frigging accountant who can work with an accountancy solution that's not screwing you by the month!

Hi Clinton
It's all a matter of how much value you put on time and how well you use the software.

Even full priced the Xero starter edition is only £10 per month, but if you use it smartly you can streamline your Quote to invoice to settlement routine in a way that saves you considerable time in comparison to using MSWord, Excel even if your customer is a good payer.
If you have trouble with debt recovery, you can also easily email statements with no additional work within Xero, whereas manually this exercise might just feel like a headache that you don't want to spend your weekend doing.

If you have recurring invoices to customers, you can be even smarter and get the system to raise and send them without you pressing a button.

Like everything in life, its how you use it.
I have used Excel extensively over the years, but I would choose a supported accounting programme over an unsupported spreadsheet, where possible .
 
Upvote 0
HI Kerwin
Companies House has guidance on what is needed for statutory micro accounts.
but HMRC have some great guidance on what you need to do, what you can claim etc
Basic rules:
- record everything you use for your business (keep receipts for expenses and record mileage)
- raise dated sales invoices with sequential numbering and company details for every sale.
- open a business bank account, but in the early stages remember to keep track of any expenses that you pay privately due to cashflow constraints (these represent money you are loaning the business, which can be repaid once funds are available).
- When taking money out of the business (in payroll or dividend), don't forget to leave enough profit to cover the corporation tax (roughly 19% or pre-dividend, post payroll profit).
- Late filings of accounts and tax returns incur penalties. Companies House accounts filings can be done via HMRC filings. CT payable 9 months after year end. HMRC does have free accounts and tax return online filing functionality, but a friend of mine did find it very difficult to do on their own.
- think carefully before registering for VAT. The additional administration costs/responsibilities may mean that its not worthwhile. It depends on what you are selling, who you are selling to and how much VAT you pay within the expenses supplied to your business. Once you reach £85k annual turnover it is compulsory, before then it is your decision.

If you are only just setting up, I would recommend that you consider a Tide Banking Account. All the set up in online, with no monthly bank fees, which includes sales invoicing and expenses categorisation capability. This basic accounting functionality may keep you going for a little while, unless you need payroll or project management functionality. I am a Tide Partner and can get you a preferential deal.

If you want more comprehensive accounting software then ask an accountant to provide it. We often get special deals on software licences, plus you have someone on hand to set you up and to ask the odd question during the year. I am a Xero Partner (desktop and mobile accounting) and I have discounted subscriptions up to March 2020 available at the moment. Other accountants may use other software, just make sure you choose cloud software.

Re Buying a book.... hmmm... even as an accountant, I find them deathly boring. I'm more of a hands on sort of girl and with things moving into the cloud, some books may be becoming outdated. Just remember evidence and document what, when, where, who and why.

Good luck with your new exciting adventure.

Thank you for the extremely helpful post. I'll try and follow your advice although I think I already made a couple of mistakes. For instance, I bought a domain name for my business from Namecheap on my personal account. I use pre-paid credit so nothing is going to show up on my personal banking and I deleted the receipt email that I received. I know it cost roughly £6.76 but I'm not 100% on the exact date and amount.

I also used a couple of personal accounts for business-related things that while they didn't cost money does muddy the water somewhat. For instance, I paid £288 for a year-long privacy email address and VPN for myself out of my own personal finances. I have my personal email address hosted there but I created a second email address using the domain name I mentioned previously that I bought from Namecheap so now I have personal and business stuff coming from the same account. How much does the business owe me from the £288 I originally paid? I don't know how this kinda thing all works and in the future, I'll make sure it doesn't happen for clarity.

Also, double entry bookkeeping seems like a dark art to me. I'd much rather pay someone else to handle all of this stuff for me but money issues make that a bit difficult at the moment. Thankfully I went through all of my personal financial information and cancelled absolutely everything that was non-essential so I could loan the company as much money as I could afford. I'm going to see if I can get a small loan for the company so at the moment I'm just cleaning up my business plan so it is as good as I can possibly make it.

I like cloud software as well. I'm a computer programmer and use Linux as my operating system so I'm used to software being Windows and/or macOS only and not running that well on Linux so having accounting software I can use in Firefox would be great. I'd happily pay £10 a month for this sort of thing.

Anyway, thank you again. I'll look into the guidance documents that mentioned but I'm also going to buy the book that was mentioned in this thread as well. You can never have too much information!
 
Upvote 0
How much does the business owe me from the £288 I originally paid?

For an ongoing service the company can only pay from the date it is incorporated.

double entry bookkeeping seems like a dark art to me.

If you use accounting software it will do the double entries for you. You just need to understand concepts like debtors and creditors, capital and revenue etc.

I recommend hiring an accountant as soon as possibel They will help you with these issues. Limited company accounting and tax are complicated. Although I have worked 40 odd years as an accountant I leave working with limited companies to those who specialise.
 
Upvote 0
I'm in need of a book to help me manually handle the majority of my accounting for a private limited company registered in England. At the moment I just have an Excel spreadsheet but I'm looking at cloud accounting software to be a bit more organised but I have to wait for the company details to be confirmed by Companies House before I can open a business bank account to pay for things.

So a book that explained things to me in a simple and (most importantly) concise manner would be excellent. Happy to hear all suggestions.

I'm not really sure a book on bookkeeping or accounting is going to be a huge help to you. Many are directed at people training to be accountants and as such aren't concise. But if you want to look for some have a look at AAT accountancy books.

If you have an accountant get support from them on using whichever cloud software you decide upon, you have lots of choice. My personal favorites are Accounts Portal and FreeAgent but it depends on what you need from your software. Do you have any specific requirements?

By the way no need to wait until your business bank account is open to pay for things. Your company can still incur costs without a bank account, you can pay for them on its behalf and be repaid later. It's what a lot of new businesses will do and is called a directors loan.
 
Last edited:
Upvote 0
I'm in need of a book to help me manually handle the majority of my accounting for a private limited company registered in England. At the moment I just have an Excel spreadsheet but I'm looking at cloud accounting software to be a bit more organised but I have to wait for the company details to be confirmed by Companies House before I can open a business bank account to pay for things.

So a book that explained things to me in a simple and (most importantly) concise manner would be excellent. Happy to hear all suggestions.

@Kerwin just a thought (and it may not be the best option for you, it depends on what you need from your software) but if you are opening a bank account with RBS, Natwest or Mettle FreeAgent is free.
 
Upvote 0
@Kerwin just a thought (and it may not be the best option for you, it depends on what you need from your software) but if you are opening a bank account with RBS, Natwest or Mettle FreeAgent is free.

Thank you for your replies.

After reading through this thread and some other resources online I've decided that I agree with the people who have said it in this thread and on other places on the internet and will hire an accountant. Unfortunately due to financial constraints, I'm unable to spend much money on an accountant. I'd rather pay monthly rather than a big lump sum as it is easier to handle (my personal finances have income once every 2 weeks and once a month) as I can buy things for the business over a longer period of time.

I still want to get a book though. Knowledge of what your accountant is doing can't hurt and will probably mean I'll be able to ask more intelligent and worthwhile questions rather than bombarding them with stupid questions (especially is they charge by time spent or something similar). I'll start a new thread asking for help on choosing the right accountant for my business as my needs are a little unique.
 
Upvote 0
Im in a similar position.
I've had one client who I invoiced mostly for a period of six months (first year).
It seems unnecessary to hire an accountant for my small, non-complex company, so I'm doing it myself.
There is no way I can't learn how to submit properly over the next few months. Plus, its a bloody good skill to have.
Furthermore, the two accountants Ive sought advice from have both quoted for work I now understand is not needed.

First thing Id say, organise all your incomings and outgoings into categories.
That'll make it easier to see what you can and cannot claim against.

I kinda messed up a bit as I was using the company card like a new toy, but now I see that a lot can be reshuffled into dividends and directors loans

Obviously more to it, but looking at the forms and HMRC websites, its not that hard for a small ltd company.
 
Upvote 0
For double entry get the AAT level 2 books from someone like Osborne.

Whilst they aimed at those training to become an accountant, it’s the first level and the books are easy to follow with questions and answers at the end of each chapter.
 
Upvote 0
I'm being abused £35 a month for my accountancy software.

I know there are cheaper and free solutions out there, but they've either got $hite UI/UX or are just plain $hite, i.e. gnucash - does everything but looks like I'm on Windows 95 again.

I know that all my accountancy software is doing is pulling in my bank feeds (albeit correctly guessing what the transaction was for etc.) and that's it.

  • A few bonuses, lets me file VAT returns with a click of a button, never taken more than 30 seconds.
  • Also lets me file my self-assessment, again no more than 30 seconds to submit after its been checked over by the accountant, who can handily login herself - not possible with a local installation.
  • Also lets me send invoices to clients.

Ping my accountant when annual accounts are due and she logs in, does her thing and files all the good stuff.

I know a lot of the old school love the old local setup - but lets be real you gotta move with the times.

If your business is really scaling you don't want to be titting about doing your own accounts, that's what professional bean counters are for.

There is a point where you can get away with a local spreadsheet but if you're moving up you can't be a tight git forever.
 
Upvote 0
After looking for my passport for the last week, I have to conclude that I have lost it. So that is £76 for a replacement, and I won't be able to open a business bank account without so I'm stuck for a few weeks. I'll have to try and keep the transactions down so that my spreadsheet doesn't get too unmanageable.
 
Upvote 0
I'll have to try and keep the transactions down so that my spreadsheet doesn't get too unmanageable.

This is your problem. You are letting the bookkeeping process constrain the business. Cart driving horse.

It is a prime example of: Give a kid a hammer and everything looks like a nail

I am an IT consultant. I have developed complex spreadsheet solutions to specified problems where my billable time exceeds £20,000. I would never, never never use a spreadsheet for my bookkeeping.

Please get yourself some good bookkeeping software. And do not forget that bookkeeping, although essential, is not the same as accountancy services.
 
  • Like
Reactions: 123 Financials
Upvote 0
This is your problem. You are letting the bookkeeping process constrain the business. Cart driving horse.

It is a prime example of: Give a kid a hammer and everything looks like a nail

I am an IT consultant. I have developed complex spreadsheet solutions to specified problems where my billable time exceeds £20,000. I would never, never never use a spreadsheet for my bookkeeping.

Please get yourself some good bookkeeping software. And do not forget that bookkeeping, although essential, is not the same as accountancy services.

I think you are taking my statement too literally. I don't want to spend much money at the moment because I don't need to. There is plenty of stuff I would like for the company but not a whole lot I need. Accounting and bookkeeping software will be chosen once I have employed the services of an accountant and opened a business bank whilst following their advice. Once that is done I'll import the data from Excel and then the spreadsheet will be deleted and I'll go back to processing data in Excel and using my accounting and bookkeeping for what it was intended for.
 
Upvote 0
Because I'm tight, I'm happy to turn by hand to most things, but I would never try to prepare by own accounts. It simply isn't cost effective.

Not always, my wifes business was paying £1200 a year for her accountancy, plus £45 a month to a bookkeeper, who then forwarded the info to the accountants. That £1200pa was solely to produce end of year accounts a tax return, for a business that only turns over £50k pa and has about 4 suppliers.
I changed her accountant and I do the books through quickbooks online. Costs £11 a month plus £275 pa for the final accounts and tax return. The £1333 pa saving is well worth the 30 mins a month it takes me to do the books ad reconcile the bank acct.

She was paying more a s a sole trader than I was as a ltd co with treble the turnover. And my own accountant was far more proactive and helpful. I am perfectly capable of doing my own accounts through quickbooks, having been a user for 23 years and now only need an accountant to produce the finished accounts in the strange file format that companies house requires. (xlbr?)
 
Upvote 0
I'm in need of a book to help me manually handle the majority of my accounting for a private limited company registered in England. At the moment I just have an Excel spreadsheet but I'm looking at cloud accounting software to be a bit more organised but I have to wait for the company details to be confirmed by Companies House before I can open a business bank account to pay for things.

So a book that explained things to me in a simple and (most importantly) concise manner would be excellent. Happy to hear all suggestions.
Hi Kerwin
I've just read most of the comments on here and note you ended up deciding you might hire an accountant. Did you find a reasonably priced one? Is there anything I can help you with?

Thanks
Sophia
 
Upvote 0

Latest Articles