← Back to Hub ← 返回主页

Week 4: SQL Accounting AI Smart Scan & Ingestion 第 4 周:SQL Accounting AI 智能扫描与自动录入

💻 Practical Exercise Online 💻 在线实操练习

Step-by-Step Guide 分步指南

1. General Journal Adjustments

General Journals are used for non-routine entries like opening balances, depreciation, and year-end accruals. Double entry balances are strictly checked: total debits must equal total credits before saving.

2. Salary Accruals & EPF/SOCSO Taxes

Monthly salary journals debit Wages/Salaries Expense, EPF Employer, and SOCSO Employer, while crediting Accrued Salaries, Employee EPF/SOCSO deductions, and PCB (Monthly Tax Deduction) payables.

1. 普通日记账调整

普通日记账用于非日常分录,如期初余额、折旧和年末应计项目。系统严格检查借贷平衡:保存前总借项必须等于总贷项。

2. 薪资计提与 EPF/SOCSO 马来西亚税费

每月薪资日记账借记工资/薪金费用、EPF 雇主部分和 SOCSO 雇主部分,同时贷记应付薪资、员工 EPF/SOCSO 扣款以及 PCB(每月预扣税款)应付款项。

Concept Visualization 概念可视化

Debit: ExpenseWages (RM 10k)EPF Employer (RM 1.3k)Credit: DeductionsEPF Employee (RM 1.1k)PCB Tax (RM 500)Credit: LiabilityAccrued SalaryRM 9,700

Educational Infographic 教学信息图

Visual concept map explaining the key module topic: 解释该模块核心主题的视觉概念图:

Debit: ExpenseWages (RM 10k)EPF Employer (RM 1.3k)Credit: DeductionsEPF Employee (RM 1.1k)PCB Tax (RM 500)Credit: LiabilityAccrued SalaryRM 9,700

🤖 AI Integration Playbook 🤖 AI 实践指南

AI Prompting for Salary Journals:

Prompt: 'I need to post a salary journal. Total salary is RM 10,000, EPF Employer is 13%, EPF Employee is 11%, PCB tax is RM 500. Write the step-by-step general journal entries.'
Result: AI maps the entries: Debit Wages 10,000, Debit EPF Employer 1,300, Credit EPF Employee 1,100, Credit PCB 500, Credit Accrued Salary 9,700.

AI 辅助步骤:

Prompt 提示词: “我需要过账一份工资日记账。总工资为 RM 10,000,雇主 EPF 为 13%,员工 EPF 为 11%,每月预扣税 (PCB) 为 RM 500。请写出分步普通日记账分录。”
效果: AI 规划分录:借记工资 10,000,借记 EPF 雇主部分 1,300,贷记 EPF 员工部分 1,100,贷记 PCB 500,贷记应付工资 9,700。

Tips 提示

Ensure EPF Employee (11%) and EPF Employer (13% or 12%) are mapped to separate liability and expense ledger account codes to keep payroll accounts audit-friendly.
确保员工 EPF (11%) 和雇主 EPF (13% 或 12%) 映射到独立的负债和费用科目代码,以便于薪酬账目的审计。

Knowledge Check 知识自测

1. Which expense account records the employer's contribution to employee retirement fund in Malaysia? 在马来西亚,哪个费用账户记录了雇主对员工退休基金的缴纳部分?

2. What is the typical employee contribution rate for EPF in standard cases? 在标准情况下,员工个人缴纳 EPF 的典型比例是多少?

3. Before saving a General Journal, the accounting system checks that: 在保存普通日记账分录之前,会计系统会自动检查:

4. PCB stands for what in Malaysia payroll? 在马来西亚工资结算中,PCB 代表什么?

5. A salary accrual journal entry is typically posted in which module? 薪资计提日记账分录通常在哪个模块中过账?

Practical Exercise 实践练习

Task 1: Calculate 13% EPF Employer contribution for a basic salary of RM 4,000. 任务 1: 计算基本工资为 RM 4,000 的 13% 雇主 EPF 缴存额。

Task 2: Write the double entry representation for posting depreciation (Debit X, Credit Y format). 任务 2: 写出折旧过账的复式记账法表示形式(借记 X,贷记 Y 格式)。

Task 3: SQL statement to check all transactions in General Ledger table 'GL' that do not balance. 任务 3: SQL 语句:检查 General Ledger 表 'GL' 中不平衡的所有交易分录。

Matching Game 配对游戏

Match the term on the left with its definition on the right. 将左侧的术语与右侧的定义进行配对。

PCB Tax
Monthly tax deduction payable 应付每月预扣所得税款
EPF Employer
13% contribution (Expense account) 13% 雇主部分(费用账户)
Accrued Salaries
11% deduction (Liability account) 11% 员工扣除部分(负债账户)
EPF Employee
Salary liability until bank payment 银行支付前的应付薪资负债