Sweldo Salary System (Windows and MacOS)

We use the ZKTeco biometric scanner to capture attendance. This app allows the upload of time sheet data and has a dashboard to track employee performance. This offers similar features to the previous version but with a more modern look and feel and is now offline-based. It no longer has online capabilities, but it is several times faster and more stable.

View on Github

CSV
Nextron
React
Electron

ZKTeco Biometric Scanner

Not all attendance data from the biometric scanner is reliable. It's possible that some data is missing or incorrect or the employee forgot to clock in or out.

This scanner exports the data in an xls file. I have a script that parses everything and organizes all the data into CSV files. My app aims to make it easier to visualize the data and make it more user-friendly. Any post-processing of the data is done in the app.

"Time Sheet shows the time in and out of each employee. With this, their summary can be easily calculated. As you can see, the data is editable. Absences do not include weekends and holidays."

The problem

I am not aware of any post-processing system that can handle the data from the biometric scanner apart from the xls file. It is not user-friendly and it is not easy to understand. Hence, I decided to create my own app to make it easier to understand and modify any data that might need to be changed.

The xls file alone do not have computations for the pay of each employee. It only has the data that is needed to be computed. It also does not account for the holiday of that day, leave of absence of the employee and other calculations needed to calculate the employee's pay of that particular day or cash advances.

"This is the settings page. It allows the user to configure the app to their liking. It also allows the user to make schedules for each employee type like in the image above. It also allows the HR to modify deductions for things like late, undertime, and overtime."

"This is the summary payroll page. It shows the total pay of each employee. It also shows the total deductions and the net pay of each employee."