ATM Operator

An individual P&L, BS and CF for consolidated group reports in multi-currency.

An individual P&L and Cash Flow for each ATM in the company network and for the portfolio as a whole.

Automated data transfer to MYGIDE from various independent data sources.

The company’s business was to deploy and operate a network of ATM machines, deployed progressively in several markets.

As a bank independent operator, the key challenge for the company was to achieve higher efficiency of its ATM network, compared to bank ATM networks, in order to operate a sustainable business. This involved achieving an optimal level of ATM operating costs (cost of leased space, card acquiring and processing services, cash and cash supply into ATMs, etc.) vis a vis a lower number of transactions that a bank network averages.

Management reporting included a record of newly deployed ATMs, the number of transactions and other value added services provided by ATMs, along with associated operating expenses. The company was seeking individual P&L and cash flow statements per ATM and visibility of the portfolio as a whole for each country and a consolidated view, including a detailed breakdown of each (service provided at the ATM). This required several third party txt based daily and monthly reports (FirstData, RBS, Visa & Mastercard) to be reconciled with accounting data (monthly records) and ATM operating records (cash, cash in transit, ATM deployment, etc.) – reported on weekly basis.

The reports were produced in slow performing excel, effectively leading to several unconnected files and producing company aggregate and selected data only. It took around 1 week to produce this incomplete report for the management. Budgeting took 6 weeks, however was effectively never finished due to the constant change with new ATM deployments, and ATM relocations.

A bespoke modelling and planning environment reflecting an ATM deployment business model available to entire team.

Holistic ATM financials available on a monthly basis, including comprehensive review of ATM performance per location, per day and month, with a possibility to consolidate ATMs ad hoc in variety of options.

Integrated analysis of the actual performance, budgeting, rolling forecasting, and strategic planning taking into consideration ATM performance, ATM roll out and relocation plan and TXN development.

Optimized cash to ATM supply based on individual ATM performance. Automated data transfer to MYGIDE from several independent data sources into specific ATM operation financial models, eliminating laborious manual report production.

• 7th Day

  ATM data review, analysis and conversion of company’s existing spreadsheets to MYGIDE.

• 14th Day

  ATM related data sources linked to accounting, serving as the basis for ATM performance models, and made available for the first client experience.

• 21th Day

  ATM models combined with general and administration data into complete consolidated financial models.

• 24th Day

  Review of company’s current performance, variance to budget. Rolling forecasting and year end forecast revision.

• 27th Day

  First top management meeting using MYGIDE reports.

• 32th Day

  Company’s employees began adjusting the models and modelling functions with assistance of the implementation team.

• 45th Day

  MYGIDE was routinely used.