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


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

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

  3. 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.

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

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

Leave a Reply