A client came to me after discovering they’d been double-charged by a vendor for six consecutive months—a total of $12,000 in duplicate payments.
The charges showed up on their bank statement every month. But they never reconciled their accounts, so they never noticed.
By the time they caught it, the vendor had gone out of business. The money was gone.
After 30+ years of bookkeeping, I can tell you that not keeping reconciliations up to date is the #1 mistake I see small business owners and new bookkeepers make. Skip monthly reconciliation and you’re flying blind—hemorrhaging money through duplicate charges, missing deposits, and accounting errors that compound every month.
Let me show you exactly how to reconcile your accounts properly so you catch problems before they cost you thousands.
What Bank Reconciliation Actually Does
Reconciliation ensures that every transaction that hit your bank account is recorded in QuickBooks—nothing missing, nothing duplicated.
The process verifies:
- All deposits that cleared your bank are in QuickBooks
- All payments and charges are recorded
- Nothing has been entered twice
- Nothing has been missed
- Your QuickBooks balance matches your actual bank balance
Think of it as: Comparing your checkbook register to your bank statement. They should match perfectly.
The Real Cost of Skipping Reconciliation
Problem #1: Duplicate Charges Go Unnoticed
Real example: My client was being billed twice monthly for their software subscription—$2,000 per charge. They didn’t reconcile for six months.
Result: $12,000 in duplicate charges. Vendor out of business. Money unrecoverable.
If they’d reconciled monthly: They would have caught it after one month and recovered $10,000.
Problem #2: Missing Deposits
A contractor deposited a $15,000 check from a client but never recorded it in QuickBooks. Three months later, they couldn’t figure out why their bank balance was $15,000 higher than QuickBooks showed.
Without reconciliation: You don’t know if that discrepancy is a missing deposit, a recording error, or something else entirely.
Problem #3: Fraudulent Charges
Employee embezzlement often goes undetected for months when businesses don’t reconcile regularly.
Common scenario: Employee has access to company credit card, makes small unauthorized charges ($50-$200), bets you won’t notice.
Without monthly reconciliation: By the time you catch it, thousands are gone.
Problem #4: Inaccurate Financial Reports
If your QuickBooks doesn’t match your bank, every financial report is wrong:
- Profit & Loss statements
- Cash flow projections
- Balance sheets
- Tax calculations
You’re making business decisions based on inaccurate data.
Problem #5: Tax Nightmares
Come tax time, if your books don’t reconcile, your CPA will charge premium rates to clean up the mess—or refuse to prepare your return until you fix it.
I’ve seen CPA cleanup fees exceed $5,000 for businesses that didn’t reconcile all year.
The Bank Reconciliation Process (Step-by-Step)
Before You Start: Clear Your Bank Feed
Critical first step: Make sure all transactions in your bank feed are categorized and cleared.
Reconciliation compares your recorded QuickBooks transactions to your bank statement. If you haven’t categorized bank feed transactions yet, you can’t reconcile.
(Reference the bank feed video if you need help with this step.)
Step 1: Access Reconciliation
Go to Accounting → Reconcile in QuickBooks.
Step 2: Select the Account
Use the dropdown to choose the account you’re reconciling (checking, savings, credit card, loan).
Step 3: Enter Statement Information
Input two critical pieces of information:
- Ending balance: The final balance on your bank statement
- Statement ending date: The date your statement covers (e.g., 12/31/2024)
QuickBooks checks: The system automatically verifies that all bank feed transactions are cleared. If there are transactions still pending in your bank feed, QuickBooks warns you to go back and clear those first.
Step 4: Start Reconciling
Click Start reconciling to open the reconciliation screen.
Step 5: Check Off Each Transaction
Now comes the verification work. Go through your bank statement line by line:
- Find each transaction on your statement
- Locate it in the QuickBooks reconciliation screen
- Verify the amount matches exactly
- Check the box on the right side
Repeat for every single transaction.
What you’re doing: Confirming that every transaction in QuickBooks actually cleared your bank, and vice versa.
Step 6: Watch the Difference Balance
At the top of the screen, you’ll see a “Difference” field.
As you check off transactions, this number should decrease toward zero.
When difference = $0.00: Your QuickBooks records match your bank statement perfectly.
If difference ≠$0.00: Something’s wrong. You have missing transactions, duplicates, or errors.
Step 7: Investigate Any Unchecked Items
After checking all transactions on your statement, scan the reconciliation screen.
Anything still unchecked falls into two categories:
- Outstanding checks: Checks you wrote that haven’t cleared the bank yet (normal)
- Errors: Transactions in QuickBooks that never hit the bank (problems)
If you see unchecked items that aren’t outstanding checks, investigate:
- Was the transaction entered twice in QuickBooks?
- Did you record something that never actually happened?
- Is the amount wrong?
Step 8: Finish the Reconciliation
Once your difference is zero and you’ve verified everything, click Finish.
QuickBooks confirms: “You’ve reconciled your account.”
Click Done.
Your reconciliation is complete. The ending date updates to show the period you just reconciled.
What a Zero Difference Means
Difference = $0.00 is your goal every single time.
This confirms:
- Every transaction on your bank statement is in QuickBooks
- Every transaction in QuickBooks that should have cleared did clear
- Nothing is missing
- Nothing is duplicated
- Your records are accurate
If you can’t get to zero: Don’t force it. Something is wrong, and you need to find it.
Common Reconciliation Problems (And Solutions)
Problem: Difference Won’t Go to Zero
Possible causes:
- Transaction entered in QuickBooks but never cleared the bank (or entered incorrectly)
- Bank transaction that wasn’t recorded in QuickBooks
- Amount entered wrong (typo in QuickBooks)
- Transaction entered twice
Solution: Compare your QuickBooks transactions to your bank statement line by line until you find the discrepancy.
Problem: Transaction in QuickBooks But Not on Bank Statement
Possible causes:
- Check hasn’t cleared yet (normal for outstanding checks)
- Transaction was voided or reversed
- You entered it incorrectly (wrong date, wrong amount)
Solution: If it’s not an outstanding check, investigate and correct or delete.
Problem: Bank Statement Shows Transaction Not in QuickBooks
This is serious. A transaction cleared your bank but you never recorded it.
Possible causes:
- Bank fee you didn’t record
- Automatic payment you forgot about
- Deposit that never got entered
- Fraudulent charge
Solution: Create the missing transaction in QuickBooks with the correct date and amount.
Problem: Amounts Don’t Match
You find the transaction on both sides, but the amounts are different.
Example: QuickBooks shows $150, bank statement shows $155.
Solution: Edit the QuickBooks transaction to match what actually cleared the bank. Add a note explaining the discrepancy if needed.
Best Practices for Reconciliation
1. Reconcile Monthly (Minimum)
Reconcile every single account every month:
- All checking accounts
- All savings accounts
- All credit cards
- All loans
Why monthly: The longer you wait, the more transactions accumulate, and the harder it is to find discrepancies.
2. Reconcile Shortly After Month-End
Don’t wait until the 25th of the next month. Reconcile within the first week after your statement closes.
Why: Problems are fresh in your mind, and you can fix them quickly.
3. Never Force a Reconciliation
If the difference won’t go to zero, do not create adjusting entries to force it.
Find the actual problem and fix it properly.
4. Save Reconciliation Reports
After finishing each reconciliation, save or print the reconciliation report.
Why: If you need to go back and verify what was reconciled, you have documentation.
5. Investigate Every Discrepancy
Don’t dismiss small differences. A $5 discrepancy is just as important to fix as a $5,000 one.
Why: Small errors indicate process problems that could lead to big errors later.
The Bottom Line
Monthly bank reconciliation is not optional—it’s the difference between knowing your true financial position and guessing.
What reconciliation catches:
- Duplicate charges costing thousands
- Missing deposits
- Fraudulent transactions
- Bank fees eating into profits
- Accounting errors before they compound
Take action today:
- Check when you last reconciled each account
- If it’s been more than 30 days, reconcile immediately
- Set a monthly reminder to reconcile within one week of month-end
The business owner who skipped reconciliation lost $12,000 in duplicate charges. The business owner who reconciles monthly catches problems while they’re still fixable.
Which one will you be?