Models for Month-end & Reconciliationweekend 11th & 12th June 2016 Melbourne
weekend 3rd & 4th December 2016 Melbourne
This practical course would allow you to further sharpen your Excel Modelling Skills to build your own financial models. As a graduator, you will be able to create your own Excel based financial models to satisfy different business needs.
Key Modules Covered in the Course
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 VBAData Organization Techniques
- Pivot without Pivot Table- Summarize Data according to multiple conditionsModelling Procedures
- Starting point of Modelling- Format requirements for data input- Data analysis with different perspectives- Dynamic elements – customised (interactive) report- Documentation requirementsMonth – End Procedure & Models
- 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 categoriesData Reconciliation Skills
- Same structure data Reconciliation- Different structure data reconciliation- Speak cell & ReconciliationAccounts Reconciliation
- Definition of Reconciliation and why we need it- 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
报名与咨询方式:
