Cloud 9 - Continuing Case You have been asked to assist in the planning and development of audit data analytics as a substantive test for Cloud 9. Cloud 9 uses an evaluated receipt settlement system (see Chapter 12) that involves electronic invoice presentment and payment (EIPP) for 90% of its purchase transactions. Required: Plan a substantive test of purchase transactions using ADA as a substantive test. When planning the substantive test, identify the following: a. What is (are) the assertion(s) being tested? b. What information are you comparing electronically for each assertion? c. What electronic evidence would represent a misstatement for each assertion? We will complete this assignment in class on Tuesday and Thursday using the workpaper provided.PU 10 Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: Purpose To determine if: Enter purposes of the tests you plan to perform here. Source PBC databases from Cloud 9's accounting information system, retrieved and provided by client Database structures also PBC: Database Felle VendorID Data Type 6-digit number A unique identification number for each vendor Data Input Condo Baw Veodoran post nicode Teat C Vendor's maling ding ADD State associated with Vendor_ADD Vendor postcode Vendor STATE Vendor PC Cloud Card deady cloud Source PBC databases from Cloud 9's accounting information system, retrieved and provided by client. Database structures also PBC: he Vendor ID A entification DataType 6-digit number Data wpat By Cloudy e r for each vendor Vendor Mar postcode Veader's mailing address ing ty, C V . ADD SVAD ded de Text Vendor ADD Vecm STATUE Ved PC Vende COUN Vende tank Art Number Vendor Credit C o Routing d with or ADD brand account number for vendor Ceado Couto Numere data Amount of credit extended by the end Coo Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: IP NO Cado Cloud Vendor A unique identification number for each vendor A unique transaction number that follows each transaction from order (Hrves as purchase order number), through s tresse berrechingering sumber invoicing serves a ASN be recording of the libility serves as voor b ereid payment number identified on payment Onder date Shipping address for excluding cry, state, post (zip) code PO SHIP_ADD Post (p) code for PO SHIP ADD SODD/YYY Cado PO DATE PO SHIP ADD POS POLIC do Test PO_COUNTRY PO_PROD_CODE Country associated with PO SHIP ADD Product number Clodio PO PROD QUANT PO_PROD_PRICE POLACCT TOTAL ORD PRICE AC DATE PROD NO eventory quantity ordered by Price per unit for each item ordered by Cloud9 Account charged based on ordering department Total price for the individual purchase order AS date sique inventory number Cloud Cado deado Cloud BOLDOG MM/DD/YYY U Vendor v Vendor Text PROD QUANT PROD_PRICE ASN_TOTAL ASN TERMS BILL. ADD BILLOS BILL PC BILL.COUNTRY BL DATE SHIP ADD SHIPS SHIPPC SHIP COUNTRY entory quantity ordered by Cloud9 Price for each item ordered by Cloud9 Sum total of the vendor's chance shipping notice discount allowed if pall within XX days from receiving date Billing address excluding city, state, post (zip) code City and state City and parated by a comma) Associated with BILL ADD Post (tip) code associated with BILLADD Country associated with BILL. ADD Bill of lading date Salons d e edadies cityInte, pout (sip and the parte accomm o dated SADA Text Vendor Vendor Veador Veder Vendor Text MM/DD/YYYY Test mutta Verder SHIP PRODANO IN One yer by SHIP QUANT REC DATE RECADD RECCS Duted MM/DD/YYYY Vendor Cloud 9 Cloud Shipping address coding city, mate, pout (tip) code City and state separate becom ) Associated with Text SHIP PROD NO o rber - umber M/DD/YYYY Vendor Co Clow IP ADD U Code Cloud SHIP_QUANT REC_DATE REC_ADD ECOS REC_ PC P REC_COUNTRY REC_PROD NO REC_PROD QUANT VOUCHER DATE VCH PROD NO VCKUPROD.QUANT VCHL_PROD_PRICE VOL TOTAL VCH_ACCT PAY_DATE TOTAL_POSITANT Totoy quantity shipped by vendor Date of receipt of goods Shipping address excluding city, state, potrip) code Che ated by Clip) code associated with SHIP ADD Country s ted with SHIP ADD inventory number of item recebed Quantity of inventory temported Date of recording the lady inventory number on voucher Inter quantity on voucher Price for each ihrem on voucher Suntold the coucher Account charged with liability for purchase Date of payment Total amount of payment of invoice SO/DOWY U Cloud saigal | MM/DD/ Y SXXXXXXXX Code do Cloudy Scope/Methodology Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: I designed the following substantive tests to evaluate the assertions shown: Assertion(s) to be Tested Nature of the Data Source of the Data Process Used to Produce the Data Maters to Consider in determining the nature, timing, and extent of procedures to perform regarding whether the data is sufficiently reliable Cloud 9 Accounting Information System databases: Vendor Master File . EIPP Database The AIS collects information on purchase orders, receiving reports, vendor invoices, and cash disbursements processed through EIPP. The audit team tested internal controls related to Cloud 9's system environment. The team also tested IT general controls and IT application controls for EIPP processing as related to the occurrence of purchases, accuracy of purchases, and occurrence/completeness of cash disbursements. The team found the IT general and application controls effective. Procedures to consider performing regarding data reliability. (US) Process Used to Produce the Data Maters to Consider in determining the nature, timing, and extent of procedures to perform regarding whether the data is sufficiently reliable EIPP Database The AIS collects information on purchase orders, receiving reports, vendor invoices, and cash disbursements processed through EIPP. The audit team tested internal controls related to Cloud 9's system environment. The team also tested IT general controls and IT application controls for EIPP processing as related to the occurrence of purchases, accuracy of purchases, and occurrence/completeness of cash disbursements. The team found the IT general and application controls effective. Procedures to consider performing regarding data reliability. Result that would indicate a misstatement for this assertion. Conclusion Leave this section blank for this assignment. Results Leave this section blank for this assignment. chILISI Cloud 9 - Continuing Case You have been asked to assist in the planning and development of audit data analytics as a substantive test for Cloud 9. Cloud 9 uses an evaluated receipt settlement system (see Chapter 12) that involves electronic invoice presentment and payment (EIPP) for 90% of its purchase transactions. Required: Plan a substantive test of purchase transactions using ADA as a substantive test. When planning the substantive test, identify the following: a. What is (are) the assertion(s) being tested? b. What information are you comparing electronically for each assertion? c. What electronic evidence would represent a misstatement for each assertion? We will complete this assignment in class on Tuesday and Thursday using the workpaper provided.PU 10 Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: Purpose To determine if: Enter purposes of the tests you plan to perform here. Source PBC databases from Cloud 9's accounting information system, retrieved and provided by client Database structures also PBC: Database Felle VendorID Data Type 6-digit number A unique identification number for each vendor Data Input Condo Baw Veodoran post nicode Teat C Vendor's maling ding ADD State associated with Vendor_ADD Vendor postcode Vendor STATE Vendor PC Cloud Card deady cloud Source PBC databases from Cloud 9's accounting information system, retrieved and provided by client. Database structures also PBC: he Vendor ID A entification DataType 6-digit number Data wpat By Cloudy e r for each vendor Vendor Mar postcode Veader's mailing address ing ty, C V . ADD SVAD ded de Text Vendor ADD Vecm STATUE Ved PC Vende COUN Vende tank Art Number Vendor Credit C o Routing d with or ADD brand account number for vendor Ceado Couto Numere data Amount of credit extended by the end Coo Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: IP NO Cado Cloud Vendor A unique identification number for each vendor A unique transaction number that follows each transaction from order (Hrves as purchase order number), through s tresse berrechingering sumber invoicing serves a ASN be recording of the libility serves as voor b ereid payment number identified on payment Onder date Shipping address for excluding cry, state, post (zip) code PO SHIP_ADD Post (p) code for PO SHIP ADD SODD/YYY Cado PO DATE PO SHIP ADD POS POLIC do Test PO_COUNTRY PO_PROD_CODE Country associated with PO SHIP ADD Product number Clodio PO PROD QUANT PO_PROD_PRICE POLACCT TOTAL ORD PRICE AC DATE PROD NO eventory quantity ordered by Price per unit for each item ordered by Cloud9 Account charged based on ordering department Total price for the individual purchase order AS date sique inventory number Cloud Cado deado Cloud BOLDOG MM/DD/YYY U Vendor v Vendor Text PROD QUANT PROD_PRICE ASN_TOTAL ASN TERMS BILL. ADD BILLOS BILL PC BILL.COUNTRY BL DATE SHIP ADD SHIPS SHIPPC SHIP COUNTRY entory quantity ordered by Cloud9 Price for each item ordered by Cloud9 Sum total of the vendor's chance shipping notice discount allowed if pall within XX days from receiving date Billing address excluding city, state, post (zip) code City and state City and parated by a comma) Associated with BILL ADD Post (tip) code associated with BILLADD Country associated with BILL. ADD Bill of lading date Salons d e edadies cityInte, pout (sip and the parte accomm o dated SADA Text Vendor Vendor Veador Veder Vendor Text MM/DD/YYYY Test mutta Verder SHIP PRODANO IN One yer by SHIP QUANT REC DATE RECADD RECCS Duted MM/DD/YYYY Vendor Cloud 9 Cloud Shipping address coding city, mate, pout (tip) code City and state separate becom ) Associated with Text SHIP PROD NO o rber - umber M/DD/YYYY Vendor Co Clow IP ADD U Code Cloud SHIP_QUANT REC_DATE REC_ADD ECOS REC_ PC P REC_COUNTRY REC_PROD NO REC_PROD QUANT VOUCHER DATE VCH PROD NO VCKUPROD.QUANT VCHL_PROD_PRICE VOL TOTAL VCH_ACCT PAY_DATE TOTAL_POSITANT Totoy quantity shipped by vendor Date of receipt of goods Shipping address excluding city, state, potrip) code Che ated by Clip) code associated with SHIP ADD Country s ted with SHIP ADD inventory number of item recebed Quantity of inventory temported Date of recording the lady inventory number on voucher Inter quantity on voucher Price for each ihrem on voucher Suntold the coucher Account charged with liability for purchase Date of payment Total amount of payment of invoice SO/DOWY U Cloud saigal | MM/DD/ Y SXXXXXXXX Code do Cloudy Scope/Methodology Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: Client Name: Cloud 9 Inc. Engagement Title: F/S Y/E January 31, 2023 WP Segment and Number: PU-10 Purchasing Cycle WP Title: Substantive Testing of Purchasing Transactions and Related Balances Using Audit Data Analytics Prepared By: Date: Reviewed By: Date: I designed the following substantive tests to evaluate the assertions shown: Assertion(s) to be Tested Nature of the Data Source of the Data Process Used to Produce the Data Maters to Consider in determining the nature, timing, and extent of procedures to perform regarding whether the data is sufficiently reliable Cloud 9 Accounting Information System databases: Vendor Master File . EIPP Database The AIS collects information on purchase orders, receiving reports, vendor invoices, and cash disbursements processed through EIPP. The audit team tested internal controls related to Cloud 9's system environment. The team also tested IT general controls and IT application controls for EIPP processing as related to the occurrence of purchases, accuracy of purchases, and occurrence/completeness of cash disbursements. The team found the IT general and application controls effective. Procedures to consider performing regarding data reliability. (US) Process Used to Produce the Data Maters to Consider in determining the nature, timing, and extent of procedures to perform regarding whether the data is sufficiently reliable EIPP Database The AIS collects information on purchase orders, receiving reports, vendor invoices, and cash disbursements processed through EIPP. The audit team tested internal controls related to Cloud 9's system environment. The team also tested IT general controls and IT application controls for EIPP processing as related to the occurrence of purchases, accuracy of purchases, and occurrence/completeness of cash disbursements. The team found the IT general and application controls effective. Procedures to consider performing regarding data reliability. Result that would indicate a misstatement for this assertion. Conclusion Leave this section blank for this assignment. Results Leave this section blank for this assignment. chILISI