Upload
others
View
5
Download
0
Embed Size (px)
Citation preview
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Achieve Fast Close and Finance Innovation Even in Complex System Landscapes
Enel
Pasquale De Pascalis : ENEL AFC – Global Central Finance Project Manager
Set 13th 2018
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Agenda
13/09/2018 2
Company profile
Key Drivers for Finance Transformation
Fast Closing 2.0: project background
SAP S/4HANA for Enel Central Finance
Results, business value and benefits
Fast Closing 2.0: lessons learned
Roadmap: Next Level Reporting
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Company Profile: Enel is very complex Group with its headquarter in Italy
13/09/2018 3
WHO WE ARE ✓ World’s leader in electricity and gas utilities
WHERE WE ARE ✓ in more than 30 countries in 5
continents
MAIN FIGURES ✓ 86 GW (43% Renewables)
✓ 2.2 Mln km of Electricity Network
✓ +73 million end users
✓ 63.000 employees
✓ Revenues 2016 : +75 €bn
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Key business challenges driving the project
13/09/2018 4
• Reporting tools not efficient Reporting
Model
•Closing procedures very slowFast
Closing “2.0”
• Many manual activities
• High number of Reports
•Many activities under performed
•Checks redundance
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Enel Fast Closing 2.0 scenario: Fast Closing reporting delivered with more effective and efficient processes
13/09/2018 5
• 2 CLOSING PROCESSES
FROM
Data
quality
Time
compression
• 1 CLOSING PROCESS
TO
• LACK OF SYSTEMS & AUTOMATION
• NO ESTIMATION
• NO TASK PRIORITIZATION
• ESTIMATION
• SYSTEMS EMPOWERMENT
• DOUBLE BINARY APPROACH
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Enel Fast Closing 2.0 scenario: Fast Closing Methodology
SAP and ENEL proprietary | 6
……
▪ All events are posted using a single accounting binary.
▪ An unique closing process is executed, relevant for both statutory and
managerial purposes.
▪ Single binary is applicable to all closing calendars (monthly, quarterly, half–
yearly, yearly).
▪ Estimations are allowed if necessary \ admitted.
Single Binary (Old Solution)
Statutory& Manag. Accounting
Consolidation
Data available for consolidation and reporting• Complete fiscal required postings
• Accounting posts for accruals, adjustments, depreciations, other necessary \ admitted estimations
CTB(*)
▪ The actual data are freeze on the basis of the closing calendar. It’s possible
to set several cut-off dates per each month
▪ Managerial integrations are posted on a specific “accounting binary” with no
statutory and fiscal impacts
▪ The ordinary activities continue to be managed on current “Operational”
ERPs (e.g. billing, etc.)
▪ Day by day activity over the cut-off dates has no impacts on management
reporting
▪ Managerial and statutory reporting are reconciled half-yearly only
▪ Yearly closing follow the Statutory Accounting calendar
Double Binary (New Solution based on Fast Closing)
Statutory Accounting
ManagerialAccounting
Cut-Off
Cut off date for freezing accounting data P&L and BS Managerial integrations
SAP
(Monthly, QuarterlyHalf-Yearly)
Data available for managerial consolidation and reporting processes
End of month
End of month
(Yearly)
(all closing cycles)
CTB(*)
ConsolidationCTB(*)
Time 0 Time 1
* Close the Book
Consolidation
In order to accelerate its Financial Closing processes, Enel decided to adopt the Fast Closing methodology, freezing the accounting data some
days before the end of the moth, starting the estimation process on the basis of reliable and affordable procedures. In order to reach the
above objective, Enel decided to move from the “Sigle Binary” Accounting Model to the “Double Binary” Accounting Model.
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Enel Fast Closing 2.0: key figures
13/09/2018 7
20SAP source
systems
545Live
companies
5Months
1st go live
5 SAP source
releases
167 MioAccounting
Documents
83 MioControlling
objects
23Countries
950 MioAccounting
Line items
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Enel Fast Closing 2.0: in scope processes
13/09/2018 8
Organize Fast Closing operations through the SAP Financial Closing Cockpit
1
Run the Intercompany reconciliation process
2
Manage Time Segregation Table and Managerial Journals
3
Extract data to feed the Enel consolidation system
4
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: integration of 19 SAP source systems to a SAP S/4HANA for Central Finance
13/09/2018 9
Real Time
Replication
Tool
Enel
Source
Systems
SAP
Landscape
Transformation
Server
Enel Fast Closing System
Based on SAP Central Finance solution
Enel
consolidation
System
Tableau
de board
SZP
IIP
PRD
DIP
ESP
GEP
PRD
SRP
….
Financial Closing Cockpit (FCC)
Cutoff Time 0 / Cutoff Time 1
Intercompany
Reconciliation
Manual Managerial Journals
(Time 1)
Automatic postings
(Time 0)
Automatic postings
(Time 1)
Time Segregation
based on FCC
calendar
Actual
Postings
Estimation
Business
Mapping
1
2
3
Tableau
de board
/
Reporting
Consolidation
Tax
Compliance
Extractors
4
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: integration of 19 SAP source systems to a SAP S/4HANA for Central Finance
13/09/2018 10
Real Time
Replication
Tool
Enel
Source
Systems
SAP
Landscape
Transformation
Server
Enel Fast Closing System
Based on SAP Central Finance solution
Enel
consolidation
System
Tableau
de board
SZP
IIP
PRD
DIP
ESP
GEP
PRD
SRP
….
Financial Closing Cockpit (FCC)
Cutoff Time 0 / Cutoff Time 1
Intercompany
Reconciliation
Manual Managerial Journals
(Time 1)
Automatic postings
(Time 0)
Automatic postings
(Time 1)
Time Segregation
based on FCC
calendar
Actual
Postings
Estimation
Business
Mapping
A
B
C
Tableau
de board
/
Reporting
Consolidation
Tax
Compliance
Extractors
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: Time Segregation rules
13/09/2018 11
• Closing Calendar rules are based on the following objects:
• Time Segregation Dimension Coding rules:
o 1st digit = T
o 2nd and 3rd digit = Month of Period Closing;
o 3th and 4th digit
− 00, if the Document CPU Date is before or equal to the
Cut-off Date
− 01, if the Document CPU Date is after the Cut-off Date
− 02, when Managerial Integrations are inserted
− 03, when Managerial Integrations are Reversed
Centrally using a specific Reversal Reason
Period of
Closing
SAP Module
(FI/CO)
Company
Code/Group of
Companies
FI Doc.
Type
CO Business
Transaction
Cut-Off
DateNotes
2015.07 FI Z001 26/07/2015
2015.07 FI Z001 WA 31/07/2015
2015.07 FI Z001 WE 29/07/2015
2015.07 CO Z001 31/07/2015
When the Document Type is blank, the
Time Segregation Rule is applied to all
other FI Document Types not present in
the Closing Calendar Rules table
When the CO Business
Transaction is blank, the Time
Segregation Rule is applied to
all other CO Business
Transactions not present in the
Closing Calendar Rules table
T. S.
Code Time Segregation Text
T0100 January: Automatic Postings before the Cut-off date
T0101 January: Automatic Postings after the Cut-off date
T0102 January: Managerial Integrations
T0103 January: Reversal of Managerial Integrations
T0200 February: Automatic Postings before the Cut-off date
T0201 February: Automatic Postings after the Cut-off date
T0202 February: Managerial Integrations
T0203 February: Reversal of Managerial Integrations
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: Business Mapping &Actual Postings with Time Segregation
13/09/2018 12
ENEL ERP SystemsENEL Central Finance SystemAccounting Postings
Posting
Date
Comp.
Code
Doc
Number
FI
Doc. Type
CO Bus.
Trans.CPU Date S/H Value CO Obj
25/07/2015 Z001 8000/010 SA 25/07/2015 S 1.000 € Profit 1
25/07/2015 Z001 8000/020 SA 25/07/2015 H 1.000 € Profit 1
26/07/2015 Z001 8100/010 SA 27/07/2015 S 1.000 € Profit 1
26/07/2015 Z001 8100/020 SA 27/07/2015 H 1.000 € Profit 1
27/07/2015 Z001 8200/010 WE 27/07/2015 S 2.000 € Profit 1
27/07/2015 Z001 8200/020 WE 27/07/2015 H 2.000 € Profit 1
28/07/2015 Z001 8201/010 WE 31/07/2015 S 2.000 € Profit 1
28/07/2015 Z001 8201/020 WE 31/07/2015 H 2.000 € Profit 1
Business Dimensions Rules
CO
Object
Business
Dimension
Profit 1 B1
Profit 2 B1
Profit 3 B2
Profit 4 B3
Posting
Period
Company
Code/Group of
Companies
FI
Document
Type
CO
Business
Transaction
Cut-Off
Date
2015.07 Z001 26/07/2015
2015.07 Z001 WA 31/07/2015
2015.07 Z001 WE 29/07/2015
2015.07 Z001 31/07/2015
Segregation Rules
Accounting Postings on ENEL Fast Closing System
Posting
Date
Comp.
Code
Doc
Number
FI
Doc. Type
CO Bus.
Trans.CO Obj CPU Date S/H Value
Source
Sys
Time
Segr.
Business
Dimension
25/07/2015 Z001 8000/010 SA Profit 1 25/07/2015 S 1.000 € ERP1 T0700 B1
25/07/2015 Z001 8000/020 SA Profit 1 25/07/2015 H 1.000 € ERP1 T0700 B1
26/07/2015 Z001 8100/010 SA Profit 1 27/07/2015 S 1.000 € ERP1 T0701 B1
26/07/2015 Z001 8100/020 SA Profit 1 27/07/2015 H 1.000 € ERP1 T0701 B1
27/07/2015 Z001 8200/010 WE Profit 1 27/07/2015 S 2.000 € ERP1 T0700 B1
27/07/2015 Z001 8200/020 WE Profit 1 27/07/2015 H 2.000 € ERP1 T0700 B1
28/07/2015 Z001 8201/010 WE Profit 1 31/07/2015 S 2.000 € ERP1 T0701 B1
28/07/2015 Z001 8201/020 WE Profit 1 31/07/2015 H 2.000 € ERP1 T0701 B1
… … … … … … … … … …
31/07/2015 Z001 8900/010 SA Profit 1 31/07/2015 S 2.000 € ERP1 T0702 B1
31/07/2015 Z001 8900/020 SA Profit 1 31/07/2015 H 2.000 € ERP1 T0702 B1
Manual Managerial Journals
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: Intercompany ReconciliationProcess
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: Intercompany ReconciliationProcess
The ICR Process is a
cycle of 3 individual
steps
1) Documents Selection (Data Selection & Data Storage)
2) Automatic Documents Reconciliation(Preparation for Data Presentation & Analysis)
3) Manual Documents Reconciliation: (Data Presentation & Analysis and Communication)
This is meant to reduce the differences in corporate group consolidation, allowing early analysis
in the closing process avoiding differences
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Solution Overview: Intercompany ReconciliationProcess
From manual download
and Excel configuration…
…to automatic mapping of account
groups and postings
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
ENEL Central Finance Systems
Solution Overview:Time Segregation Reconciliation Tools
Balan Sheet Reconciliation Report
supporting Time Segregation logics
ENEL ERP Systems
Data Query via RFC Connection,
submitting Time Segregation rules
Data retrieve applying Time
Segregation rules
AIF Queue
ACDOCA
Data Query submitting
Time Segregation rules
Data Query reading
Time Segregated data
Data retrieve applying
Time Segregation rules
Selection Screen Report
Visual alerting
Mail alerting
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Enel Fast Closing 2.0 key results: savings in working days for 2015/2016 and reduction foreseen for 2017
13/09/2018 17
Main Processes Notes(Focus Italia)
Treasury / Int &
Currencies
Derivtives
Total
Fixed Assets
Personell
11
Submission
Costs & Rev
No Energy
Energy Margin
& Commodities
Derivtives
Starting point and improvements: from 16 to 5 days!
Start
Consolidation 5
2
0,5
8
16
6
10
9
1
• System Optimization (i.e. Curves Management; Front to Accounting, enhancement Calculation Systems). More
Estimation in Energy Margin definition. Change in Billing processes
2017
2
2
2
2
2
5
• System Optimization (i.e. Settlements, Amortization).
• System Optimization (i.e. mirroring Accounting, Check Rationalization).
• Halving of loading time. Flows uploads optimization
• Improvements of reconciliation process. Automantic Rules and application of prevalence rules
• Global Business Line consolidation process (automatic). Speed up of consolidation process using the new
release of Hyperion HFM
• Processes Optimization (i.e. Anticipation in Good Entrance, Improvements in Vendor Management Cycle
• Antìcipation in the closing of Personnel processes up to arrive WD+2. Convergence of reporting processes among HR
and AFC
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Key business value and benefit
13/09/2018 18
TIME TO CLOSE REDUCTION
DATA HARMONIZATION
REAL TIME - INSTANT VISIBILITY
DATA IN ONE SINGLE PLATFORM
ENHANCED COLLABORATION
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Lessons learned and business advice
13/09/2018 19
SHARED VISION AND CLEAR OBJECTIVE
PROGRAMS INTERACTION : A KEY FACTOR
INNOVATION THROUGH COLLABORATION
YOU NEED A GREAT TEAM IN PLACE
RESULTS BUILD TRUST
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Roadmap: Next Level ReportingGoals and Key Factors
20
• Have a complete view of company performance that impact on the
key nodes of the organization
• Take the key decisions on the basis of cross business certified data
• Have a near real time view of the information
• Allow in-depth analysis to improve support for decision-making
• Enable predictive models to have a forward view of business trends
• Manage simulation scenarios to highlight the impacts of potential
decisions on economic-financial and operational aspects
1
2
4
5
3
6
Data sharing
New mindset
Tech innovation
New skills and
methodologies
Change
management
Goals Key Factors
New Unified Virtual Data Lake (UVDL) based on C3IoT
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Roadmap: Next Level ReportingUnified Virtual Data Lake Architecture
21
CFIN
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
AFC Data Lake
Roadmap: Next Level Reporting Journey
22
Financials
ConsolidationAnnual
Bdg & Fcst
Operational Data
– VolumesWhat If Analysis
Strategic
Plan
Actual vs Planning
Control Model«Next Level Dashboarding»
«Next Level» Reporting – SAP Analytics Cloud and SAP Digital Boardroom
Variances
Explanations
Predictive
Forecasting
Economic &
FInancial
Operational Data
Analytics Tools – Lumira, Web Intelligence, Analysis for Office, Predictive Analytics, SAC
Ro
wD
ata
Level
Data
Mo
del
ProjectsOperational
Reporting
1NP Consolidation
& DSS
2
Operational Data
1
Economic &
Financials
1
Financials
Consolidation
2
1 2
E-Budget
3
Strategic
Plan
2
3
Actual vs Planning
Control Model
1
Annual
Bdg & Fcst
Operational Data
– Volumes
3 4
Near Real Time
4
4
Next Level
Reporting
5
What If AnalysisVariances
Explanations
5 5
Predictive
Forecasting
3
«Next Level Dashboarding»
5
5
5
Data Consuption
4
4 5
2 34
4
#NP#_XZFtT8IwEMe/SrNXGhl7xo13G2w EBVkcBDVLTO0KNIx2a YuaEL6 7V4ma mDTXu/v/7npt TxYh1vBkyc20sYaW57 qwjLHOPZBMrnbGWNMrLwoGgXsb+z7oNy7Y 69qxel bDTD0G EII3s88 ZkUKJj Ual+KCy FIxrA0 7HIN5PJ ndhmN6/TMPFMliuIv 8xWqyLMPAA2 XRA7LT u1LB2a kdjIsSe CK6OrcZcq77aY Uk707 BPxKF2F NNU1 U7+TkH 926u0t OeY4y0 9QMIeCa6laFv Gt7bvej EApk+ DxoIcD5 eSmdg ypRkx1R3FeyrRbwpthE SZ0Dv 0c0ApqQIPawbD1c4IfIl bVDCOOaHov1 y85py2 qGpZQ1W/6/QnXLa7PMisesrCdBCX5 UMSPSe riRvMqtyt8jUw+htJRl GW50V sw+yJ HcbZ2E4 iEyZhmkbFwPNz+K/zF w==_# NP#
Thank you !
Pasquale De Pascalis : ENEL AFC – Global Central Finance Project Manager