QuickBooks Bank Reconciliation: How to Reconcile & Fix Discrepancies

Written by Meghan McKenzie | Published: October 8, 2026

Have you ever experienced that your QuickBooks balance doesn’t match your bank statement? These differences may often appear due to missing transactions, incorrect data entry, duplicate entries, or simple data entry mistakes. QuickBooks Bank reconciliation helps you match your QuickBooks transactions with the bank statement to ensure your records are accurate and free of discrepancies.

In this blog, we have explained what bank reconciliation is, how to perform bank reconciliation in QuickBooks Online & Desktop, and how to fix QuickBooks bank reconciliation problems.

What is Bank Reconciliation in QuickBooks?

This is the process of matching the transactions in your QuickBooks program with your bank or credit card statements. This helps to ensure that both records match and that your books accurately reflect your bank activity. During the reconciliation process, QuickBooks looks for the following;

• Deposits and withdrawals
• Missing or duplicate transactions
• Beginning & ending balances
• Checks & payments
• Bank fees and interest

If the balance doesn’t match, you can investigate the difference and then correct it. However, it’s best to perform the bank reconciliation process regularly to keep your financial records up to date.

Things You Must Have Before Reconciling QuickBooks Accounts

Here are a few points to keep in mind to ensure a smooth bank reconciliation process.

• Confirm that you have the account statement for the account you wish to reconcile.
• Verify that all the transactions for the statement period have been added and categorized in QuickBooks.

Note: If you’ve already linked your bank or credit card, QBO will eventually enter the starting balance and download transactions for you.

How to Do a Bank Reconciliation in QuickBooks Online

Follow the step-by-step instructions given below to reconcile an account in QuickBooks Online.

Reconcile an account 

• Select All Apps, click Accounting > Reconcile. 
• Go to the Reconcile option, and if you are a first-time user, tap on Get Started. 
• Choose the account that you want to reconcile by clicking the Account drop-down arrow.
• Check out the Last statement ending date. Verify that your current account statement starts the day after this date.
• Add the Ending balance and ending date from your account statement.
  • Optional: If you are accessing AI-powered reconciliation, upload the account statement. Wait for the file to upload and be verified.
• Once done, choose the Start Reconciling option.

Match and clear transactions 

QuickBooks will provide you with a list of your transactions beside the transactions on your account statement. Then, you can match the transactions from both lists.

• Match the list of transactions in the reconciliation window with your account statement.
• Tick the checkbox for each transaction in the reconciliation window that matches a transaction on your account statement. This will add them to the reconciliation.
• Once transactions are selected, the cleared balance will change. Make sure to match the transaction unless the difference turns to $0.00. It indicates that your account is balanced accurately.
• Click Edit Info to adjust the Ending Balance or ending date if your account isn’t balanced.
• If you find the difference is $0.00, click Finish Now > Done.

Note: If you have linked a bank account to QuickBooks Online, your transaction info comes directly via bank. In certain cases, your accounts might already be balanced.

Result: 

This shows that your accounts are now reconciled and up to date. Once done, QuickBooks saves a reconciliation report. To review these reports, on the Reconcile Page, choose History by account.

How to Do a Bank Reconciliation in QuickBooks Desktop? 

Here are step-by-step instructions to reconcile a bank account in QuickBooks Desktop.

Prerequisites Required: 

• Ensure that you have created a backup of the QuickBooks company file.
• You need a bank or credit card statement. Look for the beginning and ending balances and the statement’s end date.
• Check the opening balance when reconciling for the first time.

To Reconcile an account in QuickBooks Desktop, follow these step-by-step instructions.

Start your reconciliation 

After getting the bank statement, you can start reconciling.

For reconciling multiple months, begin with the oldest bank statement. You must reconcile each month separately, one statement at a time.

• Move to the Banking menu and click the Reconcile option.
• Pick the bank or credit card account you want to reconcile from the Account field.
• You will see that the Statement Date will automatically be filled. This is mainly 30 or 31 days after the previous reconciliation’s statement date. Confirm that this is the same as the end date on your statement.

• Your Beginning Balance will also be filled automatically by QuickBooks. It will use the ending balance from your last reconciliation. Confirm that it tallies with the beginning balance on the statement.
• Type the Ending Balance from your statement.
• Also, provide whether there is any Service Charge or Interest Earned not yet entered in QuickBooks.
• Click Continue to access the Reconcile window.

