What fields should a freelance income tracker have?

At minimum: client, project, amount, invoice date, date paid, and status. Optional but useful: payment method, category of work, and a reference to the related expense or invoice. Keep it lean — every column you add is a column you have to fill in, so only add what you'll actually filter or sum by.

How do I see how much I've earned this month in a spreadsheet?

Use a SUMIFS formula that adds the amount column where 'date paid' falls in the current month, or filter the sheet to that month and read the column total Google Sheets shows at the bottom. For a persistent number, put the SUMIFS result on a dashboard tab so it updates automatically as you log payments.

Can a spreadsheet track recurring or retainer income?

Yes. Add a 'type' column (one-off, retainer, recurring) and, for retainers, one row per billing period so each payment is tracked separately. A filter on just retainer rows shows your predictable baseline income versus project income.

How to Track Freelance Income in a Spreadsheet (Step by Step)

Last updated July 7, 2026

To track freelance income in a spreadsheet, build one Income tab with columns for client, project, amount, invoice date, date paid, and status. Add a status column (invoiced, paid, overdue) and a monthly SUMIF that totals what you've earned. Sort or filter by client to see your top payers, and filter by 'paid this month' for a live income total. Works the same in Google Sheets or Excel.

Income tracking is where a freelance finance system lives or dies. Get this one tab right and everything else — profit, taxes, invoicing — has something clean to build on. Here's how to set it up in a Google Sheet (or Excel) so it takes seconds to update and gives you real answers.

Step 1: Create the Income tab

Make a new sheet tab and add these columns:

Client (text)
Project (text)
Amount (number, formatted as currency)
Invoice date (date)
Date paid (date — leave blank until they actually pay)
Status (a dropdown: invoiced, paid, overdue — use Data → Data validation in Google Sheets)

Step 2: Add the views that matter

One tab, several lenses using filter views (Google Sheets) or filters (Excel):

This month, paid — filter status = paid and date-paid = current month. Sum the amount column for your live monthly income.
Outstanding — filter status = invoiced or overdue. This is what you're owed; it doubles as your follow-up list.
By client — sort or group by client to see who actually pays your bills (and who quietly makes up most of your income).

Step 3: Make updating it a two-second habit

The system only works if it's current. Log a row the moment you send an invoice, and fill in "date paid" the moment money lands. Because you're only touching two cells, it never feels like bookkeeping.

Step 4: Connect it to profit

Your income tab is one half of your real profit. Pair it with an expense tab tagged by tax category, and a dashboard can subtract one from the other with a couple of SUMIF formulas to show gross-vs-net by month. That full picture is what the Freelancer Finance OS assembles for you out of the box.

For the complete system, see the freelancer finance tracker template guide. To decide between tools first, read spreadsheet vs Notion for freelance bookkeeping.

Frequently asked

What fields should a freelance income tracker have?: At minimum: client, project, amount, invoice date, date paid, and status. Optional but useful: payment method, category of work, and a reference to the related expense or invoice. Keep it lean — every column you add is a column you have to fill in, so only add what you'll actually filter or sum by.
How do I see how much I've earned this month in a spreadsheet?: Use a SUMIFS formula that adds the amount column where 'date paid' falls in the current month, or filter the sheet to that month and read the column total Google Sheets shows at the bottom. For a persistent number, put the SUMIFS result on a dashboard tab so it updates automatically as you log payments.
Can a spreadsheet track recurring or retainer income?: Yes. Add a 'type' column (one-off, retainer, recurring) and, for retainers, one row per billing period so each payment is tracked separately. A filter on just retainer rows shows your predictable baseline income versus project income.

Part of our bigger guide: The Best Freelancer Finance Tracker Template (Google Sheets, 2026).

Keep reading

Ready to shop? See the gear →