Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
LottieB
January 9, 2020
Question

Adding Detail to AP Aging Summary Report

  • January 9, 2020
  • 1 reply
  • 10 views

I require a report that gives the same information as the AP Aging Summary, but lists the vendor invoices as well.  AccPac was able to generate this report and my boss would like it used for cheque runs.  We have switched to Quickbooks Enterprise Contractor Edition.  The Aging Detail Report doesn't break down the columns by current, 1-30, 31-60, 61-90, >90.  If anyone has a fix, please let me know.

 

Thank you.

1 reply

L
LauraAB
Level 8
January 9, 2020

Hello LottieB,

 

I know it can take some getting used to when you go from one system to another, but don't worry, I'm here to help you figure it out. It's great that you had a report that worked in the other software you were using. I'll go over how QuickBooks Desktop handles these kinds of details.

 

In this case, the A/P Aging Detail report is the one you're going to want to use to make sure you see each transactions as well as their aging details. I see from your question that you're looking for it to have the formatting of the Summary report, where the 1-30 and so on are individual columns, but the detail report can't be formatted that way. The good news is, it still has those same details.

 

Take a look at the screenshot below from a test company file to see where you'll find the aging details on the A/P Aging Detail report.

 

 

You can even customize the report to sort by name, aging, date, and a few other options. You can even rearrange the columns (for instance, I've dragged and dropped the "Name" column to see those details first). Learn about customizing reports here: Customize reports in QuickBooks Desktop

 

There are a few great in-product articles about QuickBooks Desktop's A/P reports, which you can find by following these steps.

 

  1. Click Help and choose QuickBooks Desktop Help (Note: the F1 key is a shortcut).
  2. Click the Help tab on the Have a Question? window.
  3. Select Search.
  4. Enter keywords in the search bar and hit Enter or the arrow button at the end of the bar.

Click on the articles that come up to get more insight into these reports.

 

You're also welcome to leave feedback by going to the Help menu and choosing Send Feedback Online. We love hearing from customers like you and many suggestions are implemented to enhance what the program can do for business owners.

 

I'm here if you have further questions!

L
LottieBAuthor
January 9, 2020

Thank you, we would prefer to have a combined report. I am using the details one now, which is what prompted my boss to ask for the old style. I will submit feedback in the hopes that this becomes an option in the future.

 

Lottie

B
Brocsan
November 16, 2022

Hello Brocsan. Glad to have you connect with us here in this thread. I'd like to make sure I'm on the same page as you here, could you elaborate more about what you're looking to accomplish using QuickBooks? 


Hi JamesM4
please see the first message in this thread from 2020. The detailed AP ageing report is not practical. What the community is looking for is detailed invoices underneath each supplier with the ageing buckets in each column.  So basically take the AP ageing summary report and add the bills in rows under each supplier name.
the way the detailed AP report works today is that it shows the details in blocks of ageing so if you have 3 invoices from a supplier that re aged differently you will see the supplier repeated 3 times with the corresponding invoice Ian different blocks. Not practical when you want to see the whole position of each supplier with the details.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement