How to Reconcile an Account in QuickBooks

Reconciling your accounts in QuickBooks means matching the transactions recorded in your books against your official bank or credit card statement. When the two match, you know your records are accurate. When they do not, you catch errors and potential fraud before they compound. This guide covers the full reconciliation process for both QuickBooks Online and QuickBooks Desktop Pro 2022, 2023, and 2024, including what to do when the numbers do not line up.

What Is Reconciliation in QuickBooks?

Reconciliation is the process of comparing two sets of financial records to confirm they agree. In QuickBooks, this means taking your bank or credit card statement for a specific period and verifying that every transaction on that statement appears correctly in your QuickBooks register.

The goal is a zero difference between the ending balance on your statement and the cleared balance in QuickBooks. A zero difference means your books are clean. Any remaining difference flags a transaction that is missing, duplicated, or entered incorrectly.

Intuit recommends reconciling every account monthly, timed to when you receive your bank statement. Monthly reconciliation keeps discrepancies small and easy to trace. If you wait longer, a single data-entry error from three months ago can turn a 30-minute task into a half-day investigation.

Reconciliation also serves as a fraud check. Unauthorized transactions, duplicate charges, and vendor overpayments all appear as discrepancies during reconciliation. Catching them monthly limits exposure.

Before You Begin

Before opening QuickBooks, gather the following:

• Your bank or credit card statement for the period you are reconciling (either printed or downloaded as a PDF)
• The ending balance from that statement
• The statement end date
• Any service charges or interest credits listed on the statement that you have not already entered in QuickBooks

If you are reconciling for the first time on an account that has a history, make sure the opening balance in QuickBooks matches the opening balance on your oldest available statement. A mismatch here will produce a discrepancy that cannot be resolved until the opening balance is corrected.

How to Reconcile in QuickBooks Online

Step 1: Open the Reconcile Page

There are two ways to reach the reconcile page in QuickBooks Online.

Option A:

1. Click Accounting in the left navigation panel
2. Click Reconcile

Option B:

1. Click the gear icon in the top right corner
2. Select Tools
3. Click Reconcile

Both paths lead to the same place. If this is your first reconciliation, QuickBooks will prompt you to set an opening balance before continuing.

Step 2: Select the Account

On the Reconcile page, use the Account dropdown to choose the bank or credit card account you want to reconcile. After selecting an account, you will see any previous reconciliation history listed below.

If an alert appears stating that your account is not ready for reconciliation, click the blue "We can help you fix it" link. This alert usually means a previously reconciled transaction was edited or deleted. QuickBooks will direct you to the Reconciliation Discrepancy Report, where you can identify and correct the problem. Do not skip this step. Proceeding with a known discrepancy forces an inaccurate balance into your history.

Step 3: Enter Your Statement Information

Click the Reconcile or Resume Reconciling button. A panel will appear with three fields:

• Beginning balance - automatically populated from the prior reconciliation's ending balance
• Ending balance - enter the ending balance from your bank statement
• Ending date - enter the last day of the statement period (for example, July 31 for a July statement)

Verify that the beginning balance matches the opening balance on your current statement. If it does not match, the opening balance was changed after the prior reconciliation was completed. This needs to be investigated before continuing.

Once all three fields are correct, click Start Reconciling.

Step 4: Match and Clear Transactions

QuickBooks displays all uncleared transactions for the account up to the ending date you entered. Each row includes the date, payee, and amount.

Working through the list, find each transaction on your bank statement. When you locate a match, click the circle on the far right of that transaction row to mark it as cleared. A checkmark will appear and the transaction amount moves into the Cleared Balance total at the top of the screen.

Two numbers at the top of the screen track your progress:

• Statement Ending Balance - the number you entered from your statement
• Cleared Balance - the running total of transactions you have marked as cleared
• Difference - the gap between the two; your target is zero

Continue matching transactions until you have cleared everything that appears on your statement.

Step 5: Use Filters When the List Is Long

If the transaction list is long, use the filter icon (the funnel icon in the upper left of the transaction list) to narrow the view. You can filter by:

• Transaction type (payments or deposits only)
• Date range
• Amount or reference number

Filtering speeds up the matching process and reduces the chance of accidentally clearing the wrong transaction.

Step 6: Reach Zero and Finish

When the Difference field reads $0.00, QuickBooks displays a green "Success" banner. Click Finish now to complete the reconciliation. QuickBooks saves the reconciliation and stamps all cleared transactions with an "R" in the register.

If the Difference is not zero, do not click Finish now. Review your work first. Common reasons for a remaining difference include:

• A transaction on the statement that was not entered in QuickBooks
• A transaction entered in QuickBooks for the wrong amount
• A transaction cleared in QuickBooks that does not appear on the statement
• A service charge or interest credit on the statement that was not yet recorded in QuickBooks

If you cannot find the source of the discrepancy, click Finish later to save your progress and return after reviewing your statement again.

How to Reconcile in QuickBooks Desktop

Step 1: Back Up Your Company File

