How to Track Job Costs and Invoice as a Handyman in the UK
Updated 2026-11-17Why Accurate Job Cost Tracking Matters
Running a small-trade business - whether you specialise in plumbing, carpentry or general handyman work - means juggling multiple jobs, each with its own mix of labour hours, material purchases and travel expenses. Without a clear record, you risk under-charging, missing tax deductions and spending hours on admin instead of on the job.
1. Set Up a Simple Job Log
- Create a new sheet for each calendar month. Label the tabs with the month and year (e.g., "Apr 2024").
- Add columns for:
- Date of work
- Client name and address
- Job description
- Labour hours (start and finish times)
- Materials used (item, quantity, cost)
- Travel mileage or fuel cost
- Total cost for the job
- Enter data daily. A quick five-minute end-of-day habit prevents gaps and ensures you capture every expense.
2. Capture Labour Hours Correctly
- Record the exact start and finish times for each task. If you work on several tasks for the same client, list them separately.
- Multiply the total hours by your agreed hourly rate to calculate the labour charge.
- Keep a separate record of any overtime or weekend rates if they differ from your standard rate.
3. Track Materials and Supplies
- Keep receipts for every purchase - from a bag of cement to a new set of drill bits.
- Enter the purchase date, supplier, item description, quantity and cost into the "Materials" column.
- If you reuse materials across jobs, allocate the cost proportionally or note the leftover stock for future jobs.
4. Record Travel and Vehicle Costs
- Use a mileage log to note the start and end odometer readings for each job.
- Multiply the miles travelled by the current HMRC mileage rate (check GOV.UK for the current rate) to calculate the deductible travel expense.
- If you use fuel receipts instead of mileage, record the fuel amount, price per litre and total cost.
5. Calculate the Job Total
Add the three cost components - labour, materials and travel - to produce a clear total for each job. This figure will form the basis of your invoice and also feed into your annual profit-and-loss summary.
6. Produce a Professional Invoice
- Header: Include your business name, address, phone number and email. Add your VAT number if you're VAT-registered.
- Client details: Name, address and contact information.
- Invoice number: Use a sequential system (e.g., INV-2024-001).
- Date: Issue date and payment due date (commonly 30 days from issue).
- Breakdown of charges: List labour, materials and travel as separate line items, each with a clear description and amount.
- Total amount due: Include any applicable VAT and state the payment methods you accept.
- Notes: You can add a short thank-you note or a reminder of your payment terms.
7. Stay Tax-Compliant Throughout the Year
- Tax year: Runs from 6 April to 5 April (check GOV.UK for the current rules). All income and allowable expenses must be recorded within this period.
- Self-Assessment deadline: Online returns and payments are due by 31 January following the end of the tax year (check GOV.UK for the current rules).
- Making Tax Digital (MTD) for Income Tax: If your qualifying self-employment or property income exceeds £50,000 in the 2024-25 tax year, you must use MTD from 6 April 2026. The threshold lowers to £30,000 for 2025-26 and £20,000 for 2026-27 (check GOV.UK for the current rules). A spreadsheet alone is not MTD-compatible software, but you can use it alongside HMRC-compatible bridging software.
- Record keeping: Keep your job logs, receipts and invoices for at least five years after the relevant tax year ends (check GOV.UK for the current rules).
8. Review and Adjust Your Rates Annually
At the end of each tax year, summarise your total income, total allowable expenses and net profit. Compare this with the previous year to see if your rates need updating to cover rising material costs or fuel prices.
FAQ
Q1: Do I need to register for VAT as a handyman? A: You must register if your taxable turnover exceeds the VAT registration threshold (check GOV.UK for the current rules). Below that, registration is optional.
Q2: Can I use a simple spreadsheet for my tax returns? A: Yes, a spreadsheet is fine for record-keeping, but you must submit your Self-Assessment return via HMRC's online service by the 31 January deadline.
Q3: What if my income will exceed the MTD threshold next year? A: From the applicable start date you'll need to submit quarterly updates using HMRC-compatible software. Your spreadsheet can still be used for internal tracking alongside that software.
Q4: How often should I back up my job-cost spreadsheet? A: Regular backups (e.g., weekly) to a secure cloud service or external drive help protect against data loss.
Final Thought - A Time-Saving Template
If you're looking for a ready-made solution to organise labour hours, material costs and travel in one place, the Handyman Job Cost & Invoice Spreadsheet provides a tidy layout that follows the steps above. It saves you the hassle of building a sheet from scratch, letting you focus on the work that matters most.