need help creating a journal for part 2 thank you

For the past several years. Samantha Hogan has cperated a part-time consuting business from her home. As of July 1 , 20 Y 9, Samantha docided to move to rented quarters and to operate the business, which was to be known as Arborvite Consuting, on a ful-time basis. Arbonite Consutting entered into the lollowing transactions during July. Jul. 1 The tolowing assets were received trom Samantha Hogan: eash, $25,700; acoounts recolvable, \$30, 200; supplies, \$5, 100; and olfice equipment, \$12, 100. There were no labilies received. 1 Paid three months' tent on a loase tental contract, 58,100 . 2 Paid the premiums on property and casualty insurance poicies, 56,100 . 3 Received cash troen clients as an advance payment for services to be provided and recorded it as unoarned tees, $10,800. 5. Putchased additional oflice equipment on account from Oetce Necessities Co, $6,900. 6 Peceived cash trom clents on account, $17,300. 10 Paid cash lor a newspsper atvedisement, 5680. 12. Paid Ortice Necessibes Co, tor part of the dobt incurred on July 5, 54,100. 12 Provided services on account for the period July 112,$10,200. 14 Paid receptionist tor two weoks' salary, $2,000 Pecord the following transactions on Page 2 of the journal- Ju. 17. Recoived cash from cash clents for tees earned during the period July 1-17, $14,100. 15. Paid cash for supplies, 51,400 . 20 Provided services on account for the period July 1320,$12,200 24. Recoived cash from cash clients for lees earned for the period July 1724,511,500. 26 Recelved eash from clients on account, $16,300. 27 Paid receptionist toe two weeks' salary, $2,000. 29. Paid telephone ble for July, $440. 31 Paid electricity bill for Juy, $910 31 Received cash trom cash clents far fees eamed for the period July is 31,$9,600. 31 Provided services on acoount for the remainder of July, $7,400 31 Samartha withdiew 527,100 foe perional use. Required: 1. Joumalize each transacton in a two-colum jouma/ stapting on Page 1, reforing to the chart of accounte in sebcting be accounte io be decited and cedied, (Do not insert the acownt munbers in the iournal at this time).) 1. Journalize each transaction in a wo-column journal starting on Page 1, referring to the charf of accounts in seiecting the accounts to be dobiled and credited. (Do not insert the account numbers in the foumal at this tirne) 2. Post the dily transactions. A. Download the spreadsheet in the Ledger panel and save the Excel Wis to your computer. Use the spreadsheet to post the Jul transactions trom the journal to a ledger of four-column accounts, 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 sprandshoot will not be included in your grade in CengageNOW on this problem. B. Add the appropriate posting reference to the joumal in Cengagenow. 3. Prepare an unadjusted trial balance. Accounts with zero balances can be ieft blank 4. At the end of duly, the following aqustment data were assembied. Anayze and use these data fo complete requiements (5) and (6) - Insurance expired during July as $510. - Supples on hand on duly 31 are 53.900 - Depreciation of omfee equpment for duly is $540 - Aocrued receptionist salary on thay 31 is $190 - Aent expined during Juy is $2,700 - Uneaned tees on iduy 31 are 54,100 8. Add the appropriate posting reilerence to the joumal in CengageNOW 3. Prepare an unadusted vial balance. Accounts with zero balances can be loft blank. 4. At the end of July, the following adfustment data were assembled. Arafyze and use these data to complete requirements (5) and (6). - Insurance expired during July is $510. - Supples on hand an July 31 are $3.900. - Depreciation of omce equipment lor duy is $540 - Accrued receptonist salary on duy 31 is \$190 - Rent expired during July as \$2,700. * Lhearned fees onduly are 34,100 . 5. (Optional) On your own paper or spresdaheet enter the unacfusted trial balance on an end-ol-period wokk shent and complefo the toreadtheet. Find a blank end-orpenad wark sheet in the Excel spreadsheet you praviously downiladed. 0. A. Journalze the adfusting enties on page 3 of the joumal Adjusting entiles are pecorded on Juy 31. B. Use the attached spreaditeot in the Ledger panel to post the adjusting entries to the ledger of loun-odimn accounts inserting balances is the accounts athected. Add the appropiate postry reference to the adfusting enthes in the foumal in CengagovOW. 7. Prepare an acfusted trial bulance. For the past several years, Samantha Hogan has operated a part-time consulting business from her home. As of July 1 , 20 y. Samantha decided to move to rented quarters and to operale the business, which was to be known as Arborvite Consuling, an a full-time basis: Arborvite Consuting entered into the following transactions during July. in Part i of this probleme the accounting cycle was completed up through the preparation of the adiustod trial balance. Pequired: 8. If you completed the end-ol-period work sheet in Part 1 , vse the adjusted frial batance figures to propare an income atatement, a statement of owner's equat, and a balance sheet for the month ended July 31, 20rg. If you dider complete the endtof periad work sheet in Rart 1 , use the ledger (the Eroel spreadaheet) to prepare an income statement, a statement of owner z equily, and a balance shoet for the month ended July 31 , abry." 'Be sure to read the instructions for esch francial statement carehily. 9. A. Joumailze the closing entries on page 4 of the joumal Closing entries are recorded an dily 31. B. Use the spraadsheet to post the closing entres to the ledger of four-colum accounts. Inserting balances in the accounts affoctied Add the apprepriate posting reference to the clasing entries in the foumal in Cengagenow. 10. Prepare a post-obsing trai balance. 9. A. Joumalize the ciesing eneries on page 4 of the joumat. Closing entries are recorded on July 31 , 9. B. Add the appropriate posting reference to the closing entries in the journal in CangageNOW. Refer to the chart of accounts for the exact wording of the account bites. CNOW joumals do not use lines for joumal explanations. Evecy line on a joumal page is used for debit or credt entries. CNOW joumals wit automadcaly indent a credit entry when a credt amount is antered. Complete accounting cycle, Part 2 Jounal