How to Reconcile Bank Statements: Step-by-Step Guide for Bookkeepers

What reconciliation actually catches

Reconciliation finds the gap between what your accounting records show and what your bank actually holds. That gap can exist for legitimate reasons (outstanding checks, deposits in transit) or for serious ones (data entry errors, duplicate entries, fraud).

Fraud detection is the most underappreciated reason to reconcile regularly. In smaller businesses, the most common type is small, repeated unauthorized transactions: slightly inflated expense reimbursements, duplicate vendor payments routed to different accounts, withdrawals below any scrutiny threshold. Monthly reconciliation catches these before they compound. Quarterly reconciliation gives a fraudster three months of runway.

What you need before you start

• The bank statement for the period (PDF is fine, but a downloaded CSV is easier to work with)
• Your accounting ledger or QuickBooks/Xero register for the same period
• The reconciliation report from the previous period showing the closing balance

The previous closing balance is your opening balance for this reconciliation. If it does not match your bank's opening balance for the same period, you have a problem from last month to resolve before doing anything else.

Make sure you have a complete statement. Missing pages are a common source of unexplained gaps that look like errors but are just missing data.

The step-by-step reconciliation process

1. Confirm the opening balance matches between your books and the bank statement.
2. Go through the bank statement chronologically and tick off each transaction against your accounting records.
3. Keep two lists: transactions on the bank statement with no match in your books (bank-only items), and transactions in your books with no match on the statement (book-only items).
4. Bank-only items usually include bank fees, interest charges, and direct debits you forgot to record.
5. Book-only items are usually outstanding checks or deposits in transit.
6. Calculate adjusted book balance: book balance plus unrecorded bank items, minus book-only items.
7. Calculate adjusted bank balance: bank balance plus deposits in transit, minus outstanding checks.
8. If both adjusted balances match, you are done.

When the numbers do not match

Check your arithmetic first. A discrepancy of exactly $100, $1,000, or any round number is often a transposition error (writing 382 instead of 328, for example). Check your opening balance next. A discrepancy that matches last month's closing balance means last month's reconciliation was wrong.

If the discrepancy is a specific amount, search your accounting records for a transaction of exactly that amount in the reconciliation period. A missing or duplicated transaction of that amount is the culprit more often than not. If you cannot find it, search for half the discrepancy. Duplicate entries create twice the error amount.

The most common reconciliation mistakes

The most common mistake is not reconciling every account. It is easy to focus on the main operating account and treat the savings account, credit card account, or petty cash account as less important. Every account holding business funds should be reconciled monthly.

The second most common error is using the wrong end date. If your bank statement runs from March 1 to 31, your reconciliation should cover exactly that period. Partial-period reconciliations create phantom discrepancies that are extremely difficult to resolve.

How to reconcile in QuickBooks Online

1. Go to Accounting, then Reconcile.
2. Select the account and enter the statement ending date.
3. Enter the ending balance from your bank statement.
4. Click to mark each transaction as cleared as you match it against the bank statement.
5. The Difference box at the top must reach $0.00 before you can finish.

QuickBooks shows which transactions were cleared in previous reconciliations, which helps distinguish genuine discrepancies from timing differences. If you need to add a missing transaction mid-reconciliation, you can create it without leaving the reconciliation screen.

Where automation genuinely helps

Bank feeds and automated matching in QuickBooks and Xero handle routine matching faster than manual work. Regular direct debits, payroll, and standing orders match automatically. Where automation helps most is not the matching itself but getting transaction data into your accounting system in the first place.

If you are still manually entering bank transactions because your client only sends PDF statements, that is the bottleneck to fix first. Converting PDFs to importable formats eliminates that constraint and lets you focus on actual reconciliation rather than data entry. For automating the full reconciliation workflow, see our bank reconciliation automation guide.

FAQ

How often should you reconcile?

Monthly is the professional standard and the minimum for any business that wants meaningful financial reporting. High-transaction businesses benefit from weekly reconciliation. Daily reconciliation using bank feeds is practical if your accounting software pulls live transaction data.

How long should reconciliation take?

For a well-maintained set of books with automated bank feeds, 15 to 30 minutes per account per month is typical. If you are doing it manually from PDF statements without automation, expect 45 to 90 minutes depending on transaction volume.

What if I find a transaction I cannot explain?

Do not post it to a suspense account and move on. Investigate it. Call the bank if needed. Unexplained transactions are either errors or fraud, and either way they need resolution before the books are closed.

Can I reconcile if I do not have the paper bank statement?

Yes. Most banks let you download statements online for at least 12 months. A PDF or CSV download works just as well as a paper statement. If you need statements older than your bank's online window, contact the bank directly. Most will provide historical statements for a small fee.