Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBudgeting & Expense ManagementHousehold Monthly Budget

SpreadsheetBudgeting & Expense ManagementFree

Household Monthly Budget

Plan by category, log spending, and see planned vs actual, what is left and your 50/30/20 split update live.

Shown with sample data

Colour

Household Monthly Budget

Plan by category, log spending, and see planned vs actual, what is left and your 50/30/20 split update live.

Income received
$4,550
Spent so far
$2,947
Needs and wants
Left to spend
$372.92
Planned spending and saving not yet used
Savings rate
21%
Saved or paid down, as a share of income
Spending by category
  • Rent / mortgage$1,450
  • Groceries$518.55
  • Emergency fund$400
  • Extra debt payment$300
  • Retirement$250
  • Utilities$183.05
  • Insurance$180
  • Entertainment$124
Needs, wants and savings
  • Needs$2,557.2066%
  • Savings & debt$95024%
  • Wants$389.8810%

How to use it

  1. 1On the Budget sheet, enter your expected income and a planned amount for each category. Rename or add categories to fit your life.
  2. 2Log every transaction on the Transactions sheet: date, description, category from the list and amount. The group fills in for you.
  3. 3Watch Left and % used on the Budget sheet; a category turns amber at 90% and red when it goes over.
  4. 4Check the 50/30/20 sheet to see whether needs, wants and savings are in a healthy balance.
  5. 5Next month, make a copy, delete the transactions and adjust the plan.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A complete monthly budget that works the way the best budgeting spreadsheets do. Plan each category once, log transactions as you spend, and every category shows actual spending, what is left and how much of its budget is used, with a warning before you overspend. Each transaction is grouped automatically, and a 50-30-20 check compares your real needs, wants and savings with the classic rule.

Who it’s for

  • Households planning a month of spending
  • Moving from a bank app or notes to a real budget
  • Couples who want one shared view of money
  • Checking spending against the 50/30/20 rule

What’s included

  • Budget sheet: Planned vs actual for every category, with what is left.
  • Transactions sheet: Every payment in and out this month.
  • 50-30-20 check sheet: Your real split of needs, wants and savings against the 50/30/20 guideline.

How to use it

  1. 1On the Budget sheet, enter your expected income and a planned amount for each category. Rename or add categories to fit your life.
  2. 2Log every transaction on the Transactions sheet: date, description, category from the list and amount. The group fills in for you.
  3. 3Watch Left and % used on the Budget sheet; a category turns amber at 90% and red when it goes over.
  4. 4Check the 50/30/20 sheet to see whether needs, wants and savings are in a healthy balance.
  5. 5Next month, make a copy, delete the transactions and adjust the plan.

Tips

  • Budget irregular costs (car service, gifts, annual subscriptions) as a monthly amount so they never surprise you.
  • Log spending every few days; five minutes a week keeps the budget accurate.
  • Pay yourself first: plan savings as a category, not whatever is left over.

Questions

How do I add a category?

Add a row on the Budget sheet with its group, then add the same name to the Category list on the Transactions sheet. Totals, the 50-30-20 check and charts pick it up automatically.

What does 50/30/20 mean?

A guideline: about 50% of take-home pay on needs (housing, bills, groceries), 30% on wants and 20% on savings and extra debt payments. Use it as a check, not a rule.

Does it work with irregular income?

Yes. Plan a conservative income, log each payment as it arrives, and the figures always use the income you actually received.

Related searchesbudgetmonthly budgetpersonal financehouseholdplanned vs actual50/30/20 budgetfamily budget

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBudgeting & Expense ManagementFree

Household Monthly Budget

Plan by category, log spending, and see planned vs actual, what is left and your 50/30/20 split update live.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Budgeting & Expense Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More budgeting & expense management templates

View all
50/30/20 Budget3 sheets

Total planned

$3,992

Left unallocated

$308

Planned spending by group
63%
  • Needs
  • Savings
  • Wants
SpreadsheetBudgeting & Expense Management

50/30/20 Budget

Split take-home pay into needs, wants and savings, and see how your real spending compares with the rule.

10 min setupPreview
Zero-Based Budget4 sheets

Income this month

$4,980

Left to assign

$0

Spent so far

$3,645

Income by group
63%
  • Essentials
  • Debt
  • Savings
  • Lifestyle
SpreadsheetBudgeting & Expense Management

Zero-Based Budget

Give every dollar a job: assign income until "left to assign" is zero, then track spending against each line.

10 min setupPreview
Annual Budget Planner2 sheets

Planned income

$58,500

Planned spending

$41,810

Saved for the year

$9,300

Spending by month
$4,870
$4,860
$4,100
$3,740
$3,150
DecJunAprJulNov
SpreadsheetBudgeting & Expense Management

Annual Budget Planner

Plan a full year month by month and see net savings, the tight months and your savings rate.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