Simple Bookkeeping Template for Malaysian Small Businesses (Excel & Google Sheets)
Record each sale and expense in one line. The summary shows your income, expenses and profit for every month.
What you get
- Pick a category from a dropdown and the sheet knows if it is income or expense
- Monthly and yearly totals with a chart
- Spending by category, so you can see where the money goes (rent, stock, salary...)
- Payment method column: cash, bank transfer, e-wallet, card
- Edit up to 30 categories to fit your business
Good to know
- Works in Excel 2016 or newer, Google Sheets and LibreOffice. No macros.
- Green cells are for your input. Formula cells are locked so you can't break them by accident.
- Comes with sample data so you can see how it works. Clear the green cells and start.
- Labels in English and Chinese (简体中文).
- Instant download: one .xlsx file with a guide sheet inside.
- This is simple bookkeeping for your own records. It does not replace an accountant or tax filing software.
---
每笔收入、支出记一行,报表马上告诉你每个月赚了多少。
内容
- 类别用下拉选,自动分收入或支出
- 每月、全年合计,附图表
- 每个类别全年花多少(租金、进货、薪水……)一眼看到
- 记付款方式:现金、转账、电子钱包、刷卡
- 类别可以自己改,最多 30 个
说明
- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。
- 浅绿色格子是你填的,公式格锁住了,不怕改坏。
- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。
- 中英双语标题。
- 付款后马上下载:一个 .xlsx 档案,里面有说明页。
- 这是给自己看的简单记账,不能代替会计师或报税软件。