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.
| What it counts | The elapsed days between today and the statement date of the most recently completed bank reconciliation for the account, read from the Cash Management module’s reconciliation records. |
| Per account | Tracked per bank account. A business with current, deposit, and foreign-currency accounts gets a reading for each; the card surfaces the worst (most stale) by default and lets finance drill to the specific account. |
| Completed vs in-progress | Only a completed (posted) reconciliation resets the clock. A reconciliation started but not finalised does not count, because an unfinished recon does not give you a trustworthy cash position. |
| Bank feeds | Where Intacct bank feeds or imported statements are connected, the card can distinguish “statement available but not reconciled” from “no statement yet,” which separates a process lag from a banking lag. |
| Currency | Each account is read in its own currency; the days count is currency-independent. Multi-Entity Console surfaces the staleness per entity. |
| Entity scope | Card respects the dashboard entity filter. |
| Dimensional cut | The reconciliation record carries the bank account and entity through, so finance can pivot by Entity or Location to see which site’s cash book is behind. |
| Time window | RT |
| Alert trigger | >7d aligned to the Bacs cycle, sentiment bank_recon. Configurable per workspace. Monthly-recon businesses may set 35 days; high-volume operations may want 3. |
| Roles | owner, finance |
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.| Bank account | Last completed recon (statement date) | Days since |
|---|---|---|
| Main current account | 09 Apr 26 | 5 |
| EUR supplier account | 21 Mar 26 | 24 |
| Deposit account | 31 Jan 26 | 73 |
| Days Since Last Bank Reconciliation (this card) | 31 Jan 26 | 73 |
- 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 Hero: it gates the trustworthiness of every cash-based decision. Reconcile first, then decide.
Sibling cards merchants should reference together
| Card | Why pair it with Days Since Last Bank Reconciliation |
|---|---|
| Cash Collected | Reconciliation is what confirms the cash you think you collected actually landed. |
| Cash Application Rate | Unapplied receipts often surface during reconciliation; the two cards diagnose each other. |
| AP Aging 60+ Days | An unreconciled bank means you may not know your true cash before deciding which suppliers to pay. |
| Period Close On-Time Rate (12mo) | Stale reconciliations are a leading cause of a late close. |
| Period Close Status | The close cannot finalise until cash ties out; this card is an upstream gate. |
| FX Currency Exposure | A stale foreign-currency account compounds reconciliation risk with FX risk. |
| Sage Health Score | Reconciliation freshness is a control-hygiene input to the composite. |
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.
| Reason | Direction | Why |
|---|---|---|
| Statement date vs action date | Either | Card counts from the statement-period end; a staff member may have reconciled it on a later calendar date. |
| In-progress reconciliations | Card may read higher | A part-done recon does not reset the clock until it is posted. |
| Auto-match vs reconcile | Card may read higher | Bank-feed auto-matching looks like progress but is not a completed reconciliation. |
| Per-account vs consolidated | Either | Card surfaces the worst account; a consolidated dashboard tile may show an average or only the main account. |
| Dormant accounts | Card may read very high | A rarely-used deposit or escrow account can show a huge gap that is low-risk; finance may choose to exclude it. |
| New accounts | Card may read undefined | An account with no completed reconciliation yet has no baseline date; the card flags it as never reconciled. |
| Multi-entity timing | Either | Entities on different close calendars reconcile on different cadences; the consolidated worst-case can look alarming. |
| Card | Expected relationship | What the comparison reveals |
|---|---|---|
| Cash Collected | Verification | Collections you recorded should match deposits the bank shows. Reconciliation is where any discrepancy surfaces. |
| Sage Cash Applied Today | Daily loop | A high daily application rate with a stale reconciliation means cash is being applied to Invoices faster than it is being verified against the bank. |
| AP Aging 60+ Days | Decision gate | Deciding which late suppliers to pay on an unreconciled cash position is a blind decision. Reconcile first. |
| Period Close Status | Dependency | The close depends on cash tying out. A stale reconciliation blocks a clean close. |
| Sage Health Score | Component | Reconciliation freshness feeds the control-hygiene component of the composite. |