Admin automation for plumbers, electricians and builders
The work on site is the easy part. Then you get home, and the paperwork is waiting: quotes, schedules, photos, job sheets, supplier orders, payments, invoices.
This article is for small trades businesses: plumbers, electricians, HVAC techs, handymen and builders. It looks at nine admin jobs. For each one you get what is tedious, two or three ways to fix it, and one first step.
None of this needs expensive software. A spreadsheet, a phone and a few simple rules go a long way. You do not have to change everything at once. Pick one job and try it for a week.
1. Quotes and estimates
What is tedious You copy last month's quote and edit it. Prices go out of date. Two similar jobs get two different prices.
Ways - Build a price list in a spreadsheet (common items and labour rates). Make the quote template look up prices from that list, so you pick an item and the price fills in. - Let formulas work out the subtotal, tax and total. - Keep a quote log with a number, a date and a status (sent, won, lost), and put a follow-up date on every quote.
First step List your 20 most common items and rates on one sheet. That is your price list. Decide a quote numbering rule at the same time, for example year-month plus a running number.
2. Job scheduling and dispatch
What is tedious Jobs move, and then everyone has to be told again. A paper diary, a text thread and a whiteboard all say different things.
Ways - A simple job board in a spreadsheet: crew or vans down the side, days across the top, colour by job type or status. - Message templates for "booking confirmed", "reminder for tomorrow" and "on my way". - Two rules: a cut-off time for next-day changes, and one person who owns the schedule.
First step Put this week's jobs on one shared sheet, one row per person. If you use a paper diary, take a photo of it each evening and send it to the crew. That alone beats nothing.
3. Job photos
What is tedious Photos pile up on phones. When a customer asks about a job from March, nobody can find the pictures.
Ways - Make one shared cloud folder per job and upload from the phone before leaving site. - Name folders the same way every time, for example job number plus address. - Add subfolders: before, during, after.
Google's Help says that in the Drive app on iPhone and iPad you tap Add, choose File upload, pick your files and tap Location to choose the folder they go into. It also says uploaded files take up space in your Drive, so keep an eye on your storage.
First step On your next job, create one folder with the naming rule above and upload the photos the same day.
4. Job sheets and timesheets
What is tedious Handwritten job sheets get lost, and nobody can add them up at the end of the month. Hours are guessed on Friday afternoon.
Ways - A Google Form on the phone with a few questions: job number, work done, materials used, time on site, follow-up needed. Use drop-downs so it is fast to fill in. - Send the answers to a spreadsheet so you can total hours by job. - A rule: the sheet is filled in before leaving site, and the office checks yesterday's sheets each morning.
Google's Help says form responses can be stored in a linked Google Sheet, and that you can also see a summary of responses in the form itself.
First step Build a form with five questions only. Use it yourself for a week before you ask anyone else to.
5. Materials ordering log
What is tedious Orders made by phone or at the counter leave no record. Then you get duplicate orders, or a supplier statement that does not match what you remember.
Ways - A purchase log in a spreadsheet: date, supplier, item, quantity, cost and job. - A form to log purchases from the supplier counter, with a link to a photo of the receipt. - A rule: decide who may order, and write the job number on every order.
Totalling the log by job shows you the real material cost of each job.
First step Start with today's orders. Add one row per order. At month end, compare the log with the supplier statements and see what it catches.
6. Subcontractor payments
What is tedious Who did what, what was agreed, whether their invoice has arrived and when they get paid: if it is all in your head, a missed payment is only a matter of time.
Ways - A subcontractor register: sub, job, agreed amount, invoice received, paid date. Highlight payments due this week. - A booking message template for new bookings, changes and payment confirmations. - Two rules: confirm every booking in writing, and pay on a fixed day.
First step Write down every subcontractor you currently owe or expect to pay in one sheet. Then pick a fixed payment day and tell them.
7. Invoicing and chasing payment
What is tedious Invoices go out late because you forget, or because you rebuild them from scratch. Chasing is awkward, so it gets put off.
Ways - One invoice template, with client details looked up from a client list. - An invoice log with sent date, due date and paid date. Colour any row that is overdue and unpaid. - A fixed invoicing day, and reminder wording you write once and reuse, for example at 3 and 14 days overdue.
First step List every unpaid invoice on one sheet with the due date. Send the first polite reminder this week.
8. Mileage and vehicle logs
What is tedious You drive all day, and the trip notes are missing when tax time comes.
Ways - A simple trip log in a spreadsheet: date, purpose, start and end odometer, with distance calculated by formula. - A Google Form on your phone for the same fields, filled in the same day. - A monthly check of your odometer reading against the log.
What counts depends on your country, so go to the official page rather than guessing. The IRS says that if you use your car for business, you may be able to take a deduction based on the mileage used for that purpose, and it publishes its standard mileage rates on one page. The Canada Revenue Agency's motor vehicle expenses page covers how to record your expenses, with a full or simplified logbook. Check which records apply to you with an accountant.
First step Start the log today with whatever the odometer shows. Add each business trip on the same day.
9. Safety checklists
What is tedious Checklists live on paper in a van, get damp, and are not always filled in.
Ways - Write a short checklist for each type of job in a form or spreadsheet, for example "tools and equipment checked", "area made safe", "customer told what to expect". - Make filling it in the first step of a job, and keep the answers in one place. - Review the list now and then and remove anything nobody uses.
This is a record-keeping habit, not a legal checklist. What is required of your trade differs by country and by job, so use your regulator's guidance for the content.
First step Take the checks you already do in your head and write down five of them. Turn them into a form.
Try the free app
If you are not sure which method fits your business, the free Small Business Automation Check lets you choose your trade, country and tasks, and compares the options.
Putting it together
- Admin gets easier when you split it into small jobs.
- Spreadsheets, a shared folder, a phone form and message templates cover most of it.
- Pick one job and try it for a week.
- Rules help as much as tools: a fixed invoice day, a payment day, one person who owns the schedule.
- Good records also help at tax time. The IRS says good records help you keep track of deductible expenses and support the items on your return.
Sources
- Google Drive Help, "Upload files & folders" (iPhone and iPad), https://support.google.com/drive/answer/2424368?hl=en&co=GENIE.Platform%3DiOS
- Upload from the Drive app using Add, File upload and Location; uploaded files take up space in your Drive.
- Google Docs Editors Help, "Choose where to save form responses", https://support.google.com/docs/answer/2917686?hl=en
- Form responses can be stored in a linked Google Sheet, and a summary can be viewed in the form.
- IRS, "Standard mileage rates", https://www.irs.gov/tax-professionals/standard-mileage-rates
- If you use your car for business you may be able to deduct based on mileage; the IRS publishes the standard rates.
- Canada Revenue Agency, "Motor vehicle expenses", https://www.canada.ca/en/revenue-agency/services/tax/businesses/topics/sole-proprietorships-partnerships/business-expenses/motor-vehicle-expenses.html
- Covers how to record motor vehicle expenses, with a full or simplified logbook.
- IRS, "Recordkeeping", https://www.irs.gov/businesses/small-businesses-self-employed/recordkeeping
- Good records help track deductible expenses and support items on your tax return.
This article was written with the help of AI and checked against the official sources above on October 19, 2026. Rules differ by country and change over time — confirm with the official guidance or an accountant.