In short
Many companies work with a copy of their accounts: in a reporting tool, a spreadsheet or their own application. An internal check (does the balance sheet balance, do the balances match the entries) then only tells you that the copy is consistent in itself. Not that it still matches the real books.
What can go wrong
- Outdated data. The copy has not been updated for a while. Everything is internally consistent, but the figures are from last month.
- Ghost entries. The bookkeeper has deleted or corrected an entry, but the copy only fetched new entries. The old one stays.
- Hidden plans. Someone has put an expected entry into the figures in advance as an adjustment. As soon as the bookkeeper actually books it, it counts twice.
In one of our own applications the internal check reported zero errors, while many accounts differed from the books held by the bookkeeper.
How to get it right
- Two kinds of check. An internal audit and a live comparison with the source, using calculations that do not rely on the application's own logic.
- Fetch changes and deletions, not just new entries.
- Keep facts and plans apart. What has been booked, what is planned and what is a scenario sit visibly side by side, never mixed up.
- Check first, then conclude. No tax or financial conclusion without fresh, verified figures.
What to watch out for
Automate the checks so they run every day. An error you see today costs less than one the accountant finds a year from now.
Would you like advice on auditing your accounts? Request a free advice conversation.
Updated on