I created a small database program to create monthly salaries and print salary slips easily.
This way you can keep monthly salary records given pay sheets calculate Overtime only filling main basic data.
no need to install special software, no need special skill.
Step 1: Create Main Basic Table
Open Ms Access.
go to main menu & create table as you want
Add following details or your details what you pay to your staff monthly.
Step 2: Create Query for Basic main table
Create a Query for basic main data table. as below
Step 3: Create Pay sheet details
Create a report base on monthly transaction for pay sheet.
insert formula for auto calculate OT / No pay/ and net salary
follow the image below
Step 4: Create a Salary Slip
Create a salary Slip how you want to give to your staff as below.
each and every details what you want to show in your staff salary slip..
Step 5: Create a form to enter data
Now create a form to enter data to your program.
base on your table crate a form to enter data very easily.
Step 6: Enter staff details
Now you are already finish your program.
enter staff details .
you can download my file how i crate here with this location and enjoy.
Download this Software free