Spreadsheet Free Budget Planner: A Simple Excel Setup

How-to basics · Updated November 21, 2026

Yes—a free budget planner spreadsheet can be made in Excel for the web or Google Sheets, and it can track income, planned spending, actual spending, and what remains. In Excel for Microsoft 365 on Windows, create a table with those figures and use simple formulas such as =SUM(B2:B7) to total planned expenses; the example below explains the cell layout and arithmetic.

What a spreadsheet budget planner does

A spreadsheet budget planner puts your money plan into rows and columns. You decide which figures to enter, how to group expenses, and how often to update them. Unlike a banking app that may import transactions automatically, a basic spreadsheet usually depends on you entering or pasting information. That extra work can be useful: it makes the categories and assumptions visible, and you can adjust the layout to suit your situation.

A practical monthly planner commonly separates four ideas:

  • Income: money you expect to receive during the month, preferably using take-home amounts when planning spendable cash.
  • Planned expenses: the amount you intend to spend in each category.
  • Actual expenses: what you have recorded as spent so far.
  • Remaining: the difference between the plan and actual spending, or the money left after planned obligations.

A budget is an estimate, not a guarantee. Irregular bills, changing work hours, and unexpected costs can make a month differ from the plan. The value of the spreadsheet is that it helps you notice the difference and revise your next decisions, rather than pretending every month will match exactly.

Set up a simple monthly budget in Excel

In Excel for Microsoft 365 on Windows, open a blank workbook and enter a small budget table. Put the column headings Category, Planned, Actual, and Left in cells A1:D1. Enter expense categories in A2:A7 and their planned amounts in B2:B7. For example, use Rent, Utilities, Groceries, Transport, Phone and internet, and Insurance. Enter what you have actually paid or spent in C2:C7 as the month progresses. Leave D for the calculated difference.

For an illustrative plan, the planned amounts could be $1,200 for rent, $180 for utilities, $450 for groceries, $220 for transport, $100 for phone and internet, and $250 for insurance. Together these six expenses total $2,400. The values are examples, not recommended amounts; actual costs vary by location, household, and circumstances.

Add a total row in row 8. Put Total in A8, then use the formula below. It assumes the expense categories are in A2:A7, their planned values are in B2:B7, and the total planned expenses belong in B8. The result for the example figures is $2,400.

=SUM(B2:B7)

Use the same pattern in C8 to total actual spending, changing the range to C2:C7. Enter the monthly take-home income in a clearly labeled cell such as B10, and a savings target in B11 if you want the plan to include one. Keep labels next to figures so the workbook remains understandable when you return to it later.

Use formulas to show what remains

A difference column makes the plan easier to read. With categories in A2:A7, planned amounts in B2:B7, actual amounts in C2:C7, and the difference in D2:D7, enter the following formula in D2 and copy it down through D7. A positive result means the recorded spending is below the plan for that category; a negative result means it is above. If groceries are planned at $450 and actual spending is $390, the result is $60.

=B2-C2

To estimate cash left after the example expenses and a savings target, put income in B10, total planned expenses in B8, and the savings target in B11. Enter this formula in B12, with a label such as Planned cash left beside it. With income of $3,200, planned expenses of $2,400, and savings of $400, the result is $400: $3,200 minus $2,400 minus $400. This is only a simple planning calculation; it does not account for every possible bill or timing issue.

=B10-B8-B11

These formulas are ordinary Excel formulas and work in Excel for Microsoft 365 on Windows and Excel for the web. If you use Excel for Mac, the formula syntax is the same. For currency, select the amount cells and use Home > Number to apply a currency format; formatting changes how a value looks, not the underlying arithmetic. Check that your planned and actual figures cover the same period before interpreting a difference.

Choose a tracking method you will keep using

The simplest approach is to enter totals directly into the Actual column once or twice a week. It takes little setup, but you may need to look through account activity and add transactions yourself. A more detailed approach uses a transaction log on another worksheet, with columns for date, description, category, and amount. You can then total each category, but that adds data entry and formula maintenance. Start with the simpler method if detail is likely to make the planner feel burdensome.

Decide whether the workbook is a monthly plan, a pay-period plan, or an annual overview. Monthly sheets suit bills and recurring categories. A pay-period view may help when income arrives on a schedule that does not line up neatly with the calendar month. An annual sheet can reveal seasonal or once-a-year costs, but it should not replace a near-term cash-flow view if bill dates matter.

  • Record a category definition, such as whether household supplies belong under groceries or a separate heading.
  • Set a consistent update time, such as a weekly review, rather than relying on memory at month-end.
  • Use a notes column for unusual entries, refunds, or one-off costs that need explanation.
  • Keep a copy of the prior month before clearing or replacing figures, so you can compare plans over time.

