Debt Collection System & Financial Reporting

25-26 Oct, 2021, Virtual Classroom Training

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 Malaysia, Nestle, IQPC Worldwide Pte Ltd , Singapore, Lexis Nexis,, Proton Edar Malaysia , Brunei Investment Agency, Small Medium Industries Development Corporation, Asia Business Forum Pte Ltd, Hong Kong, 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, SYNERGY RMS PTE LTD, India; 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 & VMAC Business Group (M) Sdn Bhd, China, Federation of Employers and Business Association, Phnom Penh, Cambodia

 

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

Venue Details

Virtual Classroom Training

Contact us

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

Michelle,
M - 019 363 7822
michelle@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: Strategies To Reduce Debts
  • Module 2: Burning Issues In Debt Recovery.
  • Module 3: How To Deal With Different Type Of Difficulty Customers
  • Module 4: Negotiation Techniques
  • Module 5: Credit Evaluation & Monitoring
  • Module 6: Debt Planning
  • Module 7: Financial Reporting- Powerful Business Intelligent Tool (Tableau)
  • Module 8: What If Analysis Excel To Prepare & Monitor Your Budgeting & Sales, Collection Expenses Performance.
  • Module 9: Specific Formula & Function
  • Module 10: Conditional Formatting -Kpi & Performance Evaluation

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

To be an effective collector, you need to have the heart of an entrepreneur. This course will help to provide you with an environment that stimulates proactive behavior to achieve greater goals for yourselves and your organization.

 

By creating value for your organization, the essential to combine the knowledge & skills of debt recovery, data visualization & sensitivity analysis is very much necessary to propel your career growth.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding Negotiation Techniques.
  2. Profiling Your Customers.
  3. Using Practical Debt Recovery Approaches.
  4. Mastering the skills in dealing with Difficult Customers via telephone.
  5. Understanding Credit Evaluation & Monitoring.
  6. Understanding Gantt Chart (Project Scheduling).
  7. Applying Scenario Planning (Best, Worst & Likely Scenario).
  8. Financial Reporting- Powerful Business Intelligent tool (Tableau).
  9. Understanding What if analysis (Sensitivity).
WHO SHOULD ATTEND
Bankers, Accountants, Business Managers, Marketing Managers, Accountant Collection Executives, Sales Executives, Finance Executives, Supervisors, Managers, Credit Analysts, Credit Controller & Recovery Officers.
METHODOLOGY

Case Study & Group Discussion. Real-current problematic debt cases & sensitivity analysis will be analyzed, and scenario solutions will be discussed within the course.

 

Special Feature: Participants Will Receive a Set of Practical Templates suitable for all sectors. These templates;

  • Ease in planning, reporting & decision-making process
  • Snapshot of overall issues & problem
  • Financial modeling using goal seek strategies for cash flow, profit, sales target, budgeting & working capital requirements.
WHAT YOUR COLLEAGUES ARE SAYING ABOUT THE COURSE…
  • “After the 2-day workshop on “Debt Recovery on NPL”, the following improvement are obvious, I set customer dateline for customers to pay, as the trainer impressed with the phrase “customer always want to pay “Now I have the passion for collection from my customers”
    Head -Credit Division, Credit Guarantee Corporation
  • “The clear improvement is the boosting of my confidence in negotiation with the customers on default payment, knowing what to ask, how to approach the customers as many roles plays of customer interaction facilitated by Dr Steven Liew really helps me in the collection process. Really nice to hear from you again & following up on my collection position”
    Asset Manager, Malaysian Debt Venture
  • “Before the credit seminar training, I am a very straight forward person in collection & sometimes customers cannot take it. After the training, I realize I should be cool & focus in the collection process. I am practicing them now & seeing a real change in my attitude towards the customers. Really thank you to Dr Steven Liew”
    Head of Business Support Section, Johor Port Bhd
  • “The credit management & collection seminar reinforce my believe in building strong rapport with customer, help the customers & even take some risk, if necessary, to recover the money. The skills learnt from the practical training process in solving & recovery the debts are indeed rewarding & challenging. Dry Steven; feel free to drop by for a cup of drink & chat”
    Marketing Manager & Credit Head; Theen Seng Paper Manufacturer Sdn Bhd
  • “Real life practical experience shared from expert Dr Steven Liew”
    Manager, R&D, UMW Corporation Sdn Bhd
  • “Got many hidden technique and formula in excel“
    Product Development Engineer UMW Corporation Sdn Bhd
  • “New formulas being introduced” Group Accountant, Ban Seng Lee Industries Sdn Bhd
  • “Good use of advance excels tool of goal seek & solver for accounting and financial analysis using practical real-life examples. Participants are able to grasp concepts quicker as it is hands on and interactive.”
    Legal Division, Ministry of Finance
