Budget Spreadsheet Examples: Templates and Formulas

Budget spreadsheet examples range from a simple monthly income-and-expense list to zero-based, annual, and small-business budgets. For a basic monthly sheet, put expense amounts in B3:B12; with the illustrative figures below, =SUM(B3:B12) returns $3,960. Add take-home income above the expense list to see whether the plan leaves money unassigned or overspends.

What a budget spreadsheet tracks

A budget is a plan for money coming in and money going out over a chosen period. A spreadsheet makes that plan visible: categories keep spending understandable, and formulas can compare a target with what actually happened. A budget is useful even when estimates are imperfect; its purpose is to help organize decisions, not predict every transaction exactly.

Most personal budgets separate three kinds of figures:

Planned income: money expected during the month, such as take-home pay or regular side income.
Planned expenses: bills and spending categories, including irregular costs when appropriate.
Actual amounts: what was received or spent, entered from account activity or receipts.

A very simple sheet needs only planned amounts and a remaining balance. A more useful tracking sheet includes planned and actual columns, then calculates the difference. Be consistent about whether figures are before or after deductions: for a household spending plan, take-home pay is often easier to compare with bills than gross salary.

Example: a simple monthly household budget

This illustrative example uses one monthly income figure and ten expense categories. In a worksheet, put the category labels in column A and amounts in column B. Use these row assignments so the formulas below match the example:

Cell in column A	Illustrative monthly amount in column B
A2 Take-home income	$4,200
A3 Rent	$1,450
A4 Utilities	$220
A5 Groceries	$500
A6 Transport	$260
A7 Phone and internet	$100
A8 Insurance	$180
A9 Debt payment	$300
A10 Savings transfer	$500
A11 Dining	$250
A12 Miscellaneous	$200

With the expense amounts in B3:B12, enter =SUM(B3:B12) in B13. The expenses total $3,960: adding each of the ten listed amounts gives that result. With income in B2 and the total expenses in B13, enter =B2-B13 in B14; the illustrative remaining balance is $240. A positive balance means planned income exceeds the listed outflows, while a negative balance means planned spending is greater than the income entered.

That $240 is not automatically spare spending money. The example may omit annual bills, medical costs, gifts, or other priorities. It is a prompt to check whether all important categories are represented. Also, this example lists a savings transfer as an outflow, which makes the remaining balance the amount left after that planned transfer.

Useful formulas and how to read the results

Excel for Microsoft 365 on Windows can handle a basic budget with ordinary formulas. Keep amounts in numeric cells, use a consistent period such as monthly, and format money cells as currency with Home > Number Format. Labels should be in a separate column from amounts so totals do not accidentally include text.

With expenses in B3:B12, =SUM(B3:B12) in B13 totals the ten listed categories and returns $3,960 for the example.
With take-home income in B2 and total expenses in B13, =B2-B13 in B14 calculates the remaining balance and returns $240.
With the remaining balance in B14 and income in B2, =B14/B2 in B15 returns about 0.0571, or 5.7% when B15 is formatted as a percentage. This is the remaining balance as a share of income, not a measure of overall financial health.

These calculations depend on the stated cell layout; if rows are inserted or moved, check that the formula ranges still cover the intended amounts. Excel recalculates formulas when referenced cells change. If a total looks wrong, inspect the range and check that amounts were entered as numbers rather than text. The formula bar can help identify the cell reference currently selected.

Set up a planned-versus-actual budget

For ongoing tracking, use columns for category, planned amount, actual amount, and difference. For example, put category names in A2:A12, planned values in B2:B12, and actual values in C2:C12. In D2, type =B2-C2 and fill the formula down through D12. A positive result means actual spending is below the plan for an expense category; a negative result means it is above. For income categories, the interpretation is reversed, so it can be clearer to keep income in its own section.

Add a total row beneath the categories. With planned expenses in B2:B12 and actual expenses in C2:C12, use =SUM(B2:B12) for the planned total and =SUM(C2:C12) for the actual total. If the illustrative actual total is $4,050 and the planned total is $3,960, actual spending is $90 higher. That comparison is only meaningful if the two columns cover the same dates and categories.

Update actuals on a schedule that is realistic for you, such as weekly or after reviewing account activity. A budget that is updated occasionally can still reveal patterns, but delayed entries make it harder to spot a problem early. Do not treat a bank balance as the same thing as a category total: pending transactions, transfers, and timing differences can make them differ.

Annual and irregular-expense examples

A monthly budget can hide costs that arrive only a few times a year. A separate annual-expenses sheet can list each bill, its expected amount, due month, and a monthly set-aside estimate. For instance, if an illustrative car registration cost is $600 per year, divide that amount across twelve months rather than treating the due-month payment as a surprise.

