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.
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.
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.