?高阶财会系列培训六月——Models for Month-end & Reconciliation 课程梗概

<- 分享“Seed职业培训”微信公众号到您的社交圈,让更多的人知道!

收藏文章 赞一个 已赞 2016-06-03 Seed职业培训



Models for Month-end & Reconciliation

weekend 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 VBA

Data Organization Techniques


- Sort without Sort
- Filter without Filter
- Pivot without Pivot Table
- Summarize Data according to multiple conditions
- Dynamic data range

Modelling Procedures


- Starting point of Modelling
- Format requirements for data input
- Data analysis with different perspectives
- Dynamic elements – customised (interactive) report
- Documentation requirements

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

Data Reconciliation Skills 


- Same structure data Reconciliation
- Different structure data reconciliation
- Speak cell & Reconciliation

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
过往学员反馈:



报名与咨询方式:




点击展开全文