Financial Controller reports

The measures used in Financial Controller reports are sourced from the AR Balances and AR Invoices facts. These measures are analyzed by Accounting Date and use the Sum aggregation.

Operational Measures by Period

Description: This report shows the average days between crucial steps in invoice processing. Average days between invoice and due dates is set in comparison to the average days between invoice and payment dates, invoice and reconciliation dates, and due and payments dates. You can use this report to analyze the trend for invoice processing and to pinpoint areas of improvement.

Measure: Invc Avg Days – Invc and Due, Invc Avg Days – Invc and Pmt, Invc Avg Days – Invc and Recon, Invc Avg Days – Due and Pmt

Chart type: 4 data series combo, 1 areaspline and 3 spline charts

Overdue Amount per Credit Manager

Description: This report shows the overall overdue amount per Credit Manager.

Measure: Overdue Invc Amt – Division

Chart type: 1 data series donut chart

Risk Payers Ranked by DSO Value (vs Previous Period)

Description: This report analyzes the risk payers that have the highest current DSO value.

Measure: DSO Value (Current Period), DSO Value (Previous Period)

Chart type: 2 data series grouped column chart

Risk Payers Ranked by DSO Value (vs Last Year Period)

Description: This report analyzes the risk payers that have the highest current DSO value.

Measure: DSO Value (Current Period), DSO Value (Last Year Period)

Chart type: 2 data series grouped column chart

Risk Payers Ranked by Payment Days

Description: This report analyzes the risk payers that have the highest number of average payment days between invoice due date and payment date.

Measure: Invc Avg Days – Invc and Due, Invc Avg Days – Due and Pmt

Chart type: 2 data series grouped column chart

Risk Payers Ranked by Stopped Amt

Description: This report analyzes the risk payers that have the highest stopped amount.

Measure: Stopped Amt – Division, YTD Sales Amt – Division

Chart type: 2 data series combo, 1 column chart on Y axis 1, and 1 point chart on Y axis 2