I need help with the unadjusted trial balance and adjusted trial balance

On April 1, Jiro Nozomi created a new travel agency, Adventure Travel The following transactions occurred during the company's first month April 2. Motoni invented $34,000 cash and computer equipment worth $25,000 in the company April 3 The company rented furnished office space by paying $2,200 cash for the first month's (April) rent. April 4 The company purchased $1,200 of office supplies for cash. April 10 The company paid $3,000 canh for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,500 cash for two weeks' salaries earned by employees. April 24. The company collected $11,000 cash for commissions revenue. April 28 The company paid $1,500 cash for two weeks' salaries earned by employees. April 29 The company paid $500 cash for minor repairs to computer equipment. April 30 The company paid $850 cash for this month's telephone bill. April 30 Nozomi vithdrew $2,200 cash from the company for personal use. The company's chart of accounts follows: 101 Cash 403 Commissions Revenge 106 Accounts Receivable 612 Depreciation Expense-Computer Equipment 124 Office Supplies 622 Salaries Expense 128 Prepaid Insurance 637 Insurance Expense 167 Computer Equipment 640 Rent pense 168. Accumulated Depreciation-Computer Equipment 650 Office Supplies Expense 209 Salaries Payable 684 Repairs Expense 301 J. Nozomi, Capital 688 Telephone Expense 302 J. Nozoni, Withdrawals 901 Incone Summary Use the following information to prepare adjusting entries. a. Prepaid insurance of $167 expired this month. b. At the end of the month, $600 of office supplies are still available. c. This month's depreciation on computer equipment is $300 d. Employees earned $420 of unpaid and unrecorded salaries as of month-end. e. The company earned $1.950 of commissions revenue that is not yet recorded at month-end. Required: 1. & 2. Prepare journal entries to record the transactions for April and post them to ledger accounts in Reg 6B GL tab. The company records prepaid and unearned items in balance sheet accounts 3. Using account balances from Requirement 6b, prepare an unadjusted trial balance as of April 30. 4. Journalize the adjusting entries for the month, and then post to the ledger on Req 6B tab, using April 30 Adjusted as the date. 5a. Using adjusted account balances from Req 6B GL tab, prepare an adjusted trial baiance as of April 30 5b. Prepare the income statement for the month of April 30. 5c. Prepare the statement of owner's equity for the month of April 30. 5d. Prepare the balance sheet at April 30 6a. Prepare journal entries to close the temporary accounts and then post to Req 6B GL tab, using April 30 Close as the date 6b. Post the journal entries to the ledger, 7. Prepare a post-closing trial balance Complete this question by entering your answers in the tabs below. Reg 1 and 2 Req3 Reg4 Rec SA Reg 5 Reqs Red 50 Reg 6A Reg 68 GL Req7 Using account balances from Requirement 6b, prepare an adjusted trial balance as of April 30 ADVENTURE TRAVEL Unadjusted Trial Balance April 30 Complete this question by entering your answers in the tabs below. Req 1 and 2 Req3 Req 4 Req 5A Req 5B Req 5C Req 5D Using account balances from Requirement 6b, prepare an unadjusted trial balance as o ADVENTURE TRAVEL Unadjusted Trial Balance April 30 Account Title Debit Credit 1,200 3,000 25,000 59,000 101: Cash 106: Accounts receivable 124: Office supplies 128: Prepaid insurance 167: Computer equipment 168: Accumulated depreciation-Computer equipment 209: Salaries payable 301: J. Nozomi, Capital 302: J. Nozomi, Withdrawals 403: Commissions revenue 612: Depreciation expense-Computer equipment 622: Salaries expense 637: Insurance expense 640: Rent expense 650: Office supplies expense 684: Repairs expense 688: Telephone expense Total 2,200 11,000 3,000 2,200 500 850 37,950 $ $ 70,000 ger UNRE 4. Journalize the adjusting entries for the month, and then post to the date. 5a. Using adjusted account balances from Req GB GL tab, prepare an adjusted trial 5b. Prepare the income statement for the month of April 30. 5c. Prepare the statement of owner's equity for the month of April 30. 5d. Prepare the balance sheet at April 30. 6a. Prepare journal entries to close the temporary accounts and then post to Req6 date. 6b. Post the journal entries to the ledger. 7. Prepare a post-closing trial balance. Complete this question by entering your answers in the tabs below. Reg I and 2 Reg 3 Reg 4 Reg SA Red 5B Req 5C Req 5D Using adjusted account balances from Reg 6B GL tab, prepare an adjusted trial balanc ADVENTURE TRAVEL Adjusted Trial Balanco April 30 Account Title Debit Credit 101: Cash 106: Accounts receivable 124: Office supplies 128: Prepaid insurance 167: Computer equipment 168: Accumulated depreciation Computer equipment 209: Salaries payable 301: J. Nozomi, Capital 302: J. Nozomi, Withdrawals 403. Commissions revenue 612 Depreciation expense Computer equipment 622: Salaries expense 637. Insurance expense 640: Rent expense 650: Office supplies expense 684: Repairs expense 688: Telephone expense Total S s