Tabellab

The Payroll Register: Totals, Cross-Foot Check and Department Totals

Lesson 7 of 20 Lab 🔒 Locked

Lessons in this course

  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