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?

    S
    Sjones94Author
    February 17, 2021

    Thank you for all the detailed information! I just tried that and April came up completely blank and I know I have invoices due in April and beyond. ?


    We figured it out for what I need. 

    unpaid bills detail. select today from dropdown, customize - put in date range, select filters (not display! This is where I was getting hung up) make sure what you want is selected...including due dates. Sorted by Vendor and voila! Thanks to all for your patience and ideas!

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