Just need help with ledger and unadjusted trial balance!

Instructions For the past several years, Steffy Lopez has operated a part-time consulting business from his home. As of July 1, 20Y2, Steffy decided to move to rented quarters and to operate the business, which was to be known as Diamond Consulting, on a full-time basis. Diamond entered into the following transactions during July: Jul. 1 The following assets were received from Steffy Lopez in exchange for common stock: cash, $14,000; accounts receivable, $20,800; supplies, $3,100; and office equipment, $7,000. There were no liabilities received. Paid two months' rent on a lease rental contract, $6,000. Paid the premiums on property and casualty insurance policies, $4,620. 1 2 Received cash from clients as an advance payment for services to be provided, and recorded it as unearned fees, $5,000. 5 10 12 12 14 Purchased additional office equipment on account from Office Station Co., $6,500. Received cash from clients on account, $15,000. Paid cash for a newspaper advertisement, $400. Paid Office Station Co. for part of the debt incurred on July 5, $5,200. Recorded services provided on account for the period July 1-12, $13,300. Paid receptionist for two weeks' salary, $1,750. Instructions Record the following transactions on Page 2 of the journal: Jul. 17 18 Recorded cash from cash clients for fees earned during the period July 1-17, $9,450. Paid cash for supplies, $600. 20 Recorded services provided on account for the period July 13-20, $6,750. Recorded cash from cash clients for fees earned for the period July 17-24, $4,500. 26 Received cash from clients on account, $12,000. 27 Paid receptionist for two weeks' salary, $1,750. 31 31 31 31 Paid telephone bill for July, $375. Paid electricity bill for July, $675. Recorded cash from cash clients for fees earned for the period July 25-31, $5,000. Recorded services provided on account for the remainder of July, $3,000. Paid dividends, $12,500. Instructions Required: 1. Journalize each transaction in a two-column journal starting on Page 1, referring to the chart of accounts in selecting the accounts to be debited and credited. (Do not insert the account numbers in the journal at this time.) 2. Post the journal to a ledger of four-column accounts. Add the appropriate posting reference to the journal. 3. Prepare an unadjusted trial balance. 4. At the end of July, the following adjustment data were assembled. Analyze and use these data to complete requirements (5) and (6). A. Insurance expired during July is $385. B. Supplies on hand on July 31 are $1,525. C. Depreciation of office equipment for July is $750. D. Accrued receptionist salary on July 31 is $175. E. Rent expired during July is $3,000. F. Unearned fees earned on July 31, $2,750. 5. (Optional) On your own paper or spreadsheet, enter the unadjusted trial balance on an end-of-period work sheet and complete the work sheet. 6. A. Journalize the adjusting entries on page 3 of the journal. Adjusting entries are recorded on July 31. Refer to the Chart of Accounts for exact wording of account titles. B. Post the adjusting entries, inserting balances in the accounts affected. Instructions Ledger Shaded cells have feedback. X Account No. 11 Account: Cash Account: Accounts Receivable Account: Supplies Account: Prepaid Rent Account: Prepaid Insurance Account: Office Equipment Account: Accumulated Depreciation Account: Accounts Payable Account No. 12 Account No. 14 Account No. 15 Account No. 16 Account No. 18 Account No. 19 Account No. 21 Account No. 22 Account: Salaries Payable Account: Unearned Fees Account: Common Stock Account: Retained Earnings Account: Dividends Account: Fees Earned Account: Salary Expense Account No. 23 Account No. 31 Account No. 32 Account No. 33 Account No. 41 Account No. 51 Account No. 52 Account No. 53 Account No. 54 Account No. 55 Account No. 59 Account: Rent Expense Account: Supplies Expense Account: Depreciation Expense Account: Insurance Expense Account: Miscellaneous Expense Unadjusted Trial Balance Shaded cells have feedback. Score: 0/62 Diamond Consulting UNADJUSTED TRIAL BALANCE July 31, 20Y2 ACCOUNT TITLE DEBIT CREDIT Cash Accounts Receivable Supplies Prepaid Rent 5 Prepaid Insurance 6 Office Equipment 7 Accumulated Depreciation Accounts Payable Salaries Payable 10 Unearned Fees 11 Common Stock 12 Retained Earnings 13 Dividends Shaded cells have feedback. X Unadjusted Trial Balance 6 Office Equipment 7 Accumulated Depreciation 8 Accounts Payable Salaries Payable 9 10 Unearned Fees 11 Common Stock 12 Retained Earnings 13 Dividends 14 Fees Earned 15 Salary Expense 16 Rent Expense 17 Supplies Expense 18 Depreciation Expense 19 Insurance Expense 20 Miscellaneous Expense 21 Totals