Business template
Freelance rates and time tracker
Work out the hourly rate you need from your income goal, then log hours by client and project. See billed and not yet invoiced amounts per client.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
3 sheets
- Rates
- Clients
- Time log
80 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 272 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Checkboxes
- Named ranges
- Frozen headers
A look at the Rates sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Freelance rate calculator | |||||||
| 2 | What you need to charge to reach your income goal after taxes and time off. | |||||||
| 3 | Your goals | Your rate | ||||||
| 4 | Take home income goal | $85,000 | Revenue needed | $127,656 | ||||
| 5 | Business expenses per year | $9,600 | Billable hours per year | 1,104 | ||||
| 6 | Tax set aside | 28% | Minimum hourly rate | $115.63 | ||||
| 7 | Weeks off per year | 6 | Suggested hourly rate | $120 | ||||
| 8 | Working hours per week | 40 | Day rate (8 hours) | $960 | ||||
| 9 | Billable share of hours | 60% | Monthly revenue target | $10,638 | ||||
| 10 | ||||||||
| 11 | ||||||||
| 12 | So far | |||||||
- freelance
- hourly rate
- time tracking
- billing
More business templates
BusinessInvoiceA clean, printable invoice with line items, discount, tax and a due date worked out from your payment terms. The balance due updates as you type.
BusinessExpense reportLog business expenses and mileage for a period and see exactly what is owed back. Company card spending is tracked but not reimbursed.
BusinessPurchase orderCreate a purchase order by picking a vendor from your list; their contact details and payment terms fill in automatically. Track received and open quantities per line.
BusinessInventory trackerKeep stock levels, values and reorder points in one place. Items at or below their reorder point are highlighted and collected on a ready to send reorder list.
Start your freelance rates and time tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.