I need assistance creating audit work papers in excel for this assignment. I have no idea what it should look like.

Auditing Expenses Assignment ACCT 6025 - Fall 2015 Due - 12/3/2015 FACTS: You are the staff auditor on a public company and have been assigned the testing of General & Administrative Expenses. There is currently no workpaper for the testing to be performed so you will have to create one and document your testing. Your goal is to transform the information below into workpaper format (Microsoft Excel). Please include all data presented below in your workpaper. Make sure you document procedures performed as well as assertions tested and any other pertinent information you deem necessary for the reviewer. Tolerable Misstatement: $45,000 Confidence Factor: 2 General Ledger for G&A Expenses 8000 Payroll - Gross Salaries 8001 Utilities 8002 Advertising 8003 Rent 8004 Legal 8005 Office Supplies 8006 Accounting and Tax Fees 8007 Subscriptions 2015 $ 552,021 $ 5,036 $ 12,543 $ 72,702 $ 16,127 $ 3,692 $ 54,095 $9,000 2014 $ 501,135 $ 5,397 $ 10,937 $ 70,268 $ 4,216 $ 3,597 $ 55,971 $12,000 The Accounting Manager provided all GL detail for the G&A expenses, which you agreed to the total balance in the trial balance. From your examination of the GL detail, there were no individual items greater than your tolerable misstatement. You will be documenting the 4 selections below (don't worry about the rest in the sample, they will be documented later). Selections were made randomly and the Accounting Manager provided the journal entry recorded for each one along with the support listed below. See descriptions of selections on the next page. Selection 1 Payroll (account 8000), pay period ending 10/16/2015 (paid every 2 weeks), totaling $19,425. A sub-selection was made for one employee (#1295, James Daugherty, Sales Manager) in the amount of $2,000. The HR Director provided the following support for the selection: employee contract, which stated that his salary is $52,000 per year, bank statement for October 2015. On 10/16, there is a total withdrawal for payroll in the amount of $19,425, reference #1J456LI09. The client uses ADP to process all of their payroll (meaning they remit the total amount to ADP, who then divides the total between employees and taxing authorities). Document what additional procedures would need to be done over the use of ADP. We have covered this in class. Selection 2 Advertising (account 8002), selection amount $2,376, dated 12/15/2015. The Accounting Manager provided an invoice, dated 12/11/2015, for the selection from Total Productions, Inc. The invoice was for online advertising for the period 12/1/15 - 1/31/16. The total invoice amount agreed to the selection amount. Payment was made on 12/28/2015 for the full amount, check #17989. Selection 3 Rent (account 8003), selection amount $6,058.50 for March rent, booked 3/31/2015. The Accounting Manager provided you the rental agreement with Property Management Pros, which stated rent would be $72,702 per year, prorated evenly across each month. The rental agreement was signed 12/19/2014. The Accounting Manager also provided the bank statement from December 2014, because they paid for 6 months of rent in advance. You examined the bank statement and noted payment on December 29th in the amount of $36,036, reference #1R982F96Y . Based on this information, which account would also need to be tested? Please state this in your workpaper documentation. Selection 4 Legal (account 8004), selection amount $5,403, dated 2/25/2015. The Accounting Manager provided the invoice from an external legal firm, Smith and Ryder Law Firm. The amount of the invoice agreed to the selection amount and was dated 2/20/2015. The invoice described the services provided as, \"Consulting services related to defense in consumer lawsuit - January and February 2015.\" The Accounting Manager also provided the bank statement for March where you noted payment to the law firm for $5,403, check #14598, cleared 3/27/2015. What other procedures need to be performed related to this selection? Please note those in your workpaper documentation