A freelance project can look well paid until meetings, revisions, administration, expenses, and platform fees are included. This freelance time tracking and profitability template shows how to record planned and actual work, calculate effective hourly pay, and use the results to improve quotes, contracts, and project choices.
Overview
Tracking hours is more useful when it answers a business question: did this project produce a reasonable return for the time and cost involved? A simple project profitability review compares the money received with every meaningful input, not just the hours spent on the final deliverable.
Use a spreadsheet, project-management tool, or time-tracking app with one row per project and separate time entries for each activity. The method works for fixed-fee projects, hourly contract jobs, retainers, and gig work. It can also help when comparing remote freelance jobs or deciding whether a new contract fits your target rate.
At minimum, record:
- Project or client name
- Quoted or contracted fee
- Planned hours
- Actual hours by activity
- Meetings and communication time
- Revision and rework time
- Direct project expenses
- Platform, payment, or transaction fees
- Amount invoiced and amount received
The most useful output is your effective hourly rate. This is the money left after direct costs and fees, divided by the total time you actually worked.
Effective hourly rate = (gross revenue − direct expenses − fees) ÷ total project hours
This is not the same as a salary, take-home pay, or taxable profit. It is a practical project-level measure that helps you compare assignments using consistent inputs. For broader decisions about rates, review the Freelance Rates Benchmark alongside your own records.
How to estimate
Start before accepting the project. Enter the expected fee and a realistic estimate of the work. Divide the project into activities rather than guessing one total number.
| Activity | Planned hours | Actual hours |
|---|---|---|
| Research or preparation | 6 | — |
| Production or delivery | 12 | — |
| Meetings and messages | 2 | — |
| Revisions | 3 | — |
| Administration | 1 | — |
| Total | 24 | — |
Then calculate an estimated effective rate:
Estimated effective rate = (agreed fee − expected expenses − expected fees) ÷ planned hours
If the result is below the minimum rate you need, adjust the scope, fee, deadline, or revision allowance before work begins. A project may still be worthwhile for strategic reasons, but that choice should be deliberate rather than caused by missing time records.
During delivery, use a consistent timer or enter time at the end of each work session. Label entries clearly, such as “client call,” “first draft,” “revision round two,” or “invoice administration.” Avoid relying on memory at the end of the month; small unrecorded tasks can materially change the result.
At completion, replace planned hours with actual hours and add all direct costs. If the project is ongoing, review the figures at a milestone instead of waiting until the final invoice. This creates an opportunity to flag scope expansion early. For a repeatable start-to-finish workflow, use the Freelance Client Onboarding Checklist.
Inputs and assumptions
A useful template separates facts from assumptions. Facts include hours already worked, invoices issued, and fees charged. Assumptions include expected revision time, future expenses, and the amount of work remaining.
Revenue
Enter the agreed project fee or the hourly revenue generated so far. If the work is billed in stages, record each invoice separately and keep invoiced revenue distinct from money actually received. That distinction helps with cash-flow reviews and makes it easier to follow up on unpaid invoices. See the Freelance Invoice Template for a practical invoicing checklist.
Time
Include all work required to deliver and manage the project. Commonly missed categories are discovery calls, email, file preparation, travel between locations when relevant, project setup, quality checks, revisions, and invoicing. Do not change your definition of “work time” from one project to another, or comparisons will be misleading.
Expenses and fees
Record costs that exist because of the project, such as specialist assets, software used only for the assignment, subcontracted support, shipping, or approved travel. Add marketplace, payment-processing, or currency-conversion fees when they apply. Check the terms of each platform or payment provider rather than relying on a general fee assumption.
Unpaid or non-billable work
Whether time is billable and whether time is profitable are different questions. A fixed-fee project may have no separate line item for meetings or revisions, but those hours still reduce the effective rate. Track them even when the contract does not permit separate billing.
Tax and bookkeeping boundaries
This template is a management tool, not a substitute for local tax or accounting advice. Keep receipts, invoices, payment records, and business-expense notes in the system required for your location. Tax treatment can vary by jurisdiction and business structure, so verify record-keeping requirements independently and review them regularly.
Worked examples
Example 1: Fixed-fee project
Assume a project has a contracted fee of 1,200 currency units. The freelancer spends 25 hours on research, production, meetings, revisions, and administration. Direct expenses total 80, and payment fees total 20.
Effective hourly rate = (1,200 − 80 − 20) ÷ 25 = 44 currency units per hour
The initial estimate may have assumed 20 hours. If so, compare the planned and actual results:
- Estimated rate before costs: 1,200 ÷ 20 = 60 per hour
- Actual rate after costs: 1,100 ÷ 25 = 44 per hour
The gap does not automatically mean the project was a mistake. It identifies what to investigate: underestimated revisions, unclear scope, excessive meetings, or an expense that should have been quoted separately.
Example 2: Hourly contract with unpaid administration
Assume an hourly contract produces 900 currency units from 18 billed hours. The freelancer also spends 3 hours on calls, reporting, and invoice administration, with no additional direct costs.
Effective hourly rate = 900 ÷ (18 + 3) = approximately 42.86 per hour
The billed rate may look acceptable when viewed only through the 18 invoiced hours. Recording the additional time gives a more realistic basis for deciding whether the contract needs a higher rate, a minimum booking, clearer communication limits, or a separate administration allowance.
Example 3: Revision-heavy project
For a 750-unit project, planned work is 15 hours, but two extra revision rounds add 6 hours. If total time reaches 24 hours and direct costs are 30, the effective rate is:
(750 − 30) ÷ 24 = 30 currency units per hour
Use the result to improve the next proposal. You might define the included revision rounds, charge for additional changes, request consolidated feedback, or add a contingency to the estimate. The Freelance Contract Checklist can help you review scope, payment, and change terms before accepting similar work.
When to recalculate
Recalculate at four points: before sending a quote, after a major scope change, at each project milestone, and immediately after completion. These checkpoints make the spreadsheet a decision tool rather than an archive.
Revisit your assumptions when:
- The client adds deliverables, stakeholders, or revision rounds.
- The deadline changes and requires faster or less efficient work.
- A platform, payment provider, or software fee changes.
- Your typical time for a role or deliverable has changed.
- Your target rate, workload, or available working hours changes.
- You begin using a new contract, marketplace, or billing arrangement.
Review completed projects monthly or quarterly, depending on your workload. Look for patterns rather than judging one result in isolation. Group projects by service, client type, contract structure, or acquisition channel. You may find that a particular service is consistently profitable, while another loses time through revisions or unpaid communication.
Refresh fee and platform assumptions at least every six months, and check tax-record guidance annually or whenever your circumstances change. Keep a dated copy of your template so you can see which assumptions produced each result.
For your next project, take these five actions:
- Copy the template and enter the proposed fee and expected costs.
- Break the work into activities and estimate hours for each.
- Set a review point before the first milestone.
- Track every work session, including meetings and revisions.
- Compare actual results with the estimate and adjust your next proposal.
Pair profitability records with a clear Freelance Proposal Template and a written scope. Over time, your own project history becomes a more useful pricing guide than a single generic hourly figure.