Can I use Excel to import into the Payroll instead of editing every person?

In short, Yes you can; but be really careful.

You can do it if:

  • You have a really large company that makes individual editing impossible, eg 300 people size, and everyone’s salary always change in different months.

  • You need fingerprint integration from other vendors. (eg FingerTec has implemented Exporting to Kakitangan.com in their TCMS v3 version)

However, it is such a feature that can be easily went wrong.

As you edit the Excel and import into the system, it is very common that some mistakes could happen in editing the amount in Excel, and gets carried forward into the Kakitangan.com payroll – and it is almost not traceable, because the source: your Excel already have the number wrong. Another possible situation is that the amount is calculated wrongly with some parameter available in the system, and it is overlooked.

So, even if you use this feature, you also need to double check everyone’s Payroll amount – please do all necessary checking and don’t hold us liable in the data finalized by your clicking on "confirm" button.

Now, if you still want to use the Excel to import the payroll data every month, here’s the magic door to the feature: https://app.kakitangan.com/payroll/import_monthly

You can

  • download an Excel template, and
  • get the Excel filled up and upload back to the system.

The system tries to match the person with the unique identifier, i.e. email address, and pump in the data you filled up in the Excel into the Payroll system.

Hope that helps!

how to setup Kakitangan.com so you can automate the max for your payroll and people operation http://blog.kakitangan.com/onboarding-your-company-to-kakitangan-com-for-the-first-time/