The Payroll Register is a monthly pay sheet for small businesses. The Payroll tab takes each employee's department, hourly rate, regular and overtime hours and tax rate. Gross pay, tax, pension and net pay are worked out from those figures, with overtime paid at 1.5 times the hourly rate. The Dashboard totals the run and breaks down gross and net pay by department.

The file comes with sample data for ten employees, so you can see how the sums fit together. Make a copy, replace the sample rows with your own staff, and the pay figures, dashboard totals and charts update on their own.