No coding. Manage employee attendance with a free, customizable spreadsheet. Easy to edit, share, download, and print. Access on any device. Perfect for HR! Streamline attendance tracking for your employees. Free, easy-to-read spreadsheet you can access and edit on any device. Download, print, and share in seconds. Make the hiring process seamless with a free Employee Onboarding Template. Let new employees view tasks, team members, and resources in an online spreadsheet.
View as a spreadsheet, calendar, or cards. Easy to customize and share. Optimize referral process with Referral Tracking Spreadsheet. Accessible and editable through any mobile device. Fully customizable with no coding required. Keep track of new employee information in a professional HR Onboarding spreadsheet. Customize, update, and manage from any device. Keep track of employee training and progress. Free online checklist for employers. Easy to customize, download, and share.
Works on all devices. Track hourly rates, tax rates, and deductions with a free online Payroll Template. Track expenses and ensure your employees get paid properly.
Track your business expenses online. Easy to customize, embed, share, or download. Track employee referrals online with our free Employee Referral Tracker spreadsheet. Great for HR departments. Manage referrals seamlessly on any device. It's easy to use and we spent less than 30 minutes customizing it to our needs.
Regardless of whether you have 5 or 50 employees, this simple spreadsheet is all you'll need to manage your in-house vacation benefit tracking! This vacation accrual spreadsheet tracks vacation , sick leave and personal leave. It can handle all of the most common accrual periods including monthly , semi-monthly , weekly , or bi-weekly.
Note that "semi-monthly" means twice per month and "bi-weekly" means every two weeks. New in Version 1. See screenshot 3. If your company uses daily vacation accrual, this spreadsheet may not work for you. It is set up for weekly, semi-weekly, monthly, or semi-monthly accrual periods.
If you are using a semi-monthly accrual period twice per month , use the Monthly Accrual worksheet and change the Pay Period to Semi-Monthly. The new hourly accrual worksheet allows you to enter the pay period date and the number of work hours. The benefits accrued are then calculated by multiplying the accrual rates by the number of work hours. I would assume that your company's benefits policy states the number of hours of vacation and other benefits an employee can earn each year.
The accrual rate is also shown in the worksheets, so if necessary you can manually override the formulas in those cells to enter specific accrual rates.
Besides the obvious Company Name and Employee Name fields, there are a few other values you'll need to enter. Monthly Accrual worksheet: This one is pretty simple. Just enter the date of the start of your fiscal year and choose the pay period. Hourly Accrual worksheet: In this version, you enter rates representing how many vacation hours are earned for each hour of work. Your mobile phone system may also recommend that you open your new vacation spreadsheet in the Google Sheets app for Android or Google Sheets for iOS which is streamlined for small screens and touch-screen tablets.
Excel Warning : This spreadsheet template is only tested to function as a Google Sheet only. Do not attempt to download a Microsoft Excel. The time off calculated scripts only work online using Google Sheets which is free. The full instructions are contained in the spreadsheet, but to get you started here are the step-by-step time-off tracking instructions:. This vacation spreadsheet is completely free to use, private when you make a copy, and contains zero advertising and cookies.
All that I ask is for your feedback see below so that I can continue to add new features and smarter ways to track, visualize, and maximize vacations and work-life balance. You can support the VacationCounts site by subscribing to the newsletter and sharing the link to this page with your co-workers and connections. You can still access the previous editions of the vacation tracking spreadsheet.
The vacation calendar was published and hosted in the Google Docs Template Gallery , but unfortunately the public template gallery was discontinued by Google. The and versions are hosted on the public Google Drive folder of VacationCounts. The spreadsheet will be actively improved in response to your feedback. We plan to add new features in future releases and update the template every calendar year, usually at the end of December.
Any feedback that you care to offer or reports of bugs or strange behavior is very much appreciated. After releasing this popular Vacation Days Tracker template file for Google Sheets for years, the team at VacationCounts created an app that does even more. You can organize your past trip details, visualize your travel accomplishments, and measure your work-life balance online. Plus it offers complete paid time off PTO tracking including company holidays, personal days, floating days, and bonus days.
Always know how many days you have remaining to plan a trip before the year is up. Give our free take time off app a try today as a better way to track, optimize, and take all your time off from work and life.
0コメント