How to Build a Budget Spreadsheet That You Will Actually Use

How to build a budget spreadsheet in six steps: income and spending, a tracker, a bill calendar and a monthly review. Free, simple and built to last.

By Galactic News Editorial · Published 2026-11-08T10:24:41+00:00 · Updated 2026-11-08T10:24:41+00:00

How to Build a Budget Spreadsheet That You Will Actually Use

Learning how to build a budget spreadsheet takes about an hour, and the result can last for years. A good budget spreadsheet answers one question: where does the money go? This guide shows you how to build one from scratch in Google Sheets or Excel, with no paid tools and no complex formulas.

The method follows the Consumer Financial Protection Bureau's budgeting steps: record all income, track spending, list bills and due dates, then pull it together into a working budget. The spreadsheet below turns those steps into a sheet you can reuse every month. This article is educational only. It is not personal financial advice.

How to Build a Budget Spreadsheet: What You Need First

Before you open a spreadsheet, gather three things. First, your last two or three months of bank and card statements. Second, a list of your regular bills and their due dates. Third, your pay slips or income records for the same period.

This layout is the foundation of how to build a budget spreadsheet that lasts. Choose your tool. Google Sheets is free and works in a browser. Excel is a strong choice if you already have it. Both handle the formulas in this guide. A template can help, but building your own sheet teaches you how it works, which makes it easier to fix later.

Keep the design simple. One sheet for the monthly budget. One sheet for tracking spending. A simple sheet you understand beats a clever sheet you abandon.

Step 1: Set Up the Monthly Budget Sheet

Open a new spreadsheet and name it Monthly Budget. Create these columns across the top row: Category, Budgeted, Actual, Difference.

In the Category column, list your income first. Add one row for each income source, such as salary, freelance work, or benefits. Below that, list your spending categories: housing, utilities, groceries, transport, phone, insurance, debt payments, savings, fun money, and a miscellaneous row.

Leave the Budgeted column blank for now. You will fill it in step 3. The Actual column gets your real spending at month end. The Difference column shows Budgeted minus Actual, so you can see where you went over or under.

Step 2: Record Your Real Income

Enter your take-home pay, not your gross salary. Take-home pay is the money that actually reaches your account. If your income varies, use the average of the last three months as a starting point. You can adjust it later.

Add every income source on its own row. Include side work, benefits, and any regular transfers in. At the bottom, add a Total Income row. In Google Sheets or Excel, use the SUM formula to add the income rows together. For example, if income sits in cells B2 to B5, the total cell reads =SUM(B2:B5).

Knowing your real income is the foundation of the whole sheet. A budget built on gross pay will always look better than reality.

Step 3: List Spending and Set Budget Amounts

Now fill in the Budgeted column. Start with fixed costs: rent or mortgage, utilities, phone, insurance, and loan payments. These change little from month to month. Use the amounts from your last bill.

Next, set amounts for variable costs: groceries, transport, eating out, and fun money. Base these on your last three months of actual spending, not on a guess. If you spent $400 a month on groceries, budget $400, not $250. A budget that ignores reality fails in week two.

Add a savings row and treat it like a bill. Even a small fixed amount counts. Add a Total Spending row with a SUM formula. Below it, add a Money Left row that subtracts Total Spending from Total Income.

The Consumer Financial Protection Bureau suggests the same order: income first, then spending, then bills and due dates. Its budgeting guide notes that mismatched timing between paydays and bill dates is a common reason budgets feel tight, even when the monthly totals work.

Step 4: Add a Spending Tracker Sheet

Create a second sheet called Spending Tracker. Give it four columns: Date, Category, Description, Amount. Each time you spend money, add a row. This takes seconds, and it is the habit that makes the budget work.

At month end, add up spending by category. In Google Sheets, the SUMIF formula does this. For example, =SUMIF(B:B,"Groceries",D:D) adds every amount in column D where column B says Groceries. Copy that total into the Actual column of your budget sheet.

If daily logging feels like too much, try a weekly check instead. Open your bank app once a week and log the week's spending in one sitting. The numbers matter more than the timing.

Step 5: Add a Bill Calendar

Create a third sheet called Bills. List each bill, its amount, and its due date. Sort by due date. This sheet answers a different question from the budget: not how much you spend, but when the money leaves.

The CFPB's budgeting guide recommends a bill calendar for exactly this reason. If rent is due on the 1st and payday falls on the 5th, the timing gap matters, even if the monthly totals balance. A bill calendar shows the gap before it becomes a problem.

Check the bill sheet at the start of each month. Update any amounts that changed. Cancel or note any bill you no longer owe.

Step 6: Review at Month End and Adjust

At month end, fill in the Actual column from your tracker. Look at the Difference column. A negative number means you spent more than planned in that category. A positive number means you spent less.

This monthly check is what makes learning how to build a budget spreadsheet pay off. Ask three questions. Which categories went over, and why? Which budget amounts were unrealistic? What will you change next month? Adjust the Budgeted column for next month based on the answers. A budget is a living document, not a one-time promise.

The CFPB's guidance makes the same point: you may not hit all your targets in the first month, and that is normal. The goal is a working budget that improves each month, not a perfect one on day one.

Common Mistakes to Avoid

• Budgeting with gross pay instead of take-home pay.
• Forgetting irregular costs such as car repairs, gifts, or annual subscriptions.
• Setting grocery and fun budgets far below real spending.
• Building a complex sheet with dozens of categories you will not maintain.
• Never reviewing the sheet after the first week.

A simple fix for irregular costs is a small monthly row called Irregular. Put a fixed amount in it each month. When a car repair or gift arrives, the money is already there.

Bottom Line

Knowing how to build a budget spreadsheet is a practical skill, not a chore. Start with income, list real spending, track it weekly, and review monthly. Keep the sheet simple enough to maintain. A spreadsheet you update every month beats a perfect one you open once. Build yours today, review it at month end, and adjust it until it fits your life.