Skip to content

A Guide to Fix QuickBooks Reconciliation Discrepancy

  • You edited or deleted transactions after they had been reconciled.
  • You might have entered transactions into QuickBooks that haven’t been cleared by your bank yet.
  • You made an adjustment to the last reconciliation by making a journal entry.
  • You might have entered an incorrect ending balance at the start of the reconciliation.
  • Some transactions are missing from QuickBooks, or there are duplicate transactions.

To find and resolve the reconciliation discrepancies, let us check and review all the aspects, such as missing or deleted transactions, reconciliation adjustments, opening and beginning balances, and more.

fix quickbooks reconciliation discrepancy message

1. Review the Opening and Beginning Balances

The first thing you should do when you start reviewing the reconciliation is to check your opening and beginning balances. 

The opening balance is the amount you had in your bank account when your financial period began. In other words, it is the first entry of the financial period. 

On the other hand, the beginning balance is the bank balance when you connect your bank account to QuickBooks. 

If either the beginning balance or opening balance is incorrect, there will be an issue with the reconciliation.

First, check the opening balance of the financial period in which you find a QuickBooks reconciliation discrepancy. If the opening balance matches your bank statement, you can proceed to step 2. However, if the opening balance is wrong, go back to the last financial period and check the opening balances for it.

Find the point where the bank statement and the opening balance match. Then, start reviewing your reconciliation.

2. Check the Ending Balance Entered

You enter an ending balance when you begin reconciling, which QuickBooks uses to check if everything is correct with the books. 

check the ending balance entered in quickbooks

Let us check if the ending balance you entered was correct.

  • Go to the Reconciliation window. Choose Edit info.
  • Check the Ending date and Ending balance.
  • Review the bank statement, and if any changes are required, make them.
  • Finally, choose Save.

However, if the QuickBooks reconciliation discrepancy persists even after doing so, proceed to the next step.

Know More: System Requirements for QuickBooks Desktop 2024.

3. Find Changed, Deleted, or Added Transactions

If an entry is mistakenly changed, deleted, added, or duplicated, it can lead to issues with reconciliation. 

Plenty of reports in QuickBooks allow you to find the transactions that were changed or deleted. 

1. Run the Reconciliation Discrepancy report

The Reconciliation Discrepancy report allows you to find the transactions that have been changed since you last reconciled.

  • Open QuickBooks and click on the Reports menu. 
  • Now, hover the cursor over Banking. Choose Reconciliation Discrepancy.
  • Pick the account you want to reconcile for and choose OK.
  • Check and review the report to find any discrepancies.

Find out who made the changes and determine if the reason for the changes was valid. If necessary, you can edit or delete the transactions. 

Know More: Why QuickBooks Reports Not Showing Memo or Description.

2. Missing Checks Report

A missing check can cause a discrepancy between QuickBooks’ ending balance and the bank statement. To find the missing checks, let’s run the Missing Checks report. 

  • Go to Reports and tap on Banking
  • Choose Missing Checks.
  • Pick the account you are reconciling for and select OK.

Review the reports and look for any transactions that aren’t on the bank statement. These transactions shouldn’t be on your reconciliation list.

3. Run the Transaction Detail Report

You can run the Transaction Detail report to find any changes in the transactions.

  • Open the Reports menu and hover the cursor over Custom Reports.
  • Choose Transaction Detail followed by the Display tab.
  • Go to the Date From field and pick the earliest date in QuickBooks for the account. Alternatively, you can leave it blank.
  • Now, in the Date to field, choose the date of your last reconciliation.
  • Tap on the Filters tab.
  • Go to the Account field and choose the account you want to reconcile for.
  • Navigate to the Entered/Last Modified field. Here, set the last date when you had reconciliation as the Date from and today in the Date to field.
  • Tap on OK to run the report.
  • Find the transactions or discrepancies that do not match your bank statement.

Find who made the changes and get to know if the reason the changes were made was valid. If required, you can edit or delete the transactions. 

However, you can read the article if your QuickBooks American Express not syncing or reach out to an accountant if you need any assistance.

4. Look for Reconciliation Adjustments

Sometimes, at the end of the financial period, while reconciling the books, things don’t align. You or your accountant might have made an adjustment to force close the reconciliation. These adjustments shouldn’t be made until you are sure they won’t impact the books or reports.

Let us find the reconciliation adjustments and check if any of them were made inaccurately. 

  • Open the lists menu and choose the Charts of Accounts.
  • Now, tap on the Reconciliation Discrepancies account.
  • Go to the Dates field and select the dates that expand some last reconciliations you had.

Now, review all the reconciliation adjustments and check which ones were inaccurate. Edit or delete any adjustments as required. However, before you do so, consult an accountant.

5. Review Combined Transactions

Often, you’d find that in your bank statement, there would be several payments combined in one. If that is the case, you should do the same in QuickBooks.

