Cust 360° - Financials

Daily update for current month and previous month

Weekly reload for all the data prior to previous month

Source: QVSBS_BW_QRY_MVCOPA01_0004

• Revenue: Sum of Direct Sales + Estimated Indirect Sales (EIS)
  
  

• Direct Sales: All invoiced amounts based on Corporate Sold-to group = GSKA
  For Composite Materials, direct sales based on manual mappings: 

• Estimated Indirect Sales (EIS):
  When EKAM knows or can identify the final customer for the indirect sales, EIS appears in the GSKA dashboard as it is calculated by the system by applying these filters (the same can be reproduced manually in CRM Analytics): 
  
  Ship-To-KA = GSKA (Intel...) AND Corporate Sold-To group ≠ GSKA (Intel) 
  

Updated daily from BW.

Budget: yearly

BFR: each quarter

MTP: yearly

Source:

Budget for 2021 has been loaded for most of GSKAs.

Budget 

• Available for CM, TS, Peroxides, Silica, Aroma, SA, SpP, Novecare, Coatis & SpChem
• Novecare at ship-to-KA level (so not exploitable at corp sold to level)

MTP (Y+1 to Y+4)

• Only available for the GSKA for Peroxides, SpChem, Aroma, TS, Coatis, Soda Ash
• Not available for Silica, CM, Novecare & SpP

Daily update

Source: Picaso (SpP) / Dynasys for the other GBUs / *Not available for Coatis

Daily update for current month and previous month

Weekly reload for all the data prior to previous month

Source: QVSBS_BW_QRY_MVCOPA01_0004

The objective is to understand at a glance the % of revenue done per payment term and check evolution YoY. 

Less than 100 Approved payment terms - list here

See ONE Credit Policy

Payment terms adherence = average number of days of the orders weighted by revenue. The target is 30 days

Calculation = Sum ( revenues of the selected rows x Payments terms number of days of the selected rows) / Sum of the revenues of the selected rows of the month

Deviating customers 

This table shows only deviating customer according to the following filters

• All the standard accounts and standard distributors above 30 days / if Ship-to Region = LAM, above 45 days 
• All the critical accounts and key distributors above 45 Days
• All the key account and strategic key account above 60 Days

Key dimensions

Number of days applied as Payment Terms: [C_PMNTRM2] Payment Term_P\Attributs\[C_STDPTRM] CM Std Payment Term

Revenues = Net Sales Internal + External (Sales + Royalties)

Daily update

Source: QVSBS_BW_QRY_MVFIAR01_0001

Link to the wiki of the Customer Credit & Trade dashboard

Overdue :

Outstanding* that is late vs. the planned payment terms.

Credit notes, early payments can lead to a negative Overdue.

Overdue % :

Late outstanding* vs. global outstanding*

Credit notes, early payments can lead to a negative Overdue %.

* Outstanding: Cash to be collected by Solvay including VAT. 

Warning : revenue (in Sales Performance for instance) is excluding VAT.

DSO :

Average number of days before receiving payment.

Credit notes, early payments can lead to a negative DSO.

Best DSO :

DSO with the hypothesis that all the payment terms commitments are fulfilled.

Credit notes, early payments can lead to a DSO lower than Best DSO.

DSO - Best DSO = Average days late.