Year End Closing

This course outlines the various reconciliations that need to take place between the various financial modules, General Ledger and external data such as the bank statements to ensure the completeness, accuracy and validity of financial information. Reconciliations are a fundamental element of risk management and accounting control especially around bank, wages, suspense, and assets under construction. The organization and presentation of reconciliations, working papers, Excel models, and the escalation / approval process will be addressed.

Mr. Jiang  has designed and delivered many practical hands-on step by step training courses to accelerate the acquisition of financial management skills. As well as identifying key financial concepts in budgeting, reporting and analysis, he supports this knowledge with many simple and sophisticated Excel models. He also has the ability to access complex BI and reporting tools and make them come alive in common sense ways which can be replicated by the learner back in the office environment.

This course is part of the Financial Closing Package:

  • GL Standing Journals
  • Month End Procedures
  • Balance Sheet Reconciliation
  • Year End Closing
  • Excel Data Modelling
  • Power BI Data Manipulation

This course is part of the Financial Closing Package:

  • Graduate Accountant
  • Accounts Payable
  • Accounts Receivable
  • Payroll Officer
  • Accounts Clerk/Office
  • Accounts Al-rounder
  • Small Firm Accountant
  • Small Company Accountants

Public courses are run in our training room without workstations provided. Participants need bring their own laptops.   The course is demonstrated using Microsoft Excel 2016, but participants can use Excel 2007, 2010 or 2013 if they prefer.  Course materials contain instructions for different versions, and Excel 2011 for Mac users are also catered for. But window system will be needed if you attending SAP-ERP tutorials.

Contact us now !

  • This field is for validation purposes and should be left unchanged.

Scan the QR code to book your first face to face Free Trial Now !!!

  • Steps : Investment Account Policy & Procedures 
  • Model: Investment Account Reconciliation Model
  • Steps : GST Account Control 
  • Model: ATO and GST Auto Reconciliation Model
  • Steps : Flow chart methods to understand the procedures
  • Model: FBT Year end adjustment and reconciliation

  • Steps : Expense Capitalization 
  • Model: Assets under construction Model
  • Steps : Year End Accounts Reconciliation Procedures 
  • Model: Year End Accounts Reconciliation Check List

Comments from past students

Our Services


Experience the real-life working environment in ERP system . Apply industry benchmark level best practices

Excel Modelling

Combine working knowledge and Excel skills . Apply industry benchmark level best practices

BI Modelling

Over 200 Corporate and listed company real case studies . Apply industry benchmark level best practices

Medium to Advanced Level Excel Modelling Skills:
Installation of SAP-ERP in your PC :
Best Practice of Australia listed companies :
Entry Level Power BI Modelling Skills:
All year round 24 hours CPD Certification:

In This Class You'll Get to...

Free Consulting

Our experienced consultant's will help you identify the skill gaps for your next move.

CPD Certificate

A formal company letter will be issued to you after class to help you claim your CPD hours.

Resume Edit

Our experienced consultant's will help you edit your resume before you apply for the target role.