Price the job
Add days, materials, miles and travel time.
Electrician day rates, priced into every job.
The national median electrician day rate is £280. Modelled town rates run from £224 in Sunderland to £349 in London, from five UK directories and ONS earnings data.
The Rate Book is a £39 spreadsheet that puts your own rate into job prices, tax set asides and invoices.
Electrician31 town rates17 trade versions
Free sample · no account · 17 KB
Not sure of your own number? Work it out free first
See the workbook
- Price
- £39 once
- Town rates
- 31 modelled
- Trade versions
- 17
- Tax year
- 2026/27
Day rates by town.
The dearest five of 31 modelled electrician town rates.
The Rate Book carries every one, beside the rate your own costs need.
31towns in this trade version
Town rates
Highest five shownElectrician
01London
£349
02Guildford
£329
03Oxford
£320
04Cambridge
£316
05Brighton
£307
See inside before you buy.
The file starts with your yearly numbers, then follows each job from price to payment.
START HERE
Every figure here fills itself in from the jobs you priced. Nothing on this tab is typed.
| Owed to you now | £1,800 | Invoiced and not yet paid |
|---|---|---|
| The taxman's share of that | £304 | You owe it whether they pay you or not |
| Longest anything is overdue, in days | 7 | From the payment due date you entered |
| Days booked of the 200 you priced for | 4 | |
| Your day rate | £377 | |
| Your town's modelled rate | £349 | London, reviewed October 2026 |
Sample figures, from the one job on the Job Pricing tab. The file computes from whatever you enter.
Your Numbers
Typed once, at the start. Every other tab reads from here.
| Your day rate | £377 | what the calculator works out, after tax |
|---|---|---|
| Your town | London, £349 | modelled, reviewed October 2026 |
| Billable days a year | 200 | days actually on the tools |
| Productive hours a day | 7 | |
| Materials markup | 20.0% | carried into every job |
| Mileage rate | 55p a mile | HMRC flat rate, first 10,000 miles |
| Payment terms | 7 days | sets the due date on every invoice |
| Tax year | 2026/27 | Scotland has its own setting |
Change one figure here and every job, quote and invoice in the file follows it.
Job Pricing
Type the four shaded figures. The file works out the rest. 100 rows, a full year.
| Days on the job | 4 | you type it |
|---|---|---|
| Day rate | £377 | from Your Numbers |
| Labour | £1,508 | |
| Materials cost | £180 | you type it |
| Markup | 20.0% | from Your Numbers |
| Materials charge | £216 | |
| Travel miles | 40 | you type it |
| Travel hours | 1 | you type it |
| Travel charge | £76 | 40 miles at 55p, plus £53.86 an hour |
| Quote price | £1,800 | |
| Tax to set aside | £304 | 19.0% of the profit in it |
| Yours after tax and costs | £1,294 |
- You type it
- The file works it out
The same row then carries invoice sent, payment due, paid, owed now and days late.
Quote
Priced once on Job Pricing, then written out as the document you send.
| Labour, 4 days at your day rate | £1,508 | |
|---|---|---|
| Materials, supplied | £216 | cost plus 20.0% |
| Travel | £76 | |
| Total | £1,800 |
Your business name, your terms and your bank details come from Your Numbers.
Invoice
The same job again when the work is done, with the chase built in.
| Invoice total | £1,800 | |
|---|---|---|
| Invoice sent | you type it | |
| Payment due | worked out | sent plus your 7 day terms |
| Paid | you type it | leave it blank and it counts as owed |
| Owed to you now | £1,800 | unpaid, so it counts |
| Days past due | 7 | counted from the due date |
This is what feeds the money owed figure on START HERE.
Town Rates
All 31 modelled towns for your trade, dearest first. Not a page of averages.
| London | £349 | |
|---|---|---|
| Guildford | £329 | |
| Oxford | £320 | |
| Cambridge | £316 | |
| Brighton | £307 | |
| Bath | £297 | |
| Reading | £295 | |
| Milton Keynes | £288 | |
| Bristol | £288 | |
| Cheltenham | £283 | |
| Edinburgh | £282 | |
| York | £273 | |
| Exeter | £272 | |
| Portsmouth | £271 | |
| Northampton | £269 | |
| Southampton | £268 | |
| Norwich | £264 | |
| Cardiff | £264 | |
| Manchester | £263 | |
| Birmingham | £260 | |
| Leeds | £259 | |
| Coventry | £254 | |
| Leicester | £254 | |
| Glasgow | £253 | |
| Sheffield | £252 | |
| Derby | £246 | |
| Liverpool | £245 | |
| Nottingham | £243 | |
| Newcastle | £243 | |
| Stoke-on-Trent | £235 | |
| Sunderland | £224 |
The published median of five UK directories, reviewed October 2026.
Live preview of the paid workbook.
Choose a tab to inspect that sheet.
Send the quote
The file turns the price into a clear customer document.
Track the money
See what is paid, overdue and still owed.
Open the electrician version and check the figures before you decide.
Open the free sampleCheck the working.
No invented reviews, hidden login or monthly fee.
- The median of five UK directories, earnings figures from the Office for National Statistics, and UK house prices.
- Real 2026/27 Income Tax and Class 4 National Insurance, with Scotland's own setting.
- Reviewed October 2026. Check every step of the working yourself on the method page
It is new. There are no reviews yet. The first will name a electrician and their town.
Clear answers before you open the file.
The practical details, without inflated claims.
Is this not just the free calculator in a spreadsheet?
No.
The calculator answers one question, which is the day rate you need.
The Rate Book runs the year on that rate.
It prices every job, sets the tax aside, and tracks what you are still owed.
Is £224 a day good for an electrician?
It is the lowest of the 31 modelled town rates, in Sunderland.
The national median is £280.
The free calculator shows what your own costs and tax need.
Should I charge the town rate or my own rate?
The two figures answer different questions.
The modelled rate is what directories publish for the work.
The needed rate is what your own costs and tax ask for over a year.
A gap between them is the thing to decide about.
The Rate Book carries the message to send your regulars before a new rate starts.
Do I need Excel?
No. It opens in Google Sheets, which is free.
Every formula is written to work in both.
Not ready for the file yet? The free invoice page prices one job and checks it against your town.
Not your trade? See all 17 Rate Books.
Price the next job with your real number.
Open the electrician Rate Book and follow one job from price to payment.
Open the free sampleFree sample · 17 KB · no account
Reviewed on .
These figures use the same sums as the free calculator. The two always agree.