Budget Excel Spreadsheet With Formulas: A Practical Guide

Formulas & functions · Updated November 21, 2026

Yes. A useful budget Excel spreadsheet can be built with columns for category, planned amount, actual amount, and variance, then formulas to total income and spending and calculate what remains. In Excel for Microsoft 365 on Windows, enter the categories and amounts, add the formulas below, and update actual spending as the month goes on.

What a formula-based budget does

A budget spreadsheet compares a plan with what actually happens. Its formulas can add income and expenses, show whether a category is over or under its plan, and calculate the money remaining after expenses. Unlike a static list of amounts, it updates totals when you change an input cell.

Formulas do arithmetic; they do not decide what your priorities should be or verify that transactions have been categorized correctly. You supply the plan and the actual figures, and the workbook organizes the comparison. Treat the figures in this guide as illustrative, not as financial, tax, investment, or legal advice. Check actual account terms with the relevant provider and consult a qualified professional for advice about your circumstances.

A simple monthly layout works well for a first workbook:

  • Column A: category, such as salary, rent, groceries, or transport.
  • Column B: planned amount for the month.
  • Column C: actual amount received or spent.
  • Column D: variance, calculated as actual minus planned.

Keep income and expenses in separate blocks so a positive expense variance is easy to recognize as overspending. A positive variance means income was higher than planned in the income block, but expenses were higher than planned in the expense block. The sign alone is not a judgment about whether a purchase was worthwhile.

Set up the worksheet

Open a blank workbook and put the four column labels in A1:D1. Use rows 2–4 for income categories: Salary, Freelance, and Other. Put Total income in A5. Leave row 6 blank, then use rows 8–13 for expenses such as Rent, Groceries, Utilities, Transportation, Insurance, and Subscriptions. Put Total expenses in A14. Leave row 15 blank and label row 16 Net available. This arrangement gives the formulas clear, consistent ranges.

Enter planned and actual amounts as numbers, not text that merely looks like a number. For example, enter 4200 rather than typing a currency symbol into the cell; apply currency formatting afterward. In this illustrative example, income is planned at $4,500 and actually received at $4,450. Expenses are planned at $2,830 and actual spending is $2,850. The resulting actual net available is $1,600.

For instance, enter the following example amounts in columns B and C:

  • Rows 2–4, income: 4,200 planned and actual salary; 300 planned and 250 actual freelance income; and 0 planned and actual other income.
  • Rows 8–13, expenses: rent 1,500 and 1,500; groceries 600 and 640; utilities 220 and 205; transportation 250 and 230; insurance 180 and 180; subscriptions 80 and 95.

These amounts are deliberately simple illustrations. Your categories and payment timing may differ. If a bill is paid annually or irregularly, decide whether the monthly plan should show the full payment in its payment month or a portion set aside each month, and use the same approach consistently.

Core formulas and a checked example

With income categories in rows 2–4 and planned and actual values in columns B and C, enter this formula in B5 to total planned income. It returns 4,500 for the example.

=SUM(B2:B4)

With the same category rows and actual income in C2:C4, enter this formula in C5 to total actual income. It returns 4,450.

=SUM(C2:C4)

With planned income in B5 and actual income in C5, enter this formula in D5 to calculate the income variance. The result is -50, meaning actual income is $50 below the plan.

=C5-B5

With expense categories in rows 8–13 and planned expense values in B8:B13, enter this formula in B14. It returns 2,830.

=SUM(B8:B13)

With actual expenses in C8:C13, enter this formula in C14. It returns 2,850.

=SUM(C8:C13)

With planned expenses in B8:B13 and actual expenses in C8:C13, enter this formula in D8, then copy it down through D13. Each row shows that category’s actual amount minus its planned amount. For groceries, D9 returns 40; for utilities, D10 returns -15.

=C8-B8

With total planned expenses in B14 and total actual expenses in C14, enter this formula in D14. It returns 20, indicating total spending was $20 above plan.

=C14-B14

With planned income in B5 and planned expenses in B14, enter this formula in B16. It returns 1,670.

=B5-B14

With actual income in C5 and actual expenses in C14, enter this formula in C16. It returns 1,600, because 4,450 minus 2,850 equals 1,600.

=C5-C14

With the planned net amount in B16 and the actual net amount in C16, enter this formula in D16. It returns -70: actual net available is $70 below the planned $1,670. Together, the formulas make the summary update when the underlying amounts change.

=C16-B16

Make the budget easier to read and maintain

Formatting helps distinguish inputs from calculated results. Select the amount cells and use Home > Number to apply a currency or accounting number format. You can also select cells and press Ctrl+1 on Windows to open Format Cells; on Mac, Command+1 opens Format Cells in current Excel versions. Choose the number of decimal places and currency symbol that suit your workbook. Formatting changes how values appear, not the arithmetic stored in the cells.

