Payslips cannot be generated using spreadsheets alone. It takes a macro to get the job done, after which the individual payslips have to be converted into PDFs to be published. Simple, you say? Well, here’s a closer look at manual payslip generation that’ll do away with that illusion. If you’re using a macro for payslip generation, you will have to ensure that the values on the payslips are identical to those on the salary register. Such cross-verification can take up to 3 days for around 100 employees. In terms of time, that’s a heavy price to pay each month.
Employee-wise data extraction and conversion
When using a macro for the purpose of payslip generation, the data for all the payslips to be generated gets collated on a single spreadsheet. This data has to then be extracted employee-wise and then each payslip converted into a PDF separately. This causes the time and effort required for the task to rise exponentially compared to software.