cancel
Showing results for 
Search instead for 
Did you mean: 
Sjones94
Level 3

AP Aging Reports

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..... :)

7 Comments 7
RCV
QuickBooks Team
QuickBooks Team

AP Aging Reports

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. 

Sjones94
Level 3

AP Aging Reports

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
Moderator

AP Aging Reports

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.

Sjones94
Level 3

AP Aging Reports

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.

Rose-A
Moderator

AP Aging Reports

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!

Sjones94
Level 3

AP Aging Reports

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. ?

Sjones94
Level 3

AP Aging Reports

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 to get in touch?

Contact us