Google Sheets Income Tracker: Track Freelance Income for Taxes

The worst way to learn how much money you made last year is by staring at your bank account in February. You're scrambling to add up invoices, guessing which payments actually cleared, and realizing — too late — that you should have set more aside for taxes.

If you're freelance or self-employed, a Google Sheets income tracker is one of the highest-ROI things you can build in an afternoon. Done right, it gives you real cash flow visibility every month and turns tax prep from a panic into a 30-minute task.

Here's how to build one that actually holds up across a full year.

---

Why Most Freelancers Track Income Wrong

The most common approach: checking your bank balance and assuming that's your income. The problem is that bank balances mix income, expenses, refunds, and transfers. One good month can look like two if a client pays a backlog of invoices at once.

The second most common approach: a rough mental tally updated whenever you feel anxious. This works until it doesn't — usually right around Q4 when you realize you have no idea what your tax bill will look like.

What you actually need is a simple, consistent log that records every payment when it's received, categorized in a way that makes monthly summaries and tax prep effortless.

---

The 5 Columns Every Income Tracker Needs

Keep it minimal. These five columns capture everything important:

1. Date The date the payment was received — not the invoice date, not the due date. When money hit your account (or PayPal, or Wise). This matters for cash flow and taxes.

2. Client The name of the client or company. You'll use this to filter by client and to run summaries at year-end ("How much did Acme pay me in total?").

3. Project A short descriptor for what the payment was for. "Brand Identity," "Monthly Retainer," "SEO Audit." This gives you context when you're looking back months later.

4. Amount The gross amount received, in your base currency. Keep it clean — no dollar signs in the cell, just the number. Formatting is handled by the column, not the data.

5. Payment Status Paid, Pending, or Overdue. This is how you track what you've invoiced but haven't received yet. A quick scan of "Pending" rows tells you exactly how much is still owed to you.

---

Add a Monthly Summary Tab With Formulas

The raw income log is your source of truth. The summary tab is where it becomes useful.

Create a second tab called "Monthly Summary." Set up two columns: Month and Total Income. Then use SUMIF to pull totals from your income log:

=SUMIF('Income Log'!A:A,">="&DATE(2026,1,1),'Income Log'!D:D)
-SUMIF('Income Log'!A:A,">="&DATE(2026,2,1),'Income Log'!D:D)

Or use the cleaner approach: add a helper column in your income log that extracts the month from the date (=TEXT(A2,"YYYY-MM")), then use SUMIF against that column. Much easier to maintain.

Add a running total column next to monthly totals: =SUM($B$2:B2). This gives you a cumulative income figure that updates automatically as you add rows. Glance at it on the 15th of any month and you know exactly where you stand year-to-date.

---

Want a pre-built finance tracker? We have a ready-to-use Google Sheets template at notioncraft.madethis.app/free — grab the free version and upgrade when you're ready.

---

The Tax Prep Shortcut: Auto-Calculate Your Set-Aside

This one column saves freelancers hundreds of dollars in stress and accountant fees.

Add a Tax Set-Aside column to your income log. Enter your estimated tax rate — 25–30% is a common starting point for US-based self-employed workers — at the top of the sheet as a named variable. Then in each row:

=D2*$B$1

Where D2 is the income amount and $B$1 is your tax rate cell. Each time you log a payment, the column automatically shows how much to transfer to your tax savings account.

Add this to your monthly summary: =SUMIF(...) against the Tax Set-Aside column. At the end of every month, you know the exact amount to move to savings. No guessing, no panic in April.

---

The Monthly Close Ritual (20 Minutes on the 1st)

The tracker only works if you update it. Block 20 minutes on the first of every month and run through this:

1. Log all payments received last month. Go through your bank statements, PayPal, Stripe — anywhere you receive money. Add every payment to the income log with the correct date.
2. Update Payment Status. Mark anything that came in as "Paid." Anything still pending from last month that's now overdue? Change the status to "Overdue" and make a note to follow up.
3. Run your monthly summary. Open the summary tab and confirm the total looks right. Any surprises? Missing payments? Now's when you catch them.
4. Move your tax set-aside. Transfer the calculated amount from your summary to your tax savings account. Done.

Twenty minutes, once a month. That's all it takes to never be surprised by your own income again.

---

Advanced: Multi-Currency Support and Late Payment Flags

If you work with international clients, add a Currency column and an Amount (USD) column that converts using a fixed rate or a Google Finance formula:

=E2*GOOGLEFINANCE("CURRENCY:"&F2&"USD")

This gets unreliable with volatile currencies, so many freelancers prefer to just log the converted amount manually when they receive payment. Either way, tracking the original currency gives you better records.

For late payments, add a Days Late column:

=IF(G2="Paid", 0, MAX(0, TODAY()-C2))

Where C2 is the invoice due date and G2 is the Payment Status. This automatically calculates how many days overdue a payment is. Sort by this column when you need to know who to chase.

---

Skip the Build — Get a Pre-Built Template

Building this tracker from scratch is doable, but it usually takes 2–3 hours of formula work, testing, and debugging to get right. Our Personal Finance Tracker gives you a fully-built Google Sheets setup with income tracking, monthly summaries, tax calculations, and expense tracking — all pre-wired and ready to use.

Personal Finance Tracker (Google Sheets) — $19

A complete Google Sheets income and expense tracker for freelancers and self-employed founders. Log income, auto-calculate your tax set-aside, and see your cash flow at a glance — every month, not just at tax time.

Get the Personal Finance Tracker →

One-time purchase. Works in Google Sheets. Duplicate and start logging today.