A free fencing quote template for the UK, in Excel and PDF. Type the length and height of the run and it counts the posts, rails, boards and post mix, then fills in the quote.
Free. No sign-up and no email needed.
Excel file 14 KB, PDF 4 KB. Opens in Excel, Google Sheets, LibreOffice and Numbers.
It is a free Excel workbook and a printable PDF for quoting fencing work in the UK. You type the length of the run, the height and whether it is closeboard or panels. The workbook counts the bays, posts, post mix, rails, boards and gravel boards, prices them with your own costs and markup, and fills in a quote ready to send.
| Item | Rule | Source |
|---|---|---|
| Bays | Run ÷ bay width, rounded up. Panels are 1.83 m; closeboard is 2.4 m unless you change it, and never more than 3 m | Jacksons Fencing (panel width); AVS Fencing (3 m limit) |
| Posts | Bays + 1, plus 1 for each corner | Martin Cashmore Fencing: a post at each end of every bay |
| Post length | Fence height + 600 mm in the ground, rounded up to a stock length | AVS Fencing |
| Post mix | 2 × 20 kg bags a post (change it if you use less) | Martin Cashmore Fencing: 1.5 to 2 bags a post |
| Arris rails | 2 a bay up to 1.2 m high, 3 a bay above that | Jacksons Fencing |
| Feather-edge boards | Run ÷ (board width − 25 mm lap), plus 5% | AVS Fencing: 13 a metre at 100 mm, 10 at 125 mm |
| Gravel boards | 1 a bay; the boards stand 150 mm shorter on top of it | Jacksons Fencing |
Sources checked 11 November 2026. A slope, a corner or a short last bay changes the count, so check it against the site before you order.
A 12 m closeboard fence, 1.8 m high, on 2.4 m bays with 125 mm boards and gravel boards. The unit costs are round illustrations, not quotes.
| Item | Quantity | Cost at the example prices |
|---|---|---|
| Posts, at least 2.4 m long | 6 | £108.00 |
| Post mix, 20 kg | 12 bags | £84.00 |
| Arris rails | 15 | £135.00 |
| Feather-edge boards, 1.65 m | 126 | £201.60 |
| Gravel boards | 5 | £40.00 |
| Fixings, capping and sundries | Allowance | £40.00 |
| Labour | 4 person-days at £200 | £800.00 |
| Taking down the old fence and tipping it | 12 m and one tip charge | £216.00 |
| Cost | £1,624.60 | |
| Price at 20% markup | Margin 16.7% | £1,949.52 |
Citizens Advice says a quote should include a fixed total price, a breakdown of the work and materials, how long the price is valid for, whether it includes VAT, and when the price can go up. The Quote sheet has a place for each: the total, a line for the fence, the old fence and any gates, a valid-until date 30 days ahead, a VAT line, and a box for what the price assumes, such as posts being dug to 600 mm without meeting rock or roots.
Source: Citizens Advice, "Before you get work done on your home", checked 11 November 2026.
Quoting other garden work? See the landscaping quote template and the patio cost calculator.
Yes. The Excel file and the PDF are free to download, with no sign-up and no email needed. You can change them and send them as your own.
One more than the number of bays, plus one for each corner. Divide the run by the bay width and round up to get the bays. A 12 m closeboard run at 2.4 m bays is 5 bays and 6 posts. Fence panels are 1.83 m wide, so the same run in panels is 7 bays and 8 posts.
The height of the fence plus at least 600 mm in the ground, rounded up to a length you can buy. AVS Fencing gives a 2.4 m post for a 1.8 m fence. Jacksons Fencing supplies a 2.7 m post for its 1.8 m featherboard fence.
AVS Fencing gives 13 boards per metre for 100 mm boards and 10 per metre for 125 mm boards. The template divides the run by the board width less a 25 mm lap and adds 5% for splits.
Two per bay for a fence up to 1.2 m high and three for anything taller. Jacksons Fencing specifies two rails for its 1.2 m fence and three for its 1.5 m and 1.8 m fences.
Only if you tell it to. Set VAT-registered to Yes on the Fence sheet and the quote adds VAT at 20% on its own line. Leave it at No and the quote shows no VAT.