Use clear headings, bold total rows, and a different fill color for cells where you type amounts. Avoid merging cells in the data area: merged cells can make sorting, copying, and selecting ranges harder. If the worksheet grows, turn a category block into an Excel table with Insert > Table. Tables can expand as rows are added, though the simple fixed-range formulas in this example must be adjusted if new categories are added outside their ranges.

To keep the headings visible while scrolling, choose View > Freeze Panes > Freeze Top Row. To flag a positive expense variance, select the relevant variance cells and choose Home > Conditional Formatting > Highlight Cells Rules, then select a rule that fits your preferred threshold. Conditional formatting changes appearance; it does not change the values or correct a mistaken entry.

A practical monthly routine

A spreadsheet works best when its update routine is predictable. One workable process is to enter the plan before the month begins, then update actuals regularly from receipts, statements, or another reliable record. Reconcile the entries with the source records rather than relying on memory alone.

  1. Set planned amounts for each category and check that the planned totals reflect your intended monthly plan.
  2. Enter income and expenses as they occur, or update them on a regular schedule. Keep the source record available to check amounts and dates.
  3. Review the variance column. For an expense category, a positive number means spending is above plan; a negative number means it is below plan so far.
  4. At month end, confirm the totals against your records, note any unusual or one-time items, and decide whether next month’s plan needs an adjustment.

Do not assume that a low actual expense halfway through the month means the category is safely under budget; a bill may not yet have arrived. Likewise, a credit-card purchase is generally an expense when it is incurred for budgeting purposes, while paying the card balance is a transfer of money to settle that expense. Counting both the purchase and the later payment as spending can double-count it. Choose a consistent tracking method and be clear about whether the sheet tracks purchases or cash leaving an account.

Common formula and data-entry problems

If a total appears too low, check that every relevant amount falls inside the SUM range. The examples include rows 8 through 13, so a new expense entered on row 14 would not be included and could overwrite the total. Insert new categories inside the intended range or update the formula range deliberately. Check for amounts stored as text as well: imported data can look numeric but fail to behave as expected in calculations.

A formula showing as text instead of a result may be in a cell formatted as Text, or the entry may have an apostrophe before the equals sign. Change the cell format to General or an appropriate number format, then re-enter the formula. If a cell shows ##### instead of a number, widen the column; that display commonly means the value does not fit in the current column width.

Another frequent mistake is reversing the variance subtraction. This guide uses actual minus planned throughout. That means positive expense variance signals spending above plan, while negative expense variance signals spending below plan. If you prefer the opposite convention, use it consistently and label the column so its meaning is clear. Mixing conventions makes totals and comparisons confusing.

Finally, do not overwrite a total cell with a typed number. Keep input cells and formula cells visually distinct, and make a backup before making extensive structural changes. Formulas recalculate based on their references, but they cannot detect duplicate transactions, missing receipts, or an incorrect category assignment.

Templates, extra features, and alternatives

You do not have to start from a blank sheet. In Excel, File > New lets you search available templates, including budget-related templates when they are offered. Template names and availability can vary by account, region, and Excel version. Before relying on one, inspect its categories, formulas, and assumptions; a polished design is not proof that it matches your needs.

A custom workbook offers control over categories and calculations, while a template can save setup time. A budgeting app may be more convenient for automatic transaction imports or mobile entry, but its available features, fees, and data-handling practices vary. Excel for the web can be useful for editing a workbook in a browser, while some desktop features and workflows differ. Compare the actual capabilities and privacy terms rather than assuming every tool offers the same functions.

For a basic monthly budget, SUM and subtraction are enough; complex functions are not a requirement. If you later add charts, make sure the chart points to the summary cells you intend to compare. If you copy the workbook for a new month, review both the category ranges and any labels or dates rather than assuming every reference updated as intended.

Frequently Asked Questions

Where can I get a free budget spreadsheet for Excel?
Check File > New in Excel for available templates, or create a workbook with the layout and formulas above. Template availability varies, and a template should be reviewed before use to confirm its categories and calculations.

What formula adds up expenses in Excel?
For expense amounts in cells C8 through C13, use =SUM(C8:C13). The result is the total of those cells; change the range to match the actual locations of your expense entries.

How do I calculate the money left after bills?
Subtract total expenses from total income. In this example, with actual income in C5 and actual expenses in C14, enter =C5-C14 in C16. The illustrative result is $1,600.

How do I show whether I overspent a category?
Subtract the planned amount from the actual amount for that category. With planned groceries in B9 and actual groceries in C9, the formula is =C9-B9. A positive result indicates actual spending exceeded the plan under this guide’s convention.

Can I use this budget spreadsheet in Excel for Mac?
Yes. The standard formulas shown here work in current Excel for Mac as well as Excel for Microsoft 365 on Windows. Ribbon layout and some shortcuts can differ; on Mac, Command+1 opens Format Cells, whereas Ctrl+1 is the Windows shortcut.

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.