Here's our take: if your drone business tracks revenue in one tool and expenses in a spreadsheet you update "when you get to it," you don't know what any single job made. You know what the year made, roughly, in April, when your accountant asks for receipts you've stuffed in the truck console since August.
Drone job expense tracking fixes that, but only if the expense lands against the job the day you spend the money. Not in a second spreadsheet. Not in a shoebox. Against the job. This Pilot Ledger post is about how to set that habit up so job profitability is a number you can read, not a guess you make at tax time. It's teach-first for U.S. commercial drone operators anywhere in the country. It is not tax advice; ask your CPA how your own expenses should be categorized.
Why the second spreadsheet always loses
Every shop we've seen that runs a "costs" sheet next to its CRM has the same three problems:
- It's always behind. The sheet gets updated in batches, so the numbers are stale the week you need them for a quote.
- It doesn't know which job. A $64 hotel receipt with no job name on it is just a business expense. It can't tell you that the pipeline corridor job ran thin.
- It doesn't talk to the books. At year end somebody retypes it into QuickBooks or Xero. That retyping is where the errors live.
The fix isn't more discipline. The fix is one system where the quote, the invoice, and the costs sit on the same job record.
What to track on every drone job
Keep the list short enough that you'll actually do it from the field:
- Travel. Mileage to and from the site, plus fuel if you track it that way. Tolls and parking.
- Lodging and per diem on overnight jobs.
- Subcontracted labor. The 1099 pilot, the visual observer, the GPS rental tech.
- Equipment rented for the job. An RTK base, a LiDAR payload, a second aircraft.
- Job-specific supplies. Ground control targets, paint, stakes, batteries you burned through.
- Processing or data costs if a job truly needs an outside service.
Fixed overhead like insurance, software subscriptions, and aircraft depreciation matters too, but it belongs in your rate, not on each job's expense list. We covered that side in drone job costing and markup.
How Pilot Ledger handles it
Pilot Ledger's Accounting & Reports area is built around this exact problem. What's on the product today, per the Pilot Ledger site:
- Expense tracking with receipt OCR. Snap the receipt and let OCR pull the details instead of typing them in.
- Mileage with IRS rates. Log the miles; the rate comes from the IRS standard mileage rate rather than a number you remember from last year.
- Job profitability. Expenses sit next to the revenue on the job, so you see what the job actually made.
- Subcontractor costs. Subcontractor Management tracks external pilots and crew with rates and payments, so "client revenue minus sub costs" shows true job margin. More on that in running 1099 drone pilots and team seats.
- P&L statements and aging reports for the business-wide view.
- QuickBooks and Xero export. Invoices, expenses, and payments export as import-ready files: QuickBooks Desktop (IIF), QuickBooks Online (CSV), or Xero (CSV). Details in drone accounting software with QuickBooks and Xero.
The point isn't that the software is clever. The point is that the expense, the invoice, and the job are the same record, so nobody retypes anything.
A field habit that actually sticks
Software doesn't help if the receipt never gets in. Here's the habit that works for most solo and small-crew shops:
- Receipt in before you leave the parking lot. Gas station, hotel desk, hardware store. Photo, tag the job, done. Thirty seconds.
- Mileage logged at the end of the drive, not reconstructed from memory on Friday.
- Sub invoices entered the day they arrive, against the job they belong to.
- A weekly ten-minute pass to catch anything untagged. If an expense doesn't belong to a job, mark it overhead on purpose instead of leaving it floating.
If that sounds too simple, good. Simple is what survives a busy month.
What job-level numbers tell you
Once expenses live on the job, a few things get obvious fast:
- Which job types pay. You might find that the "small" roof jobs near home beat the big corridor work once travel and subs come out.
- Where your quotes are thin. If overnight jobs keep eating margin, your travel line in the quote is wrong. Fix it in the next estimate, and use a change order when scope grows mid-job.
- Which clients cost more to serve. Repeat site visits and extra deliverables show up as real cost instead of a vague feeling.
- What to hand your accountant. A clean P&L and an export file instead of a bag of receipts.
What this is not
Expense tracking isn't bookkeeping advice, and it doesn't replace your CPA. It also doesn't make every expense deductible. It just means the record exists, it's attached to the right job, and it's ready when someone qualified needs it.
The bottom line
The second spreadsheet is where good intentions go to get stale. Put the cost on the job the day you spend it, and job profitability stops being a year-end surprise. If you want quotes, invoices, expenses, mileage, and exports in one place, see Pilot Ledger pricing.