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..... :)
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:
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.
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?
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:
For other fields you want to change, check out again this link: Customize reports in QuickBooks Desktop.
Let me know if you need other reports by commenting below. I'll be right here to help you.
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:
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!
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!