23
Achieve Fast Close and Finance Innovation Even in Complex System Landscapes Enel Pasquale De Pascalis : ENEL AFC Global Central Finance Project Manager Set 13 th 2018

Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

  • Upload
    others

  • View
    5

  • Download
    0

Embed Size (px)

Citation preview

Page 1: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 2: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 3: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 4: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 5: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 6: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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.

Page 7: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 8: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 9: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 10: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 11: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 12: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 13: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 14: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 15: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 16: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 17: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 18: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 19: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 20: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 21: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 22: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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

Page 23: Achieve Fast Close and Finance Innovation Even in Complex ... · Enel Fast Closing 2.0: in scope processes 13/09/2018 8 Organize Fast Closing operations through the SAP Financial

#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