Whether you're an employee or a business owner, it's important to keep good business mileage records so that you have the information you need for either completing your company's mileage reimbursement form or for determining the mileage deduction on your tax return. TotalSheets's Business Mileage Tracker will help you keep good records and determine total mileage for reimbursement or deduction. Keep reading below the download block to learn more about how to keep track of your business mileage.

categories: Business Business

Business Mileage Tracker

for Excel
Mileage Tracking and Reimbursement Form

Download

⤓ Excel (.xlsx)
For: Excel 2007 or later & Excel for iPad/iPhone

Other Versions

"No installation, no macros - just a simple spreadsheet" - by and Brent Weight

Description

This simple spreadsheet was designed at the request of an individual looking for an easy way to track daily business mileage so that they could report the information to their employer for reimbursement. Although we already had a travel expense report template and a MPG log available, we recognized the need for keeping a daily log of miles traveled for tax purposes, and this is what we came up with.

The Business Mileage Tracker includes a Mileage Log worksheet that you can print, fold in half, and store in your vehicle. Use it to record the start and end odometer reading, as well as the business purpose, whenever you use your vehicle for business travel.

How to Use the Mileage Tracking Template

For Employees

Employees are normally required by employers to keep accurate records for reimbursements. Use the TotalSheets's Mileage Tracker to keep track of your business mileage, purpose, and notes. The template will also help you to calculate the amount you are owed. If your company has a specific reimbursement form for you to use, then keep a copy of TotalSheets's Mileage Tracking Log in your car to track mileage at the source. The Mileage Log is formatted for portability and can be easily kept in the car.

For Small Business Owners

Business owners have two options when it comes to deducting the car expenses. They can choose from the Standard Mileage deduction method or the Actual Car Expenses deduction method. You should read the appropriate IRS publication about this, because there are certain requirements and qualifications associated with each of these methods. Regardless, both methods require accurate records be kept as evidence for the deductions.

Under the Standard Mileage deduction, the miles are multiplied by the IRS deduction rate to determine the amount of the deductions. Actual expenses for things like gas, insurance and maintenance are not deducted, because they are factored into the mileage reimbursement rate. Use TotalSheets's Mileage Tracker to track the miles. The total deduction is then simply the mileage rate multiplied by the reimbursable miles.

The Actual Expenses deduction is used for "itemizing" the actual cost of owning, maintaining and using the vehicle for business purposes. If the vehicle is owned and used 100% for business, then all of these costs can be deducted (see the IRS publication for more information about what costs can be deducted). In cases where the business use is less than 100%, only a percentage of the total expenses can be deducted. TotalSheets's Mileage Tracker was designed to track the business miles and the total miles so that you can calculate the "% Business Use."

For Charity and Non Reimbursed Business Use

There are several situations where you may be able to deduct mileage from your personal taxes, including charity volunteer work, moving, medical travel and unreimbursed business use. In all of these cases, accurate records of your mileage are required. Make sure you review the IRS specifics for each of these cases or consult a tax accountant before taking these deductions.

Tips for Mileage Tracking

  • Seek the help of tax professionals for complicated or questionable situations. Better to be safe than sorry.
  • Be careful not to mix the Standard Deduction and Actual Expense methods. For example, if you reimburse at the standard rate, don't deduct the actual cost of the gas or service fees.
  • Mileage for commuting to and from work is not deductible. Don't even go there.
  • Include specifics in your notes about your trips for future reference. This could be important in an audit situation. Include the purpose, start and end locations, people visited and outcomes. Note other costs such as parking and tolls.
  • Be aware that there are rules on switching between the Standard Mileage and Actual Cost deduction methods.
  • If you are an employee, make sure you understand what you can and cannot deduct from your taxes. If you are reimbursed under an accountability plan (your reimbursements are NOT on your W-2), then you are not allowed to deduct the mileage. If your reimbursements do show in your W-2, then you may be able to deduct your mileage as long as you follow the rules and limitations.
  • If you fail to record actual mileage, then make an educated guess backed up with additional information. For example, determine the mileage using a web based mapping system and print a copy for your records.

Resources for Mileage Tracking and Reimbursement

  • IRS: Topic 510 – Business Use of a Car at irs.gov - This is the official IRS publication on tax deductions for business use of vehicles. It outlines the two different methods available for deductions – standard mileage deduction and the actual expenses deduction. It provides specifics about when to use each method as well as information for employees who are reimbursed for their mileage.
  • Official IRS Publication of the Standard Mileage Rates at irs.gov - This page lists the mileage rates for business, medical, moving and charity reimbursement rates. Make sure to look up the latest rates for the current year.
  • Vehicle Maintenance Log Template - Track your auto maintenance costs using TotalSheets's new maintenance log.
Disclaimer: The content and information on this page is for educational and informational purposes only, and should not be taken as professional legal, financial, or tax advice. For questions about taxes and finances, please consult with a certified professional.