Menu
- Mileage Tracking Form Log Template Excel Tracker Sheet And Template
- Mileage Log Excel Template Free
- Mileage Tracking Form Log Template Excel Tracker Sheet And Excel
- Mileage Tracking Form Log Template Excel Tracker Sheet And Print
A mileage log is a record of your vehicle miles traveled for business over a particular period kept in a spreadsheet, form, logbook or online application that you use to claim a tax deduction or collect reimbursement from your employer. A mileage log serves as proof and may also be used to keep track of other deductible miles, e.g. Those traveled for medical, charitable or moving purposes. Mileage log and expense report. Report your mileage used for business with this accessible log and reimbursement form template. Mileage and reimbursement amounts are calculated for you to submit as an expense report.
Download a free mileage reimbursement and tracking log for Microsoft Excel®
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. Vertex42'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.
- Jan 08, 2020 Fleet Maintenance spreadsheet is a process of maintaining the good operating condition of vehicles under the same ownership to ensure the maximum availability of the vehicles.Using a spreadsheet you can manage or arrange Truck Fleet or different Fleet according to your requirement. A preventive and proactive maintenance approach is considered helpful in managing the maintenance.
- Mileage tracking templates Use these mileage tracker templates to measure your mileage and keep accurate mileage records. The templates help you track the number of miles your vehicle has traveled in a specific time period.
Other Versions
Template Details
License: Private Use![Tracking Tracking](https://www.mileiq.com/en-gb/wp-content/uploads/sites/3/2018/07/excel-mileage-log-spreadsheet-2018-01-23.png)
(not for distribution or resale)
'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer 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 Vertex42'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 Vertex42'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 Vertex42'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. Vertex42'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.
- Volunteers and Taxes at seriousgivers.org - This site provides details and information about deductions for charity volunteers. Provides details on the rate, what qualifies and other options that you may have.
- Historical Standard Mileage Rate at irs.gov - This IRS document shows the rates over the last 10 or so years. Interesting to see how it changes over time and it doesn't always go up.
- Vehicle Maintenance Log Template - Track your auto maintenance costs using Vertex42'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.
Related Content
Multipart article
In this article, you’ll find the most useful applicant tracking system (ATS) spreadsheet templates for hiring managers, HR, and small business personnel, as well as best practices for filling out these templates.
Included on this page, you'll find many helpful applicant tracking templates, including a Simple Job Applicant Tracking Template, a Recruiting Hiring Template and details on Best Practices for Filling in a Job Applicant Tracking Spreadsheet.
Simple Job Applicant Tracking Template
Use this simple job applicant tracking template to standardize your company’s applicant tracking process. Easily record position (title, description, required experience), applicant (name, position they are applying for, email address, home address, phone number, current employer, current position), and interview details (interviewer, interview score, interview notes). Download this template for single applicant tracking, or use it as your master list to track multiple candidates. You can share this information with fellow employees across multiple teams and departments in order to keep tabs on every open position, candidate, and decision in a single, customizable template.
Download Simple Job Applicant Tracking Template
Excel | Google Sheets | Smartsheet
Recruiter Hiring Template
This recruiter-centric job applicant tracking spreadsheet allows you to maintain control of all the applicant details you need in order to review, interview, and determine whether candidates should be offered a particular position. Unique in its recruiter-friendly design, this one-stop, single-tab spreadsheet keeps all of your job applicants’ details and history within view by displaying the following columns:
- Applicant: Applicant name
- Contact: Applicant contact information
- Application Date: Date applicant applied
- Status: Whether application is open or closed
- Stage: Application received, phone screen, interview, offer made, hired
- Phone Screen Date: Date of phone-screen interview
- On-Site Interview Date: Date of on-site interview
- Offer Date: Date offer made (if applicable)
- Decline Reason: Reason you declined to make an offer
- Notes: Add any other remarks related to application
Download Recruiter Hiring Template
Excel | Google Sheets | Smartsheet
Applicant Flow Log Template
Designed with a focus on helping ensure equal opportunity hiring, this spreadsheet is frequently used by federal contractors to track applicant flow throughout the entire hiring cycle. With comprehensiveness in mind, this applicant flow log allows you to factor in all the required hiring criteria (such as affirmative action details and gender, race, and veteran status) so that you are assured of interviewing and hiring the most qualified candidates.
![Mileage Mileage](https://images.sampletemplates.com/wp-content/uploads/2015/04/mileage-calculator.jpg)
Download Applicant Flow Log Template
Excel | PDF | Google Sheets
Recruitment Data Tool Template
Track candidate-specific details in a unique recruitment data tool that enables you and your fellow recruiters to track and stay apprised of candidate progress. This easy-to-fill template provides editable dropdown lists for each candidate-specific field. In each column, list the job ID, job title, job location, hiring manager, department, job type, recruiter name, job posted date, status, cost, and any additional relevant details.
Download Recruitment Data Tool Template
Excel | Word | PDF
HR Applicant Tracking Form Template
This applicant tracking form template is designed for human resources departments. It provides a comprehensive form that can be shared among HR personnel as well as hiring managers. Use this simple, streamlined applicant tracking form to track candidates’ progress for open positions and report interview outcomes and statuses. With this information at your fingertips, you can make timely offers to the prime candidates and get them working for you as quickly as possible.
Download HR Applicant Tracking Form Template
Mileage Tracking Form Log Template Excel Tracker Sheet And Template
Excel | Google Sheets
You can find additional hiring-related HR spreadsheets here.
Small Business Applicant Tracker Template
As a small business owner, you need every tool at your disposal to do some significant heavy lifting. With a relatively small team, chances are you don’t have personnel dedicated to keeping track of the details of all stages of the hiring process. That’s why a small business applicant tracker template is a perfect solution to record and evaluate candidate details until a position is successfully filled.
Share applicant details with fellow employees and track each candidate’s progress with this free spreadsheet, including the following candidate-tracking columns:
- Position: Job title applicant is applying for
- Name: Applicant’s name
- Email: Applicant’s email address
- Phone: Applicant’s phone number
- Resume: Link to applicant’s resume
- Status: Status of application
- Date Submitted: Date applicant applied
- Details: Notes relating to application
Sewart program for mac. Download Small Business Applicant Tracker Template
Mileage Log Excel Template Free
Excel | Google Docs
Sample Applicant Tracking Spreadsheet Template
Track job applicants’ progress through all stages of the hiring cycle with this easy-to-fill sample applicant tracking spreadsheet. Fill in the columns with details regarding the position applied for, minimum experience required, department, application received date, candidate name, contact information, and more.
Download Sample Applicant Tracking Spreadsheet Template
Excel | Google Sheets
How to Fill in a Job Applicant Tracking Spreadsheet: Best Practices
Next to the sustainability and profitability of your business, nothing is more important than hiring the best available candidates. Your company excels with top-notch performers, and you need a way to keep tabs on open positions and track the progress of applicants. Without a detailed way to keep all hiring-related information in one place, top candidates slip through your fingers, interview histories are lost, and positions remain unfilled.
But, what is the best way to track the best candidates? Your organization needs to ensure that you track these candidates accurately, document the company’s interactions with them, and get these top performers signed on and working for you.
Whether a candidate is someone you’re interested in hiring or not, you need an easy, reliable way to provide a detailed record of their interaction with your company throughout the hiring process.
Using a template can help you get started tracking applicant details for your open positions. Having easy access to each applicant’s details allows you and your coworkers to make informed hiring decisions and land the best candidates.
Once you’ve downloaded an applicant tracking spreadsheet in your preferred format, fill in the following fields:
Mileage Tracking Form Log Template Excel Tracker Sheet And Excel
- Job #: Enter the unique number for the position.
- Job Title: Enter the title of the open position.
- Applicant Number: Enter the unique number for the applicant.
- Application Reason: Enter the source of the applicant’s awareness of the job posting.
- Application Date: Enter the date on which the applicant submitted their application.
- Phone Screen Date: Enter the date of the phone screen interview.
- Ist Interview Date: Enter the date of the first interview.
- 2nd Interview Date: Enter the date of the second interview.
- Recruitment Status: Enter the status of the application.
- Hired Date: Enter the date on which the applicant was hired (if applicable).
- Rejection Reason: Enter the reason that the applicant was rejected (if applicable).
- Notes: Enter any additional notes pertaining to this candidate’s application.
Use Applicant Tracking Spreadsheets with Smartsheet for Human Resources
Next to the sustainability and profitability of your business, nothing is more important than hiring the best available candidates. Your company excels with top-notch performers, and you need a way to keep tabs on open positions and track the progress of applicants. HR executives need the right tools to centralize and track applicant information throughout all stages of the hiring cycle.
One such tool is Smartsheet, a work execution platform that enables enterprises and teams to move faster, drive innovation, and achieve more. Leading HR professionals rely on Smartsheet to help manage everything from simple onboarding tasks to complex change management, recruiting, and benefits and retirement tracking.
Use Smartsheet to maximize ROI on recruiting activities, stay on top of budget, and track internal planning and coordination. Streamline process and paperwork, maintain an auditable database without added effort, and grow your business with better informed, more productive employees.
Discover how Smartsheet can help maximize your human resources efforts today.