Students are required to prepare Excel Spreadsheets with tabs for Journal Entrie

Question

Students are required to prepare Excel Spreadsheets with tabs for Journal Entries, T Accounts, Trial Balances, and Financial Statements.

Anyhelp with this would be amazing

Thanks

Requirments 1-4 are done but I need the rest, answers are on my last question but since it was only answered from 1-4 I am posting my question again

Requirements: 1) Using t Balanc Shoot information, ener h boginnin balances in the T-Accounts. 2) On the following sheet, use the Transaction Information to journalize entries, 1-10. 3) Post each entry into the T-Accounts. When finished journalizing, calculate the account balance for each T-Account. 4) Create an Unadjusted Trial Balance. 5) Journalize adjusting journal entries 1-4 6) Post Adjusting Journal entries to T-accounts 7) Prepare Adjusted Trial Balance 8) Prepare: a. Income Statement b. Statement of Owner's Equity c. Balance Sheet 9) Write the four closing entries, post them to the T-Accounts and determine the ending balance for each account. 10) Create the Post Closing Trial Balance from the T-accounts.

Explanation / Answer

4

Date Journal Dr Cr 1 Supplies expense 600 To Supplies [ 1000-400] 600 2 Insurance expense 300 To Prepaid insurance [3600 *1/12] 300 3 Wages expense 100 To Accrued wage    100 4 Service revenue 1000 To unearned revenue 1000

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---