consolidating financial statements

Hunter Jiang

IFA Australia Founder
Senior Group Financial Controller

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

Financial Statement Consolidation

Fundamentals of consol:

Accounting principles Group structure Consolidation platform ( systems vs worksheets ) Reporting process & related roles

Cost Allocations

includes an Allocation Management, with a simple, user-friendly model that facilitates the creation of balanced allocations.

Multiple Worksheet Consol

Steps: consolidate P&L reports from different departments
Model: multiple worksheet consolidation

Time Dimension Consol

Steps: Recognise the lookup table between month and fortnight
Model: Fortnight to month consolidation

Benchmark Qrtly Consol

Steps: How to deal with reports with different formats
Model: Industry Level Benchmark Model

Case Study

Over 200 Corporate real case studies


Apply industry benchmark level best practices


Combine working knowledge and Excel skills

Global business structure

Listed in ASX. Holding company located in Australia Global wise operational structure. Markets cover APAC , North America and EU

Inter-company Transaction

The Elimination Rules ensures that eliminations are always in balance, and provides visual cues when eliminations or rules need attention.

Multiple Currencies

Manages the use of multiple currencies in planning, integrating data from other systems, and reporting, with automatic currency conversion.

Minority Interest

Quickly define consolidation percentages using a simple, user-friendly interface Perform what-if scenario analysis of changes in ownership interest

Consolidating P&L

Achieve faster and more accurate and transparent close and report cycles Improve visibility, audit, and control during financial consolidations

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.

Free Resume Edit

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

Michele Meng
Financial Accountant

“The course had a fresh approach and was very interesting. The case studies and readings were excellent. The presenter was engaging.”

Financial Closing Course

Christina Li
Financial Accountant, Retail Industry

“The 3 courses around month end ( Month End Closing, Balance Sheet Reconciliations, P&L Review) are fantastic. They provide very practical steps for the work for the first 2 weeks of the month. This is training that is not really available elsewhere and usually has to be passed on by the senior members of the team.”

Financial Analyst , Government

“The course was amazing with lots of practical examples and classroom exercises. I learned a lot od new techniques and I am looking forward to impressing my boss next week.”


The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who do use Excel on a regular basis, and are comfortable with using its tools and functions. At minimum, it is assumed that participants will know how to: Navigate confidently in Excel Use absolute cell references (e.g. =$A$1) Create and use advanced Excel tools and functions on a regular basis

Excel Version

Public courses are run in classroom set-up without workstations provided. Participants must bring their own laptops . The course is demonstrated using Microsoft Excel 2016, but participants can use Excel 2007 or 2010 if they prefer. Course materials contain instructions for different versions, and Excel 2011 for Mac users are also catered for. Those who would like to use a Mac are most welcome to bring their own laptops but not preferred.

ERP Installation

Public courses are run in classroom set-up without workstations provided. Participants must bring their own laptops . The operation part of the course is demonstrated using fortune 500 global business ERP system , the participants can use their window system to install the interface so they can experience the real word working environment . Those who would like to use a Mac can not install the interface.

Our Customers

Visit us

Level 5 ,251-253 Elizabeth Street, Sydney NSW 200

Call us

+61 499 180 115

Contact us