How to fix a reconciliation discrepancy in QuickBooks?

How to fix a reconciliation discrepancy in QuickBooks?

Reconciliation can be highly time-consuming and frustrating task even for the most experienced accountants. Though with the help of certain accounting software’s the time consumption has been reduced to much extent but errors still remains an issue which causes differences in accounting statements. If you are also facing the same difference issues then today we will answer “How to fix a reconciliation discrepancy in QuickBooks”.

Are you a Quickbooks user?

Though we have already covered on the below-given topics, thus if you are not able to correctly work on reconciliation part of QuickBooks then request you to go through them before jumping on how to fix a reconciliation discrepancy in QuickBooks.

How to fix a reconciliation discrepancy in QuickBooks?

Before looking for a fix, we need to first understand why we see such discrepancies in the reconciliation discrepancy report?

Well, there are 2 reasons that can cause such an error:

  • When entries reconciled in the past have been accidentally changed or modified.
  • When an entry has been forcefully adjusted.

Steps on how to fix a reconciliation discrepancy in QuickBooks:

As already said, that if you are facing discrepancy issue then it may be because of any of the above-given error. If at first, the real cause is not known then you would have to try both the methods to check out what works.

Modified previously reconciled entries:

If you have made any changes in your already reconciled transactions then this will affect your accounting balance. If you feel like, this is why your accounts are not being matched then you will have to run 3 different types of reports to find for any discrepancy.

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

Reconciliation discrepancy report:

What this report basically does is, track all your accounting entries and sort them date wise keeping most recent changes on the top. Run the report and you will find any changes done recently that has caused reconciliation error. Below are the steps to run reconciliation discrepancy report in QuickBooks:

  1. Launch QuickBooks and from the top navigation bar, choose reports tab.
  2. From the drop-down list, click on Bank tab.
  3. Navigate to the reconciliation discrepancy button and click it.
  4. Choose the account; you want to run discrepancy report for.
  5. Wait until it processes your report.
  6. Go through the report and check out for any discrepancy.

Missing check Report:

This will help you give any info. about any entry, you might have missed. You can run the missing check report the same way, as reconciliation discrepancy report.

  1. Click on the reports tab from the top corner panel.
  2. From the bankings tab, click on missing check
  3. Select the account, you want to run the report for.
  4. Hit Ok and check out for any entry that you have missed in your books but is being flaunted in your bank.

Detailed entry report:

With this report, check out each and every entry and locate for any changes made:

  1. Head over to the reports section of your QuickBooks dashboard.
  2. Choose the custom report tab from the drop-down list.
  3. Now click on the detailed entry report.
  4. Choose the date range for which you want to check the reconciliation report.
  5. Choose the account and create a filter if necessary.
  6. Hit Ok and run the report.

After running all the reports you will most likely be able to know “How to fix a reconciliation discrepancy in QuickBooks”. Now to make the correction, either you can fix the issue yourself or get in touch with QuickBooks expert. Contact us on the number given above and we will help you fix any discrepancy you may have.

Forcefully adjusted entry:

If even after running the above report you are unable to fix your issue, then check for any reconciliation adjustment done in the past. For this:

  1. From QuickBooks dashboard, click over the COA
  2. Choose reconciliation discrepancy
  3. Run the report and look for any suspicious entry.
  4. If you smell nothing wrong, then undo any changes made recently until you see a matching and correct balance.

Follow the steps above and you will fix your reconciliation discrepancy issue. If for any reason, you still face problems and wonder how to fix reconciliation discrepancy in QuickBooks and we would suggest talking to our QuickBooks proadvisors. Our technical staff is highly experienced and trained to fix your every issue. Thus wait no longer and talk to us now.

Still in Doubt…!

Request a Call Back

Talk to our Quickbooks Proadvisor and resolve your issue over a phone call.

We gaurantee 100% satisfaction

You can even give us a call at our Quickbooks Enterprise Canada, USA and UK at ✆ +1800-940-7442 and talk to our Proadvisor now.

Related articles:

Report Your Issue

(Didn't find what you were looking for! Report your issue and get customized help from our QuickBooks experts.)

QuickBooks Version:
Edition Year:
No of User: Licence
HELP Needed:
Operating System:

What is Qbpro?

We are a Quickbooks and TurboTax consulting firm that takes care of all the issues that people might ever face within these programs. If you are using any of the above platforms and are continuously faced with bugs then we are here to help. You can connect with us for errors related to Quickbooks or TurboTax via any of the medium below:

What Our Clients Say...

Here is what people have to say about us.

Areas we serve:

We are proud to announce that we are covering entire Canada. Thus if you face any issues now, give us a call as our proadvisors work 24/7 to get your issues fixed.

Leave a Reply

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

Contact Me

Leave a Message

Disclaimer: is a reputable QuickBooks® Consulting firm that provides professional support services related to your accounting software. It is also a front-runner in providing 3rd party technical support services for quickbooks.


"Get QuickBooks Support, no matter where you are living in Canada. Just Call and get issues fixed."

Alberta British Columbia Manitoba New BrunswickNewfoundland and Labrador Northwest Territories Nova ScotiaNunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon


Are you confused and not able to manage your books on QuickBooks…!

Dial us: ✆ +1800-940-7442

Still facing issues

Get Help For Your QuickBooks Accounting Software

Resolve your every issue on a
Free 30 minutes call

Enter your details to get a cheat sheet of 96 awesome tricks to use Quickbooks like a pro.

We hate SPAM and promise to keep your email address safe.

Get FREE 30 minutes, Resolve your issues now!

Call Now: 1-800-940-7442