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
Return on Investment
- We have been able to spend much more time analysis reports rather than producing them as they are automated and show in one currency
- budget input has been really helpful as we have been able to process this and measure performance clearly as opposed to on manual excel sheets which are easy to manipulate / reliant on manual entry.
- as we can continuously see performance against targets we have been able to prepare better for year end forecast due to trends being analysed and expectations being more easy to manage as a result
Alternatives Considered
Dimensions360
Other Software Used
Dimensions, InTime, itris 9





