Your QuickBooks dashboard says you have $14,200 in the bank. Your bank app says $11,850. One of them is wrong, and until you know which, every decision you make about payroll, inventory, or that new piece of equipment is a guess. Reconciling is how you close that gap. It sounds like an accountant's chore… but it's really just the monthly habit of making sure your books tell the truth.
Here's how to do it, step by step, and what to do when the numbers won't line up.
What reconciling actually means
Reconciling is comparing the transactions in QuickBooks to your bank or credit card statement for the same period, and confirming they match. When you finish, the ending balance in QuickBooks equals the ending balance on your statement, and every transaction has been checked off.
It catches things like:
- Duplicate transactions from bank feeds
- Payments recorded in QuickBooks that never cleared
- Bank fees or interest you forgot to enter
- Deposits recorded twice or not at all
- Typos in amounts
Before you start
Gather two things:
- Your bank statement for the month, either PDF or paper
- A few quiet minutes
Also make sure you've reviewed and categorized everything in your bank feed for that month. Reconciling with a pile of unreviewed transactions just creates more work.
Step-by-step: reconciling in QuickBooks Online
Menu names shift a little between versions, but the flow is the same.
- Open the reconcile tool. In QuickBooks Online, it's usually found under the settings gear or the accounting menu, labeled "Reconcile."
- Choose the account. Pick the bank or credit card account you're reconciling.
- Enter statement details. Type the statement ending date and ending balance exactly as they appear on the statement.
- Check the beginning balance. QuickBooks shows a beginning balance. It should match the beginning balance on your statement. If it doesn't, stop and investigate before continuing. Something from a past period was changed.
- Match transactions. Go down the list and check off each transaction that appears on your statement. Work through payments and deposits separately if that's easier.
- Watch the difference. QuickBooks shows a "difference" amount. Your goal is zero.
- Finish. When the difference is zero, click to finish and save the reconciliation report.
When the difference isn't zero
This is where most people get stuck. Work through these checks in order:
Is the ending balance typed correctly? It sounds obvious, but a transposed digit is the most common cause.
Are there transactions on the statement that aren't in QuickBooks? Bank fees, interest, and small automatic charges are easy to miss. Add them.
Are there checked items that aren't on the statement? Uncheck anything that hasn't cleared yet, like a check you mailed on the 30th.
Is the difference an exact transaction amount? If the difference is $86.40 and you have an $86.40 charge, it's probably duplicated or missing.
Is the difference divisible by 9? That often points to two digits swapped, like $54 entered as $45.
Did the beginning balance change? If someone edited or deleted a transaction from a previous reconciled month, the starting point shifts. Look at the past reconciliation reports to find what changed.
How often to reconcile
Monthly, as soon as your statement is available. Reconciling twelve months at once in April is painful. Reconciling one month in fifteen minutes is not. If you have a lot of activity, some owners reconcile every two weeks using an online statement.
Do this for every account connected to QuickBooks: checking, savings, credit cards, and loan accounts if you track them.
A quick example
A small cleaning company reconciles its checking account for May. The statement ends at $8,420.15. After checking everything off, QuickBooks shows a difference of $15.00.
Looking at the statement, the owner spots a $15 monthly service fee that wasn't recorded. She adds it as a bank charge expense dated May 31, checks it off, and the difference drops to zero. Done in under twenty minutes.
Common mistakes to avoid
Forcing it to balance. Some owners enter an adjustment just to get to zero. That hides the real problem and can throw off future months. Find the cause instead.
Reconciling to the bank app instead of the statement. The app balance changes daily. Use the official statement ending balance and date.
Editing reconciled transactions. Once a month is reconciled, changing a transaction in it breaks future reconciliations. If you must change something, note why.
Skipping credit cards. Credit card accounts drift just as easily as checking accounts.
Accepting every bank feed match without looking. Bank feeds suggest matches. Most are right. Some aren't. A quick review prevents duplicates.
Make it a monthly habit
Put a recurring 30-minute appointment on your calendar a few days after each statement closes. Reconcile, save the report, and move on. Clean, reconciled books make tax time easier and give you numbers you can actually trust.
Learn the full monthly routine
Reconciling is one piece of a healthy bookkeeping routine. Our QuickBooks Mastery for Small Business course includes a full lesson on reconciliation, plus bank feeds, bank rules, invoicing, expenses, and the core reports that tell you how your business is really doing.