Budget Spreadsheet Sample: Monthly Template and Formulas

Formulas & functions · Updated November 21, 2026

A useful budget spreadsheet sample has columns for each category’s planned amount, actual amount, and difference, plus totals for income, spending, and cash left over. In Excel for Microsoft 365 on Windows, you can build one with the layout and formulas below, then replace the illustrative figures with your own.

A Monthly Budget Spreadsheet Sample

This example uses one month of take-home income and ordinary household spending. The amounts are illustrative, not recommendations; categories and costs vary by household. Enter labels in column A, planned amounts in column B, actual amounts in column C, and the difference in column D.

Row Category Planned Actual Difference
4 Take-home pay $4,200 $4,200 $0
5 Other income $100 $0 —
6 Total income $4,300 $4,200 —
9 Rent $1,250 $1,250 $0
10 Utilities $180 $195 -$15
11 Groceries $500 $540 -$40
12 Transport $300 $275 $25
13 Insurance $160 $160 $0
14 Debt payments $250 $250 $0
15 Savings allocation $500 $500 $0
16 Dining out $250 $310 -$60
17 Personal and household $200 $175 $25
19 Total outflow $3,590 $3,655 -$65
21 Cash after listed outflows $710 $545 —

Rows 1–2 can hold a title and the month, while rows 3 and 8 can label the income and expense sections. Leave row 7 and row 18 blank for readability. “Cash after listed outflows” is the difference between income and the amounts assigned to expenses and savings in this sample. It is not necessarily the balance in a bank account: pending transactions, other bills, and timing can change that balance.

How the Columns and Categories Work

Planned is the amount you expect or choose to allocate before or during the month. Actual is what happened, based on transactions recorded for that period. Difference makes the comparison visible. For expense rows, this sample defines difference as planned minus actual: a positive amount means spending was below plan, while a negative amount means it went over. Keep that convention consistent and label the column clearly.

Income is shown separately because its variance has the opposite interpretation: actual income above plan is generally a positive difference. You can leave income differences blank, as the sample does, or calculate them separately using actual minus planned. Avoid mixing income and expenses in one difference column unless the sign convention is explained.

Useful categories are specific enough to guide decisions but not so detailed that recording transactions becomes a chore. A starter list might include:

  • Income: wages, benefits, freelance work, or other regular receipts.
  • Recurring essentials: housing, utilities, insurance, and subscriptions.
  • Variable essentials: groceries, transport, and household supplies.
  • Financial allocations: debt payments and savings contributions.
  • Flexible spending: dining out, hobbies, clothing, and personal purchases.

Whether savings belongs under “outflow” depends on what you want the sheet to show. Including a planned savings contribution makes the budget a plan for allocating income; it does not mean the money was consumed. If you want to distinguish spending from transfers, add a separate savings section and show both “expenses” and “savings” before calculating the unallocated balance.

Formulas for Totals and Differences

Type the labels and figures into the sample cells first. With planned income in B4:B5 and actual income in C4:C5, enter these formulas in B6 and C6. Planned income totals $4,300; actual income totals $4,200.

=SUM(B4:B5)

=SUM(C4:C5)

For the expense comparison, with planned expenses in B9:B17 and actual expenses in C9:C17, enter the following formulas in B19 and C19. They return $3,590 and $3,655, respectively.

=SUM(B9:B17)

=SUM(C9:C17)

With planned amounts in B9:B17, actual amounts in C9:C17, and the difference column in D, enter this formula in D9, then fill it down through D17. The rent row returns 0; the utilities row returns -15. A negative value signals actual spending above plan under this convention.

=B9-C9

With total planned income in B6 and planned outflows in B19, enter this formula in B21. It returns $710 ($4,300 minus $3,590). With actual income in C6 and actual outflows in C19, enter the second formula in C21. It returns $545 ($4,200 minus $3,655).

=B6-B19

=C6-C19

These are ordinary Excel formulas and work in Microsoft 365 for Windows, Mac, and Excel for the web. On Windows, use the AutoSum button on the Home tab or press Alt+= to insert a SUM formula when appropriate. On Mac, the equivalent shortcut is Command+Shift+T. Check the selected range before accepting a suggested total; a spreadsheet cannot know which rows you intended to include.

Build and Format the Sheet in Excel

  1. Open a blank workbook and enter the month and section labels. Put the planned and actual headings in columns B and C, and the difference heading in D.
  2. Enter categories and planned amounts, leaving actual amounts empty until you have transactions to record. Use a consistent unit, such as dollars, throughout.
  3. Add the total and difference formulas in the cells described above. To copy D9 down, select the cell and drag its fill handle, or copy and paste it into D10:D17.
  4. Format amount cells as currency or number with two decimal places if cents matter. Select the relevant cells, then choose Home > Number and select a number format.
  5. Make headings easy to scan with bold text, borders, or a fill color. Consider freezing the top rows if the sheet grows long: select the row below the rows to keep visible, then choose View > Freeze Panes > Freeze Panes.

