Target Audience:

– Accountants who need to perform advanced accounting duties

– Accounting students/graduates who want to work for large listed firms

– Accounts Clerks in small to medium firms who are seeking to move to large organisations

 

Outline

Module 1  Listed Company Accounting Dep. Structure & Month End Check List

– Procedures involved in compiling financials

– Procedures involved in management reporting

– Reports involved in month end reporting

Module 2  SAP Exposure

– The link between SAP and Outlook

– Difference between ERP systems and accounting softwares

– General Ledger Overview in SAP

– Create GL Account in SAP

– Enter GL Document in SAP

– Reverse Document in SAP

– Search And Display Document in SAP

– Display Account Balances in SAP

– Display Account Line Items in SAP

– Park Document in SAP

– Post Parked Document in SAP

– Open And Close Posting Periods in SAP

– Balance Sheet And Profit & Loss Statement in SAP

– Cash Flow Statement in SAP

– Chart Of Account Report in SAP

Module 3  Forward Dated Invoices

– Detailed explanation for transactions occurring after AP/AR cut-off date

– Adjusting group consolidated sales and cost of sales to reflect forward dated transactions

– Basic margin analysis concept

Module 4 Sales Report, Inter-Co Sales & Sales Analysis

– Run Sales Report from SAP/In-house system

– Adjust Inter-Co sales and Inter-Co cost of sales

– Actual v Budget, Forecast v Actual and Budget v Forecast analysis

– Generate Flash Report to reflect sales fluctuations

– Perform business analysis report for senior sales management

Module 5  Stock Report and Analysis

– Run Stock Report from SAP/In-house system

– Set up Stock List, Use all Inventory related function in MYOB

– Important analytical methods for stock analysis, such as Stock Value, Stock Days, Turns and Margin

-Perform V-Look Up across and within sheet

– Generate Flash Report to catch trends in stock levels

– Incorporate stock analysis info and prepare business email for Warehouse manager

Module 6  Accruals

– Set up accrual pool

– Comparison of accrual practices for Listed companies and small/medium size companies

– Accruals and Take-Up-Accruals procedures

– Reconcile accrual account as part of General Ledger reconciliation

– Major Balance Sheet Items Reconciliation in Listed Company

Module 7  P&L Analysis, Company Internal Audit

– Use margin to analyze sales

– Use margin to audit company accounts

– Select samples for audit from company accounts

– Use variance report to analyze actual operation, price variance and manufacturing variance

– Use Flash Report to present cost info for senior management

– Provide feasible recommendations for senior management based on info extracted from analysis

Module 8  Consolidation

– Consolidation procedures for SAP/In-house system users

– Consolidation procedures for MYOB users

– Eliminate inter-co transactions, such as inter-co sales and inter-co loans

– Journal entries for dividend declared and payment

– Consolidate Balance Sheet and P&L for group

Module 9  Forecast

– Procedures of quarterly forecast for manufacturing company

– Design forecast templates for branches

– Liaise with branch managers to collect forecast info

– Consolidate forecast at national level

– Forecast v Budget, Forecast v Actual analysis

Module 10  Budget

– Procedures of yearly forecast for manufacturing company

– Design sales budget templates for branches

– Design expense budget templates for branches

– Assist with branch managers to generate budget info

– Payroll and capex budget

– Consolidate budget at a national level

– Work with large Excel spreadsheets

– Prepare and present budget to the Board

Module 11  Cash Flow

– Design daily and monthly cash flow templates

– Use cash flow to perform an insolvency test

– Use cash flow to perform a feasibility study

– Use Macro recording function for cash flow statements

– Use Visual Basic Editor for cash flow statements