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.
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. | |||||||
| Category | Group | Budget | Actual | Difference (+ favorable) | % of income, budget | % of income, actual | Notes |
| Income | |||||||
| Take-home pay | Income | $5,400 | $5,400 | $0 | After tax, per month | ||
| Side income | Income | $300 | $240 | -$60 | Freelance and other work | ||
| Total income | $5,700 | $5,640 | -$60 | ||||
| Expenses | |||||||
| Housing | Needs | $1,650 | $1,650 | $0 | 28.9% | 29.3% | Rent or mortgage payment |
| Utilities | Needs | $230 | $252 | -$22 | 4.0% | 4.5% | Electricity, gas, water and trash |
| Groceries | Needs | $600 | $712 | -$112 | 10.5% | 12.6% | |
| Transportation | Needs | $380 | $418 | -$38 | 6.7% | 7.4% | Fuel, transit, parking and car upkeep |
| Insurance | Needs | $290 | $290 | $0 | 5.1% | 5.1% | Health, car, and renters or home insurance |
| Phone and internet | Needs | $120 | $118 | $2 | 2.1% | 2.1% | |
| Healthcare | Needs | $90 | $145 | -$55 | 1.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.
| 50/30/20 rule check | |||||||
| Compares actual spending with the 50/30/20 split of income. Targets come from the rule table and are looked up by group name. | |||||||
| Rule table (inputs) | |||||||
| Group | Target share of income | ||||||
| Needs | 50% | ||||||
| Wants | 30% | ||||||
| Savings and debt | 20% | ||||||
| Total of targets | 100% | Targets add up to 100% | |||||
| On-target tolerance (plus or minus points) | 2.0% | ||||||
| Check against the Budget tab | |||||||
| Group | Target share | Budget | Actual | Budget share | Actual share | Actual minus target | Status |
| Needs | 50% | $3,360 | $3,585 | 58.9% | 63.6% | 13.6% | Over target |
| Wants | 30% | $740 | $848 | 13.0% | 15.0% | -15.0% | Under target |
| Savings and debt | 20% | $1,100 | $1,100 | 19.3% | 19.5% | -0.5% | On target |
Showing the first 16 of 20 rows and 8 of 8 columns. Cells with formulas show the formula on hover.
| Monthly household budget |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| A monthly household budget with income, expenses by category, budget and actual amounts, the difference for each line, and each line as a share of income. A second tab checks how spending splits into needs, wants, and savings and debt agai… |
| How to use it |
| 1. Replace the example income lines with your take-home pay and other income for a typical month. |
| 2. Rename the expense categories to fit your household, and set the group for each one: Needs, Wants or Savings and debt. |
| 3. Type the planned amount in the Budget column and the amount you actually spent in the Actual column. |
| 4. Read the Difference column (positive means under budget) and the left-over line at the bottom. |
| 5. Open the Rule check tab to see how each group compares with its 50/30/20 target. Change the targets in the rule table if your plan differs. |
| Formulas and method |
| Total income = sum of the income lines. Total expenses = sum of the expense lines. |
| Difference: for expenses, budget minus actual; for income, actual minus budget. Positive is favorable in both cases. |
Showing the first 16 of 31 rows and 1 of 1 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?
| Tab | What it holds |
|---|---|
| Budget | Income and expense lines with budget, actual, difference, share of income and the left-over line. |
| Rule check | The 50/30/20 rule table, group totals from the Budget tab and the on-target status for each group. |
| Notes | Purpose, 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.
| Function | Uses | What it does |
|---|---|---|
IF | 52 | one result when a test is true, another when false |
SUM | 10 | adds numbers |
SUMIF | 8 | adds values meeting one condition |
ABS | 6 | absolute value |
VLOOKUP | 3 | looks a value up in a column |
AND | 1 | true 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?
- Enter take-home pay and other income for a typical month on the Budget tab.
- Rename the expense categories and set the group for each one.
- Type the planned amount and the amount you spent in the Budget and Actual columns.
- Read the difference, the left-over line and the share of income for each line.
- 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.