Accounts Receivable Operational Metrics dashboard

The Accounts Receivable Operational Metrics dashboard analyzes the accounts receivable collection process and provides you a quick view of the operational key measurements. This dashboard can help you gain insight on the invoicing and payment averages trend. It also provides insight on the invoice variances trend in terms of invoicing our customers and setting our sales.

This dashboard can answer these business questions:

  • How long does it take for the invoice to be reconciled?
  • What are the payment patterns that we can derive on a periodical basis?
  • How accurate are we in terms of invoicing our customers and setting our sales on a periodical basis?

Reports and KPIs

The dashboard contains these reports:

  • Invoice Average Days by Period
  • Invoice Variance by Period
The dashboard also has these KPIs:
  • Manual Amt Pct
  • Corrected Invc Amt Pct
  • Invcs w/ Var Pct
  • Invcs w/ Ded Pct
  • Pmts w/ Ded Pct

When you select a period in the Fiscal Period filter, the period is shown on the dashboard. The KPIs show the corresponding metrics for that period. Each KPI displays an indicator comparing the Fiscal Period value to the Last Fiscal Period (LFP) value. A red arrow pointing upward indicates an increase value and a green arrow pointing downward indicates a decrease value. If there is no change, a yellow square indicator is displayed. The Last Fiscal Period value is displayed as a reference.

The KPIs use the Accounting Date as the date basis for analysis and the Sum aggregation.

Currency information is also displayed on the dashboard.

Filters

These standard filters are available:
  • Division (Config. 3)
  • Fiscal Period (Config. 1)
  • Customer (Config. 1)
  • Payer
  • Last N Periods (Config. 1)

Division, Fiscal Period, and Last N Periods are mandatory filters. The Last N Period filter to determines the number of previous periods to display in the reports.

Drill across

Drilling from a report to another dashboard is enabled in this dashboard:
  • By selecting a period from the Invoice Average Days by Period report, you can drill across to the Invoices and Reconciliation Details dashboard.
  • By selecting a period from the Invoice Variance by Period report, you can drill across to the Invoice Variance Details dashboard.