cancel
Showing results for 
Search instead for 
Did you mean: 
Gail25
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
BigRedConsulting
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

5 Comments 5
katherinejoyceO
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. 

BigRedConsulting
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

Gail25
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?

Ryan_M
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. 

fpsbooks
Level 1

A/R aging report

I know this is from a while ago, but if you're only tracking aging on invoices there is a way to get rid of those pesky credits on accounts that are negative. Here's how:

  - Pull up your aging report

  - Click on Customize Report in the upper left hand corner of the window.

  - Click on the Filters tab on the Modify Report popup.

  - Under the Filter scrollbar, scroll to find TransactionType and click.

  - On the dropdown that appears click Invoice and press OK.

Now instead of Credits and Invoices, you'll see just the aging of Inovices.

 

Hope this helps someone.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us