cancel
Showing results for 
Search instead for 
Did you mean: 
Maverick2
Level 6

Customer show zero balance in QB, no outstanding invoices, but is on the A/R report

Customer shows zero balance in QB, no outstanding invoices, but is on the A/R report

 

  1. Customer record shows 0.00 balance.
  2. Has no open invoices.
  3. On A/R report the customer shows up, but all columns are 0.00.

 

How do I get rid of that?

Solved
Best answer March 17, 2022

Best Answers
Carneil_C
QuickBooks Team

Customer show zero balance in QB, no outstanding invoices, but is on the A/R report

Help has arrived, @Maverick2. I want to make sure you’ll be able to sort out this issue with the zero balance in your Accounts Receivable Aging report in QuickBooks Desktop.

 

When running the report, ensure that it's modified according to date. This way, it will show the customers' account balances, and we can identify which have active payables as of today and the number of days they have been outstanding.

 

Here’s how:

  1. Go to Reports.
  2. Select Customers and Receivables and choose A/R Aging Summary.
  3. Click the Dates drop-down menu and select a date of your transactions.


Otherwise, users may experience discrepancies in their company files as a result of data damage. You can use the Verify and Rebuild tools to get this resolved. Also, please ensure that your QuickBooks Desktop is updated.

 

You also can review this handy resource for further details about A/R balance on the Chart of Accounts does not match A/R balance on reports.

 

I'm also adding these resources which you can check for an additional guide on your future tasks in QBDT:

Keep me posted if you still have questions or concerns about your transactions in QBDT. I'll be around for you. Have a great day! 

View solution in original post

3 Comments 3
Carneil_C
QuickBooks Team

Customer show zero balance in QB, no outstanding invoices, but is on the A/R report

Help has arrived, @Maverick2. I want to make sure you’ll be able to sort out this issue with the zero balance in your Accounts Receivable Aging report in QuickBooks Desktop.

 

When running the report, ensure that it's modified according to date. This way, it will show the customers' account balances, and we can identify which have active payables as of today and the number of days they have been outstanding.

 

Here’s how:

  1. Go to Reports.
  2. Select Customers and Receivables and choose A/R Aging Summary.
  3. Click the Dates drop-down menu and select a date of your transactions.


Otherwise, users may experience discrepancies in their company files as a result of data damage. You can use the Verify and Rebuild tools to get this resolved. Also, please ensure that your QuickBooks Desktop is updated.

 

You also can review this handy resource for further details about A/R balance on the Chart of Accounts does not match A/R balance on reports.

 

I'm also adding these resources which you can check for an additional guide on your future tasks in QBDT:

Keep me posted if you still have questions or concerns about your transactions in QBDT. I'll be around for you. Have a great day! 

Maverick2
Level 6

Customer show zero balance in QB, no outstanding invoices, but is on the A/R report

I figured it out. The customer actually did have an outstanding invoice but an equal credit, ergo net zero.

JB CST BBA
Level 1

Customer show zero balance in QB, no outstanding invoices, but is on the A/R report

I always use the A/R Detail report... takes a million years to load, but then it shows you every single item.

Click in any invoice line, and it opens that transaction, so you can apply the credit. 

I actually export the list to excel so that the report doesn't try to refresh after I've applied a credit.  I just have excel on one monitor, and QB on the other, and just run down the customer list, applying Credits, charging cards on file, or sending statements.  Makes collections a breeze.   

IMO - The AR summary is really only useful for Financial Statements, or when I need aging totals for A/R indebtedness reservation calc.

Need to get in touch?

Contact us