Financial Accounting, Fast Closing & Financial Reporting

26-27 Jan, 2022, Remote Online Training - Public

IPA Training is Registered with

Learn from the Best

Dr Steven Liew is a fellow member of the Chartered Institute of Management Accountants, UK and is a Chartered Accountant by profession. He has an Asia Pacific Executive MBA (for senior executives) from the National University of Singapore and a PhD in international finance with Rushmore University of USA.

 

 

Dr Liew had worked in private sector companies, ranging from family-run businesses to professionally manage multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 30 years working experience in senior financial & operational management positions spearheading the profitability and growth of companies. He has worked for the MBF Finance & its related group of companies over the 10 years period

 

 

He is a registered Trainer with the Government Human Resources Development Berhad (Pembangunan Sumber Manusia Berhad). And he is a GST Tax Consultant and had successfully completed the Custom examination

 

 

Dr Steven Liew had conducted various seminars for corporate clientele including Association of Credit Management Malaysia, Chartered Institute of Management Accountants, Malaysia Institute of Management, Malaysia Institute of Accountants, Institute of Bank Bank Malaysia, Nestle, IQPC Worldwide Pte Ltd , Singapore, Lexis Nexis,, Proton Edar Malaysia , Brunei Investment Agency, Small Medium Industries Development Corporation , Ministry of Development, Brunei , BICPA Asean Management, Brunei, Risda Group Of Companies, Sales & Marketing Training Forum, Sri Lanka, Giant Retail Sdn Bhd, Telekom Brunei & Ministry of Foreign Affairs, Malaysia, Sabah Electricity Sdn Bhd, Bank Islam Brunei Darussalam. Continental Tyres, Sime Darby Bhd ,Sony Malaysia Sdn Bhd , Perodua Sdn Bhd & Credit Guarantee Corporation (M) Bhd; Fujixerox, UDA Holdings, SPNB, Diners Club, Elk Desa Capital Bhd, Antah Schindler, UCSI & Ministry of Finance; Seccom Sdn Bhd; Bridgestone Chemical Products (M) sdn Bhd; Dialog Group Bhd; SEDCO, KK ; Hosiden Electronics (M) Sdn Bhd; STO Maldives; Indah Water Consortium Sdn Bhd; CPA Australia (M) Sdn Bhd

 

 

He is currently providing management consultancy and training specializing in Fast closing monthly, leadership, Strategic Planning, Sales Management, budgeting, accounting, finance, Cost reduction, credit management & loan recovery.

Venue Details

Remote Online Training - Public

Contact us

Juliany,
M - 012 2281 247
juliany@ipa.com.my

Phoebe,
M - 019 363 7822
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Yvonne,
M - 012 201 1247
yvonne@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Managing P&L & Cash Flow (Simulation Exercise)
  • Module 2: Improve Cash Flow & Profitability Position (Practical Case Study)
  • Module 3: Recording and Analysing Business Transactions
  • Module 4: Preparation of Final Accounts
  • Module 5: Financial Ratios Analysis
  • Module 6: Understanding Fast Closing
  • Module 7: Fast Closing Discussion
  • Module 8: Discussion on Account Payable
  • Module 9: Financial Reporting- Getting Data
  • Module 10: Application of Power BI (Case Study)

SPECIAL FEATURE: Participants Will Receive a Set
of Practical Templates suitable for all sectors.

OBJECTIVES

The primary goal of this course is to help professionals who have knowledge in finance and accounting in developing sound financial knowledge to read and understand financial reports.

Participants are required to prepare a full set of accounts i.e., preparation of journals, posting to ledger, preparation of trial balance, prepare month-end adjustments, prepare income statement and balance sheet. This course will help you to close the account faster & be more effective.

Access the information you need when you need it through visually stunning dashboards and reports. Learn how to analyze and display data using Power Business Intelligent make better, more data-driven decisions


 

WHO SHOULD ATTEND

