Employee Attendance Tracker Google Sheets Excel | PTO Tracker, Vacation and Time Off Tracker, Attendance Points, HR Spreadsheet

Seller's description

Know who was late, sick or on vacation, and how much PTO everyone has left.

This Employee Attendance & PTO Tracker is a ready-to-use spreadsheet for Google Sheets and Excel. Mark each day on a whole-year calendar with one letter per employee. PTO Balance shows vacation and sick days used, days booked ahead and days left for everyone, Monthly Summary counts every code month by month, and Points adds up late and absent days so you see who needs a talk. Type in the yellow cells; everything else is calculated for you.

▶ VIDEO TUTORIAL: see every tab in about a minute: https://youtu.be/Zirp4SleXgw

━━━━━━━━━━━━━━━━━━
WHAT’S INSIDE (FULL VERSION, 8 TABS)
━━━━━━━━━━━━━━━━━━
• Start Here: quick setup guide
• Dashboard: attendance rate, absences, PTO used, late arrivals, active employees, out today, talk-needed flags, no-call no-shows, charts
• Employees: up to 30 employees with department, job title, start date, status, PTO days per year and carry-over
• Attendance: a calendar for the whole year, one column per employee, color-coded codes (present, late, sick, vacation, absent, no-call no-show, holiday)
• PTO Balance: allowance, carry-over, vacation used, sick days, booked ahead and days left for every employee
• Monthly Summary: every employee and every code for the month you pick, with attendance %
• Points: points for late, absent and no-call no-show days, last 90 days, warning and talk-needed status
• Setup: year, attendance codes, default PTO days, sick days rule, points and warning levels, departments

A tab bar at the top of every page lets you jump between tabs in one click.

━━━━━━━━━━━━━━━━━━
YOU GET 4 FILES
━━━━━━━━━━━━━━━━━━
• Full version with sample data (see it working)
• Full version, blank
• Lite version (6 tabs: Start Here, Dashboard, Employees, Attendance, PTO Balance, Setup) with sample data
• Lite version, blank

━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. Download the .xlsx files after purchase.
2. Google Sheets: upload to Google Drive, open, then File > Save as Google Sheets.
Excel: open the file and click Enable Editing.
3. Fill in Setup (about 3 minutes), add your employees, then type one letter per day on Attendance.

Works in Google Sheets (free) and Microsoft Excel (desktop and Microsoft 365). Not for Apple Numbers.

━━━━━━━━━━━━━━━━━━
LIFETIME UPDATES + FREE SMALL CHANGES
━━━━━━━━━━━━━━━━━━
Every improvement I make is yours for free: just download the files again from your Etsy purchases.
Need one small change? An extra column, your currency, more rows, a renamed category. Message me after your purchase and I will make it for you, free. I reply within 24 hours.

━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
• This is a digital download. No physical item will be shipped.
• Not legal or HR advice. Check your local rules for PTO and attendance policies.
• Due to the digital nature of the product, I do not accept returns, but message me and I will help with any issue.

Designed by Albina at HomeBizPaperwork. Built with the help of AI tools and my own scripts, then checked in Google Sheets before every release.