PLEASE CLICK HERE to view upcoming event. Information here is outdated

Financial Accounting, Fast Closing & Financial Reporting

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

IPA Training is Registered with

Venue Details

Remote Online Training - Public


Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

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