Fencing Quote Template

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.

Download the fencing quote template

Free. No sign-up and no email needed.

  • Excel workbook: a fence calculator, a costing table and a Quote sheet to send
  • PDF: a blank A4 quote with a measure-up box and the counting rules printed on it
  • Closeboard or panel fencing, in metres and pounds, with UK VAT at 20% when you switch it on

Excel file 14 KB, PDF 4 KB. Opens in Excel, Google Sheets, LibreOffice and Numbers.

What is the fencing quote template?

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.

How does the template count posts, rails and boards?

ItemRuleSource
BaysRun ÷ bay width, rounded up. Panels are 1.83 m; closeboard is 2.4 m unless you change it, and never more than 3 mJacksons Fencing (panel width); AVS Fencing (3 m limit)
PostsBays + 1, plus 1 for each cornerMartin Cashmore Fencing: a post at each end of every bay
Post lengthFence height + 600 mm in the ground, rounded up to a stock lengthAVS Fencing
Post mix2 × 20 kg bags a post (change it if you use less)Martin Cashmore Fencing: 1.5 to 2 bags a post
Arris rails2 a bay up to 1.2 m high, 3 a bay above thatJacksons Fencing
Feather-edge boardsRun ÷ (board width − 25 mm lap), plus 5%AVS Fencing: 13 a metre at 100 mm, 10 at 125 mm
Gravel boards1 a bay; the boards stand 150 mm shorter on top of itJacksons 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.

What does a worked example look like?

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.

ItemQuantityCost at the example prices
Posts, at least 2.4 m long6£108.00
Post mix, 20 kg12 bags£84.00
Arris rails15£135.00
Feather-edge boards, 1.65 m126£201.60
Gravel boards5£40.00
Fixings, capping and sundriesAllowance£40.00
Labour4 person-days at £200£800.00
Taking down the old fence and tipping it12 m and one tip charge£216.00
Cost£1,624.60
Price at 20% markupMargin 16.7%£1,949.52

How do you fill it in?

  1. Type the run on the Fence sheet: length, height, closeboard or panel, and whether there are gravel boards.
  2. Check the counts under "What to order" against the site.
  3. Type your costs in the costing table, with your labour days and your markup.
  4. Fill in the Quote sheet: your details, the client and the site. The descriptions and prices are written for you.
  5. Print or save the Quote sheet as a PDF and send it. Keep the Fence sheet to yourself.

What should a fencing quote include?

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.

What does the template not do?

  • It counts one straight run at a time. For a second run, save a copy.
  • It does not allow for slopes, stepped panels or concrete posts with slotted panels beyond the bay count.
  • It is not legal advice. The wording about what the price covers is an example to change, not a contract.

Quoting other garden work? See the landscaping quote template and the patio cost calculator.

We are building an estimating app for landscapers

It is not released yet. It will work out quantities and prices from your measurements and your own costs, on your phone, with no signal needed, and you will buy it once. Leave your email and we will tell you when it is ready to try.

You join the Stillware email list. We write when the landscaping estimator is ready to try, and when we ship something else: an app update or a free tool.

At most once a month. No tracking pixels. Leave in one click. What you'll get

Frequently asked questions

Is the fencing quote template free?

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.

How many posts do I need for a fence?

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.

How long should fence posts be?

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.

How many feather-edge boards do I need per metre?

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.

How many rails does a closeboard fence need?

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.

Does the template add VAT?

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.