Do you need a smart way to track your vacation days for the year*? VacationCounts has created this Google Sheets (spreadsheet) template document that not only tracks your vacation benefits, it also tracks your company holidays, floating holidays, and bonus days accrued off from work. It includes a Dashboard which graphs your vacation usage to date along with statistics to show you how well you are maximizing your work-life-vacation balance. Never lose a paid day off because you forgot to track it and use it!
*Updated annually: latest file version with 2018 holiday monthly calendar.
The following link opens the vacation tracker spreadsheet in Google Docs, now updated for 2018. Read the instructions below for how to create a private copy of the file using this template whether you are on a desktop or tablet or laptop computer or using a smart phone to track your vacation days online. No matter which device you start with, your vacation tracker can be opened on any device via browser or app.
IMPORTANT: You need to login to your Google Account to be able to save a copy of this template for private use. Your copy of the vacation days tracker will be stored in your own Google Drive account. You do not need to request permission to edit this template as you’ll be making a private copy for yourself. No information is shared with VacationCounts servers since Google handles the secure sign-in, copy, and storage when you use the template file.
On Chrome for Windows or Mac, you should automatically be prompted by Google to make a copy of the document for yourself. If you are not already signed in to your Google (Docs and Sheets) Account, you will first be prompted to do so. The behavior may vary so if you are not prompted, click on the File… menu to Make a copy for yourself to get started.
You’ll get a fresh copy of the latest version of the template to use as your own vacation days tracking spreadsheet. Your Vacation Days Tracker will be stored in your own private Google Drive folders (not shared) which you may choose to share with family members if you like.
The mobile user experience may be slightly different. Depending on your mobile device such as iPhone (iOS) or Windows Mobile (the latest Android OS works the same as Chrome desktop) you may have to manually make a copy of the template. After opening the vacation template if you aren’t prompted to make a copy right away (similar prompt as above), follow these instructions to take the View Only mode and make a personal copy.To make an editable copy and store it in your own Google Drive securely, open the file menu using the top right icon and select “Share & Export” then the “Make a copy” item.
You will be prompted to make a copy of the spreadsheet by entering a document title and selecting the drive folder to store your copy of the Vacation Days Tracker. Your mobile phone OS 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.
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 2016 vacation calendar was published and hosted in the Google Docs Template Gallery, but unfortunately the public template gallery was discontinued by Google. The 2017 version is hosted on VacationCounts.com and you can still make a copy for your own private use.
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 in early December. Any feedback that you care to offer or reports of bugs or strange behavior is very much appreciated. Without your help and support the travel blogger at VacationCounts (that’s me, Scott) cannot make fixes and update the vacation tracker smart app scripts each year.
Go to the Vacation Days Tracker Feedback Form (hosted by Google Docs).
Thanks again for your support and please share this with your friends and colleagues and family using the social media and email sharing icons below.