Complete everything on a google sheet or excel sheet with proper date format as well. Provided below! Please provide answers for each transactions. Please provide the Google sheet link or a excel download file with all the accurate answers. Thank you! Please use the below template to record each transaction accurately. Introduction: The Secret Garden

Adelaide & Carol have been dreaming about opening a flower supply shop together for years. They decide to start The Secret Garden as a part-time project, and will focus on selling luxury dried floral bouquets. The company has recently experienced various significant financial transactions, and we will explore the accounting implications of these events. Their accounting period runs from December 1^st to November 30^th.

PART 1:

1. December 1, 2021:
   • Adelaide and Carol compile funds for the start of their new partnership. Adelaide has more savings and invests $15,000, while Carol invests $10,000. They both agree that their salary will be $2,000 each in the first year and $7,500 each for every following year. Each year, any remaining income will be split in accordance with their percentage of capital investment.
2. December 10, 2021:
   • The Secret Garden purchases 100 bouquets at $12,500 + HST. As they are a new client of the supplier, The Secret Garden pays immediately by cheque.
3. January 20, 2022:
   • The Secret Garden sells 50 bouquets to a customer for $9,000 + HST. The customer pays immediately for the items.
4. February 15, 2022:
   • The Secret Garden makes a bulk purchase of $800 worth of cleaning supplies, exclusive of HST. They anticipate that these supplies will last for an extended period.
5. February 22, 2022:
   • The Secret Garden sells 32 bouquets to a customer for $8,300 + HST. The customer pays immediately for the items.
6. March 1, 2022:
   • The Secret Garden purchases a new computer for business use. They paid $1,130, including HST, and expect to use this computer for the next 5 years. The salvage value is estimated to be $400.
7. March 3, 2022:
   • The Secret Garden purchases 200 more bouquets at $21,600 + HST. As they are a repeat client of the supplier, they pay half immediately, and place the rest of the bill on account. This remaining sum is settled on March 30, 2022.
8. May 6, 2022:
   • The Secret Garden prints some business cards to use. The company owners are still uncertain about the design of the new company logo, so they have decided on a small batch of cards as a "test run". The cost comes to $425 + HST.
9. June 25, 2022:
   • The Secret Garden sells 46 bouquets to a repeat customer for $9,800 + HST. The customer pays $8,000 immediately by credit card. The merchant fee is 5%. The customer puts the rest on account with terms of net 30.
10. August 23, 2022:
    • Adelaide and Carol decide to hire a company to run a series of social media campaigns to help increase their current customer base. The fee for the campaign is $5,000 + HST. The campaign also involves $600 + HST of various goods and gift baskets as giveaway prizes.
