● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Payroll & HR›Time Off Tracker
Time Off Tracker main view of the PTO and leave workbook
PAYROLL & HR

Time Off Tracker

Who is off next week, how many days does she have left, and did anyone actually approve that request? If the answers take a group chat and a calculator, this time off tracker puts every request and balance in one calm place.

$1.00$2.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Leave questions answered in seconds, not group chats

Time off looks simple until three people want the same week, a balance gets argued about, and nobody can find the message where a request was approved. This tracker holds the whole picture in one workbook: every request with its type and dates, its approval status, and what it does to each person's remaining balance, all kept current by the sheet rather than by memory.

Logging a request takes one row. Pick the type, Vacation, Sick, Personal or Parental, add the start and end dates, and the days are counted for you with weekends left out. Approval is a single dropdown: Pending, Approved or Denied. The PTO Balances tab then does the honest maths. Type each name once and the used days appear on their own, counting approved leave only, with remaining days and percent used beside them.

The Team Calendar shows approved time off by month for the year you choose, split by type, so clashes show up while there is still time to sort cover. Breaks that cross a month end are shared fairly between the two months. The Dashboard keeps the running summary: requests still waiting on you, approved days booked, days off this month and totals by leave type.

Inside the workbook: 5 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own Google Sheets
  • BLANK Excel workbook, your fresh start with all formulas ready
  • EXAMPLE Excel workbook filled with a sample team's requests and balances
  • Quick Start Guide PDF with the simple steps on one page
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Google Sheets with a free Google account
  • Also runs in Excel 2021 or Microsoft 365
  • Works on computer, tablet and phone
  • Leave rules vary by workplace, so treat it as a tracking tool
  • Instant digital download, nothing is shipped

Questions about this template

The things buyers ask us most.

How are the days counted?

You enter the start and end dates on the Leave Requests tab and the sheet counts the days for you, leaving weekends out. Approval is one dropdown, Pending, Approved or Denied. Only approved leave flows into the balances, so a request that is still waiting or was turned down never distorts anyone's remaining days.

How do the PTO balances stay accurate?

Type each person's name once on the PTO Balances tab and their used days appear on their own, pulled from approved requests. Remaining days and the percent used sit right beside the used figure, so when someone asks how much leave they have left, the answer is one glance instead of a calculator and a group chat.

Can I see clashes before they happen?

Yes. The Team Calendar lays out approved days off by month for the year you pick, split by leave type, so two people booking the same busy week shows up early. Time off that crosses a month end is shared fairly between the two months, keeping both months honest without any manual splitting from you.

Do I need Excel or Google Sheets?

Either one. The access PDF copies the tracker into your own Google Sheets in one click with a free Google account, and the BLANK and EXAMPLE workbooks run in Excel 2021 or Microsoft 365. The example file carries a sample team's requests and balances, so you can see approvals and balances working before adding your own team.

More in Payroll & HR

All templates in this category →

Three more workbooks from the same shelf.

Employee Training Tracker

Who is trained on what, which certificates are expiring, and what session is next.

$2.50 $1.00
View on Etsy
Employee Directory Tracker

Contacts, emergency details and paperwork for your whole team.

$2.50 $1.00
View on Etsy
Payroll Tracker Spreadsheet

Hours in, gross pay, tax and net pay calculated, pay stubs ready.

$7.50 $3.00
View on Etsy
View on Etsy · $1.00