Hi, I need help to createa balance sheet and profit and loss statement along with the completed bank reconciliation using the information attached herein. Thanks.

PART A. Siesta Company Trial Balance. ACCT # 101 151 161 171 105 104 307 400 220 DR. ACCT NAME. CR. ACCT NAME. Cash Pallet Jack Fork Lift. Packaging machine Inventory Accounts Receivable Dr. Cr. 122200 8500 26300 8700 8000 6600 Common Stock Sales. Utilities payable. 180300 153500 18800 8000 180300 PART B: JOURNAL ENTRIES - SIESTA COMPANY. 1. Dec 1. Common stock Cost of asset Cash 3740 40 3780 2. . Dec 1. Notes payable Interest payable Supplies- Other assets. 2150 160 2310 3. . Dec 1. Prepaid Insurance Cash 1680 1680 4. . Dec 1. Rent Expense Prepaid rent Cash 1800 1800 3600 5. . Supplies Sales tax payable Accounts payable 800 60 860 6. . Dec 19. Cash. Dividends Income. 180 180 7. No journal entry is required. 8. . Dec 28. Cash Assets disposed. 8000 Depreciation costs. Costs of assets 13 8000 13 9. . Dec 28. Cash Common Stock. 10385 10385 10. . Dec 29. Dividends declared Cash. 2200 2200 11. . Dec 30. Cash Sales. Sales Tax Payable. 1935 1800 135 12. . Dec 30. Accounts payable. Cash. 860 860 Business 1125 - Financial Accounting Quickbooks G/L Problems -Comprehensive Problem Part B - Siesta Company Welcome to Part B (worth 30 pts) of the Quickbooks Comprehensive Problem. Please note that you should use the updated Siesta Company template provided in D2L instead of your previous Siesta Company file to insure you are starting error-free (i.e. so go into Content in D2L under Quickbooks Comprehensive Problem Part B and perform the same procedures as you did previously for downloading a zipped QB file onto your computer and then uploading it into Quickbooks). In this part of the Comprehensive Problem you will be making Journal Entries (JEs), a short payroll problem and JE, Adjusting Journal Entries (AJEs) and a Bank Reconciliation (don't forget the JE for the Bank Reconciliation). 12. Recording daily entries in the general journal. Record the following entries in the general journal [note: in the \"real world\Business 1125 - Financial Accounting Quickbooks G/L Problems -Comprehensive Problem Siesta Company Part A There are two components to this 40 total point Comprehensive Problem Part A (this assignment) - is worth 10 points allocated to the submission of a correct trial balance as discussed in this handout. Part A includes Steps 1 -11 given below, and covers Quickbooks' methods and procedures to establish the Chart of Accounts, set up Vendors and Customers, issue Purchase Orders (POs) to vendors and Invoices to customers, Receive Inventory and Customer Payments and make Payments to Vendors. You will not make any Journal Entries in Part A because in the real world the vast majority of the daily entries are automatically generated by the accounting system. For example, when an invoice is generated to a customer (and a perpetual inventory system is being used, which is the default in Quickbooks), the two entries which you studied in Chapters 5 & 6 (i.e. dr. COGS and cr. Inventory and dr. A/R and cr. Sales) are automatically recorded in the journal and posted to the general ledger. Thus it is imperative that you establish correct G/L accounts when establishing inventory items, customers, etc. in order to have appropriate entries generated by the system. Part B (described in a separate handout) - is worth 80 points (50 points allocated to the correctness of documents required to be submitted, and 30 points allocated to questions for which you will once again submit your answers in the quizzes section in D2L). In part B you will be required to make Journal Entries, Adjusting Journal Entries and prepare a Bank Reconciliation Keep this Part A document as Part B will refer to it. General Information A. Load the \"Quickbooks Comprehensive Problem\" template onto your computer by performing the same steps you previously used for the prior QB problems (these steps are repeated for you below). 1. the The Quickbooks templates are found in the \"Content\" section (under \"QuickBooks Documents\") in D2L. Due to size and nature of the file it had to be \"zipped\" (i.e. compressed) in order for you to be able to download it. You cannot directly load a zipped file into Quickbooks and thus you must unzip the file once you download it onto your computer in order to upload it from your computer into Quickbooks. Find the Quickbooks \"Comprehensive Problem\" Template and download the zipped file to your computer. You will then need to unzip the file using following instructions: To extract files or folders from a compressed folder: a. Locate the compressed folder that you want to extract files or folders from. b. Do one of the following: o To extract a single file or folder, double-click the compressed folder to open it. Then, drag the file or folder from the compressed folder to a new location. o To extract the entire contents of the compressed folder, right-click the folder, click Extract All, and then follow the instructions. 2. Start Quickbooks (if not already open). 3. If a company opens, click File, Close Company (the menu is on the upper left hand side of the page). The Quickbooks startup window [a dialog box \"No Company Open\" should be in the window] 4. Click \"Open or restore an existing company\". The \"Open or Restore Company\" dialog box should appear. Select the radio button entitled \"Restore a copy\". Click \"Next\