← Back to Hub ← 返回主页

Week 11: Cloud Million Year-End Closing Procedures 第 11 周:Cloud Million 年终结账程序

💻 Practical Exercise Online 💻 在线实操练习

Step-by-Step Guide 分步指南

1. Integrated Ecosystems

Modern accounting links directly to third-party business apps: e-commerce (Shopify), inventory platforms, and payment gateways. Direct integration eliminates manual journal voucher duplication.

2. Sales & Payment Gateway Sync

Processing online transactions automatically triggers two ledger postings: debiting Stripe/PayPal clearing account (sales receipts) and crediting Sales Revenue + SST payable accounts.

1. 数字化集成生态系统

现代会计直接连接第三方业务应用:电子商务 (Shopify)、库存管理平台和支付网关。直接集成消除了人工重复录入日记账凭单的工作。

2. 销售与支付网关同步

处理在线交易时自动触发两笔分类账过账:借记 Stripe/PayPal 清算账户(销售收款),贷记销售收入和应付 SST 账户。

Concept Visualization 概念可视化

Shopify StoreStripe GatewayClearing AccountGeneral Ledger

Educational Infographic 教学信息图

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

Shopify StoreStripe GatewayClearing AccountGeneral Ledger

🤖 AI Integration Playbook 🤖 AI 实践指南

AI Prompting for Integration Rules:

Prompt: 'Our Stripe payments deduct a 2% fee before bank transfer. Write the double-entry mapping formula to record Shopify Sales (RM 100), Stripe Fee (2%), and Bank Deposit.'
Result: AI delivers mappings: Debit Bank 98, Debit Stripe Fee 2, Credit Sales Revenue 100.

AI 辅助步骤:

Prompt 提示词: “我们的 Stripe 支付在银行转账前扣除 2% 的手续费。请写出复式记账映射公式来记录 Shopify 销售 (RM 100)、Stripe 手续费 (2%) 和银行存款。”
效果: AI 给出分录:借记银行 98,借记 Stripe 手续费 2,贷记销售收入 100。

Tips 提示

Always map payment gateway processing fees to a dedicated expense ledger account. Do not net off sales revenues, as tax authorities require auditing gross sales amounts.
务必将支付网关的手续费映射到专用的费用科目。切勿直接扣减销售收入,因为税务机关审计时要求查看总销售金额。

Knowledge Check 知识自测

1. Connecting Shopify to QuickBooks Online is an example of: 将 Shopify 链接到 QuickBooks Online 是什么例子?

2. When a customer pays via credit card online, the system debits which temporary account? 当客户在网上通过信用卡付款时,系统会借记哪个临时账户?

3. Why should Stripe transaction fees not be subtracted directly from Sales Revenue? 为什么不应直接从销售收入中扣除 Stripe 交易费?

4. Synchronizing inventories across multi-channel sales prevents: 在多渠道销售中同步库存可以防止:

5. Which system diagram shows how transactions flow from online stores to general ledgers? 哪种系统图展示了交易如何从网上商店流向总分类账?

Practical Exercise 实践练习

Task 1: Calculate payment gateway fee of 2.5% for a sale of RM 2,000. 任务 1: 计算 RM 2,000 销售额在 2.5% 费率下的支付网关手续费。

Task 2: Write a SQL statement to insert Stripe payment of RM 98 and fee RM 2 to table 'Payments'. 任务 2: 编写一个 SQL 语句,向 'Payments' 表插入一笔 RM 98 的 Stripe 付款和 RM 2 的手续费记录。

Task 3: Which accounting account category is Payment Gateway Fees classified under? 任务 3: 支付网关手续费属于哪类会计账户大类?

Matching Game 配对游戏

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

Shopify
Payment gateway processing net cash 处理净现金结算的支付网关
Stripe
E-commerce sales origin channel 电子商务销售源头渠道
Clearing Account
Temporary transit ledger code 临时中转分类账科目
Workflow Map
Visual chart of data sync pipelines 数据同步管道的可视化图表