Hi, need help with this homework. I know thos might be lengthy. Would be great to get a balance sheet and Profit loss (SS Below)

Income Discounts Given Landscaping Services Installation Sales of Product Income Total Income Cost of Goods Sold Freight Shrinkage and Waste Total Cost of Goods Sold Gross Prot Expenses Bad debt expense Bank charges Stationary & Printing Professional License expense Gas and Electric Telephone Total Operating Expenses Net Operating Income Other IncomelExpense Depreciation expense NET INCOME Assets Checking $ Savings Accounts Receivable Other Current Assets Inventory Asset Prepaid Expenses Total Current Assets Fixed Assets Truck Accumulated Depreciation Original Cost TOTAL ASSETS Liabilities and Equity Accounts Payable Mastercard Other Current Liabilities: Board of Equalization Payable $ Loan Payable Total Current Liabilities Note Payable Total Liabilities Equy Total Equity TOTAL LIABILITIES AND EQUITY Using yourjournaireport identify the debits and credits on Sales Receipt SFt~ 103 to Dukes Basketball Camp. Enter all accounts debited in the journal entry rst. in anyr order. Accounts credited should be entered next. in any order, Account Debit Credit Enter quantity and asset value for inventory products on hand as of your final exam report date. TIP: You can enter the services within each category in any orde Item Qty Asset Value Design 0 $ v 0 $ Landscaping V 55 V 55 Pest Control Complete the Following Steps 1. Chart of Accounts Work 1A. Create the following new accounts in Craig's Design 81. Landscaping Service: Name: Professional license expense Sub-Account: This account should be a sub-account of Taxes & Licenses Tax Form Section: Other Business Expense NOTE: Account numbers are not used in the test drive company Name: Shrinkage and Waste SubAccount: This account should be a sub-account of Cost of Goods Sold Tax Form Section: Supplies 8i. Materials ~ COGS Description: Account for inventory Loss 15. Locate the two accounts with "depreciation" in the account name. Change the name on one of the accounts to "Depreciation expense". Change the name on the other account to "Accumulated depreciation". HINT: Be sure to change to correct one. Looit at account type/detail type to help you. You don't need to move either account. Just change the name. 2. Working with Sub-Customers: You get a call from David's Donuts. They have one store that is open and plan to open a second store soon. They want you to take care of the lawn and gardening work at their current and future stores. They would like all the invoices to come to one place. You decide to set up David's Donuts as a parent customer with a sub-customer for each location. In: Setup the parent customer - David's Donuts Enterprises Company Name David's Donuts Enterprises Customer Displayr David's Donuts Name 390 Rock Road Billing Address Westside, CA 93268 Shipping Address Same as billing Payment Terms axes Select this customer is taxable; and California (8%] for the default tax code. 25: Setup the first store as a sub-customer of David's Donuts Company Name David's Donuts Enterprises Customer Dis la p Y David's Donuts - Westside Is Sub-customer Select Pa rent: David's Donuts elect Bill parent customer Biiling Address 890 Rock Road (Same as parent] Westside, CA 93268 1201 Yummy Drive Westside, CA 93268 Shipping Address Payment Terms Tait Info: Select this customer is taxable; and California (3%] for the default tax code. Products and Services 3. Add the following Inventory Item product Products and Services 3. Add the following Inventory Item product Inventorv m Mosquito Repellent Category Pest Control 6/1/2023 Leave blank Inventor Asset V Inventory Asset Accou nt Organic Mosquito Repellent $25.00 (This is the price per can) Sales of Product Income Sales Tax Category Taxable - standard rate Purchasing . . 0r anlc Mos ulto Re ellent Information 3 q p $10.00 {This is the price per can) Cost of Goods Sold New Vendor: 4. Set up the following vendor. Company Name Landscape Licensing Services Vendor Dis la Landscape Licensing Services Name 68 Testing Avenue Address 313910555 (select track 1095) Payment Terms Net 15 Settings: 5. Go to the Account and Settings area and change the following settings: a. Change the Company name to your own name [Company tab) lo. Turn ON Custom transaction numbers for sales forms (Sales tab] c. Turn ON custom transaction numbers for purchase orders (Expenses tab) d. Turn OFF Pre-fr'liforms with previously entered content {Advanced tab) e. Turn OFF Automatically apply credits [Advanced tab} f. Extend the time of Sign me our ifinactl'vefar to 3 hours. (Advanced tab) Transactions: 6. Record the following transactions. CAUTION - WATCH DATES CAREFULLY Write a check from the Checklng Account to Landscape Llcenslng Services. This is to pay for your semi-annual landscape design license. The amount of the check is $300.00 and the term Is from today through the next 6 months. Check it 71. Create a purchase order P0-1005 to Hick's Hardware for: 6/3/23 - 50 cans of Mosquito Repellent, - 25 Sprinkler Pipes The following customers paid via their MasterCard credit card. Geeta Kalapatapu - Invoice 1033 - $619.10 Jeff's Jalopies - Invoice 1021 $81.00 HINT: Be sure that Undeposited Funds is selected in the Deposit to field. Deposit the credit card customer payments to the checking account. There is a 2% fee that is ta ken 6/5/23 out of the credit card payments. Record the fee at the time of the deposit. Hint: Leave "received Synn" quL 6/5123 Deposit remaining items to the checking account. 6/6/23 Receive the Rock Fountain ordered on PO 1002 from Tim Philip Masonry. The bill was included with the pump. Bill it 246 {or $125.00, terms Net 15. Received 20 of the Sprinkler Pipes and 40 cans of Mosquito Repellent and the related bill from Hicks Hardware ordered on PO-lOCiS. The bill includes an additional shipping cost of $15.00 that was not 6/9/23 on the PC. Add this to the Bill. Hint: You will have to add a new account - Freight expense [Cost of Good Sold Account Type; Subaccount of Cost of Goods Sold). Total Bill is $465.00. Terms are Net 15 and Bill No. 4341. Your lawn crew performed the weekly Gardening Service (Gardening) (Qty 1) at a rate of 5 45 and 2 6.19123 hours of Tree and Shrub Trimming (Trimming) at David's Donuts Westside store. You invoice them for the work on Invoice 1038. You receive the following hills in the mail: 6/12f23 - PG&E $91.25 for monthly gas and electric. Bill # 33357, Terms Net 15 - Cal Telephone 588.75 for monthly phone service. Bill ii 987, Terms Net 30 Mark Cho returns one of the sprinkler pipes sold to him on invoice ii 1035. there was nothing wrong 5/12/23 with it, he just did not need it for the project. You issue a Credit Memo, CM1035 for this. In the Sales Tax box - select California 8% as the tax rate. Duke's Basketball Camp hears you have a new Mosquito Repellent spray that would be great for the outdoor basketball camps they run. They want to buy 25 cans. They are going to pay upfront with 6/15/23 cash so you give them a 10% discount on the whole transaction (the discount box should be listed before tax). Create Sales Receipt Sit-103 and Use the Ca llfornia sales tax rate of 8%. Be sure the Deposit to account is Undeposited Funds. As you were packing up the order for Duke's Basketball camp you found 2 cans of Mosquito 6/18/23 Repellent that were broken. You return them to Hicks Hardware. They issue you credit memo for the two cans. RM4341. You are not getting great reports on the Mosquito spray. it is not as good as you hoped. You tell Hicks Hardware that you do not want the remaining cans of repellent on POIUOS. You do still want 6/19/23 the remaining sprinkler pipes. Mark the line for the Mosquito Repellent as closed. Make a note of how many cans of repellent were left to he received. CAUTION: WATCH DATES CAREFULLY iii/19123 You pay the bill4341 to Hick's Hardwarej applying the credit above using check #72. Received a payment from Mark the for the remaining balance on invoice #1035 less the credit 6.00123 memo. Check it 54123. Total check $309.96 HINT: Be sure to start from the customer record. Deposit all undeposited customer payments to the checking account. Make a note of the number of 6/20/23 payments included. Pay the following bills from your Checking Account. Starting with Check it 73 5'20/23 CAUTION: WATCH DATES CAREFULLY Pay the following bills from your Checking Account. Starting with Check it 73 CAUTION: WATCH DATES CAREFULLY 5/20/23 PG&E - $86.44 (be sure to select the right bill) Tim Philip Masonry $125.00 Rago Travel Agency asks you to install a new sprinkler system at their office. You install the new system at the travel agency. Create invoice #1039 with the following information: - 10 Sprinkler Heads 5/25/23 - 25 Sprinkler Pipes and - 7 hours of Installation - Choose California (8%) for sales tax rate Hint: Only products sold should be taxed. Term, Net 30 You are running low on business cards and office stationary. You ordered new cards and stationary 6/26/23 online from Quick Print using your MasterCard Account. Add the vendor using Quick Print in the Vendor display name field and the Company name field. The order totaled 5125.00 and will be delivered next clay. You expense this to the Stationary Er Printing expense account. You learn that Kookies by Kathy has gone out busineSs. They have one unpaid invoice for Gardening services. You will need to determine their account balance). You will have to write this off as bad debt. You review your company policy and the policy is to usethe direct method. You choose to do this via a credit memo (WOlODl) with the appropriate service mapped to the correct account. (Hint 6/30/23 you may have to create a new account in your chart of accounts, a new service, and a category. The category should be named "Other charges" and the account and service should be reective of what you are doing.) HINT: Use a QTY of 1 on the Credit memo and the amount in the Rate field and there is no sales tax on this writeoff. Apply this credit memo to the open invoice. You perform a physical inventory count. All items match your books except for the sprinkler heads. 6f30l23 You count 13. You will need to adiust your inventory for this. Use the Shrinkage and Waste account created earEier and A011 for the reference. 6f30l23 Review the following information for month-end and make any journal entries that might be appropriate. 1. Since the landscape design license was for a one-half of a year you meed will to amortize that appropriately and account for the current month's amortization of this professional ticense. [Journal no. Final-1) - 2. Monthly depreciation on the fixed asset truck: $112.50 (Journal no. Final-2) - No other month-end adjustments should be considered. Bank Reconciliation. 7. Prepare the bank reconciliation using the following information: Opening Balance $5,000.00 Ending Balance $7,176.84 M Date 6/30/23 The first 21 transactions listed on the payments tab starting with $300 and ending Payments: with $2000 to Brosnahan insurance appear on the bank statement. Deposits: All 14 transactions listed on the deposts tab appear on the bank statement. Print the final bank reconciliation report to a pdf file. Reports to Run 8. Run the foltowing reports, Export the reports to a pdf file. 6/1/2023 Start Date 6/30/2023 End Date Journal Report for the dates listed above. Balance Sheet Report for the dates listed above. Prot and Loss Report for the dates listed above. Customer Balance Detail Report for the date range ALL DATES. Accounts Payable Aging Detail Report as of the End Date listed above. Inventory Valuation Summary Report as of the End Date listed above. Open Purchase Order Detail Report for the date range ALL DATES. Sales by Product/Service Summary Report for the date range ALL DATES