Act vs Bud Variance Reporting

Case Study

Over 200 Corporate real case studies

Procedures

Apply industry benchmark level best practices

Modelling

Combine working knowledge and Excel skills

COA Dimensions & Hierarchy

Steps: Dimensions & Hierarchy Definition Procedures Model: P&L Dimensions & Hierarchy Analysis

Volume & Rate Variance

Steps:One Product Line & Mixed Line analysing
Model: Variance Substitution Method

Sales Variance Analysis

Steps:By Product , customer and product mix analysing
Model: Multi-dimension Analysing Method

Standard Costing Analysis

Steps:Core business Processing analysing
Model: R2R Variance Analysing Method

Category Variance Analysis

Steps:Actual Wrong or Buget Wrong
Model: Vertical & horizontal Analysing Method

OPEX Variance Analysis

Steps:Operating Expense checking procedures
Model: Cross-line Variance checking Model

Dynamic Control & Fomatting

Steps: Dynamic Elements Editing Methods
Model: How to highlight the variance automatically

Time Variance Analysis

Steps: Recognize timing in variance analysis
Model: MTD & YTD variance Analysis

S&W adjustment Journal

Steps: Recognize incentives & termination
Model: S&W variance Analysis method

2D Variance checking table

Steps: Recognize the variance from 2 dimensions
Model: 2D variance Analysing Model

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
Healthcare

“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.”

Prerequisites

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