Models for Month-end and Reconciliation
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Contact Us
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

ABOUT THE COURSE

*The course will be delivered in Mandarin (中文授课). This practical course allows you to further sharpen your Excel Modelling Skills to build your own financial models. After completing this course, you will be able to create your own Excel-based financial models to complete different business needs.

UNITS

Module 1 Advanced Techniques in Financial Modelling

  • Rebuild An Inherited Model
  • Break A Complex Model into Several Sub-models for Model Auditing
  • Automation: Record, Modify and Run VBA

Module 2 Data Organisation Techniques

  • Sort without Sort
  • Filter without Filter
  • Pivot without Pivot Table
  • Summarize Data According to Multiple Conditions
  • Dynamic Data Range

Module 3 Modelling Procedures

  • Starting Point of Modelling
  • Format Requirements for Data Input
  • Data Analysis with Different Perspectives
  • Dynamic Elements – Customised (Interactive) Report
  • Documentation Requirements

Module 4 Month – End Procedure & Models

  • Month – End Procedure
  • Case Study: Month – End Closing Checklist
  • Accounts Receivable Closing Procedure
  • Case Study: Commission Calculator (Based on Market, Product and Sales Amount)
  • Accounts Payable Closing Procedure
  • Case Study: Streamline the Process of Accrued Expense (Creditor Management – Accrued Expense)
  • Case Study: Creditor Management – Prepayment
  • Case Study: Amortisation Recognition – Prepayment
  • Payroll Closing Procedure
  • Case Study: Payroll Interface & Payroll General Journal
  • Fixed Asset Closing Procedure
  • Case Study: Depreciation Calculator with Variety Asset Categories

Module 5 Data Reconciliation Skills

  • Same Structure Data Reconciliation
  • Different Structure Data Reconciliation
  • Speak Cell & Reconciliation

Module 6 Accounts Reconciliation

  • Definition of Reconciliation and Why We Need It
  • Reconciliation Issues
  • Best Practices in Preparing Accounts Reconciliations
  • Differences Between Bank Statement and Cash Accounts Ledger
  • Case Study: Bank Reconciliation
  • General Ledger to Sub-Ledger Reconciliation
  • Case Study: Use Multi-data Source Pivot for GL Reconciliation
  • Case Study: General Ledger Reconciliation Model
  • Case Study: Annual Leave Liability Calculation
  • Case Study: Long Service Leave Provision Calculation
  • Case Study: BAS Report Template

UPON COMPLETION

This course is eligible for CPD hours.

CAREER OPPORTUNITIES

  • Financial Modeller
  • Financial Accountant
  • Senior Accountant

DURATION

2 days
* Please contact us for the timetable.

FINANCE OPTIONS

FINANCE OPTIONS

Fees must be paid within 5 working days of receiving the confirmation of enrolment and invoice for the enrolment fee.

Seed Training Group may cancel an enrolment or discontinue training if fees are not paid as required.

Both direct deposit and credit card are accepted.

*Please refer to the Student Information Handbook for further details regarding Fees & Refund Policy and Procedure.

Trainer’s Profile

  • 17 Years of Dedicated Best-Practice Financial Modeller Extensive Experience in Building & Reviewing Complex Financial Model
  • Experienced Financial Controller of an ASX listed companies
  • Managing Director of AFMA (Australian Financial Modeller Association)
  • Committee Member of ACAA (Association of Chinese Accountants Australia)
  • Special Guest Trainer of ABC Television (Australian Broadcasting Corporation)
  • Guest BI (Business Intelligence) Lecturer of CPA Australia
  • Lecturer of Shanghai University of Finance and Economics MBA
  • Experienced Financial Analyst and Financial Modeller
TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Call Me Back