Reconciliation means matching your bank statement to your QBO records

Reconciliation is the process of comparing what your bank says you have against what QuickBooks Online says you have. When you reconcile, you're checking that every transaction the bank recorded matches a transaction you recorded in QBO — and that the balances are the same. If they don't match, reconciliation helps you find where the difference is.

Most people reconcile once a month, using their bank statement as the source of truth. The bank's record is what actually happened to your money, so if QBO doesn't match it, something in QBO needs to be fixed.

You'll need your bank statement — either the paper one or the one you read from your bank's website. Have it open alongside QBO before you start.

Key Takeaways

  • Reconciliation compares your bank statement balance to your QBO balance and marks off transactions that match on both sides.
  • Start reconciliation in QBO by going to the Accounting menu, selecting Reconcile, and choosing your checking account.
  • Enter the ending balance from your bank statement and the date the statement covers.
  • Check off each transaction in QBO that appears on your bank statement, then QBO will tell you if the balances match.
  • If balances don't match after you've checked off all transactions, look for missing transactions or amounts entered wrong in QBO.

Where to find the reconciliation tool in QBO

Open QuickBooks Online and go to the Accounting menu on the left sidebar. You'll see a section called "Reconcile" — click on it. QBO will show you a list of all your bank accounts. Find your checking account and click the Reconcile now button next to it.

If this is your first time reconciling this account, QBO might ask you to enter a starting balance. This is the balance from your bank statement on the day you first connected the account to QBO. Check your bank records for that date and enter the amount.

Entering your bank statement information

QBO will open a reconciliation window. At the top, you'll see fields for the Ending Balance and Ending Date. Look at your bank statement and find the balance shown on the last day of the statement period — that's your ending balance. Enter it in the first field. Then enter the date that statement covers in the second field.

You'll also see a field for Service Charges and Interest Earned. If your bank statement shows fees or interest, enter those amounts here. QBO will create transactions for them automatically.

Leave the Beginning Balance field alone — QBO fills that in based on what it already knows.

Matching transactions between your statement and QBO

Below the header information, you'll see two columns. The left side shows transactions from your bank statement. The right side shows transactions QBO has recorded. Your job is to check off the transactions that appear on both sides.

Start with the first transaction on your bank statement. Look for it on the right side of the screen in QBO. When you find it, click the checkbox next to the QBO transaction. The transaction will move to a "matched" section. Repeat this for every transaction on your statement.

Most transactions will match exactly — same amount, same date. Some might be off by a day or two because of how long deposits or checks take to clear. That's normal. Match them anyway.

If you can't find a transaction from your statement in QBO, it means you never recorded it. You'll need to add it to QBO before you can finish reconciliation. Click the Add button and create the transaction.

What to do if the balances don't match

After you've checked off all the transactions that match, look at the bottom of the reconciliation window. QBO will show you the difference between your bank statement balance and your QBO balance. If the difference is zero, you're done — click Finish Now.

If there's a difference, something is wrong. Common causes are: a transaction in QBO with the wrong amount, a transaction in QBO that isn't on your bank statement, or a transaction on your bank statement that you never recorded in QBO.

Go back and look at the transactions you didn't check off. Are they on your bank statement? If not, they might be pending transactions that haven't cleared yet — leave them unchecked and try reconciling again next month. If they're old transactions that should have cleared, delete them from QBO or correct the amount.

If you find a transaction on your bank statement that you didn't record in QBO, add it now. Then check it off. Keep doing this until the difference is zero.

Uncleared transactions and why they matter

Some transactions won't be on your bank statement yet — checks you wrote that haven't been cashed, or deposits you made that haven't posted. These are called uncleared or pending transactions. Don't check them off during reconciliation.

Leave them unchecked in QBO. They'll stay in your account and you'll match them next month when they actually clear. This is normal and expected.

The only time you should worry about an uncleared transaction is if it's very old — more than two or three weeks. If a check you wrote hasn't cleared after that long, contact your bank to see if something went wrong.

Finishing reconciliation and what happens next

Once the difference shows zero and all matching transactions are checked off, click the Finish Now button. QBO will save the reconciliation and mark all the checked transactions as reconciled.

You can reconcile again next month using the same steps. QBO will remember which transactions you already reconciled and won't show them again — it will only show you new transactions from your latest bank statement.

If you need to go back and change something after you've finished reconciliation, you can. Click on the account name in the Reconcile menu and select Edit next to the reconciliation you want to change. Make your corrections and click Finish again.

Frequently Asked Questions

What if I can't find a transaction from my bank statement in QBO?

That transaction was never recorded in QBO. Click the Add button in the reconciliation window and create it. Enter the date, amount, and description to match your bank statement. Then check it off and continue reconciling.

Should I reconcile every month?

Yes. Monthly reconciliation catches errors early and keeps your QBO balance accurate. It takes 15 to 30 minutes if you do it regularly. If you wait several months, it becomes much harder to find where things went wrong.

What does it mean if a transaction is pending?

Pending means the bank hasn't processed it yet. It won't show on your bank statement until it clears. Leave pending transactions unchecked during reconciliation — they'll match next month when they actually post.

Can I undo a reconciliation after I finish it?

Yes. Go to the Reconcile menu, find the account, and click Edit next to the reconciliation you want to change. Make your corrections and click Finish again. QBO will update the reconciliation with your changes.

Why does my QBO balance not match my bank balance even after reconciliation?

Check for transactions on your bank statement that you haven't recorded in QBO yet. Also look for transactions in QBO that aren't on your statement — these might be pending. If you've checked everything and still can't find the problem, contact your bank to confirm the statement balance is correct.