Skip to content

Your copy of the accounts can lie: why an internal audit is not enough

A copy of your accounts can be internally perfect and still be out of date. So check the consistency within the copy and also compare the figures directly with the source accounts.

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

  1. 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.
  2. Fetch changes and deletions, not just new entries.
  3. 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.
  4. 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

Services

What is full stack?

Full stack means every layer of an application, from the screen to the database and the server. A full-stack developer or team works across those layers.

Services

Who holds up a mirror to your CIO?

CIOs and IT managers divide their time between budgets, suppliers, projects and people. A sparring partner with current technical knowledge makes their decisions stronger, and gives the board confidence.

Services

What is the Definition of Done?

The Definition of Done records in advance when something is really finished. That way everyone knows in advance what the delivered work will be checked against.