Accounting template
Profit and Loss Statement Template (P&L)
Go from revenue to net income in clear steps. Gross profit, margin, operating income, tax and net income are all formulas, ready for your own numbers.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Line | Amount |
| 2 | Revenue | 1,200,000 |
| 3 | Cost of goods sold | 480,000 |
| 4 | Gross profit | =B2-B3 |
| 5 | Gross margin | =B4/B2 |
| 6 | Operating income | =B4-B6 |
| 7 | Net income | =B7-B8 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B4 =B2-B3
Gross profit is revenue minus cost of goods sold.
B5 =B4/B2
Gross margin as a share of revenue.
B9 =B7-B8
Net income after tax.
Make it yours by asking
Try a request like this in Tabstra:
"Build a profit and loss statement with revenue, COGS, gross margin, operating expenses, tax and net income"