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
  • 4 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?

    MaryLandT
    MaryLandT
    Level 10
    February 17, 2021

    Allow me to step in and share other reports to get the data you need, Sjones94.

     

    There are several accounts payable reports you can pull up in QuickBooks Desktop. You can pull up the Unpaid Bills Detail report and filter it by month. Doing this won't include other due date.

     

    Let me show you how:

     

    1. Go to the Reports menu.
    2. Choose Vendors & Payables, then Unpaid Bills Detail.
    3. Click Customize Report.
    4. Select Display.
    5. Modify the date.
    6. Click OK.

    For other fields you want to change, check out again this link: Customize reports in QuickBooks Desktop.

     

    If you need a copy of the report, you can export or memorize it.

     

    Let me know if you need other reports by commenting below. I'll be right here to help you.

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