PTO Tracker Spreadsheet | Employee Vacation Tracker | Sick Leave and Time Off | Team Calendar | Small Business | Google Sheets & Excel

Track vacation, sick days and time off for your whole team with this Employee Vacation and PTO Tracker. See days left for everyone, a monthly team calendar and who is out today.

WHAT'S INSIDE

• Start Here: company name, year, your weekend days and company holidays

• Dashboard: days left for every employee and who is out

• Employees: yearly vacation days, sick days and days carried over

• Leave Log: one row per request with type, dates, half day and approval

• Team Calendar: who is out each day of the month

• Help & FAQ: quick answers

FEATURES

✔ Days counted automatically, weekends and holidays skipped

✔ Custom weekend days (Sat-Sun, Sunday only, Fri-Sat)

✔ Half days supported

✔ Only approved leave is counted

✔ Carry-over days

✔ Monthly team calendar

✔ 150 employees and 1,500 requests ready

HOW IT WORKS

1. Download the file and open it in Google Sheets or Excel (the PDF guide shows how).

2. Set your weekend days and holidays, then add your employees.

3. Log each request. Days left and the calendar update themselves.

YOU WILL RECEIVE

✔ 1 .xlsx template file (blank, ready to use)

✔ 1 DEMO file with sample data, so you can see how it works

✔ 1 PDF guide: how to open it in Google Sheets (free) or Excel

PLEASE NOTE

✔ Digital product. Nothing physical will be shipped.

✔ Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer / Microsoft 365.

✔ Not compatible with Apple Numbers.

✔ Due to the digital nature, no returns. Message us for any help!

✔ For personal or own-business use only (no resale or sharing of the file).

Dark Mode version and Spanish version also available in our shop.