cancel
Showing results for 
Search instead for 
Did you mean: 
JeffGuldenschuh
Level 2

Payments on AR Aging Report

When I run my aging report for my AR balances, why are there payments that are shown on the report?  Are these payments that haven't been applied to invoices yet?

Are Credit Memos that show on the report the same thing, i.e. credits that haven't been applied to invoices yet?

Thanks for the help!

Solved
Best answer April 22, 2022

Best Answers
BigRedConsulting
Community Champion

Payments on AR Aging Report


@JeffGuldenschuh wrote:

When I run my aging report for my AR balances, why are there payments that are shown on the report?  Are these payments that haven't been applied to invoices yet?

 


 

Yes, exactly. All open / unpaid transactions appear on the report. Just like Invoices, which are paid by Payments, Payments are "paid" by Invoices when they are applied to each other. Everything not applied appears on the report. Sometimes this will reveal data entry errors, such as when you see both an Invoice and a Payment for a customer, where the Payment should be paying the Invoice - but isn't. In such a case, the report can help you fix your data: Double-click on the Payment listed on the report to edit it, then select the Invoice(s) to pay, and then save the Payment. If one or more of the transactions are then fully paid, they'll disappear from the report.

View solution in original post

8 Comments 8
MorganB
Content Leader

Payments on AR Aging Report

Hi there, JeffGuldenschuh.

 

Thanks for bringing your question forward here in the Community. I'd be glad to lend a hand so you're able to view the exact data you're looking for on your QuickBooks Desktop Aging Report. 

 

The payments and credit memos generated for the report most likely depend on the accounting method that has been selected. These options being either cash or accrual. "An accrual basis report shows income regardless of whether your customers have paid your invoices and expenses regardless of whether you have paid all your bills." Alternatively, "A cash basis report only shows income if you have received cash and expenses if you have paid cash."

 

I recommend checking this setting first and seeing the difference on the report after making your selection. The following linked article provides additional info about cash vs. accrual as well as how to choose between the two in your account.

 

Please feel free to reach back out if you have any other questions. I'll be here to help.

BigRedConsulting
Community Champion

Payments on AR Aging Report


@JeffGuldenschuh wrote:

When I run my aging report for my AR balances, why are there payments that are shown on the report?  Are these payments that haven't been applied to invoices yet?

 


 

Yes, exactly. All open / unpaid transactions appear on the report. Just like Invoices, which are paid by Payments, Payments are "paid" by Invoices when they are applied to each other. Everything not applied appears on the report. Sometimes this will reveal data entry errors, such as when you see both an Invoice and a Payment for a customer, where the Payment should be paying the Invoice - but isn't. In such a case, the report can help you fix your data: Double-click on the Payment listed on the report to edit it, then select the Invoice(s) to pay, and then save the Payment. If one or more of the transactions are then fully paid, they'll disappear from the report.
dmann209
Level 1

Payments on AR Aging Report

I would like to learn how to create A/R and A/P aging Reports 

MorganB
Content Leader

Payments on AR Aging Report

Good afternoon, dmann209, and welcome to the Community.

 

You've come to the right place for assistance and I'd be glad to show you how to create A/R (accounts receivable) and A/P (accounts payable) aging reports in your QuickBooks account.

 

So I'm able to give you the appropriate set of steps, which version of QuickBooks are you currently using; Online or Desktop? If you're using Desktop, here's how to create an A/R aging report: 

 

1. Choose the Reports tab from the top menu bar.

2. Select Customers & Receivables.

3. Choose A/R Aging Detail report.

 

You can do the same for an A/P aging report by choosing Vendors & Payables, then click the A/P Aging Detail report.

 

For additional info I recommend checking out the following article: Customize reports in QuickBooks Desktop

 

Please don't hesitate to leave a comment below if you have any other questions. I'll be here to help. Take care!

ly8
Level 1

Payments on AR Aging Report

There isn't a choice to run cash vs accrual for this report.

ly8
Level 1

Payments on AR Aging Report

There is not a choice to pick cash vs accrual and the payments are paying a certain invoice. 

ly8
Level 1

Payments on AR Aging Report

Not true.

Rubielyn_J
QuickBooks Team

Payments on AR Aging Report

Hi there, @ly8.

 

You are right. The A/R Aging report does not offer the option to perform cash vs. accrual.

 

This is because the report is on an accrual basis. It shows the overview of its outstanding payments from customers and how long they are past due. 

 

In the time being, I'll be sharing these articles to help personalize and memorize reports in QuickBooks: 

 

 

If you have any additional inquiries about the A/R Aging report, please let me know in the comments section. I'll follow up with you and give you the details you need. Stay safe!

Need to get in touch?

Contact us