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