i will rate! The trial balance has 17 columns plus the balance at the end.

JOHN CONSULTING Trial Balance June 30, 2022 Debit Credit Cash $ 6,850 Accounts Receivable 7,000 Supplies 1,997 Prepaid Insurance 24880 Equipment 15,000 Accounts Payable $ 4,255 Unearned Service Revenue 5,200 Common Stock 21,997 Service Revenue 8,300 Salaries and Wages Expense 4,000 Rent Expense 2,025 $ 39,752 $ 39,752 39,752 39.752 In addition to those accounts listed on the trial balance, the chart of accounts for John also contains the following accounts: Accumulated Depreciation--Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense. and Supplies Expense. Other data: 1 2 3 4 Supplies on hand at June 30 total $ 720 A utility bill for $ 270 has not been recorded and will not be paid until next month. The insurance policy is for a year. Services were performed for $4,120 of unearned service revenue by the end of the month. Salaries of $ 1400 are accrued at June 30. The equipment has a 5-year life with no salvage value and is being depreciated at $ 250 per month for 60 months. Invoices representing $ 4.250 of services performed by John during the month have not been recorded as of June 30. 5. 6. 7 Prepare an adjusted trial balance at June 30, 2022. JOHN CONSULTING Adjusted Trial Balance Debit Credit $