A bank reconciliation is the process of matching the cash balance in your books to the balance on your bank statement and explaining every difference between them. Most small businesses should do a bank reconciliation at least monthly, within a week or two of the statement closing. Businesses with heavy transaction volume or tight cash should do it weekly.
This guide is for owners who either do their own books or rely on a bookkeeper and want to know what "reconciled" really means. You'll get a step-by-step process, a fully worked example with the kinds of differences that actually show up, and a simple rule for choosing how often to reconcile.
Why the bank balance and your books never match on their own
Your accounting software records transactions when you enter or approve them. Your bank records them when money actually moves. Those two timelines drift apart for predictable reasons:
- Outstanding checks. You wrote and recorded a check, but the vendor hasn't deposited it yet.
- Deposits in transit. You recorded a deposit, but it hadn't cleared by the statement date. Weekend card batches are a classic example.
- Bank-only items. Service fees, interest, returned customer payments and automatic debits appear on the statement before anyone records them.
- Errors. Amounts keyed wrong, transactions entered twice, or payments posted to the wrong account.
- Fraud. Charges nobody authorized. This is the difference you most need to catch, and reconciliation is often the first place it shows up.
The first two are timing differences that fix themselves. The last three need action. A reconciliation sorts one group from the other.
How to do a bank reconciliation, step by step
- Pick the period and get the statement. Use the bank's official statement for the month, not a live balance that keeps changing.
- Confirm the starting point. Last month's reconciled ending balance should equal this month's starting balance in your books. If it doesn't, someone edited a prior-period transaction. Find out what changed before going further.
- Match deposits. Tick off each deposit that appears in both places. Anything in your books but not on the statement is a deposit in transit. Anything on the statement but not in your books needs to be recorded.
- Match withdrawals. Do the same for checks, card payments, transfers and automatic debits. Unmatched checks in your books are outstanding. Unmatched items on the statement need to be recorded or investigated.
- Adjust the bank side. Statement ending balance + deposits in transit − outstanding checks = adjusted bank balance.
- Adjust the book side. Book balance − bank fees − returned payments + interest ± error corrections = adjusted book balance.
- Compare. The two adjusted balances must match to the cent. If they don't, keep looking. Don't plug the difference.
- Record the adjustments and sign off. Enter the book-side corrections, save the reconciliation report, and note the date and who did it.
Worked example: an auto repair shop's month-end reconciliation
Imagine a hypothetical independent auto repair shop closing out the month. The bank statement shows an ending balance of $18,420. The accounting software shows $19,400. They're $980 apart. Here's what the owner finds while matching.
Bank-side items
- Friday's card batch of $2,640 was recorded in the books but didn't hit the bank until Monday: deposit in transit, +$2,640.
- Check #1042 to a parts supplier for $1,250 hasn't cleared: outstanding, −$1,250.
- Check #1045 for $380 to the uniform service hasn't cleared: outstanding, −$380.
Adjusted bank balance: $18,420 + $2,640 − $1,250 − $380 = $19,430.
Book-side items
- Monthly service charge not yet recorded: −$35.
- A customer's $475 check bounced and the bank reversed it: −$475.
- A parts payment of $1,280 was keyed into the books as $1,820, overstating the expense by $540: +$540.
Adjusted book balance: $19,400 − $35 − $475 + $540 = $19,430.
The two sides match. The owner records the fee, reverses the bounced payment (and calls the customer), corrects the $1,820 entry to $1,280, and saves the report. The two checks and the card batch need no entry. They'll clear on their own next month, and if they don't, that's worth a phone call.
A trick for finding keying errors
Notice that the transposition error was $1,820 − $1,280 = $540, and $540 ÷ 9 = 60. When two digits get swapped, the difference is always divisible by 9. If your unexplained difference divides evenly by 9, look for a transposed number first. If the difference is exactly double some transaction, look for one recorded as a deposit that should have been a withdrawal, or the reverse.
How often should a small business reconcile?
Monthly is the minimum for almost everyone. Beyond that, it depends on volume, cash cushion and risk. Use this as a starting rule:
| Your situation | Suggested frequency | Why |
|---|---|---|
| Under about 100 transactions a month, healthy cash cushion | Monthly | Few enough items that a monthly pass is quick and catches problems in time. |
| Hundreds of transactions a month (retail, restaurants, e-commerce) | Weekly | A month of card batches, refunds and fees is painful to untangle all at once. |
| Cash is tight or you're making payroll decisions week to week | Weekly | You need to trust the balance you're making decisions from. |
| Several people can spend or move money | Weekly, reviewed by someone other than the spender | Faster detection of errors and unauthorized payments. |
| Any account (savings, payroll, credit cards, loans) | Monthly at minimum | Every account on the balance sheet should tie to a statement. |
Don't forget credit cards and loans. A credit card is reconciled the same way against its statement. A loan balance should match the lender's principal balance, which catches loan payments coded entirely to expense.
Reconciliation is also one of the simplest controls against theft. If the person who writes checks is also the only one who reconciles, errors and fraud can hide for months. See our guide to basic internal controls for how to split those duties even with a tiny team.
Common reconciliation mistakes
- Plugging the difference. Entering a "reconciliation adjustment" to force a match hides the real problem. Find the cause, even if it takes an extra hour.
- Reconciling to the live online balance. Live balances include pending items and change by the minute. Use the statement balance on a fixed date.
- Letting old outstanding items pile up. A check that's been outstanding for months may be lost or voided. Follow up with the payee rather than carrying it forever.
- Clicking "match" on bank feed suggestions without looking. Automatic matching is convenient but can pair a transaction with the wrong invoice or bill. Spot-check the matches, especially round amounts.
- Editing reconciled periods. Changing a transaction in a month you've already closed breaks next month's starting balance. Lock prior periods in your software if it allows.
- Skipping it because "the bank feed does it." A bank feed imports transactions. It doesn't prove your books are complete or correct.
Where AI can help
AI tools can speed up the tedious part. Export the bank statement and your book register for the month as spreadsheets and ask an AI assistant to list items that appear in one but not the other, group likely duplicates, and flag differences divisible by 9. It can also scan months of transactions for unusual payees, new recurring charges or payments just under your approval threshold.
Treat its list as a starting point. You still need to confirm each match against the actual statement, decide what each adjustment should be and sign off. And be thoughtful about what financial data you upload to any tool.
Frequently asked questions
What's the difference between bank reconciliation and bookkeeping?
Bookkeeping is recording transactions. Reconciliation is checking that what you recorded matches reality. You need both, and reconciliation is the step that makes the rest of your numbers trustworthy. Our bookkeeping basics guide shows where it fits in a simple monthly routine.
How long should a bank reconciliation take?
For a small business with clean books and a bank feed, a monthly reconciliation often takes under an hour. If it regularly takes much longer, that usually points to messy categorization, many uncleared items or a process that needs fixing upstream.
What should I do if I find a transaction I don't recognize?
Check with anyone who has access to the account first. If nobody can explain it, contact your bank right away, because the time to dispute unauthorized transactions can be limited. Fake invoice and payment-diversion scams often show up this way, as our explainer on business email compromise describes.
Can I skip reconciling if I use cash-basis accounting?
No. Cash-basis books depend even more directly on the bank, so an unreconciled account means your income and expenses may be wrong too. Your accountant will almost certainly want reconciled accounts before preparing a tax return.
Key takeaways
- A bank reconciliation matches your book balance to the bank statement and explains every difference.
- Adjust both sides: the bank side for timing items, the book side for fees, returns and errors.
- Reconcile at least monthly, and weekly if you have high volume, tight cash or several people spending.
- Never plug a difference. Differences divisible by 9 often mean a transposed number.
- Reconcile credit cards and loans too, not just checking.
- Have someone other than the person who spends review the reconciliation whenever possible.
Comments
Post a Comment