This was an internal project created to facilitate day to day work of persons who work Tax or HR Departments of a company.
The Payroll Applications is a Windows Form Application that takes as input a file excel with Time sheets of all employees for a month that you want to process (using shifts or not) and as a result you can generate three documents:
1-Payroll document (excel file), is where all the calculations of working hours, overtimes, annual leaves etc.
2- List Pay document (excel file) where you have the final salary calculations after adding bonus.
3- Pay Slip document (pdf file ) generated for every employee where all the details of a single employee which will be sent by email to the interested.
There is a possibility to add,edit,delete Public National Holiday so it can be flexible.
The applications generates monthly templates for the Payroll and List Pay Documents so its easier to maintain a single format.
To the applications was added a feature that sends multiple different emails with different attachments to different with a single click, this to make it easier to send all the Pay Slips in one moment. (works only with Outlook)
The Payroll App was developed in Visual Studio 2017 in C# using Windows Forms