With the annual amount of $600 entered in B2, =B2/12 in B3 returns $50 per month. The same approach can estimate a monthly amount for an annual membership or a recurring seasonal bill, as long as the yearly estimate is realistic. The calculation does not move money into an account; it only shows the monthly amount the plan would need to reserve.

For an irregular cost with no reliable annual total, use a reasonable estimate and revisit it after actual bills arrive. Separate known bills from an emergency reserve, because they serve different planning purposes. A spreadsheet can show when costs are due, but it cannot guarantee that the money will be available unless the plan and cash flow support it.

Zero-based and envelope-style budget examples

A zero-based budget assigns expected income to categories until planned income minus planned allocations equals zero. Zero does not mean spending every dollar on purchases: categories can include savings goals, debt payments, and reserves for future bills. The point is to give all expected income an intended destination rather than leave an unexplained remainder.

In the household example, the listed allocations total $3,960 against $4,200 of income, so $240 remains unassigned. A zero-based version would decide what that $240 is for, perhaps adding it to a relevant savings or future-cost category, then check that the allocations equal income. The choice depends on the household’s priorities and circumstances; the spreadsheet itself does not determine what is appropriate.

An envelope-style budget assigns limits to categories such as groceries or dining. In a spreadsheet, the planned amount acts like an envelope limit, and actual spending reduces the amount left in that category. Unlike a physical cash envelope, a spreadsheet does not prevent a card transaction from exceeding the limit. It is a tracking method, not a spending control built into a bank account.

How to choose a budget spreadsheet

Choose a format based on the question you want the budget to answer. A one-page monthly budget is easy to maintain and works well for a first overview. Planned-versus-actual columns are better when you want to identify categories that regularly differ from estimates. An annual planner is useful for bills that do not arrive monthly, while a zero-based layout makes every expected dollar’s assignment explicit.

Choose a simple list if you mainly need to see income, major bills, and what remains.
Choose a tracking sheet if you will enter actual spending and compare it with a plan.
Choose an annual view if irregular or seasonal bills make monthly totals misleading.
Choose a category-limit format if you want to monitor flexible spending such as groceries or entertainment.

Before committing to a template, check whether it uses weekly, biweekly, or monthly periods, and whether it distinguishes gross from take-home income. Look at how it handles transfers between your own accounts: counting both sides as income or spending can double-count money. A template with many charts may look polished but still be a poor fit if entering actuals takes too much time.

Common spreadsheet budgeting problems

Leaving out nonmonthly costs: annual renewals, school expenses, repairs, and seasonal bills can make a monthly plan look more generous than it is. Add a separate category or annual schedule instead of relying on memory.

Mixing dates or accounting periods: comparing a full month of planned expenses with only two weeks of actuals produces a misleading difference. Decide whether the budget follows calendar months or pay periods and label the dates clearly.

Double-counting transfers: moving money from checking to savings is not new income. If the transfer is recorded as a planned savings allocation, avoid also treating the same amount as a separate expense in a second section that feeds the total.

Using estimates as guarantees: utility bills, variable income, and unexpected costs can differ from the plan. Review estimates against actual figures and revise future months; do not quietly change the original plan if you want to understand the variance.

Overcomplicating the workbook: too many categories or formulas can make maintenance burdensome. Start with categories that support decisions, then split one only when the detail would change what you do. Keep a backup copy before making major structural changes, especially when a workbook contains several linked sheets.

Frequently Asked Questions

What should a basic budget spreadsheet include? Include the budget period, take-home income, expense categories, planned amounts, and a remaining-balance calculation. Add actual amounts if you want to compare the plan with what happened. Include irregular costs when they are relevant to your circumstances.

Is there a free budget spreadsheet in Excel? Excel may offer templates through its template gallery, and Microsoft availability can change over time. You can also create a basic workbook using the category-and-amount layout in this example. Check the template’s formulas and date periods before relying on its totals.

How do I make a budget spreadsheet calculate totals? Put numeric amounts in a continuous range and use Excel’s SUM function, such as =SUM(B3:B12) when the values to total are in B3:B12. Confirm the range includes the intended rows and excludes unrelated figures.

Should savings count as an expense in a budget? It depends on the layout. You can show a planned savings transfer as an allocation alongside expenses so the remaining balance reflects money after that transfer. Alternatively, show savings separately from spending, but make the method clear to avoid double-counting.

How often should I update a budget spreadsheet? Choose a routine you can sustain. Weekly updates can make flexible spending easier to monitor, while a monthly review may be enough for a broad plan. Reconcile the period and categories before drawing conclusions from planned-versus-actual differences.

Spreadsheet examples are for organization and illustration, not financial, tax, investment, or legal advice. Check real account, loan, and bill terms with the relevant provider, lender, or a qualified professional when needed.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.