Try Updoot Free

When spreadsheets get messy, try Updoot

← Back to BlogHow smart managers are never chasing timesheets again.Never chase timesheetsShow me

Year-End Mileage Log: How to Total Your 2026 Business Miles

Year-End Mileage Log: How to Total Your 2026 Business Miles
Share LinkedIn Facebook

Quick Answer

To close out your 2026 mileage log, total business miles separately for January 1 through June 30 and July 1 through December 31, because the IRS business standard mileage rate is 72.5 cents per mile for the first half of 2026 and 76 cents per mile for the second half. Fill gaps from calendars, job records and GPS data before year-end, remove commuting and personal trips, reconcile employee reimbursements against logs, total miles for each vehicle and keep the logs with your tax records.

Mileage logs are easy to ignore all year and painful to fix in January. Trips go unrecorded, odometer readings are missing and nobody is sure which miles were business and which were the drive home. For 2026 there's an extra wrinkle: the IRS business mileage rate changed in the middle of the year, so a single annual total isn't enough. Closing out your log properly before December 31 saves time, protects deductions and makes reimbursements accurate.

This guide walks through closing out a 2026 mileage log step by step, with a free year-end mileage summary template. It's general information, not tax advice; confirm details with your accountant.

The Two 2026 Business Mileage Rates

According to the IRS standard mileage rates page, the 2026 business standard mileage rate is 72.5 cents per mile from January 1 through June 30, 2026 and 76 cents per mile from July 1 through December 31, 2026. That means your log needs business miles totaled separately for each half of the year.

The Two 2026 Business Mileage Rates
PeriodIRS business rateBusiness milesAmount
January 1 – June 30, 202672.5¢ per mile
July 1 – December 31, 202676¢ per mile
Total

Example: 6,200 business miles in the first half × $0.725 = $4,495. 5,800 business miles in the second half × $0.76 = $4,408. Total = $8,903 for 12,000 business miles.

Using one rate for the whole year would give the wrong total. See mileage rates for 2024, 2025 and 2026.

Free Year-End Mileage Summary Template

Free Year-End Mileage Summary Template

2026 Year-End Mileage Summary
Name or vehicle: __________  |  Personal or company vehicle: ______  |  Prepared by: __________

ItemJan 1–Jun 30Jul 1–Dec 31Year total
Starting odometer
Ending odometer
Total miles driven
Business miles
Commuting miles
Personal miles
Business rate72.5¢76¢
Business amount
Reimbursed to date
Difference

Missing log entries reconstructed? ☐ Yes ☐ No  |  Source used: __________  |  Reviewed by: __________  |  Date: ______

Step 1: Record December 31 Odometer Readings

For every vehicle used for business, record the odometer reading on December 31, or as close as possible, along with a photo. If you didn't record a reading on June 30, use service records, inspection reports or fuel receipts with odometer readings to estimate the midyear number, and note how you got it.

Step 2: Fill Gaps Now, Not in April

Look for weeks or months with no entries. Fill them while details are still fresh, using:

The IRS says taxpayers must substantiate expenses with adequate records. Records made at or near the time of the trip are stronger than estimates made months later, so keep notes on how you reconstructed any missing trips and ask your accountant how to handle gaps.

Step 3: Remove Commuting and Personal Miles

Go through the log and make sure ordinary commuting between home and a regular workplace and personal errands aren't counted as business miles. Trips between job sites, to clients and to pick up supplies generally are business. Temporary work locations and home offices can change the analysis. See commuting miles vs. business miles.

Step 4: Split Totals by Half of the Year

Total business miles for January through June and July through December separately. If your log is in a spreadsheet, add a column for the period and use a sum by period. If you use an app, run two reports for the two date ranges.

Spreadsheet formula example: =SUMIFS(BusinessMiles, TripDate, ">=1/1/2026", TripDate, "<=6/30/2026") for the first half, and the same with 7/1/2026 and 12/31/2026 for the second half.

Step 5: Reconcile Employee Reimbursements

If you reimburse employees for business miles, compare what you paid during the year with their logs. Check that the right rate was used for each period, especially reimbursements paid after July 1 for trips made before it. Correct overpayments or underpayments according to your policy, and ask your payroll provider or accountant how to handle any adjustments.

