Question about Computers & Internet
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.
Posted on Mar 24, 2011
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Sep 28, 2014 | Office Equipment & Supplies
Aug 19, 2013 | Finance
Mar 26, 2013 | Office Equipment & Supplies
Jun 16, 2010 | Vivendi Excel@ Mathematics Study Skills...
Aug 04, 2009 | Computers & Internet
May 03, 2009 | Microsoft Visual Basic Enterprise Edition...
Feb 23, 2009 | Microsoft Office 2003 Basic Edition...
Dec 25, 2008 | Computers & Internet
Nov 16, 2008 | Computers & Internet
137 people viewed this question
Usually answered in minutes!