PTO Tracker for 30 Employees – Excel and Google Sheets Leave Calendar

Manage PTO for up to 30 employees in Excel or Google Sheets. Log requests, review leave balances and see who is out on a color-coded calendar. Workday calculations skip weekends and the company holidays you enter.

Workdays are counted Monday to Friday. Custom workweeks and rotating shift patterns aren't supported.

WHAT'S INCLUDED
• Sample edition (.xlsx): the full 7-tab workbook with a fictional 10-person team and a year of requests, so you can see every feature working
• Blank edition (.xlsx): the same workbook ready for your team, with every formula, drop-down, chart, policy and leave type kept
• Start Here PDF guide: which edition to use, plus setup steps for Google Sheets and Excel

7 TABS
• Start Here: quick start, how balances work, color key and new-year steps
• Dashboard: active team, PTO taken, pending approvals, who is out today, team PTO available, sick days used, people at risk of losing PTO, overlap warnings, the next 30 days, and charts of days off by month and PTO by person
• Team Calendar: pick a month to see who is out each day (vacation, personal, sick, bereavement, jury duty, unpaid, training, holiday, pending), with a daily headcount
• Requests: up to 400 requests with workdays, hours, full or half days, Pending, Approved, Denied or Cancelled, and team overlap warnings
• Team: up to 30 people with department, manager, hire date and policy; PTO earned, used, scheduled, pending, available now and projected year-end, use-it-or-lose-it over the carryover cap, sick allowance and other leave
• Employee Summary: a printable one-page balance statement with request history for any person
• Settings: company and year, up to 8 policies (days per year, sick days, lump sum, monthly or per-pay-period accrual, carryover cap), leave types and your company holiday calendar

COMPATIBILITY
✔ Google Sheets (free Google account; upload the file and open it with Google Sheets)
✔ Excel 2016 or newer, Windows or Mac
✘ Not designed for Numbers or LibreOffice
A computer is recommended for setup.

DIGITAL DOWNLOAD
This is a digital product. No physical item will be shipped. You'll receive a download link after purchase.

LICENSE
For use within one business. Please don't resell, share or redistribute the template.

PLEASE NOTE
• This is a record-keeping tool, not legal or HR advice. Many states and cities have paid sick leave and final-pay rules; confirm your policies comply.
• The sample company, people and requests are fictional. The holiday list is a sample company calendar used to count workdays; edit it to match yours.

PAIRS WELL WITH
• Invoice and Quote Tracker
• Small Business Spreadsheet Bundle

Questions? Contact us through the shop and we'll help.

Designed by The Tidy Blueprint with the help of AI tools.