Keep the input areas distinct from formulas—for example, use one fill color for cells you type into and another for calculated totals. This makes it easier to avoid accidentally replacing a formula with a number. Excel for Mac has similar formatting and freeze-pane options, although ribbon placement can differ slightly by version; Excel for the web also provides the core number-formatting and formula features.

Choose a Time Period and Tracking Method

A monthly sheet is a practical starting point when bills and income are mostly monthly. A weekly or pay-period view can be more useful if income arrives on an irregular schedule or if you need to manage the timing of bills. One option is to keep a transaction log on a second worksheet, with columns for date, description, category, and amount, then summarize those entries by category. That gives you a record of what makes up each actual total instead of relying on memory.

Choose one rule for the date a transaction belongs to. A spending plan may track purchases by the transaction date, while a cash-flow view may focus on when money leaves or enters an account. Credit-card purchases can be counted when made, with the later card payment treated as paying the balance rather than a second purchase. Whichever method you use, avoid counting the same purchase twice.

Update the sheet on a regular schedule, such as once a week, and reconcile totals against statements or receipts when available. Waiting until the end of the month makes small purchases easier to overlook. If you share a household, agree on categories and whether figures are entered before or after refunds, reimbursements, and transfers.

How to Choose a Budget Spreadsheet

A blank workbook offers control and transparency, but it requires setup and upkeep. A ready-made Excel template can save time, though its categories, formulas, and assumptions should be checked before you rely on its totals. A budgeting app may import transactions or provide reports, but its capabilities, data handling, and possible fees vary. Choose the format you are likely to maintain, not simply the one with the most features.

Before adopting a template, check whether formulas cover every row, whether totals include income and spending separately, and whether the period matches your needs. Look for hidden rows or sheets and inspect formulas in total cells. If a downloaded workbook contains macros, only enable them if you trust the source and understand why they are needed. A basic monthly budget does not require macros.

For a simple personal budget, one sheet with planned, actual, and difference columns is often enough. If you need to review several months, create a separate sheet for each month or use a transaction table with a date field. Separate monthly sheets are easy to understand, while a single transaction log can make trends and category summaries easier to compare. The trade-off is that a more elaborate workbook needs more careful setup.

Common Problems and Useful Checks

  • Missing transactions: Actual spending looks artificially low if cash purchases or automatic renewals are omitted. Review statements and receipts when updating.
  • Inconsistent categories: Recording similar purchases under different labels makes comparisons less useful. Keep a short category list and apply it consistently.
  • Wrong total range: A SUM formula can omit newly added rows or include a heading. Confirm the referenced cells whenever you insert or move rows.
  • Confusing a transfer with spending: Moving money between accounts is not necessarily a new expense. Decide how transfers and savings allocations should appear so they are not double-counted.
  • Treating a plan as a prediction: A planned amount is a working estimate, not a guarantee. Adjust future months when bills, income, or priorities change, and preserve past actuals if you want an accurate record.

One common misconception is that a budget spreadsheet must make every category match perfectly. Its practical purpose is to make assumptions and results visible. A negative difference is information: it can reflect a one-time bill, a realistic cost that was underestimated, or spending that needs attention. Correct the underlying entry if it is a data error; do not alter actuals merely to make the totals look balanced.

The debt-payment line in this example is only a budget allocation. It does not calculate interest, a payoff date, or the amount required under a loan or card agreement. For debt calculations, check the actual terms with the lender or a qualified professional. This sample is for organizing information, not financial, tax, investment, or legal advice.

Frequently Asked Questions

What should a basic budget spreadsheet include?
A basic sheet needs a time period, income and expense categories, planned amounts, actual amounts, and totals. A difference column helps compare the plan with what happened. Add categories only when they make the sheet more useful to maintain.

Is there a free budget spreadsheet in Excel?
Excel may offer templates through its start screen or template gallery, depending on the version and account. You can also create the sample above in a blank workbook without downloading anything. Review a template’s formulas and data layout before entering personal information.

How do I calculate the amount left in my budget?
Subtract total outflows from total income for the same period. In the sample, actual income is $4,200 and actual outflows are $3,655, leaving $545. The result is only as complete as the categories and transactions entered.

Should savings count as an expense in a budget?
It depends on the question the spreadsheet is meant to answer. Treating savings as an allocation shows how income is assigned, while separating it from expenses distinguishes saving from consumption. Use a clear label and do not count the same transfer again as an expense.

How often should I update my budget spreadsheet?
Weekly updates work well for many people because they reduce the time between a transaction and its entry. A different schedule may suit you if bills or income follow another rhythm. The important part is to update consistently and check the figures against reliable records.

Related

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.