Home › Templates › Budget spreadsheet

Budget Spreadsheet for Investors

A free 12-month budget spreadsheet that tracks income, fixed and variable costs, and what you put into saving and investing, then shows your savings rate, how many months your emergency fund covers, and how your spending compares with the 50/30/20 rule.

Download Excel template (.xlsx) 36 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 27 Oct 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no bank connection, no add-on. Amounts work in any currency.

Preview: Example Dashboard, 12-month view for a fictional household in 2027 (all amounts made up).
MonthIncomeSpendingSaving & investingLeft overSavings rateEmergency fund
Jan$4,200$2,960$950$29022.6%$4,300
Feb$4,500$2,965$950$58521.1%$4,600
Mar$4,200$2,960$950$29022.6%$4,900
Apr$4,450$2,925$1,050$47523.6%$5,200
May$4,200$3,045$950$20522.6%$5,500
Jun$4,200$2,960$950$29022.6%$5,800
Jul$4,600$3,910$950−$26020.7%$6,100
Aug$4,200$3,025$950$22522.6%$6,400
Sep$4,200$2,945$950$30522.6%$6,700
Oct$4,550$2,940$1,050$56023.1%$7,000
Nov$4,200$3,105$950$14522.6%$7,300
Dec$5,400$3,620$950$83017.6%$7,600
Year$52,900$37,360$11,600$3,94021.9%$7,600
Example Dashboard, fictional household: income, spending and saving and investing by month in 2027. Year totals: income $52,900, spending $37,360, saving and investing $11,600.$0$2,000$4,000$6,000JFMAMJJASONDIncomeSpendingSaving & investing

Chart: the native column chart on the Example Dashboard tab, redrawn from the same recalculated values. July includes a $900 holiday; December includes a $1,200 bonus.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, definitions, limits, disclaimer
BudgetYear, emergency fund balance at the start, target in months; 12 monthly amounts for 4 income lines, 8 fixed costs, 9 variable costs and 6 saving and investing lines; a Need / Want / Saving tag per line (dropdown)Year total and monthly average per line; per month: total income, spending, saving and investing, left over, savings rate, amount invested, needs, wants, saving, each as % of income, emergency fund balance and months covered
DashboardNothingYear at a glance, emergency fund target and gap, a 50/30/20 comparison, a 12-month table, a column chart and an emergency fund line chart
Example / Example DashboardAlready filledA fictional household's 2027 budget

How to use it

  1. On Budget, type the year, your emergency fund balance today and a target in months of essential costs (the file starts at 3; set your own).
  2. Enter take-home income for each month. If a pension or 401(k) contribution leaves your pay before it reaches you, either add it to income and to the Retirement line, or leave it out of both.
  3. Fill fixed costs, then variable costs. Bank and card statements from the last few months are the quickest source.
  4. Enter what you move to the emergency fund, retirement, a brokerage account, crypto, extra debt repayment and other goals.
  5. Check the 50/30/20 tag on each line. A gym membership can be a Want for one person and a Need for another.
  6. Open Dashboard. Aim for "Left over" near zero, so every unit of income has a job. A negative month means you spent or saved more than came in.
  7. Each month, overwrite the plan with what really happened and compare.

What official budgeting guides say

Why the emergency fund row matters

In the Federal Reserve's Economic Well-Being of U.S. Households in 2025 report (May 2026), "Sixty-three percent of adults said they would cover a hypothetical $400 emergency expense exclusively using cash, savings, or a credit card paid off at the next statement." It also found that "55 percent of adults said they had set aside money for three months of expenses in an emergency savings or 'rainy day' fund." The survey covered nearly 13,000 adults in October 2025.

The formulas, explained

Exact formulas from the Budget tab, January column (D). Line items sit in rows 10–42; months run from D (January) to O (December).

