Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1/1/22 Write a check from the Checking Account to Landscape Licensing Services. This is to pay for your semi-annual landscape design license. The amount of

1/1/22 Write a check from the Checking Account to Landscape Licensing 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 # 71. 1/4/22 Create a purchase order to Hick's Hardware for: - 50 cans of Mosquito Repellent, - 1 Rock Fountain and - 1 Pump. Number - PO-1005 and amount is $785.00. 1/4/22 The following customers paid via their MasterCard credit card. Travis Waldron - Invoice 1032 - $414.72 Jeff's Jalopies - Invoice 1022 - $81.00 HINT: Be sure that Undeposited Funds is selected in the Deposit to field. 1/4/22 Deposit the credit card customer payments to the checking account. There is a 2% fee that is taken out of the credit card payments. Record the fee at the time of the deposit. Amount of the deposit is $485.81 Hint: Leave "received from" blank. 1/4/22 Deposit remaining 2 items to the checking account. Amount of deposit is $2,062.52. 1/6/22 Receive the pump ordered on PO 1002 from Tim Philip Masonry. The bill was included with the pump. Bill # 246 for $125.00, terms Net 15. 1/7/22 Received 1 Rock Fountain and 40 cans of Mosquito Repellent and the related bill from Hicks Hardware ordered on PO- 1005. The bill includes an additional shipping cost of $15.00 that was not on the PO. Add this to the Bill. Hint: You will use the new account created Freight. Total Bill is $660. Terms are Net 15 and Bill No. 4341. 1/9/22 Your lawn crew performed the weekly Gardening Service (Gardening) (Qty 1) at a rate of $ 45 and 2 hours of Tree and Shrub Trimming (Trimming) at David's Donuts Westside store. You invoice them $115 for the work on Invoice 1038. 1/10/22 You receive the following bills in the mail: - PG&E $87.25 for monthly gas and eclectic. Bill # 33367, Terms Net 15 - Cal Telephone $71.75 for monthly phone service. Bill # 987, Terms Net 30 Final For Students

Date Transaction 1/12/22 Mark Cho returns one of the sprinkler pipes sold to him on invoice # 1035. There was nothing wrong with it, he just did not need it for the project. You issue a Credit Memo, CM1035 for this in the amount of $4.32. In the Sales Tax box - select California 8% as the tax rate. 1/15/22 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 cash so you give them a 10% discount on the whole transaction (make sure that the discount box is listed after tax). Create Sales Receipt SR-103 and Use the California sales tax rate of 8% and discount of 10% for a total invoice amount of $612.50. Be sure the Deposit to account is Undeposited Funds. 1/18/22 As you were packing up the order for Duke's Basketball camp you found 2 cans of Mosquito Repellent that were broken. You return them to Hicks Hardware. They issue a vendor credit for the two cans. Ref no. RM4341. Hint: this will be under Items 1/19/22 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 PO-1005. You do still want the remaining Fountain Pump. Mark the line for the Mosquito Repellent as closed. Make a note of how many cans of repellent were left to be received. 1/19/22 You pay the bill 4341 to Hick's Hardware, applying the credit above using check #72 for the amount of $634.00. CAUTION: WATCH DATES CAREFULLY 1/20/22 Received a payment from Mark Cho for the remaining balance on invoice #1035 less the credit memo. Check # 54123. Total check $309.96. Hint: remember to leave receive amount blank then unclick both the invoice and credit memo then 1/20/22 Deposit all undeposited customer payments to the checking account. Deposit amount $922.46. 1/20/22 Pay the following bills from your Checking Account. Starting with Check # 73 CAUTION: WATCH DATES CAREFULLY PG&E - $86.44 (be sure to select the right bill) Tim Philip Masonry $125.00 1/25/22 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 #1040 with the following information: - 10 Sprinkler Heads - 20 Sprinkler Pipes and - 8 hours of Installation - Choose California (8%) for sales tax rate Hint: Only products sold should be taxed. - Invoice total $508.00 Term, Net 30 1/26/22 You are running low on business cards and office stationary. You ordered new cards and stationary online from Quick Print using your MasterCard Account. The order totaled $125.00 and will be delivered next day. You expense this to the Stationary & Printing expense account. 1/31/22 You learn that Kookies by Kathy has gone out business. They have one unpaid invoice. You will have to write this off as bad debt. You review your company policy and the policy is to use the direct method. 1) You choose to do this via a credit memo (WO1001). The amount of the write-off is $75 . Hint: Use the new service item that you created. 2) Next, you apply this credit memo to the open invoices by using the receive payment form. Total of the receive payment should be $0. Hint: leave payment method blank. 1/31/22 You perform a physical inventory count. All items match your books except for the sprinkler heads. You count 13. You will need to adjust your inventory for this. Use the Shrinkage and Waste account created earlier. Hint: hit Save, the click on More to review the Transaction Journal. Amount should be $1.50. 1/31/22 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 will to amortize that appropriately and account for the month's amortization of this professional license. (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. Final For Students

Check Balances 7. Here are a few balances to check to see if you completed the above correctly: Cash A/R Total Assets A/P Gross Profit Net Income Bank Reconciliation. $3,526.35 (at 1/31/22) $5,019.52 (at 1/31/22) $23,937.12 (at 1/31/22) $1.675.23 (at 1/31/22) $777.00 (for the period 1/1/22 - 1/31/22) $245.59 (for the period 1/1/22 - 1/31/22) 8. Prepare the bank reconciliation using the following information: $5,000.00 $6,971.75 1/31/22 The first 21 payments starting with $300 and ending with $2000 to Brosnahan Insurance appear on the bank statement. (Total Payments - $4770.39). All deposits appear on the bank statement (Total Deposits - $6,742.14) Print the final bank reconciliation report to a pdf file. 9. Run the following reports. Export the reports to a pdf file and submit them to Canvas. Opening Balance Ending Balance Reconciliation Date Payments: Deposits: Reports to Run 1/1/2022 1/31/2022 Start Date 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 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 for the date range ALL DATES * Bank reconciliation from step 8 above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Primary English Audit And Test

Authors: Sue Reid, Angela Sawyer, Mary Bennett-Hartley

4th Edition

1446282759, 978-1446282755

More Books

Students also viewed these Accounting questions

Question

Explain the need for fi nancial management in business.

Answered: 1 week ago

Question

Additional Factors Affecting Group Communication?

Answered: 1 week ago