It is the last day of the month. A client sends you 12 PDF bank statements and asks for clean books by Friday. Before you can reconcile a single account, you have to turn those PDFs into usable data — and that is where most of the time, and most of the errors, come from.
Bank statement reconciliation does not have to be slow or stressful. This guide walks you through the whole process step by step, with a worked example, the most common discrepancies to watch for, and how starting from clean, accurate data makes the job faster.
Quick Summary
Bank statement reconciliation is the process of comparing your accounting records against your bank statement to confirm that every transaction matches and the ending balances agree. It catches errors, missing entries, and fraud before they reach your financial statements.
- What it is — matching your book balance to your bank balance
- Why it matters — accurate cash, fraud detection, audit-ready books
- The process — 7 steps, from gathering records to confirming the balances agree
- Common discrepancies — outstanding checks, deposits in transit, bank fees, and errors
- Speed tip — clean, validated CSV or Excel data removes the manual step that causes most discrepancies
In This Article
- What Is Bank Statement Reconciliation?
- Why Bank Statement Reconciliation Matters
- Key Terms You Need to Know
- How to Reconcile a Bank Statement: 7 Steps
- A Worked Bank Reconciliation Example
- Common Reconciliation Discrepancies
- Bank Reconciliation Best Practices
- How Clean Data Speeds Up Reconciliation
- Frequently Asked Questions
What Is Bank Statement Reconciliation?
Bank statement reconciliation is the process of comparing your internal accounting records (your "book balance") against the transactions on your bank statement (your "bank balance") to confirm the two agree.
When they do not match, reconciliation is how you find out why — and fix it. The goal is simple: every deposit, withdrawal, check, and fee on the statement should match a record in your books, and the adjusted ending balances should be identical.
This is a core month-end task for accountants, bookkeepers, and business owners. It is sometimes called preparing a "bank reconciliation statement."
Why Bank Statement Reconciliation Matters
Skipping reconciliation is how small problems become big ones. Regular reconciliation protects your business in several ways:
- Catches errors early — a transposed amount or a missed transaction shows up now, not during an audit
- Detects fraud — unauthorized withdrawals or duplicate payments surface quickly
- Confirms real cash — you know exactly how much money you actually have, not just what the books say
- Keeps books audit-ready — reconciled accounts mean clean, defensible financial statements
- Prevents bounced payments — knowing your true balance avoids overdrafts and NSF fees
For a firm handling many clients, reconciliation is also a quality signal. Books that tie out every month build trust. If your work centers on this, our bank statement converter for accountants page shows how the data-prep step fits into a firm workflow.
Key Terms You Need to Know
A few terms come up in every reconciliation:
- Book balance — the cash balance in your own accounting records
- Bank balance — the ending balance shown on the bank statement
- Outstanding checks — checks you have written and recorded, but the bank has not yet cleared
- Deposits in transit — deposits you have recorded that have not yet posted to the bank
- Bank fees and interest — charges or interest the bank applied that you have not recorded yet
- NSF (non-sufficient funds) — a payment that bounced and was reversed by the bank
The book balance and bank balance rarely match at first glance. Reconciliation explains the gap between them.
How to Reconcile a Bank Statement: 7 Steps
Follow these seven steps in order. Each one narrows the gap between your books and the bank until the two agree.
Step 1 — Gather Your Statement and Records
Collect the bank statement for the period and your accounting records (general ledger or cash account) for the same dates. If the statement is a PDF, convert it into a clean spreadsheet first so you can sort, filter, and match line by line.
Step 2 — Match the Opening Balance
Confirm that the opening balance on the statement matches the closing balance from last period's reconciliation. If it does not, last month was not finished — fix that before going further.
Step 3 — Match Deposits and Credits
Go through every deposit and credit on the statement and tick off the matching entry in your books. Anything in your books but not on the statement is a deposit in transit. Note it.
Step 4 — Match Withdrawals, Checks, and Fees
Do the same for every withdrawal, check, debit, and bank fee. Checks recorded in your books but not yet cleared are outstanding checks. Fees and interest on the statement that are not yet in your books need to be recorded.
Step 5 — Identify and List Discrepancies
List everything that did not match: deposits in transit, outstanding checks, unrecorded fees or interest, and any amounts that differ. This list is your reconciliation worksheet.
Step 6 — Adjust the Book Balance
Update your books for anything the bank knew about that you did not — fees, interest, NSF reversals, or an error on your side. Do not change the bank's figures; you adjust your records to reality.
Step 7 — Confirm the Adjusted Balances Agree
Take the bank balance, add deposits in transit, and subtract outstanding checks. Take your adjusted book balance. The two should now be identical. If they are, the account is reconciled. If not, recheck your matches.
Reconciliation goes faster when your statements are already clean CSV or Excel files. StatementPro.ai turns PDF statements into balance-validated spreadsheets in seconds.
Try It FreeA Worked Bank Reconciliation Example
Here is a small reconciliation that ties out. Suppose your books show a closing balance of $8,250.00, but the bank statement shows $8,500.00.
You investigate and find:
- A $1,200.00 deposit in transit (recorded in your books, not yet at the bank)
- Two outstanding checks totaling $1,500.00
- A $50.00 bank fee the bank charged that you had not recorded
| Bank statement balance | $8,500.00 |
| + Deposits in transit | $1,200.00 |
| − Outstanding checks | ($1,500.00) |
| Adjusted bank balance | $8,200.00 |
| Book balance | $8,250.00 |
| − Bank fee (now recorded) | ($50.00) |
| Adjusted book balance | $8,200.00 |
Both sides land on $8,200.00. The account is reconciled. That final tie-out is your proof the books are correct.
Pro tip: Always finish with the math that proves it. If the adjusted bank balance and the adjusted book balance are not identical, something is still unmatched — do not close the period until they agree.
Common Reconciliation Discrepancies (and What Causes Them)
Most reconciliations come down to the same handful of differences:
| Discrepancy | What it means | Typical cause |
|---|---|---|
| Outstanding checks | You recorded a check; the bank has not cleared it | Timing — the payee has not cashed it yet |
| Deposits in transit | You recorded a deposit; the bank has not posted it | Timing — deposited late in the period |
| Unrecorded bank fees | A charge on the statement, not in your books | Service charges, NSF fees, card fees |
| Unrecorded interest | Interest earned, not yet in your books | Bank credited it at period end |
| Errors | Amounts differ between books and bank | Transposed digits, typos, or duplicate entries |
| Missing transactions | A line on one side has no match | Skipped during manual data entry |
The last two — errors and missing transactions — are the ones that cost the most time, and they almost always trace back to how the data was entered. Manual typing from a PDF is the usual culprit. Our guide to the 5 common conversion mistakes covers how these creep in.
Bank Reconciliation Best Practices
A few habits make reconciliation faster and more reliable:
- Reconcile monthly, on time. The longer you wait, the more transactions pile up and the harder discrepancies are to trace.
- Start from clean data. Sortable, accurate CSV or Excel data lets you match line by line instead of squinting at a PDF.
- Verify the balance tie-out every time. The adjusted balances must match — make it a non-negotiable final step.
- Keep documentation. Save the statement, the reconciliation worksheet, and notes on any adjustments.
- Separate duties where you can. The person reconciling should ideally not be the one recording payments.
How Clean Data Speeds Up Reconciliation
Here is the part most reconciliation guides skip: you cannot reconcile data you do not have in usable form. Before any matching happens, the statement has to become a clean, sortable spreadsheet.
When that step is done by hand — typing or copy-pasting from a PDF — it introduces the exact errors and missing transactions that create reconciliation discrepancies in the first place. Fix the data prep and you remove a whole category of problems.
That is the job StatementPro.ai does. It is an AI-powered bank statement converter that turns PDF, scanned, or digital statements into clean CSV or Excel files in seconds, with every transaction captured and the running balance validated against the statement. It does the data prep — it is not a reconciliation platform — so the matching steps above start from accurate data instead of a fresh round of typing.
For firms reconciling many accounts each month, that is the difference between hours of cleanup and a few minutes of review. Compare approaches in our best bank statement converter breakdown.
Turn any PDF statement into a clean, reconciliation-ready Excel file in seconds.
Frequently Asked Questions
What is bank statement reconciliation?
Bank statement reconciliation is the process of comparing your accounting records to your bank statement to confirm every transaction matches and the ending balances agree. It catches errors, missing entries, and fraud.
How often should you reconcile a bank statement?
At least once a month, when your statement arrives. Businesses with high transaction volume often reconcile weekly so discrepancies are easier to trace.
What are the steps in bank reconciliation?
Gather your statement and records, match the opening balance, match deposits, match withdrawals and fees, list discrepancies, adjust your book balance, and confirm the adjusted balances agree.
What is the difference between the bank balance and the book balance?
The bank balance is the ending balance on your bank statement. The book balance is the cash balance in your own records. Reconciliation explains the timing differences between them, such as outstanding checks and deposits in transit.
What are common bank reconciliation discrepancies?
Outstanding checks, deposits in transit, unrecorded bank fees or interest, data-entry errors, and missing transactions are the most common.
Can software do bank statement reconciliation for you?
Accounting software can automate much of the matching. The first step — getting accurate data out of a PDF statement — is handled by a converter like StatementPro.ai, which produces a clean, balance-validated CSV or Excel file to reconcile from.
Reconcile with Confidence
Bank statement reconciliation comes down to one idea: make your records and the bank agree, and prove it with the numbers. Follow the seven steps, watch for the common discrepancies, and finish with the balance tie-out every time.
The single biggest speed-up is starting from clean data. When your statements are already accurate CSV or Excel files, reconciliation stops being a data-entry chore and becomes a quick review.
Start reconciliation from clean data
StatementPro.ai converts PDF bank statements into balance-validated CSV or Excel in seconds. Try it free.
Try It FreeThe data-entry errors that cause most reconciliation discrepancies — and how to avoid every one of them.
We compare the top bank statement conversion methods on accuracy, speed, security, and pricing to help you choose the right tool.