Skip to content

Free template · Excel

Free Locksmith estimate template

A ready-to-use locksmith estimate in Excel, with locksmith line items filled in and automatic totals for good, better and best options. No email needed.

[Your company name]

[Address] · [Phone] · [License #]

estimate

DescriptionQtyUnitRateAmount
Smart lock installation2ea$245.00$490.00
Master key system, 12 doors1job$1,650.00$1,650.00

Total (all options shown): $2,140.00

Example line items and prices are placeholders. Replace them with your own.

What every locksmith estimate needs

  • Your business name, contact details and license number
  • Estimate number, date and how long the price is valid
  • Clear options (good, better, best) with what each includes
  • Warranty terms and any permit or inspection fees
  • Deposit required, if any
  • A place for the customer to approve and sign

Pricing locksmith work

  • Build a base service call fee from your cost to get a locksmith to the door: (loaded hourly cost × average travel and setup time) + vehicle cost per trip.
  • Set a published after-hours and holiday fee or multiplier that covers on-call pay, and quote it on the phone before dispatch.
  • Price per-unit work flat: rekeys per cylinder, deadbolt installs per door, smart lock installs per lock, with hardware at a clear markup.
  • Quote master key systems and access control as projects: hardware, pinning or programming time per door, key cuts and documentation.
More locksmith business resources →

Common locksmith jobs to add as line items

Home, business and vehicle lockoutsRekeying after a move-in or lost keysLock and deadbolt installs and repairsSmart lock installation and setupMaster key systems for businesses and property managersAccess control and commercial hardware (panic bars, closers)Automotive keys, fobs and programming

Free download

Flat-Rate Price Book Builder

Work out your true hourly cost, set your billable rate, and price every task with good, better and best options.

Get it free
  • Overhead and labor cost calculator
  • Billable hour and target margin model
  • Task pricing sheet with materials markup
  • Good / better / best option builder
  • Member discount column

Frequently asked questions

Download the free Excel template, add your logo and business details, then replace the example locksmith line items with your own services and prices. Quantities × rates and the totals calculate automatically.

Ready to run a tighter shop?

Try the TradesWork AI plan free for 14 days. Bring your customers and price book, or start fresh with a price book made for your trade.

  • No credit card
  • No contract
  • Cancel any time
Three workers in coveralls unloading equipment from a van