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?
S
Sjones94
February 17, 2021
Question

AP Aging Reports

  • February 17, 2021
  • 1 reply
  • 14 views

I am wanting to run AP Aging reports by month. But I do not want future payables to also be included. If I run an AP Aging Summary from 3/01/2021 - 3/31/2021, it includes everything due. Custom options aren't available - very limited. If I want to run an Aging report for payables due in April, I just want to see what's due in April only, not what is still in March and after April. I am surprised I can't find this as it seems to be an obvious report needed. Help please..... :)

    1 reply

    R
    RCVQuickBooks Team
    QuickBooks Team
    February 17, 2021

    Let me guide you pull up the report you need, Sjones94. 

     

    The Accounts Payable Aging report summarizes the status of unpaid bills in accounts payable, showing what you owe, who you owe it to, and how much is overdue. This shows how much your company owes for the current and previous billing periods, and it shows the total amount. The report also shows the total amount owed to all vendors.

     

    Starting with today, and looking back for 90 days. The 1-30, 31-60, 61-90, and >90 columns show overdue balances from previous billing periods. For example, an amount in the 31-60 column is between 31 and 60 days overdue. To show the payables due in April only, we can manually enter the report date range on the report. Here's how:

    1. Go to Reports on the top menu.
    2. Choose Vendors and Payables.
    3. Select A/P Aging Detail.
    4. Tick the Customize Report tab.
    5. In the Dates field choose Custom. 
    6. Enter the date for April in the From and To field.
    7. Tap OK.

     

    To learn more about modifying your reports, see the Customize reports in QuickBooks Desktop article. Feel free to visit our Reports page for more insights about managing your financial reports in QuickBooks.

     

    I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. You have a good one. 

    S
    Sjones94Author
    February 17, 2021

    Thank you for your reply! I have done this report but it includes all my payables for March as well as April and some due in May and June....granted it does space them out by days due but not what I am looking for. I just want to isolate one month at a time with no other dates on the report. Does that make sense?

    Rose-A
    Rose-A
    Level 10
    February 17, 2021

    Thank you! Unfortunately I have already tried that. I do know how to run the basic reports and use unpaid bills detail and ap aging reports frequently. I did exactly what you suggested and customized the date to 4/01/21-4/30/21 but what it does is gives me everything due in March, April and later. I just want to isolate one month at a time. We pay all bills in full every month but I need to forecast and want to see what is due each month at a time. If  run a report for April now it also includes March as an accumulated amount - that's what I am trying to get away from.


    I appreciate you getting back to us, Sjones94.

     

    Allow me to step in and provide another report that can show all the information you need.

     

    You can pull up and run the Transaction List by Vendor report and customize it to see what is due each month. Here's how:

     

    1. Click Reports at the top menu bar.
    2. On the drop-down list, choose Vendors & Payables and select Transaction List by Vendor.
    3. From the report screen, click Customize Report.
    4. Select the Dates and hit OK.
    5. This will show all the due transactions for the month of April.

     

    To help you with customizing your reports in QuickBooks, you can visit this article: Customize reports in QuickBooks Desktop. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

     

    This should get you moving today, Sjones94. Don't hesitate to let me know if I can be of additional assistance while working in QuickBooks Desktop reports or if you have any follow-up questions in mind. I'm always here to keep helping. Have a good one!

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