Seven checks to run on your books before the board pack
On this page
- Why the checks come before the analysis
- 1. Duplicate payments and invoices
- 2. Department and cost centre drift
- 3. Unusual activity
- 4. Ledger integrity
- 5. Manual journals worth a second look
- 6. New suppliers and customers
- 7. Checks for your accounting system
- Rank what you find
- How Stratavor runs the seven checks
- Frequently asked questions
The short answer. Most figures that go wrong in a board pack were wrong in the books first, and most of those errors are one of seven kinds: duplicate invoices, department drift, unusual activity, mapping errors, journals at the close, new suppliers set up in a hurry, and gaps in what the accounting system sent. Each can be checked before a figure is used, and each check comes down to one question. Stratavor's Data Health Check runs all seven on your books, read-only, before any figure reaches a report.
One supplier invoice entered twice is a small error. It becomes a large one when it has already reached the board pack, been read as overspend and been explained in a meeting. The seven checks below catch that kind of error while it is still a line in the ledger.
They are the checks Stratavor's Data Health Check runs, and each can also be run by hand in Xero, QuickBooks Online, Sage or NetSuite. The point of each is the question it asks.
Why the checks come before the analysis
Analysis multiplies whatever it is given. A duplicated invoice raises costs, then lowers margin, then widens the variance against budget, then fills a paragraph of commentary explaining a variance that never happened. Checking the books first is cheaper than correcting the pack later, and it changes the meeting: the board discusses the business, not the numbers.
1. Duplicate payments and invoices
The question: could this supplier invoice have been entered twice?
Look for invoices from the same supplier for the same amount within a few weeks of each other, and for references that differ by one transposed digit or a suffix, such as SI-4471 and SI-4417. In Company A's books, two invoices from one supplier for €6,930 sat nine days apart. Compare both with the supplier's statement before either is paid.
2. Department and cost centre drift
The question: did this spend lose the department tag it normally carries?
Departmental reporting is only as good as the tagging. When a recurring cost arrives without its usual tracking category in Xero, or class in QuickBooks Online, the department looks cheaper than it is and an unallocated line grows quietly. Compare this month's untagged lines with the same suppliers' history.
3. Unusual activity
The question: is this customer or supplier movement expected this month?
Balances, movements and volumes that sit well outside a counterparty's own history deserve a sentence of explanation before they appear in a pack. Some are good news, such as a large order. Some are early warnings, such as a customer that has ordered less for three months running.
4. Ledger integrity
The question: is this account still mapped to the right reporting line?
Charts of accounts change. A new account set up under the wrong heading, or an account moved between cost of sales and overheads, changes the margin without a single transaction being wrong. Check every account created or remapped this month against the line it reports to.
5. Manual journals worth a second look
The question: was this journal reviewed by someone other than the person who posted it?
Journals posted on the last day of the period, journals reversed soon after, and journals that bypass control accounts are where judgement enters the numbers. Most are legitimate. All of them deserve a second pair of eyes, and a journal reviewed by someone other than its author is the control auditors look for first.
6. New suppliers and customers
The question: is this new supplier expected and set up correctly?
New counterparties change the shape of the numbers and carry risks of their own: a supplier set up in a hurry, or an existing supplier whose bank details changed. Review every supplier and customer created in the month, with who created it and why.
7. Checks for your accounting system
The question: did your system send everything this report needs?
Every system fails in its own ways. A bank feed can import the same transaction twice, tracking can be missing from part of a period, and a sync can stop partway. Before a figure is used, confirm the period is complete in the system the report reads from.
Rank what you find
Seven checks on a month of books will usually find something. What matters is the order. A finding that changes a reported figure, such as a mapping error, comes before one that needs a question asking, such as a journal at the close. Sort findings into those that need action before the pack goes out and those to review, and clear the first group first.
| Finding | Check | Status |
|---|---|---|
| An account moved to a different reporting line in October | Ledger integrity | Needs action |
| Two invoices from one supplier for €6,930, nine days apart | Duplicate payments and invoices | To review |
| A manual journal for €48,500, posted at 23:42 on 31 October | Manual journals | To review |
| Customer 12 has ordered less for the third month running | Unusual activity | To review |
The findings are illustrative, for Company A, a fictional company.
How Stratavor runs the seven checks
Stratavor's Data Health Check runs all seven on your books, read-only, before the figures are used in a report. Each finding says what it found, shows the evidence and says what to check. Findings are ranked, scans can run on a schedule, and you can choose to be emailed when a scan finds something serious, with a summary every Monday.
The Data Health Check is on every plan. Essentials shows the three findings that matter most; Growth and Enterprise show every finding. Start a 7-day free trial, with no card needed.
Frequently asked questions
How often should these checks run?
Before every set of figures is used. For most businesses that means at each month-end close, and again before the board pack goes out if the books have changed since.
Can I run them by hand?
Yes. Each check above says what to look for in Xero, QuickBooks Online, Sage or NetSuite. Running all seven by hand every month takes time, which is why most teams run two or three and hope.
I inherited a messy Xero file and I'm about to do an audit: where do I start?
With the seven checks above, before anything else: duplicate invoices, department drift, unusual activity, mapping errors, journals at the close, new suppliers set up in a hurry and gaps in what Xero sent. Correct what each one finds in Xero before the auditors arrive, and keep a note of every correction for them. Stratavor's Data Health Check runs all seven on a Xero file, read-only, and ranks what it finds; it changes nothing in your books.
Will the checks change anything in my books?
No. Stratavor reads your books read-only. It flags each finding and says what to check; any correction is made by your team in your accounting system.
Which Stratavor plans include the Data Health Check?
Every plan. Essentials shows the three findings that matter most; Growth and Enterprise show every finding.
The Stratavor digest
One email a month. Worth opening.
Decoded films on real companies' results, short films on how businesses make and lose money, and guides on customers, competitors, risk, cash and the board pack. No sales emails.
By subscribing you agree to receive the monthly Stratavor digest. Unsubscribe at any time from any email. Privacy policy.