Gather Your Bank Statement & Matching Cash Book Export
Pull the official bank statement (PDF, CSV, or XLSX) and your business ledger / cash book export for the exact same period and currency. Verify both files show opening and closing balances.
Whether you reconcile in QuickBooks, Xero, Excel, or directly from statement files, reliable tie-outs follow the same disciplined seven-step sequence. Use this workflow and variance troubleshooting guide to reach $0.00 variance every close.
Matches lines within ±0–31 days, checks running balances & exports clean XLSX/CSV reports
The 7 bank reconciliation steps are: (1) gather matching statement and ledger exports, (2) prove opening balances, (3) match deposits and isolate deposits in transit, (4) match payments and list outstanding cheques, (5) record bank-only fees, interest, and NSF returns, (6) hunt down transposition or duplicate errors, and (7) verify $0.00 variance and archive the workpaper.
Pull the official bank statement (PDF, CSV, or XLSX) and your business ledger / cash book export for the exact same period and currency. Verify both files show opening and closing balances.
Confirm this period's opening bank and ledger balances equal last period's ending reconciled figures. Also check Opening + Net Flow = Closing on the bank statement itself so missing OCR or CSV lines are caught early.
Compare deposits on the bank statement (credits on the bank statement) against receipts recorded in your cash book (debits in accounting). Receipts booked near cutoff that have not hit the bank yet become Deposits in Transit.
Match cleared checks, ACH debits, SEPA transfers, and card payments against ledger disbursements. Payments recorded in your books that have not cleared the bank become Outstanding Cheques / Uncleared Outflows.
Identify transactions appearing only on the bank statement—such as wire fees, monthly maintenance charges, interest earned, or NSF returned checks—and pass adjusting journal entries in your books.
If Adjusted Bank still does not equal Adjusted Book, check for transposed digits, duplicate imports, payments posted in the wrong period, or a withdrawal entered as a deposit (Dr/Cr inversion).
Once Adjusted Bank Balance equals Adjusted Book Balance, export the completed reconciliation report (XLSX or CSV), attach supporting statements, lock the closed accounting period, and record sign-off.
If you finish Steps 1–5 and still have a lingering discrepancy, the size of the difference gives away the exact root cause:
| Mathematical Clue | Most Likely Cause | How to Fix It Fast |
|---|---|---|
| Difference is evenly divisible by 2 | Sign reversal / flipped Dr/Cr (e.g., recording a $350 withdrawal as a $350 deposit causes a $700 gap) | Divide the difference by 2 and search for that exact dollar amount posted backward |
| Difference is evenly divisible by 9 | Transposition error ($540 vs. $450 = $90) or slide error ($1,200 vs. $120 = $1,080) | Scan entries from the period for swapped adjacent digits or missing trailing zeros |
| Difference equals an exact transaction | Omitted line, duplicate import, or a deposit/payment posted to the wrong bank account | Search both records for the exact gap figure; review Unmatched Bank & Unmatched Ledger |
| Difference existed on Day 1 | Prior period opening balance mismatch or someone edited an already-reconciled transaction | Compare opening balances against last month's archived workpaper before checking new lines |
Cloud accounting tools like QuickBooks Online, Xero, and FreshBooks streamline Steps 3 and 4 via daily bank feeds—matching left-hand bank feed lines against right-hand invoices and bills. However, live feeds frequently stall when banks rotate multi-factor tokens, when teams need to catch up 6–12 months of historical PDFs, or when reconciling an exported spreadsheet outside an ERP.
Document-first software like reconcilebankstatement executes those same deterministic steps directly from your exported files—supporting encrypted PDFs (unlocked strictly in memory), scanned statement OCR, multi-language European/UK/US headers, and running balance verification without needing your online banking password.
Start by verifying both opening balances, then match cleared transactions. After listing deposits in transit and outstanding cheques on the bank side, post adjusting journal entries for bank-only charges, interest, NSF returns, and errors on the book side until both adjusted totals match.
If a $100 payment (outflow) is accidentally entered as a $100 receipt (inflow), your book balance is $100 too high instead of $100 lower—creating a net swing of $200 (2 × $100). Any variance divisible by 2 is a classic clue to check for sign flips.
reconcilebankstatement supports digital or scanned PDFs (up to 200 pages), JPG/PNG/WEBP/TIFF images, CSV, TSV, TXT, and XLSX/XLSM files up to 100 MB per file.
Follow these exact 7 steps on a complete worked dataset with adjusting entries.
See how reconcilebankstatement automates date windows, memo scoring, and balance proofs.
Learn how to handle bounced customer deposits discovered in Step 5.
Upload your statement and ledger files to reconcilebankstatement, configure your ±0–31 day date tolerance, isolate exceptions in seconds, and export XLSX or CSV workpapers.