Bank Reconciliation Guide 2026: How to Reconcile Cash in 20 Minutes Without Errors
Why Cash Comes First
If cash is wrong, every flux, covenant, and tax return inherits the error.
Use this with Month-End Close, Bookkeeping Software, and QuickBooks vs Xero.
20-Minute Workflow
- Pull statement; confirm feed completeness.
- Match automatically; manually match only with support.
- Clear outstanding >30 days — follow up, do not auto-write-off.
- Post fees/interest to correct accounts with support.
- Reconcile payroll clearing to Payroll Guide.
- Attach statement + rec + discrepancy log; sign and date.
- Reviewer signs; lock period.
Document per Audit Procedures: who, when, support, conclusion.
Error Fixes
| Symptom | Fix |
|---|---|
| Duplicate feed | Break link, delete duplicate, re-match with support |
| Wrong account | Journal with reason, re-rec both accounts |
| Stale outstanding | Investigate, reissue or accrue, never plug |
| FX break | Revalue at close rate, tie to FX Hedging memo |
Link patterns to Fraud Prevention and Occupational Red Flags.
KPIs
- Days to rec (target WD-1)
- Outstanding >30 days (target zero)
- Post-close adjustments (target declining)
Report to Audit Committee quarterly.
Worked Example: The $18,400 Duplicate That Rec Discipline Catches
March: vendor paid $18,400 by ACH; AP clerk re-enters the invoice (different invoice number typo) and pays again by check. April bank rec shows an uncleared $18,400 check aging past 30 days with no support. Investigation (same vendor, same amount, 6 days apart) → duplicate → stop-payment + recovery. Without monthly rec discipline, this surfaces at year-end as a stale outstanding, written off or — worse — re-paid a third time. The control is boring and total: every outstanding item over 30 days gets a named owner and a date, reviewed by someone who didn’t post it.
Multi-Account and FX Operations
| Situation | Practice |
|---|---|
| 5+ operating accounts | One rec per account, one reviewer summary page with all balances tied to GL cash |
| Payroll clearing | Must zero monthly; non-zero means unposted payroll or duplicate — see Payroll Year-End |
| Intercompany cash | Confirm both sides same day; breaks investigated, not netted — see Related Party |
| FX accounts | Revalue at close rate, book gain/loss with memo tying to FX Hedging policy |
| Merchant/processor clearing (Stripe, etc.) | Reconcile payouts to sales reports gross-to-net (fees separated), not net-to-net |
Stripe-style netting is the modern outstanding-item swamp: gross sales, fees, refunds, and reserves all collapse into one payout. Reconcile the payout report line-by-line monthly; auditors sample these accounts precisely because companies don’t.
Fraud Patterns the Rec Exposes
- Round-dollar outstanding checks to unfamiliar payees, never clearing — shell-vendor candidates. Cross-check against Occupational Red Flags.
- Voided checks that cleared — segregation failure; voids require independent approval and bank confirmation — see AP Fraud.
- Deposits in transit that never land — classic lapping indicator; trace to validated deposit slips immediately.
- Recurring “bank error” adjustments without bank letters — demand the letter; banks document their errors.
Escalate via Whistleblower channels when patterns involve personnel, and report themes to the Audit Committee.
FAQ
Can software auto-reconcile everything?
No. Automation proposes; humans evidence exceptions. Unreviewed auto-matches fail audits.
What support is required?
Statement, rec report, outstanding support, fee support, preparer/reviewer sign with dates.
Next Steps
- Reconcile all cash by WD-1 this month.
- Age and clear outstanding weekly.
- File signed recs in close binder with audit-log export.