Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 11, 2018
Question

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?

No text available

8 replies

Rustler
Level 15
December 11, 2018

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

AlcaeusF
Level 14
December 11, 2018

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.

January 30, 2020

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

Level 8
September 22, 2020

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:

 

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!