This was my second year in the finance industry and I completed a rotation at Enfield Council, where I carried out complex tasks efficiently in several finance roles and departments:
Treasury Team (5 months):
- Gained a detailed understanding of the treasury management function in the London Borough of Enfield with specific focus on both long-term and short-term borrowing.
- Was responsible for the recording and processing of the daily expenditure using software systems such as SAP, Stripe, Bottomline PTX, Global Pay, World Pay and HSBCnet.
- Posted journals on SAP as part of the expenditure management process for approval by the Treasury manager.
As part of my placement in the Treasury Department I was heavily involved in a project that examined the borrowing costs as these were increasing and assist in their decrease. As part of this project I successfully fulfilled the following responsibilities:
- Help prepare and format the Excel spreadsheet containing invoice details that would be used for the project, having sole responsibility for successfully preparing the data for 7 areas of the Council.
- Use both SAP and ASH software systems to collect, extract and then present invoicing data to the relevant Heads of Service.
- Accurately analysed the collected data to quantify the delay in raising the invoices in question, using an estimated invoice raised date. The delays identified ranged between 5 days and 167 days.
- Liaised with various Enfield Council employees, including both Heads of Service and Finance Directors, setting up and taking the lead in meetings to make detailed inquiries regarding the invoicing delay.
- Challenging the responses received to obtain an accurate answer regarding the number of days in which the invoice raising process was delayed.
- Inputting the collected data into the Excel dataset to quantify the total cost of the delays, and using the provided formulas to calculate this cost.
- Presented the financial data to the Treasury Manager to be used for further action in re-designing the invoicing process to reduce total borrowing costs in then future.
Capital and Projects Team (7 months):
- Gained knowledge regarding the Capital side of financial management by initially shadowing senior colleagues in their day to day tasks.
- Worked on the Master Capital Programme that contained all financial data related to all the capital projects carried out by Enfield Council, inputting new data extracted from SAP.
- Took up the business partner role for minor areas covered by the programme to assist the senior finance business partner.
- Assisted in the preparation of service specific budget reports, that included the expenditure figures recorded in the Master Capital Programme which would be sent to budget holders prior to monthly budget review meetings.
- Communicated with budget holders to accurately identify problems with both the recorded budget figures and expected expenditure and communicated them to the Senior Finance Business Partner in a timely manner.
- Challenged expenditure commitments to collect detailed comments to identify problems that might impede project progress to accurately record the estimated future expenditure.
- Downloaded monthly transactions that were recorded in SAP and entered them into the Master Capital Programme following the established data format to ensure the data-set was up to date.
- Carried out substantive procedures on invoices over £100,000 to ensure that the correct purchase order was used and that they were charged to the appropriate cost centre.
- Assisted the Head of Finance in the review of the Q1 cabinet report preparation of the Q2 cabinet report by liaising with budget holders to collect detailed comments regarding the status of projects for the Environment and Communities area.
- Gained exposure to variance analysis.
- Improved Excel skills and became proficient with the SAP software system.
During my time in the Capital Team I was tasked with the financial aspect of two business cases for to construction projects where I reported directly to the Head of Finance who reviewed my work:
- I accurately completed feasibility study DP/1 forms for both projects having a provisional cost of £2.7 million and £1.5 million respectively, contacting Project Managers and Heads of Service to challenge the precision of the estimated costs.
- Efficiently completed 2 investment appraisal DP/2 forms including the NPV for both projects to the deadline required.
- Successfully made a recommendation based on previous historical data for similar construction projects to raise the contingency from 10% to 20%, which resulted in a final agreed contingency of 17%.
- Made a recommendation to change the wording used in the classification of costs that would help secure funding for the project.
- Accurately spotted an unnecessary cost that saved the project an estimated £30,000 that was successfully reinvested in other areas.
- Proofread the draft of both business cases giving specific importance to the financial sections to assure accuracy.