Who is trained on what, which certificates are expiring, and what session is next.
View on EtsyWho 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.
Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.
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.
The things buyers ask us most.
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.
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.
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.
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.
Three more workbooks from the same shelf.
Who is trained on what, which certificates are expiring, and what session is next.
View on EtsyContacts, emergency details and paperwork for your whole team.
View on EtsyHours in, gross pay, tax and net pay calculated, pay stubs ready.
View on Etsy