80/20 Budget Essentials 模板
A simplified two-bucket approach - save 20% and spend the remaining 80% however needed. For those who prefer minimal budget categories.
包含内容
- Dashboard with 80/20 allocation view showing total income split into spending and savings buckets
- Two-bucket budget tracker that separates all spending (80%) from savings and investments (20%)
- Automatic savings target calculation that updates the 20% goal whenever income amounts change
- Flexible spending section within the 80% bucket - no rigid categories, just total spending tracked
- Color-coded input cells and clean summary layout with automatic income-based percentage updates
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with 80/20 allocation view showing total income split into spending and savings buckets
- Two-bucket budget tracker that separates all spending (80%) from savings and investments (20%)
- Automatic savings target calculation that updates the 20% goal whenever income amounts change
- Flexible spending section within the 80% bucket - no rigid categories, just total spending tracked
- 仪表板包含6个关键指标卡片：月收入、储蓄总额、消费总额、总余额、储蓄率和年度累计储蓄
- 预算追踪工作表从月收入计算20%储蓄目标和80%消费限额，包含实际与目标对比
- 消费工作表用于12个类别的所有生活和生活方式支出 - 80%的分类无需进一步细分
- 储蓄工作表追踪20%分类中特定储蓄目标、投资和应急基金的存入
- 月度历史工作表记录所有12个月的消费和储蓄总额，包含每个分类的超支/节省差异
预览
查看此模板的内容
如何使用这个80/20 Budget模板
Enter your income
Type your monthly after-tax income at the top. The template calculates the 80% spending limit and 20% savings target automatically.
Track total spending
Record all expenses in the spending section. The template focuses on total spending rather than detailed category breakdowns.
Verify your savings
Check whether the 20% savings target is met. The dashboard shows how much has been saved vs the target amount.
Adjust the balance
If total spending exceeds 80%, review the largest expense items. The simple two-bucket view makes it easy to see where you stand.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
Why only two buckets?
The 80/20 approach simplifies budgeting to one rule - save 20% and spend the rest however you need. It is designed for people who do not want detailed category tracking.
Do I need to categorize my expenses?
No. The template tracks total spending against the 80% limit. You can add categories if you want, but the core design does not require them.
Can I change the savings percentage?
Yes. The percentage fields are editable. Adjust the split to 85/15, 75/25, or any ratio that fits your situation.
Where does debt payment go?
Minimum debt payments are part of the 80% spending bucket. Extra payments beyond minimums can go in the 20% savings bucket since they build net worth.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。