Bank Reconciliation: Complete Guide With Examples

Bank reconciliation is the process of comparing transactions in your company's general ledger cash accounts against the corresponding bank statement to confirm that balances agree and to identify discrepancies that need correction. It is one of the most fundamental internal controls in accounting and the first place auditors look when assessing whether a company's cash balances are reliable.

Why bank reconciliation matters

Unreconciled bank accounts create a cascade of problems. Cash balances on the balance sheet cannot be trusted. Cash flow forecasts are built on unreliable data. Fraud goes undetected longer because unusual transactions are not investigated. And audit preparation becomes a crisis rather than a routine process. A 2023 Association of Certified Fraud Examiners report found that median fraud losses at organizations with no reconciliation controls were 2.5 times higher than at organizations with regular reconciliation procedures.

Beyond fraud prevention, bank reconciliation catches legitimate errors — duplicate vendor payments, bank charges not yet recorded, customer payments applied to the wrong invoice, and timing differences between when your team records a transaction and when the bank processes it. Each of these differences, left unresolved, compounds into a larger problem at year-end.

Step-by-step bank reconciliation process

Step 1: Obtain the bank statement for the reconciliation period. Most accounting software connects to bank feeds that pull statement data automatically. If not, download a PDF or CSV from your online banking portal. Step 2: Compare the bank's ending balance to the ending balance in your general ledger cash account for the same period. These numbers will almost never match initially — the purpose of the reconciliation is to explain and resolve the difference.

Step 3: Identify transactions in the GL that have not yet cleared the bank. These are typically outstanding checks (you mailed a check but the vendor has not cashed it yet) and deposits in transit (you recorded a deposit but it was not credited by the bank before the statement cutoff). Step 4: Identify transactions on the bank statement that have not been recorded in the GL. These typically include bank service fees, interest income, wire transfers, and NSF charges. Record these items in the GL as adjusting entries.

Step 5: Investigate any remaining discrepancies that are not explained by timing differences. These may include errors in either the GL or the bank's records, unauthorized transactions, or duplicate entries. Step 6: Prepare the reconciliation summary showing the adjusted bank balance equals the adjusted GL balance. Step 7: Have the reconciliation reviewed and approved, then file the supporting documentation.

Worked example

Assume the bank statement shows an ending balance of $147,320.00 on January 31. The general ledger cash account shows an ending balance of $143,285.00 on the same date. The difference is $4,035.00. During reconciliation, the team identifies the following items.

Adjusted bank balance: $147,320.00 - $2,150.00 - $1,400.00 + $3,200.00 = $146,970.00. Adjusted GL balance: $143,285.00 - $45.00 + $12.00 + $3,348.00 - $580.00 = $146,020.00. Wait — these do not match. The $950.00 remaining difference requires investigation. The team discovers that check #4510 for $950.00 was recorded twice in the GL. After correcting the duplicate entry, the adjusted GL balance becomes $146,970.00, matching the adjusted bank balance. Reconciliation complete.

Common reconciling items

Outstanding checks are the most frequent reconciling item — they appear in the GL when issued but do not appear on the bank statement until cashed. Deposits in transit are the second most common, occurring when deposits made near the statement cutoff date are recorded in the books but not yet credited by the bank. Bank charges (monthly fees, wire fees, overdraft charges) often appear on the bank statement before the accounting team records them. Interest income follows the same pattern. NSF or returned checks require reversing the original deposit in the GL. And then there are errors — transposition mistakes, duplicate entries, and amounts recorded incorrectly — which is why reconciliation exists in the first place.

Automation with accounting software

Modern accounting software has transformed bank reconciliation from a fully manual process into a largely automated one. QuickBooks Online, Xero, and Sage Intacct connect to bank feeds and auto-match transactions based on date, amount, and payee. The match rate for routine transactions (exact amount, similar date, matching payee name) typically reaches 80 to 90 percent with basic rules. Enterprise tools like BlackLine and Trintech Cadency add configurable matching rules, tolerance thresholds, and multi-currency support to push auto-match rates above 95 percent for high-volume operations.

The automation value is not just time savings — it is consistency and completeness. Manual reconciliation relies on someone carefully comparing every line item, which means human error increases with transaction volume. Automated matching never gets tired, never skips a line, and surfaces only the genuine exceptions that require judgment. For a company processing 500 bank transactions per month, switching from manual to automated reconciliation typically saves 6 to 10 hours per close cycle.

How often to reconcile

Monthly reconciliation is the minimum standard for any business. Companies with high transaction volumes — retail, hospitality, e-commerce — should reconcile weekly or daily to catch issues faster and maintain accurate cash positions. Daily reconciliation sounds onerous, but with automated bank feeds and matching rules, it takes minutes rather than hours. The real cost of infrequent reconciliation is not the time spent reconciling — it is the cost of discovering a $50,000 error in December that originated in March.