Malaysia Small Business Excel Bundle: Bookkeeping, Inventory, Invoice, Customers, Cash Flow
One sheet for both quotations and invoices. Pick items from your price list and it adds up the totals for you.
What you get
- Switch between Quotation and Invoice with one dropdown
- Document number, valid-until date and due date fill in automatically
- Price list for up to 200 items, with line discounts
- Tax line you set yourself (leave 0% if you are not SST-registered)
- Your company details, SSM number and bank account on every document
- Prints on one A4 page, or save as PDF
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 a normal commercial invoice. It is not an LHDN e-Invoice (MyInvois). If your business must issue e-Invoices, use MyInvois or your e-Invoice provider for those.
---
报价单和发票同一张表,从价目表选项目,总额自己算好。
内容
- 一个下拉选单切换报价单 / 发票
- 单据号码、有效日期、到期日自动产生
- 价目表放 200 项,每行可打折
- 税率自己填(没注册 SST 就留 0%)
- 公司资料、SSM 号码、银行户口自动带进单据
- 印出来刚好一张 A4,也可存 PDF
说明
- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。
- 浅绿色格子是你填的,公式格锁住了,不怕改坏。
- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。
- 中英双语标题。
- 付款后马上下载:一个 .xlsx 档案,里面有说明页。
- 这是一般商业发票,不是 LHDN 电子发票(MyInvois)。你的生意如果规定要开电子发票,那部分请用 MyInvois 或电子发票服务商。