HomeBlogBlogBudget Spreadsheet in Excel: Simple Monthly Setup

Budget Spreadsheet in Excel: Simple Monthly Setup

How to Make a Budget Spreadsheet in Excel

To make a budget spreadsheet in Excel, start with a simple layout that tracks three things: what you planned to spend, what you actually spent, and the difference. Keeping the structure clean makes it easier to update weekly and spot problems fast.

Step 1: Set up your categories

Open a new workbook and name the first sheet “Monthly Budget.” In column A, list categories such as Rent/Mortgage, Utilities, Groceries, Transportation, Insurance, Dining Out, Subscriptions, Debt Payments, Savings, and Miscellaneous. Add a “Total” row at the bottom.

Step 2: Add budgeted vs. actual columns

Create these headers across row 1: Category, Budgeted, Actual, Difference. In the Difference column, subtract Actual from Budgeted (so positive numbers mean you’re under budget). Copy the formula down the column for every category.

Step 3: Calculate totals automatically

In the Total row, use SUM formulas for Budgeted and Actual so you can see your full monthly plan versus what you spent. For the Difference total, subtract the total Actual from the total Budgeted to see whether the month is trending ahead or behind.

Step 4: Make it easy to enter transactions

Add a second sheet named “Transactions.” Use columns like Date, Description, Category, and Amount. Enter spending as it happens. Then, on your Monthly Budget sheet, total Actual spending per category using a category-based sum (so the “Actual” column pulls numbers from Transactions).

Step 5: Add quick formatting for clarity

Apply currency formatting to money columns. Use conditional formatting on the Difference column to highlight overspending (negative values) so you can adjust before the month ends.

Want a ready-to-use beginner system?

For a more complete setup—including a beginner-friendly structure and tips for keeping it consistent—follow this guide: beginner budget spreadsheet system in Excel and Google Sheets.

FAQ

What categories should I include in a monthly budget spreadsheet?

Start with essentials (housing, utilities, groceries, transportation, insurance), then add financial goals (debt and savings) and flexible spending (dining out, entertainment, subscriptions). Keep categories broad at first; you can split them into subcategories once you’ve tracked a month or two.