Good day, andrea25.
We're unable to run the AP Aging report based on the bill date instead of the due date, unless if the Bill and Due dates are the same.
You might want to run the Transaction List by Supplier report. Then, customise it to add a Due Date column and group it by Day. Here's how:
We're always here if you need anything else. The Community is always here if you require additional help with QuickBooks.
thanks but i was wanting the Ageing Summary report format but by Transaction date not the due date, i need it columns for management to see what is due to who on a 30,60 90 day like the ageing reports is meant to do.
On Reckon desktop all you do is click a button and select if you want by due date or transaction date i can not believe no one else has issues with this.
i would have thought selecting how you want to age your transactions would be simple
Thanks for getting back to us, andrea25.
Allow me to step in and add some information with you about the A/R Ageing report.
The Aging Method under Ageing lets you see open balances. At the moment, choosing Current will show all outstanding balance. While Report date shows the balances based on the transaction date selected.
I'll pass along your feedback to our Product Team to see if they can add this to the next QuickBooks update.
In the meantime, I encourage visiting this site: Product Updates. This page keeps you in the loop as to what’s new and what’s coming.
Should you need additional information, feel free to leave a comment below. I'll get back to you.
Thank you for joining the thread, @DEO12.
I can see how important the feature of sorting the aging report to either the transaction's date or due date. Though the option is currently unavailable as of the moment, rest assured our engineers never stop to develop QuickBooks to deliver the best experiences for all QuickBooks users. Hopefully, this feature request will be considered in the coming updates.
At this time, you may visit our blog to stay current with the latest QuickBooks news and updates. Here's the link: https://quickbooks.intuit.com/blog/.
For seamless activities when managing your reports in QuickBooks Online, you can also read the topics from this article as additional guides.
If there's anything else you need help with, let me know by adding a comment. I'm always here for you. Have a good one!