Mileage Reimbursement Excel - Free Template

1. Open the Lists & Instructions tab and read the setup notes before entering transactions. Confirm the mileage-rate assumption shown for 2026 and replace it with the rate your policy requires.
2. Go to the Mileage Log and assign a unique Trip ID for each business trip. Enter the Trip Date, Employee Name, Department, Start Location, Destination, and Business Purpose.
3. Enter the Odometer Start and Odometer End readings. Check that the resulting Business Miles are reasonable for the route and that the end reading is not lower than the start reading.
4. Review the Mileage Rate and Reimbursement Amount for the trip. Enter eligible Parking/Tolls so Total Reimbursement includes both mileage and incidental travel costs.
5. Select an Expense Category and Approval Status, then mark Receipt Included? accurately. Use Notes for a client name, job number, exception, or explanation of a personal detour.
6. At the end of each week or payroll cycle, compare the log with submitted receipts and approved expense reports. Correct missing fields before payment is released.
7. Use the Summary Dashboard for a management review of mileage and reimbursement activity. Save a dated copy after approval so you retain an audit trail without changing the original entries.

A small business usually needs this workbook at the moment an employee drives a personal vehicle for company work and asks to be paid back. An office manager at a plumbing contractor may record trips from the shop to three job sites, while a sales representative may submit 1,200 business miles after visiting customers across two counties. Without a trip-level record, payroll has little evidence for the amount being reimbursed.

Payroll And Expense-Report Use

Use the Mileage Log before each payroll run or expense-review meeting. A general contractor with four employees might receive 35 trip entries in a week: 900 business miles at a $0.70 placeholder rate produces $630.00 of mileage reimbursement, before $84.50 of parking and tolls. The Employee Name, Department, Approval Status, and Receipt Included? columns let the office manager separate approved claims from items that need documentation.

Bookkeeping And Department Review

A bookkeeper at an LLC can use Department to compare field service, sales, and administration costs without mixing trips together. The Summary Dashboard is useful during month-end close because the bookkeeper can compare the dashboard total with the reimbursement batch submitted to payroll or accounts payable. Image 2 gives the manager a visual review rather than requiring a search through every row.

Year-End Documentation

At year-end, a sole proprietor may use a similar log to support business-use mileage reported with Schedule C, while an employer uses it to support an accountable reimbursement arrangement. The Start Location, Destination, Business Purpose, and odometer fields are more useful than a bank statement that merely says an employee received $412.00. Image 1 shows where those facts are captured in the workbook.

The workbook displays a configurable 2026 placeholder of $0.70 per business mile. Treat that figure as an input, not an automatic tax conclusion: confirm the official IRS standard mileage rate for 2026 and your written company policy before processing payments. At 642 qualified miles, a $0.70 rate produces $449.40; adding $26.00 of eligible tolls produces $475.40 total reimbursement.

Business Trips Versus Commuting

Ordinary commuting between an employee's home and regular workplace is generally personal, not business mileage. Travel from a company location to a customer, supplier, temporary worksite, or another business destination is the type of trip your Business Purpose and location fields should explain. Do not count the same miles under both the standard mileage method and actual vehicle expenses; choose and apply the method required by the applicable tax treatment.

Accountable-Plan Documentation

An employer generally wants a reimbursement arrangement that requires a business connection, adequate accounting, and return of excess advances. The Trip Date, Start Location, Destination, Business Purpose, Odometer Start, Odometer End, receipt indicator, and approval record help establish that trail. Reimbursements that fail accountable-plan requirements can be treated as wages, which may bring FICA withholding and employer payroll tax into the calculation.

Retention And Tax Reporting

The IRS generally expects tax records to be retained for 3 years, with 6 or 7 years relevant in certain situations. Keep the Excel file with receipts, policy versions, payment records, and approval evidence rather than retaining only the dashboard total. A self-employed taxpayer reports qualifying vehicle expenses through Schedule C and may need Schedule SE; an employee reimbursement is handled through the employer's payroll and accounting process instead.

The costliest failures are usually small omissions repeated across dozens of trips. I have seen employees enter “customer visit” in every Business Purpose field, leave the destination blank, and submit one monthly total. That may save five minutes per week, but it can force a $1,050 claim back into review when the employer cannot connect the payment to identifiable business travel.

Odometer And Distance Errors

Entering 18,430 as Odometer Start and 18,390 as Odometer End creates a negative distance that should never be approved. The opposite problem is more common: a driver types 185 miles for a route that is normally 28 miles, inflating reimbursement by $109.90 at $0.70 per mile. Compare unusual entries with a map, vehicle record, or job schedule before payment.

Duplicate And Personal Miles

Duplicate Trip IDs or copied rows can pay the same 74-mile visit twice, creating an excess payment of $51.80 before tolls. A personal stop does not automatically make the entire trip business mileage; document the business portion and apply the company's policy consistently. The Notes field is the right place to explain a route exception, not a substitute for inventing a purpose after the fact.

Approval And Receipt Gaps

Parking and tolls are often added to Total Reimbursement without a receipt, even when company policy requires one. A $38.75 parking charge may look minor, but 20 unsupported charges become $775.00 that accounts payable must chase. Mark Receipt Included? honestly, use Approval Status before payment, and preserve the submitted receipt with the dated workbook copy.

Another failure is changing the rate in one batch while older rows remain unclear. If 1,500 miles were paid at $0.70 instead of an approved $0.67 policy rate, the difference is $45.00; the larger problem is proving which rate was authorized for each period.

The workbook works best when mileage entry is attached to an existing event rather than postponed until tax season. Set a fixed cutoff, such as 3:00 p.m. every Friday, and require employees to complete the Mileage Log before the expense batch is prepared. For a 12-person service team averaging 18 trips each week, that routine prevents 216 entries from becoming a month-end reconstruction project.

Use A Short Review Sequence

• First, filter the log for blank business purpose, location, odometer, or receipt fields.
• Second, review rows marked pending rather than reading approved rows again.
• Third, compare the Summary Dashboard total with the payroll or accounts-payable payment batch.
• Fourth, save a dated copy after approval, such as Mileage-2026-06-30.xlsx.

Keep Input Consistent

Use the same department names, expense categories, and approval labels every time. The Lists & Instructions tab helps establish the terminology; do not alternate between “Field Service,” “Field Svcs,” and “Service” when managers expect a department total. Copying a prior period can save time, but delete old trips and verify every date, employee, odometer, and rate before saving.

Know When Excel Is Too Small

This template is a practical control for a modest operation, but 10,000 rows, multiple legal entities, or frequent payroll integration calls for a real expense system. Move to QuickBooks or an expense platform when employees submit from mobile devices, receipts must be retained automatically, or the same reimbursement data must flow into payroll without rekeying. Until then, a weekly review and a locked approved copy are stronger than an expensive system nobody updates.