HR Tracker: Employees, Vacations, Sick Leave, KPI — Excel 2026
HR UNDER CONTROL WITHOUT 1C — VACATIONS, SICK LEAVE AND KPI
An Excel employee tracker: vacation balances are calculated through SUMIF from the journal, sick leave is paid by tenure (60/80/100%), and KPI is computed as plan/fact across three metrics with a 20% bonus.
EXAMPLE FROM THE SCREENSHOT (real calculation of the workbook):
• 8 employees, a payroll fund of 978 000 RUB/month
• Vacation balance across the staff: 154 days
• Sick days per year: 29 days
WHAT´S INSIDE (one xlsx, no macros):
• A staffing table: tenure, salary, vacation balance, sick leave, monthly cost
• A vacation journal: calendar and working days through NETWORKDAYS
• A sick-leave journal: the payout percentage by tenure and the amount to pay
• Quarterly KPI: plan/fact across 3 metrics, average completion, the bonus
• Employee cost including 30% insurance contributions
• A filter on any column, totals across all sheets
• All formulas are open — HR data never leaves your computer
WHO IT´S FOR:
Managers of small teams, HR and small-business accountants. 1C is overkill for 5-15 people, and tracking in a notebook leads to vacation arrears and calculation errors.
FORMAT: .xlsx, works in Excel and Google Sheets. Instant file delivery after payment.
No customer reviews yet.