Skip to content
ClientPlot
Get started

Freelance Client Tracker Template

A client tracker for people who bill hours and send invoices themselves. Track the client, the current project, hours this month, whether an invoice is out, the due date and the next follow-up.

Download ExcelDownload CSV

Free download. No signup required.

No signup required. Excel includes the extra formatting. CSV is portable data only.

Outgrown the freelance spreadsheet?

Keep the spreadsheet if the hours column still works. Import the clients and projects into ClientPlot when follow-ups start slipping.

Free to preview. No credit card. Create an account only when you want to save your dashboard.

Import your freelance trackerSee ClientPlot
  1. Spreadsheet rowsClient records
  2. Project columnProjects under that client
  3. Deadline columnDue dates on the work
  4. Next action / next taskTrackable tasks
  5. Client notesNotes on the client page

Official ClientPlot templates skip the mapping quiz. ClientPlot counts what it found, then you import. Unusual spreadsheets still get a mapping review.

Freelance spreadsheet

  • Hours and invoices in the same row as the client
  • Easy to miss a follow-up
  • One row per client

ClientPlot

  • Clients and projects linked
  • Follow-ups on Today
  • Hours preserved in notes

Template preview

Sample rows so you can see what you will download. Scroll sideways on a phone if the table is wider than the screen.

Freelance Client Tracker Template sample data
Client NameCompanyEmailPhoneStatusProjectHours This MonthInvoice StatusDue DateNext Follow-UpNotes
2Acme CoAcme Coops@acme.example(555) 201-0101ActiveHomepage refresh18.5Sent2026-09-122026-08-22Monthly retainer. Invoice 1042 sent. Prefers email.
3Smith LLCSmith LLChello@smithllc.example(555) 201-0102ActivePhoto shoot package6Unpaid2026-08-242026-08-29Day rate plus two selects. Nudge if unpaid Friday.
4Jones CoJones Copriya@jonesco.example(555) 201-0103On HoldIdentity system0None2026-09-182026-09-02Paused while they finish hiring. Do not invoice yet.
5Harbor ClinicHarbor Clinicadmin@harborclinic.example(555) 201-0104ActivePatient intake page11Paid2026-08-262026-08-25Must match language they already use.
6Bright LabsBright Labsteam@brightlabs.example(555) 201-0105LeadOnboarding microsite2None2026-09-202026-09-01Kickoff not scheduled. Quote only.
7Mesa GoodsMesa Goodssam@mesagoods.example(555) 201-0106InactiveCatalog refresh0Paid2026-07-15Warm relationship. Check in after busy season.

What this spreadsheet looks like in ClientPlot

Upload your spreadsheet and ClientPlot turns the rows into clients, projects, tasks, deadlines and follow-ups on a live dashboard. Preview it before signup. Create a free account only if you want to save it. No credit card.

Dashboard preview

This replaces a formula Dashboard tab. Counts stay current after you import. Invoice totals and hours stay in the spreadsheet if you track them there.

MetricCurrent
Active Clients
6
Open Projects
6
Open Tasks
0
Follow-Ups Due
5
Waiting on Client
0
Upcoming Dates
6
Project StatusCount
Planning
0
In Progress
6
Waiting on Client
0
On Hold
0
Completed
0

Operational notes

After import, these counts stay current as you work. Invoice totals and hours stay in the spreadsheet if you track them there.

ClientOpen work

Clients with open work show here after import.

Upcoming schedule

  • 2026-07-15 · Catalog refresh · Mesa Goods
  • 2026-08-22 · Homepage refresh · Acme Co
  • 2026-08-25 · Patient intake page · Harbor Clinic
  • 2026-08-29 · Photo shoot package · Smith LLC
  • 2026-09-01 · Onboarding microsite · Bright Labs
  • 2026-09-02 · Identity system · Jones Co
Upload my spreadsheet freePreview this template as a dashboard

What is in the template

Client Name, Company, Email, Phone, Status, Project, Hours This Month, Invoice Status, Due Date, Next Follow-Up and Notes. Hours and invoice status stay in the sheet. On import, ClientPlot keeps them in notes so you do not lose them.

Client Name

Who hired you.

Company

Business name if it differs from the client.

Email

Primary contact email.

Phone

Best number for a quick call.

Status

Lead, Active, On Hold, Completed, or Inactive.

Project

The current piece of named work.

Hours This Month

Hours logged this month. Stays in the sheet; ClientPlot keeps it in notes on import.

Invoice Status

None, Sent, Unpaid, or Paid. Kept in notes on import.

Due Date

When the current project is due.

Next Follow-Up

The next date you should reach out.

Notes

Scope, rate, and anything that would surprise you later.

Who it is for

Freelancers who still run the business from a spreadsheet and need hours and invoice status next to the client, not in a separate billing tool they will not open.

How to use it

  1. 1. Update hours when you invoice, not every day

    A monthly number you will maintain beats a timesheet you abandon.

  2. 2. Invoice Status is Sent, Unpaid, Paid or None

    Unpaid plus a follow-up date is how quiet invoices get a call.

  3. 3. Keep the current project on the row

    When a new project starts, change the Project cell. History can live in notes.

  4. 4. Import when hours-in-Excel is the job

    Upload the file. Client, project, due date and follow-up map into ClientPlot. Hours and invoice status land in notes.

When a spreadsheet starts becoming difficult

  • Hours in one sheet, clients in another
  • Unpaid invoices with no follow-up date
  • A CRM that wants a pipeline you do not have

Hours stay in the spreadsheet until you outgrow it

ClientPlot does not pretend to be invoicing software. It keeps the client, project and follow-up.

The same file is the next step

Import when the list is noisy. You already have the names.

Frequently asked questions

Does this send invoices?

No. It tracks whether you sent one. Keep billing where it already lives.

Will ClientPlot import hours?

Hours and invoice status are kept in notes on import. Client, project, due date and follow-up become records you can work from.

Is there a signup wall?

No. Download Excel or CSV with no account.

Related resources