Example: a week of work for one client
A freelance PPC consultant exports four rows from her time tracker for Brightwell Dental. Two rows of Google Ads setup are logged as 2:30 and 1h 45m at £55 an hour, a monthly report row has 1.5 hours and no rate, and a cancelled call shows 0 hours.
With a default rate of £45, VAT at 20% and lines grouped by project, the tool uses three rows and skips the zero-hour one. Google Ads setup becomes one line of 4.25 hours at £55, which is £233.75, with the dates and the notes from both rows in its description. The report becomes 1.5 hours at £45, £67.50. Net total: £301.25 for 5.75 hours.
Date,Client,Project,Hours,Rate,Notes 02/11/2026,Brightwell Dental,Google Ads setup,2:30,55,Account structure 03/11/2026,Brightwell Dental,Google Ads setup,1h 45m,55,Ad copy 04/11/2026,Brightwell Dental,Monthly report,1.5,,October figures 05/11/2026,Brightwell Dental,Google Ads setup,0,55,Call cancelled
Rows used 3, rows skipped 1, hours 5.75 Brightwell Dental, Google Ads setup, 4.25 h at £55.00 = £233.75 Brightwell Dental, Monthly report, 1.5 h at £45.00 = £67.50 Net total £301.25
From export to invoice
Load the timesheet
Choose Open a timesheet CSV or paste it into the box. The first row must be the header.
Check the columns were found
Columns are matched by name: Date, Hours (or Duration or Time), Rate, Project (or Job or Task), Client (or Customer) and Notes. If no hours column is found, a message says so.
Set a fallback rate and VAT
The fallback rate is used for any row without its own rate. Choose 20% VAT, or 0% if you are not registered.
Choose how lines are grouped
One invoice line per project and rate, per client and rate, or per day and rate.
Make the invoice
Press Make the invoice and the full invoice form opens below, with the lines and the first client's name filled in, ready for your details, numbering and printing.
Hour formats the tool understands
| Written as | Read as |
|---|---|
| 7.5 or 7,5 | 7.5 hours |
| 7:30 | 7.5 hours |
| 7h 30m | 7.5 hours |
| 45m | 0.75 hours |
| 0, blank or text | Row skipped |
Grouping choices and what the customer sees
Grouping by project keeps invoices short for clients who only want a figure per piece of work. Grouping by day suits clients who sign off time daily. Rows at different rates never merge, so a senior rate and a junior rate on the same project stay as separate lines.
Each line's description carries the client, the project or day, the date range covered, the number of entries and up to three of the notes, so the client can see where the hours went without a separate timesheet. Dates in day-first UK form such as 02/11/2026 are read as 2 November.
Questions people ask
Which time tracking apps does this work with?
Any that export CSV with a header row and an hours or duration column. The tool finds columns by their names rather than by position, so exports with extra columns or a different column order still work. If yours uses an unusual name for hours, rename that header to Hours.
What happens to rows without a rate?
They use the fallback rate you set above the results. That is useful when your time tracker only records hours, or when most work is at one standard rate and only a few rows carry a special one. Rows with their own rate keep it.
Can I invoice several clients from one timesheet?
The grouping keeps each client's rows separate, so lines for different clients never merge. The invoice form is filled with all the lines and the first client's name, so for several clients either filter the CSV first or remove the other clients' lines before you print.
Is the timesheet uploaded?
No. The CSV is read and grouped by the page in your browser. The invoice that opens works the same way, and if you save it, it is kept in this browser's storage on your device rather than on a server.
Where your data goes
Your timesheet file is read locally and never uploaded. The invoice built from it stays in the page unless you save it, in which case it is held in this browser's storage only.
Checked against the tool on