If your beginning balance doesn’t tally with your statement, you can take help from a few tools.

• If the numbers don’t match, click Locate Discrepancies. This will provide you with reports that can help you spot discrepancies and other reconciliation problems.
• If you have to begin from scratch, choose Undo Last Reconciliation. 
• Compare your bank statement and QuickBooks 

For reconciliation, you must match the list of transactions on your bank statement with the QuickBooks program.

Verify that you have the right dates and transactions. Once you have reviewed the statement, you are all set to go into QuickBooks.

Before proceeding further;

To make your bank reconciliation look smoother and easier;

• Click Hide transactions after the statement’s end date to check out the transactions for the statement period you are working on.
• To reconcile a credit card account, the sections are Charges and Cash Advance (purchases) and Payments and Credits (payments to the credit card company). Concentrate on one at a time to avoid confusion.
• To reconcile an account for online banking, click Matched. Then, type the Statement Ending Date from your bank statement. This will eventually choose transactions that are downloaded and matched by QuickBooks.
• Choose the header or title of the column to sort the list.
• If you have more transactions in QuickBooks than your bank statement, rearrange the list once again.

Match your transactions 

• Begin the procedure by starting with the first transaction on your bank statement.
• Now, look for the same one in the Reconciliation window in QuickBooks.
• Match both of these transactions. If the transaction matches, place a tick mark in the checkmark column. This will reconcile the transaction.
• Match each transaction on your statement with the one present in QuickBooks. As soon as you clear or add transactions, the Cleared Balance amount decreases. The amount will increase if you have cleared or added deposits along with other credit card accounts.
• If you don’t find a transaction on your statement, avoid marking it as reconciled. Follow these simple steps to see if things are matching;
  • To find the total number and amount of transactions added for reconciliation, search for the Items you’ve marked cleared section. Many financial institutions deliver the exact summary of transactions on bank statements. Match the total number of transactions to spot whether anything is missing.
  • If you want to edit or get more details regarding a specific transaction, choose the transaction, click Go To, or double-click.
  • To return and make necessary changes to the details you added in Step 3: Start your reconciliation, click Modify. You will see the service charges, interest, and ending balance info shown in the section next to it.

• Once you reach the end, confirm that the difference between the two should be $0.00. After this, click Reconcile Now.

Results: 

• QuickBooks will save the completed transaction.
• It shows that your account is balanced, and the transactions in QuickBooks will match your bank statement.

Next Steps

Once reconciliation is done, click Display to see the reconciliation report or Print to print it.

To review a reconciliation report later on;

• Click the Reports menu and then hit Reports Center.
• Locate and then open a previous reconciliation report.
• Choose the account that you want to reconcile, and click either Detail, Summary, or Both.

How to Reconcile An Account For the First Time

Reconciling an account for the first time in QuickBooks requires one extra step that doesn’t occur in a routine monthly reconciliation, which is checking the opening balance.

Before matching transactions, compare the Opening Balance Equity entry in your account register with the actual balance on the bank statement for the day before you start tracking the account in QuickBooks.

Check Your Opening Balance 

Your opening balance is the starting point for your account in QuickBooks. If the amount is incorrect, this shows that the reconciliation is not balanced even though the transactions are entered correctly.

To verify it;

• Open the account register in QuickBooks and search for the Opening Balance Equity entry.
• Look for your bank statements for the period immediately before you track the account in QuickBooks.
• Review the bank balance as of the day before your QuickBooks tracking began.
• Compare the statement balance with the Opening Balance Equity amount in the register.
• If the amount doesn’t match, correct the opening balance in the account register before starting the reconciliation.

Once the reconciliation is correct, move ahead with the reconciliation by entering the statement’s ending date and ending balance. Then, match the transactions provided on your bank statement.

How to Reconcile a Credit Card Account In QuickBooks Online?

To reconcile a credit card account in QuickBooks Online;

• Move to Accounting or click on the Gear icon.
• Select your credit card and match the charges and payments to your statement.
• Make sure you match the payments until the difference amount becomes $0.00.

