I can help you customize the report, MickeyT1.
Instead of the Accounts Payable Aging Summary report, you can run the Transaction List by Vendor report where you can filter to only show bills and which date you want to pull up. You can also customize it by adding the Account, Due Date, and Open Balance column and add columns for the transaction open balance.
Let me show you how:
- Click Reports and enter in the search field Transaction List by Vendor.
- At the upper-right, click Customize.
- Select the Report period or enter a custom date.
- Under Rows/Columns, you can click Change columns.
- Check the Due Date and Open Balance box and add columns according to the data you need.
- Under the Filter section, check Transactions Type and select Bills.
- Click A/P Paid and select Unpaid so you'll know that the bills within that date are still open and unpaid.
- Select Run report to refresh.
While the option to itemize what you entered in a bill, you'll have to manually open it to review.
Feel free to use this article for your next step in handling reports such as saving a customized report, sending, or exporting them: Save custom reports.
Let me know if you have other questions so I can help you with them especially when running reports. I'm just around ready to assist you. Take care!