The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.
The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)
At the last row you can include a total for Gross salary paid, total Tax collected etc.
Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.
Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.
181 views
Usually answered in minutes!
Subject: OBSCENE SALARIES ....... A MUST READ
Think we are in the wrong business!!
THE WORK ETHIC WE INHERITED GROWING UP HAS FALLEN PREY TO THE 'WELFARE'
SYSTEM
The Cato Institute released an updated 2013 study (original study in 1955)
showing that welfare benefits pay more than a minimum wage job in 33 states
and the District of Columbia . Even worse, welfare pays more than $15 per
hour in 13 states. According to the study, welfare benefits have increased
faster than minimum wage. It's now more profitable to sit at home than it is
to earn an honest day's pay.
×