Make the spreadsheet readable and dependable

Clear labels and a modest number of categories are more useful than elaborate formatting. Separate planned values from actual values, make the reporting period obvious, and use one currency consistently. If you create many rows, avoid merged cells in the data area because they can make sorting and editing awkward. In Excel for Microsoft 365 on Windows, select the heading row and choose View > Freeze Panes > Freeze Top Row to keep headings visible while scrolling. In Excel for the web, the available command can depend on the current interface, so use the View tab and look for Freeze Panes.

You can make unusual differences stand out with conditional formatting. Select D2:D7, then choose Home > Conditional Formatting > Highlight Cells Rules > Less Than and enter 0 to highlight negative differences. This is a visual cue, not a judgment: a negative figure tells you that actual spending is higher than the planned amount, but it does not explain why or whether the original plan was realistic.

Check totals with a quick manual estimate when you first build the workbook. A formula can be syntactically correct and still point to the wrong cells. When copying formulas, verify that the row references changed as intended. Keep a separate untouched copy of a blank template if you plan to reuse it each month.

Common budget spreadsheet problems

One frequent problem is mixing monthly and annual figures. A $600 annual bill is not equivalent to a $600 monthly expense. If you choose to spread a regular annual cost across months for planning, record that choice clearly—for example, $600 divided by 12 is $50 per month—and keep the actual payment date visible somewhere in your plan. This helps distinguish the planning allocation from the cash leaving an account.

Another issue is leaving out irregular purchases or small recurring charges. Review a representative period of account activity and decide which categories are useful, without assuming that past spending must be repeated. Also watch for double counting: a credit-card purchase should not be counted once as a purchase and again as a payment to the card if the budget is intended to measure spending by category.

  • Blank actual cells: decide whether a blank means no spending recorded yet or a true zero, and apply the convention consistently.
  • Negative remaining amounts: check for overspending, a mistaken entry, or a category that needs adjusting; do not simply hide the result.
  • Unexpected totals: confirm that the formula range includes every intended row and excludes headings or unrelated figures.
  • Changing plans: preserve the original plan or note revisions so that later comparisons do not confuse a changed target with actual performance.

Free spreadsheet options and their trade-offs

Excel for the web is a browser-based option available with a Microsoft account, while Google Sheets is a separate browser-based spreadsheet service. Both can handle a basic budget with rows, number formatting, and standard sum formulas. Excel desktop for Microsoft 365 is not the same thing as a universally free desktop application; access to desktop features depends on the applicable license or subscription. Check current account terms and feature availability before choosing a workflow.

A downloadable template can save setup time, but inspect its formulas, categories, and sharing settings before entering private information. A blank workbook offers more control and makes it easier to understand how calculations work. Dedicated budgeting apps may offer transaction connections, reminders, or reports that a manual spreadsheet does not provide, but their features, fees, and data practices vary. The right choice depends on whether flexibility, automation, simplicity, or privacy is most important to you.

Privacy and safe handling of budget data

A budget can reveal sensitive details about income, bills, and routines. Avoid storing account passwords, full card numbers, security codes, or login credentials in a spreadsheet. A budget generally needs amounts and categories, not the credentials used to access financial accounts. If you use cloud storage, review who can access the file and avoid public sharing links. If you email a workbook, remember that a copy may remain in the recipient’s mailbox or backups.

For a shared household budget, agree on who can edit the file and how updates will be recorded. Keep a backup in a secure location, and use a strong sign-in method for the account that stores it. A spreadsheet is a planning tool, not a secure banking system. These privacy habits can reduce unnecessary exposure, but they cannot guarantee that a service or device will never be compromised.

Frequently Asked Questions

Is there a genuinely free budget spreadsheet?
Yes. You can create one in a browser spreadsheet such as Excel for the web or Google Sheets without buying a prebuilt template. Service terms and available features can change, so check the provider’s current account requirements.

Can I use Excel without paying for Microsoft 365?
Excel for the web is a browser option associated with a Microsoft account, while the desktop Excel application may require a qualifying license or subscription. The exact access and features depend on Microsoft’s current terms.

What should a basic budget spreadsheet include?
At minimum, include a period, income, expense categories, planned amounts, actual amounts, and a remaining or difference figure. Add savings or debt payments if they are part of the plan, and label what each total includes.

Should I enter transactions one by one?
Not necessarily. Entering category totals is quicker, while a transaction log provides more detail and can make it easier to find mistakes. Choose the method you can update consistently, and avoid counting the same purchase twice.

Can a budget spreadsheet tell me what financial decisions to make?
No. It can organize figures and show how a scenario adds up, but it cannot determine what is suitable for your circumstances. The examples here are illustrative, not financial, tax, investment, or legal advice; check actual terms with a lender or consult a qualified professional when relevant.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.