One network, one training path — take the free lesson or see the full curriculum

Business

Locksmith Bookkeeping Monthly Checklist (90-Minute Routine)

Updated 2026-05-27. Locksmith School PRO editorial team.

The 90-Minute Financial Routine for Mobile Locksmiths

For the mobile locksmith, the end of the day usually grease on your hands and a pile of key blanks to organize. The last thing you want to do is open a laptop and stare at a spreadsheet. However, failing to reconcile your books monthly is the fastest way to turn a profitable route into a tax nightmare. The IRS frequently flags trade businesses for mileage discrepancies and unreported cash income (IRS.gov). A disciplined 90-minute routine once a month protects your license, your profit margin, and your sanity.

This checklist is designed for the sole proprietor or single-truck operator. It assumes you are using a basic accounting software like QuickBooks Online, Wave, or a dedicated trade-specific spreadsheet. The goal is not to become a CPA, but to maintain a "clean set of books" that proves your income and deductions if audited.

Phase 1: The Financial Reconciliation (30 Minutes)

The first phase is about verifying that the money you think you made matches the money the bank says you made. Discrepancies here are where audits often start.

1. Match Bank and Credit Card Feeds

Log into your banking portal and download the statement for the month. Do not rely solely on the bank feed within your software, as feeds often miss transactions or duplicate entries. You need to manually confirm the ending balance.

Go through every transaction line by line. You are looking for three specific things:

2. Reconcile Merchant Processors

If you use Square, Stripe, or a locksmith-specific POS like Lynx or Jobber, you must reconcile these separately. The total deposit in your bank account will be less than your total sales due to processing fees.

In your books, record the gross sales (e.g., $1,000) as revenue. Record the processing fee (e.g., $29) as an expense. The resulting deposit ($971) should match the bank deposit exactly. If you only record the net deposit, you are under-reporting your revenue and over-reporting your profit margin, which creates confusing data for pricing analysis.

Phase 2: Expense Categorization & Vehicle Logs (20 Minutes)

Locksmithing has a high cost of goods sold (COGS) compared to other service trades. You carry expensive inventory and drive a heavy vehicle. Proper categorization ensures you don't pay taxes on money that was actually spent on inventory.

3. Separate COGS from Overhead

This is a critical distinction that many technicians miss. Cost of Goods Sold (COGS) are costs directly tied to a specific job. Overhead are costs to run the business generally.

Correct Coding Examples:

Why does this matter? If you want to know if you are charging enough for a rekey, you need to subtract COGS from your revenue. If your insurance is mixed in with your key blanks, you cannot accurately calculate your job margin.

4. The Mileage Audit Proof

Your work van is your largest tax deduction, but it is also the biggest red flag for the IRS. For 2024, the standard mileage rate is 67 cents per mile (IRS.gov). If you drive 20,000 business miles a year, that is a $13,400 deduction. You must prove every single mile.

During your monthly review, check your mileage log. Whether you use an app like MileIQ or a paper logbook, ensure the following for each trip:

If you have gaps in your log, use your Google Maps Timeline or customer invoices to reconstruct them. If you cannot reconstruct the log, you should not claim those miles. If you find you are driving excessive empty miles between calls, review our guide on How to Set Your Locksmith Service Territory Without Burning Gas to optimize your route density.

Phase 3: Inventory & Tool Valuation (15 Minutes)

Inventory shrinkage (theft, loss, or damage) is pure profit loss. In a truck, it is easy for a pack of 10 high-security blanks to vanish without a record. A monthly physical count stops this bleed.

5. Conduct a "Spot Check" Inventory Count

You do not need to count every screw every month. Rotate your focus. This month, count your high-value items: Lishi tools, safe scopes, and high-security cylinders (Medeco, Mul-T-Lock, Assa Abloy). Next month, count your standard key blanks (Schlage, Kwikset, Yale).

Compare your physical count to what your software says you should have. If your software says you should have 50 Schlage Primus blanks but you only have 40, you have a problem. You need to adjust the inventory value in your books to reflect the loss. This is a painful expense to record, but it is a real expense. Ignoring it inflates your assets and your tax liability.

6. Track Tool Depreciation

Did you buy a new key machine or a laser cutter this month? Do not expense the full $3,000 cost in one month if possible. Consult your tax professional, but generally, large equipment should be capitalized and depreciated over its useful life (5 to 7 years). This smooths out your income and prevents a scenario where you show a massive loss in a purchase month and a massive profit in the following months.

Phase 4: Sales Tax & Compliance (10 Minutes)

Sales tax compliance is the "silent killer" for locksmiths. Unlike income tax, which you pay on profit, sales tax is collected on behalf of the state. If you mess this up, the penalties are severe and personal.

7. Verify Taxable vs. Non-Taxable Sales

Rules vary significantly by state. In many jurisdictions, labor is not taxable, but the parts (locks, cylinders, keys) are. However, some states tax the total amount if the sale is lump sum.

Review your invoices for the month. Ensure you are not charging sales tax on "Emergency Service Fees" or "Labor Trip Charges" if your state exempts labor. Conversely, ensure you are charging tax on the hardware. If you are audited by the state (e.g., California Board of Equalization or Texas Comptroller), they will look for a pattern of under-collecting tax. You are liable for the tax owed, even if you didn't collect it from the customer.

Warning: Sales tax rules change annually. Do not rely on advice from a forum. Verify the current labor vs. parts taxability rules with your state's Department of Revenue website.

Phase 5: Revenue Analysis & Pricing Adjustments (15 Minutes)

Now that the data is clean, use it to make more money. Bookkeeping is not just about the past; it is about pricing for the future.

8. Calculate Your Average Ticket (AT)

Total Revenue divided by Total Number of Jobs = Average Ticket.

If your AT is $85, you are working too hard for too little. You are likely doing too many simple lockouts and not enough access control or hardware upgrades. If your AT is $350, you are doing well, but you need to ensure your close rate isn't suffering because your prices are too high.

9. Analyze Job Margins by Service Type

Look at your "Rekey" jobs versus your "Master Key System" jobs.

If your books show that rekeys are your only profit center, you need to pivot your marketing toward higher-value commercial work. To ensure you are pricing these complex jobs correctly, refer to our breakdown on How to Quote a Master Key System (Pricing Math Inside). If you aren't calculating the pinning labor and keying software time into the quote, the high revenue from these jobs might be masking a dangerously low profit margin.

Summary Checklist

  1. Reconcile: Bank and credit card statements match the books.
  2. Review: Merchant processor deposits are split into Gross Sales and Fees.
  3. Categorize: Separate COGS (keys/locks) from Overhead (insurance/ads).
  4. Log: Verify mileage logs are complete and match Google Maps timeline.
  5. Count: Perform a spot-check on high-value inventory.
  6. Comply: Confirm sales tax was charged on parts, not labor (per state law).
  7. Analyze: Review Average Ticket and adjust pricing for low-margin services.

Final Thoughts

Spending 90 minutes a month on this routine prevents spending 90 hours in an audit. It moves you from being "a guy with a van" to a business owner. When your books are clean, you know exactly how much you can afford to invest in new tools, marketing, or the $79.99/mo Locksmith School PRO Pro Course to upgrade your skills. Treat the numbers with the same precision you treat a sidebar lock, and your business will remain secure.

Ready to take control of your business finances and technical skills? Start the Locksmith School PRO free signup today.