Google Sheets income tracker for freelancers: what to track and a sheet that does it
Quick answer
A good income tracker for freelancers in Google Sheets logs one row per invoice with the client, the amount, the currency, the date you sent it and the date it was paid. From those five things it can show what you earned this month, who still owes you, and which payments are late. Add the fees your platform or bank took, and it shows what you actually kept.
You can build this yourself in a blank sheet for free. If you want it ready, the Plainsort Income Tracker does all of it in the free Google Sheets app, with example invoices so you see how it works before you type your own.
What to track (the columns that matter)
- Client. Pick from a list so the same client is never spelled two ways.
- Amount and currency. Clients pay in USD, AUD, GBP or pesos. Log what they sent, then convert once.
- Invoice date. When you asked for the money.
- Paid date. When it landed. Keep this separate from the invoice date, or a June invoice paid in July counts in the wrong month.
- Fees. PayPal, Wise or bank fees. This is the gap between what you billed and what you can spend.
That is the whole sheet. Everything else (monthly totals, late list, best paying client) is a formula on top.
Free vs ready made: a short comparison
| Option | Price | Good for | Watch out for |
|---|---|---|---|
| Blank Google Sheet you build | Free | People who like building formulas | Late invoices and currency conversion take time to set up |
| Income trackers on Etsy | About $1.73 to $12.99 (Etsy search, checked 27 Oct 2026) | Picking a look you like | Many are income and expense in one; check the photos show the file you get |
| Plainsort Income Tracker | $4.99 Gumroad, ₱289 Etsy | Freelancers and VAs paid by several clients, in more than one currency | Google Sheets only (works in the free phone app) |
| Plainsort Freelancer Money Bundle | ₱449 on Etsy | Tracking income, then budgeting it | Three separate sheets, one copy link each |
How to start in 5 minutes
- Open the sheet and click File, Make a copy.
- Look at the example invoices, then delete them.
- Add your clients in Settings and log your last paid invoice.
Not sure what to charge yet? Try the free rate calculator first. Need to send the invoice? The free invoice generator works in any currency.
Related guides: Freelancer budget spreadsheet for 2027 · Free CRM for virtual assistants
Questions people ask
Is there a free income tracker for freelancers in Google Sheets?
Yes, you can build one in a blank sheet with the five columns in this guide. A ready made one saves the setup time for late invoice flags and currency conversion.
Can I track income in different currencies?
Yes. Log the amount in the currency the client paid, and let the sheet convert it to your home currency with a rate you set.
Does it work on my phone?
The Plainsort Income Tracker works in the free Google Sheets app on Android and iPhone. You need a free Google account.
How do I see which clients have not paid?
Leave the paid date empty until the money lands. The Plainsort Income Tracker lists those unpaid invoices and flags the late ones on its own.
Ready made
Plainsort Income Tracker
Every client payment with the currency, fees and paid date, and a list of who is late. Works in the free Google Sheets app. $4.99 on Gumroad or ₱289 on Etsy.
Get it on Gumroad, $4.99 Get it on EtsyWant income, budget and expenses together? The Freelancer Money Bundle is ₱449 on Etsy. See the Income Tracker page for screenshots.