As an Accounts Executive intern, you will play a crucial role in supporting our finance team in managing financial transactions and ensuring accurate record-keeping. This is an excellent opportunity for a motivated individual to gain hands-on experience in budget management, financial analysis, and forecasting within a dynamic and supportive work environment while developing essential skills in accounting and finance.
Roles & Responsibilities
Budget Management:
· Develop and prepare detailed part schedules for budgeting purposes.
· Facilitate the distribution of budget templates across departments and consolidate inputs.
· Utilize VLOOKUP function to align data with BC downloads and ensure accuracy.
· Consolidate budget inputs from departments for a cohesive overview.
· Break down sales budget into monthly segments and integrate them into the master spreadsheet for comprehensive analysis.
Year-End Financial Operations Support:
· Thoroughly examine intercompany transactions, including receivables, payables, and other financial components to ensure financial stability.
· Assist in the implementation of group consolidation packages to ensure financial transparency and compliance.
· Contribute to the preparation of all balance sheet schedules to maintain accurate financial records.
Forecasting for Quarters 3 and 4:
· Design and create forecast templates to facilitate accurate financial projections.
· Link sales and cost of sales to the main forecast for seamless integration.
· Integrate actual financial data into the forecast template to enhance forecasting precision and reliability.
Research and Administrative Assistance:
· Assist in conducting research and gathering financial data as needed to support decision-making processes.
· Provide support in ad hoc financial tasks and administrative duties to facilitate smooth operations.
Requirements
· Currently a final year student pursuing a Degree in Finance, Accountancy, or a related field.
· 6-month availability (Aug 2024 to Feb 2025, or depending on schedule).
· Knowledge of Microsoft Office (Words, Excel, PowerPoint) or G-suite apps (Docs, Sheets, Slides).
· Possess a positive attitude, good interpersonal skills, and a team player.
· A self-motivated and internally driven individual with quality improvement attributes, and good analytical and problem-solving skills.