If you’re a small business owner and the word “reconcile” makes your head spin, you’re not alone. Most non-accountants have no idea what bank reconciliation means, why it matters, or how to do it in QuickBooks Online (QBO).
The good news? It’s not complicated. Once you understand what it is and follow the steps below, you’ll be able to reconcile your bank account in QBO in under 30 minutes, even if you have zero accounting background.
What Is Bank Reconciliation?
Think of bank reconciliation as a matching exercise.
You have two places where your business transactions are recorded:
- Your bank statement — what your bank says happened (money in, money out)
- Your QuickBooks records — what you’ve recorded in your books
Bank reconciliation simply means comparing these two lists and making sure they match perfectly.
If your bank says you have $10,500 at the end of the month, your QuickBooks should say the same thing. If they don’t match, something is missing, duplicated, or entered incorrectly, and that’s a problem you need to fix.
Explore our service below:
- Federal Tax Compliance & Return Preparation in the USA
- Small Business Bookkeeping & Accounting in the USA
Why Does Bank Reconciliation Matter for Small Businesses?
Many small business owners skip reconciliation and only look at their bank balance to understand their finances. This is a costly mistake.
Here’s why reconciliation is non-negotiable:
- Catches errors early. Duplicate charges, wrong amounts, or unauthorized transactions get spotted fast.
- Prevents tax problems. When your books don’t match your bank, your profit and loss report is wrong — and so is your tax return.
- Gives you an accurate picture of cash flow. You can’t make smart business decisions based on wrong numbers.
- Makes audits and loan applications easy. Clean, reconciled books = trust from banks, investors, and the IRS.
- Protects against fraud. Regular reconciliation catches if someone is making unauthorized charges to your account.
Most bookkeepers and accountants recommend reconciling every single month. The longer you wait, the messier it gets.
Before You Start: What You’ll Need
Before logging into QuickBooks Online, grab these two things:
- Your bank statement for the month you’re reconciling. This can be a PDF from your bank’s website or a printed copy. You need the:
- Statement ending date
- Ending balance (the final balance shown on the statement)
- Access to your QuickBooks Online account. You’ll need either the Essentials, Plus, or Advanced plan. All three include bank reconciliation.
That’s it. You’re ready.
Step-by-Step: How to Reconcile a Bank Account in QuickBooks Online
Step 1: Go to the Reconcile Screen
- Log in to your QuickBooks Online account
- Click on Accounting in the left menu
- Select Reconcile from the dropdown
If you don’t see “Accounting” in the left sidebar, click the menu icon (three horizontal lines) at the top left to expand it.
Step 2: Select Your Account
You’ll see a screen that says “Which account do you want to reconcile?”
- Click the dropdown under Account and select the bank account you want to reconcile (for example: “Business Checking”)
- Make sure you’re reconciling one account at a time
Tip: If you have multiple accounts (checking, savings, credit card), reconcile them separately — one at a time.
Step 3: Enter Your Statement Information
This is where you pull out your bank statement.
You’ll need to fill in two fields:
- Beginning Balance — QuickBooks will auto-fill this. It should match the opening balance on your bank statement. If it doesn’t match, stop here and contact your bookkeeper — there may be an error from a previous month.
- Ending Balance — Type in the closing balance from your bank statement (the final number shown on the statement for that month)
- Ending Date — Enter the last day of your bank statement (for example: 05/31/2026)
Click Start Reconciling when done.
Step 4: Match Transactions
Now you’re on the main reconciliation screen. This is where the actual matching happens.
You’ll see two columns:
- Deposits and Other Credits (money coming IN)
- Payments and Other Debits (money going OUT)
Your job is to check off every transaction that appears on both your bank statement AND in QuickBooks.
Here’s how to do it:
- Look at your bank statement line by line
- Find the matching transaction in QuickBooks
- Click the checkbox next to it to mark it as cleared
- Move to the next transaction and repeat
As you check off transactions, watch the Difference amount at the bottom right of the screen. Your goal is to get that number to $0.00.
What does “cleared” mean? A cleared transaction has actually gone through your bank — the money has officially moved. Uncleared transactions are things you’ve entered in QuickBooks but haven’t shown up in your bank yet (like a check you mailed that hasn’t been cashed).
Step 5: Deal With Transactions That Don’t Match
This is where most beginners get stuck. Don’t panic, here are the most common reasons things don’t match and what to do:
A transaction is in QBO but not on the bank statement. This usually means it’s a transaction that hasn’t cleared yet (a check still being processed, for example). Leave it unchecked for now. It will show up next month.
A transaction is on the bank statement but not in QBO. This means it hasn’t been entered in QuickBooks yet. You need to add it. Click Add next to the transaction (if it was imported via bank feeds) or manually enter it.
The amounts don’t match. Maybe you entered $150, but the bank shows $105. Click on the transaction in QBO to edit and correct the amount.
There’s a duplicate transaction. Sometimes transactions get entered twice. Delete the duplicate, then match the remaining one.
Quick Tip: If you’re connected to bank feeds (where QBO automatically imports your bank transactions), most of these issues are already handled. Bank feeds dramatically reduce reconciliation time.
Step 6: Check the Difference Is Zero
At the bottom of the reconcile screen, you’ll see three numbers:
- Statement Ending Balance — what your bank statement shows
- Cleared Balance — what QuickBooks shows after you’ve checked off transactions
- Difference — the gap between the two
Your goal: Difference = $0.00
If the difference is zero, you’re done! Everything matches.
If it’s not zero, something is missing or wrong. Go back through your transactions carefully. Common culprits:
- A transaction you accidentally checked twice
- A transaction you missed
- A wrong amount was entered in QBO
- A bank fee or interest you forgot to record
Step 7: Click “Finish Now”
Once the difference is $0.00, click the Finish Now button.
QuickBooks will mark all checked transactions as “reconciled” and generate a reconciliation report automatically.
You’re done!
Step 8: Save or Print the Reconciliation Report
After finishing, QuickBooks gives you a Reconciliation Report. This is your proof that the books are correct.
To access it:
- Go to Accounting > Reconcile
- Click on History by account
- Find the month you just reconciled
- Click View report
Save this as a PDF or print it. It’s good practice to keep these reports for your records, especially at tax time.
What If You Can’t Get the Difference to Zero?
This happens to everyone, especially when you’re starting.
Here are a few things to check:
- Look for a transaction that equals the difference. If you’re off by $47.50, search QBO for any transaction with that exact amount. Chances are you missed it or it’s entered incorrectly.
- Check for bank fees. Banks often charge monthly fees, wire fees, or overdraft fees that are easy to miss. Make sure those are recorded in QBO.
- Check for opening balance issues. If your beginning balance in QBO doesn’t match the opening balance on your bank statement, a previous month’s reconciliation has an error. You’ll need to fix that month first.
- Call your bookkeeper. If you’ve checked everything and still can’t zero it out, don’t guess and don’t force it. Call a professional. Forcing a reconciliation with a wrong difference hides errors and makes future months worse.
How Often Should You Reconcile?
Monthly — every single month, no exceptions.
Most business owners reconcile within the first two weeks of the following month (once the bank statement is available). For example, reconcile May’s statement in the first two weeks of June.
If you’re behind by several months, start from the most recent month and work backwards, or hire a bookkeeper to do a catch-up reconciliation.
Can QuickBooks Auto-Reconcile for You?
Sort of. QuickBooks Online has a feature called Auto-Match that automatically matches imported bank transactions to existing QBO transactions. This makes reconciliation much faster because a lot of the matching is done before you even start.
But auto-reconciliation (where QBO finishes the reconciliation on its own) doesn’t exist. A human still needs to review, approve, and confirm the final reconciliation.
That’s actually a good thing; it means a real set of eyes is always on your books.
Common Mistakes to Avoid
| Mistake | Why It’s a Problem |
| Reconciling only at tax time | Errors pile up for 12 months — much harder to fix |
| Skipping the bank statement | Reconciling from memory leads to missed errors |
| Forcing a zero balance with a manual adjustment | Hides errors; causes bigger problems later |
| Mixing personal and business accounts | Makes reconciliation nearly impossible |
| Ignoring small differences | A $2 difference can indicate a bigger data entry issue |
Bank Reconciliation in QBO at a Glance
Here’s the entire process in 8 quick steps:
- Go to Accounting > Reconcile in QBO
- Select your bank account
- Enter the ending balance and ending date from your bank statement
- Check off transactions that appear on both your statement and in QBO
- Investigate and fix any transactions that don’t match
- Get the Difference to $0.00
- Click Finish Now
- Save the reconciliation report
Need Help With Your Books?
If reconciliation still feels overwhelming — or if you’re months behind and don’t know where to start, PennyWise Bookkeeping and Accounting Services in the USA can help.
We specialize in bookkeeping and accounting services for US and UK small businesses. In case you need a one-time cleanup or ongoing monthly bookkeeping, we’ll keep your books clean, reconciled, and tax-ready all year long.
Contact us at pennywiseusa to get started with a free consultation.