create end of period spreadsheet

Laundromat Service business These are the transactions that occurred in the first month of their operation for the month of November, 2021. 1-Nov Owner invested $100,000 cash in business 2-Nov Purchase equipment for $11,500 with cash 3-Nov Purchase motor vehicle for $16,000 on account 4-Nov Paid motor vehicle insurance for the year $4,800 6-Nov Bill customers for laundry services $3,400 6-Nov Purchase supplies on account $7,220 10-Nov Received payment from customer on account $2,800 13-Nov Received cash of $5,300 for laundry services yet to be provided 15-Nov Collected $2,500 cash from customers to do laundry. 15-Nov Paid utilities expense $3,000 17-Nov Billed customers for laundry services $4,000 20-Nov Purchase supplies on account $7,750 21-Nov Owner withdrew cash of $1,000 for personal use 23-Nov Paid $6,320 to suppliers on account 26-Nov Received $3,755 from customers on account 30-Nov Purchase additional equipment $2000 on account Adjustment data: A Depreciation on equipment was $250 and motor vehicle, $2,000 B Motor vehicle insurance used up $400 Supplies on hand, $4,970 D Salaries owing, $2,500. E Unearned service revenue earned, $2,900