HomeBlogBlogHow to Create a Budget Tracker in Excel Step by Step

How to Create a Budget Tracker in Excel Step by Step

A budget tracker gives you one place to compare what you planned to spend with what you actually spent. Excel makes it possible to start with a simple worksheet and update it as your needs change. You don’t need a complicated template: a few categories, basic formulas, and a regular review can be enough to get started. For more guidance, see CREATING A BUDGET WITH EXCEL.

For guidance you can follow at your own pace, we also offer an Excel budgeting eBook and checklist as a digital download. Start with the steps below, then decide whether the guide is a useful addition to your routine. For further reading, see Free Monthly Expense Tracker & Excel Template (Canada).

Start with Your Budget Categories

Gather your income figures, recurring bills, and estimates for expenses that vary from month to month. Pay stubs, recent bills, receipts, and account records can help you make realistic estimates. If your income changes, use a conservative estimate and update it when you know the actual amount.

Next, choose categories that reflect your household. Housing, utilities, groceries, transportation, and savings are useful starting points. You might also add categories for debt payments, entertainment, and occasional expenses such as gifts or car maintenance.

Keep the list manageable. If you rarely need to review a category on its own, combine it with a related one. The Consumer Financial Protection Bureau’s budgeting resources can help you consider expenses that are easy to overlook.

Build Your Budget Tracker in Excel

1. Set up your columns and rows

Open a blank workbook and enter these headings in cells A1 through D1: Category, Planned, Actual, and Difference. Use separate rows for each income source and expense category. Add a total row after each group so you can see income and expenses separately.

Enter your expected monthly amounts in the Planned column. In the Actual column, enter amounts as you receive income or spend money. You can leave an actual amount blank until it occurs.

2. Add formulas

For expenses, calculate the difference by subtracting actual spending from planned spending. For example, if the first expense is on row 2, enter =B2-C2 in D2. Copy that formula down the Difference column for your other expense rows. A positive result means you spent less than planned; a negative result means you spent more.

To total a group of amounts, use a SUM formula. For example, =SUM(B2:B3) adds the planned amounts in rows 2 and 3. Use the corresponding range in column C for actual spending, then subtract the actual total from the planned total. Adjust the row numbers to match your worksheet. For more help with formulas, see Microsoft Support’s guide to creating a simple formula.

For income, remember that the same subtraction works differently: actual income above your plan produces a negative difference. You can instead use actual minus planned for income if you prefer, but label or note the formula so you can interpret it consistently.

3. Format and save your tracker

Select the amount columns and apply Excel’s currency format. Give the worksheet a clear month and year, then save it somewhere you can find it again. Make a copy for each new month so you can preserve past figures while starting a fresh plan.

Example Monthly Expense Tracker

Category	Planned	Actual	Difference
Groceries	$400	$380	$20
Transport	$150	$165	-$15
Total	$550	$545	$5

In this example, transportation is over budget, but lower grocery spending brings the combined total $5 under plan. Reviewing both the individual rows and the total helps you see what changed.

Use Your Tracker Throughout the Month

Choose a regular time to enter actual amounts, such as once a week. Use receipts or account records to update each category, and avoid counting the same transaction twice. If you share expenses with someone else, agree on who will enter them and how you’ll divide shared costs.

At the end of the month, compare planned and actual amounts. A single higher bill may be temporary, while a repeated difference could mean your plan needs adjustment. Use what you learn to set next month’s amounts, including a realistic contribution to savings when possible.

Keep your financial files secure. Store them in a protected location and avoid putting unnecessary account numbers, passwords, or other sensitive details in the worksheet.

Explore the Excel Budgeting Guide and Checklist

If you want step-by-step guidance alongside your worksheet, our Excel budgeting guide and checklist is a digital eBook and checklist listed at $7.99 USD. Review the product listing before purchasing to decide whether it fits the way you prefer to learn.

A budget can also make room for discretionary purchases. If reading is one of your goals, our reading habit guide is another digital download you could consider within your entertainment or personal-development category.