A Look at Microsoft’s SharePoint Mileage Tracker

UPDATE:  This application is no longer available in the SharePoint Store.

Microsoft provides a free SharePoint mileage tracker app through its SharePoint Store. It is a SharePoint Access application, consequently you will need Access services as part of your SharePoint subscription. Here is the link to the app in the SharePoint Store. A screen shot of the application is presented below.

The application was developed back in 2013 and it has not been enhanced since. It is a very basic application and may be appropriate for business that don’t need much for tracking their vehicles. The app is not synced to any SharePoint Lists so you have to enter and maintain the data from scratch. For example, if you have a SharePoint Customer List and make a change to that list, the change is not reflected in the Mileage Log application. You need to go in and change it there also. This is very different than my post “Lead Tracking – Direct Sales & Mailings” where that Access application is synced with SharePoint Lists and double entry is not required.

I do not post much about SharePoint Access applications since in my opinion they are problematic for small business. Here are my reasons:

  1. You need an Access developer to properly build and maintain the application.
  2. Reporting against the Access application requires maintaining a local version of the application. This adds more complexity to your computing environment.
  3. Limiting SharePoint users from using the application can be complex or require a separated subsite.
  4. Changes to List Columns that are synced to Access tables require additional steps to reflect those changes in the Access application and you need to be careful and know what you are doing.

I included a screen shot of QuickBooks’ Vehicle tracking screen for comparison. Obliviously, it is integrated so you don’t need to enter data in two different places. It also allows the tracking of vehicle usage against customer/jobs, items, and class. As with the timesheet, you can mark the mileage as billable and include it on the customer invoice.

Leave a Reply