免费 现金流量表 电子表格模板
编制包含经营、投资和筹资活动的现金流量表。跟踪现金流入和流出，查看净现金头寸。
Upgrade your spreadsheet
Here is how you unlock a better version.
Essentials
- Full-featured Cash Flow Statement with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
$12 one-time
Ultimate Most complete
- Operating Activities sheet covering cash receipts, cash payments to suppliers and employees, and other operating items with monthly columns
- Investing Activities sheet tracking capital expenditures, asset purchases, asset sales, and investment transactions by month
- Financing Activities sheet logging loan proceeds, loan repayments, equity investments, and dividend payments by month
$19 one-time
包含内容
- 仪表板包含现金流汇总，显示经营、投资、筹资活动的净现金和总变动额
- 采用标准会计格式的现金流量表，使用间接法，包含三个活动部分
- 经营、投资和筹资活动部分，包含常见现金流条目的预设行项目
- 自动计算净现金流，汇总三个部分以显示现金的增加或减少总额
- 期间对比，彩色标记的输入单元格（黄色）和自动计算的合计（蓝色）
- 适用于 Microsoft Excel、Google Sheets 和 LibreOffice Calc，无需任何设置
Free、Essentials 与 Ultimate - 有什么区别？
Free $0
- Pre-filled budget worksheet titled "Cash Flow" with sample income and expense categories
- Automatic totals, running balance, and surplus/deficit calculation
- Color-coded input cells so you know exactly where to type your own numbers
- Step-by-step "How to Use" guide included in a second sheet
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc - no setup or sign-up
Essentials $12
- 包含 Free 的全部
- Full-featured Cash Flow Statement with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
- $12 one-time purchase, lifetime access
Ultimate $19
- 包含 Essentials 的全部
- Operating Activities sheet covering cash receipts, cash payments to suppliers and employees, and other operating items with monthly columns
- Investing Activities sheet tracking capital expenditures, asset purchases, asset sales, and investment transactions by month
- Financing Activities sheet logging loan proceeds, loan repayments, equity investments, and dividend payments by month
- Dashboard with 6 KPI cards: net operating cash flow, net investing cash flow, net financing cash flow, total net cash, ending cash balance, and months of runway
现金流量表 模板的工作原理
Single-period cash in and out. Inflows are positive, outflows are negative, so the total is Net Cash Flow. A single-period operating cash flow. Enter cash-in rows as positive, cash-out rows as negative. The total at the bottom is Net Cash Flow.
此模板何时有用
- You just started tracking spending and want a clear monthly snapshot.
- You want to see where your money actually goes compared to what you planned.
- Your expenses changed (new job, moved, new baby) and you need to re-baseline.
- You prefer a spreadsheet you control over a budgeting app.
充分利用的小贴士
- This is an operating cash flow only. For a full statement, add sections for Investing and Financing activities in a Essentials or Ultimate upgrade.
需要避免的常见错误
- Forgetting to include savings as a category - treat savings like any other bill so it gets funded first.
- Using gross income instead of take-home. Budget with what actually lands in your account.
- Over-optimistic "variable" categories. Groceries and dining out almost always come in higher than memory suggests.
如何使用这个现金流量表模板
1
输入经营活动
填写经营活动现金流 - 净利润、折旧以及应收款和应付款等营运资本项目的变动。
2
添加投资活动
记录用于或来自投资的现金 - 设备购置、物业出售或投资交易。
3
添加筹资活动
在筹资部分输入贷款收入、贷款偿还、发行权益和已付股息。
4
检查净现金流
仪表板汇总三个部分，显示本期现金的净变动额，加上期初和期末现金余额。
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
Upgrade your spreadsheet
Here is how you unlock a better version.
Essentials
- Full-featured Cash Flow Statement with dashboard and detailed analytics
- Pre-filled subcategories, sample scenarios, and helper calculations
- Larger data capacity for real-world usage
$12 one-time
Ultimate Most complete
- Operating Activities sheet covering cash receipts, cash payments to suppliers and employees, and other operating items with monthly columns
- Investing Activities sheet tracking capital expenditures, asset purchases, asset sales, and investment transactions by month
- Financing Activities sheet logging loan proceeds, loan repayments, equity investments, and dividend payments by month
$19 one-time
常见问题
这使用什么方法？
模板使用间接法，从净利润开始，调整非现金项目和营运资本变动，得出经营活动现金流。
经营活动和投资活动有什么区别？
经营活动涵盖日常业务 - 收入、费用、应收款和应付款。投资活动涵盖资产购买和出售。筹资活动涵盖债务和权益交易。
可以比较多个期间吗？
可以。模板支持期间对比，当前期间和上一期间并排显示。
折旧会加回吗？
会。在间接法下，折旧是非现金费用，在经营活动部分加回到净利润中。
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。
此模板使用什么许可证？
所有免费模板均采用 CC BY 4.0（知识共享署名）许可证发布。您可以自由使用、修改和分享，包括用于商业用途，只需注明来源为 FinancialAha.com。模板按原样提供，不构成财务建议。