How to Reconcile a Bank Statement: Step-by-Step with Worked Examples

A bank reconciliation is the simplest and most powerful control in bookkeeping. It answers one question: does the cash balance in your records agree with the money the bank says you have, and if not, exactly why not? Done every month, it catches missing transactions, duplicated entries, bank errors, unauthorised payments and timing differences before they compound into a year-end mess.

This guide explains what reconciliation is, walks through the process step by step with a worked example, shows how to track down a difference that will not go away, and covers how to reconcile when you start from PDF statements rather than a live bank feed.

Two different checks that both get called "reconciliation"

People use the word for two related but separate tasks, and it helps to keep them apart.

1. Statement integrity check. Does the statement add up on its own terms? The opening balance plus every credit minus every debit should equal the closing balance printed on the statement. If you converted a PDF into a spreadsheet, this check proves that the conversion captured every row correctly. We run it automatically on every conversion; see balance reconciliation.

2. Bank reconciliation. Do your books agree with the bank? This compares your ledger (cash book, QuickBooks, Xero, Sage or a spreadsheet) with the statement and explains every difference. It is what accountants mean by "reconciling the bank", and it is the subject of the rest of this article.

Always do the first check before the second. If the statement data is incomplete, you will waste time hunting for differences that are really conversion errors.

Why bank reconciliation matters

• Accuracy of financial statements. Cash is usually the most active account. Errors there flow into revenue, expenses, VAT or sales tax returns and management reports.
• Fraud detection. Unrecognised payments, cheques cashed for altered amounts and duplicate vendor payments show up as unexplained items.
• Cash management. Knowing which cheques have not cleared prevents you from spending money that is already committed.
• Audit and lending readiness. Auditors, lenders and tax authorities expect monthly reconciliations with supporting schedules.
• Bank errors. Banks occasionally post transactions to the wrong account or charge incorrect fees. Many account agreements set a limited window for reporting errors, so timely reconciliation protects your rights.

What you need before you start

• The bank statement for the period, either the PDF or converted data in Excel, CSV or an accounting import format.
• Your ledger for the same account and period.
• Last period's reconciliation report, including the list of items that were outstanding at that date.
• Supporting documents for unusual items: cheque stubs, deposit slips, payment confirmations, loan schedules.

The core formula

The reconciliation works by adjusting both sides until they agree:

Adjusted bank balance = closing balance per statement + deposits in transit - outstanding cheques ± bank errors

Adjusted book balance = closing balance per books + interest earned + money received directly by the bank - bank fees - returned (NSF) items ± book errors

When everything is accounted for, the adjusted bank balance equals the adjusted book balance. Items on the bank side are timing differences you do not record in the books (they will clear on their own); items on the book side are things the bank knew about first, which you must now record with journal entries.

Step-by-step bank reconciliation

Step 1: Confirm the starting point

Check that the opening balance on this statement equals the closing balance on last month's statement, and that last month's reconciliation balanced. If last month did not reconcile, fix that first; otherwise you carry the error forward.

Step 2: Clear items from last month's outstanding list

Take last period's list of outstanding cheques and deposits in transit. Tick each one that appears on the current statement. Anything still uncleared after several months deserves a phone call: a cheque that was never cashed may need to be voided and reissued, and in many jurisdictions long-unclaimed funds eventually fall under unclaimed property rules.

Step 3: Match deposits

Compare each deposit in your books with the credits on the statement. Watch for:

• Several cheques deposited together appearing as one bank credit.
• Card processor settlements arriving net of fees, so the bank credit is smaller than the sales you recorded.
• Deposits recorded on the last day of the month that the bank credited on the first business day of the next month. These are deposits in transit.

Step 4: Match withdrawals and cheques

Compare cheques, transfers, card payments and direct debits. Cheques written but not yet presented are outstanding cheques. Check amounts carefully: a cheque recorded as 1,530 but cleared as 1,350 is a book or bank error that needs investigating, not a timing difference.

Step 5: Identify bank-only items

Go through the statement for items not in your books: monthly service fees, wire fees, interest earned, returned customer cheques (NSF), automatic loan payments, card chargebacks and foreign exchange fees. List each one; you will record them in step 7.

Step 6: Prepare the reconciliation

Write out both sides using the formula above. Most accounting software has a reconciliation screen that does this, but a spreadsheet works equally well.

Step 7: Record adjusting entries in the books

Every book-side adjustment needs a journal entry or transaction: bank fees to bank charges expense, interest to interest income, NSF cheques back to accounts receivable, and so on. Timing differences on the bank side do not need entries.

