Team members: Section: 11:00 12:30 TechWear Part 3: Audit data analysis planning template What could go Data analysis auditing Assertion Auditing objectives wrong? Mitigating controls procedures Data requirements Accounts receivable account balance Existence Amounts reported in An order is placed and Debits to accounts Compare debits to Sales amounts (given) the financial a receivable is receivable are only accounts receivable Cash receipt statements represent recorded without any generated from the against recorded amounts valid receivables. product being shipped. order entry system. sales. - Customer names Review and test Transaction dates subsequent receipts. Transaction Evatuate proper numbers segregation of duties General Isedger by examining postings by postings by source preparer and and preparer (e.g.. source (e.g., order sales only entered by entry) authorized salesclerk). A shipping number Verify that every Customer names and FedEx sales transaction has Transaction identification number a shipping number numbers are entered into the and FedEx Shipping numbers system as evidence of identification number. FedEx ID numbers order fulliment and Analyze gross - Sales amounts discrepancies are margin percentage Cost of goods sold investigated. trends by month and amounts by customer. Transaction dates