Freelancer Project Tracker Spreadsheet: Clients, Time Log, Invoices & Real Hourly Rate (Excel + Google Sheets)

Freelancer tracker: clients, projects, time log, invoices and your real hourly rate on every project. Excel + Google Sheets, with a setup guide and video.

Watch the setup guide & full tour

See which clients and projects are really worth your time.

The Freelancer Project Tracker is a ready-to-use spreadsheet for Microsoft Excel and Google Sheets. Add clients and projects, log your hours and invoices. Your real hourly rate, money owed and income vs goal work themselves out.

What’s inside (9 connected tabs)

• Start Here: 6-step setup + colour key
• Dashboard: Active projects, hours, paid, owed, real rate
• Setup: Currency, default rate, income goal, terms
• Clients: 50 clients with invoiced, paid and owed
• Projects: 100 projects: fixed, hourly or retainer
• Time Log: 500 entries, hours from start and end
• Tasks: 200 to-dos with due-date flags
• Invoices: 200 invoices, status worked out for you
• Monthly: Hours, invoiced and paid vs goal, chart

Why you’ll like it

• Real hourly rate per project: fixed fee ÷ hours you actually logged
• Fixed, hourly and retainer projects in the same tracker
• Invoice status worked out for you, with overdue money on the dashboard
• Projects flagged when they’re late, under-priced or not yet invoiced
• Monthly income vs your goal, with a chart

Also included

• Setup Guide PDF
• Video walkthrough https://youtu.be/CoaKLlycKVc
• Sample data that follows today’s date

Formulas only: no macros, no add-ons, no subscription. Works in Excel 2016+, Microsoft 365 and Google Sheets.

Part of the Project Management Spreadsheet collection. More tools at createdigitaltools.com