Step 8: Review, sign off and file

Print or save the reconciliation report, attach the outstanding items list and the statement, and record who prepared and who reviewed it. In a business with more than one person handling money, the reviewer should not be the person who records cash transactions.

Worked example

Here is a reconciliation for a small business checking account for March.

Statement, 31 March: closing balance 12,480.00

Books, 31 March: cash balance 11,925.00

Items found during matching:

Item	Amount	Side
Deposit recorded 31 March, credited by bank 1 April	1,200.00	Bank: add (deposit in transit)
Cheque #1042 to supplier, not yet presented	1,640.00	Bank: subtract (outstanding cheque)
Cheque #1045 to landlord, not yet presented	150.00	Bank: subtract (outstanding cheque)
Monthly service fee	25.00	Books: subtract
Interest earned	8.00	Books: add
Customer cheque returned unpaid (NSF)	300.00	Books: subtract
Cheque #1039 recorded as 640.00, cleared at 460.00 (book error)	180.00	Books: add

Bank side: 12,480.00 + 1,200.00 - 1,640.00 - 150.00 = 11,890.00

Book side: 11,925.00 - 25.00 + 8.00 - 300.00 + 180.00 = 11,788.00

The two sides differ by 102.00, so something is still missing. Going back through the statement, there is a card payment of 102.00 for software that was never entered in the books. After recording it, the book side becomes 11,788.00 - 102.00 = 11,686.00... which now differs by 204.00. That doubling is the classic sign of a reversed sign: the 102.00 was a refund, not a payment. Recording it as a credit gives 11,788.00 + 102.00 = 11,890.00, and the reconciliation balances.

The example is deliberately messy because real reconciliations are. The useful lesson is that the size of the difference tells you what kind of mistake to look for.

How to find a difference that won't go away

When the two sides refuse to agree, work through these checks in order.

1. Is the difference equal to a single transaction? Search the statement and books for that exact amount. It is probably missing from one side or duplicated on the other.
2. Is it twice a transaction amount? Look for a sign error: a deposit recorded as a payment, or a refund recorded as a purchase.
3. Is it divisible by 9? Transposed digits (54 entered as 45, 1,530 as 1,350) always produce a difference divisible by 9.
4. Is it a round number? Check for a typo in the thousands or hundreds column.
5. Did the opening balances agree? If last month's reconciliation was forced or skipped, the difference may be historical.
6. Was a transaction dated in the wrong period? A December payment entered with a January date will show up in the wrong reconciliation.
7. Was an item reconciled previously and then edited or deleted? Accounting software usually lets you edit reconciled transactions, which silently breaks earlier reconciliations.
8. Is the statement data complete? If you are working from converted PDFs, re-run the integrity check: opening plus credits minus debits must equal closing.

Reconciling from PDF statements

Live bank feeds make matching easier, but many reconciliations still start from PDFs: older periods, accounts without feeds, clean-up projects, client documents received by email, or banks whose feeds dropped transactions.

A reliable workflow:

1. Convert the statement into a spreadsheet or import file. A tool like our PDF to Excel converter or PDF to QBO converter keeps dates and signs consistent.
2. Check statement integrity first: the converted rows must reproduce the printed closing balance and, ideally, every printed running balance.
3. Import or match. Either import the file into your accounting system (see our guides for QuickBooks and Xero) or use a spreadsheet match with lookups on date and amount.
4. Reconcile in the accounting system using the statement's closing balance and date.

If you need a quick calculator for the reconciliation arithmetic, our free bank reconciliation calculator lays out both sides and shows the remaining difference.

Matching transactions in Excel

For a spreadsheet reconciliation, put the bank data on one sheet and the book data on another, each with Date, Description and Amount columns, using the same sign convention.

• Add a key column on both sheets combining amount and date, for example =TEXT(C2,"0.00")&"|"&TEXT(A2,"yyyy-mm-dd").
• On the bank sheet, use =COUNTIF(Books!D:D,D2) to see whether a matching key exists in the books. Zero means unmatched.
• Do the reverse on the book sheet.
• For items that match on amount but not date, add a looser key using amount only and review those manually.

Unmatched bank items become your book-side adjustments; unmatched book items become outstanding items. The guide to categorising transactions in Excel covers related lookup techniques.

How often should you reconcile?

Monthly is the minimum for any business account, aligned with the statement cycle. High-volume accounts, accounts with many cheques, and accounts where fraud risk is elevated benefit from weekly or even daily reconciliation against the bank feed, with a formal monthly sign-off. Personal accounts are easier: a monthly glance comparing your budget app or spreadsheet with the statement is usually enough.

