How to Fix QuickBooks Reconciliation Discrepancy in QuickBooks

If you have faced Reconciliation Discrepancy in QuickBooks, and want an immediate solution to resolve the error, Then this article is here for you. Read this article carefully, so as to understand how to resolve and fix QuickBooks reconciliation discrepancies. Go through the complete article and get solutions in simple steps, learn to troubleshoot the issue. For any suggestion or help contact our Quickbooks ProAdvisor toll-free: +1-844-405-0904

QuickBooks Reconciliation Discrepancy occurs by the reconciliation adjustments such as QuickBooks Journal entries or previously reconciled transactions that have been changed, added, or deleted, etc.

Causes of Reconciliation Discrepancy in QuickBooks

Steps How to Fix a Reconciliation Discrepancy in QuickBooks:

If you are encountering a discrepancy problem it may be due to an error given above. If at first, the actual cause is not known, then you have to try both methods to see what works.

Modified Previously Reconciled Entries:

Your accounting balance will affect if you have made any changes to your already reconciled transactions. If you feel like this is the reason your accounts are not matching, then you have to run 3 different types of reports to find out any discrepancies.

  • Reconciliation Discrepancy report,
  • Missing check report,
  • Detailed entry report.

Reconciliation Discrepancy Report:

This report is basically tracks all your accounting entries and sorts them by date, noting the most recent changes at the top. Run the report and you will find any recent changes that have caused the reconciliation error. Following are the steps to run a reconciliation discrepancy report in QuickBooks:

  1. Open QuickBooks and go to the top navigation bar, and click on the Reports tab.
  2. Later, go to the drop-down list, and click on the Bank tab.
  3. Now, look for the reconciliation discrepancy button and click on it.
  4. Select the account for that you need to run a discrepancy report.
  5. Wait here to processes your report.
  6. Now, after processing, open the report and look out for any discrepancy.

Missing Check Report:

This report will guide give you to any information. Regarding any entry, you may miss. You can run a missing check report in the same way as a reconciliation discrepancy report.

  1. First, go to the Reports tab on the top corner panel.
  2. Next, go to the bankings tab, and click on the missing check
  3. Select the account for that you need to run a discrepancy report.
  4. Click on Ok and Check out for any entries that you have missed in your books, but are being deposited in your bank.

Detailed Entry Report:

With a detailed entry report, you can each and every entry and locate any changes made:

  1. First, you need to go to the reports section of your QuickBooks dashboard.
  2. Now, click on the custom report tab from the drop-down list.
  3. Later, go to the detailed entry report.
  4. Click on the date range for which you need to check the reconciliation report.
  5. Click on the account and generate a filter if required.
  6. At last, click on Ok, and run the report.

After Running the above reports you will be most probably able to know “How to fix a reconciliation discrepancy in QuickBooks”. now you can fix the issue by yourself or also get technical help from our QuickBooks expert.

Forcefully Adjusted Entry:

If after running the above report you are still unable to fix your problem, check for any reconciliation adjustments made in the past. For this:

  1. Go to the QuickBooks dashboard, and click on the COA
  2. Later, click on reconciliation discrepancy
  3. Now, you can run the report and look for any suspicious entry.
  4. If you have noticed nothing wrong, then you need to undo any changes made recently until you see a matching and correct balance.

We hope, the article would help you to fix the reconciliation issues. If you need further assistance dial our toll-free [Quickbooks] and get in touch with our technical support team.

Call Now