● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Freelancer Tools›Freelance Income Tracker Spreadsheet
Freelance Income Tracker Spreadsheet hero preview showing the income workbook
FREELANCER TOOLS

Freelance Income Tracker Spreadsheet

The work is done, the invoice is sent, and then the month blurs into who paid, who is late and what is actually yours. This freelance income tracker sorts income by client, project and month, and sets the tax money aside before you can spend it.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know what you earned, and what is still owed

Freelance income rarely arrives in a neat monthly salary, which is why it is so easy to lose track of it. This tracker asks for one small entry per payment: date, client, project, type, amount and status. That is all the typing there is. From that single log, paid, pending and overdue stay clearly separate, so the money in your account, the money you are waiting on and the money you need to chase never get mixed into one vague total.

The value builds in the tabs behind the log. Each client gets one row where lifetime billed, paid and outstanding are counted automatically, which answers at a glance who your best client is and who owes you the most. Projects get the same treatment, with the agreed fee beside what has actually been received and what is still outstanding. The monthly summary then lays out the whole year, month by month, including slow months, which are a normal part of freelancing.

Tax is treated as part of the routine rather than a yearly panic. You set your rate once, the example uses 25 percent, and the set-aside and net after tax figures fill themselves in on every row. The dedicated tax tab totals what to save quarter by quarter and records what you have already paid, leaving the amount still to keep aside. The dashboard pulls everything together with your best month, best client and progress against the monthly income goal you set.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link to your own copy in Google Sheets
  • BLANK Excel workbook, clean and ready for your own income
  • EXAMPLE Excel workbook filled with realistic demo data to explore first
  • Quick Start Guide PDF walking through setup in Excel and Google Sheets
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel and in Google Sheets
  • Your files stay on your computer and in your own Google account
  • Tax rate can be changed in one place and applies everywhere
  • Income Log holds 60 rows, Clients and Projects hold 20 rows each
  • A planning tool, not tax advice, check filing with an accountant

Questions about this template

The things buyers ask us most.

Do I need to know formulas to use it?

No. You only type in the plain columns of the Income Log: dates, client and project names, amounts and statuses. Every total, client balance, project balance and tax figure is calculated for you from those entries. If you can fill in a simple table, you can run this tracker, and the Quick Start Guide explains the short routine in order before you log your first real payment.

Can I change the tax rate?

Yes. The tax rate lives on the Settings and Lists tab, and changing it once updates every income row, the monthly summary and the Tax Set-Aside tab. The example workbook uses 25 percent as a common starting point, but your own rate may differ by country and circumstances. Set the figure that fits you, and check your actual tax position with an accountant before you file.

What if a client pays late?

Mark that row as Overdue on the Income Log. The amount then appears in the overdue totals on the Dashboard and in the Monthly Summary, so you can see at a glance exactly who to follow up with and how much is outstanding. Once the payment arrives, change the status to Paid and the totals update themselves, keeping your paid, pending and overdue figures honest.

Is my income data private?

Yes. The workbook lives on your own computer and, if you use the Sheets version, in your own Google account. We never see your income, your clients, your projects or your rates, and nothing in the file connects to a bank or sends data anywhere. It is simply a spreadsheet you control, which is exactly how a record of your earnings should be kept.

More in Freelancer Tools

All templates in this category →

Three more workbooks from the same shelf.

Freelancer Expense Tracker

Log business expenses in seconds and watch spending sort itself by category and month.

$5.99 $2.40
View on Etsy
Freelancer Content Tracker

Track content orders from queued to paid, with clients, due dates and earnings in one place.

$4.99 $2.00
View on Etsy
Freelancer Project Tracker

Keep projects, tasks and deadlines in one calm sheet, with overdue warnings built in.

$5.99 $2.40
View on Etsy
View on Etsy · $3.00