How to Create an Income Statement: A 5-Step Method, With QuickBooks and Excel

To create an income statement, list your total revenue for a period, subtract the cost of goods sold to get gross profit, subtract operating expenses to get operating income, then subtract interest and taxes to arrive at net income. That top-to-bottom order, revenue down to net income, is the whole structure. Everything else is deciding which accounts belong on which line and choosing a single-step or multi-step format. The five steps below build one from a trial balance, in QuickBooks, and in a spreadsheet, and cover the mistakes that make an income statement not tie.

An income statement, also called a profit and loss statement or P&L, reports what a business earned and spent over a stretch of time: a month, a quarter or a year. It is the statement people mean when they ask how the business is doing, because it ends in one number, net income, that says whether the period made or lost money.

What is an income statement?

An income statement is a financial statement that summarizes revenue, expenses and the resulting profit or loss over a period of time. Unlike a balance sheet, which is a snapshot at one date, an income statement covers a span and resets to zero at the start of each new period. Its bottom line, net income, is the figure that flows into retained earnings on the balance sheet, which is how the two statements connect.

The logic runs in one direction. Start with revenue at the top, subtract the direct cost of producing what you sold, then subtract the cost of running the business, then the cost of financing and tax. Each subtraction produces a named subtotal, gross profit, operating income, pre-tax income and net income, and each subtotal answers a different question about the business. That is why the ordering is not cosmetic: it separates how much you make on the product from how much it costs to run the company.

How to create an income statement, step by step

Building an income statement is five steps, and they follow the structure exactly. Work from a trial balance or a categorized transaction list for the period you are reporting.

1. Set the period and total your revenue. Decide the exact date range, then add up all income earned in it. On the accrual basis this is revenue earned during the period whether or not the cash arrived; on the cash basis it is revenue collected. Report revenue net of returns, allowances and discounts, so the top line is what you actually expect to keep.

2. Subtract cost of goods sold to get gross profit. Cost of goods sold is the direct cost of the products or services you sold: materials, direct labor, merchant fees on a sale. Revenue minus cost of goods sold is gross profit, and gross profit divided by revenue is your gross margin, the first ratio anyone reading the statement checks. A pure service business with no direct product cost may have little or no cost of goods sold and a gross profit close to revenue.

3. Subtract operating expenses to get operating income. Operating expenses are the costs of running the business that are not tied to a single sale: rent, salaries, software, marketing, insurance, office costs. Group them so a reader can see where the money goes rather than listing forty accounts. Gross profit minus operating expenses is operating income, also called earnings before interest and taxes, which measures the profit of the core business before financing decisions.

4. Subtract interest and taxes to get net income. Below operating income come the items that are not part of running the business day to day: interest on loans, and income tax. Subtract them and you reach net income, the bottom line. If the number is negative it is a net loss, which is normal and expected for a young or reinvesting business.

5. Check that it ties. Net income has to agree with the change in retained earnings on the balance sheet for the same period, after dividends or owner draws. If your income statement and balance sheet were built from the same books, they will tie automatically; if you built the income statement by hand, this reconciliation is how you catch a missed account. An income statement that does not tie to the balance sheet is not finished.

What is the format of an income statement?

There are two formats, and the difference is how much subtotalling you show. A single-step income statement adds up all revenue, adds up all expenses, and subtracts once to reach net income, with no gross profit or operating income line. It is quick and fine for a very simple business or a one-page internal look. A multi-step income statement shows the full ladder, gross profit, then operating income, then net income, and it is what a lender, an investor or a buyer expects, because those subtotals are exactly what they analyze.

For anything beyond a personal side project, use the multi-step format. The order of the accounts within it is fixed, and if you ever wonder which line something belongs on, the rule of thumb is direct-to-the-sale costs go in cost of goods sold, everything else operating goes in operating expenses, and financing and tax go at the bottom. The order the financial statements are prepared puts the income statement first for a reason: its net income is the input the balance sheet and cash flow statement both need.

How do you create an income statement in QuickBooks?

In QuickBooks Online, an income statement is the Profit and Loss report. Go to Reports, open Profit and Loss, set the report period and the accounting method, cash or accrual, then run it. QuickBooks builds the statement from the income and expense accounts in your chart of accounts, so the quality of the result depends entirely on how transactions were categorized. A P&L full of an Uncategorized Expense line or a bloated Ask My Accountant account is a categorization problem, not a reporting one, and it has to be fixed in the transactions before the statement means anything.

QuickBooks gives you the raw report, but not the presentation a bank or a buyer wants: comparative prior-period columns lined up cleanly, expenses grouped into readable categories rather than the full account list, ratios calculated, and a written read of what changed. That is the gap our QuickBooks financial statements tool fills, taking the export and returning a grouped, board-ready pack. If you are working from a QuickBooks export specifically, running financial statements in QuickBooks walks through the export step in detail.

How do you make an income statement in Excel?

In a spreadsheet, set up one column for account names and one for amounts, then lay the rows out in the fixed order: revenue accounts, a revenue subtotal, cost of goods sold, a gross profit formula, operating expense accounts, an operating income formula, then interest, taxes and a net income formula at the bottom. Use SUM ranges for each group and reference the subtotals in the next formula down, so a corrected number flows through to net income automatically. The work in Excel is not the arithmetic, it is getting the categorized data in and keeping the template correct as accounts change.

That is where a template becomes a chore for a real business. Every month you re-paste the data, re-check the groupings, and hope nothing shifted. For a solo operator or an online seller, even step one is work, because the revenue line means pulling together payouts from several platforms first, the job an income tracker for creators and sellers is built to handle before any statement gets made. Once the categorized numbers exist, generating the statement should take seconds, which is the case for using an income statement generator that reads the export and returns the finished multi-step statement with the ratios already calculated.

Common mistakes when preparing an income statement

The frequent errors are the same few. Mixing balance sheet items into the income statement: a loan repayment is not an expense, only the interest portion is, and buying equipment is not an expense, its depreciation is. Reporting revenue gross when returns and discounts should be netted against it. Burying meaningful costs in a catch-all account so no subtotal is readable. Switching between cash and accrual within one statement, which makes the period incomparable. And building the income statement in isolation, then finding it does not agree with the balance sheet, which almost always traces back to a transaction posted to the wrong account. Every one of these is a categorization decision, which is why clean books are the real prerequisite: the statement is only ever as good as the data feeding it.

Once the accounts are clean, the statement itself is mechanical, and that is the part worth automating. Whether the source is QuickBooks, Xero or a spreadsheet, an income statement generator takes the categorized export and returns a grouped, multi-step income statement that already ties to the balance sheet, with gross margin and operating margin calculated, so the time goes into reading the result rather than assembling it.