Unit Price Book Template, Contractor Price List Spreadsheet, Excel Google Sheets Estimating Template, Construction Pricing Sheet

Seller's description

Every estimate rebuilt from scratch. Two estimators, two prices for the same storm inlet. A unit price book fixes both.

Created by Patrick Foundry LLC. We built this for owners and estimators who want every bid to start from the same numbers — price common work once, per unit, from your own costs, then reuse it.

The Unit Price Book Template is for owners, estimators and project managers who want every bid to start from the same numbers. Price your common work once, per unit, from your own costs, then reuse it on every estimate, change order and customer price list. One workbook opens in Excel or Google Sheets. A printable worksheet, a customer price sheet and a short guide are included.

WHAT'S INCLUDED
- Price book workbook (.xlsx, no macros). The same file opens in Excel or Google Sheets.
- Start Here: how a unit price is built, markup vs margin, units, printing
- Company Rates: burdened labor rate by class, equipment rates by the hour, overhead method (% of direct cost, $ per labor hour or % of price), target net margin and price rounding
- Price Book: 57 editable starter items across sitework, earthwork, erosion control, storm, sanitary and water, concrete, paving, restoration and hourly rates, with room for 200. Enter labor hours, material, equipment hours and sub cost per unit; get direct cost, overhead, break-even, unit price, net margin and markup on every line
- Assembly Builder: 6 assemblies of up to 10 items each (for example, a storm inlet complete), priced per assembly unit
- Customer Price Sheet: a printable price list with code, description, unit and price only. Your costs and margins never show
- Examples: every starter item with fictional EXAMPLE hours and costs worked out, clearly labeled EXAMPLE
- Printable unit price worksheet (PDF, fill by hand): build-up page and price book log
- Printable customer price sheet (PDF)
- Short PDF guide: how unit pricing works, building your book from past jobs, assemblies, keeping it current, an optional AI workflow, opening it in Google Sheets

DIGITAL DOWNLOAD: this is an instant digital download. No physical item will be shipped. After purchase, download the zip from your Etsy Purchases page.

COMPATIBILITY
Works in Excel 2016 or later (Windows or Mac, including Microsoft 365) and in Google Sheets. No macros. PDFs print on US Letter.

GOOD TO KNOW
- Instant digital download. No physical item is shipped. One-business license: use it on all your company's projects and print as many copies as you need.
- The starter items ship with descriptions, units, labor classes and equipment filled in. Hours and costs are yours to enter: unit prices from another company or region would be wrong for you. The Examples tab shows fictional EXAMPLE values so you can see the math. They are not market rates.
- Not tax, legal or accounting advice. Example figures are fictional and labeled EXAMPLE. Verify every price with your own costs.
- Margin means net margin as a share of the price: price = (direct cost + overhead) / (1 - margin). A 10% margin is an 11.1% markup on break-even cost.
- Pairs with our True Hourly Cost / Labor Burden Calculator and Overhead & Markup vs Margin Calculator, also in this shop.
- AI disclosure: designed by Patrick Foundry with AI assistance. Files were checked by automated QC (formula recalculation and page renders).
- Questions about the files? Message us on Etsy with your order number.

PRICE
$24. One price for the full kit.

HOW THIS WAS MADE
Designed by Patrick Foundry LLC with AI assistance. The templates, formulas and layout are original. Files were checked by automated QC (formula recalculation and page renders). A person on our team reviewed the structure and the EXAMPLE figures before publishing.

Run a live job after your book is set? Pair this with our Contractor Bid · Estimate · Cost Tracker Bundle when it lists, and with the Markup and Labor Burden calculators already in the shop. We make tools for crews who work with their hands and keep honest numbers.

REFUND POLICY: These are instant digital downloads. If a file won't open, is damaged, or isn't what the listing describes, message us on Etsy within 14 days of purchase and we'll fix it or refund you in full. Because the files can't be returned once downloaded, we don't otherwise offer refunds for change of mind.