What reconciliation means and why QuickBooks makes it easier

Reconciliation is the process of matching the transactions QuickBooks shows in your checking account against the actual transactions your bank shows. When you reconcile, you're confirming that every deposit, withdrawal, and fee in QuickBooks is real and accounted for—and that nothing is missing or duplicated.

QuickBooks automates much of this work if your bank is connected through the app's linking feature. Instead of manually entering each transaction, QuickBooks pulls them directly from your bank and shows you which ones you've already recorded and which ones are new. You then tell QuickBooks which transactions match, and the software calculates whether your account balance is correct.

The reconciliation process catches errors before they compound—a missed fee, a duplicate entry, or a transaction that didn't clear the way you expected. Without it, your QuickBooks balance and your bank balance drift apart, making it hard to know how much money you actually have.

Key Takeaways

  • Reconciliation in QuickBooks compares your recorded transactions against your bank's records to find mismatches and errors.
  • If your bank is linked, QuickBooks automatically downloads transactions, and you match them by marking them as cleared in the reconciliation window.
  • The reconciliation process ends when your QuickBooks balance matches your bank statement balance exactly.
  • If balances don't match, QuickBooks shows you the difference amount, which helps you track down the missing or wrong transaction.
  • You can reconcile as often as you want—weekly, monthly, or whenever your bank statement arrives—but monthly is standard for most small businesses.

How to start a reconciliation in QuickBooks Online

Open QuickBooks Online and go to the Accounting menu on the left sidebar. Select Reconcile. QuickBooks will show you a list of your bank and credit card accounts. Click the account you want to reconcile—usually your checking account.

QuickBooks will ask you to enter the statement ending date (the date on your bank statement) and the ending balance (the total shown on your statement). You can find both at the top of your bank statement or in your online banking portal. Enter these numbers exactly as they appear.

Once you've entered the statement details, QuickBooks shows you two columns: one for deposits and one for withdrawals. Each transaction pulled from your bank appears with a checkbox next to it. Your job is to mark each transaction as cleared—meaning you've confirmed it's real and matches what's in QuickBooks.

Matching transactions and marking them cleared

QuickBooks displays transactions it has already downloaded from your bank. Look at your bank statement and check off each transaction in QuickBooks that appears on the statement. Most transactions will already be matched automatically if you've been recording them in QuickBooks as you go.

If a transaction appears on your bank statement but not in QuickBooks, you'll need to add it manually. Click Add transaction and enter the details—the date, amount, and description. Then mark it as cleared. Common examples are bank fees, interest deposits, or automatic payments you forgot to record.

If a transaction appears in QuickBooks but not on your bank statement, leave it unchecked. It may be a recent transaction that hasn't cleared yet, or it could be an error. QuickBooks will flag it at the end of the reconciliation.

What to do when your balances don't match

At the bottom of the reconciliation window, QuickBooks shows your Cleared Balance (the total of all transactions you've marked cleared) and your Statement Balance (the ending balance from your bank statement). If these two numbers are the same, you're done—click Finish and the reconciliation is complete.

If the numbers don't match, QuickBooks shows you the difference. For example, if your cleared balance is $5,000 and your statement balance is $5,050, the difference is $50. This means either you've missed marking a $50 transaction as cleared, or you've recorded a transaction in QuickBooks that isn't on your bank statement.

Go back through your bank statement line by line and compare it to the transactions shown in QuickBooks. Look for transactions you may have missed or recorded with the wrong amount. Common culprits are outstanding checks (checks you wrote that haven't cleared yet), deposits in transit, and bank fees. Once you find and fix the error, the balances should match.

Handling outstanding checks and deposits in transit

An outstanding check is a check you wrote and recorded in QuickBooks, but the person or business you sent it to hasn't cashed it yet. It won't appear on your bank statement until it clears. Leave it unchecked in the reconciliation—QuickBooks will hold it separate and include it in your next reconciliation once it clears.

A deposit in transit works the same way: you recorded a deposit in QuickBooks, but your bank hasn't processed it yet. Leave it unchecked. Both of these are normal and expected. They explain why your QuickBooks balance may be higher or lower than your bank statement balance on any given day.

If an outstanding check or deposit in transit is more than a few weeks old, follow up. Call your bank to confirm the check cleared or the deposit posted. If it did, add it to your next reconciliation. If it didn't, you may need to reissue the check or investigate why the deposit didn't go through.

Reconciling a checking account that's never been reconciled

If you're reconciling for the first time or after a long gap, start with your oldest bank statement. Reconcile that month completely, even if it takes time to track down old transactions. This creates a solid foundation—once one month is correct, the next month's reconciliation is much faster.

For the first reconciliation, you may find transactions in QuickBooks that don't match any bank statement, or vice versa. Be thorough: check old emails for receipts, call your bank to confirm transactions, and review your QuickBooks records for duplicate entries. The goal is to get to zero difference, even if it means going back several months.

Once your first reconciliation is complete and balanced, mark that date in your records. From then on, reconcile monthly using the same process. Monthly reconciliation takes far less time than trying to catch up after months or years of drift.

Frequently Asked Questions

Can I reconcile a credit card account the same way as a checking account?

Yes. The process is identical—you enter the statement ending date and balance, mark transactions as cleared, and match your QuickBooks balance to your statement balance. Credit card reconciliation works the same way because you're still comparing QuickBooks records to your financial institution's records.

What if a transaction shows up twice in QuickBooks?

During reconciliation, you'll see the duplicate when you compare to your bank statement. Only one will appear on the bank statement, so leave the duplicate unchecked. After reconciliation, delete the duplicate transaction from QuickBooks to prevent it from causing problems in future reconciliations.

Do I have to reconcile every month?

No, but monthly is standard. You can reconcile weekly, quarterly, or whenever your bank statement arrives. More frequent reconciliation catches errors faster. Less frequent reconciliation means larger gaps to search if something is wrong, making the process harder.

What if my bank hasn't linked to QuickBooks yet?

You can still reconcile manually. Enter transactions into QuickBooks by hand, then follow the same reconciliation steps—enter your statement balance, mark transactions cleared, and match the totals. It takes longer because you're not pulling transactions automatically, but the reconciliation logic is the same.

Can I undo a reconciliation after I finish it?

Yes. Go back to the Reconcile menu, select the account, and click Undo next to the reconciliation you want to reverse. This unmarks all transactions as cleared so you can reconcile again. Use this if you realize you made an error after finishing.