Analytics Overview

The trading arm of a multinational energy business asked AG for help with automating invoice and settlement reporting. The team were using Power BI for their analytics but were running 10+ reports in SAP to extract the data. This would then be dumped into Excel, reformatted and uploaded onto Power BI.

AG brought great efficiencies to the process. Using Winshuttle, they moved data extraction from multiple SAP screens and reports to a user-friendly spreadsheet that captured only the required fields. The spreadsheet was then be uploaded onto Power BI, making a time consuming and prone-to-error process a breeze.

This leading Oil & Gas business’ joint venture accounting (JVA) month end was characterised by frequent delays, a problem aggravated by a recent change in the business environment. AG conducted a review of their SAP JVA solution design and processes and found a number of candidates for improvement.

Lack of onboarding and succession planning was an issue, together with complex SAP system tasks required from accounting resources, lack of automation and manual reports, and poor understanding of the SAP reports and outputs. By showing how they could optimise their use of the system and people resources, AG helped the company reduce risk, improve efficiency and remove the road-blocks to a smooth period end.

When this global leader in specialist pharmaceutical active ingredients was acquired, they engaged AG to ensure that the processing of supplier payments amounting to $100M per month was rapidly moved to the new company while still using the old parent’s SAP ERP.

The solution, which met unique integration requirements, synchronised invoice and supplier details between the 2 systems to create payment records that the new company could action. Validation eliminated the risk of payment duplication and ensured that suppliers were paid when invoices were due. The result was a robust solution delivered on time & on budget.