Group Reporting with SAP S/4HANA
Description
Get financial consolidation up and running! With this comprehensive guide, learn how to set up and use SAP S/4HANA Finance for group reporting. Organize your financials information by configuring global settings, master data, and transaction data. Walk through each group reporting process-intercompany elimination, consolidation of investments, and matrix consolidation-following step-by-step instructions for setup and execution. With details on consolidation reporting, this is the only book you need for a successful corporate close!
In this book, you'll learn about:
a. System Setup
Discover how group reporting fits into the architecture of SAP S/4HANA Finance. Customize key settings to suit your business: consolidation units, financial statement items, journal entries, data validation rules, and more.
b. Consolidation Processes
Perform a successful consolidation! Set up and run critical processes such as currency translation, intercompany profit elimination, and consolidation of investments using the Data Monitor and the Consolidation Monitor.
c. Reporting
Once your consolidation is complete, it's time to report your results. Use reporting rules to create flexible custom reports, and then explore reporting tools in SAP S/4HANA, SAP Analysis for Microsoft Office, and SAP Analytics Cloud.
Highlights include:
1) Master and transaction data
2) Currency translation
3) Intercompany elimination
4) Consolidation of investments
5) Consolidation entries
6) Matrix consolidation
7) Data Monitor
8) Consolidation Monitor
9) Reporting items and rules
10) Consolidation reporting
More details
Other editions
Previous edition
Persons
Content
... Objective of This Book ... 13
... Target Audience ... 14
... How to Read This Book ... 14
1 ... Introduction to Consolidation ... 17
1.1 ... Financial Consolidation Basics ... 17
1.2 ... Why Consolidate Financials Data? ... 22
1.3 ... Evolution of Consolidation with SAP Solutions ... 24
1.4 ... Financial Close in SAP S/4HANA ... 31
1.5 ... Summary ... 38
2 ... Group Reporting Architecture and Components ... 39
2.1 ... SAP S/4HANA Finance ... 39
2.2 ... Group Reporting ... 44
2.3 ... Summary ... 80
3 ... Master Data ... 81
3.1 ... Global Settings ... 81
3.2 ... Group Reporting Preparation Ledger ... 85
3.3 ... Group Reporting Master Data ... 89
3.4 ... Selections ... 153
3.5 ... Summary ... 155
4 ... Transaction Data ... 157
4.1 ... What Is the Data Monitor? ... 157
4.2 ... Configuring the Data Monitor ... 161
4.3 ... Integrating Transaction Data ... 170
4.4 ... Plan Data Integration ... 193
4.5 ... Balance Carryforward ... 194
4.6 ... Calculation of Net Income ... 201
4.7 ... Data Validation ... 206
4.8 ... Journal Entries ... 217
4.9 ... Group Reporting Preparation Ledger ... 226
4.10 ... Substitution and Validation Rules ... 235
4.11 ... Summary ... 241
5 ... Currency Translation ... 243
5.1 ... What Is Currency Translation? ... 243
5.2 ... Configuring Currency Translation ... 249
5.3 ... Translating Reported Currency ... 276
5.4 ... Summary ... 282
6 ... Intercompany Elimination ... 283
6.1 ... What Is Intercompany Elimination? ... 283
6.2 ... What Is the Consolidation Monitor? ... 292
6.3 ... Configuring the Consolidation Monitor ... 296
6.4 ... Configuring Intercompany Elimination ... 317
6.5 ... Eliminating Intercompany Transactions ... 325
6.6 ... Eliminating Intercompany Profit in Inventory ... 331
6.7 ... Summary ... 344
7 ... Consolidation of Investments ... 345
7.1 ... What Is Consolidation of Investments? ... 346
7.2 ... Configuring Rule-Based Consolidation of Investments ... 356
7.3 ... Configuring Activity-Based Consolidation of Investments ... 364
7.4 ... Running Equity and Investment Eliminations ... 387
7.5 ... Summary ... 390
8 ... Consolidation Entries ... 391
8.1 ... Common Consolidation Entries ... 391
8.2 ... Journal Entry Template ... 394
8.3 ... Summary ... 409
9 ... Matrix Consolidation ... 411
9.1 ... What Is Matrix Consolidation? ... 411
9.2 ... Configuring Matrix Consolidation ... 412
9.3 ... Running Matrix Consolidation ... 417
9.4 ... Summary ... 423
10 ... Consolidation Reporting ... 425
10.1 ... Predefined Reports ... 425
10.2 ... Reporting Rules and Reporting Items ... 433
10.3 ... Additional Reporting Tools ... 442
10.4 ... SAP Fiori ... 460
10.5 ... Summary ... 464
11 ... Conclusion ... 465
11.1 ... Book Summary ... 465
11.2 ... Considerations for Your Group Reporting Journey ... 466
11.3 ... Five Key Takeaways ... 468
... The Authors ... 471
... Index ... 473