Prepare Income Statement In Excel

The following are the best excel templates you can use to record the income statement of your enterprise.
Prepare income statement in excel. The income statement is generally a record of income received and expenses incurred over that period. The income statement summarizes the results of a firm. Enter income in the cell at the top of the list. Enter each income source in a new cell of the excel spreadsheet and then list the total amount for the period in the adjacent cell.
The company s income sources include gross revenue interest revenues and other income. Create a subtotal at the bottom and label it total income. Companies can use the overall results to find the net profit or loss incurred for the period ended at the end of the year.