There are two separate accounting questions. Each question is required to be solved separately using Excel . From the three months transactions Prepare:
In excel – journal entry for the three months
In excel – post the journal entry to ledgers and calculate one balance (total) amount for each account.
In excel – Prepare trial balance at the end of March
In excel – Prepare adjusting entries at the end of March (You have to prepare adjusting entries for the three months period – refer to Module 4)
In excel, prepare income statements, balance sheet and statement of retained earnings
In excel, prepare closing entries and post-closing trial balance
Leave a Reply