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

A/R aging report

Is there any way to leave A/R credits for customers that have overpaid, but not have them appear on the A/R aging?  They are throwing my AR balances off a bit and I'd like to run the report without those customers appearing.

Solved
Best answer August 25, 2020

Best Answers
Highlighted
Community Champion

A/R aging report

There isn't a way to exclude only outstanding credits, which do impact your AR balance.

 

View solution in original post

4 Comments
Highlighted
QuickBooks Team

A/R aging report

Hi there, @Gail25.

 

Welcome to the Community. I understand you don't want the A/R credits for customers to appear on the A/R aging report. 

 

The best way to remove them is to apply the deposits as a credit to an invoice. Here's how: 

 

  1. Go to the Customers menu, then select Create Invoices.
  2. Choose the customer from the Customer:Job drop-down.
  3. Enter the necessary information, then click Apply Credits.
  4. Hit Yes to confirm the changes.
  5. In the Apply Credits window, select the deposit from the Credits tab. (Make sure the amount is the same with the invoice)
  6. Click Done to mark the invoice as paid
  7. Hit Save & Close to save the invoice.

 

I'm adding this article for your future reference: AR Balance on the Chart of Accounts does not Match AR balance on Reports.

 

For future reference, you'll want to read through this article to learn more about writing off vendor/customer balances to clear A/R or A/P transactions: Write off customer and vendor balances

 

Let me know if there's anything else that you need help with. I'm always around to assist. 

Highlighted
Community Champion

A/R aging report

There isn't a way to exclude only outstanding credits, which do impact your AR balance.

 

View solution in original post

Highlighted
Level 1

A/R aging report

Hi KatherineJoyce,

I appreciate your explanation, however, I don't want to eliminate the credit from the customer. I am looking to eliminate the negative numbers from the A/R Aging report.  On the Filters Tab I should be able to add Amount >= .01; however QB has a note that QB ignores positive and negative signs for this report.  Is there another way?

Highlighted
QuickBooks Team

A/R aging report

Hi @Gail25,

 

Thank you for your prompt reply. I'll take care of your query about the A/R Aging report. 

 

As stated by @BigRedConsulting above, the option you're looking for is unavailable.  What you can do is follow the steps shared by @katherinejoyceO when you create an invoice for the customer that you wish to apply the credits to. 

 

Take a look at this article as well: Advanced troubleshooting for balance sheets out of balance. It's a detailed guide on how you can run custom reports to identify the cause of an out of balance Balance Sheet. 

 

Direct other questions you have in the comments below. I'll get back to you as soon as I can. 

Need to get in touch?

Contact us