Accounts Executive, Senior Account Executives, Supervisors, Account Assistants and All Professionals who are interested in Financial Accounting, Fast Closing & Financial Reporting

METHODOLOGY
Case Study & Group Discussion. Real-Current Issues & Cases Will Be Analyzed And Scenario Solutions Will Be Discussed Within The Course.
DAY 1
9:00

MODULE 1: MANAGING P&L & CASH FLOW (SIMULATION EXERCISE)
Objective:

  • with little or zero accounting knowledge, will walk you through Your business or new business on sales, purchases, operating expenses, investment, capital injection, depreciation & interest payment
  • you see your own P&L, Balance sheet, cash flow & equity
  • provide strategies (using goal seek) to improve your cash flow & P&L position
10:45

MODULE 2: IMPROVE CASH FLOW & PROFITABILITY POSITION (PRACTICAL CASE STUDY)
Objective: Use financial tools of goal seek & solver to meet management target of sales, profit & cash flow position

  • Applying what if analysis (goal seek & solver)
  • Applying profitability strategy management framework
    - Formulation stage
    - Execution stage
    - Evaluation stage
 
12:00

MODULE 3: RECORDING AND ANALYSING BUSINESS TRANSACTIONS

  • Understanding Main Books of Accounting System for any type of Business Operations
  • Journal, Ledger and Source Documents
  • Ensuring Relevant Supporting Documents for Accounting Transactions
  • Books of Original Entries – Types of Journals and Cash Book
  • Ledger System – General Ledgers, Subsidiary Ledgers – Posting into Ledgers
  • Proper Classification of Expenses to Avoid problems with Tax Authorities
1:00 Lunch
2:00

MODULE 4: PREPARATION OF FINAL ACCOUNTS

  • Balancing Accounts and preparing Trial Balance to ensure accuracy of double entry system
  • Detectable / Non-Detectable Errors
  • Trading Accounts / Profit & Loss Accounts / The Financial Position
  • Final Accounts with Adjustment
  • The closures of books and transfer of balances to next financial year
  • Dealing with Bad / Doubtful Debts / Provisions, etc
3:45

MODULE 5: FINANCIAL RATIOS ANALYSIS  

  • Learn how to size up a company quickly by reading their financial ratios
  • Liquidity
  • Solvency
  • Efficiency
  • Profitability
  • Asset Management
  • Assessing drivers of company profitability and growth: -
  • Operations and investment strategies: operating and investment management
5:00 End of Course
DAY 2
9:00

MODULE 6: UNDERSTANDING FAST CLOSING 

  • Fast closing definition
  • Benefits of fast closing
10:45

MODULE 7: FAST CLOSING DISCUSSION 

  • Discuss on how to shorter the month end closing
  • Discussion on systematic way of closing the accounts
  • How to do minimum adjustments to closing of accounts
  • Discuss ways to redesign a simple finance accounting cycle
  • How finance division can be more proactive in terms of budgeting, Forecasting & advisory role
  • Discuss ways to control & manage the cash flow
 
12:00

MODULE 8: DISCUSSION ON ACCOUNT PAYABLE

  • Timely payment due incomplete documents
  • Received invoices late from vendor/outlets
  • PO not stated on the invoice
  • Timely closing of AP/accruals
  • PO issued but invoice never reached AP.
  • Cancellation of PO was never informed.
  • Changes in price quoted was not informed
  • Invoices do not issue/received
1:00 Lunch
2:00

Module 9: FINANCIAL REPORTING- GETTING DATA

  • Available data sources in Power BI Desktop
  • Connecting to data sources
  • Get Data from Folder
    - Handling multiple worksheets
  • Get Data from CSV file
 
3:45

MODULE 10: APPLICATION OF POWER BI (CASE STUDY)

  • Sales performance
  • Web application
  • Profit by date
  • Unit Sold by Each Country/state
  • Profit by product
5:00 End of Course