DAY 1
9:00

MODULE 1: STRATEGIES TO REDUCE DEBTS

  • Know your customers.
  • Plan your site visit.
  • Focus on collectable & big customers.
  • Lead by example
  • Be flexible, creative & think out of the box (ways & means to speed up the collection process)
  • Recovery techniques (outsourcing, insourcing, legal, asset conversion, take over, revaluation)
  • Put your house in order (credit evaluation 7cs, management support & involvement, clear SOP & strong credit manpower team, strong tracking systems)
  • Consider collection risk model (cost & benefit analysis)
  • Develop qualities of effective collectors.


10.45

MODULE 2: BURNING ISSUES IN DEBT RECOVERY

  • Management Bureaucracy
  • Collectors Are Not Well Recognized
  • Borrowers Has Multiple Loans Exposure to Other Banks
  • Unable to Locate Customers
  • Insufficient Funding for Repayment
12.00

MODULE 3: HOW TO DEAL WITH DIFFERENT TYPE OF DIFFICULTY CUSTOMERS

  • Give empty promises.
  • Avoiding
  • Giving thousand excuses
  • Annoying attitude
1:00 Lunch
2:00

MODULE 4: NEGOTIATION TECHNIQUES

  • Soft Negotiation
  • Hard Negotiation
  • Principles Negotiation
  • Successful Negotiation
3:45

MODULE 5: CREDIT EVALUATION & MONITORING

  • Importance of Credit Evaluation & Monitoring
  • Criteria for Approval or Rejection
  • Setting the Credit Limit
  • Monitoring Customer Account
  • Group exercises
5:00 End of Day 1
DAY 2
9:00

MODULE 6: DEBT PLANNING

  • Current DSO & AR
  • Target reduce AR & DSO.
  • Debt strategies


10.45

MODULE 7: FINANCIAL REPORTING- POWERFUL BUSINESS INTELLIGENT TOOL (TABLEAU)

  • Download software Tableau Public.
  • Steps in Tableau?
    - Data source must be a RAW data (No Formulas)
    - Data source must be in a table format (Headers must be on TOP)
    - Connect file.
    - Sort, filter, slice, pivot, and graph using a Tableau Public.
    - Combine multiple data sources.
    - Create bar charts, pie charts, and line graphs.
    - Map your data to quickly detect geographic variation.
    - Create a dynamic dashboard combining multiple worksheets.
12.00

MODULE 8: WHAT IF ANALYSIS EXCEL TO PREPARE & MONITOR YOUR BUDGETING & SALES, COLLECTION EXPENSES PERFORMANCE

  • Define your sales projection, factor in fluctuation.
  • Do your monthly average sales & expenses.
  • Used Variance techniques (2+10, 5+7, 8+4) and use SMART (specific, measurable, achievable, realistic & timebound)
  • Make sure your budget is always relevant during the year.
1:00 Lunch
2:00

MODULE 9: SPECIFIC FORMULA & FUNCTION

  • Gantt Chart (Project scheduling)
  • Scenario Planning (Best, worst & Likely scenario)
  • PV, FV, PMT (Loan facility)
  • Sensitivity Analysis
3:45

MODULE 10: CONDITIONAL FORMATTING -KPI & PERFORMANCE EVALUATION

  • Review staff performance
  • Link KPI to bonus & increment
5:00 End of Course