0

Your Cart is Empty

GS Software - Excel Software

Construction Crew Mileage Reimbursement Excel Calculator


Who and What this tool is for:

The Travel Reimbursement Excel Application is for Construction companies that have to reimburse their employees for mileage driven to the job site. It makes the reimbursement process a breeze and allows for the Mileage Calculation and the generation of slick documents with your company's logo on the fly

How the tool works

The purpose of the tool is to create a tool that makes generating the Reimbursement Forms a breeze. With the click of a button, the user can do each of the following:
  • Update the jobs for each employee by day.
  • Generate the miles for ALL THE TRAVEL between Employee address (home or office) and Job Locations
  • Generate a separate PDF with your Company Logo and Address for each employee to be emailed/printed

Let's explore each feature of the tool


Jobs Screen 

This screen/sheet is where we maintain the Job Information. Each Job requires a Job Name and Job Address. That's it!
Construction Employee Mileage Reimbursement Tool


The Employee Screen

In this screen we maintain the Employee Information For each employee we maintain the Employee Name and the Employee Address. The employee Address will be used to calculate the mileage for the day. 
Excel Employee Travel Reimbursement Tool


The Works Screen

This screen is where we can assign the jobs for each employee for the day of the week. The tool allows us to select a dropdown from the Employee List and the jobs those employees worked each day of the week. 

Fill out the Employee Columns and the jobs that that specific employee worked for the week. Each employee can be assigned one job per day. 
Excel Travel Reimbursement Calculator for Companies


The Settings Screen

Here we can maintain certain values such as the Google Maps API key (information on how to get the api Key is in the link below)
API Key - This is the key we get from Google Maps that allows for the distance Calculations
Non - Reimbursable miles - This is the amount of miles that are not reimbursed. For Example, most companies dont reimburse the first 20 miles of travel. So The employee has to travel over 20 miles in order to get reimbursed. Set Non - Reimbursable Miles to 0 if all the mileage is reimbursable. 
Reimbursable Rate.  - This is the dollar amount reimbursed per mile. 
Path to where you want to save the reports  - Click Browse and select the folder where you want the pdf files to be saved. Each file will be saved with the Employee name and date. Example "2020-05-23_John_Smith.pdf"
Excel Travel Reimbursement Calculator with Driving Time


The Template

This is where you can format how the Reimbursement form will look. You can change the company address, the logo and the look and feel. Please do not delete or add rows as that can mess with the tool to function properly. 


What do our Customers say of us?

Working with Vinnie and GS Software has been a pleasure from start to finish. His expertise became apparent right from the start of our time working together on this project. He was expeditious to provide aid and tweak the software as needed to fit my company’s needs; even creating a training video to support roll-out with my office team internally. All work was completed swiftly and well. I cannot recommend GS Software  highly enough. Vinnie is extremely competent, thorough, and provides a high value experience.
 
Zachary Martin
President
Stief Concrete Work, Inc.’

Q and A

Will the tool work on a PC and Mac?
Yes, this will work on a mac and PC

What Software do I need to install?
There is no need to install anything. The software is built in Excel, all you need is to have Excel installed.

What version of Excel Do I need
Any Version 2013 and newer will do just fine.




Do you need the tool Customized to your current Process and Company?


While this is a generic template that can probably meet the needs of 50% of the companies running crews out there, I also understand that each company is different and has a different process of handling the Travel Reimbursement process.

Please contact me at the information below, and I will help you customize the tool to match your current process. I have built over 150 different software for construction companies, chances are whatever feature you need, I have built it before
Email:   Vinnie@excelvbamaster.com
Phone:  801-243-8350


 

Customer Reviews

Based on 1 review Write a review

Subscribe