Skip to main content
J
JeffGuldenschuh
April 22, 2022
Solved

Payments on AR Aging Report

  • April 22, 2022
  • 3 replies
  • 0 views

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!

Best answer by BigRedConsulting
@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.

3 replies

MorganB
MorganB
April 22, 2022

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
BigRedConsultingAnswer
April 22, 2022
@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.
    L
    ly8
    March 31, 2023

    Not true.

    Rubielyn_J
    Rubielyn_J
    March 31, 2023

    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!

    D
    dmann209
    November 9, 2022

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

    MorganB
    MorganB
    November 9, 2022

    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!

    L
    ly8
    March 31, 2023

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

    Terms & ConditionsAccessibility statement