WHS Training Plan and Training Needs Analysis

A WHS training plan template in Excel for Queensland businesses, with a training needs analysis built in. Set the training each role needs and say whether it is required by law, a code of practice or your own business rule. Record each worker’s training with the date completed and the refresh interval or expiry date, and Next Due, Days to Next Due and the Status are worked out for you. The Required Training sheet counts, for each role and item, how many workers are current, due soon, overdue or missing, and the Workers sheet shows the same for each person. High risk work licence classes, the general construction induction two-year rule, an induction record, a forward training plan with costs and a triggers list for extra or refresher training are included. Use it alongside the Employee Training Register, which holds the record of training done.

What Is Included In Our WHS Training Plan and Training Needs Analysis?

• A Start Here sheet: type your details once and they appear on every sheet and printed page
• Required Training by role, with the category and whether it is required by Law, Code of practice or Business rule
• Workers sheet with required, current, due soon, overdue and missing items counted for each worker
• Training Records with date completed, refresh interval or expiry date, next due date, days to next due and a status
• High risk work licence class list from Schedule 3 and a date for sighting written evidence of the licence
• Gaps by role and item, with the percentage of workers in date
• Training Plan with reason, provider type, planned date, cost and an overdue flag
• Induction sheet with six steps and a Complete or Incomplete result, plus repeat induction after a long absence
• Needs Analysis sheet: what the work requires, the standard, how assessed, current competence, gap and action
• A Triggers sheet and a Summary sheet with counts, planned cost and the percentage of required training in date

Legislation and Codes of Practice Referenced

• Work Health and Safety Act 2011 (Qld): ss 19, 47, 49
• Work Health and Safety Regulation 2011 (Qld): ss 38, 39, 81, 85, 316, 317; Schedule 3
• First Aid in the Workplace Code of Practice 2021

What You Get

• An editable Microsoft Excel workbook with no macros
• Drop-down lists, frozen headings, working formulas and colour highlighting
• Room for 150 workers and 500 training records, with more rows when you need them
• Print-ready pages with your business details repeated on every printed page
• Drop-down options you can change on the Lists sheet to suit your business

Review it and adjust it to suit your business, your sites and the way your team works, and talk it through with your workers. If you have any trouble downloading this template, you can contact us at any time. Please make sure you read our Disclaimer before downloading.