The AR Aging Summary lists aging receivables based on the due date. Our banker would like to see an AR Aging report based on the invoice date. How do I do this?

bankers are so strange

the only way to do that is to set each invoice to due on receipt

run the report

set each invoice back the way it was

Hi there, @yellowbrickroad0.

It's a pleasure to see you here in the Community. I can help you pull up the report that you need in QuickBooks Online (QBO).

Yes! @Rustler is correct. Additionally, to have an Accounts Receivable Aging report that'll be based on the invoice date, you can also pull the Accounts Receivable Aging Detail instead. Here's how:

1. Go to Reports menu at the left panel.
2. Enter Accounts Receivable Aging Detail on the search bar.
3. You can change the Report period, Aging method, Days per aging period, Number of periods, and Min. Days Past Due depending on what you prefer.
4. You can also customize the report by clicking Customize at the upper right.
5. The invoice date will show on the DATE column. You can click each date to check.

Just in case you need it, you may check out this article that tackles customizing reports in QBO: How to customize reports.

That's it! Please let me know how it goes or if you're referring to something else by leaving a comment. I'd be glad to answer should you have any follow-up questions. Take care and enjoy the rest of the day.

 You can click each date to check. What does this part mean?

 I appreciate you for raising this concern with us today, @DKCPA.

The step number five in the given solution above means, you can check each date to verify if its accurate. 

If you have any other concerns about running the Accounts Receivable Aging report, you can check this link: Run an accounts receivable ageing report.

I'm also adding here an article that contains details about the reports that you can pull up in your QuickBooks Online for reference: Reports included in your QuickBooks Online subscription

You've got me here to help if you have any other questions. I'll make sure you're all set. Have a lovely day!

I am looking for the same report but this is cumbersome to calculate the aging from the date of the invoice. Is there a report to get the aging from the date of the invoice- not due date? 

Hello there, @9549.

Currently, a report to get the aging base on the date selected of the invoice is unavailable in QuickBooks Online.

While this option is unavailable, you can export the report into an Excel file. From there, you can manually filter it to get the data you need. By pulling up the A/R Aging Detail report, click the Export button and select Export to Excel.

I've included some articles in case you need other ideas about aging reports, also in exporting data to Excel:

• Run an accounts receivable aging report
• How to get your Aging Reports to match
• Export reports, lists, and more

Additionally, you can always visit our QuickBooks Blog to check for product updates and feature releases.

I'll stay connected if you have more questions or concerns. I'll be around to assist. Stay safe and well!

Since the aging by invoice date is a common request, when will it be avaiable?

c

Good morning, @cindy15. 

Thanks for chiming in on this thread and asking us when this will be available to you and your business. Allow me to give you some insight into this issue. 

At this time, there isn't a set date for this feature to be available. However, you can send feedback to our Product Developers so they can consider this in the future. This will help get the feature added sooner than later. Here's how: 

1. Go to the Gear (Settings) icon in the top right-hand corner. 
2. Under the "Profile" column, pick the Feedback option. 
3. Enter the information and hit Next. 

That's all there is to it! 

If you have any other concerns, feel free to ask. I'm always here to lend a helping hand. Have a splendid day!