Payment Dashboard Report

To meet government requirements for reporting on payments your organisation makes for the following contract types, run the Payments Dashboard report.

Contract types:

  • Linked between two or more businesses
  • Linked to the United Kingdom (UK)
  • Goods and services or intangible property (including intellectual property)
  • Not for Financial Services

To exclude supplier contracts that do not qualify, they must have the EXCPDASH index selected on their account. If the EXCPDASH option is not available in Indices, contact the consultant who installed the report for you.

What's Included in the Report

The Payment Dashboard report provides the following information:

  • Payments Made — Displays how many payments were made for the following categories
    • 1-30 Days
    • 31- 60 Days
    • 61-90 Days
  • Average number of days taken to pay invoices
  • Maximum payment terms for qualifying contracts on the selected ledgers
  • Percentage of invoices paid after the due date

  • Payment term Changes — Details of changed payment terms by account.

    For payment terms, changes are only recorded when the audit function is turned on. If payment terms have not previously been audited, they are not included in the report. To check payment terms are being audited, run a system audit.

Run the Payment Dashboard Report

  1. From the Reporting Suite, select Dashbaord Home.
  2. Select Payment Dashboard.
  3. Enter the required criteria:
    • Please select the Company
    • Please select the Locations(s)
    • Please select the Ledger(s)
    • Payments Made From — Enter the first date payments you want included were made
    • Payments Made Up To — Enter the last date payment you want included were made
    • Payments Made Ageing Based On — Choose how you want to display the number of days taken to pay invoices from:
      • Input Date — Calculate ageing as between the date the invoice was posted in IRIS Financials and the day the payment was made
      • Document Date — Calculate ageing as between the date of the invoice and the day the payment was made
  4. To run the report, select View Report.