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

AP Aging Detail Report

I am trying to find an A/P ageing report that looks like the Summary Report in QB, with the number of days past due across the top, and then the vendors as rows, but I also need it show the individual invoices for each vendor. There is an A/P report that shows the amount per each vendor, but only the totals for that vendor and not the individual invoices.

How do I accomplish this report. QuickBooks Desktop 2018

1 Comment 1
Anonymous
Not applicable

AP Aging Detail Report

Hi there, StephanSF.

 

Summary reports will only show total amounts or condense information. You can pull out the AP Aging Detail report instead. This shows more detailed information including the bills per vendor.

  1. Go to Report at the top.
  2. Select Vendors & Payable.
  3. Choose AP Aging Detail.

You can also run the Transaction List by Vendor report then customize it to add the Term column. Also filter the report to only show the unpaid bills. Here’s how:

  1. Go to Reports at the top and select Vendors & Payable.
  2. Click the Customize Report tab at the top.
  3. Type in Terms on the search columns field.
  4. Checked the Terms on the option below.
  5. Got to Filters tab and search Transaction Type.
  6. Select Bill as the transaction type.
  7. Search Paid Status and select Open.
  8. Click Ok.

Though, this would not show the number of days past due.

 

Lastly, you can also request your preferred way of reporting AP Aging Summary in QuickBooks. Just click Help at the top, select Send Feedback Online and choose Product Suggestion.

 

Drop by again if there’s anything else we can help you with QuickBooks.

Need to get in touch?

Contact us