Closing Month End Best Practice

This course outlines the typical month end processing timetable, responsibilities and tasks which need to be undertaken to transform the financial information from the trial balance to key financial reports. The tasks will include:- Tracing the financial data from the input systems of AP, AR, Fixed Assets and Payroll to the General Ledger Typical accrual, prepayment and provision journal entry models will be outlined including revenue, OPEX, and various adjustments.Templates, sample working papers and Excel models will illustrate the organization and workflow of the closing process.

GL Standing Journals

BEST PRACTICE
OF MONTH END
CLOSING PROCEDURES

Closing Month End Best Practice

What the best accountant do differently ?

This course outlines the typical month end processing timetable, responsibilities and tasks which need to be undertaken to transform the financial information from the trial balance to key financial reports.
The tasks will include:- Tracing the financial data from the input systems of AP, AR, Fixed Assets and Payroll to the General Ledger Typical accrual, prepayment and provision journal entry models will be outlined including revenue, OPEX, and various adjustments.Templates, sample working papers and Excel models will illustrate the organization and workflow of the closing process.

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.

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

Steps  :Reversing Journal In ERP Policy
Model: Quarterly Automatic Calculation  Model

Steps : Bad debt write-off  and recover journal

Model : Percentage of Sales & Percentage of Receivables

Steps :Cooperate with Accounts Payable
Model : Amortization Calculation Model

Steps :Collect the payroll reports from HR
Model : Transform the activity report to Journal

Steps :Approximate Match method

Model: Multiple Location and dimension calculation

Comments from past students

Our Services

SAP-ERP

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:
90%
Installation of SAP-ERP in your PC :
85%
Best Practice of Australia listed companies :
80%
Entry Level Power BI Modelling Skills:
67%
All year round 24 hours CPD Certification:
50%

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.

Closing Month End

  • Case 1:Utitlies Expense Accrual Journal

Steps  :Reversing Journal In ERP Policy
Model: Quarterly Automatic Calculation  Model

  • Case 2: Cost Allocation Time-saving journal

Steps  : How to design the data collection form
Model:Unpivot Journal Preparation Model

  • Case 3: Contractors' time sheet Accrual

Steps  : Deal with operation log book record
Model: Roaster Shift Scenario Calculation Model

  • Case 4:Prepayment Amortization Journal

Steps :Cooperate with Accounts Payable
Model : Amortization Calculation Model

  • Case 5: Sales Commission Automation Journal

Steps :Multi-Dimension data collection
Model :  Sales Commission Auto Calculation Model

  • Case 6: Payroll Standing Journal

Steps :Collect the payroll reports from HR
Model : Transform the activity report to Journal

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.