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

Reconcilliation Discrepancy Report

Hi A colleague has moved some customer payments onto different accounts as they were allocated incorrectly. Now I have a Reconcilliation Discrepancy report that says these payments are amount changed or deleted. Ive checked and they still appear in the Reviewed area on the bank and still appear on the Customer Accounts. They also appear on my reconcilliation list but when I allocate them all my bank doesn't balance.  What can I do to recify this as quickbook Chat tells me to do an adjustment for the difference but I'm obviously wrong somewhere so I need to find where. Any help gratefully received!!

6 Comments 6
Adrian_A
Moderator

Reconcilliation Discrepancy Report

You have me to help you fix this reconciliation, JayneOwen.

 

It's possible that you haven't reconcile the modified transactions. We can fix this by manually change the reconcile status to R.

 

Before doing so, we'll have to view the reconciliation history to see and check the changes you've made. All you have to do is click the Gear icon, and then select Reconcile. Click the History by account link at the upper-right. Then, filter the Account and the Report period.

 

Then, we'll have to manually reconcile the transactions you've modified. Let me guide you with these steps:

 

  1. From the Accounting tab, select Chart of Accounts.
  2. Select the account, and then click View Register.
  3. Select the transactions.
  4. In the () Reconcile column, toggle it to R.
  5. Click Save.

 

Do the same steps for the other transactions.

 

Feel free to browse these articles to know the reconciliation workflow in QuickBooks:

 

 

I'm just a post-away if you still need my help. Thank you!

JayneOwen
Level 1

Reconcilliation Discrepancy Report

Thank you so much for your help.  Is there a way to Print out the Discrepancy report as there are lots on there?  Thanks again

Steve_C
QuickBooks Team

Reconcilliation Discrepancy Report

Hey JayneOwen. Thanks for your reply. To print the report, press Ctrl+P on your keyboard from within the report.

 

This will print the current browser window for you, since there is no print option available withing the report itself yet. Let me know if there are any other questions, I'm happy to answer them. 

JayneOwen
Level 1

Reconcilliation Discrepancy Report

Hi Sorry but i still cant get it to balance.

Ive been through and marked them as reconcilled in the register but its still saying the amount has changed on several of them. The amount hasn't changed tho as it comes from the bank feed and Ive checked against my statements and marked them as econcilled. Any ideas?

 

MaulikH
QuickBooks Team

Reconcilliation Discrepancy Report

Hi, JayneOwen.
Thank you for following up with us.

Here’s a list of possible reasons why these balances don’t match:

 

  • Outstanding transactions.
  • New transactions for a connected account.
  • Duplicate transactions.
  • Edited or deleted transactions.
  • Card (liability) account.

 

Depending on the factor that’s mentioned above, there are different steps to fix your issue. Here’s an article on the steps to fix or adjust these factors: How to Fix Differences Between QuickBooks Balance and Bank Balance. I'm here to help if you have any follow up questions.

MaulikH
QuickBooks Team

Reconcilliation Discrepancy Report

Hi, JayneOwen.
Thank you for following up with us.

Here’s a list of possible reasons why these balances don’t match:

  • Outstanding transactions.
  • New transactions for a connected account.
  • Duplicate transactions.
  • Edited or deleted transactions.
  • Card (liability) account.

Depending on the factor that’s mentioned above, there are different steps to fix your issue. Here’s an article on the steps to fix or adjust these factors: How to Fix Differences Between QuickBooks Balance and Bank Balance. I'm here to help if you have any follow up questions.

Need to get in touch?

Contact us