Download Employee TA Reimbursement Free Excel Template

Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Download free excel template for claiming reimbursement of travel expenditures. This template is useful for companies and organizations where travel expenses are reimbursed on actual basis.

Understanding traveling allowances (TA)

Employees are entitled to TA reimbursement for their official travels. TA stands for Traveling Allowance. Traveling allowance is the amount paid or allotted to an employee by the employer for traveling to another place for business purpose.

The traveling allowance includes modes of travel, accommodation, meals, and other incidentals. Traveling Allowance is an additional sum of money apart from the salary given to the employee when he/she travels to other places for business purposes. Thus, the amount is not deducted from the salary of the employee.

Components of TA Reimbursement Form

Usually, in a small or medium-sized company, the reimbursement of TA includes modes of travel, accommodation, meals, and other incidentals.

But in larger corporates, there are many more details as follow:

  • Airfare
  • Rail transportation
  • Rental vehicles
  • Conference registration fees
  • Mileage expenses
  • Rental vehicle expenses
  • Lodging (commercial)
  • Meals (per diem)
  • Business meals
  • Business expenses
  • Parking
  • Telephone calls
  • Tolls
  • Visa, passport fees, and immunizations
  • Other business expenses.

Different companies have their predefined formats for reimbursement of TA.

About employee TA reimbursement template in Excel

This template consists of 6 sections: Header Section, Employee Details Section, Travel Details Section, Food and Accommodation Expenses Section, Travel and Other Expenses Section, and Approval Section.

The header section consists of the company name, company logo, and heading of the sheet “TA Reimbursement Template”.

Employee Details

Employee details section consists of general details like employee name, employee id, designation, department, and purpose of the trip.

Travel Details

Travel details section consists of data for each day, From and To Travel destinations.

If you are using your vehicle for the official travel then you need to enter kilometers for a daily run.

Once you add the kilometers the sheet will automatically multiply it with the usage rate and displays the result in the travel expenses section.

Food and Accommodation Expenses

This section consists of expenses related to room rent, daily breakfast, lunch, and dinner.

Travel and Other Expenses

The travel and other expenses section include all expenses related to travel. It includes expenses of air tickets, taxi charges, rent a car, parking, etc.

If you are using your vehicle for travel, you need to mention the daily run in the travel details section.

If you mention the daily run and rate in the respective column, it will automatically calculate the mileage for you.

The template shows both; daily totals as well as weekly totals of each head of expense. With this template, you can claim up to 7 days of travel expenses.

Approval Section

In the end, there is an approval section. This section consists of final calculations. If you have received any advances from the company you need to mention them in the cell below totals.

Total Reimbursable Amount = Sub-Total of all the expenditures – Advances taken from company.

Download and use Employee TA Reimbursement Excel template

To use this free Employee Travel Allowance Reimbursement excel template, you should have Microsoft Office/ Microsoft Excel installed in your system.

After installing Excel or Spreadsheet, download the zip file of this template. Extract the template using WinRAR or 7Zip decompressing software.

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click the button below to Download Employee TA Reimbursement Excel Template

By Downloading this Free Excel Template, it is implied that you comply with Download Instructions

Download Instructions

If the excel templates can not be downloaded, Leave us a feedback at admin@exceldownloads.com. We will solve the related problems/ query for you as soon as possible. All Excel templates and dashboards and tools are sole property of exceldownloads.com. As a User, you can download and use the excel templates, dashboards and calculators for personal and business use with no payment i.e. for free. But without permission, you can not distribute it on the Internet website or any other online or offline medium !

Without permission granted from us/ management team of ExcelDownloads.com, use of these excel templates and dashboards is not allowed. However, if you want to share this templates and dashboards with your friends and peers, we have provided sharing option in various social media and platform via which you can share our content.

We hope that you can get our help in making your personal and business activities easier with the use of free excel templates and dashboards, and at the same time, support the construction of our website by considering our efforts and aforesaid instructions.