Employee Management
Import the sheet once
The master spreadsheet becomes employee records in one import, and the org chart builds itself from the data on day one.
The situation
A company run from four files and a folder.
Import · people.xlsx
Columns mapped, sample shownDone
84 people createdDone
Leave provisioned from policyDone
Invite everyone to sign inNow
This world has a real workforce and a shadow one. The real one works, takes leave and gets paid. The shadow one lives in a master spreadsheet owned by whoever built it, a leave tracker with formulas nobody dares touch, a payroll export edited by hand every month, and a shared drive of contracts in six naming conventions. Every question about the real workforce is answered by the shadow one, and they disagree more every week.
Where it breaks
The problems that live in this world.
Not generic HR pains: the specific ways this environment grinds people teams down, one honest description at a time.
One file, many truths.
The sheet gets emailed, copied and edited in parallel. Two versions disagree about a salary, and the one that reaches payroll is whichever was attached last.
Formulas fail silently.
A dragged formula skips a row and someone’s leave balance is wrong for months. Spreadsheets do not raise errors about being wrong, they just keep being wrong politely.
Everyone sees everything, or nothing.
A spreadsheet has no row-level permissions. Either the salary column is visible to whoever opens the file, or HR becomes the bottleneck for every single lookup.
History does not exist.
Cells get overwritten. Who changed the salary, when the role changed, what the balance was in March: unanswerable, which is uncomfortable in a dispute and fatal in an audit.
Day to day
Three operational realities, handled.
Attendance, pay and compliance are where this world gets judged. Here is how each one runs on a connected record.
01
Leave leaves the tracker.
Balances calculate from policy, tenure and entitlement, with public holidays excluded and carry over handled at year end. Approvers see who else is off before saying yes.
02
Payroll stops being an export.
Payroll reads the same record HR maintains, so the monthly export-edit-import ritual disappears. Each run is validated and two people must sign off before anything pays out.
03
Expiry dates start warning you.
Visas, right to work and certifications become tracked items with a warning well before the date, and a daily check ranks every record that is about to lapse.
The modules that fit
Take what fits, leave the rest.
HarmoniHRM is modular. These are the pieces that earn their keep in this world, each reading and writing the same connected record.
Employee Management→
The record that replaces the master sheet: one profile per person, documents in a vault, history kept.
Leave management→
Ledgered balances and clash-aware approvals instead of a formula-driven tracker.
Reports→
The pivot tables, rebuilt: filtered, exportable, permission scoped and audit logged.
Organo→
The org chart drawn from the data itself, updating the moment something changes.
Payroll→
Runs that read the record directly, killing the monthly export-and-edit ritual.
Company Calendar→
Leave, holidays and pay days visible on one permission-aware calendar instead of a tab.
A working day, connected
How the day actually runs.
Follow one realistic cycle through HarmoniHRM, step by step, from the first event of the day to the numbers that close it.
01
Import the sheet once
The master spreadsheet becomes employee records in one import, and the org chart builds itself from the data on day one.
02
People correct their own rows
The self service portal lets everyone update their own details, bank information and emergency contacts, and a daily data quality check ranks whatever is still wrong.
03
Leave moves onto the ledger
Policies are set once, balances compute themselves, and every request, approval and adjustment is a ledger entry rather than a cell edit.
04
Managers approve with context
A request shows who else on the team is already away, so approvals stop being a guess about a spreadsheet nobody checked.
05
Reports replace pivots
The month-end questions become saved reports with filters and CSV export, each carrying a line naming exactly how its numbers were derived.
06
The spreadsheet is archived
The file that ran the company gets a dignified retirement: kept for history, opened never.
Who lives this
The people inside this playbook.
Leave management
People correct their own rows
The self service portal lets everyone update their own details, bank information and emergency contacts, and a daily data quality check ranks whatever is still wrong.
Reports
Leave moves onto the ledger
Policies are set once, balances compute themselves, and every request, approval and adjustment is a ledger entry rather than a cell edit.
Organo
Managers approve with context
A request shows who else on the team is already away, so approvals stop being a guess about a spreadsheet nobody checked.
Keep reading
Related playbooks in this family.
Asked before buying
The questions that come up every time.
How hard is it to move off the spreadsheet?
The core move is one import: your people data becomes records, and the org chart builds from it automatically with no manual chart edits. From there, self service and daily data quality checks clean up what the spreadsheet had quietly got wrong.
We are a small team. Is this overkill?
HarmoniHRM is modular and priced per person per module, so a small team starts with Employee Management and adds nothing else until it needs to. Organo is included with any module. The pricing page shows exactly how it scales.
Can we still get data out into Excel?
Yes. Reports export to CSV throughout, with filters on departments, countries, statuses and dates, so anything you used to build as a pivot table you can still open in a spreadsheet, now from numbers that cite their basis.
Who can see salaries once it is all in one system?
Access is role-aware everywhere, so people only see what their permissions allow, and money-bearing reports sit behind an additional email one-time-code reveal. That is the opposite of the spreadsheet, where the salary column was one careless share away from everyone.
Run it on your own organisation.
Modular pricing, no long contracts. Start with the modules this world actually needs and add the rest when you are ready.