How do you reconcile a bank statement step by step?

Match every deposit and withdrawal that appears on both your books and the statement, list the items that appear on only one side, record any bank fees or interest in your books, then adjust the bank balance for outstanding checks and deposits in transit until it equals your adjusted book balance.

What are outstanding checks and deposits in transit?

An outstanding check is one you have written and deducted from your books but the recipient has not yet cashed, so you subtract it from the bank balance. A deposit in transit is money you recorded but the bank has not yet posted, so you add it to the bank balance.

Why won't my bank statement reconcile?

The most common causes are a missing bank fee or auto-payment, a transposition error (the difference divides evenly by nine), a transaction entered with the wrong sign (the difference is double the amount), or a mismatched statement date range.

How often should you reconcile a bank statement?

At least monthly, as soon as each statement closes. Frequent reconciliation keeps errors small, catches fraud early, and means you are never reconstructing transactions you have forgotten.

What is the difference between reconciling and balancing a checkbook?

They are the same idea at different scales. Balancing a checkbook reconciles a personal account against the bank, while business reconciliation does the same against a full accounting ledger and produces a documented worksheet for the records.

Can I reconcile a bank statement in a spreadsheet?

Yes. Convert the statement to CSV or Excel, paste your own records alongside, and use formulas to match amounts and total the adjustments. A spreadsheet is enough for low to moderate transaction volume.

How to Reconcile a Bank Statement: 5 Simple Steps

To reconcile a bank statement, you compare the closing balance the bank reports against the balance in your own accounting records for the same period, then account for every difference between them. The two figures rarely match on the first pass, and that is normal: checks you wrote have not cleared yet, deposits are still in transit, and the bank has added fees or interest you have not recorded. Reconciliation is the process of explaining each of those gaps until your books and the bank agree to the penny.

Goal: prove that your recorded cash balance equals the bank's balance once timing differences and errors are accounted for.
Frequency: reconcile every account at least monthly, as soon as the statement closes, while transactions are still fresh.
The four usual suspects: outstanding checks, deposits in transit, bank fees and interest, and recording errors on either side.
Direction matters: outstanding items adjust the bank side; fees, interest, and your own mistakes adjust the book side.
A clean reconciliation is the evidence auditors, lenders, and the IRS expect that your cash figure is real and not estimated.

What you need before you start

You need exactly two things: the bank statement for the period and your own record of cash transactions for those same dates. The statement comes from online banking as a PDF; your record is whatever ledger, check register, or accounting file you keep. The single most common reason a reconciliation fails is mismatched date ranges, so confirm both cover the identical statement period before you compare a single line.

Document	Where it comes from	What you pull from it
Bank statement	Online banking, downloaded as PDF for the closed cycle	Opening balance, every cleared transaction, fees, interest, closing balance
Your cash ledger	Accounting software, spreadsheet, or check register	Every deposit and payment you have recorded for the same dates
Prior reconciliation	Last month's completed worksheet	Any items that were still outstanding and should clear this period

If your statement is a locked PDF, the fastest way to compare it line by line is to convert the statement to Excel first, so each transaction becomes a sortable row you can tick off against your ledger.

The five-step reconciliation process

The process is mechanical once you know the order: match what cleared, list what did not, add what only the bank knew about, then adjust both sides until they agree. Work through it in this sequence and you will not double-count anything.

Confirm the opening balance. The statement's opening balance should equal last period's reconciled closing balance. If it does not, the prior reconciliation has a problem to fix first.
Match deposits and credits. Go line by line through the statement's incoming money and tick the matching entry in your books. Anything in your books not yet on the statement is a deposit in transit.
Match withdrawals and debits. Do the same for outgoing money: checks, card payments, transfers, and automatic debits. Checks in your records that have not cleared are outstanding checks.
Add bank-only items to your books. Record any service charges, monthly fees, NSF fees, interest earned, or auto-payments that appear on the statement but were never entered in your ledger.
Reconcile the two adjusted balances. Take the bank's closing balance, add deposits in transit, subtract outstanding checks. Take your book balance, add interest, subtract fees and any corrections. The two results must match.

For the formal worksheet that lays out those adjustments in a balance-per-bank versus balance-per-books format, see our guide to the bank reconciliation statement.

Outstanding checks and deposits in transit

