● 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›Receipt and Mileage Expense Tracker Excel Spreadsheet
Receipt and Mileage Expense Tracker spreadsheet, hero view of the combined tracker
BOOKKEEPING & BUSINESS FINANCE

Receipt and Mileage Expense Tracker Excel Spreadsheet

Receipts live in one folder and trip notes in another, so the two halves of your business expenses never meet. This receipt and mileage expense tracker keeps purchases and drives in a single workbook, so one combined total finally answers what you spent and what you drove.

$3.00$7.5060% OFF

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

Instant DownloadExcel + Google SheetsPDF Guide Included

Two expense jobs, one workbook, one total

Most business expenses come in two flavours that rarely meet: the things you buy and the miles you drive. Receipts end up in one folder, trip notes in a notebook, and at tax time somebody has to merge two half-records into one honest total. This workbook was built for the two jobs together. Purchases live on the Receipt Log, trips live on the Mileage Log, and every summary in the file reads from both.

The daily entries stay simple. A receipt is logged with vendor, category, amount and tax, and its total works itself out. A trip is logged with where you went, the miles and the purpose, and its reimbursement works itself out as miles times the rate on your Settings tab, so one rate change updates every trip at once. The Vehicle Log records starting and current mileage per vehicle, keeping your driven miles provable rather than estimated.

The Combined Expense Summary is the page the whole workbook points at: total receipts with tax, total business miles, total mileage reimbursement and the combined figure, with receipt totals by category and their share of the whole. Tax Categories adds a plain note on how each kind of cost is commonly treated, and the Monthly Summary breaks receipts and mileage down month by month with a combined total and trip count, ready to review, bill or hand over.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a 1-click copy link to your own Google Sheets copy
  • BLANK Excel workbook, clean and ready for your own receipts and trips
  • EXAMPLE Excel workbook filled with realistic demo data so you can see every total working first
  • Quick Start Guide PDF that walks through setup in Excel and in Google Sheets
  • Four separate files, delivered individually, no ZIP to unpack

Good to know

  • Works in Microsoft Excel and in Google Sheets
  • Change the mileage rate once on Settings and every trip updates
  • Set your currency and tax year on Start Here
  • Keep your paper or photo receipts too; the workbook organises the records
  • An organising tool, not tax advice; check local rules before claiming

Questions about this template

The things buyers ask us most.

Is this two trackers stuck together, or one combined tracker?

It is one workbook with one combined total. Receipts and mileage each live on their own log, because the entries are different, but the combined summary, the tax categories page and the monthly view all read from both logs at once. You never have to merge two files or add two totals together yourself at the end of the month or the year.

How is mileage reimbursement worked out?

As miles times your rate. The rate lives on the Settings and Lists tab, and every trip on the Mileage Log uses it, so if your rate changes, you change it in one place and every trip's reimbursement updates without any retyping. Each trip also records its purpose and vehicle, which keeps the log useful when someone asks what a drive was for.

Do I still need to keep my receipts?

Yes. This workbook organises your records: what you bought, where, the category, the tax and the total. The paper or photo receipt is still the proof behind the line, so keep those as well, especially for anything you plan to claim. The tracker's job is to make sure that when you reach for a receipt, you know its amount, date and category already.

Does it work in Google Sheets as well as Excel?

Yes. Use the 1-click copy link in the Google Sheets Access PDF to make your own copy and work there, or open the Excel files directly in Microsoft Excel. The BLANK workbook is your clean start, and the EXAMPLE workbook is filled with demo data so you can watch receipt totals, mileage reimbursement and monthly totals working before you log anything real.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Small Business Bookkeeping Spreadsheet

Log income and expenses in minutes and see your real net profit on one clear dashboard.

$6.99 $2.80
View on Etsy
Small Business Subscription Tracker

Every recurring cost, renewal date and annual total in one simple tracker.

$2.99 $1.20
View on Etsy
Small Business Cash Flow Planner

Set an annual revenue goal, plan each month, and see achieved and remaining all year.

$5.99 $2.40
View on Etsy
View on Etsy · $3.00