FieldFormula
Total income (row 45)=SUM(D10:D13)
Total spending (48) = fixed + variable=D46+D47
Left over (50)=D45-D48-D49
Savings rate (51)=IF(D45>0,D49/D45,"")
Invested (52)=D38+D39+D40 (retirement + brokerage + crypto)
Needs (53)=SUMIFS(D$16:D$42,$C$16:$C$42,"Need")
Emergency fund balance (59)=N($C$5)+D37, then =N(D59)+E37 for February
Emergency fund in months (60)=IF(D53>0,D59/D53,"")
Monthly average of a line (Q)=IF($C$62>0,P10/$C$62,""), where C62 counts months with income entered
Dashboard: target amount=IF(N(B12)>0,B15*B12,"") = target months × average monthly needs

Worked example from the sample data

The fictional household takes home $4,200 a month, plus side income in four months and a $1,200 bonus in December: $52,900 for the year. Spending is $37,360, and $11,600 goes to saving and investing, so the savings rate is $11,600 ÷ $52,900 = 21.9%. Of that, $7,800 is invested ($350 retirement, $250 index funds and $50 crypto each month). $3,940 is left over and not yet allocated.

July shows why a 12-month view helps: a $900 holiday pushes spending to $3,910 and left over to −$260, even though the monthly plan looked fine.

Emergency fund

The fund starts at $4,000 and gets $300 a month, ending at $7,600. Average monthly needs are $2,574, so the fund covers 3.0 months. The target of 3 months is $7,722, which leaves $122 to go.

50/30/20 comparison

BucketTotal% of incomeRule of thumbRule amountDifference
Needs$30,89058.4%50%$26,450$4,440
Wants$6,47012.2%30%$15,870−$9,400
Saving and extra debt repayment$11,60021.9%20%$10,580$1,020
Not in a bucket (left over)$3,9407.4%

Needs take 58.4% of income, above the 50% guide, mostly because rent is $1,450. Wants are well below 30%, and saving is above 20%. The rule does not say this is wrong; it shows where the money goes so you can decide.

The 50/30/20 rule in one paragraph

Elizabeth Warren and Amelia Warren Tyagi set out the split in their 2005 book All Your Worth: roughly 50% of after-tax income for needs (housing, utilities, insurance, groceries, minimum debt payments), 30% for wants, and 20% for savings and paying down debt faster. It is a rough guide. The template lets you tag each line yourself and shows the gap in money, not just percentages.

Common mistakes

FAQ

How do I make a budget spreadsheet?

List your monthly take-home income, then your fixed costs (rent, insurance, minimum debt payments), your variable costs (groceries, fuel, eating out) and what you move to saving and investing. Total each group with SUM, subtract spending and saving from income, and repeat for 12 months so irregular costs show up. The free template on this page has these rows, the formulas and a dashboard.

What is the 50/30/20 budget rule?

A rule of thumb from Elizabeth Warren and Amelia Warren Tyagi's 2005 book All Your Worth: about 50% of after-tax income for needs, 30% for wants and 20% for savings and extra debt repayment. It is a starting point, not a requirement. In high-rent areas needs often take more than half; the template shows your own split next to the rule.

How much should I have in an emergency fund?

There is no single number. MoneyHelper (UK) suggests three to six months' essential outgoings in an instant access account. The SEC's investor guide notes that some investors keep up to six months of their income in savings. The template converts your balance into months of your own essential costs.

What is a good savings rate?

It depends on your income, goals and age, so there is no official benchmark. The 50/30/20 rule points to about 20% of take-home pay for saving and extra debt repayment. The template calculates your savings rate each month as saving and investing divided by take-home income.

Should I build an emergency fund before investing?

The SEC's "Ten Things to Consider Before You Make Investing Decisions" lists creating and maintaining an emergency fund as one of the steps, noting that most smart investors put enough money in a savings product to cover an emergency, like sudden unemployment. The budget lets you plan both: an emergency fund deposit line and separate investing lines.

Can I use this budget spreadsheet in Google Sheets?

Yes. In Google Sheets choose File > Import > Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. It uses only SUM, SUMIFS, COUNTIF, IF, N, MAX and DATE, and has no macros.

Related tools and templates

Educational template only, not financial, tax or investment advice. Example data is fictional: the household, every amount and the year are made up. Investing involves risk, including loss of the money you invest. Quotes from Consumer.gov, the CFPB, MoneyHelper, the SEC and the Federal Reserve were retrieved on 27 October 2026.