SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
alex_nj
Level 3

Vendor AP report filter

In QB Desktop, is there an AP report filter that will let me filter out bills that have future payments scheduled? Or is the only option to set the date of the report to a date after the latest scheduled bill payment? I'm trying to run a list of open bills that shows bills without payments in the pipeline. 

Solved
Best answer January 24, 2025

Best Answers
alex_nj
Level 3

Vendor AP report filter

"Currently, there isn’t a direct filter available to exclude those open bills from scheduled payments in a report in QBDT."

That's all the answer I was looking for. Thank you.

View solution in original post

3 Comments 3
ArielI
QuickBooks Team

Vendor AP report filter

My goal is to ensure you have the clarity you need for effective financial management in QuickBooks Desktop (QBDT), Alex. Let's work together to navigate these options and find the best path forward.

 

Currently, there isn’t a direct filter available to exclude those open bills from scheduled payments in a report in QBDT. However, you can export the report to Excel and then edit it as needed.

 

Here are the steps to export your report:

 

  1. Open QuickBooks Desktop.
  2. Go to Reports and click on Vendors & Payables.
  3. Choose A/P Aging Summary.
  4. Click the Excel dropdown menu and select Create New Worksheet.
  5. Finally, click on Export.

111.png

 

For more detailed information on exporting reports, you can refer to the following article: Export reports as Excel workbooks in QuickBooks Desktop.

 

Additionally, if you have customized your reports, you can save those exact settings by memorizing them for future use. This will allow you to easily access your preferred report configurations without having to set them up again.

 

Let us know if you have further questions about managing these reports, we'll be right here to help you anytime.

alex_nj
Level 3

Vendor AP report filter

"Currently, there isn’t a direct filter available to exclude those open bills from scheduled payments in a report in QBDT."

That's all the answer I was looking for. Thank you.

Heide DC
QuickBooks Team

Vendor AP report filter

Thank you for your kind words and feedback, Alex.

 

We sincerely appreciate you taking the time to share your detailed experience with us. We're thrilled to hear that you have now gained the ability to manage your reports efficiently and the solution provided by my colleague meets your needs.

 

Your positive feedback means a lot to us, and we value your trust as we continue to support you. If you have other QuickBooks Desktop concerns, please let us know. We look forward to serving you in the future.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us