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