Audit Program 4.0 - User Manual
7. Revising and Finalizing Materiality
7.3 Updating the "Main" Worksheet
A. Locate the "Main" Worksheet:
Navigate to the following pathway to locate the “Main” worksheet that was previously completed during the “Audit Planning” Stage.
C Drive > AP4.0 > Generated Files > _Bulk_Generation > 2.3 Main_Controller.xlsm
B. Open the Main Controller File and Add "Yes" in Column L or Column M
Open the 2.3 Main Controller.xlsm Excel File, and go to the “Main” worksheet. Then identify the row with the audit engagement that you are working on, and scroll to Column L or M.
The user will see that the answers in Columns F to I have been automatically updated from “Yes” to “Completed”. This indicates that the audit planning files have already been previously generated, and now the user should select “Yes” in Columns L or M for revising materiality, or finalizing materiality, respectively.
C. Update Any Other Changes, then Save and Close the Main Controller File
If there are any other changes to the options in this worksheet, such as new Accounting Estimates, Report and Archive Dates to be updated, or change in the current year’s audit opinion, etc. The user may make those changes now.
After the user has made all necessary changes, save the changes and close the Workbook.