A cash dashboard is useful only if its numbers can support the next decision. Before approving a purchase or a new hire, check that the starting balance is supported, transactions are complete, internal transfers are treated consistently, and expected payments have not already happened.
These checks need not turn a weekly cash review into an audit. Their purpose is to catch a small number of mistakes that can make available cash look safer than it is.
A number can add up and still be wrong
Imagine opening a forecast that shows enough cash for the next payroll. Every total calculates correctly. But the latest bank export ends three days ago, and a large supplier payment cleared yesterday.
The arithmetic is right. The decision is based on an incomplete picture.
Reliability has several parts: the amounts must be correct, the records must be complete, and the dates must mean what the reader thinks they mean. A dashboard also needs to make its coverage visible. “Updated today” says little if one account still contains last month's data.
ICAEW's spreadsheet principles recommend clear separation of inputs and outputs, controls, and review. The five checks below apply that discipline to a small business's cash decisions, whether the working view lives in a spreadsheet or an application.
1. Can you explain the starting balance?
Write down the accounts included, the balance date, and any adjustments between bank cash and cash available for operations. Keep facilities and restricted funds identifiable. Combine currencies only after applying a documented conversion basis.
For each account, compare the recorded opening balance plus receipts minus payments with the bank's closing balance for the same period. Investigate a difference before relying on the combined number.
Take care with uncleared payments: an adjustment already included in your starting position should not be subtracted again in the forecast. Record how you treated it so another person can reproduce the result.
The useful output is a short explanation: “These three accounts are reconciled through Friday; this amount is unavailable; these two items still need review.”
2. Did everything arrive, exactly once?
Check the date range and account on each import. Look for gaps between exports, overlapping periods, missing pages in statements, and transactions entered manually before the same activity was imported.
Compare receipt totals and payment totals separately with the source. A matching net movement is not enough: a missing receipt and a missing payment of equal size cancel each other out.
Keep the original export intact. If you transform descriptions or categories, do that in a working copy or review layer. That preserves a reference when a total changes unexpectedly.
A small control table can make the next review faster:
| Check | Evidence to retain | What needs attention |
|---|---|---|
| Account coverage | Accounts and dates included | Missing or stale account |
| Completeness | Source receipt and payment totals | Difference in either total |
| Duplicates | Source reference and transaction details | Overlapping imports or repeated entry |
| Review status | Unresolved items and reviewer | Pending data used as final data |
Two equal payments are not automatically duplicates. Confirm against the source before removing either one.
3. Are transfers inflating business activity?
A transfer between two accounts owned by the same business changes where cash sits. It does not, by itself, create a customer receipt or an operating expense.
Keep both account records so each balance remains explainable, but exclude the internal movement from consolidated operating receipts and payments. Otherwise, a transfer can make sales collections and spending look larger even when combined closing cash is unchanged.
Transfers involving an owner, another entity, bank fees, or currency conversion need separate consideration. Do not classify every unfamiliar bank movement as an internal transfer merely to make totals agree.
4. Are any transactions missing from the categories?
A dashboard may show the right bank balance while its spending analysis omits an unmapped vendor. Keep uncategorized amounts visible and reconcile the sum of categories with the relevant transaction total.
If you maintain a mapping table, record changes there rather than repeatedly editing each source export. Review newly appearing accounts or vendors when refreshing the report.
“Other” should remain a visible category with an owner for review. It should not become a place where material costs disappear from management attention.
5. Has expected cash already become actual cash?
Suppose an invoice appears in both the expected-collections list and the bank receipts. Leaving it in both places can count the cash twice: once in today's balance and again next week.
Match material receipts and payments to their expected items. Mark fully paid items appropriately and retain only the remaining amount for partial settlements. Follow the tool's settlement process carefully; some actions create a transaction, so using them after separately entering the same bank movement can introduce a duplicate.
This is the connection between receivables planning, payables planning, and the cash forecast.
Worked example: the buffer that was smaller than it looked
The following independent example uses a fictional business, Cedar Lane Services. Amounts are illustrative dollars in one currency.
Cedar Lane's draft forecast shows a lowest balance of $48,000. Management uses $40,000 as its minimum planning threshold.
| Review finding | Effect on projected lowest cash |
|---|---|
| Draft forecast | $48,000 |
| Remove a $7,000 future receipt already included in opening cash | −$7,000 |
| Include a $6,000 bank payment omitted from opening cash and all forecast periods | −$6,000 |
| Corrected lowest balance | $35,000 |
For simplicity, neither correction changes the week of the lowest balance. The apparent $8,000 cushion becomes a $5,000 gap. A separate transfer-classification correction changes the operating totals but has no effect on combined cash.
Management now has a reason to revisit a proposed purchase and confirm a customer payment. A more polished chart would not have uncovered the problem; the source checks did.
Make the review repeatable
Keep one exception list with the amount, issue, next action, and owner. Set a materiality threshold appropriate to the business, while always investigating issues that suggest fraud or a wider data problem. Resolve significant uncertainties before using the forecast to make commitments.
In CashCatalyst, start with the statement review queue and the source account on each transaction. Confirm the data that should reach the ledger, then check outstanding expected items. The product guide explains those steps; the methodology explains what the forecast uses.
This week, choose one account and trace it all the way from its bank statement to the dashboard. Record any missing, duplicated, or unexplained item. Once that path is clear, repeat it for the remaining accounts and bring the exceptions to your weekly cash review.
Frequently asked questions
Does a matching closing balance prove the dashboard is correct?
No. Offsetting errors can leave closing cash unchanged while distorting receipts, spending, or categories. Check gross inflows and outflows as well as the balance.
Must every small categorization issue stop the meeting?
Usually not. Show the unresolved amount and assess whether it could change the decision. An unexplained opening balance or a large missing payment deserves a different response from a small expense assigned to the wrong category.
Sources and editorial note
The control principles draw on ICAEW's Twenty Principles for Good Spreadsheet Practice. The checklist and Cedar Lane example are original CashCatalyst editorial illustrations. This article covers operating cash review, not an audit or formal accounting reconciliation standard.