Course Information
This is a certification program in which participants will obtain a Certification on Accounting Transformation upon completion of 6 courses:
- Accounting for Analysis and Decisions
- Using MS Excel in Accounting
- Performing Cloud-Accounting
- Finance-Business Partnering with Data Visualisation
- Strengthening Internal Controls with Analytics
- 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
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 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.
GST Increment in 2024
Please note that the GST rate will be revised to 9% with effect from 1 Jan 2024. As such any payable course fees will be subjected to the new GST rate adjustments in 2024. Please refer to our STEP portal for the updated fees. (Click on STEP)
Note:
- The fees below are determined based on prevailing funding policies and subject to review and revision.
- Please refer to our FAQs for more information.
Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.
| Applicants / Eligibility | Fees |
|---|---|
| Full course fee | $680.40 |
| Singaporeans aged below 40 qualified for SkillsFuture Funding | $202.23 |
| Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy | $76.23 |
| Singaporeans qualified for Enhanced Training Support for SMEs | $76.23 |
| Singapore Permanent Residents & **LTVP+ qualified for SkillsFuture Funding | $204.12 |
| Singapore Permanent Residents & ##LTVP+ qualified for Enhanced Training Support for SMEs | $78.12 |
| Others (and Repeat Students) | $680.40 |