Can anyone help me with the SURL assignment for Assurance class? Thank you so much! I have attached all the documents that may needed and we will submit the Template

Accrued Expenses 20X3 Account Number Vendor Name Identifier Amount of Expense 2010 All Occasion Rental 11X2GA24 850.00 2010 Aluminum in Bulk LLC 10W3CO01 8,005.00 2010 Beverageland Times 19U7GA10 89.00 2010 BL Generic Brands 87U4CO91 2,412.00 2010 Body of Water Supply 91F1UT12 62,810.75 2010 Bottlers Anonymous LLC 12E3CO90 16,435.00 2010 C.C. Supplies 80A2GA09 879.00 2010 Cardboard Universe 40O5GA10 3,605.00 2010 Chemical Brothers 90H1CO12 12,091.00 2010 City of Poptown 77V3PT10 778,000.00 2010 Create a Scene Corp. 71B9GA12 12,346.00 2010 CVV Consultants 00F8FE79 646.00 2010 Emeril Spice 80T6CO11 2,100.12 2010 Extreme Caffeine 00H1CO15 8,576.00 2010 FastEx Shipping 12T2GA90 200.00 2010 Fizland Communications 18A3GA90 801.00 2010 Fizland Daily Press 12G0GA21 210.00 2010 Fizland Water Company 19Y6UT01 87,833.00 2010 Foreign Oil Suppliers Inc. 79S1UT33 41,881.00 2010 Fruity Flavors 87V8CO23 543.00 2010 FZL Gas and Electric 65Y6UT10 64,183.00 2010 Industrial Supply 43I2GA99 7,670.00 2010 Intl Shipping Corp. 91Q8CO23 1,352.00 2010 KPMG LLP 91Y1FE09 70,000.00 2010 M&M Maintenance Services 18I1GA55 915.85 2010 Mainland Importers 11Y3GA10 4,921.39 2010 Niknaks Corp 80R8GA11 8,970.00 2010 O'Donnell, Roman, & Yin 91P9FE21 20,000.00 2010 Office Supply Closet Inc. 88B3GA91 906.00 2010 Oil Slick Inc. 21V6UT10 87,654.00 2010 Packing Machinery Galore 98I2CO12 456.00 2010 Paper Piper Co. 99K1GA78 8,970.00 2010 Paper Product Wholesale 91U0GA43 9,062.00 2010 Poptown Catering Company 44E8GA01 4,020.00 2010 Poptown Gas & Electric 91L6UT11 24,000.00 2010 Queen Spices 66R5CO00 345.00 2010 Salty, Inc. 91F8CO76 4,456.01 2010 Savvy Bottlers 20Y7CO91 215,346.68 2010 SecureYourSpace Inc. 36P2GA10 5,583.00 2010 Sell Out Supply 81J7GA19 700.86 2010 ShipIt Trucking Co 10H8GA12 345.12 2010 Sizzle Spice Company 01F1CO43 6,021.00 2010 Sold Out Suppliers 09K8GA12 704.00 2010 State of Beverageland 19V1PT12 41,460.00 2010 Sugar and Spice Supply 01F8CO19 1,200.00 2010 Super Oil 91V7UT10 59,150.00 2010 Table Top Inc 00D2GA51 7,000.00 Page 1 of 2 2010 The Fiz Street Journal 09L1GA14 225.00 2010 The Fizland Group, LLC 12X8FE19 4,544.00 2010 The Truck Doctor 09I7GA10 4,889.00 2010 Tops of the World 91F9CO19 6,100.00 2010 Wacky Widgets Inc. 51I1CO18 3,191.00 2010 Warehouse Street LLC 08L2GA12 385,000.00 2010 We Office Supply Inc. 52L1GA19 1,360.00 2010 Widgets & Other Things LLC 10C9GA50 4,400.00 2010 World Shipping Specialists 19I1FE76 5,572.35 Page 2 of 2 SEARCH FOR UNRECORDED LIABILITIES TEMPLATE WAREHAM, INC. DECEMBER 31, 20X3 Payment details Ref. Check/ wire No. reference 1 19040 Check/ wire date January 27, 20X4 Invoice details Vendor Water Suppliers Unlimited 2 10000012 January 9, 20X4 City of Poptown 3 19055 January 28, 20X4 Savvy Bottlers 4 19055 January 28, 20X4 Savvy Bottlers 5 19075 February 4, 20X4 Poptown Gas & Electric 6 19082 February 6, 20X4 Umbrella Insurers 7 N/A N/A Global Hotel Group Comments, if any a Number Date Amount Date goods/ services were received Was the expense Accounting period the recorded in the proper expense was recorded period? TM ACCT 4610 SEARCH FOR UNRECORDED LIABILITIES ASSIGNMENT Background You are an audit associate at KPMG and are working on audit of Wareham, Inc. for the year ending December 31, 20X3. You have been tasked with performing the search for unrecorded liabilities, which helps to test the assertion of completeness (C). In order to complete the search, certain documents have been provided in iCollege. Documents 1. TP Aging 20X3.pdf - This is the trade payables aging schedule for Wareham, Inc. as of December 31, 20X3. 2. Accrued Expense Detail 20X3.xlsx - This is a listing of the expenses for which Wareham, Inc. had accrued for as of December 31, 20X3. In other words, these are expenses that relate to 20X3 but will be paid in 20X4 (or later), and Wareham hasn't yet received an invoice that would create a trade payable. 3. Invoices for Search.pdf - These are the supporting invoices that Wareham, Inc. has provided to you based on the sample selection of disbursements. 4. Search Testwork Template.xlsx - This is your audit workpaper that will be completed. Directions: For each sample item, you need to perform the following procedures and document your work in the template provided. 1. Review the details on the invoice to ensure Wareham, Inc. provided you with the correct support based on your sample. 2. Determine the period(s) in which the expense should be recognized (20X3 = current year; 20X4 = subsequent year). 3. If the expense, or any part of the expense, relates to 20X3, verify that Wareham appropriately accounted for that expense as either a trade payable or accrued expense. 4. If you find an unrecorded liability, determine whether or not an audit adjustment needs to be proposed. If an audit adjustment is needed, provide the necessary journal entry using the comments box. Deliverable: Each group should submit the Search for Testwork Template through iCollege. Tips: Dates on the invoices are in a European format (DD/MM/YY). CU stands for currency unit. You may treat the amounts in this activity as U.S. dollars ($). WAREHAM, INC. UNITED CARBONATIONS Trade Payables Aging Detail: BY VENDOR December 31, 20X3 Vendor Invoice # Invoice Date All Occasion Rental All Occasion Rental Total P03-01 December 2, 20X3 2,230.12 2,230.12 0.00 0.00 0.00 0.00 0.00 0.00 2,230.12 2,230.12 Bottlers International Bottlers International Total 25-632 December 14, 20X3 12,271.32 12,271.32 0.00 0.00 0.00 0.00 0.00 0.00 12,271.32 12,271.32 CRU01_03 November, 28, 20X3 10,452.10 10,452.10 0.00 0.00 0.00 0.00 0.00 0.00 10,452.10 10,452.10 Distilled Beverages Inc. Distilled Beverages Inc. Distilled Beverages Inc. Total 9851 1116 December 2, 20X3 January 3, 20X4 21,012.10 22,207.92 43,220.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 21,012.10 22,207.92 43,220.02 Extreme Caffeine Extreme Caffeine Total 6581 November 2, 20X3 16,695.00 16,695.00 0.00 0.00 0.00 0.00 5,984.99 5,984.99 10,710.01 10,710.01 FizzEx Shipping FizzEx Shipping Total PL-367 December 3, 20X3 10,063.10 10,063.10 0.00 0.00 0.00 0.00 0.00 0.00 10,063.10 10,063.10 CMI-122801 December 19, 20X3 14,670.34 14,670.34 0.00 0.00 0.00 0.00 0.00 0.00 14,670.34 14,670.34 CMI-1428 November 28, 20X3 30,145.12 30,145.12 0.00 0.00 0.00 0.00 30,145.12 30,145.12 0.00 0.00 89161 December 2, 20X3 10,351.00 10,351.00 0.00 0.00 0.00 0.00 0.00 0.00 10,351.00 10,351.00 Central Marketing Central Marketing Total Global Hotel Group Global Hotels Total Green Team Consultants LP Green Team Consultants LP International Shipping Corp. International Shipping Corp. Total Amount > 90 61-90 31-60 Current INCOMPLETE - FOR TRAINING PURPOSES ONLY Magic Machine Maintenance Service Magic Machine Maintenance Service Total 892 December 8, 20X3 2,132.00 2,132.00 0.00 0.00 0.00 0.00 0.00 0.00 2,132.00 2,132.00 US-PL-109 December 3, 20X3 7,745.20 7,745.20 0.00 0.00 0.00 0.00 0.00 0.00 7,745.20 7,745.20 Mango Computers Inc. Mango Computers Inc. Total 12-78652 December 24, 20X3 1,672.35 1,672.35 0.00 0.00 0.00 0.00 0.00 0.00 1,672.35 1,672.35 Paper Packaging Plus Paper Packaging Plus Paper Packaging Plus Total 16235 16997 December 5, 20X3 December 29, 20X3 8,971.04 5,583.04 14,554.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,971.04 5,583.04 14,554.08 Mainland Importers Mainland Importers Total 1/2 1 of 2 WAREHAM, INC. UNITED CARBONATIONS Trade Payables Aging Detail: BY VENDOR December 31, 20X3 Vendor Invoice # Invoice Date 201-0013520 December 17, 20X3 33,421.00 33,421.00 0.00 0.00 0.00 0.00 0.00 0.00 33,421.00 33,421.00 Poptown Gas and Electric Co. Poptown Gas and Electric Co. Total 1000001 January 5, 20X4 102,500.00 102,500.00 0.00 0.00 0.00 0.00 0.00 0.00 102,500.00 102,500.00 Poptown Gazette Poptown Gazette Poptown Gazette Poptown Gazette Total 95-6852 95-6971 95-9981 October 2, 20X3 November 2, 20X3 December 2, 20X3 32,010.00 21,501.00 21,501.00 75,012.00 0.00 0.00 0.00 0.00 32,010.00 0.00 0.00 32,010.00 0.00 21,501.00 0.00 21,501.00 0.00 0.00 21,501.00 21,501.00 Premier Labeling Premier Labeling Total 3581 January 2, 20X4 8,703.23 8,703.23 0.00 0.00 0.00 0.00 0.00 0.00 8,703.23 8,703.23 D15990C December 4, 20X3 323,020.03 323,020.03 0.00 0.00 0.00 0.00 0.00 0.00 323,020.03 323,020.03 13-Jan December 13, 20X3 14,020.72 14,020.72 0.00 0.00 0.00 0.00 0.00 0.00 14,020.72 14,020.72 Water Suppliers Unlimited Water Suppliers Unlimited Total 921840109 December 31, 20X3 309,225.00 309,225.00 0.00 0.00 0.00 0.00 0.00 0.00 309,225.00 309,225.00 World of Flavoring World of Flavoring Total CMI62857 November 26,20X3 6,549.26 6,549.26 0.00 0.00 0.00 0.00 6,549.26 6,549.26 0.00 0.00 CMI 12-26-02 December 26,20X3 670.71 670.71 0.00 0.00 0.00 0.00 670.71 670.71 0.00 0.00 2,333,090.00 100.00% 0.00 0.00% 32,010.00 1.37% 499,160.00 21.39% 1,801,920.00 77.23% Periodic Tables Periodic Tables Total Savvy Bottlers Savvy Bottlers Total Tops & Botts Ltd Tops & Botts Ltd Total Zesty and Spicy Total Zesty and Spicy Total Grand Total As a % of Total Trade Payables Amount > 90 61-90 31-60 Current