Reconciliation matches your bank statement to your QBO records

Reconciliation is the process of comparing what your bank says you have against what QuickBooks Online shows. You do this once a month, using your bank statement as the source of truth. QBO walks you through it step by step, and the goal is to make sure every transaction the bank recorded matches a transaction you recorded—or to find and fix the ones that don't.

The reconciliation tool in QBO is built into the checking account itself. You start from your account register, tell QBO which statement you're working from, and then mark off each transaction as "cleared" or "deposited." When the math works out—when your QBO balance plus any outstanding checks equals your bank statement balance—you're done. If it doesn't, QBO shows you the difference and helps you hunt for the problem.

Most small business owners reconcile monthly because that's when the bank sends a statement. Some do it weekly or after large transactions. The longer you wait between reconciliations, the harder it is to find mistakes, because you have more transactions to sort through.

Key Takeaways

  • Reconciliation compares your bank statement balance to your QBO balance by marking each transaction as cleared.
  • You start the process from the checking account register and select the statement date you're reconciling to.
  • QBO shows you which transactions are uncleared and calculates the difference between your records and the bank's.
  • When the difference is zero, your reconciliation is complete and locked in QBO.
  • If the difference is not zero, you need to find missing or incorrectly recorded transactions before you can finish.

Starting a reconciliation in QBO

Go to the Accounting menu and select Reconcile. QBO will show you a list of your bank accounts. Click on the checking account you want to reconcile. QBO will ask you for the ending balance from your bank statement and the statement date. Type both in exactly as they appear on the statement—the date matters because QBO uses it to filter which transactions to show you.

QBO will also ask for the beginning balance, which is usually the ending balance from your last reconciliation. If this is your first time reconciling, use the opening balance of the account. Once you enter these numbers, QBO displays all transactions posted to that account since the last reconciliation (or since the account was created, if you've never reconciled before).

At the top of the screen, QBO shows three numbers: your statement ending balance, your QBO balance, and the difference between them. Your job is to make that difference zero.

Marking transactions as cleared

QBO displays two columns of transactions: deposits and checks (or withdrawals). For each transaction on your bank statement, find the matching transaction in QBO and click the checkbox next to it. This marks it as "cleared"—meaning the bank has processed it and your records match.

As you check off transactions, the difference at the top of the screen shrinks. If you mark a transaction that doesn't belong or mark the wrong amount, the difference will grow instead. That's your signal to uncheck it and look again.

Some transactions may appear in QBO but not on your bank statement yet—these are usually recent transactions that haven't cleared. Leave these unchecked. Some transactions may appear on your bank statement but not in QBO—these are usually bank fees or automatic payments you forgot to record. You'll need to add these to QBO before you can finish reconciling.

Handling transactions that don't match

If a transaction is on your bank statement but not in QBO, you need to add it. Click the "Add transaction" button at the bottom of the reconciliation screen. QBO will open a form where you can record the transaction—usually a check, deposit, or fee. Fill in the date, amount, and description, then save it. The transaction will appear in the list and you can mark it as cleared.

If a transaction is in QBO but shows a different amount than on your bank statement, you have two choices: edit the transaction in QBO to match the bank, or delete it and re-enter it correctly. To edit, click on the transaction itself (not the checkbox) and change the amount. Save it and return to reconciliation. The updated amount will show in the list.

If a transaction is in QBO but hasn't appeared on your bank statement yet, don't mark it as cleared. These outstanding transactions are normal—checks you wrote that the recipient hasn't deposited yet, or ACH transfers that are still processing. Leave them unchecked and they'll carry forward to next month's reconciliation.

When the difference is zero

Once every transaction on your bank statement is marked as cleared in QBO, and the difference at the top shows zero, click the "Finish" button. QBO will lock that reconciliation in place. You can still view it later, but you can't edit the cleared transactions without unlocking the reconciliation first—and QBO will warn you if you try.

A locked reconciliation is important because it creates an audit trail. If someone asks you later whether a transaction was real or a mistake, you can point to the reconciliation and say "Yes, the bank cleared it on this date." This matters for taxes, for disputes with your accountant, and for catching fraud.

After you finish, QBO updates your account register to show which transactions are cleared. Cleared transactions have a small checkmark or "C" next to them. This makes it easy to see at a glance which transactions the bank has processed and which are still pending.

What to do if the difference won't go to zero

If you've checked off all the transactions on your bank statement and the difference is still not zero, something is wrong. The most common causes are: a transaction recorded in QBO with the wrong amount, a transaction recorded twice, a transaction that shouldn't be there at all, or a transaction that's on the bank statement but you haven't found it in QBO yet.

Start by looking at the difference amount. If it's a round number like $50 or $100, search QBO for that amount—you may have entered it backwards or with a typo. If the difference is an odd amount like $17.43, it's often a bank fee you didn't record. Check your bank statement for any fees, interest, or automatic payments.

If you still can't find it, you can click "Undo" to unlock the reconciliation and start over, or you can click "Pause" to save your progress and come back later. Many accountants recommend pausing, waiting a few days, and then looking again with fresh eyes—mistakes are often easier to spot after a break.

Reconciling after a mistake is found

If you've already finished a reconciliation and later discover a mistake—a transaction that was recorded wrong, or a duplicate—you need to unlock that reconciliation first. Go back to Reconcile, select the account, and find the reconciliation you want to fix. Click "Edit" or "Undo." QBO will unlock it and let you make changes.

Once you've fixed the transaction, you'll need to reconcile again. The difference will show up, and you can mark the corrected transaction as cleared. Then finish the reconciliation again. This creates a new locked reconciliation with the correct information.

If the mistake was in a past month's reconciliation, fixing it may affect the current month's reconciliation too. For example, if you recorded a check in the wrong month, moving it will change both months' balances. This is normal and expected—the important thing is that your records eventually match the bank's.

Frequently Asked Questions

Can I reconcile a checking account that's already been reconciled?

Yes. You can unlock a past reconciliation, make changes, and reconcile again. QBO will ask you to confirm that you want to unlock it. This is useful if you find a mistake weeks or months later, but it's better to catch mistakes during the current month's reconciliation if you can.

What if a check I wrote hasn't cleared after two months?

This is unusual but not unheard of. Leave it unchecked in each month's reconciliation until it clears. Once it appears on the bank statement, mark it as cleared. If it never clears after three months, contact the recipient to confirm they received it—it may have been lost or the recipient may not have deposited it.

Do I have to reconcile every month?

You don't have to, but monthly reconciliation is the standard practice. It catches mistakes early and makes tax time easier. If you reconcile less often, you'll have more transactions to sort through and mistakes will be harder to find. Many accountants require monthly reconciliation as part of their engagement.

What's the difference between cleared and reconciled?

Cleared means the bank has processed the transaction. Reconciled means you've compared your records to the bank statement and confirmed they match. A transaction can be cleared but not yet reconciled if you haven't finished the reconciliation process yet.

Can I reconcile on a date other than the statement date?

You can, but it's not recommended. QBO uses the statement date to filter transactions, so reconciling on a different date may include or exclude transactions you don't expect. Stick to the date on your bank statement for consistency.