Free template
Locksmith estimate and invoice templates
Locksmiths charge a service call plus per-cylinder or per-lock pricing. These spreadsheets come set up for that, with working totals, tax and deposit, and an example rekey house and add smart deadbolt to start from.
Free, no sign-up. Works in Excel, Google Sheets and Apple Numbers.
What's in the template
The example line items for a rekey house and add smart deadbolt. Prices are illustrative only; replace them with your own.
| Item | Qty | Unit | Unit price | Taxable | Line total |
|---|---|---|---|---|---|
| Service callResidential, standard hours | 1 | ea | $65.00 | N | $65.00 |
| Rekey cylinderPer cylinder, including new keys | 5 | ea | $25.00 | N | $125.00 |
| Additional keysStandard key cut | 4 | ea | $4.00 | Y | $16.00 |
| Smart deadboltKeypad and app, supplied and installed | 1 | ea | $245.00 | Y | $245.00 |
| Install laborFit to existing door prep | 1 | ea | $75.00 | N | $75.00 |
| Subtotal (before tax) | $526.00 | ||||
| Deposit (0%) | $0.00 | ||||
| Balance | $526.00 | ||||
The spreadsheet adds sales tax on lines marked Y once you enter your rate, and has spare rows for more items.
How to use it
- 1Download the template. Download the locksmith estimate or invoice (.xlsx). It opens in Excel, Google Sheets and Apple Numbers.
- 2Add your company and customer. Fill in the shaded company, customer and service-address cells, and set the document number and date.
- 3Replace the example lines. The example is a rekey house and add smart deadbolt. Locksmiths charge a service call plus per-cylinder or per-lock pricing. Change the items, quantities and unit prices to your own; line totals and the subtotal update automatically.
- 4Set tax and deposit. Mark each line taxable (Y) or not (N), enter your sales tax rate, and set the deposit percent (the example collects none, so the balance equals the total).
- 5Review terms and send. Edit the terms to match your policies, save a copy for the customer, and export to PDF to send.
Tips for locksmith estimates
- Count cylinders, not doors. A front door with knob and deadbolt is two.
- Add an after-hours line instead of changing the service call price.
- Put the key code in your records, never on the invoice.
Locksmith terms included
- Proof of residence or ownership is required before lock work.
- Smart lock app setup is completed with the customer present.
Plus standard validity and payment terms. Edit all of them to match your policies and local law.
FAQ
Locksmith template questions
Have a question we didn't cover? Book a demo and ask a product specialist.
How do I bill lockouts?
One line for the service call and one for the lockout service. Add an after-hours surcharge if it applies.
Should I note ID verification on the invoice?
Note that it was verified, not the ID details. The Terms line covers it.
Do the formulas work in Google Sheets?
Yes. The line totals, subtotal, taxable amount, tax, deposit and balance use standard functions (SUM, SUMIF, ROUND, IF) that work in Excel, Google Sheets and Numbers.
Send estimates customers can approve online.
Homeforce builds estimates from your pricebook, collects deposits, and turns approved work into invoices customers can pay online. We're onboarding early customers now.
Onboarding early customers · Month-to-month · Free data migration