profit and loss generator
Profit and loss statement generator
Create a P&L from revenue to net income with gross margin, operating income and tax as formulas. Free to open, easy to adapt.
Opening the template uses no credits. Building from a prompt uses credits; the Free plan includes 25.
A clear P&L answers two questions: are we making money, and where does it go. Tabstra lays out each step from revenue to net income so every line is traceable.
What the spreadsheet looks like
| 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 expenses | 420,000 |
| 7 | Operating income | =B4-B6 |
| 8 | Tax (20.6%) | =B7*0.206 |
| 9 | Net income | =B7-B8 |
This is the real first sheet of the Profit & Loss template. Every total is a formula.
Who it's for
- Small businesses reviewing a quarter
- Founders preparing board updates
- Students learning income statements
What you get
- Revenue, COGS and gross profit
- Operating expenses and operating income
- Tax and net income
- Margins as percentages
How it works
- 1
Open the template
It opens free with sample numbers.
- 2
Replace the numbers
Typing your figures never uses credits.
- 3
Ask for structure
Request extra lines, periods or comparisons in plain language.
Prompts to try
Tips from practice
- Keep COGS separate from operating expenses to see gross margin.
- Show margins as percentages next to amounts.
- Use the same categories as your bookkeeping to compare easily.
Good to know: Tabstra doesn't import from accounting software; paste or attach exported numbers instead.
Formulas used here: ROUND, Percentage change, IFERROR