ASE20095: Computerised Accounting Skills ASE20095: 计算机化会计实操技能

Interactive Study Portal & AI Playbook 互动式学习门户与 AI 实操指南

Macaron Accounting Concept
Go to Comprehensive Review SPA 进入综合复习笔记本 SPA

Continuous Assessments (100%) 持续评估作业 (100%)

📋 Download Official Grading Rubric 📋 下载官方评分标准

Assignment 1: SQL (50%)

📄 Download Instructions 🧾 Mock Source Documents

Assignment 2: Cloud (50%)

📄 Download Instructions 🧾 Mock Source Documents
Week 1 第 1 周

Topic 1: SQL Accounting Intro & Setup 主题 1:SQL Accounting 介绍与系统初始化

Introduction to SQL Accounting, system requirements, and creating a new company database. SQL Accounting 介绍、系统要求以及创建新公司数据库。

Week 2 第 2 周

Topic 2: SQL Accounting COA & Opening Balances 主题 2:SQL Accounting 科目表与期初余额

Setting up the chart of accounts, entering opening balances, and managing debtor/creditor profiles. 设置会计科目表、录入期初余额以及管理应收/应付账款档案。

Week 3 第 3 周

Topic 3: SQL Accounting Sales Tax (SST) & E-Invoicing 主题 3:SQL Accounting 销售税 (SST) 与电子发票

Configuring Malaysia SST, tax codes, and processing E-invoices in SQL Accounting. 配置马来西亚 SST、税码,以及在 SQL Accounting 中处理电子发票。

Week 4 第 4 周

Topic 4: SQL Accounting AI Smart Scan & Ingestion 主题 4:SQL Accounting AI 智能扫描与自动录入

Using AI smart scan for OCR invoice extraction and automated data ingestion. 使用 AI 智能扫描进行 OCR 发票提取和自动数据录入。

Week 5 第 5 周

Topic 5: SQL Accounting Procurement, Inventory & Ledgers 主题 5:SQL Accounting 采购、库存与分类账

Managing purchase orders, goods received notes, and real-time inventory synchronization. 管理采购订单、收货单以及实时库存同步。

Week 6 第 6 周

Topic 6: SQL Accounting Journals & Errors Correction 主题 6:SQL Accounting 日记账与错误更正

Posting general journals, correcting bookkeeping errors, and generating basic financial reports. 记录普通日记账、更正记账错误以及生成基本财务报表。

Week 7 第 7 周

Topic 7: Cloud Million Accounting Setup & Access 主题 7:Cloud Million 财务设置与多用户访问

Transitioning to Cloud Million accounting, cloud setup, and configuring multi-user access. 过渡到 Cloud Million 财务系统、云端设置以及配置多用户访问。

Week 8 第 8 周

Topic 8: Cloud Million Debtor & Creditor Aging 主题 8:Cloud Million 应收与应付账龄管理

Analyzing debtor and creditor aging reports, setting credit terms and limits in the cloud. 分析应收和应付账龄报告,在云端设置信贷账期和额度。

Week 9 第 9 周

Topic 9: Cloud Million Transaction Recording & Workflows 主题 9:Cloud Million 交易记录与工作流

Recording daily transactions, managing cloud workflows, and data security. 记录日常交易、管理云端工作流以及数据安全。

Week 10 第 10 周

Topic 10: Cloud Million Custom Reports & Bank Recon 主题 10:Cloud Million 自定义报表与银行对账

Creating custom criteria filters for reports and performing automated bank reconciliations. 为报表创建自定义条件过滤并执行自动银行对账。

Week 11 第 11 周

Topic 11: Cloud Million Year-End Closing Procedures 主题 11:Cloud Million 年终结账程序

Executing year-end closing processes, profit transfers, and securing finalized cloud ledgers. 执行年终结账流程、利润结转以及锁定最终云端分类账。

Week 12 第 12 周

Topic 12: AI Analytics & Cash Flow Forecasting 主题 12:AI 财务分析与现金流预测

Utilizing AI tools to analyze financial data, predict cash flow trends, and assess liquidity. 利用 AI 工具分析财务数据、预测现金流趋势并评估流动性。

Week 13 第 13 周

Topic 13: AI-Driven Financial KPI & Ratio Analysis 主题 13:AI 驱动的财务 KPI 与比率分析

Deep dive into automated financial KPIs, current/quick ratios, and profitability metrics using AI. 深入探讨使用 AI 进行自动化财务 KPI、流动/速动比率以及盈利能力指标分析。

Week 14 第 14 周

Topic 14: AI Financial Report Interpretation & Insights 主题 14:AI 财务报告解读与洞察

Synthesizing final financial reports with AI to generate strategic business insights and governance reviews. 使用 AI 综合最终财务报告,生成战略业务洞察和治理审查。