Home › Templates and printables › Business and work › Freelance Day Rate Calculator UK
Freelance Day Rate Calculator UK
A UK freelance day rate and take-home pay calculator for 2026/27, for Google Sheets and Excel. Start with the pay you want.
£5.39 on EtsyUK price, VAT included. Instant download, nothing is posted.
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.
Bought it already? 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
- UK CV TemplateA two-page A4 UK CV template for Word and Google Docs, in four colours, that reads well to people and tracking software.
- UK Invoice Template and TrackerA UK invoice template and tracker for Google Sheets and Excel: numbered, optional VAT, printable A4, for sole traders and freelancers.
- UK Cover Letter TemplateA one-page A4 UK cover letter template for Word and Google Docs, in four colours, that matches our UK CV template.