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

Maverick2 · ‎March 17, 2022

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

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

How do I get rid of that?

Carneil_C · ‎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:

Go to Reports.
Select Customers and Receivables and choose A/R Aging Summary.
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

Carneil_C · ‎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:

Go to Reports.
Select Customers and Receivables and choose A/R Aging Summary.
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 · ‎March 17, 2022

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

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.

Elena-UniqueMetal · ‎March 05, 2026

The AR Detail report version suggested here seemed like the answer to my issue, however, it seems like I can't apply credits because my predecessor entered offsets as General Journal entries instead of credits, so I can't apply them. Does anyone know how to resolve that issue? I want to stop seeing these $0 balance customers on my reports! The activities happened way back in 2012-2016.

MoiraskyeT · ‎March 05, 2026

Hi, @Elena-UniqueMetal. You can use a General Journal Entry (GJE) to record credits, ensuring they are applied correctly so that the credits are reflected accurately and accounts are posted properly.

You can ask for help from an accountant to review the GJE created.

Alternatively, you can delete the GJE and record the transaction as a Credit Memo instead.

Please reply to this thread if you have additional concerns.

Elena-UniqueMetal · ‎March 09, 2026

I don't doubt that the GJE's were entered correctly, but they don't appear to connect/apply to the customer account in such a way that the customer disappears from the outstanding AR reports. The customer will show on the reports, as $0 owing, instead of disappearing from the reports as they would if these were regular AR credits. I don't know that going back 10+ years and deleting a GJE is the correct solution.

ZackE · ‎March 09, 2026

Thanks for following up with the Community, Elena-UniqueMetal. I appreciate your detailed information.

To properly identify if the journal entries entered in your books are correct, or what you may need to do to be able to apply them as credits like you're wanting to, I'd recommend working with an accounting professional.

If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

I've also included a detailed resource about working with journal entries which may come in handy moving forward: Create & manage journal entries

Please don't hesitate to send a reply if there's any questions. Have a wonderful Monday!

Topics

Training

Community

Resources

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