second and third pictures are the spreadsheet. please help with the ledger, the UNADJUSTED trial balance and ADJUSTED trial balance. thank you

und That Balance Ledger Download the attached SPREADSHEET and save the Exce) the to your computer Use the spreadsheet to post the May transactions from e uma af four column accounts. Be sure to save your work in Excel as it will be used to complete the following steps in Port of this problem an well as to in Part 2 or this problem. Your input into the spreadsheet will not be ncluded in your grade in Cengupenow on this problem 2 1 A. For each account in the post-cloning tribalance, enter the barice in the appropriate Balance colume of a four column account as me bulances May, enter Balance in the form column and select a check max the Posting Reference colum. Do not mean any in the stom column for any other is in the ledger Post the journal entries on page 5 and 6 of the journal to the ledger of four column accounts Enter the appropriate Posting was in the journal and the edger No entry is necessary in the column 6.8. Post the acutting entries to the indger Ender the appropriate Posting Perences in the journal and the odpor. No enty a necessary in me cam column dd Check My Work 2 more Check My Work uses remaining 72" - LMO 6 D E H Remember, this spreadsheet will not be part of your concerto gradie Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 11, 2016 UNADJUSTED TRIAL ADJUSTED TRIAL BALANCE ADIUSTMENTS BALANCE ACCOUNT TITLE DEBIT CREDIT DET CREDIT CHO INCOME STATEMENT DEBIT CHI SALANCE SHEET DET CREO Accounts Receivable Supplies Prepaid Rent Prepaid insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Uneamed Fees Icommon sto Retained Gaming Dividende Fees Earned Salary Expense Rent Expense Supplies Expo Depreciation Expense EP Work Sheet 724 LMO D Type here to search OTECTED VIEW Iechtern..content Editing D G H Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Fees Common Stock Retained Emin Dividends Fees Eamed Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense + Net income edges EoP Work Shot our Mark 21. Brightspace lo Sign On You G Google Diversity versus co Item Unadjusted Trial Balance 3. Prepare an unadjunted tre balance Accounts we borces can be letbank URADJUSTED TRIAL BALANCE May 31, 2018 COM 1 Gash 1 Accounts Rece Suges Prepaid Rent Prepadne Offset Acum Deciben Account Sea Omar Chow o - 3 P tigrumentMain.do?involer assignments&takeAssignmentSessionLocator assignme Your L. Brightspelo Sign On Wa G Google Diversity versus ce Unadjusted Trial Balance Erica Accounts Payable Staries Payable Uneamed Fees Il Cammon Stock Retained Earings 11 Dividends 1 Fees Earned Il Stary Expense Rent Expense 17 Supplies Experte Depreciation Expen mune E Miss Bee Check My Worloe Chow o O - men/takssignment Main.do/imaker assignments.takeAssignmentSessionLocator Mercan Your Mart 2L Brightspace La Sign On With Your G Google Diversity Perem Adjusted Telal Balance 7. Prepare an adusted til Dalance Accounts per ces can be a bank Kelly Coraline ADJUSTED TRUE BLANCE May 21, 2018 CREDIT 3 courts Supe Prepaid Part Office Acum cation Account O - LM 3 gnment/kassignment Main.do?invoker-assignmentsBtakeAssignmentSession Locator escan Your Mark 02. Brightspecielo Sign On With Your G Google Diversity Printem Adjusted Trial Balance Human Deprecation Actunts Payable Staries Payable Uneaned Fees 11 Commons Ruined Eurings Dividends 1 Fees Eamed 1 SayExpense Retete Supplies Experts Derationen incepe More 1 Check Chow o - und That Balance Ledger Download the attached SPREADSHEET and save the Exce) the to your computer Use the spreadsheet to post the May transactions from e uma af four column accounts. Be sure to save your work in Excel as it will be used to complete the following steps in Port of this problem an well as to in Part 2 or this problem. Your input into the spreadsheet will not be ncluded in your grade in Cengupenow on this problem 2 1 A. For each account in the post-cloning tribalance, enter the barice in the appropriate Balance colume of a four column account as me bulances May, enter Balance in the form column and select a check max the Posting Reference colum. Do not mean any in the stom column for any other is in the ledger Post the journal entries on page 5 and 6 of the journal to the ledger of four column accounts Enter the appropriate Posting was in the journal and the edger No entry is necessary in the column 6.8. Post the acutting entries to the indger Ender the appropriate Posting Perences in the journal and the odpor. No enty a necessary in me cam column dd Check My Work 2 more Check My Work uses remaining 72" - LMO 6 D E H Remember, this spreadsheet will not be part of your concerto gradie Kelly Consulting End-of-Period Spreadsheet (Work Sheet) For the Month Ended May 11, 2016 UNADJUSTED TRIAL ADJUSTED TRIAL BALANCE ADIUSTMENTS BALANCE ACCOUNT TITLE DEBIT CREDIT DET CREDIT CHO INCOME STATEMENT DEBIT CHI SALANCE SHEET DET CREO Accounts Receivable Supplies Prepaid Rent Prepaid insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Uneamed Fees Icommon sto Retained Gaming Dividende Fees Earned Salary Expense Rent Expense Supplies Expo Depreciation Expense EP Work Sheet 724 LMO D Type here to search OTECTED VIEW Iechtern..content Editing D G H Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Fees Common Stock Retained Emin Dividends Fees Eamed Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense + Net income edges EoP Work Shot our Mark 21. Brightspace lo Sign On You G Google Diversity versus co Item Unadjusted Trial Balance 3. Prepare an unadjunted tre balance Accounts we borces can be letbank URADJUSTED TRIAL BALANCE May 31, 2018 COM 1 Gash 1 Accounts Rece Suges Prepaid Rent Prepadne Offset Acum Deciben Account Sea Omar Chow o - 3 P tigrumentMain.do?involer assignments&takeAssignmentSessionLocator assignme Your L. Brightspelo Sign On Wa G Google Diversity versus ce Unadjusted Trial Balance Erica Accounts Payable Staries Payable Uneamed Fees Il Cammon Stock Retained Earings 11 Dividends 1 Fees Earned Il Stary Expense Rent Expense 17 Supplies Experte Depreciation Expen mune E Miss Bee Check My Worloe Chow o O - men/takssignment Main.do/imaker assignments.takeAssignmentSessionLocator Mercan Your Mart 2L Brightspace La Sign On With Your G Google Diversity Perem Adjusted Telal Balance 7. Prepare an adusted til Dalance Accounts per ces can be a bank Kelly Coraline ADJUSTED TRUE BLANCE May 21, 2018 CREDIT 3 courts Supe Prepaid Part Office Acum cation Account O - LM 3 gnment/kassignment Main.do?invoker-assignmentsBtakeAssignmentSession Locator escan Your Mark 02. Brightspecielo Sign On With Your G Google Diversity Printem Adjusted Trial Balance Human Deprecation Actunts Payable Staries Payable Uneaned Fees 11 Commons Ruined Eurings Dividends 1 Fees Eamed 1 SayExpense Retete Supplies Experts Derationen incepe More 1 Check Chow o