Food Vendor Mileage Ledger | IRS Mileage Log Spreadsheet (Google Sheets)

Form to sheet: log it in-the-moment on a Google Form on your phone, and the entry lands organized in your Google Sheet. No app, no re-typing. That's how every Ledger & Light tool works.

The drive out to a weekend festival, the run to the farmers market, the trip to restock ingredients — a food vendor's business miles add up fast, and every one is worth a deduction.

Your Mileage Ledger turns the miles you drive for food vendor work into a running deduction. Open the linked Mileage Form on your phone, log a trip when it happens, and the entry lands in your sheet on its own — valued at the IRS standard mileage rate. A vending season runs on long hauls clustered into market days and festival weekends — out to the site before dawn, back to the commissary at close, and out again the next weekend.

Built for the trips food vendors really make: markets and festivals, fair and concession events, commissary runs, and ingredient and supply pickups.

Separating the haul out to a paid event from the ingredient run you made the same morning gets simpler when every trip is logged in-the-moment.

✓ WHAT YOU GET:
• Your Mileage Ledger for Google Sheets — a private copy link arrives with your instant Etsy download
• A setup instruction PDF, delivered the moment you check out
• A mobile-friendly Mileage Form that opens in any browser — no app to install
• A short email tips sequence to walk you through setup

✓ KEY FEATURES:
• Mileage Log with the current IRS standard mileage rate applied on its own
• Because a vendor's driving comes in bursts — a dawn haul out, a restock mid-week, the long return after close — the deduction holds up best when each trip is logged at the IRS standard rate; the year then lands as one figure under Line 9 car and truck expenses.
• Mileage Form on your phone — odometer start, end, destination, and purpose in one submit
• Every trip joins a running deduction total, updated live as you log
• Customize Forms tab to add your own trip purposes to the Mileage Form dropdown, which arrives seeded with Market Day, Festival/Fair, Commissary Run, Ingredient Pickup, Supply Run, Propane & Equipment Service, and Bank/Post Office — the reasons a food vendor is actually on the road
• Tax Summary tab that totals your deductible mileage for the year
• Dashboard with a month-by-month view of your business miles and deduction
• Log any date — backfill trips from earlier in the year whenever you remember them

✓ HOW IT WORKS:
1. Check out and download your instruction PDF from Etsy right away
2. Open your Mileage Ledger from the link inside, then Make a Copy into your own Drive
3. Follow the guide, bookmark the Mileage Form on your phone, and log trips as you make them

✓ PERFECT FOR:
• Food vendors who drive to markets, fairs, festivals, and supply runs
• Concession-stand and market-stall operators claiming the standard mileage deduction
• Food-truck and mobile-food owners who want IRS-ready mileage records they keep
• Self-employed food sellers logging the miles behind every event

I designed this ledger myself — the category logic, the Schedule C mapping, the formulas, the dashboard, and the mobile forms are all my own work, built for how a food-vendor business really drives.

Your instruction PDF is available immediately after purchase — no waiting, no shipping.

These tools help you stay organized. I'm not a CPA and nothing here is tax advice — your accountant has the final word.

The spreadsheet system, formulas, and tax categories are my own original design; AI tools assisted with the decorative illustrations.