We provided our services to a client who required us to develop a report which would help monitor the orders of raw materials from the warehouse.Read case study →
This case study brings forth the services we provided for a transport and logistics company with an annual turnover up to 40 mil EUR. Prior to this, the customer had no centralised reports with data from different departments and the management had no access to monthly results.
We implemented a monthly report with analysis and control activities, focusing on commercial figures. The first analysis was on transport orders to monitor sales, the number of orders, invoiced kilometers, tariff / km and unpaid kilometers. Due to the implementation of a new ERP system, the customer was having a difficult time obtaining accurate data. Many orders were lacking the number of kilometers, therefore, we implemented an analysis with wrong data per user. The following analysis focused on different departments (domestic, foreign etc.), the most important being the analysis per customer to view monthly changes in sales and tariff. The customer had key accounts with contracts and our report supported the management to compare monthly figures (to control the data) and to negotiate new deals.
As a control activity we implemented a report to see delivered orders that were not invoiced yet. We have also built reports that allowed the monitoring of the km per truck and sales per destination (Loading Country = Unloading Country) with tariffs which would help negotiations during the tender phase. It was equally important to keep an eye on fuel and road tax data, therefore, we centralized data from different suppliers and we standardized the format. We presented a top down approach with monthly cost per product: fuel, adblue and road tax. This helped our customer see the high fuel cost and decide on increasing tariff. Afterwards, we presented the fuel cost per supplier (total amount and price per liter) in a separate analysis, with variances and comments.
We also provided an analysis on prices per station and the type of station (Economy, Motorway etc.). This helped the customer decide which station to use due to considerable price variances. As a control activity we defined a table to present the monthly fuel cost for the number of cars that were outside client orders and a table to present the impact of exchange rate on sales.
Last but not least we provided and extensive report on financial results, for which we used the Trial Balance and the General Ledger that are common in all companies. The first task was to define the monthly model for Income Statement. We presented a standard model with turnover analysis per GL account type (sales of services, goods etc.) and a detailed cost analysis with variances for each element. Previously, the management had no overview on results per department and to solve this problem we presented a PL per Profit Center. As a control activity this helped because not all costs where split per Profit Center and thus the results were wrong. The following reports where monthly sales per customer and PL element (same for suppliers).
Through the reports that we used, we provided the company with the most detailed, comprehensive listing containing data from all departments. These reports are the backbone of any accounting system which holds financial and non-financial data for an organisation. They allowed the management to get a detailed view over the business and make informed decisions to implement cost-cutting solutions that prevent wrong bookings.
Read about the services we provided for different companies, the challenges we faced and the solutions we offered in order to meet the requirements.