HRIS for Mid-Sized Companies: When a Spreadsheet Is No Longer Enough

By · 15 November 2026 · 4 min read

Illustration of a spreadsheet full of problem cells beside a tidy HRIS dashboard with employee data, a leave calendar and a chart

When you had 20 employees, one spreadsheet for attendance, leave and pay felt like enough. Everyone knew each other, and HR remembered who worked overtime when. Once headcount nears a hundred, with several work locations and more varied overtime rules, the same file starts causing problems.

This article helps you judge when a spreadsheet is no longer enough, what is at stake, and what to prepare before moving to an HRIS (Human Resource Information System).

Signs the spreadsheet is overwhelmed

There is no fixed point at which a company must switch. But if several of the following sound familiar, that is a fairly clear sign:

  • Compiling attendance and overtime takes days at the end of every month.
  • Several versions of the file are circulating, and it isn't clear which is the latest.
  • Employees often ask about their remaining leave, and the answer has to be looked up first.
  • Only one person understands the payroll calculation. If they are on leave, payroll is delayed.
  • Leave and overtime approvals happen in chat, then get copied into the file by hand.
  • Management asks a simple question, such as total overtime hours per department last month, and it takes two days to answer.

Overtime and pay: where mistakes cost the most

Overtime is a good example of why spreadsheets get riskier as headcount grows. Indonesia's Government Regulation No. 35 of 2021 sets out several things that must be calculated and recorded correctly, including:

  • Overtime of at most 4 hours a day and 18 hours a week, not counting overtime on weekly rest days or public holidays.
  • Overtime requires an instruction from the employer and the employee's consent, in writing or through digital media, and the employer must keep a list of overtime worked with each employee's name and the length of the overtime.
  • Overtime pay on working days: 1.5 times the hourly wage for the first hour and 2 times for each following hour, with the hourly wage calculated as 1/173 of the monthly wage.

There are more rules, such as overtime rates on holidays and exceptions for certain positions. The details are best confirmed with an employment law adviser or the latest regulations. The point is this: the more employees and working patterns you have, the more spreadsheet formulas can break without anyone noticing. A good system can warn when overtime limits are exceeded, and calculate pay from the same attendance data, not from figures typed in again.

Employee data is personal data

HR files hold more than names and job titles. They often include bank account numbers, salaries, sick notes, family and children's details, and even fingerprint data from attendance machines.

Indonesia's Personal Data Protection Law (Law No. 27 of 2022) classifies health data, biometric data, children's data and personal financial data as specific personal data. The law also requires data controllers to protect and ensure the security of the data they process, and to record all personal data processing activities.

How those obligations apply in your company is best discussed with a legal adviser. But in practical terms, a spreadsheet sent around by email or chat is hard to control: who has a copy, who changed what, and whether former HR staff still keep it. A system with role-based access and a change log makes these questions much easier to answer.

What you actually get from an HRIS

An HRIS brings HR data and processes into one place. Common modules:

  • Employee data: profile, position, department, employment status and documents.
  • Attendance: clock-in and clock-out times, with summaries per period.
  • Leave: requests, manager approval and an always up-to-date balance.
  • Overtime: requests and approvals linked directly to the payroll calculation.
  • Payroll and payslips: calculated from attendance and overtime data, with payslips each employee can view.
  • Reports for management.

The biggest benefit isn't the features but a single source of data. A manager approves overtime in the system, that figure is used for pay, and the employee sees the result on their payslip. No more figures retyped in three places.

What to prepare before switching

  1. Tidy up the employee master data. Names, employee numbers, positions, departments, start dates and pay components. Messy data stays messy in a new system.
  2. Write down the rules that have lived in people's heads. Leave entitlements, shift patterns, allowances and approval flows. Check them against your company regulations or collective labour agreement.
  3. Choose priority modules. Start with the process that takes the most time, usually attendance and overtime, then add the next modules.
  4. Run both side by side for one pay period. Calculate pay in the new system and the old way, and compare the results before fully switching over.
  5. Decide who can see what. Managers don't need to see the whole department's salaries, and not every HR staff member needs access to health data.

Off the shelf or built for you?

An off-the-shelf HRIS is usually quicker to start using, and suits you if your processes are similar to most companies'. If your approval flows, shift patterns or pay components are very particular, a custom-built system may fit better, but it needs a longer analysis phase. Whichever you choose, ask how data will be moved from the old spreadsheet, who keeps the rules up to date, and where employee data is stored.

The spreadsheet isn't the problem. The problem starts when one file has to carry the data, rules and approvals of hundreds of people at once.

We are preparing the Digimasi HRIS for companies in Indonesia. It isn't available yet, but you can register your interest through the contact form and tell us which process causes the most trouble today.