Overview
This 2-day course provides good coverage of using analytics for accounting & auditing professionals through a combination of seminars, case studies, and hands-on sessions using free tools available. Through analysis and visualization, this course aims to equip professionals with the skills to discover and analyze patterns, digressions, and inconsistencies in data, for the purpose of performing the audit.
What You’ll Learn
At the completion of the sessions, the participant should be able to:
| Topics |
Objectives |
| Basics of data analytics
|
Use of business intelligence tools and their applications in accounting and auditing context |
| Analysis of Journal entries |
Drill into the journal entries to identify patterns and anomalies |
| Analysis of Revenue and AR accounts |
- Assess collectability risk and customer profitability
- Make estimation of provision for doubtful debt
- Use audit analytics to test the relevant assertions of sales transactions and accounts receivables
|
Who Should Attend
- Accounting & Auditing Professionals
SITizens Learning Credits (SLC) - Eligible Course
SIT Alumni: Before registering for courses, please activate your
SITizens Learning Credits via the email sent by SIT Alumni Team, on behalf of SITLEARN Professional Development.
CLICK HERE TO APPLY (only for SIT Alumni)
Certificate and Assessment
A Certificate of Participation will be issued to participants who:
- Attend 75% of the course
- Undertake non-credit bearing assessment (during course)
Schedule
Day 1
| Welcome and Registration |
- Overview of DA and real world use cases of data analytics in Auditing & Accounting
- Types of data analytics, i.e., business intelligence, data visualization and machine learning
|
| Introduction to Power BI |
| Tea Break |
|
| Hands-on practice with Power BI |
|
| Lunch |
|
| Creating Dashboard with Power BI (I) |
|
| Tea Break |
|
| Creating Dashboard with Power BI (I) |
|
| End of Day |
|
Day 2
| Audit objectives in auditing revenue cycle |
- Filtering, grouping and sorting of data
- Generating AR aging statement
- Using analytics techniques for risk assessment
|
| Tea Break |
| Identify risk factors, affected assertions and prepare planning memo |
|
| Lunch |
|
| Using audit analytics to test assertions I |
|
| Tea Break |
|
| Using audit analytics to test assertions II |
|
| Quiz/ Q&A |
|
| End of Day |
|
Fees
| Category |
Full Fee |
After SF Funding |
| Singapore Citizen (Below 40) / Singapore PR |
$2,033.00 |
$609.90 |
| Singapore Citizen (40 & above) |
$2,033.00 |
$229.90 |
| Non-Singaporeans |
$2,033.00 |
Not Eligible |
Note:
- All figures include GST. GST applies to individuals and Singapore-registered companies.
- You can opt for either SF Series Funding or Mid-Career Enhanced Subsidy. Both cannot be combined.
»
Learn more about funding types available
Terms & Conditions:
SkillsFuture Funding
In order to be eligible for the 70% training grant awarded by SkillsFuture, applicants (and/or their sponsoring organisations where applicable) must:
- Be a Singaporean Citizen or Singapore Permanent Resident
- Not receive any other funding from government sources in respect of the actual grant disbursed for the programme
SkillsFuture Mid-Career Enhanced Subsidy
To be eligible for the 90% enhanced subsidy awarded, applicants (and/or their sponsoring organisations where applicable) must:
- Be a Singaporean Citizen
- Be at least 40 years old
- Not receive any other funding from government sources in respect of the actual grant disbursed for the programme
SIT reserves the right to make changes to published course information, including dates, times, venues, fees and instructors without prior notice.
