● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Business Mileage Log
Business Mileage Log hero image showing the mileage log spreadsheet
BOOKKEEPING & BUSINESS FINANCE

Business Mileage Log

Every work trip you forget to write down is money left behind at tax time, but this business mileage log makes recording a drive take seconds: the date, where you went, and the miles. Your rate does the maths, and the year quietly adds itself up while you get on with the driving.

$1.20$2.9960% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Ten seconds per trip, a tidy total at tax time

Driving for work adds up faster than most people realise, and memory is a poor bookkeeper. A client visit here, a supply run there, and by the end of the year hundreds of deductible miles have blurred into one vague guess. The Trips tab replaces the guesswork with a habit that takes seconds: date, from, to, purpose and miles, one honest row per journey, kept in the order you actually drove them.

The money side looks after itself. Set your per-mile rate once on the Settings tab, alongside your business name, and every trip you log is priced automatically from that rate. Change the rate when the official figure moves and the whole log recalculates, past rows included, so you never have to redo a year of entries by hand or wonder which rows used the old number.

The Dashboard keeps the running picture in front of you: total miles, the total amount they are worth and how many trips you have logged, plus a monthly chart that shows your busy driving periods at a glance. It suits realtors, delivery drivers, sales reps and freelancers, anyone whose work happens on the road. When tax time comes, your records are already clean, dated and totalled instead of rebuilt from memory.

Inside the workbook: 4 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the log into your own account
  • BLANK Excel workbook, clean and ready for your trips
  • EXAMPLE Excel workbook with sample trips so you can see it working first
  • Quick Start Guide PDF with setup in about five minutes, step by step
  • Four separate files delivered by instant download, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel 2021 or Microsoft 365
  • Also runs in Google Sheets with a free Google account
  • One payment only, no subscription and no add-ons
  • Your trips stay in your own file, nothing is shared with us
  • Stuck on anything? Message us on Etsy and we reply within 24 hours

Questions about this template

The things buyers ask us most.

Is this a subscription?

No. One payment makes the files yours for good, with no monthly fees and nothing else to buy. You can log trips year after year in the same workbook, and if you want a fresh start each January, the BLANK file gives you a clean copy whenever you need one.

Can I change the mileage rate later?

Yes, and it takes seconds. Your rate lives on the Settings tab, and every amount in the log is calculated from that one cell. Update it when your rate changes and the whole workbook recalculates, including trips you logged earlier, so your totals always use the current figure.

Excel or Google Sheets, which should I pick?

You receive both, so pick the one you already use. The Excel files open in Excel 2021 or Microsoft 365 with all formulas live, and the Access PDF creates your own Google Sheets copy in one click. The tabs and calculations are the same either way, so your records look identical.

What if I get stuck?

Open the Start Here tab first, since it walks through setup in plain steps and takes about five minutes. The EXAMPLE file shows sample trips already logged, which makes the pattern easy to copy. If anything still looks off, message us through Etsy and we will help, usually within 24 hours.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Small Business Bundle

One workbook for clients, invoices, money and projects, with profit on one dashboard.

$24.99 $10.00
View on Etsy
Pricing Calculator

Price products from true costs, fees and margin, not guesswork, and keep a clear price list.

$2.50 $1.00
View on Etsy
Profit and Loss Tracker

Turn income and expense logs into a clean profit and loss statement every month.

$7.50 $3.00
View on Etsy
View on Etsy · $1.20