Skip to main content
March 15, 2022
Question

Reconciliation always off $3

  • March 15, 2022
  • 1 reply
  • 0 views

Hi, all. I'm having a weird and frustrating issue while reconciling a credit card account. The reconciled items for a particular amount match perfectly with my statement, and the charges and payments total correctly. However, QB shows a difference of -$3.00. I checked everything 2 more times (there are only a few items), and just as a test, adjusted one charge down $3 so the difference was $0.

 

Then, when I went to the next month, the exact same thing happened: the mystery $3 difference. Checked everything against the statement once again, and it's perfect. It almost feels like this must be a bug, and that QB's math is off.

 

I've reconciled other accounts with no problem. I'm using QB on the browser, not the desktop. Any ideas on what's happening and how to fix it?

1 reply

March 15, 2022

Let's investigate what's causing this reconciliation discrepancy issue, lanarkllc. 

 

There are a few reasons why the difference amount won't match up on the Reconcile page. Reconciliation discrepancies are usually caused by the following factors:

  • duplicate transactions
  • the transaction was associated with a different bank account
  • previously reconciled transactions were edited or deleted
  • the opening balance of an account is incorrect

 

We can try reviewing your previous period's reconciliation. This will help us determine whether the opening balance for the current period is correct. You can follow the steps in this article: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

 

You can also run a Reconciliation Report to view previous reconciliations to see if everything has balanced out, as well as see what transactions were recorded. Here's how to run the report:

  1. Go to Reports.
  2. Type Reconciliation Report in the Find report by name search bar.
  3. Select Reconciliation Reports.
  4. Choose the Account for the reconciliation report you want to view.
  5. From the Report period drop-down arrow, pick the reconcile period.
  6. Hit View Report.

 

I'd like to provide you with a couple of Community Articles that you may find useful:

 

If you need further assistance, please don't hesitate and reach back out to us. We are just a Reply away. Have a great day ahead.