Skip to main content
M
Maverick2
March 17, 2022
Solved

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

  • March 17, 2022
  • 1 reply
  • 0 views

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?

Best answer by Carneil_C

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! 

1 reply

C
Carneil_CAnswer
March 17, 2022

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! 

M
Maverick2Author
March 18, 2022

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

    J
    JB CST BBA
    November 23, 2022

    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.

    Terms & ConditionsAccessibility statement