Bank Reconciliation: 6-Step Guide (2026)
Quick answer: Bank reconciliation is the process of comparing your internal bookkeeping records against your bank statement to make sure every transaction is accounted for and both balances agree. It is a direct way to catch errors, spot unauthorized charges, and keep your financial records trustworthy.
This guide gives you a six-step method, a worked example with real numbers and a reconciliation checklist. Use it by hand or with software.
How to Fix Missing Transactions in Bank Statements
A missing transaction is always one of five cases, and each case has its own fix. Sort every unmatched item into the table below before you change anything in your books.
| Case | What it usually is | The fix |
|---|---|---|
| In the bank but not in your books | A fee, interest, an automatic payment or a deposit you never recorded | Record it in your books with the date and amount shown on the statement |
| In your books but not on the statement | A timing difference, such as an outstanding check or a deposit in transit | Change nothing and list it as a reconciling item; it should clear on a later statement |
| Amount differs | A typo, transposed digits or a check recorded at the wrong amount | Verify the underlying check or invoice first, then correct whichever record is wrong; when the bank is wrong, treat it as a bank error |
| Duplicate | The same transaction entered twice, often one manual entry and one imported from the bank feed | Delete the extra entry in your books |
| Bank error | A wrong amount, a charge that is not yours or a deposit credited to the wrong account | Report it to the bank and track it until it is corrected (covered below) |
Search by amount first and by a date range of a few days second. Missing items often turn up within a few days of the date you expected. An item that stays in the “in your books but not on the statement” column for several statements deserves a call to the payee or the bank. The Common Discrepancies section below covers timing differences, fees, entry errors and unauthorized charges in more detail.
The diagram shows the same five cases at a glance.
What Is Bank Reconciliation?
Bank reconciliation is a verification process. You take your bookkeeping records (the transactions you have logged in your ledger, spreadsheet, or bookkeeping software) and compare them line by line against the official bank statement for the same period.
The goal is simple: your ending book balance and your bank statement balance should agree once you account for timing differences and corrections. When they don’t, you investigate until you find the reason.
Reconciliation is a line-by-line comparison, not a glance at your bank balance online. A quick peek at your banking app does not tell you whether your books are accurate. A structured comparison in your bookkeeping software or spreadsheet surfaces discrepancies you would never spot otherwise.
Why Bank Reconciliation Matters for Small Businesses
Bank reconciliation catches errors, helps catch fraud, keeps tax filings accurate and gives you a reliable cash position.
Error detection
A mistyped number, a duplicated entry or a transaction you forgot to record can compound over time. A $200 error in March becomes a $200 mystery in December that takes hours to track down. Monthly reconciliation catches these problems while they are still fresh and fixable.
Fraud prevention
Organizations with fewer than 100 employees lose a median of $126,000 per occupational fraud case, and the typical scheme runs 12 months before it is detected, according to the ACFE’s Occupational Fraud 2026: A Report to the Nations. Reconciliation catches money that left the account without a matching record, such as unauthorized purchases and altered check amounts. Cash stolen before it is recorded or deposited may not show up in the match.
Accurate tax filings
Your CPA needs numbers they can trust at tax time. Records that don’t match your bank activity risk overpaying taxes (by missing deductions) or underpaying (and facing IRS penalties). Clean reconciliation means clean tax filings, and it gives you reliable numbers when you plan around the IRS estimated payment deadlines.
Reliable cash position
You cannot decide on hiring, inventory or marketing spend without knowing how much money you have. Reconciled books give you a reliable cash position, not an approximation. Lenders also want to see organized financial records when you apply for a loan or line of credit, and consistently reconciled books signal that your business is well managed.
How to Reconcile Your Bank Account: 6 Steps
The six steps run in a fixed order, and each one depends on the one before it. The chart shows the full sequence before the detail.
Step 1: Gather your documents
Pull together two things:
- Your bank statement for the period you are reconciling (usually one month). Download it from your online banking portal or use the mailed paper statement.
- Your bookkeeping records for the same period: your general ledger, check register, or the transaction log from your chart of accounts.
Make sure both documents cover the exact same date range. Your bookkeeping records must cover the same dates as the statement, such as March 1 through March 31.
Step 2: Compare the starting balances
Check each opening balance against last month. The statement’s opening balance must equal the prior statement’s closing balance, and your book opening balance must equal last month’s reconciled book balance. The raw bank and book opening balances do not have to equal each other: last month’s outstanding checks and deposits in transit explain any difference between them.
Stop when either opening balance fails its check. Something changed after last month was closed, such as an edited entry or a missing statement, and it needs fixing first. Reconciling on top of it will not balance.
Step 3: Match transactions one by one
Go through each transaction on your bank statement and find the corresponding entry in your books. Check off each match as you go. Pay attention to:
- Deposits and credits: Do all incoming payments on the bank statement appear in your books at the correct amounts?
- Checks and debits: Do all outgoing payments match?
- Dollar amounts: Does every figure agree exactly? Even a $0.50 difference matters.
- Dates: Are the dates close? Bank processing dates sometimes differ from the date you recorded the transaction by a day or two. That is normal and not a problem.
This is the most time-consuming step, but it is where you find problems. Work methodically from top to bottom and skip nothing.
Step 4: Identify outstanding items
After matching, some items will appear in one set of records but not the other. These are your unmatched items:
- Outstanding checks: Checks you wrote and recorded in your books, but the recipient has not cashed yet. They show in your records but not on the bank statement.
- Deposits in transit: Money you received and recorded, but it had not cleared the bank by the statement closing date.
- Bank fees and service charges: Monthly service fees, wire transfer fees, overdraft charges, or ATM fees that appear on the statement but you have not yet recorded in your books.
- Interest earned: Small amounts of interest the bank credits to your account that you may not have logged.
- Automatic payments: Recurring charges (subscriptions, loan payments, insurance premiums) that hit your bank account but you forgot to record.
- Book errors: A check recorded for $520 when the actual amount was $490, a deposit entered twice, or a transaction in the wrong account. These need an entry in your books.
- Bank errors: A wrong amount or a charge that is not yours. These go on the bank side of the reconciliation until the bank corrects them.
The diagram sorts these items by where each one is handled.
Step 5: Adjust your books
Now fix what needs fixing:
- Add missing transactions: Record any bank fees, interest, automatic payments, or deposits you missed.
- Correct book errors: Fix wrong amounts, remove duplicate entries, and reclassify transactions assigned to the wrong expense category.
- Do not adjust for outstanding checks, deposits in transit or bank errors. Timing differences normally clear in a later period, and bank errors are corrected by the bank.
Total these adjustments before you post them. Step 6 adds them to the book balance as it stood before Step 5, so count each adjustment once, either in the formula or after you post it, never both.
Step 6: Verify the ending balances match
Use these two formulas and confirm the results are identical:
Adjusted bank balance: Bank statement ending balance + deposits in transit - outstanding checks +/- uncorrected bank errors = Adjusted bank balance
Adjusted book balance: Book ending balance (before the Step 5 adjustments) + unrecorded interest earned - unrecorded bank fees - NSF or returned items +/- book error corrections = Adjusted book balance
Other unrecorded receipts or automatic payments you found while matching belong in the book-side adjustments as well: add the receipts and subtract the payments.
The diagram lays the two formulas side by side.
The reconciliation is complete when the adjusted bank balance equals the adjusted book balance. Document it and move on.
A mismatch sends you back to Step 3. The usual culprits are a missed transaction, a transposition error (writing $540 instead of $450), or a check recorded at the wrong amount.
Free download, no sign-up needed
Download the bank reconciliation worksheet (Excel). It calculates both adjusted balances for you and includes the Maple Street Bakery example below.
Worked Example: Reconciling Maple Street Bakery
The example below reconciles a fictional bakery for March 2026, with every figure shown.
The starting point
Bank statement for March 2026:
- Opening balance: $12,450.00 (equal to the February statement’s closing balance)
- Total deposits: $8,365.00
- Total withdrawals: $6,580.00
- Ending balance: $14,235.00
Maple Street Bakery’s books for March 2026:
- Opening balance: $12,450.00 (equal to February’s reconciled book balance)
- Total recorded income: $9,100.00
- Total recorded expenses: $6,875.00
- Ending book balance: $14,675.00
Each opening balance ties to February, and no checks or deposits carried over from that month, so both open at $12,450. The statement arithmetic holds ($12,450 + $8,365 - $6,580 = $14,235), as do the books ($12,450 + $9,100 - $6,875 = $14,675). The ending balances still differ: the books show $14,675 and the bank shows $14,235, a $440 difference. Time to find out why.
What the owner found after matching transactions
| Item | Amount | Where it appears | What happened |
|---|---|---|---|
| Check #1047 to flour supplier | $300.00 | Books only | Written March 28, not yet cashed by the supplier |
| Catering deposit from Johnson wedding | $750.00 | Books only | Deposited March 30, not yet cleared |
| Bank monthly service fee | $35.00 | Bank only | On statement, never recorded in books |
| Interest earned | $15.00 | Bank only | On statement, never recorded in books |
| Check #1031 to equipment repair | $30.00 overstatement | Books | Recorded as $520, actual cleared amount was $490 |
The statement totals already reflect these items. Deposits of $9,100 less the $750 in transit plus $15 interest give $8,365, and withdrawals of $6,875 less the $300 outstanding check and the $30 overstatement, plus the $35 fee, give $6,580.
The reconciliation math
Adjusted bank balance:
- Bank ending balance: $14,235.00
- Minus outstanding check #1047: -$300.00
- Plus deposit in transit (Johnson wedding): +$750.00
- Adjusted bank balance: $14,685.00
Adjusted book balance:
- Book ending balance: $14,675.00
- Minus bank service fee (not yet recorded): -$35.00
- Plus interest earned (not yet recorded): +$15.00
- Plus correction for overstated expense (recorded $520, actual $490): +$30.00
- Adjusted book balance: $14,685.00
Both adjusted balances equal $14,685.00. The reconciliation is complete. The diagram shows both sides with the March figures.
The owner now records journal entries for the bank fee ($35 expense), the interest ($15 income), and the $30 expense correction. The outstanding check and deposit in transit require no action, because they normally clear in a later period.
Common Discrepancies and How to Resolve Them
Five kinds of discrepancy are covered below, and each has a fixed resolution.
Timing differences
What it looks like: A check you mailed or a deposit you made near the end of the month doesn’t appear on the bank statement.
How to fix it: Don’t fix it. These are outstanding checks and deposits in transit. They are not errors. Note them as reconciling items, and they normally clear in a later period.
Unrecorded bank fees
What it looks like: Your bank charged a $12 monthly fee, a $25 wire transfer fee, or a $35 NSF fee, and you never entered it in your books.
How to fix it: Add the fee as an expense in your books under Bank Fees or Service Charges. Bank fees are a frequent discrepancy for small businesses.
Data entry errors
What it looks like: You recorded a payment as $1,250 when the actual amount was $1,520 (transposed digits), or you entered a transaction twice.
How to fix it: Check the original check or invoice, then correct the amount in your books or delete the duplicate entry. Tip: a reconciliation difference divisible by 9 often points to a transposition error (e.g., $72 vs. $27 = $45 difference, and 45 / 9 = 5).
Unauthorized transactions
What it looks like: A charge appears on your bank statement that nobody in your business authorized.
How to fix it: Contact your bank immediately to dispute it. Track the charge as an open item until the bank resolves the claim, then clear it. The next section shows how to handle an error the bank made.
Automatic payment changes
What it looks like: A recurring payment amount changed (your insurance premium went up by $50) and your books still reflect the old amount.
How to fix it: Update the recurring entry to the new amount and record the difference for the current period.
When the Bank Made the Error
Report a bank error to the bank promptly, keep your evidence, and show the error as a temporary reconciling item on the bank side of your reconciliation. Your own books stay unchanged, because they are correct.
- Report it promptly. Contact the bank as soon as you spot the error and ask for a written claim or reference number.
- Keep the evidence. Save the statement, receipts, deposit slips and screenshots that show what the amount should have been.
- Record it on the bank side. Add or subtract the error as a separate line in the adjusted bank balance, labeled with the claim reference, so both adjusted balances still match.
- Clear it when the bank corrects it. The correction appears on a later statement. Reverse the reconciling item at that point and note the date.
The diagram shows the four actions in order.
The window for disputing an error on a business account comes from your account agreement, so read that agreement now rather than after a problem appears.
How Often Should You Reconcile?
Monthly is the minimum. Most accountants expect you to reconcile at least once a month, after your bank statement closes.
Weekly is better for businesses that process more than 50 transactions a month (a rule of thumb) or handle cash. Weekly reconciliation keeps problems small and fresh.
Daily suits high-volume businesses such as retail, restaurants and e-commerce. Automated tools often make daily reconciliation a task of about five minutes, a rule of thumb rather than a guarantee.
The more often you reconcile, the shorter each session is. These are rules of thumb, not measured figures: a month of transactions typically takes about 30 to 60 minutes, a week about 10 and a day about 5.
Catching Up After Months Without Reconciling
Start from your last reconciled statement, or from the account’s opening balance if you have never reconciled, and work forward one month at a time. Do the oldest month first and finish it before you touch the next.
- Find the starting point. Use the ending balance of your last completed reconciliation. A first-ever reconciliation starts at the opening balance of the account, which is the first statement’s starting balance.
- Reconcile the oldest month completely. Run all six steps for that statement, including the adjustments.
- Carry the balance forward. That month’s ending balance becomes the next month’s starting balance, so each opening balance ties to the prior closing balance from there onward.
- Do not net months together. One combined reconciliation lets errors in different months cancel each other out and makes the difference much harder to trace.
- Finish at the current month. From then on, reconcile each statement as it arrives.
When to use an opening balance adjustment
Use an opening balance adjustment only as a last resort, after you have rebuilt the records you can and investigated the difference. Document why you made it and review it with an accountant. Never use it as a plug to force a match, and never for a current-period error: find and fix that instead.
Manual vs. Automated Reconciliation
Manual reconciliation
You print (or view) your bank statement, open your ledger or spreadsheet, and match transactions by hand.
Pros: No software cost. Forces you to review every transaction closely. Full control.
Cons: Time-consuming (an estimated 30 to 60 minutes per account per month). Prone to human error. Easy to procrastinate.
As a guide, manual works for one bank account, fewer than 50 transactions per month and the discipline to do it consistently.
Automated reconciliation
Software connects to your bank feed, pulls in transactions automatically, and matches them against your book entries. It flags mismatches for your review.
Pros: Can take minutes instead of an hour, depending on volume. Reduces human error. Enables daily reconciliation. Creates an automatic audit trail.
Cons: Monthly software cost. Still requires your review. Initial setup takes some time.
Most bookkeeping software can connect to your bank feed and suggest matches. Instead of checking off items one by one, you review the suggestions and a short list of exceptions. Review each suggested match before you accept it.
Which should you choose?
Choose manual reconciliation for one account with fewer than 50 transactions a month, a rule of thumb rather than a hard limit. Automation fits better once you have multiple accounts, higher volume or limited time.
The diagram summarizes the choice.
Bank Reconciliation Checklist
Use this checklist every time you reconcile. Print it out or save it somewhere accessible.
- Download or collect the bank statement for the period
- Pull up your bookkeeping records for the same date range
- Confirm each opening balance ties to the prior closing balance
- Match every deposit on the bank statement to your books
- Match every withdrawal on the bank statement to your books
- List all outstanding checks (in books, not on statement)
- List all deposits in transit (in books, not on statement)
- Record any bank fees, interest, or automatic payments you missed
- Correct any data entry errors or duplicates in your books
- Calculate the adjusted bank balance
- Calculate the adjusted book balance
- Confirm both adjusted balances are identical
- Save or file the completed reconciliation with the date and your initials
- Investigate and report any unauthorized transactions immediately
Reconciliation is one line on the monthly bookkeeping checklist, which covers the full month-end routine.
Tips for Faster, Easier Reconciliation
Reconcile more frequently. Weekly beats monthly every time. Smaller batches mean shorter sessions.
Use consistent naming. When you record transactions, use the same vendor names your bank uses. A bank line reading “AMZN MKTP US” should not become “Amazon” one month and “Amazon.com” the next.
Tackle the largest discrepancies first. Search first for a single transaction near a $347 difference before hunting through dozens of small ones. Several errors can net to the same figure, so widen the search if nothing matches.
Keep a list of recurring items. Bank fees, loan payments, and subscriptions hit every month. A checklist of expected charges means you never forget to record them.
Don’t ignore small differences. A $2 discrepancy is still a discrepancy. Small errors have a way of hiding bigger problems.
Start Reconciling Today
Start with the oldest month you have not reconciled. Pull its bank statement, open your books and work through the six steps above, then move forward one month at a time. The first time takes the longest, and after that it becomes routine.
Reconciliation typically takes an estimated 30 to 60 minutes a month. It catches mistakes that cost you money, surfaces unauthorized charges early and shows that the numbers in your books reflect reality.
Software can speed up the matching, but the reconciliation is only done when your adjusted book balance equals your adjusted bank balance.
Related Resources
- Cash vs. accrual accounting: how your method changes what you record and when
- What a bookkeeper costs: DIY, software and professional options compared
- Expense categories for small business: where fees and corrections belong
- Expense tracking template: a log to keep transactions ready to match
- Cash flow forecasting: using reconciled balances to plan ahead
Frequently Asked Questions
How often should I reconcile my bank accounts?
Monthly at minimum. Many businesses reconcile weekly or even daily using automated tools. The more frequently you reconcile, the faster you catch errors and discrepancies. As a guide, reconcile weekly when you process more than 50 transactions per month.
What do I do if my books don't match my bank statement?
Check for timing differences (outstanding checks, pending deposits), data entry errors, bank fees you haven't recorded, and unauthorized transactions. Work through each discrepancy systematically, starting with the largest dollar differences, since they are the easiest to spot.
How do I fix missing transactions in a bank statement?
Sort each missing item into one of five cases: in the bank but not in your books, in your books but not on the statement, an amount that differs, a duplicate, or a bank error. Record bank-only items in your books and list timing items as reconciling items. Correct wrong amounts, delete duplicates and report bank errors to the bank.
Can I use software to reconcile my bank accounts automatically?
Yes. Most bookkeeping software can connect to your bank feed, suggest matches and flag anything that does not line up. Review each suggested match before you accept it. Automation shortens the work but does not replace checking your balance against the bank statement.
What is the difference between bank reconciliation and bookkeeping?
Bookkeeping is the ongoing process of recording and categorizing every financial transaction. Bank reconciliation is a specific verification step where you compare those records to your actual bank statement to confirm everything matches. Reconciliation is one part of the larger bookkeeping process.
How far back should I reconcile if I've never done it before?
Start from your last reconciled statement, or from the account's opening balance if you have never reconciled, and work forward one month at a time. Each month's ending balance becomes the next month's starting balance. Do not combine months. Use an opening balance adjustment only as a last resort, after you rebuild the records you can, and ideally with an accountant.
Do I need to reconcile credit card accounts too?
Yes. Credit card reconciliation follows the same process as bank reconciliation. Compare your recorded credit card transactions against the monthly statement, check for unauthorized charges, and verify the balance matches. Reconciling the card statement is how you spot charges you did not make.