HR Tracker: Employees, Vacations, Sick Leave, KPI — Excel 2026
Seller: SirBob
Price: 2.47 USD
Available. The final price depends on the selected options and is checked before payment.
Product description
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.