Complete the Following Steps Chart of Accounts work 1A. Create the following new expense account in Craig's Design & Landscaping Service: Name: Property and Equipment Insurance Expense Make this new account a SUB-ACCOUNT to Insurance 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. 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. New Customer: 2. Add the following Customer to your company: Company Name Doctor Offices of San Diego First Name Thomas Last Name George Display Name Doctor Offices of San Diego Address (Billing & 25 Main Street Shipping) San Diego, CA 92109 Tax Info Select this customer is taxable Payment Terms Net 30 m.pdf o Transactions: 6. Record the following transactions. CAUTION - WATCH DATES CAREFULLY Date Transaction 7/1/21 Write a check from the Checking Account to Best Insurance Company. This is to prepay for 6 months of property and equipment insurance starting the date of the check. Check #71 $1200.00 7/4/21 7/4/21 7/4/21 Create invoice #1038 to Sushi by Katsuyuki for 2 hours of trimming trees (Trimming). Receive a check (#5488) from John Melton for $250. 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 $88.00 (Bill No. 112017). The bill is due in 15 days. Enter the bill. You take all work trucks to Chin's Gas and Oil. It costs $78.00 to refuel them. You use your MasterCard credit card to pay for the fuel. Pay bill that is due to Robertson's Associates for $315 with check #72. CAUTION: WATCH DATES CAREFULLY 7/7/21 7/12/21 7/15/21 7/18/21 Created a Solar Light Design for Doctor Offices of San Diego. The design took 4 hours. When you delivered the design Doctors Offices of San Diego paid you right away with check # 65412. The total amount of the check was $240. Sales Receipt number 103. Deposit to Undeposited Funds 7/18/21 7/20/21 7/20/21 7/20/21 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 PG&E $86.44 Cal Telephone $88.00 Enter journal entries for the following month-end accounting activity: 1. Expense one month of the property and equipment insurance. 2. Monthly depreciation on the fixed asset truck: $225 7/22/21 7/31/21 Bank Reconciliation. 7. Prepare the bank reconciliation using the following information: Opening Balance $5,000 Ending Balance $10,128.23 Reconciliation Date 7/31/21 The first 9 payments starting with $300 and ending with $108.09 appear on the bank statement. Payments: Deposits: The first 13 deposits starting with $175 and ending with $540 appear on the bank statement. Print the final bank reconciliation report to a pdf file. Reports to Run 8. Run the following reports. Export the reports to a pdf file and submit them to your instructor. 7/1/2021 Start Date 7/31/2021 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 Reciveable 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 * Bank reconcilation from step 7 above