Run the Payable Invoice Summary report (New)

Run the Payable Invoice Summary to view or export a summary of all bills, credit notes, overpayments and prepayments from Bills in a given period.

The Payable Invoice Summary is the new version of the Supplier Invoice Report you might be familiar with. You can continue to use the Supplier Invoice Report if you wish.

Run the Payable Invoice Summary

  1. Go to Reports, then click All Reports.
  2. Under Purchases, click ... to expand the section if the report is hidden.
  3. Click Payable Invoice Summary (New).
  4. Choose a time frame or select a date, then click Update to view your report.

Refine your report's settings

Click Report Settings to refine your report.

Image of the Report Settings link.

Show or hide decimals

Numbers will show to 2 decimal places by default.

To show only round numbers, click to clear the Show decimals checkbox.

Group data and select columns to display on the report

Select an option from Layout to group and subtotal information on the report. Select Standard for no groups.

Select checkboxes for columns you wish to show on the report. Clear a checkbox to hide a column.

Display column options explained

  • Payments / Debits
  • All payments and debit allocations. When you've applied a prepayment to a bill, it will appear in this column even if your report doesn't include prepayments individually.

  • Planned Date
  • The planned payment date entered on the Purchases screen, or the due date, if you haven't entered one.

  • Realized Gains
  • The gain or loss realized when you apply payment to a foreign currency bill.

  • Unrealized Gains
  • The unrealized gain or loss associated with a foreign currency bill. This doesn't apply to draft bills.

Apply filters

Click Add a filter and select a column to filter by, then enter or select details.

As you add more filters, the report displays results based on all your filters combined.

When you update the report, the filters show at the top in a text block you can edit or delete.

Edit, move or delete text blocks

Click Update to run and view

After you've made your choices, click Update to close Report Settings and view your report.

Sort and reorder columns

Once you've run your report and refined your results, you can:

  • Sort the report in ascending or descending order of the data in any column by clicking on the column heading.
  • Reorder the columns by dragging and dropping them into a different order.

You might also be interested in

Publish a report

Running the Payable Invoice Detail report