How to Fix Beginning Balance Problem in QuickBooks Online?

Users may encounter a discrepancy in the beginning balance when something changes on a transaction since a past reconciliation. Other factors that may cause this issue are;

• Incorrect opening balance
• A categorized bank transaction that was undone is sent back to pending.
• A transaction dated on the last reconciliation ending date that was reconciled manually is added to the beginning balance outside of reconciliation.
• A reconciled transaction was edited, moved, or unreconciled.

Steps to Resolve the Beginning Balance Problem

After knowing why the beginning balance problem occurs, let’s perform the troubleshooting methods below to fix the issue.

First Step: Prepare to Reconcile

• Keep all the bank statements for the account and date range you want to reconcile. Admin access is required to make any changes to the reconciliations.
• Select All Apps > Accounting > Bank Transactions.
• Confirm that every transaction from the period is matched, categorized, posted, or excluded. For accounts that are linked with online banking, match and categorize all downloaded transactions.

Second Step: Open the Reconcile Discrepancy Report

• Click All Apps > Accounting > Reconcile. 
• Choose the account by clicking the Which account do you want to reconcile drop-down menu.
• Look for the alert stating “Your account isn’t ready to reconcile yet. Your beginning balance is off by…”. 
• Now, hit the We can help you fix it option.

Third Step: Review & Fix Each Change

Now, work through the report one transaction at a time.

• Select the “What happened” column to see what changed, when, and who changed it.
• Now, click Review in tray for the details. To see the full history of a transaction, select the drop-down menu beside Review in tray and click View History.

Before making any corrections;

• Only correct a change made in error. Some changes are intentional, whereas the suggested fix assumes an error. If a correction affects a reconciled period or opening balance and you’re not certain, talk to your accountant.
• If a fix asks you to reconcile an individual transaction, you can mark it as R (Reconciled) in the account register or reconcile the account again using the same ending date and ending balance as your last reconciliation. Both will rectify the beginning balance, but only reconciling again will record the change on a reconciliation report. Both will correct the beginning balance, but only reconciling again can record the change on a reconciliation report.

Fourth Step: Check For Other Changes 

If you see that your report is clear but the balance is still off, it won’t show two kinds of changes there;

• Deleted and voided transactions 

Choose the Settings menu and click Audit Log. Apply a filter to the account and the period since your last completed reconciliation. Review the audit log for deleted or voided transactions.

• Transactions reconciled outside of a typical reconciliation 

• Choose All Apps > Accounting > Charts of Accounts.
• Now, click View Register for the account you want to review.
• Apply a filter to the account by Reconcile status. Look for any transaction marked R dated after your last completed reconciliation.

Confirm your balance is fixed

Once you’ve resolved all discrepancies, the Total discrepancy should be $0.00. The adjustments should also match the difference you identified in Step 1. Your beginning balance should now agree with the bank statement, allowing you to proceed with the reconciliation.

How to Undo a Bank Reconciliation in QuickBooks?

To correct a previously reconciled transaction or fix an incorrect reconciliation, you can undo the reconciliation in QuickBooks.

• Select the Settings icon and click Chart of Accounts.
• Check for your bank or credit card account. Then, pick the Account History or View Register option.
• After this, locate the reconciled transaction.
• Within the Reconciliation status column, choose the transaction’s status.
• Change R (Reconciled) to C (Cleared) or leave the field blank.
• Finally, save the necessary changes made.

Steps to Undo Bank Reconciliation In QuickBooks Desktop

• Initially, open QuickBooks Desktop and select the Banking menu.
• Choose the Reconcile option and opt for Undo Last Reconciliation.
• Now, go through the reconciliation you wish to undo.
• Finally, click Undo to confirm.

How to Troubleshoot Reconciliation Problems in QuickBooks

Are you still struggling with QuickBooks bank reconciliation problems? Then start by identifying the cause of the reconciliation discrepancy instead of the account to balance.

