help please!! last two photos are the spreadsheet

Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2018 The accounting cycle for Kelly Consulting for April, including financial statements; was ilustrated in this chapter. During May Kelly Consulting entered into the following transactions May 3 5 Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, 54,500 Received cash from clients on account. 52 450 Paid cash for a newspaper advertisement $225 Paid Onice Station Co for part of the debt incurred on April 5, 5540 Recorded services provided on account for the period May 1-15,89 100 16 Paid part-time receptionist for hivo weeks slay including the amount owed on April 30,5750 17 Recorded cash from cash clients for fees earned during the period May 1-16, 58,360 13 15 Record the following transactions on Page 6 of the journa May Purchased supplies on account, $735 Rando as formand Man 20 Check My Work 2 more Check My Work uses remaining Next 11:07 PM 1/11/2001 9F 778 A LMO o Record the following transactions on Page 6 of the Journal May 20 21 25 27 28 Purchased supplies on account, $735. Recorded services provided on account for the period May 16-20, 54,820 Recorded cash from cash clients for fees earned for the period May 17-23. $7,900. Received cash from clients on account $9,520 Paid part-time receptionist for two weeks' salary, $750 Paid telephone bill for May, 5260 Paid electricity bill for May, 5810. Recorded cash from cash clients for fees earned for the period May 26-31, 53,300 Recorded services provided on account for the remainder of May, $2,650. Paid dividends, $10,500 30 31 31 31 31 Required: . Check My Work 2 more Check My Work uses remaining OPC > Record the following transactions on Page 6 of the Journal May 20 21 25 27 28 Purchased supplies on account, $735. Recorded services provided on account for the period May 16-20, 54,820 Recorded cash from cash clients for fees earned for the period May 17-23. $7,900. Received cash from clients on account $9,520 Paid part-time receptionist for two weeks' salary, $750 Paid telephone bill for May, 5260 Paid electricity bill for May, 5810. Recorded cash from cash clients for fees earned for the period May 26-31, 53,300 Recorded services provided on account for the remainder of May, $2,650. Paid dividends, $10,500 30 31 31 31 31 Required: . Check My Work 2 more Check My Work uses remaining OPC > Required: 1. The chart of accounts is shown in a separate panel and the post-closing trial balance as of April 30 2018, is shown below, A Download the spreadsheet in the Ledger panel and save the Excel file to your computer. Be sure to save your work in Excel as it will be used to complete the following steps in Part 1 of this problem as well as steps in Part 2 of this problem. Your input into the spreadsheet will not be included in your grade in CengageNow on this problem. For each account in the post-closing tria/ datance, under the balance in the appropriate Balance column of the four-column account Date the balances May 1, enter Balance in the tem column and select a check mark in the Posting Reference column B. Journalize each of the May transaction in the wo-column Journal starting on Page 5 of the journal. Refer to the Chart of Accounts for exact wording of account title (Do not insert the account numbers in the journal at this time) 2. Post the journal entries on papes 9 and 6 of the journal to the wedger of tow.colum accounts. Enter the appropriate Posting Patiences in the Journal and the fedper. No entry is necessary in the tem column 3. Prepare an unadjusted trial balance 4. At the end of May, the following adjustment data were assembled Analyze and use these data to complete parts (1) and (8) Insurance expired during May Is $275 Supplies on hand on May 31 are 5715. Next THE PM Check My Work 2 more Check My Work uses remaining + 9F 775 A 18 3 4 o LMO 6 . journal and the ledger No entry is necessary in the tem column 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled Analyze and use these data to complete parts (1) and (6) Insurance expired during May is $275 Supplies on hand on May 31 are 5715 Depreciation of office equipment for May is 5330 Accrued receptionist salary on May 31 is $325 Rent expired during May is $1.600 Unearned foes on May 31 are 53210 5. (Optional) on your own paper or spreadsheet enter the radiated in balance on a tocoum end-o period spreadsheet (work show and complete the spreadsheet 6. A Journalize the adjusting entries on Page 7 of the journal. Refer to the Chart or Accounts for exact wording of account sites B. Poat the adjusting entries to the ledger Enter the appropriate Posting References in the journal and the edper. No entry is moessary in the em column 7. Prepare an adjusted trial balance Check My Work 2 more Check My Work uses remaining Next 11:00 PM F 118/202 9'F @ 4 II LMO 678 3 C 7. Prepare an adjusted trial balance Kelly Consulting POST-CLOSING TRIAL BALANCE April 30, 2018 CREDIT ACCOUNT TITLE DET 22,100.00 1 Cash 3.400.00 1 Accounts Receivable 1.350.00 3,200.00 1.500.00 Supplies Prepaid Rent 5 Prepaid Insurance Office Equipment 1 Accumulated Depreciation 14,500.00 330.00 Instructions 3,200.00 1.500.00 14.500.00 - Prepaid Rent Prepaid Insurance + Office Equipment 1 Accumulated Depreciation Accounts Payable Salaries Payable 10 Uneamed Fees 330.00 800.00 120.00 2,500.00 11 Common Stock 30,000.00 13 Retained Earnings 12.300.00 13 Dividends 14 Income Summary 46,050.00 46,050.00 15 Totals CHART OF ACCOUNTS Kelly Consulting General Ledger ASSETS REVENUE 41 Fees Earned 11 Cash 12 Accounts Receivable 14 Supplies 15 Prepaid Rent 16 Prepaid Insurance 18 Office Equipment 19 Accumulated Depreciation EXPENSES 51 Salary Expense 52 Rent Expense 53 Supplies Expense 54 Depreciation Expense 55 Insurance Expense 59 Miscellaneous Expense LIABILITIES 21 Accounts Payable 22 Salaries Payable 22 linearned Fees 15 Prepaid Rent 16 Prepaid Insurance 18 Office Equipment 19 Accumulated Depreciation 51 Salary Expense 52 Rent Expense 53 Supplies Expense 54 Depreciation Expense 55 Insurance Expense 59 Miscellaneous Expense LIABILITIES 21 Accounts Payable 22 Salaries Payable 23 Unearned Fees