Reconciliation is a central item on any month-end close checklist, and it should be complete before you produce management accounts or file indirect tax returns.

Special situations

Credit card accounts

Reconcile cards in the same way, but remember the balance is a liability. Purchases increase it and payments reduce it. Match the statement's new balance with your card liability account, and treat payments made but not yet received by the card issuer as timing differences.

Foreign currency accounts

Reconcile in the account's own currency first, then deal with revaluation separately. Mixing exchange rate differences into a transaction-level reconciliation makes it impossible to see genuine errors.

Accounts with many card or payment processor deposits

Stripe, PayPal, Square and similar processors pay out net of fees and refunds, often combining many sales into one deposit. Use the processor's payout report to break the deposit into gross sales, fees and refunds, then match the net amount to the bank.

Catching up several months

Do it one month at a time, in order. Reconciling twelve months against a single year-end balance hides errors that offset each other. Our bookkeeping clean-up page outlines a catch-up workflow.

Common reconciliation mistakes

• Forcing the reconciliation with an unexplained "adjustment" entry. It hides the problem and makes next month harder.
• Recording timing differences as journal entries. Outstanding cheques and deposits in transit clear by themselves; booking them double-counts.
• Ignoring small differences. A small difference can be the net of two large errors in opposite directions.
• Not keeping the outstanding items list. Without it, next month starts blind.
• Reconciling to the wrong date. Use the statement's closing date, not the last day of the calendar month, if they differ.

Building reconciliation into your internal controls

As a business grows, reconciliation stops being a bookkeeping chore and becomes part of the control environment. A few practices make it far more effective.

Separate duties. The person who reconciles should ideally not be the person who approves payments or records receipts. In a very small business where that is impossible, the owner should at least review the reconciliation and scan the statement personally each month, looking for payees they do not recognise.

Set a deadline. Agree that every account is reconciled within a fixed number of business days after the statement date, for example five. Deadlines turn reconciliation from "when there is time" into a routine.

Investigate stale items. Any outstanding cheque or deposit in transit older than about 60 to 90 days should be investigated rather than carried forward indefinitely. Old deposits in transit are a particular warning sign, because legitimate deposits almost always clear within a few business days.

Keep evidence of review. A signature, initials or an approval in your accounting software, with a date, shows auditors and lenders that the control actually operated.

Lock reconciled periods. Most accounting systems let you set a closing date or lock period. Locking stops someone from editing a reconciled transaction months later and silently breaking the history.

Review the pattern, not just the balance. A reconciliation can balance while still hiding a problem, such as a new recurring payment to an unknown supplier. Spend a minute reading the statement descriptions each month, or use a bank statement analysis view to spot new payees and unusual amounts.

Frequently asked questions

What is the difference between a deposit in transit and an outstanding cheque?

A deposit in transit is money you have recorded as received but the bank had not credited by the statement date. An outstanding cheque is a cheque you have written and recorded, but the payee has not yet cashed. Both are timing differences adjusted on the bank side, in opposite directions.

Do I need to record bank fees found during reconciliation?

Yes. Fees, interest, returned items and automatic payments that appear only on the statement must be entered in your books, usually as expenses, income or receivable adjustments. These are the book-side adjustments.

What if the bank made the error?

Note it as a bank-side adjustment on the reconciliation, contact the bank promptly with the evidence, and confirm the correction on the next statement. Do not change your books to match a bank error.

Can I reconcile without a bank feed?

Yes. Many accountants reconcile from PDF statements, either manually or by converting them to Excel, CSV or QBO first. The important step is confirming that the converted data reproduces the statement's opening and closing balances.

How long should a bank reconciliation take?

For a small business account with a few dozen transactions, it can take 15 to 30 minutes once the process is routine. Catch-up work, high volume, or a stubborn difference can take much longer, which is the strongest argument for reconciling monthly.

What documents should I keep with a reconciliation?

Keep the reconciliation report, the bank statement, the outstanding items list and support for any adjustments. Our guide on how long to keep bank statements covers retention periods.

Summary

Reconciling a bank account means explaining every difference between the bank's records and yours. Adjust the bank side for timing differences, adjust the books for items the bank recorded first, and investigate whatever remains using the size of the difference as your guide. If your reconciliations start from PDFs, convert them with a tool that proves each statement adds up first. You can try StatementPilot free for 20 pages a month.