Cash Forecasting and Reporting Assistant Analyst HRGCD303505 Milton Keynes Posted 3 weeks ago

Job description

Role area
Finance
· Contract type
Permanent
· Job reference
HRGCD303505
· Location
Milton Keynes
MK9 2NW
· In this role, your responsibilities will include:

Analysing out the movements of c60 bank accounts of Sainsbury’s Argos on a daily basis, through the New Movement Analysis programme.
Summarising the daily balance for all the above bank accounts through the Daily Position Summary (DPS) and reconcile back to the accounting records (Lawson) and reporting tool (Hyperion) on a monthly basis after adjusting for unpresented cheques/BACS, uncollected credit card takings, floats, and cash in hand.
Communicating the weekly variances to the latest forecast to all the companies within Sainsbury’s Argos, analysing and reviewing the reasons for the variances, and appropriately timing or releasing the variances.
Communicating the updated consolidated latest view on a weekly basis to Sainsbury’s treasury team.
Comparing the consolidated weekly latest view to the rolling daily cash forecast prepared by the Commercial Payments team to ensure a consistent view is provided to the Sainsbury’s treasury team. (The Commercial Payments team provide the Sainsbury’s treasury team with a 10 day forecast of cashflows at half year and year end based on actual BACs, cheques, DD and TT payment runs.)
Calculating the statutory cash forecast for Sainsbury’s Argos (using the latest view of direct cash outflows) and comparing to previous views on a monthly basis depending on business need.
Reviewing on a monthly basis forward currency Euro deals that have matured, checking for hedge effectiveness and taking corrective action with the aid of the Treasury team.
Assisting in the understanding and forecasting of VAT payments based on a analysis of the business weekly performance.

At each budget/forecast process:

Be responsible for the Intercompany elimination process for Sainsbury’s Argos to reconcile between the statutory and direct cash flows;
Consolidate the Direct cash forecast for the whole group, analyse out the weekly direct cash by day based on appropriate methodology relevant to each area and compare the daily cash flows year on year after making allowances for changes in calendar, bank holidays etc; and,
Based on the budgeted Cost of Sales and Management fees for Argos Ireland, forecast the amount of Euros to buy/sell.

The successful candidate will have improved the overall treasury forecast accuracy and developed key relationships within the Sainsbury’s treasury team.

Your skills & experience will include:

Graduate calibre professional studying towards a professional accounting qualification ideally ACCA or CIMA.
Basic understanding of cashflow and working capital is essential.
Possess good inter-personal skills, have an empathetic nature and a good sense of humour.
Be enthusiastic, positive and have ability to proactively engage with key Finance and non-Finance stakeholders.
Be a team player with good presentation and communication skills (both verbal & written)
Possess can do attitude with an adaptable approach suitable to operating at pace and switching between priorities.
Strong systems skills including Excel.
Experience in a large company environment, preferably retail would be advantageous.

What you’ll get in return:

If being part of a hugely influential Finance team wasn’t enough, you’ll also receive a host of great benefits. As well as a competitive salary and bonus scheme you will receive a huge range of learning and development opportunities, 22 days holiday, a save-as-you-earn scheme, pension and staff discounts at Argos, Sainsbury’s and Habitat.