Case study: Apply the accounting cycle and worksheet using excel
Budget: $10 – $30 USD
Required: Apply the accounting cycle and worksheet using excel
1. Analyze business transaction
2. Journalize the transaction
3. Post to Ledger accounts.
4. Prepare an unadjusted trial balance
5. Journalize and post adjusting entries.
6. Prepare an adjusted trial balance
7. Prepare the 3 financial statements (Income Statement, retained earnings statement,
Statement of Financial position) following the standards.
8. Journalize and post closing entries
9. Prepare a Post-closing trial balance
1. Analyze business transaction
2. Journalize the transaction
3. Post to Ledger accounts.
4. Prepare an unadjusted trial balance
5. Journalize and post adjusting entries.
6. Prepare an adjusted trial balance
7. Prepare the 3 financial statements (Income Statement, retained earnings statement,
Statement of Financial position) following the standards.
8. Journalize and post closing entries
9. Prepare a Post-closing trial balance