DO IT ON EXCEL

DO EVERYTHING ON EXCEL WITH ITA JOURNAL ENTRY, THE TRIAL BALANCE (BEGINNING BALANCE, MONTHLY ACTIVITY, ENDING BALANCE), INCOME STATEMENT, RETAINED EARNINGS STATEMENT, AND BALANCE SHEET

1.
Prepare April Journal Entries as T accounts and Regular Journal entries. Don’t forget descriptions and date. JTT is a licensed CPA. During the
first month of operations of her business, the following events and transactions occurred.
a)
b)
c)
d)
e)
f)
g)
h)
i)
j)
k)
April 2, Invested $73,600 cash and equipment valued at $32,200 in the business.
April 2, Hired a secretary-receptionist at a salary of $667 per week, payable monthly.
April 3, Purchased supplies on account $1,610. (Debit an asset account.)
April 7, Paid office rent of $1,380 for the month.
April 11 Completed a tax assignment and billed client $2,530 for services rendered. (Use Service Revenue account.)
April 12 Received $7,360 advance on a management consulting engagement.
April 17 Received cash of $5,290 for services completed for Calunga Co.
April 21 Paid insurance expense $253.
April 30 Paid secretary-receptionist $2,668 for the month.
April 30 A count of supplies indicated that $276 of supplies had been used.
April 30 Purchased a new computer for $14,030 with personal funds. (The computer will be used exclusively for business purposes.)