Step 5: Reconcile Employee Reimbursements
EmployeeBusiness miles H1Business miles H2Reimbursement duePaidAdjustment

If your policy uses a different rate than the IRS rate, apply your policy rate, but ask your accountant how it affects the tax treatment of reimbursements.

Step 6: Total Company Vehicle Miles

For company-owned vehicles, total business, commuting and personal miles for each vehicle. Personal use of a company vehicle, including commuting, can be a taxable fringe benefit to the employee, so your accountant or payroll provider may need these totals before year-end payroll. See the company vehicle use policy.

Step 6: Total Company Vehicle Miles
VehicleAssigned driverTotal milesBusinessCommutingPersonal

Step 7: Organize and Keep Records

The IRS generally says to keep records for 3 years, with longer periods in some situations. Ask your accountant how long to keep mileage and vehicle records for your business.

Step 8: Set Up a Better Log for 2027

Use what went wrong this year to fix next year's process. Common improvements include switching from paper to an app, logging trips daily, recording odometer readings at the start and middle of the year and tying trips to jobs. Check the IRS standard mileage rates page for the 2027 rate before updating reimbursement forms. See mileage tracking software.

Year-End Mileage for Self-Employed Owners

Owners who use a personal vehicle for business often keep the least complete logs. Total business miles by half of the year, keep the log with your tax records and ask your accountant whether the standard mileage rate or actual expenses makes more sense for your situation. The choice can affect future years too.

Example: An HVAC Company

An HVAC company reimbursed six technicians for personal vehicle use at a single rate all year. In December, the office manager pulled GPS reports for each technician, split business miles at June 30 and recalculated reimbursements using 72.5 cents for the first half and 76 cents for the second. Two technicians were owed small adjustments for second-half trips reimbursed at the old rate. The company paid the differences in the last payroll and switched to period-based reports for 2027.

Common Mistakes

Year-End Mileage Checklist

Year-End Mileage Checklist
StepDone?
Record December 31 odometer readings
Fill gaps in the log
Remove commuting and personal miles
Total business miles for Jan–Jun and Jul–Dec
Apply 72.5¢ and 76¢ rates
Reconcile employee reimbursements
Total company vehicle miles by use
Save logs and receipts with tax records

Reconciling Fuel Cards With Mileage

If you use fuel cards, compare total gallons with total miles for each vehicle. A large mismatch can mean unrecorded trips, personal use or fuel card misuse. Year-end is a good time to review the full year, since monthly variations even out. See the fuel log.

Example check: A van averages about 15 miles per gallon. 12,000 miles ÷ 15 = about 800 gallons expected. If fuel card records show 1,100 gallons, investigate the 300-gallon difference.

Mileage by Job or Client

If trips are tied to jobs or clients, total miles by job for the year. That shows the real cost of serving distant customers and helps you set trip charges or service areas for next year. It can also support billing clients for travel where your contracts allow it. See job cost codes.

Year-End Mileage for Multiple Vehicles

Businesses with several vehicles should produce a summary for each one, plus a fleet total. Track which driver used each vehicle and when vehicles were bought, sold or replaced during the year. A vehicle sold in August needs its own closing odometer reading and totals for the months it was in service.

Year-End Mileage for Multiple Vehicles
VehicleIn service datesBusiness miles H1Business miles H2Total business miles
Fleet total

Communicating With Employees

Send employees who drive for work a short reminder in early December: submit any missing trips by a set date, record December 31 odometer readings and check their reimbursement totals. Explain the two 2026 rates so employees understand why reimbursements before and after July 1 differ.

Sample reminder

Sample reminder: Please submit all 2026 business trips by [date] and record your odometer reading on December 31. Reminder: trips from January through June are reimbursed at 72.5¢ per mile and trips from July through December at 76¢ per mile, under our policy. Contact [name] with questions.

Common Questions From Employees

Year-End Mileage Quick Reference

