PTO balances that are right, without the spreadsheet fights.
For small employers tracking vacation in their heads, where every request starts a debate about days remaining.
Employee Attendance and PTO Tracker is a 5-tab Excel and Google Sheets workbook for small employers tracking vacation in their heads, where every request starts a debate about days remaining. 2 you type into, 1 that fills itself in and 2 you set once. $8.98 once, no subscription.
Filed under team & time.
Type into the highlighted cells, watch every number update itself.
You only ever type in the highlighted input cells, everything else fills itself in.
A one-page setup guide inside the workbook. Enter your basics once: five minutes, done.
Name, start date, annual entitlement input, accrual method.
Employee, date(s), days taken, type [vacation/sick/personal], status.
Part of the automated engine, filled in for you.
Currency, date format and category lists. Change them once and the whole workbook follows.
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and you get a fix plus a refund.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells, every formula updates itself.
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Yes. The Google Sheets version is built natively, not converted: every formula, highlight and protection works the same.
Yes. $8.98 once. You keep the files forever and get free updates to this template.
Digital downloads on Etsy are generally final, but if the template doesn’t work as described and we can’t fix it for you, you get your money back. Just email support@elecart.us.
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
$8.98, once, 40% off. Yours forever, with free updates.
Get it on Etsy →