Reading Your Payslip: Gross-to-Net, Withholding & Year-End Refunds

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Rebuild October's gross pay for five employees: salary or hours × rate, overtime at 1.5×, allowances, the total payroll and the overtime share.
• Order Jonas's payslip correctly: pension and health premium before tax, union dues and parking after tax, then show why raising his pension contribution costs him less than it saves.
• Track Ines's year-to-date pay, find the month in which she hits the annual earnings cap, charge only the part below the cap and check the year with one formula.
• Turn weekly, biweekly and monthly pay into annual figures, run them through the bracket table and bring the annual tax back to a withholding amount per pay period.
• Withhold tax on Jonas's 6,000 bonus with two methods, calculate the extra tax the bonus really causes over the year and show which method over- or under-withholds.
• Build YTD totals for Jonas's pay and withholding, project his annual pay after a July raise and chart how the withholding builds up over the year.
• Add Jonas's wages and his untaxed side income, calculate his real annual tax after a credit and compare it with twelve months of withholding to find his refund or balance due.
• Project Jonas's year after July, including a side income without withholding, find the shortfall and spread it over the remaining months as extra withholding, rounded up.