Given Data
May
1 Cash invested in company $60,000
1 Cash paid for may rent $3,200
3 office equipment purchased on credit $1,680
5 Cash paid for May cleaning services $800
8 Cash collected for services provided $4,600
12 provided services on credit $3,000
15 Cash paid for assistants salary (1st half of May) $850
20 Cash received for servives provided May 12 $3,000
22 Provided services on credit $2,800
25 Cash recevied for services provided May 22 $2,800
26 Cash Paid for office equipment Purchased May 3 $1,680
27 Purchased May Advertising payment due June 1 $60
28 Cash paid for assistant salary (2nd half of May) $850
30 Cash paid for May telephone bill $200
30 Cash paid for May Utilities $480
31 Cash paid for dividends $1,200
Check figures
(2) Ending Balances $61,140
Cash $6,440
Expense
(3) Net income 3960
Total Assets $62,820
I need this in a spread sheet form that says
Asset = Libilities + Equity
The sub heading would be
Cash, Account Receivable, office equipment, Accounts payable, Common Stock, dividends, Revenue, and Expenses.
