Template · Budgeting

Monthly household budget (budget vs actual)

Budget and actual spending by category, the difference for each line and a 50/30/20 check.

Create a free account to download

This sheet is a free sample: any confirmed account can download it. XLSX, ODS and XML keep formulas; CSV and Numbers contain values only.

XLSXCSVODSXMLNumbers
Monthly household budget
Example data — replace the blue input cells with your own.
Group feeds the 50/30/20 check on the Rule check tab. Difference is positive when you are under budget or earn more than planned.
CategoryGroupBudgetActualDifference (+ favorable)% of income, budget% of income, actualNotes
Income
Take-home payIncome$5,400$5,400$0After tax, per month
Side incomeIncome$300$240-$60Freelance and other work
Total income$5,700$5,640-$60
Expenses
HousingNeeds$1,650$1,650$028.9%29.3%Rent or mortgage payment
UtilitiesNeeds$230$252-$224.0%4.5%Electricity, gas, water and trash
GroceriesNeeds$600$712-$11210.5%12.6%
TransportationNeeds$380$418-$386.7%7.4%Fuel, transit, parking and car upkeep
InsuranceNeeds$290$290$05.1%5.1%Health, car, and renters or home insurance
Phone and internetNeeds$120$118$22.1%2.1%
HealthcareNeeds$90$145-$551.6%2.6%Prescriptions, copays and dental

Showing the first 16 of 30 rows and 8 of 8 columns. Cells with formulas show the formula on hover.

What does this template do?

A monthly household budget for planning and checking spending. Each income and expense line has a budget and an actual amount, the difference between them, and its share of income. The Difference column is positive when a line is under budget or income is above plan, so a good result reads the same way in every row.

Expenses are grouped as Needs, Wants, or Savings and debt. The Rule check tab looks up each group's target from a 50/30/20 rule table with VLOOKUP, totals the actual spending for each group with SUMIF, and shows whether the group is on target, over or under. The targets and the on-target tolerance can be changed.

The example figures are fictional and show how the sheet reads. The 50/30/20 split is a guideline, not a requirement, and nothing in the workbook is financial advice.

What’s inside

  • Budget, actual, difference and share of income for every line
  • Difference is positive when a line is under budget, for income and spending alike
  • Needs, Wants and Savings and debt groups with a 50/30/20 check
  • VLOOKUP targets and SUMIF group totals, with a tolerance for the on-target status
  • Left-over line, and the savings and debt share of income

Which tabs does the workbook have?

TabWhat it holds
BudgetIncome and expense lines with budget, actual, difference, share of income and the left-over line.
Rule checkThe 50/30/20 rule table, group totals from the Budget tab and the on-target status for each group.
NotesPurpose, steps, formulas used, assumptions and limits.

What formulas does this template use?

This template holds 98 formulas in 254 cells across 3 tabs, so 39% of its cells calculate. They use 6 distinct functions; the longest formula is 107 characters and 15 of them read from another tab.

FunctionUsesWhat it does
IF52one result when a test is true, another when false
SUM10adds numbers
SUMIF8adds values meeting one condition
ABS6absolute value
VLOOKUP3looks a value up in a column
AND1true when every test is true

Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.

How do you use it?

  1. Enter take-home pay and other income for a typical month on the Budget tab.
  2. Rename the expense categories and set the group for each one.
  3. Type the planned amount and the amount you spent in the Budget and Actual columns.
  4. Read the difference, the left-over line and the share of income for each line.
  5. Open the Rule check tab to compare each group with its 50/30/20 target.

What is it good for?

  • Setting a monthly budget for a household for the first time
  • Checking where the money went at the end of each month
  • Seeing whether needs, wants and savings match a 50/30/20 split
  • Comparing two months of spending by changing the actual column

Questions about this sheet

What does the 50/30/20 rule say?

It is a budgeting guideline: about half of after-tax income for needs, about 30% for wants, and about 20% for savings and debt repayment. The Rule check tab lets you change those targets.

Why is the difference positive for some lines?

Positive always means favorable. For an expense, budget minus actual is positive when you spent less than planned. For income, actual minus budget is positive when you earned more.

How do I include irregular bills?

Divide an annual bill by 12 for a monthly budget, or enter it in the month you pay it and note that in the Notes column.

Can I add more categories?

Yes. Insert rows inside the expense block, copy the formulas from the row above, and set the group so the Rule check includes the new row.