Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyFreelancer FinanceFreelance Client & Project Tracker

SpreadsheetFreelancer FinanceFree

Freelance Client & Project Tracker

Every project with client, fee, hours logged, effective hourly rate, deadline and invoice status.

Shown with sample data

Colour

Freelance Client & Project Tracker

Every project with client, fee, hours logged, effective hourly rate, deadline and invoice status.

Paid this year
$6,800
Awaiting payment
$9,200
Ready to invoice
$3,200
Average effective rate
$102
Fee ÷ hours
Fee by type
  • Website$14,600
  • Brand identity$14,300
  • Consulting$3,200
  • Retainer$1,800
Share of fee by type
  • Website$14,60043%
  • Brand identity$14,30042%
  • Consulting$3,2009%
  • Retainer$1,8005%

How to use it

  1. 1Add each project when you quote it.
  2. 2Update the stage as it moves and log hours weekly.
  3. 3Invoice everything marked Ready to invoice.
  4. 4Compare effective rates when deciding what to take on next.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Run your freelance work from one sheet. Track each project’s stage, fee and deadline, log the hours it takes and see your effective hourly rate, so you know which clients and project types are worth more of your time and what is still to be invoiced.

Who it’s for

  • Juggling several clients
  • Finding your most profitable work
  • Month-end invoicing

What’s included

  • Projects sheet: One row per project.
  • Summary by Type sheet: Fee and Hours logged and the number of entries for each type, calculated from the Projects sheet.

How to use it

  1. 1Add each project when you quote it.
  2. 2Update the stage as it moves and log hours weekly.
  3. 3Invoice everything marked Ready to invoice.
  4. 4Compare effective rates when deciding what to take on next.
Related searchesfreelance trackerclient trackerproject pipelineeffective hourly ratefreelance business

Details

Format
Spreadsheet
Category
Freelancer Finance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFreelancer FinanceFree

Freelance Client & Project Tracker

Every project with client, fee, hours logged, effective hourly rate, deadline and invoice status.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Freelancer Finance
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More freelancer finance templates

View all
Freelance Rate Calculator2 sheets

Revenue needed

$84,309

Billable hours per year

1,080

Minimum hourly rate

$79

ABC
1Business costCategoryPer year
2Design and office softwareSoftware$1,400
3Laptop and equipment (yearly share)Equipment$900.00
4Professional indemnity insuranceInsurance$620.00
5Co-working membershipWorkspace$2,400
Costs
SpreadsheetFreelancer Finance

Freelance Rate Calculator

Work back from the income you want to the hourly and day rate you must charge, after costs, tax and unbilled time.

10 min setupPreview

Freelance Service Agreement

This agreement is between Freelancer name ("Freelancer") and Client name ("Client"), dated Date.

1. Services

The Freelancer will provide: Description of services.

Deliverables

DeliverableFormatDue date
Deliverable 1FormatDate
Deliverable 2FormatDate

Work outside this scope will be quoted separately before it starts.

DocumentFreelancer Finance

Freelance Service Agreement

A plain-language contract for freelance work: scope, fees, revisions, ownership, confidentiality and ending the agreement.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