Once you have your adjusted trial balance, you can move the totals to the Income Statement columns for all revenue and expense accounts and to the Balance Sheet and owners’ equity columns for all asset, liability, and equity accounts. When you total the columns for the income statement, it will not balance. The difference is your net income. Be sure to review the worksheet in Chapter 4 to see how it presents the net income and make the two columns balance. The same will happen when you total the Balance Sheet columns.
Now you can prepare the income statement and the statement of owner's equity for the year ended April 30, 2009 and the classified balance sheet at April 30, 2009. Please be sure to prepare these in Excel as it is difficult to keep your columns straight and get your formatting correct in Word. Proper format counts. Please view examples in your textbook and make sure you prepare a classified balance sheet.
Be careful how many $ you use in your statements. They go before the first amount in each column and on the totals. Also make sure you underline before a calculation (example addition) and double underline at the end of the statement to show the end.