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

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

 
9 Comments 9
JenoP
Moderator

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

 

andrea25
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

MaryLandT
Moderator

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.

DEO12
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 

 

Angelyn_T
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!

Monique_
Level 1

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

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. 

IntuitSheila
Level 8

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

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!

aaaaaab
Level 1

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

Almost 2 years later and STILL no update??

I need an AP Aging report based on invoice date, not the due date.

Mich_S
QuickBooks Team

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

Hi there, @aaaaaab. I want to share some insights about the flow of the A/P Aging report in QuickBooks Online.

 

There's no standard A/P Aging report that is run using the invoice date. It always uses the due date and is aged based on Days Past Due or Days Until Due. Additionally, it digs deeper into the status of accounts payable and how any debt from overdue payables to vendors may impact future quarters. For this reason, it calculates based on due dates and not the bill or transaction dates.

 

Alternatively, you can export the report to an Excel file and customise the details from there. Here's how to export:

 

  1. Open the Reports menu.
  2. Search for and pick the A/P Aging report.
  3. At the top of the report, select the Export icon. Then select Export to Excel.
  4. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

 

Furthermore, you can manually edit the due date and set it the same as the transaction date. This helps report to flow the way you want it to be. Kindly see the image below for reference.

 

If you're all good and want to handle vendor bills, read this for guidance: Enter and manage bills and bill payments in QuickBooks Online


You can always get back to us if you need more help with reports, bills, or QuickBooks. The Community is here lend a hand to you and your business. Take care!