The reconciliation process matches your QuickBooks records against your actual bank statement

Reconciliation is the step where you compare what QuickBooks says you have in your checking account against what your bank says you have. The goal is to find and fix any differences — a check that cleared late, a deposit you recorded wrong, a fee the bank charged that you missed. QuickBooks has a built-in reconciliation tool that walks you through this side-by-side comparison and flags transactions that don't match.

You'll need your bank statement (the one your bank sends you, either by mail or in your online banking portal) and access to QuickBooks. The process usually takes 15 to 45 minutes depending on how many transactions you have and whether everything matches on the first try.

Key Takeaways

  • Reconciliation compares your QuickBooks balance to your bank statement balance and finds the reasons they differ.
  • You start the reconciliation in QuickBooks by going to the Reconcile tool and selecting your checking account and the statement date.
  • QuickBooks automatically matches transactions it recognizes; you manually mark off the ones that appear on both your statement and in QuickBooks.
  • When the difference reaches zero, your account is reconciled and you save the reconciliation — QuickBooks locks that period so you cannot accidentally change it later.
  • If the difference does not reach zero, you need to find the missing or misrecorded transaction before you can finish.

Where to find the reconcile tool in QuickBooks

The location depends on which version of QuickBooks you use. In QuickBooks Online, go to the left navigation menu and click Reconcile (it may also appear under Tools or Settings depending on your subscription level). In QuickBooks Desktop, click the Banking menu at the top and select Reconcile.

When you open the reconcile tool, QuickBooks asks you which account you want to reconcile. Select your checking account from the dropdown. Then enter the statement date (the date printed on your bank statement) and the ending balance (the number at the bottom of your statement that says "ending balance" or "statement balance"). Do not use your current balance — use the balance from the specific statement you are reconciling.

How QuickBooks matches transactions automatically

Once you enter the statement date and balance, QuickBooks displays two columns: one showing transactions in your QuickBooks records, and one showing transactions on your bank statement. If you have connected your bank account to QuickBooks through the bank link feature, QuickBooks automatically matches many transactions for you and marks them with a checkmark.

You should still review these automatic matches to make sure they are correct. A deposit you recorded as $500 should not be matched to a bank deposit of $5,000, even if QuickBooks suggests it. If an automatic match is wrong, click on it and select Unmatch so you can match it correctly or leave it unmatched while you investigate.

Manually marking transactions that match

For transactions that QuickBooks did not automatically match, you need to mark them yourself. Look at your bank statement and find each transaction listed there. Then find that same transaction in the QuickBooks column and click the checkbox next to it. The transaction now shows a checkmark, meaning you have confirmed it appears on both your statement and in QuickBooks.

Work through your entire bank statement this way. Every deposit, every check, every debit card charge, every fee — if it is on the statement, find it in QuickBooks and check it off. This is the most time-consuming part, but it is also where you catch mistakes. If you see a transaction on your statement that is not in QuickBooks, or a transaction in QuickBooks that is not on your statement, leave it unchecked for now and note it.

What to do when the difference does not match

After you have checked off all matching transactions, QuickBooks shows you the difference between your statement balance and your QuickBooks balance. If this number is zero, you are done — skip to the next section. If it is not zero, you have a problem to solve.

The most common reasons for a mismatch are: a check you wrote that has not cleared yet (it is in QuickBooks but not on the statement), a deposit you made that has not posted yet (it is in QuickBooks but not on the statement), a bank fee or interest you did not record in QuickBooks, or a transaction you recorded in QuickBooks with the wrong amount. Start by looking at the unchecked transactions — these are your suspects. If you see a check or deposit in QuickBooks that is not on the statement, it probably has not cleared yet, which is normal. Leave it unchecked.

If you find a transaction on the statement that is not in QuickBooks at all (like a bank fee), you need to add it to QuickBooks before you can finish reconciling. Click Add transaction or New transaction (the button name varies by version) and enter the transaction details. Then check it off. Once you have found and fixed all the mismatches, the difference should reach zero.

Saving your reconciliation

When the difference shows zero, click Finish reconciliation or Reconcile now (again, the button name varies). QuickBooks saves your reconciliation and locks that statement period. This means you cannot edit or delete any of the transactions you just checked off without unlocking the reconciliation first.

Locking the period is a safety feature — it prevents you from accidentally changing something you have already verified against the bank. If you need to edit a transaction from a locked period later, you can go back and unlock the reconciliation, make the change, and reconcile again. But for now, your account is reconciled and you can move forward.

Reconciling future months

Next month, when your new bank statement arrives, you repeat this process. QuickBooks remembers your previous reconciliation and starts fresh with the new statement date and balance. Any transactions from the previous month that you marked as checked are already locked, so you will not see them again unless you specifically unlock that period.

If you reconcile regularly (monthly is standard), each reconciliation takes less time because you are only dealing with that month's transactions. If you have not reconciled in several months, the first reconciliation back will be longer because you have more statements to work through. The process is the same either way.

Frequently Asked Questions

What if I cannot find a transaction that is on my bank statement?

Check the amount and date carefully — you may have recorded it differently in QuickBooks. Search QuickBooks for the amount or the payee name. If you truly cannot find it, add it as a new transaction in QuickBooks during the reconciliation process. This usually happens with bank fees or automatic transfers you forgot to record.

Can I reconcile a period from several months ago?

Yes. Open the reconcile tool and enter the statement date and balance from the old statement. QuickBooks will show you all transactions from that period that have not been reconciled yet. You can reconcile old periods, but it is easier to reconcile monthly as you go rather than trying to catch up all at once.

What does it mean if a transaction is marked "pending" in QuickBooks?

Pending means the transaction is in QuickBooks but has not cleared your bank yet. Do not check it off during reconciliation — wait until it appears on your bank statement. Once it clears and shows on the statement, you can check it off in the next month's reconciliation.

Do I have to reconcile every month?

You do not have to, but monthly reconciliation is the standard practice. It catches errors early when they are easier to fix, and it keeps your QuickBooks records accurate for tax and financial reporting. If you reconcile less often, errors can pile up and become harder to track down.

What if I reconciled incorrectly and need to fix it?

You can unlock a reconciliation by going back to the reconcile tool, selecting the account and the period you want to unlock, and clicking the option to unlock or undo that reconciliation. Then you can redo it. After you unlock, any transactions from that period become editable again.