Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Janet32
Level 1

Accounts Receivable discrepancy

Customer's payment does not meet up with Statement Charges.

 

Balance Sheet Detail shows he paid -131.00 which he did

Open Invoices shows balance: 0.00 (correct amount)

Customer Statement Charges show 131.00

Customer Balance Detail shows 0.00 (correct)

 

Balance Sheet shows Assets: Accounts Receivable -131.00

Why does Balance sheet show -131.00 when should be 0.00?

How to fix

1 Comment 1
jamespaul
Moderator

Accounts Receivable discrepancy

Hello, Janet. 

 

Yes, I agree that the Balance Sheet should show zero after processing the invoice payment. There could be a couple of reasons why this is happening, and I'll help you fix this with these solutions. 

 

First, it could be a duplicate transaction that affects the Balance Sheet report. You can drill it down by clicking the -131 amount. This shows the transactions booked under the balances. If it's a duplicate, you'll want to simply delete it from your books (you might want to review this first). 

 

Another way to review and check for duplicates is to run the Transaction List by Customer. Here's how: 

 

  1. Go to Reports, then hover your mouse on Customers & Receivables
  2. Choose Transaction List by Customer.
  3. Review the listed transaction and check for the -131 amount (it could be listed under a different customer).
  4. Open the transaction, then click the Delete button. 

 

Delete1.PNG

 

The second reason is that the link between the payment and the invoice is damaged. In this case, you'll want to delete the payment and recreate it. Simply open the payment transaction, then click the Delete button. 

 

A data integrity issue could also be the reason why there's a discrepancy on your Balance Sheet report. In this case, you'll want to run the Verify and Rebuild tools. Check this article for the steps and details how: Fix data damage on your QuickBooks Desktop company file.

 

After fixing the discrepancy, you can start managing your bank transactions or do your regular reconciliation process. You can check these pages and look for an article of your choice: 

 

Need help with something else in QuickBooks Desktop? Please let me know and I'll be happy to show you a thing or two on how to achieve it. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us