If you find the payments are not combined in QuickBooks, transfer them into the Undeposited Funds account. Now, make a bank deposit to combine these payments into a single entry.

After doing so, review your reconciliation report. If you still find a discrepancy, move to the next step.

6. Narrow Down the Transactions

To find the transactions causing it, you can find the ones that you know are surely correct and remove them from the list. 

Or you can print out the bank statement and then mark the ones that you know are correct. This will leave you with a short list of the transactions you will need to check for issues.

Once you review them, move to the next step.

7. Add Transactions Not in QuickBooks

We need to make sure that all the transactions were entered into QuickBooks. If you have connected the accounts to online banking, you must review and categorize all the downloaded transactions before you can reconcile them.

Now, go to the reconciliation window and review these transactions. If you find a bank transaction that is in the statement but not recorded in QuickBooks, here’s what to do:

  • Click on Bookkeeping and choose Transactions.
  • Tap on All Sales or Expenses.
  • Find the transactions that aren’t in bank statements but not in QuickBooks.
  • When you find them, click on them to open it.
  • Now, review the Deposit to or Payment account. Check and ensure the transactions are in the correct account. If required, you can select a different account for the transactions.

After you have double-checked everything, you will know what transactions to enter. Enter these transactions on bank statements but not in QuickBooks.

8. Remove Transactions Not in Bank Statement

Now, we will find the transactions that are in QuickBooks but not in the bank statement. These are redundant transactions that should not be in QuickBooks. 

When you find such transactions, here’s what you should do:

  • View the transaction date and check your bank statements for the same timeline.
  • Note down the date and amount for the transaction.
  • Now, run a past reconciliation report for these dates.

a. If you don’t find the transaction on the past reconciliation report

In a transaction that is on a previous bank statement but not on the past reconciliation report for the same dates, here’s what you should do:

  • Open Bookkeeping and choose the Chart of Accounts.
  • Select the account you want to reconcile. Choose View register.
  • Now, locate and select the transaction to open it.
  • If the checkbox is blank or has a C, you need to ensure the transaction is accurate. 
  • Now, mark the checkbox until you see an R. However, if there is already an R in the checkbox, leave it as is.
  • Finally, choose Save.

b. If you don’t find the transaction on the past reconciliation report

Now, we will check and find the duplicate transactions. 

  • Open Bookkeeping and choose Transactions
  • Now, tap on All Sales or Expenses.
  • You can sort the lists as you want, such as by customer, date, vendor, or amount.
  • If you find entries that you are sure are duplicates, you can go ahead and delete them. (In case of duplicate entries, keep one and delete the other so that the same entry only shows once.)
  • Open Bookkeeping and choose the Chart of Accounts.
  • Select the account you want to reconcile for and choose View Register.
  • Locate the transaction and select on it to expand it.
  • Choose Delete followed by Yes to confirm.

After you have got rid of all the duplicate transactions, move on to the next step.

9. Review Transactions Slightly Off

Is there a transaction in QuickBooks that matches your bank statement but is slightly off? It means it doesn’t match exactly. Talk to your accountant and review these transactions. 

10. Check for Bank and Transaction Fees

Your bank’s ending balance and the one on your QuickBooks might not match for one reason. Your bank charges transactions and other fees, which might not be entered in QuickBooks.

If you find some transaction fees or charges that are not entered in QuickBooks, enter them.

If fees were added:

  • Choose + New.
  • Tap on Bank deposit.
  • Now, add a bank or processing fee to the account you are reconciling.
  • Go to the Memo section and choose a note about which transaction it’s linked to.

Finally, check for the mistakes in your bank or credit card account. Sometimes, there could be a mistake from the financial institution’s side, although it is rare.

Finish Reconciling

The above steps will help you resolve the QuickBooks reconciliation discrepancy. Once you are done, you can conclude reconciling and close off the books. 

you finish reconciling

However, if you still have an issue reconciling your QuickBooks accounts, you can connect with a  A2 Auto Care QuickBooks experts, who is an expert in accounting. Dial +1(800) 780-3064 and speak to an expert!

1. How do I fix a reconciliation discrepancy in QuickBooks?

To resolve the QuickBooks reconciliation discrepancy, here’s what you can do:
a. Now, check the reports for edited, deleted, or missing transactions 
b. Moreover, check the opening and beginning balances
c. Find the reconciliation adjustments and check if they are correct

2. What is the discrepancy in reconciliation?

The discrepancy in the reconciliation means a difference between the ending balance of QuickBooks and the bank statement. The ending balance for the bank statement and QuickBooks both should be the same.

3. What to do if there is a difference in bank reconciliation?

If there is a difference in bank reconciliation, edit, add, or delete the transactions as needed. For detailed steps, consult our guide on how to resolve QuickBooks reconciliation discrepancies.

Leave a Reply

Your email address will not be published. Required fields are marked *