What Is the 70/20/10 Budget Rule? The 70/20/10 rule is a budgeting framework designed to organize monthly spending into a small number of groups. Instead of assigning a separate percentage to dozens of individual expense categories, it starts with three large slices. That makes the method easy to understand and quick to set up. 70% for Living Expenses The largest slice covers the cost of your everyday life. This includes both essential expenses and the discretionary spending that makes up your day-to-day routine: Rent or mortgage Utilities and internet Groceries and household items Transportation and fuel Insurance Healthcare costs Dining out, entertainment, and subscriptions Shopping and personal care Notice that this category mixes essentials with wants. That’s a deliberate difference from rules like 50/30/20, which separate “needs” and “wants.” Under 70/20/10, you give yourself one combined living budget and manage it as a whole. 20% for Savings and Debt Repayment The second slice is about building financial security. Depending on your priorities, it can include: Emergency savings Retirement contributions Other savings goals (a home, travel, education) Extra payments on credit cards or loans For someone with high-interest debt, this category may lean heavily toward repayment. For someone with a solid emergency fund, it may shift toward retirement and long-term savings. 10% for Investing and Personal Goals The final slice is the most flexible. Common uses include: Long-term investing Charitable donations A dedicated personal development budget Additional payments toward a specific financial goal This 10% gives the framework room for what matters beyond basic living and standard savings.
How the 70/20/10 Rule Works in Real Life The calculation is straightforward. Start with your monthly after-tax income. Then calculate: Living Expenses = Income × 70% Savings/Debt = Income × 20% Investing/Personal = Income × 10% For example, with $4,000 of monthly after-tax income: Living expenses: $2,800 Savings and debt: $800 Investing and personal: $400 An Excel 70/20/10 budget planner can calculate these targets automatically. In practice, your spending may not match the targets exactly. Suppose your living expenses total $3,100 instead of $2,800. That’s 77.5% of income — above the 70% target. That doesn’t mean the system failed. It tells you something specific: in this month, living costs absorbed more than the framework suggests. You can then decide whether to trim a category, pause discretionary spending, increase income, or accept the deviation and adjust for the next month.
Why Use Excel for a 70/20/10 Budget? A calculator can tell you what 70%, 20%, and 10% of your income are. Excel can help you manage the entire budget. With a 70/20/10 budget Excel template, you can combine: Monthly income Target amounts for each slice Actual living expenses Savings and debt payments Investing or personal contributions Remaining budget per slice Rolling month-to-month comparisons For example: Category Target Actual Difference Living Expenses $2,800 $3,100 -$300 Savings & Debt $800 $750 +$50 Investing / Personal $400 $450 +$50 This view immediately shows where spending ran over target and which slices stayed on track. That’s more useful than simply knowing your total spending for the month.
What to Include in a 70/20/10 Budget Planner A useful 70/20/10 budget planner should make it easy to compare target allocation with actual spending. Monthly Income Start with your monthly after-tax income. If your income varies from month to month, update the amount each month rather than relying on an annual average. Living Expenses Create practical subcategories so you can see where the 70% actually goes, such as: Housing Utilities Groceries Transportation Insurance Healthcare Dining and entertainment Shopping and subscriptions Savings and Debt Track: Emergency fund contributions Retirement savings Other savings goals Extra debt payments Investing and Personal Record: Long-term investments Charitable giving Personal development spending Goal-specific contributions Budget vs. Actual This is the most valuable part of the planner. Instead of setting a budget once and forgetting it, compare planned and actual amounts each month. Budget: $2,800 Actual: $3,100 Difference: -$300 A negative difference means you spent more than planned in that slice. A positive difference means you stayed under target.
How to Create a 70/20/10 Budget in Excel You can build a simple planner with a few columns and formulas. Step 1: Enter Your Monthly Income Create an income field at the top of the spreadsheet. Monthly After-Tax Income: $5,000 Step 2: Calculate Your Target Amounts Use formulas to calculate the three targets: Living Expenses: =Income70% Savings/Debt: =Income20% Investing/Personal: =Income10% If your income is stored in cell B2, the formulas become: =B270% =B220% =B210% Excel recalculates these automatically whenever you change your income. Step 3: Log Your Actual Spending by Slice Create rows for your actual spending, grouped into the three slices. For example: Item Slice Budget Actual Rent Living $1,800 $1,800 Groceries Living $600 $640 Eating out Living $300 $350 Emergency fund Savings $500 $500 Retirement Savings $300 $250 Investing Personal $400 $450 This connects each individual expense to one of the three larger slices. Step 4: Compare Budget and Actual Spending Calculate the difference between planned and actual amounts per slice. Difference = Budget − Actual A positive result means you spent less than planned. A negative result means you spent more. Step 5: Review the Month At the end of the month, look at the three slices and ask: Did living expenses stay near 70%? Did savings and debt payments hit the 20% target? Did I actually use the 10% slice as planned? Which subcategory ran over? What should I adjust next month? This turns your spreadsheet into an ongoing budgeting system rather than a one-time exercise.
How to Adjust the 70/20/10 Rule for Your Situation Budgeting frameworks are guidelines, not universal requirements. Your financial situation may not fit exactly into 70/20/10. When 70% Living Is Not Enough In high-cost areas, housing alone can consume 40–50% of income. If keeping all living costs below 70% is unrealistic, you may need a temporary structure where savings takes a smaller share until your situation changes. When You Want to Save More Aggressively If you’re targeting an aggressive savings goal or paying down high-interest debt, you might shift toward something like: 70% Living / 25% Savings & Debt / 5% Personal The important thing is to create a budget that reflects your real circumstances. Irregular Income Freelancers and business owners may have variable monthly income. In that case, build a conservative budget based on a realistic baseline income and adjust when actual income is known. The principle remains the same: Use the 70/20/10 rule as a framework, not a rigid requirement.
Common 70/20/10 Budgeting Mistakes Mixing Everything Into “Living Expenses” and Losing Visibility Because 70% combines essential and discretionary spending, it’s easy to lose track of wants. Keep subcategories within living expenses so you can still see where the money goes. Forgetting Irregular Expenses Annual insurance, vehicle repairs, gifts, and other occasional costs can disrupt a monthly budget. Set aside space within a slice for predictable irregular expenses. Treating the Targets as a Pass/Fail Test Going over 70% one month is not failure. The value is in noticing the gap and adjusting. A rigid view makes budgeting discouraging and hard to maintain. Ignoring Actual Spending A budget is a plan. Your actual spending tells you whether the plan is working. Review it regularly instead of setting it once and never updating it. Making the Spreadsheet Too Complicated You don’t need dozens of categories and complex formulas to start. A simple system you update consistently is more useful than a complicated spreadsheet you abandon after two weeks.
Use a Ready-Made 70/20/10 Budget Planner Building a budgeting spreadsheet from scratch takes time, especially if you want automatic calculations and clear category tracking. A ready-made 70/20/10 Budget Planner provides a starting structure for organizing income and expenses. A practical template can include: Monthly income 70% living target 20% savings/debt target 10% investing/personal target Expense subcategories Budget vs. actual spending Remaining amounts Monthly summary You can then customize categories and percentages to fit your situation. The goal isn’t a perfect spreadsheet — it’s making your financial decisions easier to see and understand. For a similar ready-made structure you can adapt, the 50/30/20 Budget Planner starts with the same target-vs-actual layout. If you’d rather track every transaction in detail first, pair your budget with an Expense Tracker Template. Frequently Asked Questions What is the 70/20/10 budget rule? The 70/20/10 rule divides after-tax income into approximately 70% for living expenses, 20% for savings and debt repayment, and 10% for investing or personal goals. How do I calculate a 70/20/10 budget? Multiply your monthly after-tax income by 70%, 20%, and 10%. With $5,000 of income, that’s $3,500 for living, $1,000 for savings and debt, and $500 for investing or personal goals. How is 70/20/10 different from 50/30/20? The 70/20/10 rule combines needs and wants into a single 70% living category, then sets aside 20% for savings and debt and 10% for investing or personal goals. The 50/30/20 rule separates needs (50%) and wants (30%). 70/20/10 can suit people who prefer one living budget or face higher living costs. Can I use Excel for the 70/20/10 budget rule? Yes. Excel can calculate target amounts, categorize spending, compare budgeted and actual amounts, and track savings, debt, and investing over time. What if my living expenses are more than 70%? That’s common with high housing, transportation, or healthcare costs. The 70/20/10 rule is a guideline. Adjust the percentages to create a budget that reflects your actual situation. Conclusion: Make the 70/20/10 Rule Work for You The 70/20/10 budget rule gives you a simple structure for organizing your money: keep living costs manageable, prioritize savings and debt, and leave room for investing or personal goals. Using Excel makes the system easier to customize and maintain. You can calculate targets automatically, track actual spending, compare results, and adjust your plan from month to month. The goal isn’t to hit exactly 70%, 20%, and 10% every month. The goal is to understand where your money goes and whether your spending supports your financial priorities. If you want to get started quickly, use a 70/20/10 Budget Planner to organize your income, categorize expenses, compare budget vs. actual spending, and build a simple monthly budgeting system. You can also browse the full range of templates and guides at Use Office Toolkit. Download the free 70/20/10 Budget Planner and start organizing your monthly budget today.