Human Resources Complete Package

Description

1 SPREADSHEET · 12 CONNECTED TABS · 9 LANGUAGES · 16 CURRENCIES · 5 THEMES ✦ ONE workbook, not a folder of files 📊 Type each employee once. Everything else works it out. 👥 Most HR bundles hand you thirty separate templates and make you type the same person’s name into all of them. Nothing adds up, because nothing is connected. This is ONE workbook. Fill in EMPLOYEES — one row per person — and that single list feeds leave balances, attendance, payroll cost, reviews, training expiry and turnover. Change someone’s salary once and every number that depends on it moves. ───────────────────────────── AND ONE NUMBER NO OTHER TEMPLATE CALCULATES ⚠️ FLIGHT RISK. The sheet scores every employee on how likely they are to resign: • how far below their salary band midpoint they sit • how long since their last pay rise • how long since their last promotion • where they are in the tenure curve • their last performance rating • their unplanned absence Every weight is a yellow cell you control. Change one and the whole workforce re-ranks. Everyone is banded HIGH, MEDIUM or LOW, and the high-risk ones are multiplied by a replacement cost you set — recruitment plus onboarding plus lost productivity while the new person gets up to speed. The dashboard then tells you the two things that matter: how many people are at high risk, what it would cost you if they all left, and who to talk to first. The pattern it finds again and again is the same one every HR manager recognises: a strong performer, paid below the midpoint, with no raise in two years. TWO MORE NUMBERS MOST SMALL BUSINESSES HAVE NEVER SEEN 💰 LEAVE LIABILITY. Accrued but untaken leave, multiplied by each person’s real daily rate. That is money you owe, sitting on your books, and this workbook puts a figure on it. FULLY LOADED COST. Not salary — salary plus employer tax plus benefits plus pension, then per month and per working day. What that person actually costs. Available in ENGLISH, SPANISH, GERMAN, ITALIAN, FRENCH, TURKISH, POLISH, PORTUGUESE and DUTCH. ───────────────────────────── WHAT’S INSIDE — 12 CONNECTED TABS (one-click navigation) ✦ DASHBOARD — headcount, people at high risk, cost at risk, turnover rate, leave liability, annual payroll, open roles and expiring training — with charts for headcount by department, the flight-risk ranking, and leave taken vs entitlement ✦ EMPLOYEES — the master list, 100 rows: ID, name, job title, department, manager, location, contract type, start and end dates, status, salary, band midpoint, last raise, last promotion, review score and leave entitlement. Then tenure, months since raise and promotion, leave taken and left, absence, FLIGHT RISK, RISK BAND and REPLACEMENT COST all calculate themselves ✦ LEAVE — 300 requests: type, dates, working days counted automatically, reason and approval status, with the department pulled in for you ✦ ATTENDANCE — a month-by-month grid for every employee. Mark ✓ present, ✗ absent, ⏰ late or 🏠 remote; the grid colours itself and totals the attendance rate ✦ PAYROLL — gross, employer tax, benefits, pension, fully loaded cost, monthly cost, daily rate and leave liability, per person and totalled ✦ REVIEWS — 150 reviews: date, reviewer, period, score, goals met, an automatic rating band and the next review date ✦ RECRUITMENT — 100 candidates: role, source, stage, days open, offer salary and outcome, with stale vacancies flagged ✦ TRAINING — 150 records with expiry dates, days to expiry, mandatory flag and an automatic EXPIRED / EXPIRING SOON / VALID status ✦ ONBOARDING — a checklist per new starter, with owner, due date and overdue flag ✦ TURNOVER — leavers, reason, voluntary or not, tenure at exit and the cost of each exit, plus a real turnover rate over AVERAGE headcount ✦ SETTINGS — language, theme, currency, leave year, your eight departments, the six risk weights and all six cost assumptions ✦ START HERE — a branded guide that links to every tab ───────────────────────────── MAKE IT YOURS • The RISK ENGINE is yours — six weights and two band cut-offs, all editable • The COST ASSUMPTIONS are yours — recruitment, onboarding and ramp-up percentages, working days per year, employer tax and pension rates • Name your own eight departments; every dropdown and chart follows • 9 interface languages, all dropdowns included • 16 currencies for salaries, payroll and replacement cost • 5 themes including MIDNIGHT DARK • YELLOW cells are yours to fill. GREY cells calculate themselves • Formulas protected (no password) so nothing breaks by accident • No macros, no VBA — every formula works in BOTH Excel and Google Sheets TWO FILES INCLUDED • One filled with a worked example — 60 employees across 6 departments, with leave, attendance, reviews, hiring, training and leavers — so you can see every calculation behave before you trust it • One completely BLANK, ready for your own team from the first row PERFECT FOR small businesses without an HR system, office and practice managers, startup founders doing HR themselves, agencies and studios, and any HR team of one who has been asked “what would it cost us if she left?” and had no way to answer. ───────────────────────────── PLEASE NOTE • This is a DIGITAL product; nothing will be shipped. • Works in Microsoft Excel 2016+ AND Google Sheets (free Google account). • This is a spreadsheet, not legal or payroll advice — check your local employment law and tax rates before relying on any figure. • Digital sales are final — but if anything is wrong with your file, message me and I’ll fix it fast.