What reconciliation means and why QuickBooks makes it easier
Reconciliation is the process of comparing what QuickBooks says is in your checking account against what your bank says is in it, then explaining any differences. Most of the time the two match. When they don't, reconciliation helps you find out why — usually a check that hasn't cleared yet, a deposit the bank recorded on a different date than you did, or a fee you forgot to enter.
QuickBooks walks you through this step by step. You tell it what your bank statement says your balance is, and it shows you which transactions in QuickBooks match transactions on your statement. Anything that doesn't match gets flagged so you can investigate. Once everything lines up, your QuickBooks balance and your bank balance are the same, and you know your records are accurate.
The reconciliation process usually takes 10 to 20 minutes if your account is already connected to QuickBooks through your bank's link. If you're entering transactions manually, it may take longer because you'll need to match more items by hand.
Key Takeaways
- Start reconciliation by logging into your bank's website or app, finding your statement, and noting the ending balance — this is the number QuickBooks needs to match.
- In QuickBooks, go to the Reconcile tool for your checking account and enter that ending balance, then let QuickBooks show you which transactions cleared.
- Mark each transaction that appears on your bank statement as cleared in QuickBooks; transactions not yet cleared (like mailed checks) stay unmarked.
- When your QuickBooks balance matches your bank balance, the reconciliation is complete and you can save it.
- If the balances don't match, QuickBooks shows you the difference amount, which helps you track down missing or incorrectly dated transactions.
Gather your bank statement before you start
Log into your bank's website or mobile app and pull up your most recent checking account statement. You need the ending balance — the total the bank says you have at the end of that statement period. Write this number down or keep it visible on another screen while you work in QuickBooks.
You'll also want to look at the list of transactions on that statement. Note any that look unusual or that you don't remember entering into QuickBooks. These are often the culprits when balances don't match.
Open the Reconcile tool and enter your bank's ending balance
In QuickBooks, find the Reconcile option. The exact location depends on which version you use — in QuickBooks Online, it's usually under the Banking menu or in the left sidebar. In QuickBooks Desktop, look for it under the Banking menu at the top.
Select your checking account from the list. QuickBooks will ask you for the ending balance from your bank statement — this is the number you just wrote down. Enter it exactly as it appears on your statement, including cents. QuickBooks will also ask for the statement date; use the date printed on your statement.
If your account is linked to your bank, QuickBooks may have already pulled in the ending balance and statement date automatically. Double-check that both are correct before moving forward.
Mark transactions as cleared one by one
QuickBooks will now show you a list of all the transactions in your checking account. Your job is to go through your bank statement and mark each transaction as cleared — meaning it actually appears on the bank's statement.
Start with the oldest transactions. Look at your bank statement and find the first check, deposit, or other transaction listed. Then find that same transaction in QuickBooks and click the checkbox next to it to mark it cleared. Move to the next transaction on the bank statement and repeat.
Transactions that appear in QuickBooks but not yet on your bank statement — like a check you mailed last week that hasn't cleared — should stay unchecked. These will clear in the next reconciliation period.
If your account is linked to your bank, QuickBooks may have already marked many transactions as cleared automatically. You still need to review them to make sure they're correct, but you won't have to click each one individually.
Handle transactions that don't match
As you mark transactions cleared, watch for items on your bank statement that don't appear in QuickBooks at all. These are usually bank fees, interest deposits, or automatic payments you forgot to record. You'll need to add these to QuickBooks before reconciliation can finish.
Click the button to add a new transaction (usually labeled "Add" or a plus sign), enter the details from your bank statement, and save it. Then mark it as cleared. Common items to watch for include monthly maintenance fees, overdraft fees, ATM fees, and interest earned.
If you see a transaction in QuickBooks that's not on your bank statement, leave it unchecked. It will likely appear on next month's statement. If it's very old — more than 60 days — you may need to investigate whether the check was lost or the payment was cancelled.
Finish reconciliation when balances match
As you mark transactions cleared, QuickBooks shows you a running total. When the QuickBooks balance matches your bank's ending balance exactly, the reconciliation is complete. Click the button to finish or save the reconciliation.
QuickBooks will confirm that reconciliation is done and may show you a summary of what cleared. Keep this summary for your records — it's proof that your accounts matched on that date.
If the balances still don't match, QuickBooks will show you the difference amount. This number is your clue: it tells you how much is missing or extra. If the difference is $50, for example, look for a $50 transaction you may have missed or entered incorrectly.
What to do if the balances won't match
Start by checking your math. Make sure you entered the bank's ending balance correctly — a single digit wrong will throw everything off. Then scroll through the QuickBooks transaction list again and look for any you might have missed.
Check the dates carefully. Sometimes a transaction clears on a different date than you entered it. If you recorded a deposit on the 15th but the bank didn't process it until the 17th, it won't show up on the 15th's statement. Look at the bank statement dates, not the dates you used.
Look for duplicate transactions. If you entered a check twice by accident, or if QuickBooks imported a transaction from your bank link and you also entered it manually, you'll have it listed twice. Find and delete the duplicate.
If you still can't find the problem, you can save the reconciliation as incomplete and come back to it later. QuickBooks will remember which transactions you marked as cleared. Sometimes the missing item appears on the next statement, which makes it easier to spot.
Frequently Asked Questions
Can I reconcile a month that's not the most recent one?
Yes, but QuickBooks works best if you reconcile in order — finish last month before starting this month. If you skipped a month, go back and reconcile it first. This keeps your running balance accurate and makes future reconciliations easier.
What if I reconciled but then realized I made a mistake?
You can undo a reconciliation in QuickBooks and start over. The exact steps depend on your version, but look for an "Undo" or "Unreconcile" option in the Reconcile menu. This puts all your transactions back to unmarked status so you can try again.
Do I have to reconcile every month?
Monthly reconciliation is the standard practice because it catches errors early and keeps your records accurate. If you reconcile less often, errors pile up and become harder to find. Even if you're busy, reconciling quarterly is better than not at all.
Why does QuickBooks show a different balance than my bank app?
Usually because of timing. Checks you mailed take days to clear, and deposits you made may not show up when ready. QuickBooks shows what you've recorded; your bank shows what's actually cleared. Reconciliation explains the difference and proves both are correct.
What if a transaction is on my bank statement but I don't want to record it in QuickBooks?
You still need to mark it as cleared during reconciliation so your balances match. If it's a bank fee or charge you disagree with, you can mark it cleared, then contact your bank to dispute it separately. Reconciliation is about matching records, not about deciding which transactions are valid.