HR Tracker Pack: Leave, Attendance & Headcount Spreadsheet (Excel + Google Sheets)
Stop tracking leave in emails and notebooks.
The HR Tracker Pack by Shaqo Kaab Solutions gives small and growing businesses one simple spreadsheet for employee records, leave requests, leave balances and daily attendance, plus an HR dashboard that updates itself.
WHAT YOU GET
• Employee register: up to 150 employees, with status and length of service calculated automatically
• Leave log: working days counted for you, skipping weekends and public holidays (half days supported)
• Leave balances: allowed, taken and remaining days for every employee, across up to 6 leave types
• 12 monthly attendance sheets: simple codes, automatic totals and attendance %
• HR dashboard: headcount, joiners, leavers, turnover, who is on leave today, pending requests and absence rate
• Settings page: your company name, year, departments, leave allowances, public holidays and weekend days
TWO FILES INCLUDED
1. Blank version, ready to fill in
2. Example version, filled with sample data so you can see how it works
Works with Microsoft Excel (2010 or later), Google Sheets and LibreOffice. No macros, no subscription. Set up in about 15 minutes with the Start Here guide.
Created by an HR specialist with experience across Oil & Gas, Telecommunications, Banking and Finance, Government, Health, NGOs and recruitment.
Please note: this is a digital download. Leave allowances differ by country, so set them to match your own policies and local law. This tracker is a record-keeping tool, not legal or payroll advice. Licensed for use within one business. Please don't resell or share it.