Try the hosted plan free for the first month. Book before 31 December 2026 and get 10% off. Start free trial

All articles

How to move HR from spreadsheets to software in a week

A day-by-day plan for a small team: what to move first, what to leave behind, and how to keep salaries on time while you switch.

· Thitainfo

When the spreadsheet stops working

A spreadsheet is fine for five people. The trouble starts when several people edit it, when leave is agreed in chat and never written down, and when making salary slips takes a full day each month.

If any of these sound familiar, it is time to move:

  • Two versions of the employee list exist and nobody is sure which is right.
  • Leave balances are argued about because the record is in someone's messages.
  • Salary details sit in a file that more people can open than should.
  • The person who understands the formulas is the only one who can run payroll.

Day 1: employee records

Start with the employee list, because everything else depends on it. Clean the spreadsheet first: one row per person, one column per detail, and the same spelling for each department.

Then import it. In HRMS you upload the list as a CSV file and each row becomes an employee profile. Add salary and bank details now if you plan to run payroll in the software.

Day 2: your rules

Set working days, office hours, the grace period for late arrival, and this year's holidays. These decide how attendance, leave and paid days are counted, so set them before you record anything.

Days 3 and 4: attendance and leave

Begin recording attendance in the software from a fixed date, ideally the first of a month. Do not try to move years of history; the current month is enough, and you can import it from a CSV file.

Tell the team that leave is now applied for in the software, and that a request made anywhere else does not count. This single rule ends most leave disputes.

Day 5: a trial payroll run

Run payroll in the software for the month you just paid from the spreadsheet, and compare the two. Differences usually come from a deduction rule that was applied by hand. Fix the rule in Settings and run it again until the figures match.

Keep paying from the spreadsheet for this one month. Switch fully the month after, once the trial run matches.

Days 6 and 7: give people access

Invite managers and HR first, each with a role that shows only what they need. Then give employees their own space, where they check in, apply for leave and download salary slips.

Keep the old spreadsheet, read-only, for a few months. You will rarely open it.

Start a free trial
Chat on WhatsApp