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

Accounts Receivable Aging Report

Looking for DETAIL of current Accounts Receivable Aging Report that shows INVOICE billed and date, along with ALL subsequent payments and dates of those payments.  The Customer Balance Detail shows all Customers, even those that are paid in full.

11 Comments 11
Joesem M
QuickBooks Team

Accounts Receivable Aging Report

Hello there, @DonnaCush.

 

You'll want to run the Transaction List by Customer report and customized it from there. It will show the dates of your invoice payments in QuickBooks Desktop.

 

Here's how:

 

  1. Go to the Reports tab at the top menu bar.
  2. Select Customers and Receivables.
  3. Choose Transaction List by Customer.
  4. Click the Customize button.
  5. Tap the Display and Filters button for the columns and account type.
  6. Hit the OK button.

Also, if you'll want to see the related payments of your invoices. You'll have to click the invoice in th right side click the Transaction button to see the related transactions.u.PNG

 

To learn more about running reports in QBDT, you may check this article: Understand reports.

 

If there’s anything else I can help you with, please post a comment below. I’ll be happy to assist you further. Have a good one.

DonnaCush
Level 1

Accounts Receivable Aging Report

Thank you for your prompt response.  I'm not sure what you mean by "Identify the invoice and specific payments."  I don't see that anywhere on the Customize button.

 

I'm looking to see ONLY the outstanding Accounts Receivable balances with all the transactions listed:  a listing of all the invoices and payments for each Customer. 

 

Thank you.

Donna

Jovychris_A
QuickBooks Team

Accounts Receivable Aging Report

I appreciate the details a lot, @DonnaCush.

 

You can pull up the A/R Aging Detail report. This report will show you the latest and aging customer balances. If you're looking for a customer's balance within a specific period, make sure to change the date.

 

Here's how:

  1. Go to the Reports menu.
  2. Select Customers & Receivables.
  3. Choose A/R Aging Detail report.1.PNG

There you can see the list of customers' outstanding balances.

 

Just in case you wanted to customize  any report that you can generate, you can refer to this article: Customize reports in QuickBooks Desktop.

 

Please let me know or tag me (@Jovychris_A) if you need further assistance. I'll keep my notifications open. Stay safe and healthy!

larrylbr
Level 1

Accounts Receivable Aging Report

Where can I see something like this with Quickbooks Online?  We used to get the invoices, payments, balances and aging all together on one report.  What's happened to this? Is there no way to combine these without producing 3 different reports?

Candice C
QuickBooks Team

Accounts Receivable Aging Report

Good afternoon, @larrylbr

 

Thanks for chiming in on this thread. Allow me to share some light on this subject about reports in your QuickBooks Online (QBO) account. 

 

All you need to do is run the A/R Aging Detail Report to produce and see all 3 different transactions/balances. It's a simple process. Here's how: 

 

  1. Go to the Reports tab on the left-hand menu bar. 
  2. Ensure that you're in the Standard section. 
  3. Go to the Who owes you portion of the page. 
  4. Choose the Accounts receivable aging detail report option. 

 

If you need to customize the list to your liking, just hit the Customize button at the top of the report. 

 

This should do the trick. If you have any other questions, don't hesitate to ask. Have a good one!

Doug4800
Level 1

Accounts Receivable Aging Report

We use QB Desktop and none of the standard A/R reports are satisfying our needs and really I need a combination of the Detail and Aging summary.  I am looking for the Current, 30, 60 90, >90 at as the column headers in addition to Invoice Date and Invoice#, grouped by Customer and Job Name.  Is there a report out there that provides this because I can't seem to find it and don't know if I can create one.

 

Thanks for the help! 

Adrian_A
Moderator

Accounts Receivable Aging Report

Hi Doug4800,

 

As of now, the option to modify a report that will show the net terms and the Current is unavailable. However, you can export the detail and aging reports to an Excel report. From there, you can combine the two reports in one file. Here's how:

 

  1. From the Reports menu, select Reports Center.
  2. Find and open any report.
  3. Select the Excel on the toolbar.
  4. Select Create New Worksheet
  5. When you’re ready to export, select OK.

 

You can set your report preferences to change the file type that QuickBooks exports.

 

I'm just a post-away if there's anything that I can help. Keep safe!

Doug4800
Level 1

Accounts Receivable Aging Report

Thanks for your reply.  We know how to export a report but this does not answer the question in much detail and what you are saying looks like a lot of work because we need to provide this monthly to a bank.  Can you provide more details how to do what I asked?  Very surprised QB does not include such a basic A/R report??  All we need is more detail than the standard A/R report they provide.

 

Name                                        Current                      1-30                    31-60

 

Customer 1

     Invoice #      Date                $60,000

     Invoice #      Date                                                 $75,000

Total                                         $60,000                    $75,000

 

Customer 2

     Invoice #      Date                                                                              $100,000

Total                                                                                                        $100,000

Grand Totals                            $60,000                    $75,000                 $100,000

Tam41
Level 1

Accounts Receivable Aging Report

Doug4800,

 

I am looking for the same sort of report today!  I need a combination of the detail and summary as well -- we are wanting to show the customer's purchase order number on the report.  The PO number does show on the detail aging, but then we lose the column arrangement of 1-30, 31-60, 61-90 just as you described.  

JonpriL
Moderator

Accounts Receivable Aging Report

Let me help share information about your report in QuickBooks Desktop (QBDT), @Tam41.

 

As of the moment, there isn't an integrated way to customize a report showing detail and summary data at once. Let's consider creating your report by exporting it as suggested by my colleague above.

 

While the report you need is not available, it's best to let our developers know about your request by sending feedback. Let me show you how.

 

  1. Go to Help.
  2. Select Send Feedback Online.
  3. Click Product Suggestion.
  4. Under Product Area, select Reports.
  5. Enter a few words describing how you wanted to customize and use the report in question.
  6. Select Send Feedback.
  7. Click Close Window.

 

I'm adding this article to keep track of your business's financial status to date: Create and Manage Reports in QuickBooks Desktop.

 

If you have any other concerns with generating reports, please let me know in the comments below. I'll be here to answer all of them. Take care and stay safe!

Tam41
Level 1

Accounts Receivable Aging Report

Thank you for the reply -- I have submitted the suggestion.

Need to get in touch?

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