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 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: [email protected]