Reconciliation
Reconciliation · 2026-09-24 · 11 min read
Opening Balance Doesn't Match Bank Statement? Fix It
Why your opening balance doesn't match the bank statement in QuickBooks, Xero or a spreadsheet, how to find the cause, and how to fix it safely.
Reconciliation · 2026-09-23 · 11 min read
Outstanding Checks and Deposits in Transit Explained
What outstanding checks and deposits in transit are, how they affect a bank reconciliation, worked examples, and what to do with stale items.
Reconciliation · 2026-09-21 · 11 min read
How to Reconcile a Bank Statement in Google Sheets
Reconcile a bank statement in Google Sheets step by step: import transactions, match them with formulas, list outstanding items and prove the balance.
Reconciliation · 2026-09-16 · 11 min read
Bank Reconciliation Template in Excel: Build Your Own
Build a reusable bank reconciliation template in Excel: sheet layout, matching formulas, outstanding items, a summary that proves zero, and monthly reuse.
Reconciliation · 2026-09-15 · 11 min read
Month-End Close Checklist for Small Businesses
A practical month-end close checklist for small businesses: bank and card reconciliation, receivables, payables, payroll, review and sign-off.
Reconciliation · 2026-09-10 · 11 min read
How to Find Bank Reconciliation Discrepancies Fast
A systematic way to find why a bank reconciliation won't balance: the divide-by-two and divide-by-nine tricks, timing items, duplicates and Excel checks.
Reconciliation · 2026-09-07 · 11 min read
Credit Card Reconciliation in Excel (With Template)
Reconcile credit card statements against your books or receipts in Excel: setup, matching formulas, timing differences, and a reusable template layout.