Skip to main content
A
alex_nj
January 24, 2025
Solved

Vendor AP report filter

  • January 24, 2025
  • 1 reply
  • 0 views

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. 

    Best answer by alex_nj

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

    1 reply

    A
    ArielI
    January 24, 2025

    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.

     

    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.

    A
    alex_njAuthorAnswer
    January 24, 2025

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

    H
    Heide DC
    January 24, 2025

    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.

    Terms & ConditionsAccessibility statement