Strengthening Internal Controls with Analytics

Offered by School of Business & Accountancy

Short Course / 24 hours / TGS-2021009903

Note: To receive an alert about the future runs for this course, please click on the INDICATE INTEREST button. Thank you.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Trainer Profile
Certification
Entry Requirements
Course Fees

Course Information

This is a certification program in which participants will obtain a Certification on Accounting Transformation upon completion of 6 courses:

  1. Accounting for Analysis and Decisions
  2. Using MS Excel in Accounting
  3. Performing Cloud-Accounting
  4. Finance-Business Partnering with Data Visualisation
  5. Strengthening Internal Controls with Analytics
  6. Automation of Processes with RPA

The overall program is aimed at equipping bookkeepers with skillset to enable them to chart out their progression paths in view of existing industrial developments causing disruption to job roles. The program provides participants with knowledge and hands-on skills in visualisation, automation, etc. in order to help them stay relevant and employable.

Learning Outcomes

Upon completion of this course on Strengthening Internal Controls with Analytics, participants will acquire knowledge on the internal control principles to embed basic internal controls and compliance checks during transaction processing. They will also be able to explain and use data analytics and visualisation tool to apply analytics techniques to assess their accounting transactions to identify and detect non-compliances with internal controls.

Course 
Schedule

Course Date: TBC
Application Period: TBC
Duration: 24 hours
Time: 4 x 4 hours face-to-face lessons (F2F (9am – 1pm)) & 4 x 2 hours online lessons (8 hours)
Delivery Mode: Classroom with Asynchronous e-Learning
Venue: Classroom & Online

Ngee Ann Polytechnic reserves the right to reschedule / cancel any programme, modify the fees and amend information without prior notice.

Lesson Plan

All sessions will be conducted on a weekly basis within the same month.             

Session 1: (6 hours)

  • Internal Control Principles and Frameworks (E-Learning: 2 hours Asynchronous)
  • Internal Controls (Using COSO Internal Controls – Integrated Framework) (F2F: 1 hour on a weekday morning)
    • Control Environment
    • Risk Assessment
    • Control Activities
    • Information and Communication
    • Monitoring
  • Review of Local and International Fraud Cases and Role of Internal Controls in Mitigating Risks (F2F: 2 hours on a weekday morning)
  • Concepts of Fraud Analytics (F2F: 1 hour on a weekday morning)

Session 2: (6 hours)

  • Internal Controls in the Accounting Processes (E-learning: 2 hours Asynchronous)
    • Payments and Accounts Payables
    • Revenue and Accounts Receivables
    • Payroll
    • Fixed Assets and Inventory
    • Cash and Cash Equivalents
  • Risk Control Matrix (F2F: 1.5 hours on a weekday morning)
    • Process Based Approach
    • Risk Based Approach
    • Control Based Approach
  • Getting Started with Data Analytics (F2F: 2.5 hours on a weekday morning)
    • Identify the Data Analytics Maturity Scale in Your Organisation
    • Factors Affecting Maturity Scale and Analytics Adoption Rate
    • Benefits of Analytics in Internal Controls

Session 3: (6 hours)

  • Introduction of Data Analytics for Accounting and Finance (E-Learning: 2 hours Asynchronous)
  • Data Analytics Techniques for Accounting Processes (F2F: 1 hour on a weekday morning)
    • Payments and Accounts Payables
    • Revenue and Accounts Receivables
    • Fixed Assets and Inventory
    • Cash and Cash Equivalents
  • Designing and Developing Analytics for Payroll Process using Tableau (F2F: 3 hours on a weekday morning)
    • Risk Control Matrix
    • Hypothesis Generation
    • Dashboard Design
    • Dashboard Creation
    • Identifying Anomaly in Analytics

Session 4: (6 hours)

  • Introduction to Risk and Control Self-Assessment (E-Learning: 2 hours Asynchronous)
  • Developing Analytics for Self-Check and Control Checks (F2F: 2 hours on a weekday morning)
  • Developing Analytics for Continuous Monitoring (F2F: 2 hours on a weekday morning)

Trainer's Profile

Chew Lee Chen

Chew Lee Chen has 10 years of experience in Data Analytics across different industries and business functions. She majored in Information Systems Management and has built up strong technical skills in data analytics, data visualization and machine learning over the years as an IT professional. Lee Chen’s past working experience includes being a Data Analyst in an Accounting firm, Fraud Analytics Manager in Internal Audit, and currently as a Project Manager in a consumer technology company. Lee Chen is passionate about using analytics and automating processes, and loves to share her knowledge with others so as to equip them with the same skill sets. She has curated training materials and conducted multiple training sessions on Data Analytics, Robotic Process Automation (RPA) and the use of various tools for over 1,000 participants.

Certification

A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass the assessment.


Participants will further obtain a Certificate on Accounting Transformation upon completion of all 6 courses in the program.


Entry Requirements

  • Basic Proficiency in English
  • Bookkeeping/ Accounting background

Course Fees

Funding period for this course is from 25 Nov 2021 to 30 Sep 2024.

SkillsFuture Credit
All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website to choose from the courses available on the Training Exchange course directory.

Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.

Enhanced training support for SMEs
For enhanced training support for SMEs, enter SME in the promo code during course application.

Long Term Visit Pass Plus (LTVP+) holders, please furnish the following documents to the course administrator to qualify for SSG funding:
Self-sponsored learner (**LTVP+): Copy of your green visit pass card, with the word ‘PLUS’ on the back of the card.
Co-sponsored learner (##LTVP+): Copy of valid and current Letter of Consent (LOC) from MOM

Temasek Trust – CDC Lifelong Learning Enabling Fund
Eligible learners with disability can apply for up to S$1,000 to defray course-related fees. For more information, please click here. Funding ends on 31 Dec 2022.

Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.

(Course fee is payable upon acceptance. It is inclusive of 7% GST and subject to review.)

Applicants / Eligibility Fees
Full Course Fee$674.10
Singaporeans aged below 40 and Permanent Residents qualified for SkillsFuture Funding$202.23
Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy$76.23
Singaporeans and Permanent Residents qualified for Enhanced Training Support for SMEs$76.23
Others (and Repeat Students)$674.10