Refrigerant Usage and Recovery Register

An editable Excel refrigerant register and log book for Queensland air conditioning, refrigeration and automotive businesses. Record each job on one row: the equipment, the refrigerant and its charge, the technician with their licence class and licence number, the kilograms added and recovered, the recovery cylinder weight before and after, the leak check and where the recovered refrigerant went. A cylinder list holds each cylinder’s tare weight, maximum filled weight and test expiry date, and a technician sheet holds licence classes and expiry dates. Leaks not yet repaired turn red and are counted on the Start Here sheet.

What Is Included In Our Refrigerant Usage and Recovery Register?

• A Start Here sheet: type your details once and they appear on every sheet and printed page
• A Usage and Recovery sheet with one row for each job: date, job or site, equipment type, make and model, serial number, refrigerant and system charge
• Technician, licence class from the five refrigerant handling licence types (RAC01, AAC02, RRR11, TRT07 and TL000) and licence number on every job
• Kilograms added and the supply cylinder ID
• Kilograms recovered, recovery cylinder ID, cylinder weight before and after, with the weight gained and the difference to the kilograms recovered worked out for you
• Leak check method and result, with leaks not yet repaired shown in red and counted, and the date the leak was repaired
• Where the recovered refrigerant went and the date it was handed over
• A Cylinders sheet with cylinder ID, supply or recovery use, refrigerant, owner, tare weight, maximum filled weight, date tested and test expiry date that turns amber and then red
• A Technicians sheet with licence class, licence number and licence expiry that turns amber and then red, and the supervisor for a trainee licence
• A plain-English summary of the refrigerant handling licence rule, the electrical work licence rule and the rule for storing gas cylinders

Legislation and Codes of Practice Referenced

• Ozone Protection and Synthetic Greenhouse Gas Management Regulations 1995 (Cth): reg 110 (RAC equipment), reg 111 (work in relation to RAC equipment needs a refrigerant handling licence)
• Electrical Safety Act 2002 (Qld): s 18 (electrical work), s 55 (electrical work licence)
• Work Health and Safety Regulation 2011 (Qld): s 53 (gas cylinders kept at the lowest practicable quantity)
• Work Health and Safety Act 2011 (Qld): ss 37 and 38 (dangerous incidents and notification)

What You Get

• An editable Microsoft Excel workbook with no macros
• Drop-down lists, frozen headings, automatic weight differences and colour highlighting
• Room for 200 jobs, 100 cylinders and 50 technicians, with more rows when you need them
• Print-ready pages with your business and site details repeated on every printed page
• Drop-down options you can change on the Lists sheet to suit your equipment

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.