ACCT305: Accounting Information Systems- John Brown Home Services- Report Writing Assignment

Internal Code: MAS7580

Report Writing Assignment:

Task: Mary Green is the owner of Greens Services. This Company provides service such as cleaning, car details, lawn and gardening to customers in North Sydney. The adjusted trial balance columns of the worksheet for Greens Services are as shown in Table 1 below. Table 1. Adjusted Trial Balance of John Brown Home Services Based on information provided above, please complete the following tasks: Create an excel file and name it as Your_Student_No.xlsx, e.g. S004123456.xlsx. Name each of the excel sheets as: • Trial Balance, • Income statement, • Changes in equity, • Balance sheet, and • Part E. A. Copy Table 1 to the Trial Balance excel sheet and complete the worksheet. B. Prepare an income statement on the Income statement excel sheet. C. Prepare a statement of changes in equity on the Changes in equity excel sheet D. Prepare a balance sheet on the Balance sheet excel sheet. E. What are the advantages and disadvantages using Excel spreadsheets for preparing financial reports? Give academic references to justify your answers. Type your answers on excel sheet Part E in NOT more than 600 words.