You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 2
Next »
General Description |
|---|
This KPI is a summary table that includes Product and Service (Turnover, Outstanding, Overdue, Percentage of Overdue, DSO, Best DSO, Delay DSO, Cash Value 1 day DSO (KCURR)), Doubtful (Bad Debt), Write Down (Negative amounts displayed in positive), Advanced Payments (Negative amounts displayed in positive), Accruals and Revaluation.
Indicator details results can be analyzed by :
Month Year
Date Reference:
Refresh Frequency: Monthly (during closure on 1st to 6th 3 times per day) |
KPI Name | Calculation |
Turnover (KCURR) | |
Outstanding (KCURR) | Sum of open documents in the customer's account at the report date |
Overdue (KCURR) | Amount of outstanding due and not yet paid at the date of report. In a monthly report, the overdue amount at the end of the month is the sum of amounts with due date lower or equal to the last day of the month and not yet paid nor cleared by that date. |
% Overdue | Percentage of Overdue - Overdue/Outstanding:
It is by default filtered by GL Account sub-type Product & Services.**Please noted that Credit Management term will still communicate official percentage overdue statistics for Solvay Group with the old calculation method. |
DSO | Evaluation in teams of days of sales of the outstanding amount at the report date. It is a measure of efficiency on how quickly receivables are collected. It shows the age in term of days of an organization's accounts receivable and the average time it takes to turn receivables into cash
Days = Number of days in the month. (Month premise: 30 days)Outstanding = Sum of open documents in the customer's account at the report date. Receivables in doubtful state and advanced payments are excluded.Turnover = Sales (VAT included) in a specific monthm = Current month (Month Premise: 30 days)
|
Best DSO | Number of days of up to previous month (M-1) |
Delay DSO | = DSO - Best DSO |
Cash Value 1 day DSO (KCURR) | Amount lost due to the each day of the DSO |
Bad Debts Outstanding (KCURR) | Amount consider 100% lost |
%Bad Debts Outstanding | -------Bad Debts Outstanding (KCURR) = --------------------------------------------------- -------------Outstanding (KCURR)
|
Advanced Payment Outstanding (KCURR) | Payment received ahead of schedule |
%Advanced Payment Outstanding | -------Advanced Payment Outstanding (KCURR) = ------------------------------------------------------------------- ---------------Outstanding (KCURR) |
Write Downs Outstanding (KCURR) | Bad Debits adjustment |
%Write Downs Outstanding | -----------Write Downs Outstanding (KCURR) = ------------------------------------------------------------------- ------------------Outstanding (KCURR) |
|
QV Query: | QVSBS_BW_QRY_MVFIAR01_0001 QVSBS_BW_QRY_MVFIAR01_0006 (TABLE: Aged Overdue) |
Core Query | |
| Specific Dimensions |
|---|
GL Account Sub Type | |
Mini Zone (Cust) | |
Customer Country | |
PRS Customer | |
Customer Group | |
Coll. Speci. | |
Sales Rep | |
Credit. Mgr. | |
Page
viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))