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 statement your bank sends you. You are checking that every deposit, withdrawal, and fee recorded in QuickBooks is real, and that nothing is missing or duplicated.

When you reconcile, you catch errors before they throw off your tax records or your profit-and-loss statement. A transaction might fail to upload from your bank, or you might have entered a check amount wrong, or your bank might charge a fee you forgot to record. Reconciliation finds these gaps.

Most people reconcile once a month, using the bank statement that arrives at the end of the month. If you have connected your bank account to QuickBooks Online through a direct link, many transactions will already be downloaded and waiting for you to review. If you have not connected your bank, you will enter them manually or upload a file.

Key Takeaways

  • Reconciliation compares what QuickBooks shows against what your bank statement shows, and you mark each transaction as matched or investigate why it is missing.
  • Start by opening the Reconcile tool in QuickBooks Online, selecting your bank account, and entering the ending balance from your bank statement.
  • QuickBooks will show you downloaded transactions and ask you to confirm each one matches your statement; you check them off as you go.
  • If the reconciled balance does not match your bank statement balance at the end, QuickBooks will tell you the difference, and you can search for the missing or wrong transaction.
  • Once reconciliation is complete and balanced, QuickBooks locks that period so you cannot accidentally change transactions that have already been verified.

Opening the Reconcile tool and entering your bank statement details

Log into QuickBooks Online and go to the Accounting menu on the left sidebar. Click Reconcile. QuickBooks will show you a list of all bank and credit card accounts you have set up.

Select the account you want to reconcile. QuickBooks will ask you for the Ending Balance — this is the balance shown on your bank statement on the last day of the period you are reconciling. You will also enter the Ending Date, which is usually the last day of the month. If your bank statement shows a service fee or interest, enter that in the fields provided.

Once you enter these details and click Start Reconciling, QuickBooks will display all the transactions it has recorded in that account since the last time you reconciled. If your bank is connected, most of these will be downloaded automatically. If not, you will see only the transactions you entered by hand.

Matching transactions to your bank statement

QuickBooks will show you two columns: one for Deposits and Other Credits (money in) and one for Checks and Payments (money out). Each transaction has a checkbox next to it.

Open your bank statement and go through it line by line. For each transaction on your statement, find the matching transaction in QuickBooks and check the box. The amount, date, and description should match. If QuickBooks shows a transaction that is not on your bank statement, leave it unchecked — it may not have cleared yet, or it may be an error.

As you check off transactions, QuickBooks updates a running total at the bottom of the screen. This total should move toward zero as you match more transactions. If you see a transaction in QuickBooks that you do not recognize, click on it to see more details or edit it.

What to do if a transaction does not match

If your bank statement shows a transaction that QuickBooks does not have, you will need to add it. Click the Add Transaction button and enter the details: the date, the amount, and a description. Common examples are bank fees, interest deposits, or automatic payments you forgot to record.

If QuickBooks shows a transaction but your bank statement does not, the transaction may not have cleared yet. Leave it unchecked and it will carry forward to next month's reconciliation. If it has been more than a week and it still has not appeared on your statement, contact your bank to confirm it went through.

If the amount is different — for example, you recorded a check for $150 but your bank shows $155 — edit the transaction in QuickBooks to match the bank statement. Click on the transaction, change the amount, and save. Then check the box to mark it as matched.

Finishing reconciliation when the balance matches

Once you have checked off all the transactions that appear on your bank statement, look at the Difference field at the bottom of the screen. If it shows zero, your reconciliation is complete and balanced. Click Finish Now.

QuickBooks will confirm the reconciliation and lock that period. You will no longer be able to edit transactions from that month without unlocking the reconciliation first. This lock protects your records from accidental changes after you have verified them against the bank.

If the difference is not zero, QuickBooks will show you the amount. This means a transaction is missing, wrong, or duplicated. Before you finish, search for the problem — see the next section.

Finding and fixing the difference when reconciliation does not balance

If your difference is a small amount — like $0.50 or $1.00 — it is often a bank fee or interest that you did not record. Check your bank statement for any charges or credits you missed, add them to QuickBooks, and try again.

If the difference is larger, use the Search function in QuickBooks to look for the problem. Go back to your bank statement and look for any transaction that is not checked off in QuickBooks. Write down the date and amount, then search for it by amount in QuickBooks. You may find it recorded under a different date or with a slightly different description.

Another common issue is a duplicate transaction — the same deposit or payment appears twice in QuickBooks. If you find a duplicate, delete one copy and reconcile again. If you still cannot find the problem after checking your statement carefully, you can enter a Reconciliation Discrepancy adjustment — QuickBooks will create a small balancing entry so you can finish. However, go back later and find the real transaction, because the adjustment is only a temporary fix.

Reconciling credit card accounts in QuickBooks Online

Credit card reconciliation works the same way as bank account reconciliation, but the logic is reversed. With a bank account, you are matching money that went in and out. With a credit card, you are matching charges and payments against your credit card statement.

Select your credit card account from the Reconcile menu and enter the Ending Balance from your credit card statement — this is what you owe, not what you have. Check off each charge and payment as it appears on your statement. When the difference reaches zero, you have matched everything and can finish.

Credit card statements usually take longer to post than bank transactions, so you may see charges in QuickBooks that do not appear on your statement yet. Leave them unchecked and they will appear in next month's reconciliation.

Frequently Asked Questions

Can I reconcile a previous month if I skipped it?

Yes. Go to the Reconcile tool, select the account, and enter the ending balance from the statement for the month you want to reconcile. QuickBooks will show all unreconciled transactions from that period. You can reconcile any month, even if you are several months behind, but it is easier to catch errors if you reconcile every month.

What if I need to change a transaction after I have already reconciled?

You can edit a reconciled transaction, but QuickBooks will mark the reconciliation as out of balance. You will need to go back into the Reconcile tool for that month, re-check the boxes, and finish again. This is why it is important to get transactions right before you reconcile.

Do I have to reconcile every month?

You do not have to, but monthly reconciliation is the standard practice and catches errors early. If you reconcile quarterly or yearly instead, errors can pile up and become harder to find. Monthly is the safest approach.

What does it mean if QuickBooks says a transaction is pending?

A pending transaction is one that has been downloaded from your bank but has not cleared yet. It will not appear on your bank statement until it clears, so do not check it off during reconciliation. It will show up on next month's statement and next month's reconciliation.

Can I undo a reconciliation after I finish it?

Yes. Go back to the Reconcile tool, select the account and the month you want to undo, and click Undo. QuickBooks will unlock that period and uncheck all the transactions so you can reconcile again. Use this if you realize you made a mistake after finishing.