Accounting eqn soln

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.