Redundancy Calculator Template

Business Details Business Name: [BUSINESS NAME] ABN: [ABN NUMBER] Date of Calculation: [DD/MM/YYYY]

Employee Details Employee Name: [EMPLOYEE NAME] Job Title: [JOB TITLE] Date of Commencement: [DD/MM/YYYY] Date of Termination: [DD/MM/YYYY] Award/Agreement: [AWARD NAME or NONE]

Step 1: Check Small Business Exemption Total number of employees in the business (including casuals): [NUMBER] Is the business a Small Business (<15 employees)? [YES/NO] Note: If YES, NES Redundancy Pay may be $0 unless an Award applies.

Step 2: Calculate Continuous Service Years of continuous service: [YEARS] Note: Only count full years of service for the NES base calculation. Pro-rata may apply for Awards.

Step 3: Determine Base Rate of Pay Ordinary Weekly Hours: [HOURS] Hourly Rate: $[RATE] Weekly Base Pay: [TOTAL WEEKLY PAY] Include shift loadings and allowances. Exclude overtime.

Step 4: Calculate NES Redundancy Pay

Years of Service	Entitlement (Weeks)	Calculation	Amount ($)
1 year but less than 2 years	4 weeks	[WEEKLY PAY] x 4	$[AMOUNT]
2 years but less than 3 years	6 weeks	[WEEKLY PAY] x 6	$[AMOUNT]
3 years but less than 4 years	7 weeks	[WEEKLY PAY] x 7	$[AMOUNT]
4 years but less than 5 years	8 weeks	[WEEKLY PAY] x 8	$[AMOUNT]
5 years but less than 6 years	10 weeks	[WEEKLY PAY] x 10	$[AMOUNT]
6 years but less than 7 years	11 weeks	[WEEKLY PAY] x 11	$[AMOUNT]
7 years but less than 8 years	13 weeks	[WEEKLY PAY] x 13	$[AMOUNT]
8 years but less than 9 years	14 weeks	[WEEKLY PAY] x 14	$[AMOUNT]
9 years but less than 10 years	16 weeks	[WEEKLY PAY] x 16	$[AMOUNT]
10 years or more	12 weeks	[WEEKLY PAY] x 12	$[AMOUNT]

Total NES Redundancy Pay: $[TOTAL REDUNDANCY]

Step 5: Payment in Lieu of Notice Years of Service: [YEARS] Required Notice Period (Weeks): [WEEKS] Employee working notice period? [YES/NO] If NO, Payment in Lieu of Notice: $[NOTICE AMOUNT]

Step 6: Leave Payouts Accrued Annual Leave: $[AMOUNT] Annual Leave Loading: $[AMOUNT] Accrued Long Service Leave: $[AMOUNT]

Step 7: Other Entitlements Outstanding Wages/RDOs: $[AMOUNT] Bonus/Commission (Pro-rata if applicable): $[AMOUNT] Superannuation on Redundancy/Leave: [CHECK ATO RULES - USUALLY NOT ON REDUNDANCY BUT YES ON LEAVE]

Step 8: Total Payable

1. NES Redundancy Pay: $[TOTAL REDUNDANCY]
2. Payment in Lieu of Notice: $[NOTICE AMOUNT]
3. Annual Leave & Loading: $[LEAVE TOTAL]
4. Long Service Leave: $[LSL TOTAL]
5. Other Payments: $[OTHER TOTAL]

GROSS TOTAL PAYABLE: $[GROSS TOTAL]

Tax Estimation (See ATO guidelines) Tax Free Component (Redundancy): $[AMOUNT] Taxable Component: $[AMOUNT] Estimated Tax Withheld: $[TAX]

NET TOTAL PAYABLE: $[NET TOTAL]