Handled by Morning Book a free look

Make a profit and loss statement

This profit and loss statement template, also called an income statement or P&L, shows what the business earned, what it spent and what was left over for a period. Type or paste your numbers on the left and the statement builds itself on the right, with gross profit, operating profit, net profit and margins worked out as you go. It is a plain form with arithmetic, not AI. Nothing you type leaves this page, and closing the tab clears it.

About the statement

Type costs as positive numbers; the statement subtracts them. A refund or credit that lowers a section goes in as a negative, such as -500 or (500). Lines with no amount are left off the statement.

Income

Money earned from your main work in the period: sales of products and services.

Cost of goods sold

What it cost to make or buy what you sold: materials, products bought for resale, and labor that goes straight into the work. Service businesses with no direct costs can leave this empty.

Operating expenses

The costs of running the business that do not rise and fall with each sale. Each line shows its share of income.

Other income

Money that does not come from your main work, such as interest earned on savings.

Other expenses

Interest paid on loans, and depreciation: the part of the cost of equipment and vehicles counted as used up in this period.

Income tax

Leave this empty if your books do not record income tax for the business.

Paste from a spreadsheet

Copy two columns from a spreadsheet or an exported report, the line name and then the amount, and paste them here. A third column fills the compare amounts. Heading rows and rows starting with Total are skipped. The pasted lines replace the lines in the section you pick.

To save a PDF, choose Print, then Save as PDF as the printer. Only the statement prints.

Want your profit and margins without building this by hand?

I connect your books read-only and send one page each morning with sales, costs and margins for the month so far. A free 30-minute look shows what your books could answer today.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

How to read a profit and loss statement

Read it from the top down. Each step takes away one kind of cost, so you can see where the money goes.

income − cost of goods sold = gross profit

gross profit − operating expenses = operating profit

operating profit + other income − other expenses = profit before tax

profit before tax − income tax = net profit

Gross profit is what is left from sales after paying for what you sold. It shows whether your prices cover the direct cost of the work. Operating profit is what is left after the costs of running the business as well, such as wages, rent and software. It shows whether the business itself makes money. Net profit, the bottom line, is what is left after everything, including interest, depreciation and tax.

A margin is a profit divided by income. A 40% gross margin means 40 cents of each sales dollar is left after the direct costs. Margins let you compare periods of different sizes, and the share-of-income figure beside each expense shows which costs grew faster than sales. To work out the margin on a single product or price, use the margin calculator.

Where the numbers come from

Most accounting software has a report called Profit and Loss or Income Statement. Run it for the period you want, export it to a spreadsheet, then copy the line names and amounts into the paste box above, one section at a time. Many of those reports can also add a column for the same period last year, which you can paste into the compare column.

If your books group costs differently from this template, that is fine. Rename the lines, add lines, or remove the ones you do not use. What matters is that each cost sits in the right section, because the subtotals depend on it.

A profit and loss statement covers a stretch of time. To see what the business owns and owes on a single day, make a balance sheet as well.

Questions

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

Yes. Profit and loss statement, P&L and income statement are different names for the same report.

Why is my profit different from the money in the bank?

Profit and cash move at different times. A sale can count as income before the customer pays, and a bill can count as a cost before you pay it. Loan repayments, money the owners take out and equipment purchases change the bank balance, yet most of them do not show on the profit and loss statement at all.

What should go in the compare column?

The same period last year is the usual choice, because it removes the effect of seasons. A budget works too: put your planned numbers in the compare column and the change shows how far you are ahead or behind the plan.

Where does depreciation go?

This template puts it under other expenses with interest, so operating profit shows the business before the cost of equipment and loans. Some businesses list it under operating expenses instead. Either is fine if you do it the same way every period.

Is anything I type sent anywhere?

No. The statement is put together in your browser and the page stores nothing. It is a plain form with arithmetic, not AI. Download the spreadsheet or save the PDF to keep a copy.

Who made this?

Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.