When preparing to close last year’s books it’s important to check the data is correct because it’s not always easy (and certainly not advisable) to edit the books in a closed period and you should definitely avoid editing data that has been submitted to the tax man.
You, or your bookkeeper, should check and confirm the accuracy of all the data you will be submitting to your accountant for your year end reports. Try to correct every error you find if you know how to do this and don’t worry if you have a few things you don’t know how to correct, most accountants will appreciate you stating upfront, “I’ve found this error but don’t know how to sort it. Can you please help me?” It’s better to point out unresolved errors than to leave them to hurt you later.
How can these errors be found? Well, it depends a lot on how you are recording your data. If you are using a spreadsheet most data entry errors can be found using filters and pivot tables. If you are using cloud software there will be a variety of methods, specific to your program, for finding these mistakes.
The first place I always look is the year-end reports as most accounting software allows you to dig into the data from the reports. There is also usually an easy-to-use transaction search function that will allow you to confirm, for example, all of the Electricity invoices have been coded to Electricity and not Gas and you have all 12 invoices recorded.
Once you have checked all the recorded transactions are correct, it’s important to look for any transactions that may have been missed, duplicated or added in error. This is where good paper records/ online filing comes into its own and where some accounting packages trump others. Your bookkeeper will need to check every document you have against the bookkeeping program, simultaneously confirming your filing and bookkeeping records are complete and accurate while removing any documents and transactions that have been recorded twice, correcting bank reconciliations at the same time.
Yes, you probably perform many of these checks monthly when you reconcile the bank, but it’s advisable to come back later and confirm nothing is missing from the records. After all, have you never started to reconcile the bank and found a direct debit payment you didn’t have the invoice for yet or received and invoice which you have put into the online system only to enter the payment separately weeks later when reconciling the account? This is the sort of thing that’s easy to miss on a monthly basis and why it’s important to check again.
Larger businesses will prefer to perform this sort of deep-data check on a quarterly basis as well as annually, while non-micro charities may schedule the data deep-clean to coincide with trustee meeting report generation.
This may sound like a lot of work, but it’s worth it. Some businesses have discovered errors that could have cost them thousands of pounds if they had not checked their records carefully enough.
If you want help checking your records, please use the “Contact Us” button below.