What reconciliation means and why you do it

Reconciliation is the process of matching the transactions QuickBooks shows in your bank account against the actual transactions your bank shows. You do this once a month (or as often as your bank sends statements) to catch errors, spot fraud, and make sure your books are accurate.

When you reconcile, you are checking two lists side by side: what QuickBooks recorded and what your bank recorded. If they match, your account is balanced. If they do not, something is missing or wrong — a transaction you forgot to record, a check that has not cleared yet, a bank fee you did not know about, or a genuine error by the bank.

QuickBooks Online has a built-in reconciliation tool that walks you through this step by step. It shows you which transactions are cleared and which are still pending, and it will not let you finish until everything matches.

Key Takeaways

  • Reconciliation compares what QuickBooks shows against what your bank statement shows, and you do it once a month or whenever you receive a statement.
  • You need your bank statement (online or paper) and access to your QuickBooks Online account to start the process.
  • QuickBooks walks you through marking transactions as cleared and will flag any amounts that do not match between your records and the bank's.
  • If reconciliation does not balance, you can undo it and add missing transactions or correct errors before trying again.
  • Reconciling regularly — even monthly — catches problems early and keeps your financial records trustworthy for taxes and business decisions.

How to start reconciliation in QuickBooks Online

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

QuickBooks will ask you for the statement ending date and the ending balance from your bank statement. Type in both. The statement ending date is the last day covered by your statement (usually the end of the month). The ending balance is the total your bank shows you have in the account on that date — you can find this on your bank statement or by logging into your bank's website.

QuickBooks will also show you the beginning balance it has on file. This should match the ending balance from your previous reconciliation. If it does not, you may have already recorded transactions that the bank has not processed yet, or you may have missed a transaction.

Marking transactions as cleared

Once you have entered the statement dates and balances, QuickBooks shows you two columns: one for deposits and one for withdrawals. Each transaction has a checkbox next to it. Your job is to go through your bank statement line by line and check off every transaction that appears on both the statement and in QuickBooks.

Start with deposits. Look at your bank statement and find the first deposit listed. Then look in the QuickBooks deposits column and find the matching transaction — it should have the same date and amount. Click the checkbox next to it in QuickBooks. Move to the next deposit on your statement and repeat.

Then do the same for withdrawals: checks, transfers, debit card charges, and any other money that left the account. Check off each one as you find it in QuickBooks. If a transaction appears on your bank statement but not in QuickBooks, you will need to add it before you can finish reconciliation.

Transactions that have not cleared the bank yet (like a check you wrote but the recipient has not deposited) will not appear on your bank statement, so do not check them off. Leave them unchecked — QuickBooks will hold them aside.

What to do if amounts do not match

At the bottom of the reconciliation screen, QuickBooks shows you the difference between what you have checked off and what the bank statement says the balance should be. If this number is zero, you are done — click Finish Now and reconciliation is complete.

If the difference is not zero, something is missing or wrong. Common causes are: a transaction on the bank statement that you have not recorded in QuickBooks, a transaction you recorded with the wrong amount, or a bank fee or interest deposit you did not know about.

Go back through your bank statement and QuickBooks side by side. Look for transactions on the statement that do not have a checkmark in QuickBooks — these are transactions you need to add. If you find one, click Add Transaction (or the equivalent button in your version), enter the details, and save it. Then check it off.

If you find a transaction in QuickBooks with the wrong amount, click on it to open it, correct the amount, and save. Then check it off again.

Adding missing transactions during reconciliation

If your bank statement shows a transaction that is not in QuickBooks, you can add it without leaving the reconciliation screen. Look for a button or link that says Add Transaction or New Transaction. Click it and enter the date, payee (who the money went to or came from), category, and amount. Save the transaction and it will appear in the list so you can check it off.

Common transactions people forget are bank fees (usually listed as "Service Charge" or "Monthly Fee"), interest earned on savings accounts, and automatic transfers set up directly with the bank. Your bank statement will show all of these, so check for them before you assume reconciliation is wrong.

Undoing a reconciliation if you made a mistake

If you finished reconciliation but then realized you made an error, you can undo it. Go back to Accounting and Reconcile, select the account, and look for a button or option that says Undo or Start Over. Click it and QuickBooks will reopen the reconciliation so you can make corrections.

Once you undo, all the checkmarks you made will disappear and you can start over. This is useful if you checked off a transaction by mistake or if you added a transaction with the wrong amount. Make your corrections and then go through the process again.

Why reconciliation matters for your business

Reconciling your bank account every month is one of the most important things you can do to keep your books accurate. It catches errors early — both yours and the bank's — and it gives you confidence that the numbers in QuickBooks match reality.

If you do not reconcile regularly, errors pile up. A missing transaction here, a wrong amount there, and soon your QuickBooks balance is thousands of dollars off from what your bank says. This makes it hard to trust your financial reports, and it can cause problems when you file taxes or apply for a loan.

Reconciliation also protects you from fraud. If someone uses your account without permission, reconciliation will show a transaction you do not recognize. The sooner you spot it, the sooner you can contact your bank and dispute it.

Frequently Asked Questions

What if a check I wrote has not cleared yet?

Do not check it off during reconciliation. Checks can take several days or even weeks to clear, especially if they were mailed. Leave it unchecked in QuickBooks and it will stay in your "pending" list. When the check finally clears and appears on your bank statement, you can check it off in the next month's reconciliation.

Can I reconcile a credit card account the same way?

Yes. The process is identical — you match transactions on your credit card statement to transactions in QuickBooks. The only difference is that you are reconciling to your credit card balance instead of your bank balance. Use the statement ending date and balance from your credit card statement.

What does "cleared" mean?

A transaction is cleared when both you and your bank have recorded it. For deposits, this usually means the money has arrived in your account. For withdrawals, it means the check has been cashed or the debit card charge has been processed. Pending transactions (like a check you just mailed) are not yet cleared.

Do I have to reconcile every month?

You should reconcile at least as often as your bank sends statements — usually monthly. Some businesses reconcile weekly or even daily if they have high transaction volume. The more often you reconcile, the easier it is to spot errors, because there are fewer transactions to review each time.

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

First, check that you entered the amount correctly in QuickBooks. If you did, contact your bank — it is possible they made an error. If the bank confirms the amount is correct, edit the transaction in QuickBooks to match and then check it off during reconciliation.