What reconciliation means and why it matters

Reconciliation is the process of matching the transactions QuickBooks shows in your checking account against the transactions your bank shows. When you reconcile, you're confirming that QuickBooks and your bank agree on what money came in, what went out, and what the balance is on a specific date—usually the date of your bank statement.

The reason this matters: errors happen. A check you wrote might not have cleared yet. A deposit might be pending. Your bank might charge a fee you forgot to record. A transaction might post on different dates in QuickBooks and at the bank. Reconciliation catches these gaps before they throw off your financial picture.

In QuickBooks Online, reconciliation is built into the bank connection itself. Once your bank account is linked, QuickBooks pulls in transactions automatically, and you verify them one by one against your bank statement. If everything matches, your books are accurate. If something doesn't match, you'll see it when ready and can fix it.

Key Takeaways

  • Reconciliation compares what QuickBooks shows versus what your bank statement shows, and it happens in the Banking section under the account name.
  • You'll match each cleared transaction from your bank statement to a transaction in QuickBooks, marking it as reconciled.
  • Transactions that haven't cleared yet (like checks still in the mail) stay unreconciled until your bank shows them.
  • If your ending balance in QuickBooks doesn't match your bank statement ending balance, QuickBooks will show you the difference so you can find the missing transaction.
  • You reconcile once per statement period—usually monthly—using your bank statement as the source of truth.

Where to find the reconciliation tool in QuickBooks Online

Open QuickBooks Online and go to the Banking section on the left sidebar. You'll see a list of all your connected bank accounts. Find the checking account you want to reconcile and click on it. You should see a button or link that says Reconcile or Start Reconciliation—the exact wording varies depending on whether you've reconciled this account before.

If you don't see a Reconcile button, your account may not be linked to your bank yet, or the connection may have broken. Check that your bank login credentials are still active and that your bank hasn't changed its security settings. If the connection is live, the Reconcile option will appear.

The step-by-step reconciliation process

When you click Reconcile, QuickBooks will ask you for two pieces of information from your bank statement: the statement ending date and the statement ending balance. Enter both exactly as they appear on your statement. These are the numbers you're trying to match.

QuickBooks will then show you a list of all transactions it has recorded in that account since your last reconciliation. Each transaction has a checkbox next to it. Go through your bank statement line by line and check off each transaction that appears on the statement. Ignore transactions that haven't cleared yet—those will show up on next month's statement.

As you check off transactions, QuickBooks keeps a running total at the bottom of the screen. It shows your current reconciled balance and compares it to the statement ending balance you entered. When those two numbers match, you're done. Click Finish Reconciliation and QuickBooks locks that statement period so you can't accidentally change it later.

If the balances don't match, QuickBooks will tell you the difference. For example, if your statement shows $5,000 but QuickBooks shows $4,950, there's a $50 gap. This usually means one of three things: a transaction is missing from QuickBooks, a transaction in QuickBooks hasn't hit the bank yet, or a transaction amount is wrong in one place or the other.

What to do when balances don't match

Start by looking for the missing amount in your bank statement. If your statement shows a fee, interest, or a deposit you didn't record in QuickBooks, that's your culprit. Add that transaction to QuickBooks and try reconciling again.

If you find a transaction in QuickBooks that isn't on your statement yet, leave it unchecked. It will reconcile next month when the bank processes it. This is normal for checks you've written but haven't cleared, or deposits you've made but haven't posted.

If you find a transaction that appears in both places but with different amounts, edit the QuickBooks transaction to match the bank statement. The bank statement is always the source of truth—if there's a discrepancy, the bank's version is correct.

Once you've found and fixed the problem, try reconciling again. The balances should now match, and you can finish.

Handling outstanding checks and pending deposits

An outstanding check is a check you wrote and recorded in QuickBooks, but the person you wrote it to hasn't cashed it yet. It won't appear on your bank statement until they do. Don't check it off during reconciliation—leave it unchecked. It will reconcile on next month's statement when the bank clears it.

A pending deposit works the same way. You recorded it in QuickBooks, but the bank hasn't processed it yet. Leave it unchecked. Once the bank shows it, you'll check it off next month.

This is why your QuickBooks balance and your bank balance can be different on the same day. QuickBooks shows what you've recorded; the bank shows what has actually cleared. Both are correct—they're just measuring different things. Reconciliation proves that both are tracking the same transactions, just on different timelines.

What happens after you finish reconciliation

Once you click Finish Reconciliation, QuickBooks marks all the checked transactions as reconciled and locks that statement period. You can still view the reconciliation history, but you can't change the reconciled transactions without unreconciling them first—which requires a reason and creates an audit trail.

This lock is a safeguard. It prevents accidental changes to transactions you've already verified against your bank statement. If you need to change a reconciled transaction later (for example, you discover a duplicate or an error), you can do it, but QuickBooks will track the change and ask you to re-reconcile that statement period.

For your next statement period, repeat the process. Go back to the Banking section, click Reconcile on the same account, and enter the new statement ending date and balance. QuickBooks will show you only the transactions since your last reconciliation, making the process faster each time.

Common mistakes to avoid

Don't reconcile to your current account balance. Reconcile to your bank statement balance—the number at the end of the statement period, not today's balance. Your bank statement is a snapshot of a specific date. Use that date and that balance.

Don't assume a transaction is wrong just because it doesn't match. Check the date, the amount, and the description carefully. A transaction might be correct but posted on a different date in QuickBooks than at the bank. That's normal and doesn't mean anything is wrong.

Don't reconcile more than one statement period at a time. Reconcile one month, finish it, then move to the next. Jumping around or trying to reconcile multiple periods at once creates confusion and makes it harder to find errors.

Don't ignore small differences. A $1 discrepancy is still a discrepancy. Find it and fix it. Small errors compound, and a $1 mistake this month becomes a $12 discrepancy by year-end.

Frequently Asked Questions

Can I reconcile a statement from months ago if I skipped it?

Yes. Go to the Banking section, click on the account, and look for a link to view past reconciliations or start a new one. You can reconcile any statement period, even if you're several months behind. Start with the oldest statement and work forward. Each reconciliation builds on the previous one, so doing them in order matters.

What if I can't find a transaction on my bank statement?

Leave it unchecked in QuickBooks. It will show up on next month's statement, or it may never clear (which sometimes happens with pending transactions that expire). If a transaction is more than 30 days old and still hasn't appeared, contact your bank to confirm it was processed. If it wasn't, delete it from QuickBooks.

Do I have to reconcile every month?

You should reconcile at least once per statement period to catch errors early. Monthly reconciliation is standard. If you reconcile less often, errors pile up and become harder to track down. If you reconcile more often (weekly or bi-weekly), you'll catch problems faster, but it takes more time.

What if QuickBooks and my bank disagree on a transaction amount?

Trust the bank. Edit the transaction in QuickBooks to match what the bank shows. The bank's record is the official one. Once you've corrected it, reconcile again and the balances should match.

Can I undo a reconciliation after I finish it?

Yes, but it's not automatic. In the Banking section, find the reconciliation history for that account and look for an option to unreconcile. QuickBooks will ask you why you're unreconciling (to create an audit trail). Once you unreconcile, you can change the transactions and reconcile again. Avoid this if possible—it's better to get it right the first time.