The CanadaGAP Audit Checklist is the tool used by auditors to assess that participants are meeting program requirements. The Audit Checklist is an Excel document that has been programmed with a number of automatic features (e.g., formatting is adjusted as the checklist is completed, automatic scoring of sections/checklist, questions that are not applicable based on the certification option are removed, etc.). It also has a ‘spell check’ feature that allows auditors to check the spelling of their comments in the checklist (even though it is a protected Excel document).
In order to use the Audit Checklist properly the following steps should be taken:
- Download the Audit Checklist:
- First download the checklist to your computer. Either right click on the file, click ‘Save As’, and choose a destination on your computer, or download a copy directly to your own computer (e.g., on your desktop, C drive, etc.)
- It is important to save the file on your local drive rather than opening it directly from an email or a web browser. This ensures that all features, including macros, function correctly. If you attempt to use the checklist without saving it on your computer, some functionalities may not be available.
- Enable Macros:
- ‘Macros’ should be enabled.
- Macros are essential for the automation features in the checklist (e.g., automatic scoring, formatting adjustments, and other programmed functionalities). Without macros, these features will not work, and the checklist will not function as intended. This could result in incomplete or incorrect scoring, etc.
- How to Enable Macros:
- When you open the file, you will likely see a security warning or a yellow bar at the top of Excel asking if you want to enable macros. This depends on the device/operating system, but you should click ‘Enable Content’ or ‘Enable Macros’.
- If you do not see this option, you may need to adjust your Excel security settings. Go to ‘File’ > ‘Options’ > ‘Trust Center’ > ‘Trust Center Settings’ > ‘Macro Settings’ and select ‘Enable all macros’.
- ‘Macros’ should be enabled.