PTO & Leave Tracker – Employee Vacation, Sick Day & Balance Spreadsheet (Excel / Google Sheets)

Track every employee's accrued days, leave taken and remaining balance – working days are counted for you.

What's included

• 1 .xlsx file with 3 sheets: Employees, Requests, Settings

• Employees: annual allowance, carry-over, pro-rated accrual from start date, vacation/sick/personal taken, balance

• Requests: employee drop-down, leave type, from/to dates, status (Pending/Approved/Rejected)

• Working days calculated with NETWORKDAYS, excluding your public holidays

• Orange warning when a balance is 3 days or less, red when negative; pending requests highlighted

• Settings: leave-year start and an editable public-holiday list (Italian 2026 holidays pre-filled)

• Up to 50 employees and 1,000 requests

• Works in Microsoft Excel and Google Sheets (File › Import › Upload the .xlsx).

Who it's for

• Small business owners, office managers and HR teams who need a simple PTO system without HR software.

How to use it in 3 steps

1) Set your leave-year start and public holidays in Settings.

2) Add employees with start date, annual days and carry-over.

3) Log each request – only Approved requests reduce the balance.

Format

• .xlsx · instant download