Locksmith Job Sheet

Who this is for

A job sheet built round the two things a locksmith has to be able to prove: who asked for the work, and how many keys went out. It records the door and the lock, the keys issued, the identity check you made, and totals the labour and the hardware.

Locksmiths and door hardware engineers doing lock-outs, repairs, upgrades and rekeying for householders, landlords, letting agents and businesses.

What this helps you track

• Which door and which lock, by location and type
• What was done to it — opened, repaired, replaced or rekeyed
• How many keys were issued, and against what key or cylinder reference
• Confirmation that you checked who was asking for the work
• Labour and hardware totalled at your own rate, signed for

How to use it

1. Fill in the job number, date, customer, site and a contact number, and note how the job came in.
2. Before you start, confirm the customer's identity and their authority over the property, and write down what you were shown and its reference.
3. Record each door and lock on its own line: where it is, what it is, what you did and how many keys you handed over.
4. Enter the labour hours against your rate — a call-out or attendance charge takes its own line — then the hardware with quantities and prices.
5. Check the totals, run through the closing checks, and have the customer sign for both the work and the keys.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Why record the identity check?

Because opening or rekeying a door for the wrong person is the single worst mistake in the trade. What checks you must make, and what you may keep a record of, depends on the rules where you work — the sheet gives you a place to note what you saw.

Why count the keys?

So there is no argument later about how many are in circulation. Write the number issued against each cylinder and have the customer sign for them; it also flags how many old keys are unaccounted for.

Does it cover restricted or patented keys?

There is a reference column for the key or card number, which is where a restricted system's card details go. Keep the system's own paperwork as well — this sheet is the visit record.

Can I use it for a landlord or letting agent?

Yes, and the key columns are the reason to. Agents usually want to know exactly which cylinder changed and how many keys came back; the key control log on this site tracks them afterwards.