How to Track Freelance Income and Expenses in Google Sheets

Freelancing comes with one unavoidable admin task: tracking what's coming in and what's going out. Without it, tax season becomes a panic, and it's hard to know if you're actually profitable.

Most freelancers either use expensive software they don't fully need, or they fall back on manually logging transactions in a spreadsheet. There's a better way.

This guide walks through building a practical freelance finance tracker in Google Sheets, with transactions synced from your bank via SheetLink.

Why Google Sheets Works Well for Freelancers

• It's free. No monthly subscription for a tool you use once a month.
• It's flexible. You build exactly what you need, not what a SaaS product thinks you need.
• Your accountant can access it. Share a link and they're in. No exports, no software to install.
• It survives company shutdowns. The data is yours, in a file you control.

The missing piece has always been getting the data in without manual entry. That's what SheetLink solves.

The Setup

1. Connect your business bank account to SheetLink

If you have a dedicated business checking account (highly recommended), connect it to SheetLink. If you're using a personal account, connect that. You'll filter later.

2. Link to a Google Sheet

Create a sheet called "Finances 2026" (or whatever year). Link it in SheetLink's Sheet tab. Run your first sync, and you'll get a Transactions tab and an Accounts tab.

3. Add a Category column

SheetLink writes Plaid's category for each transaction, but you may want your own. Add a My Category column and use a dropdown (Data → Data validation) with values like:

• Client Payment
• Software & Tools
• Travel
• Office & Supplies
• Marketing
• Meals (50% deductible)
• Health Insurance
• Personal (not deductible)

You'll fill these in once per new merchant, then copy them down for future syncs.

The Core Sheets to Build

Transactions (auto-generated by SheetLink)

This is your source of truth. Don't modify the raw data. Build everything else on top of it with formulas that reference this sheet.

Income Summary

A simple pivot: income by month. Use SUMIFS with MATCH to find columns by header name:

=-SUMIFS(
  INDEX(Transactions!$A:$AJ, 0, MATCH("amount", Transactions!$1:$1, 0)),
  INDEX(Transactions!$A:$AJ, 0, MATCH("My Category", Transactions!$1:$1, 0)), "Client Payment",
  INDEX(Transactions!$A:$AJ, 0, MATCH("date", Transactions!$1:$1, 0)), TEXT(DATE(2026,A2,1), "yyyy-mm") & "*"
)

Where A2 contains the month number. SheetLink writes dates as text (YYYY-MM-DD), so the formula matches the month as text (for example 2026-03*) rather than comparing dates. Amounts follow Plaid's sign convention (positive is money out, negative is money in), so the minus sign in front makes income show as a positive number.

Expense Summary by Category

Same pattern, without the minus sign: sum expenses by category per month. This becomes your tax prep worksheet.

P&L Tab

Revenue minus expenses, by month. Three rows: Revenue, Expenses, Net. Build a simple bar chart on top of it and you have a dashboard.

Tax Prep: The Real ROI

At tax time, you need:

1. Total income (easy: sum Client Payment category)
2. Deductible expenses by category (filter your expense sheet)
3. Mileage and home office (tracked separately, not in bank data)

With SheetLink keeping your transactions current, your accountant gets a clean spreadsheet instead of a shoebox of receipts. Some accountants will charge less for this, since it's less work on their end.

What Pro adds

The Free plan syncs the last 7 days. For freelancers, you need the full year, especially for quarterly estimated taxes. Pro ($4.99/mo or $39.99/year) gives you up to 2 years of transaction history across all connected accounts.

The 15-Minute Monthly Routine

Once this is set up, your monthly finance review takes about 15 minutes:

1. Open SheetLink, click Sync Now (10 seconds)
2. Review new transactions, fill in any missing My Category values (5 minutes)
3. Glance at your P&L tab (30 seconds)
4. Note anything unusual. Done.

That's it. No software to log into, no subscriptions beyond Sheets, no data locked up somewhere you can't export it.

Questions