How to Tell If Your Excel Mileage Log Is Broken

Written by mBurse Team Member Oct 13, 2017 11:40:00 AM

Are Your Employees Padding their Mileage? Here’s How to Tell (and What to Do about It)

If your organization reimburses employees for mileage, chances are you use some kind of mileage log. Quite a few organizations use Microsoft Excel for as a mileage log. Although the Excel mileage log is not the best tool, it serves adequately as a mileage log. But there’s a cost: using a spreadsheet mileage log often leads to overestimated mileage. Here are two reasons why: 

  1. Busy people take shortcuts, and mobile employees stay busy 

Mobile employees don’t have a lot of time. And this leads to shortcuts, such as estimating their mileage. They are tasked with their core job functions: sales, marketing, account management, merchandising. On top of that they find their schedules filled with internal meetings, committees, and training. Then there are administrative tasks like managing email, maintaining their CRM, running marketing and sales campaigns, keeping track of receipts, and logging expenses. When you add a mileage log into the mix, it’s no surprise that many employees guesstimate their mileage—and not in the company’s favor.

  1. Spreadsheet mileage logs amount to one more time-consuming task

Keeping an Excel spreadsheet is a time consuming and inconvenient process, especially for mobile employees. To maintain an Excel spreadsheet mileage log, your employees must take three steps each month:

  1. Keep a separate trip log of their travel, which includes addresses—because they are not in their office
  2. Calculate mileage either by tracking odometer readings or by entering addresses into Google maps or MapQuest
  3. Input data into the spreadsheet on a daily, weekly, and/or monthly basis

You can see why many employees find ways to reduce the amount of time spent calculating mileage. Shortcuts such as rounding up or estimating mileage can cost your company thousands of dollars a year per employee in over-reimbursements, especially if you use the IRS mileage rate.

Mileage infographic

So what are the signs employees are padding their mileage?

Here are three ways you can tell if employees are estimating rather than calculating mileage, along with three fixes:

  1. The mileage amount is always a whole number. If you see that mileage consistently ends with a 0 or .5, there is a good chance employees are rounding mileage. The distance between two locations is not always 20 miles; it could be 19.1 miles or some fraction of a mile.

    How to correct this: Require employees to add the physical address as well as company name. Adding the additional information will take a little more time, but will allow administrators to easily audit the mileage calculation.
  1. Productivity does not match the mileage. Lots of activity does not equal lots of productivity. Unfortunately, because a spreadsheet only holds data, it makes it difficult to measure how productive employees really are, or if they are just very active.

    How to correct this:
    Make employees accountable. Create a column in the spreadsheet into which they must add a short business purpose for each trip.
  1. When gas prices increase, so does employees’ mileage. Because the mileage rate does not rise with gas prices, employees may add a little extra to their mileage totals in an attempt to keep up with gas prices.

  How to correct this: During times of higher mileage, audit mileage     
  calculations and activity vs. productivity.

You can follow this guide to improve your Excel spreadsheet. But you may be wondering whether there’s a better way to log mileage. And there is.

21st-century alternatives to spreadsheet mileage logs

mBurse offers several 21st-century alternatives to mileage logs that will provide visibility, increase accuracy, and decrease time spent calculating and reporting mileage. The key is to incorporate mileage logs into mobile phones and integrate them with CRMs. Click here for a mileage log demo.

Get rid of your speadsheet mileage log

icon of envelope

Subscribe by Email