Credit management analytics and dashboard reporting using Excel (16&17-Mar-2016)

For REP’s, Member staff and Group (3+) registrations, complete & email registration form to cpd.malaysia@cpaaustralia.com.au

Download brochure & registration form

The value of data depends upon the ability of user to understand, interpret and communicate it’s key insights. A good credit management system will help you reduce the amount of capital tied up with debtors while minimising your exposure to bad debts.

Learn the seven smart reporting templates to prepare effective management reports 

1) Easy sort and filter debtors ageing report 
Learn to build an interactive sort and filter report – user decides which age of debt to sort, by just a click of button and simply by scrolling, shows the top 20 consecutive records of importance 

2) Interactive analysis of debtors 
Learn to creatively build interactive report that allows user to key in ‘group’ of debt owing, and the report auto computes the count of debtors & total debt, thus makes analysis flexible and relevant 

3) Informative yet simple line vs. target chart 
Learn to create powerful yet simple line charts which compares against target – giving a clear overview of the credit control performance over time 

4) Creative waterfall chart 
Learn to build waterfall chart which shows monthly progression and breakdown of debtors balance, add clarity with creative up/down arrows in place of columns 

5) Creative interactive credit risk vs. debt amount 
Learn to build report that allows user to select credit risk by month 

6) Auto-update commentary highlights 
Learn to create commentary write-up that automatically refreshes as month selector is changed 

7) Drill in to details 
Learn to place secondary data in another worksheet, while still allowing user easy access to view the details whenever required by clicking an object

Pre-requisite
• Must possessed at least Intermediate Excel and basic financial knowledge
• Software Version: MS Excel 2010

KEY TOPICS COVERED

Introduction: Get it right from the start…
• Why develop a Dashboard?
• The differences between a Report vs. Dashboard
• Learn the key steps in Dashboard reporting to ensure success
• The Do’s and Don’ts of designing a dashboard

The Model: Interactive credit management dashboard
• Create interactive Credit Management report to show: Overall DSO, credit risk exposure, receipting performance, spread of volume vs value of debtors, thereby giving you a clear high level view to have better control over your debtors performance
• Ease your analysis of debtors by building an interactive list of debtors’ aging that allows user to re-organise and sort quickly by simply clicking and scrolling without having to leave the dashboard.
• Improve your credit and collection plan by knowing where your credit risk lies, allowing for better formulation of strategies to be implemented
• Build capability to allow for what-if analysis, providing quick results that helps organise the credit and collection team to focus efforts where is required most

Protect and share: Protect and share your dashboard
• Protect your dashboard to ensure data integrity and data security
• Ease navigation around the worksheet with user friendly buttons
• Present with ease by linking your Dashboard into PowerPoint

Learning objectives

In this workshop, participants will learn to utilise smart excel functions and create charts that enable you to present them in easy-to-understand visuals! Power up by combining what-if analysis functions and allow for interactive credit management analysis.

SPEAKER’S PROFILE
Ms Joanne Kok Yee Lan
Ms Joanne is a certified accountant with diverse experience in the fields of audit, manufacturing, investment holding and training. Having served as a financial controller during her career, she honed her managerial, operational and financial analytical skills to achieve goals beyond managing credit, inventory and business processes. Ms Kok’s business mindedness and attention to detail have contributed million-dollar savings to the organisations she served. During her three year tenure with a multi-national organisation in China, she set up and established a joint venture business. The experience further broadened her business sense and management analytical skills, which she brings into the classroom and shares with her participants. She is known of her practical and performance orientated delivery hence enhancing the effectiveness of the learning for participants.

Audience

Credit management, AR managers, finance managers and accountants, supervisors and anyone who is interesting on this topic.