HR payslip-sharing Automation

 One of the startups with which I worked was 200 employees strong at the time I joined. It was 4 years old at the time. I was working as an operations manager and chief of staff, so I was given the task of streamlining processes in different departments.

One of the departments that I worked with was HR. The company didn’t have any HR software. All the finance-related work used to be handled by the finance head through Excel files. The HR executive used to share payslips with the employees by manually editing a Word file template, mostly with those who requested it. The result was that a lot of the time of the HR personnel was going into creating those payslips, and the employees were also suffering by not getting them on time.

When I was given this task to streamline the processes, I started using one of my favorite tools, SpreadSheets (aka Google Sheets). We wrote a script and pasted the monthly payroll data (which was already being managed by the Finance Head) into a tab in the sheet. The template remained as it was, except for a few variable names. Just by putting 4 hours into creating the process and testing it, HR could send all the payslips to all the employees by just clicking on a button.

Afterward, the HR executive pasted data into the sheet every month and ran the script. All the employees were getting payslips by the 10th of every month.

This process not only saved the time of the HR executive, but it also reduced her frustration with the repetitive task and employees’ frustration with not getting their documents on time.

One simple process and so much time was saved. Do you also do repetitive tasks manually?

Promento Solutions LLP