Skip to main content
November 11, 2019
Question

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

  • November 11, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

JenoP
November 11, 2019

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. 

 

 

andrea25Author
November 11, 2019

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
November 11, 2019

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.