Quick answer: A good client tracker logs one row per job with client, job type, dates, quote, invoice, and payment status. Drone pilots should add flight time, location, and mileage (72.5¢ per mile in 2026), then review revenue per client and per hour every month.
Turn scattered gigs into steady income with these tracking hacks. Whether you’re flying real estate shoots, inspecting roofs, or juggling design clients, a simple client tracker is the difference between “I think I’m busy” and knowing exactly where your money comes from.
📋 Hack 1: One row per job, not per client
Create a row for every job, with columns for:
- Client name and contact
- Job type (real estate, wedding, inspection, mapping, design, etc.)
- Date booked and date delivered
- Quote, invoice number, and amount paid
- Status (Lead → Booked → Delivered → Paid)
This makes it easy to filter by client later while keeping every job’s details in one place.
Track every client and invoice in one sheetThe CRM Template flags overdue invoices and shows your best clients.
See the CRM🚁 Hack 2: Add flight-log fields for drone work
Dronepreneurs, add a few extra columns:
- Location and airspace notes
- Flight time and battery count
- Weather or cancellation notes
- Miles driven to the site
Those mileage numbers matter. For 2026, the IRS standard mileage rate is 72.5 cents per mile for business driving, so a 40-mile round trip is worth $29 in deductions.
🔁 Hack 3: Track repeat clients
Add a “Repeat?” column or a count of jobs per client. Your repeat clients are your most profitable ones: no marketing cost and less back-and-forth. Once you know who they are, you can offer packages or retainers.
⏱ Hack 4: Log your time
Add hours spent per job, including editing and travel. Then divide what you earned by the hours. You may discover your “small” jobs pay better per hour than your big ones, or the opposite.
💬 Hack 5: Use status colors
Use conditional formatting in Google Sheets to color rows by status: yellow for leads, blue for booked, green for paid, red for overdue. One glance tells you what needs attention today.
📈 Hack 6: Review monthly
At the end of each month, look at:
- Total booked vs. total paid
- Top three clients by revenue
- Which job types earned the most per hour
- How many leads turned into booked jobs
🧰 Start simple
You don’t need expensive CRM software to do this. A well-built Google Sheet covers everything above. Our free Start CRM template gives you the columns, dropdowns, and color coding ready to go, so you can spend less time organizing and more time flying (or creating).
Related guides
Frequently asked questions
Client name and contact, job type, booking and delivery dates, quote, invoice number, amount paid, and a status column such as Lead, Booked, Delivered, Paid.
The 2026 standard mileage rate for business driving is 72.5 cents per mile.
Not necessarily. A well-built Google Sheet with dropdowns and color-coded statuses covers what most solo freelancers and drone pilots need.
This article is for educational purposes only and isn’t tax or legal advice. Figures reflect IRS guidance for 2026; check with a qualified tax professional about your situation.
