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

TL;DR: Create a working budget spreadsheet in Google Sheets by setting up income/expense columns, categorizing spending, and adding SUM formulas to track totals and remaining budget. This guide walks you through each step with copy-paste formulas. For a polished template ready in 2 minutes, use a pre-built Sheetfolk budget template instead.

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 screenshots 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 20 minutes and teaches you how to customize. However, if you want it done instantly with professional formatting, charts, and formulas already built, try a pre-made Sheetfolk budget template. Templates save time and include features like automatic category breakdowns, spending trends, and goal tracking.

For more guidance on formulas, see our guide on Google Sheets budget formulas and explore the best budget spreadsheet templates for Google Sheets.

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 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? Sheetfolk templates come with all formulas pre-built, charts included, and professional formatting. Browse budget templates or start with a free trial.