Job Description
Interested in learning more about this job Scroll down and find out what skills, experience and educational qualifications are needed.
Rutherford Cross is delighted to be working in partnership with one of Scotland's most iconic FMCG brands based in Glasgow City Centre to appoint an Interim Finance Analyst for a 6-month period. This is a 6-month contract that will have the potential to be made permanent. This role will suit a recent accountancy graduate or someone in the infancy of their finance career.
Role & Responsibilities:
Daily Tasks
* Monitoring aged debts and carrying out customer credit checks (now mostly handled by Kath, but still required occasionally)
* Managing inbox and actioning queries
* Raising POs
* Processing and reviewing bank statements
* Maintaining SAP (clearing Shopify receipts, tidying accounts, resolving system issues)
* Enforcing the purchasing approval matrix
* Handling supplier and invoice queries
* Supporting colleagues with SAP issues (posting errors, invoice blocks, PO matching problems, stock issues)
* Creation and maintenance of Statement of Processes – for both reporting and month-end tasks
* Creation of Private Cask invoices
* Training colleagues on Excel re data manipulation, formulas, pivots, logic
* Reconciling filling, disgorging, cask sales and spirit quantity data in Cask Management, Spirit Cost and SAP
Month-End Tasks
(completed jointly with Finance Manager)
* Upload Supplier Invoices to SAP
* Run Receivables and Payables Reports
* Reconcile Bank Balances to SAP
* Run Shopify Sales Report, clear balances and upload fees report
* Process Bank Statement Imports
* Post Month-End Journals
* Manage Clearing Processes (Depreciation, WIP, GR/IR)
* Process VAT Returns
* Produce various Analysis spreadsheets required for reporting purposes
* Aged Debtors / Aged Creditors Reconciliation
* Balance Sheet Reconciliations
* Open New Accounting Periods in SAP
Reporting Responsibilities:
(This is the largest portion of time spent)
* Creating bespoke financial reports and data models for colleagues
* Cleansing and restructuring large data dumps (Sales Data, BD Data, Duty Reports, P&L extracts)
* Standardising reporting structures (consistent column names, corrected product families, corrected customer groupings)
* Improving workflows to reduce manual work (e.g., dynamic formulas, automation logic, templates)
* Fixing incorrect mappings and coding in datasets used by Sales, Marketing, and Operations
* Weekly updates of Shopify, SAP, and Volumes YTD spreadsheets
Maintaining and developing:
* Regional Sales Report
* Performance Analysis Report
* 2026 Sales Forecasting tools
Developing spreadsheet reporting for specific projects e.g.:
* Regional Sales Report
* Performance Overview Report
* Providing Business Development cost analysis v budget & forecast for Commercial and Sales & Marketing teams
* Product pricing and discount analysis
* Production of planned procurement spend to support production and sales budgets/forecasts
* Support the reporting of alcohol duty and required spreadsheet work
* Maintaining the integrity of the cask management and cost spreadsheets, ongoing reconciliation with SAP xcswzye and supporting the production and maturation team as regards data input and maintenance
* Maintaining the product master data set
* Maintaining the integrity of the monthly stock reports and periodic stock take data
* Fault-finding and spreadsheet troubleshooting across the business
Key Skills Required:
* Highly developed Excel skills, including the ability to manipulate large data sets downloaded from SAP and other sources
Personal Profile:
* Analytical, capable of interpreting data outputs into meaningful reporting, analysis and insight
* Highly organised, capable of working to tight timescales
* Flexibility and adaptability, capable of multi-tasking depending on business priorities
For more information, please contact Euan Bodie at Rutherford Cross
Our client is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status or pregnancy and maternity.