12-Month Cash Flow Planner for Malaysian Small Businesses (Excel & Google Sheets)
Enter the money you expect to come in and go out. See your cash balance at the end of each month and spot a tight month before it arrives.
What you get
- Up to 15 income lines and 25 expense lines, 12 months each
- Opening, net and closing cash for every month
- Low-cash warning at a level you set
- Line chart of month-end cash
- Replace estimates with actual numbers as the months pass
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.
- A planning tool based on your own estimates. It is not financial advice.
---
填进未来 12 个月预计进出的钱,看每个月底剩多少,哪个月会紧先知道。
内容
- 收入 15 项、支出 25 项,各 12 个月
- 每月月初、净额、月底现金
- 低过你设的金额就警告
- 月底现金折线图
- 每过一个月改成实际数字,后面自动更新
说明
- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。
- 浅绿色格子是你填的,公式格锁住了,不怕改坏。
- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。
- 中英双语标题。
- 付款后马上下载:一个 .xlsx 档案,里面有说明页。
- 这是用你自己估计的数字做规划,不是财务建议。