11. September 16, 2022:
    • Carol has been attempting to reach the customer (#9) for months regarding their outstanding invoice. She finally decides to write off the remaining sum.
12. October 1, 2022:
    • The Secret Garden has found a small booth at a local weekly market to host their business. The cost to rent the booth is $650 per month, and the additional storage space at the location is $100 per month. Their contract states that they will pay for 5 months of rent upfront, and then will pay at the start of each ongoing month.
    • For the most part, Carol & Adelaide will be stationed at the booth themselves. However, for the hours that they are unavailable, The Secret Garden has hired a part-time employee for a salary of $500 per month, to be paid on the 15^th of each month.
13. November 1, 2022:
    • Unfortunately, Adelaide and Carol are not satisfied with the computer they have purchased. They are eligible for a trade in to upgrade the computer on December 1, 2023. The resale value of their current computer is $800, but with a $500 additional fee, they can upgrade to a new computer model with a fair market value of $1,500. After much discussion, Adelaide and Carol decide to sell off the computer for its current market value. They will reconsider purchasing another computer in the future.
14. November 20, 2022:
    • The Secret Garden prepares to bring their taxes to their accountant for the year-end file. Their accountant bills them $1,650 for their bookkeeping, taxes, and HST remittance this year. The Secret Garden still has $200 worth of cleaning supplies remaining (from transaction #4), and luckily was able to acquire $1,000 on October 20^th for a long-overdue bill (transaction #9/#11). The accountant informs Adelaide & Carol that the income tax is 11% and due three months after their year-end.
    • Adelaide & Carol would like to see the Trial Balance, Income Statement, and Balance Sheet so that they can plan for the year ahead.
15. December 1, 2022:
    • All outstanding tax balances/refunds are settled immediately, and The Secret Garden is ready for the upcoming year!
    • Adelaide and Carol are very excited for the year ahead! The have decided that to continue with renting their booth & storage, and with hiring their part-time employee.
16. December 5, 2022:
    • After analyzing the prior year's financials, Adelaide and Carol realize they need to plan for bad debt. This year, they anticipate that 5% of sales on credit will be uncollectible.
17. December 12, 2022:
    • Christmas season is very busy. The Secret Garden makes the following sales at a single vendor market:
    • 52 bouquets for $13,800 + HST, paid immediately by credit card, with a merchant vendor fee of 5%
    • 65 bouquets for $16,000 + HST, paid on account
    • 29 bouquets for $9,250 + HST paid immediately by cash
18. January 30, 2023:
    • The customers from the Christmas vendor market (#17) pay their full balance.
19. March 15, 2023:
    • Adelaide and Carol are facing some big changes in their life: Adelaide is moving to another city, and Carol is returning to school for her Master's degree. Due to these changes, they decide that they will start preparing for the dissolution of their company:
    • Adelaide and Carol decide that they will let go of their part-time employee & terminate their rental space at the end of the month.
    • At this point in time, the Secret Garden has used up most of their expendable assets. All that remains is inventory.
20. March 26, 2023:
    • Adelaide and Carol sell 15 bouquets for $2,500 + HST, paid immediately in cash.
    • The remaining bouquets they sell at discount to a charity that sends gift baskets to elderly and ill individuals. Those bouquets are sold at $500 + HST total.
21. March 31, 2023:
    • The Secret Garden hires a cleaner to clear out their booth and rental space. The total cost is $120 + HST.
22. April 2, 2023:
    • The Secret Garden pays off all outstanding fees and writes off all uncollectible balances.
23. April 21, 2023:
    • Adelaide and Carol bring their books to the accountant for bookkeeping, taxes, HST remittances, and any other work necessary to dissolve their company. The accountant charges $1,400 + HST.
24. April 30, 2023:
    • The accountant settles all tax refunds/balances, and splits all remaining money between Adelaide & Carol. Adelaide & Carol receive a copy of the Trial Balance, Income Statement, and Balance Sheet.

Template to use:

Google Sheet Link: https://docs.google.com/spreadsheets/d/1mv_q3OMwY0YIC7c9h6AMom_RZ_p2B8QKLpeePWnMPnE/edit?usp=sharing If Google Sheet link doesn't work. Use the below Template. Template:

Transactions #	Date	Account	Debit	Credit	Memo
1
1
1
2
2
2
3
3
3
3
3
4
4
4
5
5
5
5
5
6
6
6
7
7
7
7
7
7
8
8
8
9
9
9
9
9
9
9
10
10
10
11
11
12
12
12
12
12
12
13
13
13
13
13
13
13
14
14
14
14
14
14
14
14
14
14
14
14
14
14
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
15
15
15
15
15
15
15
15
15
15
15
15
15
15
15
16
16
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
17
18
18
19
19
19
19
20
20
20
20
20
20
20
20
20
20
21
21
21
22
22
23
23
23
24
24
24
24
24
24
24
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Closing
Dissolution
Dissolution
Dissolution
Inventory
		PUCHASE	SALE	ENDING BALANCE
Transaction #	Date	Unit Amount	Unit Cost	Total Cost	Unit Amount	Unit Cost	Total Cost	Unit Amount	Unit Cost	Total Cost