How often should I reconcile my bank account in QuickBooks?

Every month, without exception. Reconcile as soon as your bank statement is available — usually within the first week of the following month. The longer you wait, the harder it becomes to find errors.

What if I've never reconciled and I'm months behind?

Start from the earliest unreconciled month and work forward. It's tedious but necessary. If you're more than 3–4 months behind, a QuickBooks cleanup service can get you current much faster than doing it yourself.

Can I undo a reconciliation in QuickBooks Online?

Yes, but it should be done carefully. Go to Accounting → Reconcile → History by Account, find the reconciliation, and click Undo. This will unmark all transactions from that period. Only undo if you have a specific error to fix.

What's the difference between "cleared" and "reconciled" in QuickBooks?

"Cleared" means the transaction has been matched to your bank statement but the reconciliation isn't finished yet. "Reconciled" means the full reconciliation was completed and the difference was $0.00. Reconciled transactions are locked and harder to accidentally edit.

My beginning balance is wrong — what happened?

A wrong beginning balance usually means someone edited or deleted a previously reconciled transaction. Go to Accounting → Reconcile → History by Account to see your reconciliation history and identify which period has the discrepancy.

Do I need to reconcile credit cards too?

Yes. Any account connected to QuickBooks — checking, savings, credit cards, lines of credit — should be reconciled monthly against its statement. Credit card reconciliation works the same way as bank reconciliation.

How to Reconcile QuickBooks Online — Step-by-Step Bank Reconciliation Guide

Why Bank Reconciliation Matters

Reconciling your bank account in QuickBooks Online means matching every transaction in your QuickBooks register to your actual bank statement. It's the process that confirms your books are accurate — that what QuickBooks says happened actually happened.

If you skip reconciliation, errors and duplicates pile up undetected. Your Profit & Loss report becomes unreliable. Your tax return may be wrong. And when you finally do try to reconcile, you're facing months of tangled transactions instead of one clean month.

ProAdvisor Tip

Reconcile every single month — ideally within the first week after your statement closes. The longer you wait, the harder it gets to find errors. Monthly reconciliation takes 15–30 minutes. Annual catch-up takes days.

What You Need Before You Start

Your Bank Statement

The official statement from your bank for the period you're reconciling. You need the ending date and ending balance.

QuickBooks Online Access

15–30 Minutes

For a well-maintained account. If you're behind, budget more time per month you're catching up.

Attention to Detail

Go line by line. Don't rush. One missed transaction is all it takes to end up with a non-zero difference.

The 6-Step Reconciliation Process

Gather Your Bank Statement

Before you open QuickBooks, have your bank statement ready — either printed or open in another browser tab. You'll need two key pieces of information: the statement ending date and the ending balance. These must match exactly what you enter in QuickBooks.

Tip: Use the statement from your bank's website for the most accurate ending balance. Avoid using your current balance — it changes daily.

Open the Reconcile Tool in QuickBooks Online

In QuickBooks Online, navigate to Accounting in the left sidebar, then click Reconcile. If you don't see Accounting, go to the gear icon (Settings) → Chart of Accounts, then look for the Reconcile option at the top right.

Tip: You can also search "Reconcile" in the QuickBooks search bar at the top of the screen.

Select Your Account & Enter Statement Details

From the dropdown, select the bank account you want to reconcile. Enter the Ending Balance exactly as it appears on your bank statement. Enter the Ending Date (the last day of your statement period). Then click Start Reconciling.

Tip: Reconcile one account at a time. Start with your main checking account before moving to savings or credit cards.

Match Transactions to Your Statement

QuickBooks will display all uncleared transactions for that account. Go through your bank statement line by line and check off each matching transaction in QuickBooks. The "Difference" counter at the top right will update as you check items off. Your goal is to reach $0.00.

Tip: Work top to bottom on your bank statement — don't jump around. This reduces the chance of missing a transaction.

Investigate Any Difference

If the Difference doesn't reach $0.00, stop and investigate before finishing. Common causes: a transaction entered twice (duplicate), a bank fee or interest charge not recorded in QuickBooks, a transaction amount typed incorrectly, or a transaction on the statement that hasn't been entered yet.

Tip: Never click "Finish Now" with a non-zero difference. QuickBooks will create a reconciliation discrepancy entry that's hard to undo.

Finish the Reconciliation

Once the Difference shows $0.00, click Finish Now. QuickBooks will mark all checked transactions as cleared and generate a Reconciliation Report. Save or print this report — it's your proof that the reconciliation was completed correctly.

Tip: Store your reconciliation reports in a dedicated folder (digital or physical) for each month. Your CPA will thank you at tax time.

Troubleshooting: When the Difference Isn't $0.00

A non-zero difference is the most common reconciliation problem. Here are the most frequent causes and how to fix each one:

Duplicate Transaction

Cause: The same transaction was entered manually AND imported via bank feed.

Fix: Search for the transaction amount in QuickBooks. If you see it twice, delete the duplicate. Then re-run the reconciliation.

Missing Bank Fee or Interest

Cause: Your bank charged a fee or paid interest that wasn't recorded in QuickBooks.

Fix: Add the missing transaction directly from the reconciliation screen using the "Add" button. Categorize it correctly (Bank Charges or Interest Income).

Wrong Amount Entered

Cause: A transaction was typed incorrectly — e.g., $1,200 entered as $1,020.

Fix: Find the transaction in QuickBooks and correct the amount. The difference will often equal the exact error amount.

Transaction Not Yet in QuickBooks

Cause: A check or payment appears on the bank statement but hasn't been entered in QuickBooks yet.

Fix: Enter the missing transaction in QuickBooks, then return to reconciliation and check it off.

Previously Reconciled Transaction Edited

Cause: Someone changed or deleted a transaction that was already reconciled in a prior month.

Fix: Go to Accounting → Reconcile → History by Account to find the affected period. This is a more complex fix — consider getting professional help.

When to Get Professional Help

Some reconciliation problems are straightforward. Others — especially those involving months of unreconciled history or edited prior-period transactions — require a professional to untangle without making things worse.

You're more than 3 months behind on reconciliation

Your beginning balance doesn't match the prior month's ending balance

You've been clicking "Finish Now" with a non-zero difference

Your bank balance and QuickBooks balance are off by thousands

You've never reconciled since setting up QuickBooks

Your books need to be ready for a CPA or tax filing

LedgerCore Solutions specializes in QuickBooks cleanup and catch-up reconciliation for small businesses. We can get months of unreconciled books current — usually within 1–2 weeks.

Get a Free Cleanup Consultation