Lab $5-4$ Identify Audit Requirements $-$ Slainte

Attached are the directions for highlighting the items. I do not understand how to break them up in an excel sheet. How many tables and what attributes go to where. Microsoft $|$ Power BI Desktop

$1.$ Open your Slainte Working Papers folder on OneDrive or the Lab $5-4$ Slainte Audit Files.zip file.

$2.$ Evaluate your audit action sheets:

a$.$ Look inside the Master File for the document titled Audit Action Sheets and open it to edit it$.$

b$.$ Use the Yellow highlighter to identify any master or transaction tables, such as "Vendors" or "Purchase Orders."

c$.$ Use the Green highlighter to identify any fields or attributes, such as "Name" or "Date."

d$.$ Use the Blue highlighter to identify any specific values or rules, such as "TRUE," "January $1$st$,"$ "Greater than $..$

$3.$ Summarize your highlighted data:

a$.$ Create a new Excel workbook in your Master File to summarize your highlighted data elements from the three audit action sheets. Use the following headers:

b$.$ Take a screenshot $($label it $5-4$MA$)$ of your completed spreadsheet.

$4.$ Now that you have analyzed the action sheets, look through the systems documentation to see where those elements exist:

a$.$ In the Master File, open the UML System Diagram and Data Dictionary files.

b$.$ Using the data elements you identified in your Audit Automation Summary file, locate the actual names of tables and attributes and acceptable data values. Add them in three new columns in your summary:

$5.$ Take a screenshot $($label it $5-4$MB$)$ of your completed spreadsheet.

$6.$ After you answer the lab questions, save your file as Audit Automation Summary.xlsx and continue to the next part. Durit $\backslash (\backslash$operatorname$\{$Artinn$\}\backslash )$ Shopt $1.$ Sucnirinac Sunnlipre

Policy:

$-$ Employees should not also be related to suppliers, except where approved by the controller.

$-$ Suppliers should have valid data $($e$.$g$.$ valid zip codes, phone numbers$)$

$-$ Payments should only be made to approved suppliers with supporting documentation.

Task:

$1.$ Load complete suppliers and customer master data in IDEA or Excel.

$2.$ Join suppliers and customers with a fuzzy match on address and zip code. Set fuzzy similarity to $50\backslash \%.$

$3.$ Produce a list of suppliers with fuzzy address and validate with controller.

Additional steps

$4.$ Identify any suppliers with incomplete or invalid data $($e$.$g$.$ zip code, phone number$)$

$5.$ Identify any transactions that involve suspicious suppliers.

$6.$ Review suspicious suppliers with management.

Notes:

$-$ Assign a rating for this task:

$-\backslash (4=\backslash )$ no exceptions$/$issues

$-3=$ few exceptions$/$issues$,$ transactions are valid

$-2=$ many exceptions$/$issues$,$ transactions are valid

$-1=$ few exceptions$/$issues$,$ transactions are invalid

$-\backslash (0=\backslash )$ many exceptions$/$issues$,$ transactions are invalid

$-$ Exceptions should be supported by documentation provided by the controller.

$-$ Collect evidence in working papers along with response from management. Attributes

Values$/$Rules

Step$($s$)$

no missing fields

Only match approved suppliers

$2,6$ name, address, zip code, phone numbers

Only match to