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.
- 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
- Timesheet to Payable Hours: Clock Times, Breaks and RoundingFree
- Overtime and Night-Shift Premiums Locked
- Salaried vs Hourly Staff: One Gross-Pay Formula for Both Locked
- Pre-Tax Deductions: Pension Contributions and Taxable Pay Locked
- Withholding from a Rate Table: Approximate-Match Lookups Locked
- Gross-to-Net per Employee: From Gross Pay to the Amount Paid Out Locked
- The Payroll Register: Totals, Cross-Foot Check and Department Totals Locked
- Employer Cost on Top of Gross Pay Locked
- Year-to-Date Totals Across Months Locked
- New Starters and Leavers: Pro-Rata Pay by Working Days Locked
- Payroll Checks: Variance vs Last Period and Flags Locked
- Payroll Summary Dashboard: Department Costs and a Chart Locked
- Holiday Accrual and Balances: Months Employed, Days Accrued, a Carry-Over Cap and the Holiday Liability Locked
- Unpaid Leave and Sick Pay: Daily Rate, Deductions, the Sick-Pay Reduction and the Adjusted Gross Locked
- Contribution Ceilings: Year-to-Date Pay, the Part Still Subject to Contributions and the Month the Cap Is Reached Locked
- Back Pay and Pro-Rata Bonus: New Rates Rounded to the Cent, Back Pay for Past Hours and a Bonus by Months Employed Locked
- The Payroll Calendar: Pay Dates on the Last Working Day, Timesheet Cut-Offs, Bank File Deadlines and Holidays Locked
- Timesheet Exceptions: Missing Clock-Outs, Over-Long Shifts and Short Breaks Before the Pay Run Locked
- Net Pay to Bank File: Matching Payments by Employee ID, Differences, Duplicates and Unknown Payees Locked
- Final Project: Year-End Payroll Dashboard – Total Cost per Month, Cost per Head, Overtime Share, Big Changes and a Chart Locked
Learner reviews
Be the first to review this course.