Date Payee Sports Sample Item 1/2/2008 Clothing 0 Invoice Number Customer Number Recorded Amount 6521 109 12,376.00 Audited Amount Difference 1a 1b 1c 1d 2a 2b 2c 2d 3a 3b 3c 12,376.00 - - 6/27/2007 1 6540* 116 1,344.00 1,344.00 7/15/2007 2 6542* 113 12,664.00 10,122.00 10/15/2007 3 6555 114 5,832.00 5,832.00 5/15/2007 4 6535* 103 1,344.00 - (1,344.00) 8/18/2007 5 6547* 108 39,340.00 - (39,340.00) 11/13/2007 6 6558 119 3,432.00 2/10/2007 7 6524* 105 1,344.00 8/30/2007 8 6549 107 19,970.00 19,970.00 - 11/23/2007 9 6559 115 19,970.00 19,970.00 - Note you may not need 13 items (three per group member) Do not include item 0 (the example, in your results) Source of Information: Sample Selection Method: Random Number Generator Projection of Results to Population 3,432.00 - (2,542.00) - (1,344.00) 105,240.00 60,670.00 (44,570.00) Every column and row should have a symbol indicating the test was done NOTE: use these for projecting to population Tickmark Legend: Audit step complete with no deviations noted Deviation noted -- see fn below for additional details Footnotes * Invoice: 6540 - Accuracy Deviation Noted Sales Order, Shipping Document & Invoice do not show the customer's full name Sales Journal: Barbich, Longcrier, Hooper & King Accountacy Sales Order: Barbich, Longcrier Shipping Document: Barbich, Longcrier, Hooper & King Invoice: Barbich, Longcrier, Hooper & Invoice: 6542 - Accuracy Deviation Noted Quantity reported on invoice & sales order is greater than quantity reported on shipping d Sales Order: 18 items ($12,664) Shipping Document: 14 items ($10,122) Invoice: 18 items ($12,664) Invoice: 6535 - Occurrence Deviation Noted No shipping document or sales order to support this sale Invoice: 6547 - Occurrence Deviation Noted No shipping document or sales order to support this sale Conclusions about sales: (Don't forget to consider Materiality and recommended adjustments if any) Invoice: 6524 - Ocurrence deviation noted No shipping document or sales order to support this sale Was the merchandise delivered, was there evidence of an arrangement, etc. 3d 3e 3f omer's full name y reported on shipping documents Attributes of Substantive Tests should be listed here so reviwers do not have look at audit program Vouch to the supporting Invoices 1a Agree the customer's name from the Sales Journal to the name on the Invoice 1b Agree the date from the Sales Journal to the date on the Invoice 1c Agree the amount from the Sales Journal to the amount on the Invoice 1d Agree the prices on the Invoice to the Price List Vouch to the supporting Shipping Documents 2a Agree the customer's name on the Invoice to the name on the Shipping Document 2b Agree the customer's address on the Invoice to the address on the Shipping Document 2c Compare the date on the Invoice to the date on the Shipping Document 2d Agree the quantities on the Invoice to the quantities on the Shipping Document Vouch to the supporting Sales Orders 3a 3b 3c 3d 3e 3f Agree the customer's name on the Shipping Document to the name on the Sales Order Agree the customer's address on the Shipping Document to the address on the Sales Order Compare the date on the Shipping Document to the date on the Sales Order Agree the quantities on the Shipping Document to the quantities on the Sales Order Agree the prices on the Sales Order to the Price List Re-calculate the accuracy of the mathematical accuracy of the Sales Order Note: Audited amount should be based on the revenue recognition criteria. Based on the above tests, one should conclude whether there is evidence of an arrangement, delivery has occurred, etc