Models for Month-end & Reconciliation

Duration: 2 days
Workshops:  03-04 Feb 2018 Sydney & Melbourne
            16-17 Jun 2018 Sydney & Melbourne
            11-12 Aug 2018 Sydney & Melbourne
            29-30 Sep 2018 Brisbane
            24-25 Nov 2018 Sydney & Melbourne

This practical course would allow 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 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

29 Comments

  1. Enjoyed Terry’s workshops so much! I found it very useful and eyes opening experience! I definitely recommend the workshops!

  2. I like the course as it consolidated the end of month process and the models are very handy. Terry is excellent! Thanks.

  3. 非常有用的课程!信息量大 ,老师教的很细致。学到了非常多有用的财务知识,立马能在工作中用到。两天的课程觉得比我在工作一年中学习的还要多,报Terry老师的课真的是最正确的选择!

  4. Month end的课特别实用,全部都是工作中会遇到的情况,梳理之后感觉逻辑清晰了很多。给Terry老师疯狂打call~

  5. 满满内容的两天,需要回来好好消化下。我不是财务专业的,所以两天下来觉得财务水很深,但是Terry老师能把这么深的水给提纯出精华,让我们短期内迅速提升,觉得真是不虚此行!推荐!

  6. Good strucutre of the course, the improvement point could be updating all the relevant computer softwares in the classroom.

  7. Hi there,

    just want to check whether there is any face to face training for the Month end training in Nov in Melbourne?

  8. Hi, I would like to find out the cost for this course please. Is this an entry level course or advanced course? Is it conducted in English? I am a CPA accountant and have recently returned to work in management/financial accounting field, will this course be suitable for me? Thank you.

  9. 谢谢Terry 提供重听的机会,能让我温故知新,并且每次上课都会有不一样的收获,很实用!

  10. 课程结构设置合理,环环相扣,容易理解。会计原理配合模型,模版可以直接在工作中使用,大大提高了工作效率,节省了工作量,很受益于该课程,谢谢!

  11. 非常有调理,细节也不错。挺不错的课程。适合有一定经验的人,基本能跟上。谢谢老师耐心的讲解。

  12. 这次重听terry老师课程温故而知新,尤其是增加了部分内容,开阔了思路。还要感谢terry的是这次课程内容有部分吸取我上次的反馈并做了更新。大家一定要积极认真的给出反馈,因为下次再听的时候真的会有新发现。

  13. Easy to understand, help us to master pratical&useful excel skills, build up confidence to undertake challenge in the work

  14. 挺不錯的,但如果能上課之前先上個excel效果可能會更好,或者能知道準備用什麼公式先預習一下

Leave a Reply

Your email address will not be published. Required fields are marked *