Payables Management dashboards and reports

Invoice and Payment Performance

To access Invoice and Payment Performance dashboard reports, select Payables Management > Invoice and Payment Performance.

The dashboard is a high level overview of performance of the Payables activity at your organization. There are five charts showing trends in different areas:

  • The Available and Actual Discounts MoM chart compares the discounts applied and lost over time.
  • The Invoices Paid chart displays the invoice count over time and compares those paid vs paid within terms.
  • The Percent Discounts Lost chart compares the Paid amount vs Discounts lost over time.
  • The Payments by Cash Code chart shows the Paid Invoice Count per Cash Code or Banking entity.
  • The Invoices by Payment Status chart is Invoice Count by Status. The dashboard defaults to display activity over the current month by default.

The filters used for slicing data are:

  • Company
  • Cash Code
  • Date Range
  • Pay Group
  • Payment Method
  • Vendor
  • Vendor Class
  • Date Range

Payables Processor Performance

To access Payables Processor Performance dashboard reports, select Payables Management > Payables Processor Performance.

This dashboard contains these reports:

  • The Released Invoices by Processor report shows the released for payment count and payment count.
  • The Rush Payments by Processor report shows count of rush payment and payment count per processor.
  • The Void Payments by Processor report shows the count of void payments and payment count per processor
  • The Paid Invoices by Processor report shows the count of paid late and payment count per processor

The filters used for slicing data are:

  • AP Clerk
  • Company
  • Pay Group
  • Process Level
  • Date Range

Payables Activity Analysis

To access Payables Activity Analysis dashboard reports, select Payables Management > Payables Activity Analysis.

This dashboard contains these reports:

  • The Late Payments report shows the paid late count and count of paid invoice over a period.
  • The Invoices by Source report provides detailed information about the payment made by the company categorized by its source over a period.
  • The Average Days to Pay report shows the average days to pay over a period.
  • The Payments by Payment Method report shows the payment count per payment method over a period.

The filters used for slicing data are:

  • Company
  • Invoice
  • Pay Group
  • Payment Method
  • Process Level
  • Vendor
  • Date Range

Vendor Payment Activity

To access Vendor Payment Activity dashboard reports, select Payables Management > Vendor Payment Activity.

This dashboard contains these reports:

  • The Paid TY LY report compares the current paid amount to a year ago.
  • The Payments by Vendor shows a detailed report that lists vendor invoices. It shows year, transaction number, processor, vendor number, payment status, invoice, process level, terms code, invoice date, due date, check date, pay immediately, days to pay invoice, payment count, rush payment count, void payment count, payables invoice amount, discount amount applied, discount amount lost, discount lost count, paid amount, and payment amount currency amount.

The filters used for slicing data are:

  • Company
  • AP Clerk
  • Currency
  • Invoice
  • Pay Group
  • Pay Immediately
  • Process Level
  • Terms Code
  • Transaction Number
  • Vendor
  • Date Range

PO Invoice and Payment Comparison

To access Purchase Order Invoice and Payment Comparison dashboard reports, select Payables Management > Purchase Order Invoice and Payment Comparison.

This dashboard contains the Purchase Order Invoice and Payment Comparison report. The report shows a detailed report of lists of all PO invoices and payment. It shows year, company,vendor number, process level,purchase order, invoice, opera-tor, match status, reference number, terms code, due date,processor, authority code,check date, transaction number,payment status, discount amount applied, discount amount lost, paid amount, and days to pay invoice.

The filters used for slicing data are:

  • Company
  • Authority Code
  • Invoice
  • Invoice Status
  • Match Status
  • Invoice Operator
  • Pay Group
  • Process Level
  • Purchase Order
  • Terms Code
  • Vendor Class
  • Vendor
  • Year
  • Year/Month

Payables Payments Due

To access Payables Payments Due dashboard reports, select Payables Management > Payables Payments Due.

This dashboard contains these reports:

  • The Payments Due report shows unreleased payment count, system generated payment count, and released for payment count on each status over a period.
  • The Payables Payments Due report hows a detailed report that lists the year, vendor number, company, pay group, process level, invoice type, invoice, invoice date, due date, payment status, payables invoice amount, payment amount, and currency amount.

The filters used for slicing data are:

  • Company
  • Currency
  • Date Range
  • Due Date
  • Invoice
  • Invoice Date
  • Invoice Type
  • Pay Group
  • Payment Status
  • Process Level
  • Vendor

Payments for Invoices

To access Payments for Invoices dashboard reports, select Payables Management > Payments for Invoices.

This dashboard contains the Payments for Invoices report that shows a detailed report of lists of all invoices payments. It shows year, payment status, company, cash code, payment method, process level, vendor number, invoice, invoice date, batch number, pay immediately, reference number, terms code, due date, AP clerk, transaction number, check date, discount amount applied, paid amount, days to pay invoice, discount lost count, paid within terms, paid on time count, paid late count, and rush payment count

The filters used for slicing data are:

  • Company
  • AP Clerk
  • Currency
  • Due Date
  • Invoice
  • Invoice Source
  • Invoice Type
  • Pay Group
  • Payment Immediately
  • Payment Method
  • Payment Status
  • Precess Level
  • Terms Code
  • Vendor
  • Vendor Class
  • Date Range

Expenditure Report

To access Expenditure Report dashboard reports, select Payables Management > Expenditure Report.

This dashboard contains the Expenditure Report report.

The filters used for slicing data are:

  • Check Date
  • Company
  • Process Level
  • Vendor Name
  • Vendor Number
  • Year
  • Year/Month