Pre-Tax Deductions: Pension Contributions and Taxable Pay
Lessons in this course
- 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