Guides
How to Reconcile a Bank Statement: Step-by-Step + Example
November 19, 20268 min read
To reconcile a bank statement, compare the statement's ending balance with the cash balance in your books and adjust each one until they match. On the bank side, add deposits in transit and subtract outstanding checks, because the bank has not processed them yet. On the book side, add interest and other credits only the bank recorded, and subtract bank fees and NSF (bounced) checks. Correct any errors on the side that made them. When the adjusted bank balance equals the adjusted book balance, the account is reconciled; then record the book-side items in your books.
Pull every transaction from your PDF before reconciling
Upload your PDF bank statement to extract itemized deposits, withdrawals, bank fees, and possible duplicate charges into a clean summary or CSV/Excel export.
Upload your bank statementCheck my statementPDF from any bank. Scans and photos work too.The bank reconciliation formula
A bank reconciliation has two halves. Each half starts from a different ending balance and fixes what that record does not know yet.
| Side | Formula |
|---|---|
| Bank side | Ending bank balance + deposits in transit − outstanding checks ± bank errors = adjusted bank balance |
| Book side | Ending book balance + interest and other bank credits − bank fees and NSF checks ± book errors = adjusted book balance |
The bank side only holds timing differences and the bank's own mistakes, so it needs no entries in your books. Everything on the book side is something your books are missing or got wrong, so each book-side item becomes a journal entry once the reconciliation balances.
How to do a bank reconciliation, step by step
- Check the starting point. The statement's opening balance should equal last month's statement ending balance, and your books should start from last month's adjusted book balance. Tick off last month's deposits in transit and outstanding checks as they clear. If the starting point is wrong, fix last month first; every later month inherits the error.
- Tick off deposits and withdrawals. Go through the statement line by line and mark each deposit and each payment that matches an entry in your books, by amount and date. IRS Publication 583 has you compare each canceled check by both check number and amount.
- List what is only in your books. Unmarked deposits in your books are deposits in transit; unmarked checks and payments are outstanding. These go on the bank side.
- List what is only on the statement. Service charges, wire and overdraft fees, interest, direct customer payments and returned (NSF) checks. These go on the book side. If a line is hard to read, the bank statement abbreviations guide decodes codes such as NSF, ACH and POS.
- Hunt for errors in what is left. Work out both adjusted balances. If they still differ, divide the difference by 9: a whole number points to a transposition error (two digits swapped). A difference equal to one entry suggests it was missed or entered twice; a difference of twice an entry suggests it was entered with the wrong sign.
- Confirm the two adjusted balances match, then post. When the adjusted bank and book balances are equal to the cent, record every book-side item in your books and keep the reconciliation with the statement.
Worked bank reconciliation example
A small business closes October with $12,480.00 on its bank statement and $13,005.00 in its books, a gap of $525.00. The figures are made up; the method is the one above.
| Bank side | Amount |
|---|---|
| Ending balance per bank statement | $12,480.00 |
| Deposit in transit: Oct 31 deposit, not on the statement yet | +$2,150.00 |
| Outstanding check #1047 (rent) | −$1,200.00 |
| Outstanding check #1049 (supplier) | −$500.00 |
| Adjusted bank balance | $12,930.00 |
| Book side | Amount |
|---|---|
| Ending balance per books | $13,005.00 |
| Interest earned, shown on the statement | +$3.85 |
| Customer ACH payment the bank received but the books missed | +$346.15 |
| Monthly service charge | −$15.00 |
| NSF check returned unpaid (customer deposit bounced) | −$320.00 |
| Transposition error: check #1045 paid $540.00 but recorded as $450.00 | −$90.00 |
| Adjusted book balance | $12,930.00 |
Both sides land on $12,930.00, so October is reconciled. The transposition error was the last thing found: after the interest, the ACH payment, the fee and the bounced check, the books were still $90.00 above the adjusted bank balance. $90.00 divides by 9, which led straight to check #1045. Because the books deducted $450.00 for a check that took $540.00 out of the bank, book cash was overstated, so the correction is a deduction.
The book-side lines now become five entries: interest income, the customer payment, the service charge, the returned check (back to the customer's balance) and the corrected check. The deposit in transit and the two outstanding checks need nothing; they should appear on the November statement.
Common reasons a bank reconciliation does not balance
Almost every difference falls into one of these six. Work through them in this order; the first four are routine and the last two are mistakes.
| Difference | Side | What it looks like | What to do |
|---|---|---|---|
| Deposit in transit | Bank: add | A deposit in your books that is not on the statement, usually made on the last day or two of the period. | No entry. Confirm it appears early on next month's statement. |
| Outstanding check | Bank: subtract | A check in your books that has not cleared the bank yet. | No entry. If it is still outstanding after a few months, call the payee before reissuing or voiding it. |
| Bank fees and monthly service charges | Book: subtract | Small debits on the statement that are not in your books: maintenance fees, wire fees, overdraft fees. | Record each fee as an expense in your books. |
| NSF (bounced) check | Book: subtract | A customer check you deposited comes back as a returned item, often with a fee next to it. | Take the amount back out of cash, show it as still owed by the customer, and record the fee. |
| Duplicate entry | Book or bank | The same amount, date and payee twice: entered twice in the books, or charged twice by the merchant. | Delete the extra book entry. If the bank really charged twice, dispute it with the merchant or the bank. |
| Transposition error | Book (usually) | Two digits swapped, such as $540 entered as $450. The difference divides evenly by 9. | Correct the entry to the amount that actually cleared the bank. |
Duplicates are the easiest to miss by eye, especially a merchant charge that posted twice a day apart. The duplicate charge finder groups payments to the same merchant for the exact same amount, checks how close together they landed, and flags the ones that look like double charges, so you can check each against your books.
Reconciling a bank statement in Excel or accounting software
Accounting software such as QuickBooks or Xero runs the same reconciliation on screen: you enter the statement's ending balance and tick off matching transactions until the difference shows zero. It needs the bank transactions to be in the software first, through a bank feed or an imported file. Without a feed, or for an old period, the statement PDF is all you have.
In Excel, the fastest worksheet is two tabs and one formula:
- Put the statement transactions on a Bank tab and your ledger or checkbook on a Ledger tab, each with date in column A, description in B and amount in C (payments negative).
- In D2 on the Bank tab, enter
=COUNTIF(Ledger!C:C, C2)and fill it down. A0is a line your books are missing (fees, interest, NSF checks). A2or more is a possible duplicate. - Do the same on the Ledger tab against the Bank tab. A
0there is a deposit in transit or an outstanding check. - Lay out the two-sided reconciliation from the flagged lines and check that both adjusted balances match.
Getting the PDF into rows is the slow part. Upload the statement above to extract every transaction and download it as CSV or Excel, then paste it into the Bank tab. For practices doing this for many clients each month-end, bank statement processing for accountants covers client statements, categorization and QBO, QIF and OFX exports.
Frequently asked questions
What does it mean to reconcile a bank statement?
Reconciling a bank statement means checking that the ending balance on the bank statement and the cash balance in your own records (the books, the cash book or your checkbook) tell the same story. You adjust the bank balance for items the bank has not processed yet, such as deposits in transit and outstanding checks, and the book balance for items only the bank knows about, such as fees, interest and returned checks. When both adjusted balances are equal, the account is reconciled.
What is the formula for a bank reconciliation?
There are two sides. Bank side: ending bank balance + deposits in transit − outstanding checks ± bank errors = adjusted bank balance. Book side: ending book balance + interest and other bank credits − bank fees and NSF checks ± book errors = adjusted book balance. The reconciliation is done when the two adjusted balances match to the cent.
How often should you reconcile a bank statement?
Every month, when the statement arrives. IRS Publication 583 says you should reconcile your checking account each month. Busy business accounts are often reconciled weekly or even daily from the online transaction list, because a month of unmatched lines is much harder to untangle than a week.
What are deposits in transit and outstanding checks?
Both are timing differences. A deposit in transit is money you deposited and recorded in your books that the bank had not recorded by the statement date, so you add it to the bank balance. An outstanding check is a check you wrote and deducted in your books that the payee has not cashed yet, so you subtract it from the bank balance. Neither needs a journal entry, because your books are already right; they should clear on next month's statement.
Why is my bank reconciliation off by a number divisible by 9?
A difference that divides evenly by 9 is the classic sign of a transposition error, where two digits were swapped when an amount was entered, for example $540 recorded as $450 (difference $90) or $1,260 recorded as $1,620 (difference $360). Search your entries for one whose digits could be swapped to produce that gap. It is a strong clue, not proof: a missing item can also happen to be a multiple of 9.
What should I do if an NSF check appears on my bank statement?
An NSF (non-sufficient funds) check is a customer's check you deposited that bounced, so the bank took the money back out of your account, often with a returned-item fee. Subtract the check amount and any fee from your book balance on the reconciliation, record both in your books, and treat the check amount as still owed by the customer. Then contact the customer for a new payment.
Can I reconcile a bank statement in Excel?
Yes. Put the bank statement transactions on one sheet and your ledger or checkbook entries on another, each with date, description and amount. Use COUNTIF on the amount column to flag lines with no match on the other sheet (fees, interest, deposits in transit, outstanding checks) and lines that match more than once (possible duplicates), then build the two-sided reconciliation from the flagged lines. The slow part is getting the statement out of PDF and into rows; a statement converter does that in seconds.
How long should you keep bank reconciliations and statements?
Keep them with your tax records. The IRS generally has three years to assess more tax, or six if more than 25% of gross income was left off the return, and it says to keep employment tax records for at least four years. In the UK, sole traders must keep records for at least five years after the 31 January submission deadline of the tax year, and limited companies for six years from the end of the financial year they relate to; GOV.UK lists bank statements among those records.



