Chelsea Li
Zetland,NSW
Summary
Dynamic Assistant Accountant with a proven track record at the Sydney Institute of Higher Education, excelling in financial modeling and reporting, and supporting the auditing process. Proficient in Power BI, SQL, and Excel, enhanced strategic decision-making through data-driven insights.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Assistant Accountant
Sydney Institute of Higher Education PTY LTD
Sydney, NSW
03.2023 - Current
- Developed Monthly Sales Reports: Consolidated data from multiple platforms to monitor key financial indicators—such as cash flow movements, cost-to-revenue ratios, and profit margins—and non-financial metrics, including CoE issuance, status changes, and visa refusal rates.
- Revenue Recognition & Visualization: Recognized quarterly revenue and created detailed Power BI dashboards to illustrate revenue distribution across various countries, programs, and agents, supporting strategic market decisions and agent tier evaluations.
- Financial Statement Preparation & Audit Support: Assisted in preparing FY2023 and FY2024 financial statements, including cash flow statements, and detailed notes on Property, Plant, and Equipment (PPE), Right of Use Assets, Related Party Transactions, and Sensitivity Analysis. Collaborated with external auditors to resolve inquiries, and ensure audit readiness.
- Account Reconciliation & Daily Financial Operations: Conducted reconciliations for multiple accounts—such as suspense, income, and insurance accounts—utilizing advanced Excel functions (LOOKUP, Power Query). Managed daily bank reconciliations, processed bills, and executed unscheduled pay runs using Xero.
Analysis Intern
Deloitte Consulting (Shanghai) Co. Ltd
Beijing, China
07.2020 - 08.2025
- Conducted basic quantitative financial analysis by building Excel models to project cash flows and evaluate key valuation metrics for both acquirer and target companies. Assisted in sensitivity analyses to understand how changes in growth assumptions impacted forecasted performance.
Education
Master of Commerce - Business Analytics
University of New South Wales
Sydney, NSW09-2024
Master of Finance - Financial Analysis
University of New South Wales
Sydney, NSW09-2023
Skills
- Account reconciliation specialist
- Revenue recognition
- Financial modeling and reporting
- IFRS knowledge
- Power BI visualization
- SQL and Microsoft Excel
Certification
- ACCA (Association of Chartered Certified Accountants) – Passed 12 out of 13 Exams
- Xero Advisor and Payroll Certified
- Goldman Sachs Excel Skills for Business Certified
- Securities Investment Advisory Business Qualification
Timeline
Assistant Accountant
Sydney Institute of Higher Education PTY LTD
03.2023 - Current
Analysis Intern
Deloitte Consulting (Shanghai) Co. Ltd
07.2020 - 08.2025
Master of Commerce - Business Analytics
University of New South Wales
Master of Finance - Financial Analysis
University of New South Wales
Similar Profiles
Samuel Nche Trupeah DeemiSamuel Nche Trupeah Deemi
HND/SRN Practical Examiner at Ministry of Higher Education/ Full Gospel Higher institute of Health and Biomedical ScienceHND/SRN Practical Examiner at Ministry of Higher Education/ Full Gospel Higher institute of Health and Biomedical Science
Ishrat SiddiqueIshrat Siddique
Head of Student Affairs and Registrar at Sydney Metropolitan Institute of Technology Pty Ltd [Trading as Sydney Met]Head of Student Affairs and Registrar at Sydney Metropolitan Institute of Technology Pty Ltd [Trading as Sydney Met]
Fang ShiFang Shi
Casual Lecturer at Southern Cross Education Institute Higher EducationCasual Lecturer at Southern Cross Education Institute Higher Education