Reseller 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.

Four estate sales before noon, a thrift stop in the next town over, then the post office before it closes. A reseller's sourcing route is the drive, and every mile of it is deductible.

Your Mileage Ledger turns the miles you drive for reseller 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. Sourcing miles arrive in weekend clusters, heavier in estate-sale season, while the post-office run repeats on its own steady schedule all year — two different patterns landing in one log.

Built for the trips resellers really make: estate sales and auctions, thrift and consignment sourcing runs, flea markets, and post-office shipping trips.

Rebuilding a Saturday of six stops weeks later, when the only thing left is a handful of handwritten sale tags 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
• A sourcing route is business driving from the first address to the last — the estate sale, the thrift stop, the flea market, the post-office run at the end of it. The Mileage Log prices every leg at the IRS standard mileage rate and carries the year's total to 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 Estate Sale, Thrift Sourcing, Auction/Flea Market, Post Office Shipping, Supply Run, and Bank/Post Office — the stops a reseller's week is actually built from
• 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:
• Resellers driving estate-sale, thrift, and auction routes most weekends
• Cross-platform secondhand sellers claiming the standard mileage deduction
• Booth and consignment sellers logging restock and booth-tending trips
• Self-employed resellers who want an IRS-ready mileage record of their own

I designed this ledger myself — the sourcing and cost-of-goods logic, the Schedule C mapping, the formulas, the dashboard, and the mobile forms are all my own work, built around how a reseller 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.