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

The account payable aging is sorting by due date instead of invoice date. Can I change the sorting?

 
2 Comments 2
Joyce_P
QuickBooks Team

The account payable aging is sorting by due date instead of invoice date. Can I change the sorting?

Yes, you can change the sorting of the Accounts payable aging report, stylqbo.

 

The Date column is the invoice date of your account's payable. Let's customize your report and include the date column.

 

Here's how: 

  1. Go to Reports.
  2. Enter Accounts payable aging detail in the Search field and select the report from the drop-down options.
  3. Click the Gear icon at the top right corner of the report page.
  4. Check the Date box.
  5. You can also check other information that you want to include in the report.

Once done, you can filter the report period. Just click the Report period drop-down and choose your preferred period.

 

Please see the screenshot I've provided below: 

 

 

 

 

 

Keep posting here in the Community if you have other concerns. Have a good one!

stylqbo
Level 1

The account payable aging is sorting by due date instead of invoice date. Can I change the sorting?

When I search on reports, it is giving 2 choices Accounts payable aging summary or Accounts payable aging detail.
On the summary version, the gear icon is asking only for a compact option
On the detail version, the column date is already checked.
 
Let me explain more about my situation.
 
On the Payable aging summary, you a column for current, 1-30 etc.
Each invoice is classified in the column with the due date instead of the invoice date.
 
Example.
 
Invoice 123 dated March 5, 2019. Due date is April 4, 2019
On today's report, you would normally see the amount due to this invoice in the  31-60 column but it is showing in the  1-30 because it is classified by the due date.
 
Let me know how I can fix that.

Need to get in touch?

Contact us