2027 PTO & Vacation Tracker (Excel + Google Sheets)

DIGITAL SPREADSHEET: nothing is shipped.

Keep track of your 2027 vacation, sick and personal time in one spreadsheet, for just you or a small team of up to 10 people. Log a request with its first and last day off, and the tracker counts the workdays (it skips weekends and holidays), then updates the balances, the year calendar and the monthly chart.

AI disclosure: this item was created with the use of AI. LB3 Trackers designed it with AI assistance; AI tools helped write the formulas, layouts and instructions.

What's inside (8 tabs):

- Instructions: step-by-step setup

- Settings: hours per workday, an "as of" date, and 4 leave types you can rename

- People: yearly hours for each type, 2026 carryover, and Upfront or Monthly accrual

- Holidays: the 2027 US federal holidays (observed dates) plus the day after Thanksgiving, all editable

- Time Off Log: 300 rows, with an hours override for half days, and a Taken/Planned status

- Balances: allowance, carryover, earned, used, planned, available now, and what's left at year end (red if over)

- Calendar: pick a person to see their whole 2027 year, with time off in teal and holidays in gold

- Summary: hours per month for each type, a stacked chart, and the next day off

You get a SAMPLE file (made-up people and dates) and a BLANK file. Works in Excel, Google Sheets, LibreOffice and Numbers. No macros. Pages print on US Letter, landscape.

Please note: this is a personal planning tool, not HR, legal or payroll advice. Check your employer's handbook for the real rules.

Instant download: after payment you get a download link right away.

Questions or a problem with the file? Message us through the store contact page. If the file doesn't work for you, we'll fix it or refund you.

License: personal or own-business use. Please don't resell or share the file.