Before reconciling in QuickBooks Desktop, back up your company file. Go to File > Back Up Company > Create Local Backup. This gives you a restore point if anything goes wrong during the reconciliation.

Step 2: Open the Begin Reconciliation Window

1. Go to Banking in the top menu bar
2. Click Reconcile
3. The Begin Reconciliation window opens

Step 3: Fill In the Statement Information

In the Begin Reconciliation window:

• Account - select the account you want to reconcile from the dropdown
• Statement Date - QuickBooks auto-fills this to approximately 30 days after the last reconciliation; adjust it to match the end date on your bank statement
• Beginning Balance - auto-filled from the prior reconciliation; verify it matches your statement's opening balance
• Ending Balance - enter the ending balance from your bank statement

If your bank statement lists a service charge that you have not yet entered in QuickBooks, enter it in the Service Charge field along with the date and the appropriate expense account. Do the same for any interest income in the Interest Earned field. Do not enter these amounts if they are already in your QuickBooks register.

Click Locate Discrepancies if you want to review a report of any past discrepancy adjustments before proceeding. If everything looks correct, click Continue.

Step 4: Clear Transactions on the Reconcile Screen

The Reconcile screen displays transactions in two columns: checks and payments on the left, deposits and credits on the right. This mirrors the structure of a standard bank statement.

Work through each column and click the checkmark column next to each transaction that appears on your bank statement. The Cleared Balance and Difference fields in the lower right corner update as you clear items.

A useful shortcut: if all transactions from the prior period have already been cleared, click Mark All to check them off at once, then uncheck any that do not appear on your current statement.

You can open and edit a transaction directly from this screen if you find an error. Click the transaction row to highlight it, then click Go To to open it. Make corrections, save, and return to the Reconcile screen. Only correct genuine errors; do not edit transactions simply to force the difference to zero.

QuickBooks Desktop also supports bank feed matching. If you have connected your bank account to the bank feed, downloaded transactions can be auto-matched and cleared, which reduces manual work.

Step 5: Complete the Reconciliation

When the Difference field shows 0.00, click Reconcile Now. QuickBooks generates a reconciliation report and marks all cleared transactions with an "R" in the register. Print or save the report for your records and for your accountant.

Understanding Reconciliation Discrepancies

A discrepancy during reconciliation is a signal that something is out of alignment between your records and your bank's records. Understanding the cause determines the correct fix.

Missing transaction: A charge appears on your statement but not in QuickBooks. Enter the missing transaction directly from the reconcile screen and then clear it.

Duplicate entry: A transaction was entered twice in QuickBooks. Identify the duplicate in your register, verify it does not appear twice on the statement, and delete the extra entry.

Wrong amount: A transaction was entered for the wrong dollar amount. Edit the transaction to match the statement amount.

Timing difference: A check you wrote has not cleared the bank yet. This is normal. Do not clear it during this reconciliation; it will appear cleared in the following month when the bank processes it.

Previously reconciled transaction changed: Someone edited or deleted a transaction that was already reconciled. This is the most disruptive type of discrepancy. In QuickBooks Online, the Reconciliation Discrepancy Report identifies these changes. In QuickBooks Desktop, the Locate Discrepancies report in the Begin Reconciliation window shows the same information. Consult your accountant before making corrections to previously reconciled periods.

How to View Past Reconciliation Reports

In QuickBooks Online:

1. Go to Accounting > Reconcile
2. Click History by account
3. Select the account and period
4. Click View report

In QuickBooks Desktop:

1. Go to Reports > Banking
2. Click Previous Reconciliation
3. Select the account and the statement ending date
4. Choose whether to view the full detail or just the summary

Both versions retain all past reconciliation reports. Reviewing these reports is useful when an accountant needs to audit a prior period or when a discrepancy traces back several months.

Common Mistakes to Avoid

Forcing a zero balance: If your difference is not zero but you click Finish anyway, QuickBooks creates a reconciliation discrepancy adjustment to zero out the balance. This disguises the real problem. Future reconciliations will be harder to complete accurately.

Deleting reconciled transactions: Deleting or voiding a transaction that already has an "R" in the register un-reconciles it and creates a discrepancy. If a transaction needs to be reversed, create a correcting entry rather than deleting the original.

Skipping months: If you miss a month, start from the oldest unreconciled month and work forward. Do not try to reconcile several months at once by using the most recent statement's ending balance.

Reconciling the wrong account: Double-check the account name before entering statement information. Applying a bank statement to the wrong QuickBooks account creates two sets of problems: the intended account shows a discrepancy and the wrong account shows a false reconciliation.

When to Call Support

Contact QuickBooks support phone number if:

• Your opening balance does not match your statement and you cannot identify when it changed
• Reconciliation discrepancy reports show adjustments you did not make, which may indicate unauthorized access
• Your reconciliation was completed successfully but the register shows transactions reverting to uncleared status
• You need to undo a reconciliation that was completed incorrectly and the Undo feature is not available in your subscription tier

You can also use the Help menu inside QuickBooks to open a chat session with Intuit support, or visit the QuickBooks Community to search for solutions from other users and Intuit staff.