What reconciliation does and why it matters

Reconciliation is the process of matching the transactions QuickBooks shows in your account against the transactions your bank shows on your statement. When you reconcile, you're confirming that QuickBooks and your bank agree on what money came in and went out, and how much is actually in the account right now.

This catches errors before they compound—a missed deposit, a duplicate charge, a transaction QuickBooks recorded but the bank hasn't processed yet. Without reconciliation, you might think you have money available when you don't, or miss fraudulent activity. Most small business owners reconcile monthly, matching their QuickBooks records to their bank statement.

QuickBooks Online's reconciliation tool walks you through this step by step. It shows you which transactions match between the two systems and flags ones that don't, so you can investigate and fix them before you mark the account as reconciled.

Key Takeaways

  • Reconciliation compares what QuickBooks shows against your actual bank statement to catch errors and fraud.
  • You'll need your bank statement (online or paper) and access to the account in QuickBooks to start the process.
  • QuickBooks matches transactions automatically when the amounts and dates line up, but you confirm each match manually.
  • Unmatched transactions—deposits pending, checks not yet cleared, bank fees—stay unreconciled until they appear on both sides.
  • Once all transactions match, you mark the reconciliation complete, and QuickBooks locks that period so changes require a separate adjustment.

Starting a reconciliation in QuickBooks Online

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

QuickBooks will ask you for the ending balance from your bank statement—the total shown at the bottom of the statement for the period you're reconciling. It will also ask for the ending date of that statement. Enter both exactly as they appear on your statement. If the numbers don't match later, you'll know something is wrong.

Next, QuickBooks shows you the beginning balance—the amount it thinks was in the account at the start of the period. This should match the beginning balance on your statement. If it doesn't, you may have unresolved issues from a previous reconciliation.

Matching transactions between QuickBooks and your bank

QuickBooks displays two columns: one for transactions it has recorded, one for transactions on your bank statement. The tool attempts to match them automatically based on amount and date. When a match is found, both transactions are checked off.

You need to review each match to confirm it's correct. Look at the transaction description, the amount, and the date. If everything lines up, leave it checked. If something looks wrong—the amount doesn't match, or the description doesn't match what you recorded—uncheck it and investigate before moving forward.

Transactions that don't match automatically appear unchecked. These are usually deposits or checks that haven't cleared yet, or transactions the bank has recorded that QuickBooks hasn't seen. You can manually match these by clicking on a QuickBooks transaction and a bank transaction and selecting Match. QuickBooks will check both off if the amounts are identical.

Handling transactions that won't match

Some transactions will remain unmatched at the end, and that's normal. A check you wrote last week might not have cleared yet. A deposit might be pending. A bank fee might appear on the statement but not yet in QuickBooks. These are called outstanding items.

For outstanding items, you have two choices: leave them unmatched and reconcile anyway, or add them to QuickBooks first. If a transaction is on your bank statement but not in QuickBooks—like a bank fee or automatic payment—you should record it in QuickBooks before reconciling. Go to the account register, add the transaction, and then return to reconciliation to match it.

If a transaction is in QuickBooks but not on the statement yet (like a check you mailed), leave it unmatched. It will match next month when the bank processes it. QuickBooks will remember it and suggest the match automatically next time.

When the balances don't match

After you've matched all the transactions you can, QuickBooks shows you a difference amount at the bottom of the screen. If this number is zero, your account is ready to reconcile. If it's not zero, something is still out of balance.

Start by double-checking the ending balance you entered from your bank statement. A single digit error—typing 5,000 instead of 50,000—will throw off the entire reconciliation. Go back and verify it matches your statement exactly.

Next, look for transactions that might be recorded twice in QuickBooks, or transactions with the wrong amount. Use the Filter option in the reconciliation window to search by date or amount. If you find a duplicate, delete it from the account register. If you find an amount error, edit the transaction to correct it.

If you still can't find the problem, you can use QuickBooks' Discrepancy Report to see what changed between reconciliations. This shows you which transactions were added, deleted, or modified since the last time you reconciled.

Completing the reconciliation

Once the difference is zero and all matched transactions are checked off, click Finish or Complete Reconciliation. QuickBooks will ask you to confirm. After you confirm, the reconciliation is locked. The account is now marked as reconciled through that statement date.

QuickBooks keeps a record of every reconciliation you complete. You can view past reconciliations by going to Accounting > Reconcile and selecting the account. This history is useful if you need to go back and see what was reconciled when, or if you need to undo a reconciliation later.

Making changes after reconciliation is complete

Once you mark a reconciliation complete, QuickBooks prevents you from editing the transactions that were part of that reconciliation. If you need to change a reconciled transaction—to correct an amount or date—you have to undo the reconciliation first.

To undo a reconciliation, go to Accounting > Reconcile, find the account and the reconciliation period you want to undo, and select Undo. QuickBooks will unlock those transactions so you can edit them. After you make your changes, you'll need to reconcile the account again.

Avoid undoing reconciliations unless necessary. Each time you undo and redo, you risk introducing errors. If you catch a mistake shortly after reconciling, undo it right away. If weeks have passed, consider recording an adjustment transaction instead—a small debit or credit that brings the accounts back into balance without disrupting the historical record.

Frequently Asked Questions

What if a transaction appears in QuickBooks but not on my bank statement?

Leave it unmatched for now. It's likely a check or transfer that hasn't cleared yet. When your bank processes it, it will appear on next month's statement, and QuickBooks will suggest the match automatically. If it's been more than two weeks and still hasn't appeared, contact your bank to confirm it was sent.

Can I reconcile a credit card account the same way?

Yes. The process is identical. You'll match transactions from your credit card statement to the transactions QuickBooks has recorded, and reconcile to the statement balance. Credit card reconciliations often have fewer outstanding items because charges post faster than bank transfers.

What does it mean if QuickBooks shows a negative difference?

A negative difference means QuickBooks thinks there's less money in the account than the bank statement shows. This usually means a transaction is recorded in QuickBooks but hasn't hit the bank yet, or a transaction is on the bank statement but missing from QuickBooks. Review unmatched transactions and check for duplicates or missing entries.

Do I have to reconcile every month?

Monthly reconciliation is standard practice and catches errors early. However, you can reconcile more or less frequently depending on your needs. Some businesses reconcile weekly; others reconcile quarterly. The more often you reconcile, the easier it is to find and fix problems, because fewer transactions have accumulated.

What if I can't find the error after checking everything?

Use the Discrepancy Report to see which transactions changed since your last successful reconciliation. If the difference is small and you've spent significant time searching, you can record a one-time adjustment transaction to bring the accounts into balance, then reconcile. Document why you made the adjustment in the transaction memo so you have a record.