Finance Analyst
Lifetime Training Group
Total years of experience :6 years, 9 Months
• Submission of business and learner information to Skills Funding Agency (SFA) on a monthly basis for the generation of approximately 90% of income for the business. (turnover: approx. £60m)
• Keeping up to date with the changes in SFA rules and regulations and ensuring data in various MIS are updated accordingly by the Compliance team.
• Using the Funding Information System (FIS) software, ensuring cashflow is maximised every month by performing various different checks on files submitted to the SFA and liaising with other departments to ensure error level is kept to minimal.
• Analysis and presentation of financial and non-financial data including revenue, cost and expenditure analysis including staff expenses and marketing spend. Dealing with queries from department heads.
• Maintaining close working relationships with the Commercial division managers and Sales manager designing process improvements and controls
• Periodic bad debt analysis and data reconciliations between various systems
• Finance business partnering including weekly reporting that provide offsite Regional Managers and Senior Management Team with pivotal information on actual performance against budgeted KPIs
• Maintenance, design and creation of reports from the accounting system
• Month end journal posting on accounts system
• Assisting with budget preparation and with building financial models for clients
• Data extraction from systems and analysis to provide the most relevant and resourceful information to business leaders and managers
• Various ad-hoc reporting upon request
• Winner of Team Spirit Awards 2015
Monthly reporting within Basel regulation
•Managing large volumes of data analysing all trends
•Interpret complex reports and regulations to provide simplified information to non financial stakeholders
•Reconcile the reporting system of the general ledger
•Timely consolidation and reporting of Basel III - Risk weighted Assets and Expected Losses information
•Carrying out controls and reconciliations to ensure that the output of the team adheres to the relevant Group Minimum Standards
Accurate and comprehensive review of Gross Profit of numerous contracts on a monthly basis identifying and correcting errors or omissions as appropriate.
•Preparation of monthly business unit reviews, detailing performance at Gross Profit, Overhead and Net Profit level, including a written review of key contracts and overhead expenditure against budget.
•Arranging monthly contract GP reviews with the Key Account Managers so that they are aware of how their business is performing and identifying any areas of concern to rectify.
•Preparation of service reports in formats required by customers to ensure accurate and timely invoicing.
•Identifying invoicing errors and liaising with members of the finance team to ensure corrective action is taken and improving accuracy within future reporting periods.
•Analysis of Work In Progress (WIP) and posting of WIP adjustment journals for clients in the portfolio.
Responsible for the subsidiary company, Tenovus Trading Ltd. (Subsidiary turnover > £200k, Tenovus charity profit - £1.3m)
•Preparation of monthly management accounts (P&Ls, Balance sheet and variance analysis) and submitting quarterly VAT returns for the trading company.
•Reporting sales and stock information in a timely manner to Head of Retail.
•Responsible for sales ledger, purchase ledger and stock system including posting of receipts, payment runs and stock adjustments and movements using the accounting software, Access Dimensions.
•Reconciliation of Intercompany accounts.
•Banking, BACS payment runs, prepayment reconciliations and posting of monthly journals.
•Responsible for Payroll for over 250 employees within the charity
•Processing of starter and leaver pay information along with changes to contracts using payroll software, Select Pay.
•Processing of overtime, statutory sick pay, sending/receiving and processing HMRC (tax) information (via Gateway and RTI) and payroll reconciliations.
•Variance analysis and producing payroll procedure compliance reports for HR Director and Director of Finance and Operations on a monthly basis and various other reports upon request.
Maintenance of donor database by keeping donor details up to date along with adding new donors on a weekly basis and entering donated goods' sales data on to Gift Aid database.
•Inputting weekly sales data into excel spreadsheet.
Payroll, staff/freelance expenses, purchase ledger, raising sales invoices and payments, petty cash & physical banking, fixed asset register.
Maintenance of the register by accepting those accounts that comply with the relevant Companies Act or rejecting them for relevant amendments to be made so that they comply with the Act before filing in house to be viewed by public.
Professional Accountancy Qualification - ACCA
courses: Association of Chartered Certified Accountants (ACCA)
Maths (A), Chemistry (B), Biology (B)
Physics, Chemistry, Biology, Maths, English, History, Geography, Hindi, Malayalam (534/600 marks)