These two timing differences explain the majority of reconciliations that do not balance on the first try, and they adjust opposite sides. An outstanding check is money you have already subtracted from your books but the recipient has not cashed, so the bank balance is still too high. A deposit in transit is money you have added to your books but the bank has not yet posted, so the bank balance is too low.

Timing item	What it is	Effect on the bank balance	Adjustment
Outstanding check	A check you wrote that has not cleared	Bank balance is higher than reality	Subtract from the bank balance
Deposit in transit	A deposit recorded but not yet posted	Bank balance is lower than reality	Add to the bank balance
Bank fee or charge	A cost the bank deducted automatically	Already reflected at the bank, not in books	Subtract from the book balance
Interest earned	Interest the bank credited	Already reflected at the bank, not in books	Add to the book balance

A check that stays outstanding for months is worth investigating: it may be lost, and after a long period it can become a stale-dated or unclaimed item your bank will no longer honor.

Why monthly reconciliation is the standard

The math is the test. Reconciliation is the only routine check that proves your recorded cash equals real cash. If the adjusted balances do not match, something is missing, duplicated, or entered wrong, and the difference points you straight to it.
Fraud surfaces here first. An unauthorized debit shows up as a bank transaction with no matching entry in your books. Catching it during reconciliation is often how a business first notices a compromised account, and for consumer accounts prompt reporting limits liability under federal Regulation E.
Lenders and auditors expect it. A documented monthly reconciliation is standard evidence that your financial statements are reliable, which matters whenever you apply for financing or undergo review.

A short worked example

Numbers make the order concrete. Suppose a small business ends the month with a book balance of 12,300 while the bank statement shows a closing balance of 13,000. The 700 gap looks alarming until you list the differences. There is one outstanding check for 900 to a supplier that has not cleared, a deposit in transit of 600 dropped at the branch on the last day, a 20 monthly service fee on the statement, and 20 of interest earned, also on the statement but not in the books.

Apply each to the correct side. On the bank side, start at 13,000, add the 600 deposit in transit, subtract the 900 outstanding check, and you reach 12,700. On the book side, start at 12,300, add the 20 interest, subtract the 20 fee, and you also reach 12,300 plus a net zero, which is 12,300. The two sides do not match yet, which tells you something is still missing. Re-reading the statement, you find a 400 automatic insurance payment that the bank took but the books never recorded. Subtracting that 400 from the book side brings it to 12,300 minus 400, or 11,900, and adjusting the example shows why the discipline of listing every bank-only item before declaring victory matters: a single missed auto-payment is the most common reason a reconciliation appears finished but does not actually tie out. Once that payment is recorded, both adjusted balances meet, and only then is the account reconciled.

Common errors and how to find them

When the two sides refuse to balance, the difference itself is a clue. Divide the unreconciled amount by nine: if it divides evenly, you likely have a transposition error, such as entering 54 as 45. If the difference equals exactly twice a transaction, you probably added an amount you should have subtracted, or recorded a debit as a credit.

Transposition errors. Two digits swapped. The difference is always divisible by nine.
Sign errors. A debit recorded as a credit. The difference equals double the transaction amount.
Duplicated entries. The same payment entered twice in your books. The difference equals that payment.
Missing transactions. A fee or auto-payment on the statement never recorded in your books.
Bank errors. Rare, but real. If you have ruled out your own side, the bank can post a wrong amount; document it and contact them.

What trips up reconciliations across different bank layouts

From parsing statements across hundreds of bank templates, two layout quirks cause the most reconciliation friction. First, some banks lump several same-day card transactions into one combined posting while your accounting software lists them individually, so the totals match but the line counts never do. Second, banks differ on whether a returned or reversed payment appears as a separate credit line or simply removes the original debit. When the line items will not tie out one to one but the period totals agree, the cause is almost always one of these two posting conventions, not a real discrepancy. Exporting the statement to a clean column format makes the combined postings obvious because you can sort by date and amount and see the grouping the bank applied.

Turning the statement into something you can match

The hardest part of a manual reconciliation is comparing a static PDF against your ledger. Converting the statement into Excel or CSV turns every transaction into a row you can sort by date or amount, total with a formula, and tick against your books, which removes most of the manual error from the process and lets you finish the reconciliation in minutes rather than an afternoon.

How to Reconcile a Bank Statement