How to Make a Budget Spreadsheet in Google Sheets (Step-by-Step, 20 Minutes)

Quick answer: Build a budget spreadsheet in Google Sheets with four columns (Date, Category, Description, Amount), a dropdown list of categories via Data Validation, and three SUMIF formulas for total income, total expenses, and what's left. That's the whole structure — the rest of this guide is the copy-paste formulas for it, step by step. If you'd rather skip the build, a free monthly budget template has this structure already set up, no email required; paid templates from sheetfolk start at $9 one-time for more specific layouts (couples splitting, sinking funds, a full dashboard).

How to Make a Budget Spreadsheet in Google Sheets

A budget spreadsheet doesn't need to be complicated. You can build a functional tracker in Google Sheets in 20 minutes using basic columns, categories, and formulas. This guide shows you exactly how, with step-by-step instructions and formulas you can copy and paste directly.

How do I set up the basic structure for a budget spreadsheet?

Start with four main columns: Date, Category, Description, and Amount. Open Google Sheets, create a new blank spreadsheet, and add headers in row 1. Use columns A through D for this layout.

Make row 1 a header row by adding a light background color (Format > Fill color > Light gray) and bolding the text. This keeps your budget visually organized and makes it easy to spot where data starts.

How do I categorize expenses in Google Sheets?

Expense categories are the backbone of any budget. Common categories include Groceries, Utilities, Transportation, Entertainment, Dining Out, Subscriptions, and Miscellaneous. In your Category column (B), write each expense's category as you enter it.

To keep categories consistent (and avoid typos), create a separate "Categories" sheet and use Data Validation. In column B, go to Data > Data Validation, select "List of items," and type your categories separated by commas. This creates a dropdown menu so you always pick from your predefined list.

What formulas do I need to track my total spending?

Add a summary section at the bottom of your spreadsheet. In column A, write labels like "Total Income," "Total Expenses," and "Remaining Budget." Use these formulas in column B:

Total Income:

=SUMIF(B:B,"Income",D:D)

This sums all amounts in column D where the category in column B is "Income."

Total Expenses:

=SUMIF(B:B,"<>Income",D:D)

This sums all amounts that are NOT income (i.e., all spending).

Remaining Budget:

=SUMIF(B:B,"Income",D:D)-SUMIF(B:B,"<>Income",D:D)

This shows what's left after subtracting expenses from income.

If you want to track spending by category, add another section that breaks down each category. For example:

=SUMIF(B:B,"Groceries",D:D)

Replace "Groceries" with any category name you're tracking. This gives you a quick view of how much you're spending on each type of expense.

How do I format amounts as currency in Google Sheets?

Select the cells containing your amounts (usually column D and your totals). Go to Format > Number > Currency and choose your currency (USD, EUR, etc.). This displays numbers with dollar signs and two decimal places, making it easier to read.

How should I organize my budget by month?

The simplest approach is to use one sheet per month. Name each sheet with the month and year (e.g., "June 2026," "July 2026"). Keep your summary formulas on each sheet, and they'll automatically calculate for just that month's data.

Alternatively, add a "Month" column to your data and use SUMIFS formulas to filter by month. For example:

=SUMIFS(D:D,B:B,"Groceries",A:A,">=2026-06-01",A:A,"<2026-07-01")

This sums groceries spent in June 2026. Adjust the dates as needed.

How do I find hidden spending to cut?

Look for recurring charges you forgot about. Go through subscriptions, streaming services, memberships, and app charges. Many people discover $50–$200 per month in forgotten subscriptions.

Use Spendcull.com to audit your subscriptions and find recurring charges to cancel. It pulls your transactions and surfaces recurring patterns, helping you fill in the expenses tab of your budget accurately.

How do I track my budget vs. actual spending?

Create a "Budget" column for your target spending per category and an "Actual" column for what you really spent. Add a third "Difference" column using this formula:

=C2-B2

(Assuming B is Budget and C is Actual, row 2 is your first data row.)

If the difference is negative, you overspent. If it's positive, you underspent. This helps you see which categories are busting your plan.

Should I build a budget spreadsheet myself or use a template?

Building from scratch takes about 20 minutes and teaches you how to customize it later. If you'd rather skip straight to entering numbers, a free monthly budget template has the categories, formulas and a planned-vs-actual layout already built, no email required. If your situation is more specific — splitting a budget between two incomes, a funding calendar for annual bills, or a full dashboard linking budget, debt payoff and net worth — sheetfolk's paid templates ($9-$29 one-time, not a subscription) are built for exactly those.

For more guidance on formulas, see our guide on Google Sheets budget formulas and explore free vs. paid Google Sheets budget templates.

How do I use this to improve my spending habits?

Review your budget weekly. Open your spreadsheet every Sunday and check which categories exceeded your target. Identify patterns: Are dining-out costs rising? Are subscriptions eating into your savings? Small adjustments compound—cutting $30 per month adds up to $360 per year. If Sunday reviews are the first habit to slip, a recurring reminder in TaskDrain keeps the check-in on your calendar instead of relying on memory.

If you're serious about tracking personal finances, combine your budget with a personal finance tracker in Google Sheets to monitor net worth, savings rate, and investments over time.

Disclaimer

This blog post is for informational purposes only and is not financial advice. Budget strategies and expense tracking methods should be adapted to your personal circumstances. Consult a financial advisor or accountant before making major financial decisions. The formulas and templates provided are tools to help you organize your own data; they do not constitute professional financial guidance.

Ready to skip the 20 minutes? A free monthly budget template has these formulas and categories already built in, no email required. Browse sheetfolk's paid templates ($9-$29 one-time) for a purpose-built layout instead.