Freelancer Income & Tax Tracker 2027 - Hourly Rate Calculator, Client & Invoice Tracker (Excel & Google Sheets)

Track every invoice, fee and expense - see how much to set aside for tax - and finally know what to charge.

NEW IN THIS VERSION

• Rate Calculator - type the take-home pay you want, your expenses, tax set-aside %, platform fee % and billable hours. Get your MINIMUM hourly rate, day rate, and a ready quote for any project (with a buffer for revisions).

• Client Summary - billed, fees, net income, unpaid now, share of your income and average days to get paid for every client. Slow payers are flagged red; relying too much on one client is flagged too.

WHAT'S INCLUDED (2 files)

• Freelancer_Income_Tax_Tracker_EXAMPLE.xlsx - filled with sample invoices so you can see how it works

• Freelancer_Income_Tax_Tracker.xlsx - blank, ready for your work

TABS

• How To Use - simple guide

• Settings - year, tax set-aside %, monthly income goal

• Dashboard - billed, platform fees, expenses, profit, tax to set aside, take-home, unpaid invoices, goal progress, monthly + quarterly tables, by platform

• Rate Calculator (NEW)

• Client Summary (NEW)

• Income - up to 400 invoices: client, project, platform (Upwork, Fiverr, direct, PayPal, Stripe...), fee, paid / unpaid, date paid

• Expenses - up to 300 expenses with business-use %

HOW IT WORKS

1. Set your year, tax % and income goal

2. Log each invoice and expense

3. Check your rate and clients - the Dashboard does the maths

WORKS IN: Microsoft Excel, Google Sheets (File > Import) and Apple Numbers.

Instant download. The tax set-aside is a simple savings estimate, not tax advice. Ask a local accountant what % to save where you live.

Personal use. Please do not resell or share.

Images made by me from the real spreadsheet; some design help from AI tools.