What Are Some Tips on Making a Free Payroll Template?


Quick Answer

Vertex42.com provides free payroll templates. To record the daily hours that employees work, take note that the Daily Hours Worked column on the Payroll Register Worksheet is hidden by default. To change this, simply change the settings. To record overtime pay and reimbursements, make the Gross Pay column a formula.

Continue Reading
Related Videos

Full Answer

Three templates are available on Vertex42.com: the Employee Payroll Register, the Employee Payroll Information Worksheet and the Payroll Register Worksheet.

The Employee Payroll Register is a spreadsheet specifically designed for small businesses that want to utilize an online payroll service like Intuit.com or an accountant. This spreadsheet is quite basic, and so depending on the type of business and its policies, additional columns may be necessary.

The Employee Payroll Information worksheet is where information is recorded, such as ID, address, name, occupation, sex and salary basis. Additionally, other information such as federal allowances and information about contribution elections and current deduction is also recorded.

The Payroll Register Worksheet is a way to keep track of payment dates, the summary of the total hours worked, state and federal tax withholding, taxes and other deductions.

Depending on the way that records are kept, additional information may be added to the payroll register or removed.

Learn more about Business Resources

Related Questions