Accounts Payable Q&A: Unpaid Invoices by Due Date

September 2019    Tags: , ,

We need a report that will show the oldest invoices that have not been yet paid. Is there a report in Accounts Payable that will list all invoices that have not been paid, sorted by due date?

There are two reports in Accounts Payable that we would suggest: Aged Unpaid Invoice Report and Cash Requirement Report.

The Aged Unpaid Invoice Report provides a list of outstanding invoices by aging period, allowing you to see what is due for each period.

The Cash Requirements Report provides a list of unpaid invoices sorted by Due Date along with a running bank account balance. This allows you to see how much would be in your bank account if you paid each invoice.

To print the Aged Unpaid Invoice Report

  1. From the Reports menu, point to Invoices and select Aged Unpaid Invoice Report.
  2. On the Options tab:
    1. In the Include section, select Both.
    2. In the Report Type section, select Detail.
  3. Click OK.

Note: When running the Aged Unpaid Invoice report, invoices are included in aging periods by comparing the Due Date of the invoices with the Report Date. You may want to consider changing the Report Date if you want to project future budgets.

To print a Cash Requirements Report

  1. From the Checks menu, point to Check Preparation and select Cash Requirements Report.
  2. On Options tab, optionally select Bank Account Order.
  3. Click OK.
How helpful was this article? Rate it above.
Please wait...
Share or Print this Article

« PREV NEXT »


Leave a Comment