Sample Budget Excel Spreadsheet: A Walkthrough Guide

Excel was practically built for budgets. It adds your numbers, flags overspending, and turns a plain list into a chart with a couple of clicks, all without leaving the page.

This guide walks through a sample budget Excel spreadsheet you can copy line by line. You will get real example numbers, the exact formulas to type, and the Excel features that make the sheet do the work for you.

Start with Excel's built-in template

Before building from scratch, check what Excel already gives you. Open Excel, click New, and type budget in the template search box.

Microsoft includes several free options, such as Personal Monthly Budget and Simple Budget. Click one and it opens a fully formatted sheet with categories, formulas, and a summary already set up.

These templates are a solid head start, but they are generic. Most people delete a few rows, rename categories, and adjust the formulas, which is easy once you see how the sheet is built.

A sample budget you can copy

Here is a simple monthly layout with real example numbers. Put categories in column A, your planned amounts in column B, and actual amounts in column C.

The Leftover row shows whether your plan balances and how the month actually closed. In this sample, dining out and groceries ran over, so the real leftover came in $60 lighter than planned.

The Excel formulas that run it

Four functions do almost all the work in a budget. Type them once and the sheet updates itself whenever you change a number.

Use SUM to total your expenses. If your expense rows run from B3 to B8, type =SUM(B3:B8) to add them. Copy it to column C to total your actual spending too.

Find leftover money with subtraction. In the Leftover cell, type your income cell minus your expense total, such as =B2-B9. A negative result means your plan spends more than you make.

Use SUMIF to total only matching rows, like every expense labeled "Groceries." The pattern is =SUMIF(A3:A8,"Groceries",B3:B8), which is useful when you paste a month of transactions into another tab.

Use IF to label overspending automatically. Type =IF(C4>B4,"Over","OK") next to a category, and Excel writes Over whenever actual beats planned.

Use Excel features that automate the sheet

A few Excel-only tools turn a static budget into a smart one. They take seconds to set up.

Conditional formatting flags overspending with color. Select your Actual column, open Home then Conditional Formatting, and add a rule that turns a cell red when it is greater than the planned amount. Now overspending is impossible to miss.

Format your data as a Table by selecting it and pressing Ctrl+T. Tables auto-extend your formulas when you add a row and let you sort categories with one click.

Add a chart to see the big picture. Highlight your categories and actual amounts, click Insert, and pick a pie chart to see exactly where your money goes. Visuals often reveal a problem a column of numbers hides.

The one thing Excel will not do is fill itself in. Every figure in the Actual column has to come from somewhere, and entering a month of transactions by hand is the step most people abandon. Monarch Money is a paid budgeting app that connects your bank and card accounts and categorizes spending automatically, then shows budgets and trends in a live dashboard. For someone who likes Excel's structure but not the data entry, it does the typing. Terms and pricing apply.

Build a second tab for transactions

Keep your summary clean by putting raw transactions on a second sheet. Create a tab called Transactions with columns for Date, Amount, and Category.

As you enter each purchase, your SUMIF formulas on the summary tab pull the totals automatically. This separates your tidy plan from the messy detail behind it.

Exporting transactions from your bank as a CSV and pasting them in saves a lot of typing. Most banks offer a download button in their transaction history.

If even the export-and-paste routine feels like a chore, an app can replace it. Piere is a free budgeting app that tracks and categorizes spending in real time, so your category totals are ready whenever you open it. For an Excel user who wants daily tracking handled automatically, it feeds the same numbers your formulas need. Terms apply.

Many users of automated budgeting apps report that live category totals cut down on spreadsheet upkeep, though some note that occasional transactions land in the wrong bucket and need a quick fix. Reviewing categories weekly keeps your data clean.

Keep your sample sheet useful

The sample above is a starting point, not a finished budget. Swap in your own income, rename categories to match your spending, and delete lines you do not use.

Save a blank copy as your master template before you fill it in. Each month, copy the master, rename it with the month, and start fresh so you keep a clean history of every month.

Build yours today

Open Excel, copy the sample layout above, and type in last month's real numbers. Add the SUM and IF formulas, then turn on conditional formatting so overspending shows up in red.

A budget built on real numbers beats a guess every time. Start with one accurate month, and let Excel's formulas and charts do the heavy lifting from there.

Frequently Asked Questions

Does Excel have a free budget template?

Yes. Open Excel, click New, and search budget to find free templates like Personal Monthly Budget and Simple Budget. Each opens a formatted sheet with categories and formulas already built in, ready for you to edit.

What formulas should a budget Excel spreadsheet use?

Four cover most needs: SUM to total a column, subtraction to find leftover money, SUMIF to total only matching categories, and IF to flag overspending. You can type all four in a minute without prior Excel experience.

How do I highlight overspending in Excel?

Select your Actual column, open Home then Conditional Formatting, and add a rule that turns a cell red when its value is greater than the planned amount. Overspending then shows up in color automatically.

How do I import bank transactions into Excel?

Download your transactions from your bank as a CSV file, then open or paste them into a separate tab in your workbook. Your summary formulas, like SUMIF, can then pull category totals from that data automatically.