<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Filter By Categories
Gwen Chen
By
June 12, 2018

3 Free App-Friendly Human Resources Excel Templates: Timesheet, Expense Tracker and Vacation Request

As promised (in my Project Planner Templates post), I've got more Excel and Google Sheet templates to share! This time we're looking at Human Resources (you may want to check out my post on Inventory Templates) and its three most common use scenarios — take employee attendance, track expenses and process vacation requests.

Turn Your Spreadsheet into a Timesheet App

If you are interested in converting these spreadsheet templates into mobile apps in order to empower and engage your deskless employees, I included links to each sample app that I created. From there, you can copy the app, replace the data and customize it to meet your specific needs.

Without further ado, here are three free human resources spreadsheets! 


HR Excel Template: Employee Attendance Tracker

The weekly multi-employee timesheet (below) has Employee Name, Time In, Time Out, and Hourly Rate fields, basically every key element that a time-sheet should have. In this spreadsheet, you can easily track the number of hours an employee worked each week as well as calculate their weekly wages.

Timesheet Spreadsheet

 


Download Excel Template

Download Google Sheet Template


I changed the above sheet's structure a bit and converted it into the following mobile app. With the app, you can:

  • Take attendance on the fly as long as you have a mobile device.
  • Display attendance data by day, week, month, or year without having to create new sheets.
  • Check out an employee's detailed information.
Multiple Employee Weekly Timesheet App

 


Get The TimeSheet App


 

HR Excel Template: Expense Tracker

The following template can be used by home builders or maintenance technicians, who want to keep track of the progress and cost of each item. It organizes data by Area and tracks Actual Cost and Cost Overruns.

When you add a row, you can track Total Cost per Area. When you sort data by Status, you can see what items are In Progress, Complete, and Not Started.

Contractor Expense Tracker Sheet Screenshot

Download Excel Template

Download Google Sheet Template


I turned the sheet into an app (below) so that superintendents or technicians can enter information on the site without the hassle of filling out a sheet with a pen and driving to an office to submit it. The app shows data by Area and Status and has a Actual Total Cost chart.

Contractor Expense Tracker App

 


Get The Expense Tracker App


 

HR Excel Template: Vacation Request Form

After an employee submits a vacation request form, the HR team might want to gather all forms and put them in one place so that they can monitor whether a request has been approved and the total vacation days per employee.

The following spreadsheet serves that purpose. It keeps a record of all vacation requests. The Timestamp column displays the time when a request was submitted. Total Days is End Date subtracted from Start Date.

Vacation Request

Download Excel Template

Download Google Sheet Template


To make the process even easier, I turned this sheet into an app. From the app, employees can submit vacation request forms. The moment an employee submits a form, all information he or she entered, together with other vacation forms, is automatically stored in one spreadsheet.

You can configure the app so that only the HR team can make edits on a form after it is submitted. You can also pre-fill the form's fields (match a user's login email with the user's information) so that when a user logs in with her/his email (for example, gwen@appsheet.com), the app pre-fills the Employee, Team, Supervisor, and Supervisor Email fields. In this case, the user will only have to enter the start and end Dates.

Vacation Request Form App

Get The Vacation Request App


Well, that's it for now! Hope you find these spreadsheets useful and remember: it's really easy to turn a spreadsheet into an app!

Google Search

Subscribe Email