The reconciliation process in QuickBooks Online matches your bank's records against your own

Bank reconciliation in QuickBooks Online is the step where you confirm that the transactions QuickBooks recorded match what your actual bank statement shows. You're looking for differences — missing deposits, duplicate entries, fees you didn't record, or timing gaps where a check cleared later than you expected. QuickBooks walks you through this transaction by transaction, and the process usually takes 15 to 45 minutes depending on how many transactions you have and how organized your records are.

The goal is to reach a state called "reconciled," where your QuickBooks balance and your bank balance are identical. Until you do this, you won't know whether a discrepancy is a data entry mistake on your end, a bank error, or straightforward a timing issue. Most small business owners and freelancers reconcile monthly, right after the bank statement arrives.

Key Takeaways

  • Start reconciliation by opening your bank account in QuickBooks, clicking the reconcile button, and entering the ending balance from your bank statement.
  • QuickBooks shows you deposits and withdrawals side by side; you check off each one as you find it on your bank statement.
  • Unmatched transactions — ones in QuickBooks but not on the statement, or vice versa — stay unchecked until you investigate and fix them.
  • Once every transaction matches and your QuickBooks balance equals your bank balance, you mark the reconciliation complete and QuickBooks locks those transactions.
  • If you find a mistake after reconciliation is complete, you can undo it, fix the error, and reconcile again.

How to start a reconciliation in QuickBooks Online

Log into QuickBooks Online and go to the Accounting menu on the left sidebar. Click Reconcile. QuickBooks will ask you which account you want to reconcile — select the bank account that matches your bank statement. Then enter the ending balance from your bank statement (the number at the bottom of the statement that shows what you had on the last day of the month). QuickBooks also asks for the ending date, which should match the date on your statement.

You can also enter the service charges or interest your bank applied during the month, if any. QuickBooks will create entries for these automatically so your records stay accurate. Once you've entered this information, click Continue, and QuickBooks will show you a list of all the transactions it has recorded in that account.

Matching transactions to your bank statement

QuickBooks displays two columns: deposits and other credits on the left, withdrawals and debits on the right. Your bank statement lists the same transactions. Go through your statement line by line and find each transaction in QuickBooks. When you find a match, click the checkbox next to it in QuickBooks. The transaction turns gray to show it's been matched.

Work methodically — start at the beginning of the statement and move forward. This prevents you from checking the same transaction twice or missing one. As you check off transactions, QuickBooks updates a running total at the bottom of the screen. When that total matches your bank statement's ending balance, you're ready to finish.

Some transactions may appear in QuickBooks but not yet on your bank statement — for example, a check you wrote that hasn't cleared yet. Leave these unchecked for now. They'll show up on next month's statement, and you'll check them off then. The same goes for deposits you recorded but the bank hasn't processed yet.

What to do when amounts don't match

If you find a transaction in QuickBooks that doesn't match your bank statement, or a transaction on your statement that you didn't record in QuickBooks, stop and investigate before you finish reconciliation. Common causes are data entry errors (you typed $150 instead of $15), timing differences (the bank processed a transaction on a different date than you expected), or duplicate entries (you recorded the same deposit twice).

If the error is in QuickBooks, click on the transaction to open it and correct the amount or date. If the error is on your bank statement, contact your bank — they may have made a mistake, or there may be fraud. If it's a timing issue, leave the transaction unchecked this month and it will reconcile next month when the bank processes it.

If you can't find the source of a small difference (a few dollars), some accountants recommend creating a small adjustment entry to make the accounts match, then investigating the discrepancy separately. QuickBooks allows you to do this during reconciliation, though it's better to find and fix the real error if you can.

Finishing and locking the reconciliation

Once every transaction on your bank statement is checked off in QuickBooks and your running total matches the bank's ending balance, QuickBooks shows a green checkmark and the message "Reconciliation Complete." Click Finish Now. QuickBooks locks all the transactions you checked off — you can still view them, but you can't edit them without undoing the entire reconciliation first.

This lock is a safeguard. It prevents accidental changes to transactions you've already verified against the bank. If you need to change a locked transaction later, you'll have to undo the reconciliation, make the change, and reconcile again. For this reason, it's worth taking the time to get it right the first time.

Undoing a reconciliation if you made a mistake

If you finished reconciliation and then discovered an error, you can undo it. Go to Accounting > Reconcile, find the account, and look for the reconciliation history. Click on the month you want to undo, then click Undo. QuickBooks unlocks all the transactions from that reconciliation so you can edit them. Once you've fixed the error, you can reconcile again.

Undoing doesn't delete anything — it just removes the lock so you can make changes. This is useful if you realized you missed a transaction, recorded something twice, or entered the wrong amount. After you fix the problem, run through the reconciliation process again to confirm everything matches.

Why reconciliation matters for your finances

Reconciliation catches errors before they compound. A $50 mistake in January becomes a $50 discrepancy in February, and by June you're looking at a balance sheet that doesn't match reality. Regular reconciliation also catches fraud — if someone used your account without permission, reconciliation is usually where you'll spot it first, because the transaction will appear on your bank statement but you won't have recorded it in QuickBooks.

For tax purposes, your bank records are the official record. If you're audited, the IRS will compare your QuickBooks records to your bank statements. If they don't match, you'll have to explain the difference. Staying reconciled means you can answer that question quickly and confidently.

Frequently Asked Questions

What if a check I wrote hasn't cleared yet?

Leave it unchecked during this month's reconciliation. It will appear on next month's bank statement once the bank processes it, and you'll check it off then. This is normal and expected — checks often take several days to clear.

Can I reconcile a bank account that's connected to QuickBooks through automatic sync?

Yes. Even though QuickBooks automatically imports transactions from your bank, you still need to reconcile to confirm they're correct and catch any errors or fraud. The automatic sync saves you data entry time, but reconciliation is still your responsibility.

What does it mean if my QuickBooks balance is higher than my bank balance?

It usually means you recorded a deposit or wrote a check that hasn't cleared yet. Review unchecked transactions in QuickBooks and compare them to your bank statement. If a transaction is in QuickBooks but not on the statement, it's probably pending.

Do I have to reconcile every month?

Monthly reconciliation is standard practice and catches problems early. If you reconcile less often, errors pile up and become harder to track down. If you reconcile more often (weekly or biweekly), you'll catch mistakes faster but spend more time on the process.

What if I find a bank error during reconciliation?

Contact your bank when ready with the transaction details and the amount of the error. The bank will investigate and correct it on their end. Once they do, the transaction will match your QuickBooks record and you can check it off during next month's reconciliation.