do this on a Microsoft Excel with picture provided Problem $2-2$B Preparing and posting journal entries;

preparing a trial balance P$1$ A$1$

At the beginning of April, Bernadette Grechus launched a custom computer

solutions company called Softworks. The company had the following transactions

during April.

a$.$ B$.$ Grechus invested $$65,000$ cash, office equipment with a value of $$5,750,$ and

$$30,000$ of computer equipment in the company in exchange for common

stock

b$.$ The company purchased land worth $$22,000$ for an office by paying $$5,000$

cash and signing a note payable for $$17,000.$

c$.$ The company purchased a portable building with $$34,500$ cash and moved it

onto the land acquired in $b_s$

d$.$ The company paid $$5,000$ cash for the premium on a two$-$year insurance

policy.

e$.$ The company provided services to a client and immediately collected $$4,600$

cash.

f$.$ The company purchased $$4,500$ of additional computer equipment by paying

$$800$ castrand signing a note payable for $$3,700.$

g$.$ The comvany completed $$4,250$ of services for a client. This amount is to be

received within $30$ days.

h$.$ The company purchased $$950$ of additional office equipment on credit.

i$.$ The company completed $$10,200$ of services for a customer on credit.

j$.$ The company purchased $$580$ of TV advertising on credit.

k$.$ The company collected $$5,100$ cash in partial payment from the client

described in transaction $i.$

The company paid $$1,800$ cash for employee wages.

m$.$ The company paid $$950$ cash to settle the payable created in transaction $h.$

n$.$ The company paid $$608$ cash for repairs.

o$.$ The company paid a $$6,230$ cash dividend.

Page $78$

p$.$ The company paid $$1,800$ cash for employee wages.

q$.$ The company paid $$750$ cash for advertisements on the web during April.

Required

Prepare general journal entries to record these transactions $($use account

titles listed in part $2).$

Open the following ledger accounts$-$their account numbers are in

parentheses $($use the balance column format$)$: Cash $(101)$; Accounts

Receivable $(106)$; Prepaid Insurance $(108)$; Office Equipment $(163)$;

Computer Equipment $(164)$; Building $(170)$; Land $(172)$; Accounts Payable

$(201)$; Notes Payable $(250)$; Common Stock $(307)$; Dividends $(319)$; Services

Revenue $(403)$; Wages Expense $(601)$; Advertising Expense $(603)$; and

Repairs Expense $(604).$ Post the journal entries from part $1$ to the accounts

and enter the balance after each posting.

Check $(2)$ Ending balances: Cash, $$17,262$; Accounts Receivable, $$9,350$;

Accounts Payable, $$580$

Prepare a trial balance as of the end of April.

$(3)$ Trial balance totals, $$141,080$