Days since the last completed bank reconciliation. The UK Bacs cycle assumes weekly recon; gaps over 7 days compound and inflate close-cycle workload.
At a glance
The number of days since your last completed bank reconciliation in Sage, the point at which the cash book was last tied line-for-line to the actual bank statement. This is the cleanest single measure of whether your reported cash position can still be trusted. The longer the gap, the more unmatched transactions pile up, the more likely an error or a missed payment hides in the float, and the heavier the eventual reconciliation becomes. UK businesses on a weekly Bacs cycle should reconcile at least weekly, so anything past 7 days is a flag and anything past a full month is a control problem. The card reads the Cash Management module’s reconciliation status per bank account, dimension-tagged in Sage Intacct so finance can see which specific account has gone stale and who owns it.
Calculation
Calculated automatically from your Sage data. The card subtracts the statement date of the most recent completed reconciliation from today, per bank account, and surfaces the longest gap. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK B2B stationery brand on Sage Intacct, single entity, GBP base currency, roughly 7M GBP annual revenue, settling supplier Bills via weekly Bacs runs and collecting customer payments by Bacs and card through a BigCommerce B2B portal. Three bank accounts: a main current account, a deposit account, and a EUR account for EU suppliers. Snapshot 14 Apr 26. The card surfaces the worst account.
Five things to notice:
- 73 days on the deposit account is the headline, and it is past the 7-day alert by an order of magnitude. The card surfaces the worst account because a single stale account is enough to mean the consolidated cash position is unverified. The deposit account moves rarely, which is exactly why it gets forgotten, and exactly why a fraud or a bank error there can sit undetected for months. The fix is mechanical (reconcile it) but the value of the card is that it made an invisible gap visible. Nobody chooses to leave an account unreconciled for 73 days; they simply never see the counter.
- The main current account at 5 days is healthy and inside the Bacs cycle. This is the account that matters most operationally because it is where the weekly Bacs runs settle and where customer receipts land. At 5 days it is being reconciled roughly weekly, which is the correct cadence for a Bacs-cycle business. The card confirms the discipline is holding on the account that needs it most, while flagging the neglected ones. That contrast is the useful read: not “are we reconciling” but “are we reconciling everything.”
- The EUR account at 24 days is the quiet risk because of FX. An unreconciled foreign-currency account does not just risk missed transactions, it risks an FX revaluation that has drifted from reality. EU supplier payments settle here, and 24 days of unreconciled activity means the GBP value of the EUR balance on the books may not match what the bank actually holds once revaluation is applied. Pair this card with FX Currency Exposure to see whether a stale foreign account is also carrying material currency risk.
- A long gap directly inflates the period-close workload. Every day unreconciled is more unmatched transactions to clear, and clearing them at month-end under time pressure is how errors get rushed through. Read this card next to Period Close On-Time Rate (12mo): stale reconciliations are one of the most common reasons a close runs late, because the cash position cannot be signed off until the bank ties out. Reconciling weekly is not bureaucracy, it is what keeps the close fast.
- The cross-signal to watch is a stale recon alongside a confident-looking cash number. A business can show a healthy AR Balance and a comfortable cash figure while the bank has not been reconciled in 73 days, which means that comfortable cash figure is unverified. Any AP-stretch or investment decision made on an unreconciled cash position is made partly blind. This is why the card is a Key Metric: it gates the trustworthiness of every cash-based decision. Reconcile first, then decide.
Sibling cards merchants should reference together
Reconciling against Sage
Where to look in Sage: The native Sage Intacct views to run side by side with this card:Cash Management → Reconcile (the bank reconciliation workspace showing last-reconciled date and outstanding items per account) Cash Management → Bank Accounts (the list of accounts with their reconciliation status and most recent statement date) Reports → Cash Management → Bank Reconciliation Report (the formal recon output, including the reconciled balance and the uncleared float) Reports → Cash Management → Outstanding Checks and Deposits (the uncleared items that accumulate while an account goes unreconciled) Interactive Custom Report (ICR) built on the Cash Management data source listing each bank account’s last completed reconciliation date and computing the days elapsedThe reconciliation date on this card is the statement date of the last completed (posted) reconciliation, which is what the Cash Management → Reconcile screen shows as the last-reconciled point. A reconciliation that has been started but not finalised does not reset the date in either place. For Multi-Entity Console accounts, check each entity’s bank accounts, because a consolidated view can hide a single neglected account inside an otherwise tidy group. Common reconciliation pitfalls:
- Started but not posted. A part-done reconciliation sitting in progress does not reset the clock. Finalise it, or the card correctly continues to count from the last completed one.
- Statement date vs reconciliation date. The card uses the statement-period end date, not the date someone clicked reconcile. If you reconcile a March statement in mid-April, the clock resets to the statement end, not to today.
- Auto-matched bank feeds. Where bank feeds auto-match transactions, an account can look “matched” without a formal reconciliation being completed. Matching is not reconciling; only a completed reconciliation resets this card.
Cross-connector reconciliation:
The cross-platform point is that no commerce platform can tell you whether your bank is reconciled, because none of them touch your bank statement. Sage Intacct’s Cash Management module is the only system that ties recorded cash to actual bank cash, and this card turns that buried status into a live counter. The dimensional carry-through means a stale account points at the specific entity and owner responsible, so the gap closes with a named action rather than a general reminder.