# Bank Reconciliation

> The periodic proof that the company's cash records match the bank's, catching errors, timing differences, and fraud before they compound.

- Source: https://briq.ai/acu/object/bank-reconciliation
- Department: Cost, Billing & Accounting (https://briq.ai/acu/department/cost)
- Catalog code: CST 206 · Level: Practitioner · Track: Finance · 10 min read
- Also known as: Bank Rec, Cash Reconciliation, Bank Statement Reconciliation

## Definition

A bank reconciliation is the periodic process of comparing the cash balance in a company's own accounting records to the balance reported by the bank, and explaining every difference between them. Its purpose is to prove that the two agree once timing differences and errors are accounted for, so that reported cash can be trusted. A bank reconciliation is not simply checking that the ending balances match — they rarely do at any instant because of outstanding checks, deposits in transit, bank fees, and interest — it is the disciplined identification of each reconciling item until the adjusted book balance equals the adjusted bank balance. In construction, where multiple bank accounts, joint checks, and large intermittent draws and disbursements move cash unpredictably, the reconciliation is a primary fraud-detection and error-catching control, not a clerical formality.

## Why it matters

The bank reconciliation is the proof that reported cash is real. Cash is both the most liquid asset and the one most exposed to theft and error, and the reconciliation is the control that confirms the ledger's cash balance corresponds to money that actually exists at the bank. Financial statements that report a cash figure no one has reconciled are asserting something they cannot support.

It is the earliest catch for both error and fraud. Duplicate payments, altered or forged checks, unauthorized withdrawals, and miskeyed deposits surface as reconciling items that do not resolve, and the sooner the reconciliation runs, the sooner they are caught. A reconciliation performed monthly by someone independent of cash disbursement is one of the most cost-effective internal controls a contractor has.

Timing differences in construction are large and volatile, which makes the reconciliation genuinely informative rather than routine. Outstanding checks to subcontractors, deposits in transit from owner payments, and joint checks create sizable gaps between book and bank at any moment, and understanding those items is part of understanding the company's true cash position. The reconciliation is where the difference between book cash and available cash becomes explicit.

It underpins the reliability of everything downstream that depends on cash. The cash-flow forecast, the working-capital picture on the WIP schedule, and covenant calculations all assume the cash balance is accurate, and an unreconciled account propagates its error into all of them. A stale or skipped reconciliation is a silent corruption of the entire liquidity view.

## Lifecycle

1. **Statement receipt** — The bank statement for the period is obtained, increasingly via direct feed rather than paper or PDF. The reconciliation cannot begin until the source of truth for the bank side is in hand.
2. **Matching cleared items** — Transactions appearing on both the bank statement and the books — cleared checks, settled deposits, electronic payments — are matched and ticked off. Automated matching handles the bulk; the residue is the informative part.
3. **Identifying timing differences** — Items on the books but not yet at the bank (outstanding checks, deposits in transit) and items at the bank but not yet on the books (fees, interest, direct debits) are identified as reconciling items rather than errors.
4. **Investigating unmatched items** — Anything that is neither a match nor an explainable timing difference is investigated — a duplicate payment, an unrecognized withdrawal, a keying error, or potential fraud. This is the control's real work.
5. **Posting adjusting entries** — Legitimate book-side items the company had not yet recorded — bank fees, interest, returned checks, direct debits — are posted as journal entries so the books catch up to reality.
6. **Balancing** — Adjusted book balance is proven equal to adjusted bank balance. If they do not tie, the reconciliation is not complete, and forcing a plug to make it balance defeats the entire purpose.
7. **Review and sign-off** — An independent reviewer approves the completed reconciliation, confirming the reconciler is not also the person who disburses cash. Segregation here is the anti-fraud backbone of the control.
8. **Aging and follow-up** — Long-outstanding checks and stale reconciling items are tracked and cleared — voided and reissued, escheated, or written off — so the reconciliation does not accumulate a growing tail of unexplained items.

## Anatomy

- **Bank statement balance** — The bank's reported ending balance, one anchor of the reconciliation. The external source of truth for cash.
- **Book (ledger) cash balance** — The company's own recorded cash balance, the other anchor. The figure the reconciliation exists to validate.
- **Outstanding checks** — Checks written and recorded but not yet cleared by the bank, a book-side deduction from the bank balance. In construction these can be large subcontractor payments.
- **Deposits in transit** — Deposits recorded on the books but not yet posted by the bank, a book-side addition. Owner payments in the mail or in overnight processing.
- **Bank fees and charges** — Service charges the bank deducted that the books have not yet recorded, requiring an adjusting entry to the books.
- **Interest earned** — Interest the bank credited not yet on the books, another book-side adjusting entry.
- **Returned / NSF items** — Deposited checks the bank reversed for insufficient funds, which reduce cash and often signal a collection problem.
- **Electronic and direct debits** — Automatic withdrawals and card settlements the bank posted that the books may not have captured yet.
- **Unmatched / unexplained items** — Transactions on one side with no counterpart and no timing explanation. The reconciliation's fraud- and error-detection payload.
- **Adjusted balances** — Book and bank balances after all reconciling items, which must be equal for the reconciliation to be complete.
- **Reconciler and reviewer** — Who performed and who independently approved the reconciliation, the segregation-of-duties record that gives the control its integrity.
- **Item aging** — How long each outstanding or unexplained item has persisted, so stale checks and lingering breaks are cleared rather than carried indefinitely.

## Failure modes

- **Reconciliation forced to balance with a plug** — An unexplained difference is written off to a miscellaneous account to make the reconciliation tie, rather than investigated. The plug hides whatever caused the difference — often duplicate payments or fraud — and the control has been defeated while appearing complete.
- **No segregation between reconciler and disburser** — The person who writes checks also performs the reconciliation, so someone diverting cash can conceal it by adjusting their own reconciliation. This is the single most exploited weakness in small-company cash fraud.
- **Stale and skipped reconciliations** — Accounts go unreconciled for months because the close is behind. Errors and fraud compound undetected, and by the time the reconciliation is attempted, the volume of unmatched items is too large to unwind cleanly.
- **Accumulating outstanding-check tail** — Old outstanding checks are never followed up — never cleared, voided, or escheated — so the reconciliation carries a growing list of stale items. The clutter hides genuinely new problems and overstates the true cash the company can spend.
- **Timing differences mistaken for errors, or vice versa** — A legitimate deposit in transit is chased as a missing deposit, or a genuine duplicate payment is dismissed as timing. Misclassifying reconciling items wastes effort on non-problems and lets real ones slip through.
- **Multiple accounts reconciled inconsistently** — A contractor's several operating, payroll, and retention accounts are reconciled on different schedules or with different rigor, so a problem hides in the least-watched account. Consistent treatment across all accounts is what closes the gap.
- **Adjusting entries never posted back to the books** — Fees, interest, and returned items are identified on the reconciliation but the corresponding journal entries are never posted, so the books stay wrong and the same items reappear as differences next period. The reconciliation caught the item but never fixed it.

## Metrics

- **Reconciliation timeliness** — Days from period end to completed, reviewed reconciliation. A reconciliation weeks late means cash has been unverified while decisions were made on it.
- **Unexplained difference at completion** — Any residual gap after reconciling items, which should be zero. A nonzero residual, especially a plug, is a control failure.
- **Aged outstanding items** — Count and value of checks and reconciling items outstanding beyond a threshold. Measures follow-up discipline and true available cash.
- **Segregation-of-duties compliance** — Whether the reconciler is independent of cash disbursement and a separate reviewer signs off. Binary, and foundational to the control's value.
- **Exceptions caught** — Duplicate payments, unauthorized withdrawals, and errors surfaced by the reconciliation. Evidence the control is actually finding things, not just ticking boxes.
- **Auto-match rate** — Share of transactions matched automatically versus manually. High auto-match frees attention for the unmatched residue where problems live.

## The AI shift

- **Conversational** — The reconciliation becomes interrogable rather than a spreadsheet to grind through. You ask which items are truly unexplained versus normal timing differences, which outstanding checks are stale enough to clear, and whether any account is overdue for reconciliation — and get the specific transactions and their ages cited, so attention goes straight to the residue that matters.
- **Generative** — The reconciliation and its adjusting entries are drafted. Given the bank feed and the ledger, a model matches cleared items, classifies the remainder as timing differences or true exceptions, drafts the adjusting journal entries for fees, interest, and returned items, and presents a completed reconciliation with the unexplained residue isolated for human investigation rather than plugged.
- **Orchestrated** — Reconciliation stops being a monthly manual chore. The bank feed is matched continuously against the ledger and the payment and deposit records, adjusting entries flow to the journal, and any unmatched item is triaged against outstanding checks, deposits in transit, and known fees — so a duplicate payment or an unrecognized withdrawal is surfaced within days, not at month-end, with the underlying records attached.
- **Autonomous** — The routine matching runs unattended: cleared items matched, timing differences classified, adjusting entries drafted, and stale outstanding items flagged for clearing — while humans own the investigation of every genuinely unexplained item, the write-off of any difference, and the independent review sign-off, and the system never plugs a difference or clears an item without approval.

## Prompts

### Conversational — A reconciliation will not balance and you need to find why fast.

```text
This bank account will not reconcile. Compare the bank feed to the ledger for the period and classify every difference: match cleared items, identify outstanding checks and deposits in transit as timing differences, and isolate anything that is neither. For the unexplained residue, look for duplicate payments, checks that cleared for a different amount than recorded, unrecognized withdrawals or direct debits, and deposits that never posted. Tell me the exact items making up the difference, their amounts and dates, and for each whether it is a timing difference, a missing adjusting entry, an error, or a possible exception. Do not suggest plugging the difference — name what causes it. Cite the specific transactions on both sides.
```

**Expected output:** An itemized explanation of the difference with each component classified as timing, missing entry, error, or exception, and the specific transactions cited, with no plug proposed.

**Follow-ups:**

- Which of these look like duplicate payments, and to whom?
- Draft the adjusting entries for the legitimate book-side items you found.
- Which outstanding checks are stale enough that we should void and reissue them?

### Generative — Running the monthly reconciliation and drafting the adjusting entries.

```text
Perform this month's bank reconciliation from the bank feed and the ledger attached. Match all cleared items, then build the reconciliation: list outstanding checks and deposits in transit as timing differences, identify bank fees, interest, returned items, and direct debits that the books have not recorded, and isolate any unmatched item with no timing explanation. Draft the adjusting journal entries the books need — fees, interest, NSF reversals — each balanced with the correct accounts, a description, and the reconciliation as its reference. Prove the adjusted book balance against the adjusted bank balance and show the reconciliation in full. Present the unexplained residue separately for investigation rather than forcing a balance, and flag outstanding items aged beyond 90 days for follow-up.
```

**Expected output:** A complete, balanced reconciliation with timing differences listed, adjusting entries drafted, the unexplained residue isolated for investigation, and aged items flagged, rather than a forced tie.

**Follow-ups:**

- Show me the reconciliation summary an independent reviewer would sign.
- Which aged outstanding checks should be voided, reissued, or escheated?
- List the adjusting entries and confirm they post the books to the reconciled balance.

### Orchestrated — You want continuous matching across the bank feed, ledger, and payment records.

```text
Reconcile cash continuously across the connected records rather than waiting for month-end. Match the bank feed against the ledger, the accounts-payable payment records, and the deposit records as transactions clear. Classify each cleared item, mark outstanding checks and deposits in transit, and route recognized fees, interest, and returned items to draft adjusting entries. For any bank transaction with no counterpart in the payment or deposit records, triage it immediately as a possible duplicate payment, an unauthorized withdrawal, or an unrecorded transaction, and surface it with the related records attached. Keep a running reconciliation status per account and report any account whose unexplained residue exceeds the threshold or that is overdue for a full reconciliation. Return the current status, the draft entries, and the triaged exceptions.
```

**Expected output:** A continuously updated reconciliation status per account with cleared items matched, adjusting entries drafted, and unmatched withdrawals and deposits triaged as possible exceptions with their related records, surfaced within days rather than at close.

**Follow-ups:**

- For each unmatched bank withdrawal, tell me if there is any authorizing record.
- Which accounts are trending toward a difficult month-end and why?
- Show me the exceptions you would escalate today versus watch.

### Autonomous — Standing policy for how bank reconciliation should run and stay controlled.

```text
Run bank reconciliation continuously under these rules. Match the bank feed against the ledger and the payment and deposit records as items clear, classify timing differences, and draft the adjusting entries for fees, interest, and returned items. Flag stale outstanding checks and reconciling items for clearing. Maintain a reconciliation status per account and escalate any account overdue for a full reconciliation. Never write off or plug an unexplained difference, never clear or void an outstanding check, never post an adjusting entry above the approval threshold, and never sign off the reconciliation — segregation requires an independent human reviewer — without approval. Route every unexplained item, possible duplicate payment, and unauthorized-withdrawal candidate to me with the supporting records, and give me a per-close exception queue rather than the full matched ledger.
```

**Expected output:** A continuously reconciled set of accounts where routine matching and adjusting-entry drafting are automatic, and every write-off, item clearing, above-threshold entry, and the independent sign-off stay human decisions, with exceptions escalated and no plugs.

**Follow-ups:**

- Show me the exceptions you escalated this month and which turned out to be real.
- Report reconciliation timeliness and the aged-outstanding-item trend across all accounts.

## Maturity ladder

- **Level 0 — Level 0 — Occasional and informal** — Accounts are reconciled sporadically, often by the same person who disburses cash, and differences are plugged. The control provides little real assurance and fraud can hide indefinitely.
- **Level 1 — Level 1 — Monthly and segregated** — Every account is reconciled monthly by someone independent of disbursement, with an independent reviewer signing off. Differences are investigated, not plugged, but matching is manual.
- **Level 2 — Level 2 — Feed-driven and timely** — Bank feeds drive automated matching, reconciliations complete soon after period end, adjusting entries are posted promptly, and aged items are actively cleared.
- **Level 3 — Level 3 — Continuous and assisted** — Matching runs continuously against ledger and payment records, adjusting entries are drafted, and unmatched items are triaged as timing, error, or exception for human review well before close.
- **Level 4 — Level 4 — Operated** — Routine matching, classification, and entry drafting run unattended, while humans own every write-off, item clearing, exception investigation, and the independent sign-off the control depends on.

## FAQ

### Why don't the bank balance and the book balance simply match?

Because the two records capture the same transactions at different moments. Checks the company has written and recorded may not have cleared the bank yet (outstanding checks), deposits the company has recorded may not have posted (deposits in transit), and the bank may have charged fees or credited interest the company has not yet booked. The reconciliation identifies each of these timing differences until the adjusted book balance equals the adjusted bank balance; a permanent, unexplained gap is an error or fraud, not a timing difference.

### Why is segregation of duties so important in bank reconciliation?

Because a person who both disburses cash and reconciles the account can conceal a theft by adjusting their own reconciliation to hide the missing money. Requiring that the reconciler be independent of cash disbursement, and that a separate person review and sign off, removes the ability of any one individual to both take cash and cover it up. It is the single most important control feature of the process, and its absence is the most commonly exploited weakness in small-company cash fraud.

### What should happen to old outstanding checks?

They should be followed up rather than carried indefinitely on the reconciliation. A check outstanding for several months usually means the payee never received or never cashed it, and it should be investigated, then voided and reissued if still owed, or handled under unclaimed-property (escheatment) rules if the payee cannot be located. Letting stale checks accumulate clutters the reconciliation, hides genuinely new items, and overstates the cash the company can actually spend.

### How often should reconciliations be done?

At minimum monthly, when bank statements close, and ideally more frequently for high-volume accounts through continuous feed-based matching. The value of the control decays with delay: errors and fraud compound the longer an account goes unreconciled, and a large backlog of unmatched items becomes progressively harder to unwind. Timely reconciliation of every account — operating, payroll, and retention alike — on a consistent schedule is what keeps cash trustworthy.

## Related objects

- [Journal Entry](https://briq.ai/acu/object/journal-entry)
- [Cash Flow Forecast](https://briq.ai/acu/object/cash-flow-forecast)
- [Three-Way Match](https://briq.ai/acu/object/three-way-match)
- [Accounts Payable Invoice](https://briq.ai/acu/object/ap-invoice)
- [Joint Check](https://briq.ai/acu/object/joint-check)
- [Financial Statements](https://briq.ai/acu/object/financial-statements)