Mary Taylor opened Mary's Cleaning Service on July 1, 2017.During July, the company completed the following transactions:

July 1 Stockholders invested $20,000 cash in the business in exchange for common stock.

1 Purchased a used truck for $15,000, paying $2,000 cash and the balance on account.

3 Purchased cleaning supplies for $900 on account.

5 Paid $2,100 on a one-year insurance policy, effective July 1.

12 Billed customers $4,200 for cleaning services.

18 Paid $4,000 of amount owed on truck, and $450 of amount owed on cleaning supplies.

20 Paid $2,800 for employees' salaries.

21 Collected $3,000 from customers billed on July 12.

25 Billed customers $5,400 for cleaning services.

31 Paid gasoline for the month on the truck, $560.

31 Declared and paid a $800 cash dividend.

Required:

1. Journalize and post the July transactions in the Excel template located in the D2L site.Use page J1 for the journal
2. (b) Prepare a trial balance at July 31 in the Excel template located in the D2L site.