Record time while the work is fresh, mark whether the agreement permits billing, and separate approved work from anything still being queried. A recorded hour and an invoiceable hour are different things.
Download the working timesheet
Download the freelance timesheet (.xlsx). Use the blank Timesheet tab for your work and Example week to see the formulas in action. It includes date, client/project, task, duration, billable status, hourly rate, approval and invoice reference.
Enter durations as h:mm: 1:30 is one hour and 30 minutes. Do not type 1.30 to mean 90 minutes. The decimal-hours column converts the time for billing. Use one row per task and split sessions spanning midnight into separate dated rows. The template flags durations of 24 hours or more for checking.
A completed hypothetical week
| Task | Duration | Billing position | Ready to invoice |
|---|---|---|---|
| Draft copy | 2:30 | Billable, approved | £125.00 |
| Own business admin | 0:45 | Non-billable | £0.00 |
| Editing | 1:30 | Billable, approved | £75.00 |
| Extra revision | 1:00 | Awaiting approval | £0.00 |
| Final checks | 0:30 | Already invoiced | £0.00 |
| Total recorded | 6:15 (6.25 hours) | Ready amount | £200.00 |
The ready amount includes only billable rows that are approved (or genuinely do not require approval) and have no invoice reference. After invoicing the four approved, unbilled hours, enter the invoice reference on those rows. Their ready amount becomes zero, which helps prevent billing them twice.
Define billable work first
Check the agreed scope and charging basis. Delivery work, meetings, travel and revisions may have different rules. Label an extra request “Pending” until it is authorised. “Not required” is for an agreement that does not require an additional approval step; it is not a shortcut around a disputed charge.
Use a short daily routine
- Start a timer or note the start time when beginning one task.
- Stop for breaks and task changes. Avoid overlapping timers.
- Record the task and actual duration before the end of the day.
- Check missed entries against your calendar or work record. Label an estimate rather than manufacturing precision.
- At the weekly review, resolve pending items and confirm the agreed rate.
Keep an audit note when correcting a material entry: original duration, corrected duration and reason. Store the sheet securely because client names and project details may be confidential. This downloadable workbook runs in your spreadsheet application; The Coven does not receive your entries.
What if the project has a fixed fee?
Track time to understand capacity, but invoice the agreed project fee. A hypothetical £600 project taking 12 hours produces £50 per recorded hour before expenses and tax. If it takes 16 hours, that falls to £37.50. The extra four hours do not automatically entitle you to charge more.
Compare that evidence with the assumptions in the rate calculator. Use it when scoping the next project rather than rewriting an existing agreement after delivery.
When a spreadsheet stops being enough
A manual timer and this sheet can work well for a small number of projects. FreshBooks documents both timers and manual entries, billable flags and later billing of recorded time. Check FreshBooks UK plans when repeatedly transferring hours between systems is the real problem. Client limits, subscriptions and payment fees still matter; see the invoice guide’s cost notes.
Sources
Sources were checked on 9 September 2026. External information can change.
Spot something that needs correcting? See the corrections process.