Vacation Days Tracker (Google Spreadsheet Template)

Do you need a smart way to track your vacation days for the year?  VacationCounts has created this Google Sheets (spreadsheet) template that not only tracks your vacation benefits, it also tracks your company holidays, floating holidays, and bonus days accrued off from work.  It has a Dashboard that 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!

Vacation Days Tracker 2017 Dashboard

Vacation Day Tracker Dashboard

How to Get the Vacation Days Tracker

The following link opens the vacation tracker spreadsheet in Google Docs, now updated for 2017. Read the instructions below for how to create a private copy of the file using this template whether you are on a desktop or laptop computer or using a smart phone to track your vacation days online.

Desktop Browser Users

On Chrome for Windows or Mac, you will automatically be prompted by Google to make a copy of the document for yourself. This means that you’ll get the latest version of the template to use as your own.

Copy document - Vacation Days Tracker

Click on the “Make a copy” button so that an editable spreadsheet can be copied to your Google Sheets account. Your Vacation Days Tracker will be stored in your own private Google Drive folders which you may choose to share with family members.

Mobile Browser Users

The mobile user experience is slightly different. On Chrome for Android and on iPhone (iOS) as well as Windows Mobile, the Vacation Days Tracker will default to opening in “View Only” mode.

To make an editable copy and store it in your own Google Drive securely you must open the file menu using the top right icon and select “Share & Export” then the “Make a copy” item.

Vacation Template Mobile Share Export Menu   ->  Vacation Template Mobile Save to Drive

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.


Google Spreadsheet Link to Vacation Days Tracker 2017 (Google Sheets Template)


How to Use the Vacation Days Tracker

The full instructions are contained in the spreadsheet, but to get you started here are the step-by-step time-off tracking instructions:

  1. Make sure that you are logged into your Google Account since Google Docs get stored securely and privately in your Google Drive.
  2. Follow the desktop or mobile instructions above to “Make a copy” of the Vacation Days Tracker 2017 spreadsheet so that you get your own personal file using this template.
  3. Rename the file if you wish. It will be stored privately in your Google Drive in a folder of your choosing.
  4. Open the ‘Initial Setup‘ sheet (tab at the bottom) to enter the details about your HR paid time-off benefits at work:
    1. The total number of vacation days (including roll-over days) you will earn (accrue) this calendar year
    2. The number of personal days or floating holidays if applicable to your employment situation
    3. The list of all your official company holidays for which you receive a paid day off from work
    4. Any bonus or make-up days off that can be used like vacation days (can be added later as needed)
    5. Your vacation goals for the year so you can view progress by using a single day of vacation, going on a weekend getaway, or taking a week or longer vacation.
      Vacation Day Tracker Initial Setup
  5. As you plan and take vacations during the year, enter each in the ‘2017 Vacations‘ sheet – one per line.
    Listing Your Vacations for 2017 - Vacations Tab

    1. This includes all your one-day trips, weekend trips, and week or longer vacations.
    2. For each vacation enter the number of paid days off used in the matching column – vacation, holiday, floating, and bonus.
    3. By entering the location (city, state or country) you can globally map your vacation destinations on the dashboard.
  6. View your ‘Dashboard‘ (the first sheet in the spreadsheet) which will automatically update to display your vital vacation and holiday statistics.  It graphs:
    1. Days Off Remaining in the vacation year by category
    2. Number of Days and the Percent of Days This Year “On Vacation”
    3. Your Vacation Goals progress so far and compared with last year
    4. A Vacations World Map showing where you traveled to this year
  7. Remember to input all your vacations as you plan and take them into the spreadsheet so you can track and use every paid day off and not accidentally take too many.  You never want to lose a paid vacation day or floating holiday simply because you forgot to use it before the end of the year.
  8. Submit your feedback to VacationCounts (see below) so we can add new features and functionality to help you maximize your time off from work.

Is the Vacation Day Tracker Really Free?

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.

What Happened to the 2016 Vacation Tracker?

You can still access the 2016 edition of the vacation tracking spreadsheet. It was previously published and hosted in the Google Docs Template Gallery, but unfortunately the public template gallery is being discontinued by Google. So the 2017 version is hosted by VacationCounts so that you can make a copy to use as your own template. Here is the link to the Vacation Days Tracker 2016 template if you still need it and as long it is still available online.

Vacation Days Tracker Feedback Form

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.

Open Vacation Day Tracker Feedback Form

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.