Skip to content

View unpaid invoices by vendor due this month

Use the AP Invoice screen to see every open AP invoice due this month, grouped by vendor with a total for each. You can expand each vendor or export the list to Excel.

  1. On the Operations or Accounting tab, select A/P Invoices.

  2. Make sure Open is selected.

  3. Select the refresh button to list all open invoices.

    The AP Invoice screen with Open selected, the refresh button highlighted and a list of open invoices

Total Due shows the total of the invoices in the list.

  1. Hover over the Due Date column header and select the filter icon that appears at the top right of the header.

  2. Select This month. To use a different period, select a date or range from the list instead.

    The Due Date filter list with a calendar and options including Today, This week and This month

  1. Select and hold the Vendor column header.

  2. Drag it up to the area labeled Drag a column header here to group by that column, and drop it.

    Dragging the Vendor column header up to the grouping area above the grid

The list now shows the invoices due this month grouped by vendor, with the Total and Balance for each vendor.

Open invoices grouped by vendor with a total and balance for each, the due date filter at the bottom and the Excel export button highlighted

  • To see each vendor’s invoices, select the arrow next to the vendor.
  • To export the list, select the Excel button at the bottom of the screen.

For more about filtering and grouping, see Search, filter and save grid views.