ACC 131 QuickBooks Software Quick Books Comprehensive Problem I "Your Name Web Designs Sole Proprietorship" - also the company's legal name: 547 Miller Place Westport, NY 11858 U.S. Phone: 7349733708 has been in business for several years and was using a manual accounting system. On 10/1/22 Your Name" contracted you to convert their manual accounting information system to a QuickBooks computerized accounting information system. Web Designs classified their business as "Art, Writing or Photography" which will sell services only. Fiscal year starts on 10/1/22 Web Designs has no employees and no inventory, therefore there will be no sales tax. Web Designs uses the accrual basis. Web Designs has one bank account; Four Two Bank and its account number is 5769 . The last statement was dated 9/30/22. (See attached chart of accounts for the opening balance in cash). Web Designs Chart of Accounts and balances as of 10/1/22 are listed on the attached pages. Attached are all of Web Design customers and creditors along with their opening balances. To simplify the set up of the customers and creditors you are only required to enter the name, credit. terms and opening balances unless otherwise stated. Web Designs wants to set up service items for its two revenue accounts. See attached chart of accounts. Required: 1. Set up the chart of accounts with opening balances. See chart of accounts below. - Set up customers and creditors. (See below) Chart of Accounts -After setting up a/c 4010 also set up a service item at $125 hour using a/c 4010 "After setting up a/c 4020 also set up a service item at $100 per hour using a/c 4020 Attached are all of Your Name Designs vendors and customers along with their balances as of 10/1/22. 2. Export the following reports to the Excel file for this problem and upload to Blackboard. - Trial Balance as of 10/1/22 - Account Listing 3. Record the following transactions in QuickBooks for the month of October. olity= Investigate Submit the following by exporting the report to Excel and then copying that report to the excel workpaper provided. You should have the one spreadsheet with the 7 reports copied to the separate tabs on the worksheet provided. The first two reports should have already been exported as indicated in requirement 2. (Trial balance as of 10/1/22 and the Account Listing). 1. Bank Reconciliation as of 10/31/22. See attached bank statement and duplicate deposit slips to assist you. 2. Journal Report for (10/1/2210/31/22). 3. Profit and Loss Report (10/1/22 - 10/31/22). 4. Balance Sheet Report (10/1/2210/31/22. See duplicate deposit slips "returned due to insufficient funds- Long Island Auto Works ACC 131 QuickBooks Software Quick Books Comprehensive Problem I "Your Name Web Designs Sole Proprietorship" - also the company's legal name: 547 Miller Place Westport, NY 11858 U.S. Phone: 7349733708 has been in business for several years and was using a manual accounting system. On 10/1/22 Your Name" contracted you to convert their manual accounting information system to a QuickBooks computerized accounting information system. Web Designs classified their business as "Art, Writing or Photography" which will sell services only. Fiscal year starts on 10/1/22 Web Designs has no employees and no inventory, therefore there will be no sales tax. Web Designs uses the accrual basis. Web Designs has one bank account; Four Two Bank and its account number is 5769 . The last statement was dated 9/30/22. (See attached chart of accounts for the opening balance in cash). Web Designs Chart of Accounts and balances as of 10/1/22 are listed on the attached pages. Attached are all of Web Design customers and creditors along with their opening balances. To simplify the set up of the customers and creditors you are only required to enter the name, credit. terms and opening balances unless otherwise stated. Web Designs wants to set up service items for its two revenue accounts. See attached chart of accounts. Required: 1. Set up the chart of accounts with opening balances. See chart of accounts below. - Set up customers and creditors. (See below) Chart of Accounts -After setting up a/c 4010 also set up a service item at $125 hour using a/c 4010 "After setting up a/c 4020 also set up a service item at $100 per hour using a/c 4020 Attached are all of Your Name Designs vendors and customers along with their balances as of 10/1/22. 2. Export the following reports to the Excel file for this problem and upload to Blackboard. - Trial Balance as of 10/1/22 - Account Listing 3. Record the following transactions in QuickBooks for the month of October. olity= Investigate Submit the following by exporting the report to Excel and then copying that report to the excel workpaper provided. You should have the one spreadsheet with the 7 reports copied to the separate tabs on the worksheet provided. The first two reports should have already been exported as indicated in requirement 2. (Trial balance as of 10/1/22 and the Account Listing). 1. Bank Reconciliation as of 10/31/22. See attached bank statement and duplicate deposit slips to assist you. 2. Journal Report for (10/1/2210/31/22). 3. Profit and Loss Report (10/1/22 - 10/31/22). 4. Balance Sheet Report (10/1/2210/31/22. See duplicate deposit slips "returned due to insufficient funds- Long Island Auto Works