cancel
Showing results for 
Search instead for 
Did you mean: 
Amy217
Level 1

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

The amount still shows under the Amount column. I am using QBO Plus.
7 Comments
IamjuViel
QuickBooks Team

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

Pleased to have you here, @Amy217.

 

I want to make sure you’re getting the right support in fixing the reconciliation discrepancy in your QuickBooks Online.

 

Reconciliation Discrepancy report is a type of report that can only be generated via QuickBooks Desktop. This specific report displays cleared transactions that were changed since you last reconciled a particular account. Are you perhaps looking at the Reconciliation Summary Report?

 

To fix any issues you have with account reconciliation, you may check out this article for a more detailed information: Troubleshoot reconcile when opening balance is correct.

 

 

Also, I’d recommend consulting an accountant to guide properly in reconciling your account. 

 

If you need further assistance in fixing the reconciliation discrepancy on your account, I’d suggest contacting our Customer Care Team. A specialist will be able to further assist you via secured remote access session.

 

Here’s how to contact us:

  1. Go to the Help menu.
  2. Click Contact Us.
  3. Under How can we help?, type in your “Import Customer’s List”.
  4. Hit Continue.
  5. Click Get our phone number to contact us.

Please keep me posted on how things work on your end. I’m always here to lend a hand in making sure you’re able to reconcile your accounts successfully in QuickBooks Online.

IntegriTesting
Level 1

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

@Amy217 

I am having this exact same issue. Were you able to find a solution?

FritzF
Moderator

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

Thanks for joining this conversation, @IntegriTesting.

 

I see that this thread is tagged as QuickBooks Online (QBO). However, the Reconciliation Discrepancy report is for the desktop version. To ensure that I'm on the same page, what QuickBooks version you're using? Any additional information will be much appreciated. This will help me make sure that I can provide the best resolution.

 

In the meantime, I recommend following the troubleshooting steps provided by my colleague above to fix this. I'm also including these articles for additional information:

 

 

This should get you pointed in the right direction. Keep me posted on how everything goes by leaving a comment below. I want to make sure this is taken care of for you.

IntegriTesting
Level 1

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

@FritzF 

 

I am using Quickbooks Online Plus. I access the Reconciliation Discrepancy Report through the "We can help you fix it" link because my beginning balance is off (although I don't know how that happened since my previous month reconciliation is correct). When the report opens it lists multiple transactions that have already been reconciled. The Reconciled Amount is missing, the Amount is the correct amount of the transaction, and the Difference is the (-)of the amount. They are marked "R" but the Reconciled Amount and the transaction Amount do not match.

IamjuViel
QuickBooks Team

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

I appreciate the complete detail of your concern, @IntegriTesting.

 

When a reconciled transaction is changed or deleted, the system will prompt you about a discrepancy on your account. Let me share additional steps to fix it.

 

a3.gif

Here's how to fix the discrepancy:

  1. In the Reconciliation Discrepancy Report, review the list of transactions that have been changed since the reconciliation.  a1.gif
  2. Click the View link in the History column.
    • You'll see a timeline on when the transaction was updated or changed and who did it.

a2.gif

For the deleted transactions, you'll need to manually re-enter it.  Once entered, you can now re-reconcile the transactions. This process is called mini reconciliation or special reconciliation.

 

Also, I'd suggest consulting with your accountant so you'll be properly assisted when reconciling your account.

 

I've attached some articles below for additional reference:

Fill me in if you have other questions about managing your transactions. I'm just a post away.

Amy217
Level 1

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

To  @IntegriTesting 

I'm not sure if this is your same situation, but I did finally figure out what I did wrong. I had some old previously reconciled transactions that I went back and changed the "Item" I had used on the invoice. But when I changed the item on the invoice, it also changed the amount I had previously entered to zero but I didn't realize that QBO deleted the amount. So I found the transactions that I had changed, took out the zero amount and recorded the correct amount again and saved it. Once I did that, & I went back to do the reconciliation, those transactions were no longer on the report.

Anonymous
Not applicable

On the Reconciliation Discrepancy report it shows zero amount under the Reconciled Amt column but it says "Reconciled in register" under Change Type. How can I fix it?

Thanks for getting back @Amy217, and for sharing the steps you did to fix your reconciliation discrepancy.

 

I'm glad you found the transactions and recorded the correct amount. I hope this scenario can help others as well when fixing their reconciliation discrepancy.

 

Should you have other questions about your reconciliation, please don't hesitate to reach out again. I'm here to help.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us