Home › Small business and work
Freelance Day Rate Calculator UK
Start with the take-home pay you want and work back to the day rate to quote, through UK income tax, Class 4 National Insurance, student loan, your business costs and your real billable days.
£5.39 on EtsyUK price, VAT included. Instant download, nothing is posted.
Bought it already? Here's where your files are.
What it does
- Target take-home a month or a year, plus the pension you want to pay in
- Profit needed worked out from the 2026/27 bands, including the personal allowance taper, Scottish rates and other income, with a check that it adds up
- Working days, with bank holidays, annual leave, sick days, training, gaps between clients and admin time taken off first
- Business costs, monthly or yearly, and the cost per billable day
- Day, half-day and hourly rates, rounded up to the nearest £5 (or your choice), and a VAT threshold check
- Rate check: test a rate you already charge, or compare twelve rates side by side with a chart
What you get
- Four colourways, all included: Pastel, Bright, Dark and Earthy, with identical formulas
- A zip of Excel files (.xlsx): an example version with numbers in, and a blank version, for every colourway
- A PDF with a Google Sheets copy link for each colourway (free Google account needed)
Good to know
- Works in Google Sheets and in Excel 2016 or newer; no macros, nothing to enable
- Works on a phone in the Google Sheets app; setting it up is easier on a laptop. Not editable in the Etsy app
- Cells with a coloured border are yours to type in; everything else is worked out for you and protected against a stray click
- For sole traders. Estimates for planning with a standard tax code; not tax or financial advice
You might also like
Childminder Spreadsheet UK
A UK childminder spreadsheet for Google Sheets and Excel: attendance, funded hours, parent invoices, record logs and a tax set-aside.
Dog Grooming Business Spreadsheet
A UK dog grooming spreadsheet for Google Sheets and Excel: dogs, price by size, rebooking, invoices and tax set-aside.
Nail Tech Business Spreadsheet
A UK nail business spreadsheet for Google Sheets and Excel: clients, rebooking, appointments, stock, invoices and a tax pot figure.