Chart of Accounts work 1A. Create the following new expense account in Craig's Design & Landscaping Service: Name: Automobile repair Make this new account a SUB-ACCOUNT to Automobile NOTE: Account numbers are not used in the test drive company Hint: Subaccounts should have the same detail type as their parent. 1B. Locate the two accounts with "depreciation" in the account name. New Customer: Edit one of the accounts to have the name "Depreciation expense". Edit the other account to have the name "Accumulated depreciation". HINT: Be sure to change to correct one. Look at account type/detail type to help you. 2. Add the following Customer to your company: Company Name First Name SJ Ballet & Dance Sophia Jones Last Name Display Name Address (Billing & Shipping) Tax Info Payment Terms SJ Ballet and Dance 25 Main Street San Diego, CA 92109 Select this customer is taxable Net 30 New Vendor: 3. Set up the following vendor. Company Name Auto Fix and Go First Name Jeremy Display Name Auto Fix and Go Address Account No. 2525 San Pablo Dam Rd. San Pablo, CA 94806 5002 Payment Terms Net 30 Business ID 37-8910899 Opening Balance Leave blank Products and Services 4. Add the following service. Type Name Category Service Design Solar Light Design Description Solar Light Design Sales Price $50.00 Income Account Design income Sales Tax Nontaxable Category 5. Edit a current service item You notice a sales price has not been assigned to the Weekly Gardening Service (Gardening). You edit the service and add a sales price of $30.00. This is a nontaxable service. Settings: 6. Go to the Account and Settings area and change the following settings: a. Change the company name to your own name b. Turn ON custom transaction numbers for sales forms c. Turn OFF Automatically apply credits d. Turn OFF Pre-fill forms with previously entered content e. Extend the time of Sign me off if inactive for to 3 hours. Transactions: 7. Record the following transactions. Date Transaction CAUTION - WATCH DATES CAREFULLY 6/1/22 6/4/22 6/4/22 6/4/22 6/10/22 6/12/22 6/16/22 6/18/22 6/18/22 6/20/22 6/20/22 6/20/22 6/22/22 Write a check for $900 from the Checking Account to Cigna Health Care. This is to prepay for 3 months of health insurance for you and your employees starting on the date of the check. Check #71 $900.00 Create invoice #1038 to Pye's Cakes for 2 weeks of weekly gardening service (Gardening). Receive a check (#5488) from John Melton for $200. This is a partial payment on invoice #1007 that has an open balance. Deposit to Undeposited Funds Deposit all undeposited customer payments to the checking account. Make a note of how many items you are depositing. Receive your monthly cell phone bill from Cal Telephone for $82.00 (Bill No. 112017). The bill is due in 30 days. Enter the bill. You take all work trucks to Auto Fix and Go for routine auto maintenance. It costs $359.00 for the automobile repairs. You use your MasterCard credit card to pay for the work. Pay bill that is due to Robertson and Associates for $315 with check #72. CAUTION: WATCH DATES CAREFULLY Created a Solar Light Design for SJ Ballet and Dance. The design took 3 hours (Qty= 3). When you delivered the design the customer paid you right away with check # 65412. The total amount of the check was $150. Sales Receipt number SR-103. Deposit to Undeposited Funds Weiskopf Consulting was not happy with their design service. They have been a good customer so you decide to issue a credit memo CM1010 for $75.00 (1 hour of Design work). All of the design work was originally invoiced on invoice #1010. You receive the bill for the monthly bookkeeping service from Books by Bessie for $75.00. The terms are Net 15 and the bill is # 085. Receive a $300 check (#54123) from Weiskopf Consulting for the remaining balance on invoice #1010 less the credit memo (CM1010). Deposit all undeposited customer payments to the checking account. Make a note of how many items you are depositing. Pay the following bills from your Checking Account. Starting with Check # 73 CAUTION: WATCH DATES CAREFULLY 6/30/22 1. PG&E $86.44 Books by Bessie $75.00 Enter journal entries for the following month-end accounting activity: Expense one month of the health insurance cost. (Journal No. MT-1) 2. Monthly depreciation on the fixed asset truck: $125 (Journal No. MT-2) Bank Reconciliation. 8. Prepare the bank reconciliation using the following information: Opening Balance $5,000 Ending Balance $9,988.23 6/30/22 Reconciliation Date The first 9 payments starting with $300 and ending with $108.09 appear on the bank statement. Payments: The first 13 deposits starting with $175 and ending with $450 appear on the bank statement. Deposits: Print the final bank reconciliation report to a pdf file. Reports to Run 9. Run the following reports. Export the reports to a pdf file and submit them to your instructor. 6/1/2022 Start Date 6/30/2022 End Date Journal Report for the dates listed above Balance Sheet Report for the dates listed above Profit and Loss Report for the dates listed above Accounts Receivable Aging Detail report as of the End Date Listed above Accounts Payable Aging Summary report as of the End Date Listed above Sales by Product/Service Summary for the dates listed above