Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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