Exciting new opportunity has become available for a Cash Forecasting & Reporting Assistant Analyst to join our expert Cash & Central Costs Team, which will report into the Cash Forecasting & Reporting Manager within Sainsbury’s Argos. The FP&A Cash & Central Costs team are key to Sainsbury’s Argos…. they deal with over £8billion (yes that’s billion) pounds worth of sales receipts and payments to suppliers, and provide the most up to date views on how much cash we will generate as a business in a financial year.
At Sainsbury’s Argos, the great digital transformation is under way. It’s our aim to become the digital market leader in choice, value and convenience, so our Finance teams are more important to us now than ever before. They’re the people who provide support across the business and help make the crucial decisions that will allow us to develop into a leading digital retailer. We have joined Sainsbury’s in our journey to become a leading retail organisation and ensuring we place our customers at the heart of everything we do. Together we have a great opportunity to build a brilliant future and do a fantastic job for all our customers.
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.