Building An Income Statement In Excel

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.

Building an income statement in excel. Now let s see if we can replicate this formula based version using a pivottable. Companies can use the overall results to find the net profit or loss incurred for the period ended at the end of the year. Next let s take a look at a formula based income statement which retrieves the values with the sumifs function. The income statement is generally a record of income received and expenses incurred over that period.

Click the cell that you want to use to calculate your total in the income column select the list arrow and then choose the sum calculation. There are now totals for the income and the expenses. The second worksheet shown on the right is a multi step income statement that calculates gross profit and operating income. The following are the best excel templates you can use to record the income statement of your enterprise.

When you have a new income or expense to add click and drag the blue resize handle in the bottom right corner of the table. This income statement template was designed for the small business owner and contains two example income statements each on a separate worksheet tab see the screenshots the first is a simple single step income statement with all revenues and expenses lumped together. Enter income in the cell at the top of the list.