Payroll pal

Keep accurate payroll records with this simple Excel template.

Even if you use an accountant or payroll company to handle your business' payroll needs, it's still important--and often legally required--that you keep payroll-related records yourself. Employee Payroll Template is a template for Excel that can help you keep track of this important information. It's not a payroll calculator, so if you're expecting something that will help you do payroll yourself, you'll need to look elsewhere. But if you just need a tidy way to keep employee payroll records, Employee Payroll Template fits the bill.

The template is plain and attractive, with a blue header across the top that contains the column names. For each employee, you can enter the employee ID, name, Social Security number, address, gender, occupation, and hire date. There are also columns for annual salary, hourly and overtime rates, overtime exemption, the number of federal allowances, the percentage contributed to a 401(k), insurance deductions, and any other deductions. A second page in the template lets you track payroll information for each pay period; for each employee, you can enter the number of hours worked, as well as vacation, holiday, sick, personal, and overtime hours. There are columns to record the gross pay and the amounts of various taxes and other withholdings, as well as the net pay. An online Help file explains how to use the template, although it's pretty self-explanatory.

Overall, Employee Payroll Template isn't something that most Excel users couldn't create for themselves, but since it's free, why not save yourself the trouble and check it out? It could be exactly what you're looking for to keep accurate payroll records.

CNET Top 5
Companies Apple could buy with their billions
Apple's sitting on a massive pile of cash. Here are five interesting ways they could spend it.
Play Video
 

Member Comments