Bank Reconciliation Statement: How to Reconcile a Bank Statement
Use the analysis guide if you want to review income, spending, and red flags before or alongside reconciliation work.
Analyze bank statementsUse the retention guide if your question is how long to store reconciled statements and supporting records.
See retention rulesUse the retrieval guide if you still need to download the official statement before reconciling it.
Get a bank statementYour bank statement ending balance and your own records almost never match — and that's normal. Bank reconciliation is the process of explaining exactly why they differ and confirming that both arrive at the same correct figure. This guide walks through the full process, with a sample bank reconciliation statement format you can use right away.
What Is Bank Reconciliation?
Bank reconciliation is the process of comparing your bank statement (what the bank says your balance is) against your own financial records (what you think your balance is) to make sure they agree.
The two balances will almost always be different because of timing differences — transactions you've recorded that the bank hasn't processed yet, or transactions the bank has processed that you haven't recorded yet. Reconciliation explains every difference and confirms neither figure has an error.
Bank Balance vs. Book Balance — What's the Difference?
Before you start reconciling, it's important to understand the two balances you're working with:
How to Reconcile a Bank Statement in 6 Steps
Follow these steps in order. The goal is to reach the same "adjusted balance" from both the bank side and the book side.
Bank Reconciliation Statement Format + Example
Here is the standard bank reconciliation statement format, filled in with a sample example. Both adjusted balances must equal the same number.
The reconciled balance is the adjusted figure that both sides agree on — $9,125.00 in this example. This is your true, verified account balance after all timing differences are accounted for.
Bank Reconciliation Formula
The book-to-bank reconciliation comes down to two formulas. Both adjusted balances must produce the same number:
+ Deposits in Transit
− Outstanding Checks
+ Unrecorded Credits (interest, refunds)
− Unrecorded Debits (fees, NSF checks)
Bank Reconciliation Example (with Numbers)
Here's a full book-to-bank reconciliation example. The bank statement ending balance is $12,350.00, the book ending balance is $11,870.00, and the goal is to prove both sides match once outstanding items are accounted for.
+ Deposit in transit $ 1,200.00
− Outstanding check #1042 $ 420.00
− Outstanding check #1045 $ 1,235.00
Adjusted bank balance $11,895.00
+ Interest credit $ 50.00
− Bank service fee $ 15.00
− NSF returned check $ 10.00
Adjusted book balance $11,895.00
The reconciled balance — $11,895.00 in this example — is the real, trustworthy cash position. Both the bank and the books had it wrong individually; the reconciliation statement produces the truth.
Book to Bank vs Bank to Book Reconciliation
These two terms describe the same reconciliation done from opposite starting points. The end result — a reconciled balance — is identical.
Auditors prefer the bank-to-book direction because the bank statement is the objective source document. For day-to-day small-business accounting, book-to-bank is usually faster because your books already reflect transactions as you enter them.
Common Discrepancies and How to Fix Them
If your balances don't match, here are the most likely causes and what to do. Note: not every unfamiliar entry is an error — labels like counter credit (an in-person teller deposit) or abbreviations like NGIC (National General Insurance) are standard banking labels that may look wrong at first glance.
How Often Should You Reconcile?
Never let more than 90 days pass without reconciling. The longer you wait, the harder it is to track down discrepancies — vendors close, records get lost, and fraud can go undetected for months.
Reconciling in QuickBooks, Excel, and Other Tools
- Go to Accounting → Reconcile
- Select your bank account and enter the statement ending date + ending balance
- Check off each transaction that appears on your bank statement
- When Difference = $0.00, click Finish Now
- Create two columns: Bank Statement transactions and Book transactions
- Use VLOOKUP or manual matching to find items in both lists
- Flag unmatched items — these are your outstanding items
- Build the reconciliation template shown above in separate cells
- Go to Accounting → Bank Accounts → select account → Reconcile
- Xero automatically imports bank transactions via bank feed
- Match imported transactions to your Xero entries
- Any unmatched items are flagged for review
Frequently Asked Questions
What is bank reconciliation?
Bank reconciliation is the process of matching your internal financial records (your books) against your official bank statement to make sure they agree. It confirms that every transaction is accounted for and catches errors, fraud, or missing entries before they become bigger problems.
How often should you reconcile bank statements?
Monthly is the standard for most businesses and individuals. Reconcile at the end of each statement period. High-volume businesses (with hundreds of daily transactions) may reconcile weekly or even daily. Never go longer than 90 days without reconciling — errors compound quickly.
What is the difference between a bank statement and a bank reconciliation statement?
A bank statement is an official document from your bank showing all transactions in an account for a period. A bank reconciliation statement is a document YOU create to explain the difference between your bank balance and your book balance, listing outstanding items and adjustments.
What if the adjusted balances still don't match?
Work backwards: check for duplicate entries, wrong amounts (transposition errors — try dividing the difference by 9, a divisible result usually means transposed digits), or missing transactions. Also check that you're using the correct statement period. If you can't find it, have a second person review the reconciliation.
Can I use bank reconciliation to detect fraud?
Yes — this is one of its most important uses. Reconciliation catches unauthorized transactions (someone using your account number), forged checks, altered check amounts, and fraudulent ACH debits. Regular reconciliation is one of the strongest internal controls a business can have.
What is a bank reconciliation statement format?
A standard format has two sections: (1) Bank Balance section — start with bank ending balance, add deposits in transit, subtract outstanding checks = adjusted bank balance. (2) Book Balance section — start with book ending balance, add bank credits not recorded, subtract bank debits not recorded = adjusted book balance. Both adjusted figures must be equal.
How do I reconcile a bank statement in QuickBooks Online?
In QuickBooks Online: go to Accounting → Reconcile. Select the account and enter the ending date and ending balance from your bank statement. QuickBooks will show your cleared and uncleared transactions. Check off each transaction that matches your bank statement. When the 'Difference' field shows $0.00, click Finish.
What is the bank reconciliation formula?
Two formulas must produce the same number. Bank side: Bank Statement Ending Balance + Deposits in Transit − Outstanding Checks = Adjusted Bank Balance. Book side: Book Ending Balance + Unrecorded Credits (interest, refunds) − Unrecorded Debits (fees, NSF checks) = Adjusted Book Balance. If Adjusted Bank = Adjusted Book, the statement is reconciled.
What is a reconciled balance?
A reconciled balance is the adjusted figure that both the bank and book sides produce at the end of a reconciliation — the real, trustworthy cash position after outstanding items and unrecorded transactions are accounted for. Neither the raw bank statement balance nor the raw book balance on their own is the reconciled balance.
What is the difference between book to bank and bank to book reconciliation?
Both produce the same reconciled balance — they only differ in the starting point. Book-to-bank starts with the ledger balance and adjusts toward the bank; bank-to-book starts with the bank statement and adjusts toward the books. Small businesses typically run book-to-bank (from QuickBooks or Xero); auditors prefer bank-to-book because the bank statement is the objective source document.
What is included in a bank reconciliation summary?
A bank reconciliation summary lists four things: the ending bank statement balance, the ending book balance, the items that reconcile the two (outstanding checks, deposits in transit, bank fees, interest, errors), and the final reconciled balance. It also notes the statement period and the date reconciliation was performed.
Free tool · 30 seconds · No signup
Skip the spreadsheet
Upload your bank statement and get every transaction automatically categorized and analyzed — no manual matching required.
