ATM Operator

ATM cost benefit analysis

Building cost-effective ATM network

Implementation Man-days

0

Days

Interconnected Models

0

Models

Business Acc. Units

0

Units

General Ledger Accounts

0

Accounts

Operating Accounts

0

Accounts

Data records available online

0

Thousands

Project Highlights

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.

Pain Points & Operational Challenges

6 weeks

The average budgeting process that was never finished due to constant changes of ATM deployments and relocations

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.

6 weeks

The average budgeting process that was never finished due to constant changes of ATM deployments and relocations

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.

Key Benefits

Holistic ATM

Holistic ATM performance assessment per location, enabling ad hoc consolidation due to changes

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.

Holistic ATM

Holistic ATM performance assessment per location, enabling ad hoc consolidation due to changes

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.

Project Milestones

  • 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.