how to do post closing trial balance

how to do you put in the end of period spread sheet , income statement , retained earning statement and balance sheet ?

5. Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 2 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a retained earnings statement, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 3 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance. EXHIBIT A - CHART OF ACCOUNTS The chart of accounts for your consulting business is shown in Exhibit A. REQUIREMENTS: 1. Use Micros oft Office Excel application to create the charts of accounts, general journal, four-column general ledgers, end-of-period spreadsheet, unadjusted trial balance, adjusted trial balance, post-closing trial balance, income statement, retained earnings statement, and balance sheet. 2. Record September transactions on Page 1 of the general journal. 3. Post the journal to a ledger of four-column accounts. 4. Prepare an unadjusted trial balance as of September 30,2022 At the end of September, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). Insurance expired during Sep is $275. Supplies on hand on Sep 30 are $715. Depreciation of computer equipment for Sep is $330. Accrued receptionist salary on Sep30 is $325. Rent expired during Sep is $1,600. Unearned fees on Sep 30 are $3,210