• Duplicate Transactions: Check whether the transaction was entered manually and then imported via bank feed.
• Edited, voided, or deleted transactions: See the previously reconciled transactions to see if any transaction is changed, edited, or voided after reconciliation.
• Incorrect transaction dates: Ensure that the transactions are correctly dated and fall within the statement period being reconciled.
• Unreconciled or uncleared transactions: Search for the transactions left over from a last period that must be cleared or reconciled.
• Incorrect opening or ending balances: Match the QuickBooks balances with the bank statement and confirm the statement date and ending balance are entered accurately. 
• Reconciliation doesn’t match with the Balance Sheet: Verify that the “as of” date on the reconciliation report matches with the date used on the Balance Sheet. Confirm that you are checking the same bank account that was reconciled.
• Don’t force the difference to be zero: Identify and then correct the underlying transaction or balance issue rather than using an unsupported adjustment to eliminate the reconciliation discrepancy.
• Recheck after corrections: You can now run the reconciliation reports and confirm that the difference is $0.00 before completing it.

How to Export, Print, and Read Your Reconciliation Report

The reconciliation reports provide a summary of the following;

• Beginning and ending balances
• Lists which transactions were cleared and which are pending when you reconcile.

Steps to view a reconciliation report 

• Choose the Reports icon and click Standard Reports.
• Enter “Reconciliation Report” into the Find Report by name search box.
• Click Reconciliation Reports and pick the Account for the reconciliation report you want to view.
• Select the reconciliation period by clicking the Report period drop-down menu.
• Once done, tap on View Report.

For Printing a Reconciliation Report 

To print the reconciliation report, click on the Printer icon at the upper right of the report.

Steps to Export a Reconciliation Report to Excel 

The reconciliation report in QuickBooks Online is one of those reports that can be exported directly to Excel. Here’s how to export it manually;

• First, highlight the information on the report.
• Right-click on the report and then copy the information.
• Now, open an Excel file, right-click on it, and paste the information.
• Set the column width according to the Excel report format to show all the information.

Bank Reconciliation Example

Here’s an example stating how outstanding transactions and bank-only items bring the bank and book balances into agreement. It follows the standard QuickBooks reconciliation method of adjusting the bank balance for timing differences and the book balance for items not yet recorded in the books.

Example: A business is reconciling its account at the closing month.

Bank Side: 

• Bank Statement ending balance: $10,000
• Add: Deposit in transit: + $1,500
• Less: Outstanding check: −$500
• Adjusted bank balance: $11,000 

Book Side:

• Book balance: $10,700
• Add: Interest earned not yet recorded: +$350
• Less: Bank service fee not yet recorded: −$50
• Adjusted book balance: $11,000

Result: Both the adjusted bank balance and book balance are $11,000, which means the account is reconciled. Outstanding deposits and checks are timing differences, but bank fees and interest needs to be updated in your records.

Best Practices for QuickBooks Bank Reconciliation

Performing the following practices will keep your financial records accurate and make it easier to identify the discrepancies between accounts. Thus, it provides a clear insight into your business cash position.

• Reconcile your bank accounts monthly to identify errors easily.
• The statement date and ending balance must be correct.
• You must search for the cause of any difference instead of forcing reconciliation to balance.
• Save statements and reconciliation reports for future reference.
• Once an account is reconciled, avoid changing or deleting reconciled transactions unless necessary.
• Compare deposits, payments, transfers, fees, and other transactions with your bank statement.
• Add bank charges and interest that aren’t already recorded.
• For a first-time reconciliation, ensure it matches your actual bank balance before you started tracking in QuickBooks.
• Make sure imported and manually entered transactions aren’t duplicated.

Bringing It Altogether

QuickBooks Bank reconciliation plays a major role in keeping your financial data accurate and to the point. By regularly comparing QuickBooks transactions corresponding to your bank transactions, you will help spot discrepancies like missing, duplicate, or incorrect transactions. Then, it helps resolve reconciliation problems instantly. Checking opening balances, reviewing outstanding transactions, and investigating differences instead of forcing the account to balance can help prevent errors from carrying ahead into the future period.

With a consistent reconciliation process, you can maintain cleaner books and get a clear picture of the company’s financial status. If the issue still exists, then have a one-to-one consultation with our QB professionals at BooksMerge. Call us at +1-866-513-4656.

About The Author

Meghan McKenzie, CPA, is a senior accounting technology writer with over a decade of experience helping US small businesses streamline their financial operations. She specializes in resolving complex accounting software errors, automating workflows, and translating technical tax and bookkeeping standards into practical advice.