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

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

 
5 Comments
QuickBooks Team

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

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:

 

  1. Look for the Transaction List by Supplier report.
  2. Click Customise in the upper-right hand corner.
  3. Go to the Rows/Columns section and select Day for Group by.
  4. Check both Due Date and Create Date boxes.
  5. Proceed to the Filter section.
  6. Check the Transaction Type box and select Bill.
  7. Click Run Report.

We're always here if you need anything else. The Community is always here if you require additional help with QuickBooks. 

ap.PNG

 

ap 2.PNG

 

Level 1

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

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

QuickBooks Team

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

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.

Level 1

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

it would be great to have aging report options to be either by Due Date or by Transaction Date 

 

QuickBooks Team

Does anyone have a way to make your AP Ageing reports age from the invoice/transaction date not the due date.

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!