Income Statement Format: Single-Step and Multi-Step Layouts

A lender, a partner, or your own month-end close asks for an income statement, and the sheet is a flat list of expenses. The income statement format is what makes that period readable.

Single-step shows one result: money in minus money out. Multi-step also shows gross profit and operating income. You need those lines when you sell products and want to see whether the problem is margin or overhead. The rows and formulas below are a management layout, not a tax filing or an SEC report.

Income Statement Format: Single-Step and Multi-Step Layouts

Pick the Income Statement Format You Actually Need

Put the period in the header before you type a number. An income statement covers a span of time, such as "For the year ended December 31, 2025" or "For the month ended September 30, 2026." A date with no range reads like a balance sheet.

Use a single-step income statement format when the business sells services and you only need net income. Add every revenue line, add every expense line, and subtract once.

Use a multi-step income statement format when you buy goods to resell or make products. Net sales minus cost of goods sold is gross profit. If that line is missing, you cannot tell a weak margin from high rent.

• Gross profit answers whether the goods themselves made money.

• Operating income answers whether the day-to-day business made money after wages, rent, and similar costs.

• Net income is what remains after interest and income tax.

Returns and allowances reduce sales. They are not an operating expense. Interest income and interest expense sit after operating income, not inside cost of goods sold.

Single-step stack beside gross profit

Build a Multi-Step Income Statement Format

Type labels in column A and amounts in column B. Totals are formulas, so a changed sales figure updates the rest of the sheet. The sample below is for reference only. Enter the same formulas in WPS Spreadsheet or Excel.

1. Header: company name, the words Income Statement, and the period.

2. Net sales in B1. If you track returns, use a cell for sales and a cell for returns, then set net sales to sales minus returns.

3. Cost of goods sold in B2. For a shop, that is beginning inventory plus purchases minus ending inventory. For a service firm with no inventory, skip this format and use the single-step layout.

4. Gross profit in B3: =B1-B2.

5. Operating expenses in B4. Wages, rent, utilities, and office costs go here. A simple retail sheet can put depreciation here too. A factory may need part of depreciation inside cost of goods sold instead.

6. Operating income in B9: =B7-B8. On the sample, gross profit 3,500 minus operating expenses 900 is 2,600.

   

   Sample multi-step income statement sheet

7. Add a row for other income and other expenses, such as interest, when the amount is not zero. The sample omits that row. Income before tax is operating income plus other income minus other expenses.

8. Income tax in the next amount cell. Net income is income before tax minus tax. On the sample, operating income 2,600 minus tax 700 is 1,900, so B11 is =B9-B10.

Do not subtract tax from the operating-expense total. That hides operating income and makes the period look less profitable than the core business was.

Build a Single-Step Income Statement Format

A single-step income statement format is enough for a freelancer, a consultant, or any period where gross profit would not change a decision.

1. List revenues and gains: fees, service income, and similar inflows. Put the total in one cell with =SUM over those rows.

2. List expenses and losses under that total: software, contractors, rent, and income tax if you want one bottom line only.

3. Net income is total revenues minus total expenses. One subtraction, no gross profit line.

The tradeoff is real. A single-step sheet will not show whether you made money on the work itself or only after a one-time gain. If a product line appears later, switch that period to the multi-step rows instead of forcing cost of goods sold into a miscellaneous expense.

If you want a ready visual starting point for a profit and loss sheet, the profit and loss statement templates are a separate download. Still replace the sample months with your period and your figures.

Revenues expenses and net income

Review the Income Statement Format Before You Share It

Run this check on the finished sheet. It catches the mistakes that make a tidy layout misleading.

• Period. The header names a month, a quarter, or a year. It is not a single "as of" date.

• Subtotals. On a multi-step sheet, gross profit equals net sales minus cost of goods sold, and operating income equals gross profit minus operating expenses. Change one input and confirm the formulas move.

• Net income. Tax is subtracted after income before tax. A negative result is a net loss. Label it that way instead of hiding the minus sign.

Round to the currency you actually keep in the books. A projection with sparklines is not a statement of what happened until you replace the sample numbers. Keep a copy of the workbook, and export PDF only after the totals match your source records.

Period subtotals and net income

The Best Free Office Alternative: WPS Office

You can build this income statement format in WPS Spreadsheet with the same cell formulas you would type in Excel. The sheet, the number formats, and a later PDF export stay in one suite.

	WPS Spreadsheet	Excel
Quick access	SUM, number formats, and the formula bar are on the sheet as soon as the file opens.	The same formulas, often behind a Microsoft 365 sign-in on a new PC.
Statement layout	You type the income statement rows once and lock every total with a formula.	Templates exist, but a blank workbook still needs this row structure.
All-in-one	Writer and PDF sit in the same install if you later export or explain the statement.	Excel handles the grid. A separate PDF step is common when you send a fixed copy.
File you can share	Save as .xlsx so an accountant can open it in Excel.	Native .xlsx. Binary and macro files are a different job.
Cost to start	Free to start on desktop for this formula sheet.	Current desktop Excel is part of a Microsoft 365 subscription.

• The income statement format is just rows and formulas, so you are not locked to one brand of spreadsheet.

• Save .xlsx and the totals travel with the file.

• You can start on the free desktop app, then export a PDF when the check above passes.

Open WPS Spreadsheet, enter the labels, and fill only the input cells. Leave gross profit, operating income, and net income as formulas.

WPS Spreadsheet workbook and file formats

FAQs

Which income statement format should a small shop use?

Use multi-step if you buy goods to resell and need gross profit. Use single-step if you sell services and only need net income for the period.

Where does cost of goods sold go?

On a multi-step sheet it sits under net sales, before gross profit. If you drop it into operating expenses, the margin disappears.

Do I subtract tax from total expenses?

No. Subtract income tax after income before tax. Mixing tax into operating expenses hides how the core business performed.

Is an income statement the same as a profit and loss statement?

For most small businesses, yes. The rows do the same job. A monthly projection template is not a finished statement until the period and the figures are yours.

Can I build this income statement format without Excel?

Yes. WPS Spreadsheet uses SUM and cell formulas and can save .xlsx. Type inputs by hand and let the total cells calculate.