Google Sheets Budget Template: Build One in 20 Minutes

Short answer: you can build a Google Sheets budget template in about 20 minutes with two tabs, one for planned amounts and one for transactions, plus three formulas: SUM to total, SUMIF to add up a category, and a subtraction for what is left. A $4,000 monthly budget might assign $1,200 to housing, $520 to food, $600 to savings and the rest across other lines until the plan equals income.

Key takeaways

• Two tabs are enough: a Plan tab (what you intend) and a Transactions tab (what happened).
• Three formulas do the work: SUM, SUMIF and a difference column. Everything else is formatting.
• A good budget assigns every dollar. The plan equals your income, and the "left to assign" cell shows zero.
• Share the sheet with a partner and agree who updates it and when.

What goes in the Plan tab?

List income at the top, then your categories with a planned amount, a share of income, the actual amount spent and the difference. Here is a filled-in example for $4,000 of monthly take-home pay:

For the thinking behind the categories, see how to make a budget. Families can compare with the family budget planner.

Which formulas do you need?

Cell references depend on where you place the table, so adjust them to your layout.

What goes in the Transactions tab?

Three columns: Date, Amount and Category. Add one row per purchase or paste a month of bank export and add a category to each row. The SUMIF formula on the Plan tab reads this tab, so the actuals update by themselves. Use a drop-down list for the category column (Data, then Data validation, then a range of your category names) so spelling stays consistent. If you have a CSV from your bank, MoneyFrame's spreadsheet import can also read income, spending and goals from a file.

How do you build it in 20 minutes?

1. Minutes 1 to 3: create a new sheet, name the tabs Plan and Transactions.
2. Minutes 4 to 8: write your income and your categories on the Plan tab. Start from the table above and rename lines to fit.
3. Minutes 9 to 12: add the formulas, then check that "left to assign" shows zero.
4. Minutes 13 to 16: set up the Transactions tab and the category drop-down.
5. Minutes 17 to 20: add conditional formatting so negative differences turn red, and pin the top row.

How do you use it every month?

• Day 1: copy the Plan tab, rename it for the month and update income and amounts.
• Weekly: five minutes to add transactions and glance at the differences.
• End of month: compare planned and actual, and move any leftover to a goal. See where does my money go for how to spot leaks.
• Each quarter: adjust the plan for new bills or goals.

How do you share it with a partner?

Use Share and give your partner Editor access. Agree who adds transactions, who reviews, and a monthly check-in. See how to split bills with a partner and the money date night agenda. Protect the formulas by locking the cells that contain them (Data, then Protect sheets and ranges).

If you would rather not maintain it, the free Is my goal realistic? sheet checks whether a goal fits your monthly free money, and the YNAB alternative guide compares apps.

What mistakes break a budget sheet?

• Too many categories. Past twelve, upkeep becomes a chore. Merge small lines.
• Planning to the penny. Include an "other and buffer" line, as in the example, so a surprise does not wreck the month.
• Forgetting irregular bills. Annual insurance, gifts and repairs need a sinking fund line. A $1,200 yearly bill is $100 a month. See sinking funds.
• Mixing planned and actual in one column. Keep them apart so you can see the difference.
• Never reviewing. A sheet nobody opens is a decoration. Set a calendar reminder.

How do you adapt the sheet for your situation?

Sources and further reading: the Consumer Financial Protection Bureau has free budgeting worksheets.

General education, not financial advice. Reviewed October 2026. The budget amounts are an example, and formula cell references depend on how you lay out your sheet.

Frequently asked questions