How to Set Up Google Sheets for Budget Tracking (No Formulas Needed)

There's a common misconception that spreadsheet budget trackers are for accountants and finance nerds. That the moment you open Google Sheets, you need to know how to write complex formulas or you'll be hopelessly lost.

Not true. You can build a genuinely useful budget tracker in Google Sheets with just a handful of simple tools — and I'll walk you through every step. By the end of this guide, you'll have a working tracker that tells you exactly where your money is going, what's coming in, and whether you're on track.

No finance degree required.

Why Google Sheets Is Great for Budget Tracking

Google Sheets beats a dedicated budgeting app in a few important ways for freelancers and small business owners:

It's free. No subscription, no premium features locked away, no ads.
It's flexible. You decide the categories, the layout, the level of detail.
It's shareable. You can give your accountant view-only access in 30 seconds.
It's yours. No risk of an app shutting down and taking your financial history with it.

The downside is that it doesn't auto-import bank transactions. You'll need to log entries manually (or copy-paste from your bank export). For most freelancers, a quick weekly review is enough to keep it current.

Step 1: Create a New Spreadsheet

Go to sheets.google.com and click the + to create a blank spreadsheet. Name it something clear — "2026 Budget Tracker" or "Freelance Finances." You want to be able to find it immediately when you need it.

You'll be working on the first sheet (labeled "Sheet1" at the bottom). Start by renaming it — double-click the tab and type "Transactions."

Step 2: Set Up Your Columns

In row 1, create headers across the first five columns:

A1: Date
B1: Category
C1: Description
D1: Amount
E1: Type

The Type column is where you note whether each entry is "Income" or "Expense." This is the key field that lets you see your net position at a glance.

Make the header row bold (select row 1 → Ctrl+B) and give it a background color so it stands out. Nothing fancy — just something to visually separate the headers from the data.

Step 3: Add a Summary Tab With SUM Formulas by Category

Right-click the "Transactions" tab at the bottom and select Insert sheet. Name this new sheet "Summary."

Here's where a couple of simple formulas come in — and I promise they're not scary. In your Summary sheet, create two columns:

Column A: Category (list all your categories: Rent, Software, Subscriptions, Meals, Client Income, etc.)
Column B: Total

In column B, next to each category, use this formula:

=SUMIF(Transactions!B:B, A2, Transactions!D:D)

What this does: it looks at your Transactions sheet, finds every row where the Category column matches whatever's in A2, and adds up the amounts. Change A2 to whichever cell your category name is in.

Add a "Total Income" and "Total Expenses" row at the bottom using simple SUM formulas, then a "Net" row that subtracts one from the other. That's your budget dashboard.

Step 4: Use Conditional Formatting to Highlight Expenses Over Budget

This is optional but genuinely useful. Select your Transactions sheet, highlight the D column (Amount), go to Format → Conditional formatting, and set a rule: if the value is greater than (say) $500, highlight it red.

This gives you an instant visual alert for big-ticket expenses. You can also use it on your Summary sheet to highlight any category where you've gone over a threshold you set.

Step 5: Freeze the Header Row

Here's a small quality-of-life improvement that matters when your sheet has dozens of entries. Click on row 2 (the first data row), then go to View → Freeze → Up to row 1. Now when you scroll down, your column headers stay visible.

Same principle applies to your Summary sheet — freeze row 1 so the labels stay put.

Step 6: Add a Monthly Totals Section

On your Summary sheet, add a section at the bottom (or on a new tab) with monthly income and expense totals. You can do this manually — create a column per month and use SUMIFS to filter by both category and month.

Or simply use the Filter function: click anywhere in your Transactions sheet, go to Data → Create a filter, and then filter by date. It's not automated, but it's fast enough for a weekly review.

Step 7: Share With an Accountant or Partner (View-Only Link)

When tax time rolls around (or when you just want a second set of eyes on your numbers), you can share your spreadsheet in seconds. Click Share in the top-right corner. You can either enter someone's email directly, or click Copy link and set the permission to "Anyone with the link can view."

View-only sharing means they can see your numbers but can't accidentally edit anything. Perfect for accountants.

Pro Tips

Use data validation for the Category column. Instead of typing your category every time (and accidentally creating "Meals" and "Meal" as two different categories), use a dropdown list. Select column B, go to Data → Data validation, and add your category list. Now you click instead of type, and your data stays consistent.
Run a weekly 5-minute review. Budget trackers only work if you actually use them. Block 5 minutes every Monday morning to log last week's transactions. It takes less time than you think, and it means you're never doing a massive catchup session at month-end.
Back up monthly with File → Download → Excel. Google Sheets auto-saves to the cloud, but a monthly local backup (download as .xlsx) is good practice. If something ever goes wrong with your Google account, you have your financial history safe on your computer.

Already-Built and Formatted for Freelancers

If you'd rather skip the setup entirely and start with a tracker that's already built and formatted specifically for freelancers, the Skillhood Freelancer Starter Pack ($22) includes a pre-built income and expense tracker — complete with categories, summary dashboard, and formulas already in place.

Get the Freelancer Starter Pack →

Frequently Asked Questions

What's the best way to track expenses in Google Sheets?

The most effective approach is a simple transactions log: one row per expense, with columns for date, category, description, amount, and type (income vs. expense). Keep it consistent — log entries at least weekly — and add a summary tab with SUMIF formulas to see your totals by category. Simplicity beats complexity for long-term use.

Do I need to know formulas to use Google Sheets for budgeting?

Not really. The only formula that makes a big difference is SUMIF, which totals up entries by category. It's one formula with three parts: the range to search, the value to search for, and the range to sum. Once you've written it once, you copy-paste it for every category. Everything else in a basic budget tracker is just typing data into cells.

How do I make Google Sheets automatically calculate totals?

Use SUM or SUMIF formulas in a Summary tab. The SUM formula adds up a range of cells (e.g., =SUM(D2:D100) adds everything in column D from row 2 to 100). The SUMIF formula adds up only the cells that match a condition (e.g., only "Expenses" or only the "Software" category). Write the formula once, and it updates automatically every time you add a new entry to your Transactions sheet.