Item2026 detail
Business rate, Jan 1–Jun 3072.5¢ per mile
Business rate, Jul 1–Dec 3176¢ per mile
Odometer readingsDecember 31 (and June 30 if available)
ExcludedCommuting and personal miles
RecordsLogs, receipts, summary with tax records

Example: A Real Estate Office

A real estate office reimbursed agents for showings and client visits. Several agents kept paper logs that were missing whole weeks. In early December, the office manager asked agents to compare their logs with their showing calendars, fill gaps and split totals at June 30. Agents who used a phone app were done in minutes; those with paper logs took a few hours. The office required app-based logging for 2027.

Year-End Mileage and Reimbursement Policies

Use year-end to review your mileage reimbursement policy: the rate you pay, how employees submit logs, deadlines and what counts as business mileage. If many logs were incomplete or late, tighten submission deadlines or require app-based logging. If you plan to follow the IRS rate in 2027, write in the policy that rates change when the IRS announces new ones, so midyear changes like 2026's are handled automatically. Check the IRS standard mileage rates page for updates.

Mileage Records for Different Vehicle Types

Keep separate logs for each vehicle, even if one employee drives more than one. Trucks, vans and cars may have different costs, fuel economy and tax treatment, and mixing them in a single log makes year-end totals hard to check. For electric vehicles, track charging costs alongside miles. Label each log with the vehicle's plate or asset tag so records line up with your asset list and insurance schedule.

Getting Started This Week

  1. Send employees the year-end mileage reminder.
  2. Run mileage reports for January–June and July–December.
  3. List vehicles and their December 31 odometer readings.
  4. Compare reimbursements paid with logged business miles.
  5. Book time with your accountant to review totals.

Starting in early December leaves time to fill gaps before the holidays.

Year-End Totals for Owners and Partners

Owners and partners who drive their own vehicles for business should total their miles the same way, split at June 30, and give the summary to the accountant with other year-end documents. Keeping owner mileage in the same system as employee mileage makes it easier to review and less likely to be forgotten.

Store the owner summary with the rest of the year's tax documents.

Checking the Math

Before finalizing, recalculate each half of the year separately: business miles times the rate for that period. Then add them. Compare the total with reimbursements paid and with the amount your accountant expects. Simple errors, like using 76 cents for the whole year, are easy to catch with a quick recalculation.

A second person checking the totals adds confidence.

Final Thoughts

Closing out a 2026 mileage log takes a few extra steps because of the midyear rate change. Record year-end odometer readings, fill gaps, remove commuting and personal miles, total business miles for each half of the year, reconcile reimbursements and save everything with your tax records. Then set up a better log for 2027 so next year's close-out is simple.

Track Mileage All Year With Updoot

Updoot's mileage tracking records trips by employee, vehicle and job, so year-end totals for each half of the year are a report instead of a reconstruction project.

Sources

Related Reading

Mileage Rate 2024, 2025 and 2026 →

Commuting vs. Business Miles →

Mileage Tracking Software →

Frequently Asked Questions

What is the 2026 IRS business mileage rate? ▶
72.5 cents per mile for January 1 to June 30, 2026 and 76 cents per mile for July 1 to December 31, 2026.
Why do I need to split 2026 miles? ▶
Because the business rate changed on July 1, each half of the year uses a different rate.
What if my log has gaps? ▶
Fill them from calendars, job records, GPS and receipts, and note how you reconstructed them.
Should commuting be included? ▶
No. Ordinary commuting between home and a regular workplace is generally personal.
How do I reconcile employee reimbursements? ▶
Compare paid amounts with logs, check the rate used for each period and adjust under your policy.
Do company vehicles need year-end totals? ▶
Yes. Personal and commuting use may be taxable, so totals may be needed for payroll.
How long should I keep mileage logs? ▶
The IRS generally says 3 years, longer in some situations; ask your accountant.
Where do I find the 2027 rate? ▶
On the IRS standard mileage rates page once it is announced.
How do I check fuel cards against mileage? ▶
Divide miles by average miles per gallon and compare with fuel purchased.
What if a vehicle was sold during the year? ▶
Record its final odometer reading and totals for the months it was in service.

Ready to try Updoot free?

Track business miles by employee and job all year. Free to start.

Start Free Today