SAP BPC has various features and functionality that will meet a wide range of business needs. In this eBook we will focus on the features most needed for financial consolidations. This will give you the reader a better focused perspective in how BPC fits into the financial processes associated with a close. The features highlighted are:
♦ Currency Translation: Currency Translation is referring to the process of converting balances of 1 specific entity/company from local currency to a global or presentation currency. Why is this function important?
Here is an example:
Let’s say we have 2 different companies that are subsidiaries of a parent company. The parent company is a US based company and needs to submit the consolidated financial statements to the US government agencies. One subsidiary is located in China and the other one is located in France. Each of the subsidiaries will have transactions in their local currencies (Chine subsidiary in RMB and France subsidiaries in EUR). We cannot just combine all of the numbers together and give it to the US regulators since the exchange rates between RMB and EUR to USD is not 1to1. So in order to produce consolidated financial statements we first have to convert the local currency transactions to a USD equivalent.
SAP BPC has standard delivered functionality to convert balances from local currency to a global or presentation currency (this could be USD or any other currency established as the presentation currency). There are multiple steps to be taken in order to perform currency conversion correctly.
Digram of Currency Conversion rule configuration landing page in Administration
♦ Account Reclass: Reclass of accounts is a standard delivered functionality that can provide users the ability to move a specific balance from one intersection to another intersection. Why is this function important?
Here is an example:
For most companies, after the year end process, there exists a need to reclass the current year’s earnings into retained earnings. Any money that is calculated at the end of the year to represent total Net Income or Current Year retained earnings should become part of the Retained Earnings in the New Year.
This reclass process typically happens in the Balance Carry Forward process. One way of achieving this is by utilizing standard configuration of reclass to perform this process.
Digram of Eliminations and Adjustments rule configuration landing page in Administration.
Diagram of Consolidation method setup in administraion
♦ Microsoft Office Add-Ins: SAP BPC is integrated with the Microsoft office suite of applications (Excel, PowerPoint and Word). The main functionalities can be found in the Excel add-in. This is where you can trigger process runs, post journal entries, create reports and run other analysis. Data can be pulled straight into Excel reports or even a PowerPoint presentation and document.
Checkout SAP BPC Interview Questions
♦ Ownership Structures: SAP BPC handle entity ownership structures easily with standard functionality where a business user can adjust how a company is rollup up and how the entity should be consolidated. Each consolidation methodology can be defined in BPC and multiple methodologies can be structure and how the entity is defined.
♦ Interfaces: Interfaces can be setup to source data from multiple systems. These systems can be other SAP systems or other non-SAP systems. Interfaces can be setup but it may need custom programming depending on where the information is sourced form.
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies