ExcelWhiz

EXCELWHIZ

All Calculators

Wages Calculator

Gross pay with overtime and weekend rates, plus a take-home estimate

Results are estimates for guidance only. This tool does not provide financial advice.

Hours & Rates

$

Multipliers default to common award levels (1.5x first overtime band, 2x after the band, 1.5x Saturday, 2x Sunday, 2.5x public holiday). Overtime is paid in bands, with the first band at the lower rate. Casual loading is added to each multiplier, which matches most awards, so a retail casual Sunday on 1.5x gives 175%. Where an award applies the penalty percentage to the casual hourly rate instead, as the Nurses Award does, leave casual loading off and enter the combined percentage. Check the specific award or agreement for your industry.

Enter hours and rates above

to see the gross pay breakdown