Skip to content
The title slide and first slides of the Freelance Writer Income Tracker template

Freelance Writer Income Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Freelance writers use this income tracker to follow money from pitch to payment. The Assignments tab lists pieces with word counts and per-word rates. The Invoices tab records what was sent, what was received, what is still owed and a tax set-aside amount for each payment. The Clients and Forms tab shows who should send a tax form and totals what each client paid. The Dashboard puts collected and owed money side by side by client.

Update the sheet each time an invoice goes out and each time a payment lands. Late invoices turn red so you know whom to chase. Pick a set-aside percentage with advice from a preparer, and move that money into savings as each payment lands. In January, check the Clients and Forms tab against the forms that arrive and compare them with your own totals.

Useful for

  • Chase late invoices before the month ends
  • Compare 1099 forms with your own payment totals
  • Put part of every payment into tax savings

What's included

  • 5 tabs: Dashboard, Invoices, Clients and Forms, Assignments, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Invoices: a table
  • Clients and Forms: a table
  • Assignments: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Invoices tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do freelance writers track income for taxes?

Record each invoice and each payment with its date, client and amount. Compare your yearly totals by client with the tax forms you receive, and keep the invoices and bank records that support them.

What if a client never sends a 1099?

The income still counts without a form. Report it from your own records, and get advice from a tax professional on any mismatch with a client's totals.

What percentage of a payment goes to tax savings?

No one number fits everyone. Your income, deductions and location all play a part. Get a percentage from a tax professional, enter it in the Set aside column, and review it during the year.

  • #tax-tracker
  • #freelance-writer-income-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…