Consolidation of FX in one place
Use Cases and Deployment Scope
We have recently built 2 reports with SAP BPC (Business Planning and Consolidation) which allow us to show balance sheet & P&L in one currency that has evolved our reporting process and made it more efficient and accurate. Previously we used a manual excel file to consolidate all values and the exchange rate issue was very time reliant and caused multiple issues. Sage BPC has eliminated this issue as we have the elimination entry section that clears up. It has also allowed us to create consolidated reports for different areas of business (eg - 2 or 3 businesses at once) which were previously reported manually.
Pros
- combine currencies into one easy to use report
- allow the addition of graphs to reports and dashboards to show trends clearly
- allows for multiple books to be added where you can add and consolidate a number of entities together at your choosing with no hassle.
- stores previous consolidations so it is easy to track & fix any issues with progress
Cons
- some reports seem to take a while to run and crash when too much information is being processed
- Graphs don't allows certain things to be added like labels & %. If this could be replicated like excel graphs it would be ideal. The option to then add to dashboards would help presentation of accounts
- reports are very limited and the scope to add in creative reporting isnt large. Would be nice to be able to add in manual calculations on reports and show KPI's specific to company
Likelihood to Recommend
SAP BPC (Business Planning and Consolidation) overall is a good package and has helped improve our reporting a lot whilst also making it more efficient due to the reliability of data input / output. There are limitations like graphs being so limited in functionality and reports failing when too much data being processed however i would recommend to others.
