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!
This question was posted two years ago and QuickBooks is yet to update the system to allow ageing reports to be based off transaction date. I'm going to have to change to Xero purely because of this stupid feature.
Good day, Monique_.
Appreciate you sharing your honest feedback with us. I get your part on how helpful for you and your business to run Accounts Payable Ageing report based on the transaction date.
At this stage, the AP, Ageing report is designed to show transactions based on the due date. I have lodged a feedback in our customer feedback system in regards to making the report more dynamically updated. This feedback is reviewed by the product development team for work on future releases.
In the meantime, you may want to edit the Bill and due dates to have the same date or run the Transaction List by Supplier report and then, Customise it to add the Create date
Feel free to comment below, the Community is always here if you require more help with QuickBooks Online. Have a nice day!