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.
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.
| Month | Income | Spending | Saving & investing | Left over | Savings rate | Emergency fund |
|---|---|---|---|---|---|---|
| Jan | $4,200 | $2,960 | $950 | $290 | 22.6% | $4,300 |
| Feb | $4,500 | $2,965 | $950 | $585 | 21.1% | $4,600 |
| Mar | $4,200 | $2,960 | $950 | $290 | 22.6% | $4,900 |
| Apr | $4,450 | $2,925 | $1,050 | $475 | 23.6% | $5,200 |
| May | $4,200 | $3,045 | $950 | $205 | 22.6% | $5,500 |
| Jun | $4,200 | $2,960 | $950 | $290 | 22.6% | $5,800 |
| Jul | $4,600 | $3,910 | $950 | −$260 | 20.7% | $6,100 |
| Aug | $4,200 | $3,025 | $950 | $225 | 22.6% | $6,400 |
| Sep | $4,200 | $2,945 | $950 | $305 | 22.6% | $6,700 |
| Oct | $4,550 | $2,940 | $1,050 | $560 | 23.1% | $7,000 |
| Nov | $4,200 | $3,105 | $950 | $145 | 22.6% | $7,300 |
| Dec | $5,400 | $3,620 | $950 | $830 | 17.6% | $7,600 |
| Year | $52,900 | $37,360 | $11,600 | $3,940 | 21.9% | $7,600 |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, definitions, limits, disclaimer |
| Budget | Year, 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 |
| Dashboard | Nothing | Year 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 Dashboard | Already filled | A fictional household's 2027 budget |
How to use it
- 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).
- 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.
- Fill fixed costs, then variable costs. Bank and card statements from the last few months are the quickest source.
- Enter what you move to the emergency fund, retirement, a brokerage account, crypto, extra debt repayment and other goals.
- Check the 50/30/20 tag on each line. A gym membership can be a Want for one person and a Need for another.
- 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.
- Each month, overwrite the plan with what really happened and compare.
What official budgeting guides say
- Consumer.gov (FTC): "A budget is a plan you write down to decide how you'll spend your money each month." Its method: "Subtract your monthly bills and expenses from how much money you make in a month." That is the Left over row.
- The CFPB spending tracker suggests tracking spending "for a day, a week, two weeks, or a month" first. Its cash flow budget goes further: it "is all about tracking the timing of your income and expenses to make sure you have enough from week to week." This template is monthly; if bills cluster before payday, use the CFPB's weekly tool as well.
- MoneyHelper (UK) suggests you "have three to six months' essential outgoings available in an instant access savings account." The Dashboard measures your fund in exactly that unit: months of Need costs.
- The SEC's Ten Things to Consider Before You Make Investing Decisions includes "Create and maintain an emergency fund", noting that "Most smart investors put enough money in a savings product to cover an emergency, like sudden unemployment."
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).
| Field | Formula |
|---|---|
| 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
| Bucket | Total | % of income | Rule of thumb | Rule amount | Difference |
|---|---|---|---|---|---|
| Needs | $30,890 | 58.4% | 50% | $26,450 | $4,440 |
| Wants | $6,470 | 12.2% | 30% | $15,870 | −$9,400 |
| Saving and extra debt repayment | $11,600 | 21.9% | 20% | $10,580 | $1,020 |
| Not in a bucket (left over) | $3,940 | 7.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
- Budgeting gross pay. Use take-home pay, after tax and payroll deductions, or the savings rate will look too low.
- Forgetting yearly and irregular costs. Insurance, gifts, car repairs and holidays break a monthly-only plan. Put them in the month they happen.
- Treating investing as "whatever is left". Put the contribution in as a line, like a bill. The Left over row then shows what is truly spare.
- Investing money you may need soon. The emergency fund row tracks cash for surprises separately from investments that can fall in value.
- Counting a 401(k) or pension twice. If it comes out of pay before you see it, add it to income and to the Retirement line, or to neither.
- Never updating it. Replace the plan with what actually happened each month.
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
- Emergency fund trackerTarget, months to goal and log
- Net worth trackerAssets, debts and net worth over time
- DCA trackerLog the monthly investing from your budget
- DCA calculatorProject a regular investing plan
- Compound interest calculatorGrowth with regular deposits
- Net worth percentile calculatorSee where your net worth ranks
- Investment policy statementWrite down your investing rules
- All templatesFree spreadsheets
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.