Tabellab
HR & People Ops Beginner

Excel for Payroll Administrators: Hours, Gross-to-Net, Registers & Checks

20 hands-on labs for payroll administrators: timesheet hours, overtime and night premiums, salaried and hourly pay, pre-tax pension, rate-table withholding, gross-to-net, the payroll register, employer cost, year-to-date totals, starters and leavers, variance checks and a payroll dashboard, then holiday accrual and liability, unpaid leave and sick pay, contribution ceilings, back pay and pro-rata bonuses, a payroll calendar, timesheet exception checks, a bank file reconciliation and a year-end payroll dashboard.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course follows the payroll of Larkfield Bakeries, a fictional bakery chain, through 20 hands-on spreadsheet labs. You turn clock times into payable hours, add overtime and night premiums, pay salaried and hourly staff with one formula, take pension before tax, look up withholding rates, build gross-to-net, check the payroll register, add employer cost, total the year to date, pay starters and leavers pro rata, compare pay runs and summarise the month. Then you go further: holiday accrual and liability, unpaid leave and sick pay, contribution ceilings, back pay and pro-rata bonuses, a payroll calendar with holidays, timesheet exception checks, a bank file reconciliation and a year-end dashboard. Every cell is checked instantly. All rates are example values.

Lessons

  1. Timesheet to Payable Hours: Clock Times, Breaks and RoundingLabFree
  2. Overtime and Night-Shift PremiumsLab Locked
  3. Salaried vs Hourly Staff: One Gross-Pay Formula for BothLab Locked
  4. Pre-Tax Deductions: Pension Contributions and Taxable PayLab Locked
  5. Withholding from a Rate Table: Approximate-Match LookupsLab Locked
  6. Gross-to-Net per Employee: From Gross Pay to the Amount Paid OutLab Locked
  7. The Payroll Register: Totals, Cross-Foot Check and Department TotalsLab Locked
  8. Employer Cost on Top of Gross PayLab Locked
  9. Year-to-Date Totals Across MonthsLab Locked
  10. New Starters and Leavers: Pro-Rata Pay by Working DaysLab Locked
  11. Payroll Checks: Variance vs Last Period and FlagsLab Locked
  12. Payroll Summary Dashboard: Department Costs and a ChartLab Locked
  13. Holiday Accrual and Balances: Months Employed, Days Accrued, a Carry-Over Cap and the Holiday LiabilityLab Locked
  14. Unpaid Leave and Sick Pay: Daily Rate, Deductions, the Sick-Pay Reduction and the Adjusted GrossLab Locked
  15. Contribution Ceilings: Year-to-Date Pay, the Part Still Subject to Contributions and the Month the Cap Is ReachedLab Locked
  16. Back Pay and Pro-Rata Bonus: New Rates Rounded to the Cent, Back Pay for Past Hours and a Bonus by Months EmployedLab Locked
  17. The Payroll Calendar: Pay Dates on the Last Working Day, Timesheet Cut-Offs, Bank File Deadlines and HolidaysLab Locked
  18. Timesheet Exceptions: Missing Clock-Outs, Over-Long Shifts and Short Breaks Before the Pay RunLab Locked
  19. Net Pay to Bank File: Matching Payments by Employee ID, Differences, Duplicates and Unknown PayeesLab Locked
  20. Final Project: Year-End Payroll Dashboard – Total Cost per Month, Cost per Head, Overtime Share, Big Changes and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy