Skip to content
Freelance Time Tracker cover: a sample sheet with hours tracked, invoiced and unbilled and a bar chart, beside the Dashboard, Time log and Clients tabs

Freelance Time Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Freelance Time Tracker is for a self-employed designer, developer, writer or consultant who bills several clients by the hour. The Time log tab records each session with its date, client, work done, start and finish times, hours, rate, amount and a status of Unbilled, Invoiced or Not billable. The Clients tab stores each hourly rate and totals the hours, invoiced amount and unbilled amount for that client. The dashboard adds up the hours and money and shows the split by client.

Choose the client before you type the times, so the rate fills in and the amount is right from the start. Log calls and admin as Not billable, which keeps them in the hours without adding to the amount. Before you send each invoice, check the Unbilled figure for that client on the Clients tab, then change the matching rows to Invoiced so the two totals stay in step.

Useful for

  • Total hours for each client before sending a monthly invoice
  • Separate billable work from admin and client calls
  • See which clients have the most unbilled time waiting

What's included

  • 4 tabs: Dashboard, Time log, Clients, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Time log: a table
  • Clients: a table
  • 2 charts 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 Time log 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

What if I change a client's rate partway through the month?

The rate column looks up the current rate on the Clients tab, so every row changes at once. If earlier work should keep the old rate, type the rate into that row's rate cell and replace the formula there. Keep a note of the change so the invoice matches what you agreed.

Can I track a session that runs past midnight?

Enter the finish time as it appears on the clock and the hours may show as negative. Split the session into two rows, one ending at midnight and one starting at midnight, so the hours add up correctly on each day.

How do I use the totals for a tax return?

The invoiced amounts show what you billed in each period, which helps when you prepare your records. Check current IRS rules or ask a tax professional about what income and expenses you need to report, since this sheet only tracks time.

  • #timesheet
  • #freelance-time-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More timesheet templates

See all 10

Also in Human resources

All human resources templates
Get this template

Preparing your template…