The Sage Active Dashboard shows you an overview of key information (or KPIs) for you business.
These KPIs are either based on direct figures from your existing financial reports or they are the result of calculations performed with these figures. The tables below show the report titles and the description for the report lines that are used when retrieving the amounts for calculating each KPI.
The value for the Operating result KPI is the difference between the amounts for the lines TOTAL (A+B) and TOTAL I of the Profit and loss report.
Depending on the start date of you fiscal year, a different format is used for the balance sheet and profit and loss report. The KPI calculation for both forms is described below
The period for the calculations starts from the first day of the current fiscal year until the current date.
Format 2025
| KPI | Source document | Calculation |
|---|---|---|
| Sales | Profit and loss | MONTANT NET CHIFFRE D’AFFAIRES |
| Purchases | Profit and loss | COÛT D’ACHAT DES MARCHANDISES + CONSOMMATION EXERCICE/TIERS |
| Gross profit | KPI | KPI Sales – KPI Purchases |
| Result before taxes on profits | Profit and loss | 3. RESULTAT COURANT avant impôts (I – II + III – IV + V – VI) + 4. RESULTAT EXCEPTIONNEL (VII-VIII) – PARTICIPATION DES SALARIES AUX RESULTATS (IX) |
| Operating result | Profit and loss | 1. RESULTAT D’EXPLOITATION (I -II) |
| Financial result | Profit and loss | 2. RESULTAT FINANCIER (V – VI) |
| Exceptional result | Profit and loss | 4. RESULTAT EXCEPTIONNEL (VII-VIII) + Bénéfice attribué ou perte transférée (III) – Perte supportée ou bénéfice transféré (IV) – Participation des salariés aux résultats (IX) |
| Available funds | Balance sheet (Amount column) | VALEURS MOBILIERES DE PLACEMENT |
| Working capital | Balance sheet (Amount column) | TOTAL DE L’ACTIF CIRCULANT (IV) – [ AVANCES & ACOMPTES REÇUS SUR COMMANDES EN COURS + DETTES FOURNISSEURS & COMPTES RATTACHÉS + DETTES FISCALES ET SOCIALES + DETTES SUR IMMOBILISATIONS ET COMPTES RATTACHÉS + AUTRES DETTES + PRODUITS CONSTATÉS D’AVANCE ] |
| Staff cost | Profit and loss | CHARGES DU PERSONNEL |
| Return on sales (ROS) | KPI | ( KPI Operating result / KPI Sales ) x 100 |
| Return on assets (ROA) | KPI Balance sheet (Amount column) |
( KPI Operating result / Balance sheet TOTAL GENERAL DE L’ACTIF (I á VII) ) x 100 |
| Return on equity (ROE) | Profit and loss Balance sheet (Amount column) |
( Profit & loss RÉSULTAT DE L’EXERCICE / Balance sheet TOTAL DES CAPITAUX PROPRES (I) ) x 100 |
Format 2024
| KPI | Source document | Calculation |
|---|---|---|
| Sales | Profit and loss | MONTANT NET CHIFFRE D’AFFAIRES (A) |
| Purchases | Profit and loss | COÛT D’ACHAT DES MARCHANDISES + CONSOMMATION EXERCICE/TIERS |
| Gross profit | KPI | KPI Sales – KPI Purchases |
| Result before taxes on profits | Profit and loss | TOTAL (A+B) + PRODUITS FINANCIERS (III) + PRODUITS EXCEPTIONNELS (IV) + QUOTES-PARTS RESULTATS/OP COM (II) – TOTAL I – CHARGES FINANCIERES (III) – CHARGES EXCEPTIONNELLES (IV) – QUOTES-PARTS RESULTATS/OP COM (II) – PARTICIPATION SALARIES EXPANSION (V) |
| Operating result | Profit and loss | TOTAL (A+B) – TOTAL I |
| Financial result | Profit and loss | PRODUITS FINANCIERS (III) – CHARGES FINANCIERES (III) |
| Exceptional result | Profit and loss | PRODUITS EXCEPTIONNELS (IV) – CHARGES EXCEPTIONNELLES (IV) + QUOTES-PARTS RESULTATS/OP COM (II) – QUOTES-PARTS RESULTATS/OP COM (II) – PARTICIPATION SALARIES EXPANSION (V) |
| Available funds | Balance sheet (Amount column) | DIVERS |
| Working capital | Balance sheet (Amount column) | ( CRÉANCES + STOCKS ET EN-COURS + DIVERS + CHARGES CONSTATÉES D’AVANCE + AVANCES & ACOMPTES VERSÉS/COMMANDES ) – ( DETTES FOURNISSEURS & COMPTES RATTACHÉS + DETTES FISCALES ET SOCIALES + DETTES SUR IMMOBILISATIONS ET COMPTES RATTACHÉS + AUTRES DETTES + PRODUITS CONSTATÉS D’AVANCE + AVANCES & ACOMPTES REÇUS SUR COMMANDES EN COURS ) |
| Staff cost | Profit and loss | CHARGES DU PERSONNEL |
| Return on sales (ROS) | KPI | ( KPI Operating result / KPI Sales ) x 100 |
| Return on assets (ROA) | KPI Balance sheet (Amount column) |
( KPI Operating result / Balance sheet TOTAL GENERAL (I à VI) ) x 100 |
| Return on equity (ROE) | Profit and loss Balance sheet (Amount column) |
( Profit & loss RÉSULTAT DE L’EXERCICE / Balance sheet TOTAL (I) + TOTAL (II) ) x 100 |
Follow all the news from Sage