Michael Hack
Systems Accountant at Capita Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Credentials
-
ACCA
-
Experience
-
Capita Group
-
United Kingdom
-
1 - 100 Employee
-
Systems Accountant
-
Aug 2013 - Present
• Axiom Administrator which involves updating user security, maintaining tables, reports and plan files, testing new updates and resolving server issues.• Implementation of several projects from start to finish.• Providing end users with written documentation and training videos to demonstrate how to use the developed systems.• Ensuring financial systems adhere to internal controls • Report development using SQL queries. • Creating ad hoc Excel tools using VBA to automate several processes.• Resolving and providing resolutions to queries raised on Capita’s internal query logging system in a timely manner. Achievements• Developed the Working Capital process within Axiom to significantly enhance the functionality to hundreds of users across the Group. - This has included additional reporting, ease of access and automation of the process.- Integrates data directly from SAP into Axiom ensuring the data available to the end user is always up-to-date.• Continued development of the Prepayment process started in Management Accounts.- Transitioned the Prepayment process into Axiom to allow more dynamic processing.- Users are now able to use data updated daily from SAP.- Journals can be processed intermittently throughout the reporting period • Ad Hoc Excel tools include: - Method of populating the debtor information on the month end reporting packs which has saved over 2 days of manual processing per month.- Authorisation lookup tool which instantly cross references over 4000 cost centres against 100s of approvers to identify correct line manager for the query approval process. This is now used by the entire 1st line query support team.- New Cost Centre form which is available on the Group intranet. Several checks built in to validate and ensure all fields correctly populated.- SQL string generator to produce necessary user security access strings quickly and accurately and also validate against the live cost centre structure. Show less
-
-
Management Accountant
-
May 2009 - Aug 2013
• Produced the working capital report across 10 divisions within the Group.• Distribution of the working capital report to business partners across the Group and board members. Explaining results and variances of the report to all stakeholders.• Management accounts for 7 of Capita Groups legal entities.• Managing the fixed assets, prepayments, deferred income & balance sheet reconciliations for these entities.• Production of accurate 18 month cashflow forecasts.• Variance analysis of actual profit against business plan forecasts.• Reporting at half year and year end.• Ad hoc systems tasks including content editor for Finance section of Group Intranet & producing reports using Business Warehouse – a data warehouse reporting tool.Achievements• Contributed to the implementation of an incentive scheme to encourage divisional finance directors to improve their working capital position and charge those whose position has worsened year on year. This has had a significant benefit to the cash flow position of the group. • Implemented automated system to consolidate the Cash Flow forecasts of over 100 of Capita’s subsidiaries saving the department two days of manual processing per month.• Devised a tool to link Prepayment and Deferred Income release schedules on Excel to the SAP accounting system which allows journals to be created automatically and uploaded efficiently and accurately.• Created a program to accumulate Trade Debtor information from over 100 separate reports to produce Group Debtor report, eliminating a manual process which took a day to complete.• Created a Fixed Asset posting tool which assigns GL codes to non-capital elements to ensure consistency when posting these items to the Profit and Loss account. Show less
-
-
Community
