Profit & Loss — Free Waterfall Chart Template
This Profit & Loss template turns your income statement into a waterfall chart, showing exactly how revenue flows down through costs to your bottom line. The sample data walks from $50,000 in revenue, subtracting $18,000 COGS to reach $32,000 gross profit, then trims marketing and salaries to land on a $15,000 operating profit. It is a ready-made starting point for visualizing where your money is made and lost, so you can swap in your own figures and instantly see the story.
Open This Template in the EditorAbout This Waterfall Chart Template
This Profit & Loss template turns your income statement into a waterfall chart, showing exactly how revenue flows down through costs to your bottom line. The sample data walks from $50,000 in revenue, subtracting $18,000 COGS to reach $32,000 gross profit, then trims marketing and salaries to land on a $15,000 operating profit. It is a ready-made starting point for visualizing where your money is made and lost, so you can swap in your own figures and instantly see the story.
It's a ready-made Waterfall Chart you can open and edit in seconds — replace the sample numbers with your own, restyle it, and download a publication-ready image, all free and in your browser.
Template Data
This template ships with the sample data below. Open it in the editor to swap in your own figures:
| Item | P&L |
|---|---|
| Opening | 0 |
| Revenue | 50000 |
| COGS | -18000 |
| Gross Profit | 32000 |
| Marketing | -5000 |
| Salaries | -12000 |
| Operating Profit | 15000 |
When to Use This Template
- Small business owners breaking down monthly revenue, costs, and operating profit for a board or investor update
- Finance and FP&A analysts building a clean P&L waterfall for a budget review or management report
- Founders and consultants presenting how gross profit erodes through marketing and payroll into net operating profit
How to Use It
- Open the template — click "Open This Template in the Editor" to load it with its sample data.
- Edit the data — type your own labels and values, or paste a column straight from a spreadsheet.
- Customize & export — pick colors, add a title, then download as PNG, SVG, or PDF. No signup, no watermark.
Frequently Asked Questions
Can I replace the sample revenue and expense figures with my own numbers?
Yes. Click "Open in editor" and edit the data table directly, swapping the sample rows (Revenue, COGS, Marketing, Salaries, and so on) for your own line items and amounts. The waterfall recalculates automatically, and you can add or remove rows to match your P&L. Use negative values for costs so they step the bars downward.
Is this template really free, and how do I export the finished chart?
It is completely free with no signup or account required. Everything runs in your browser, and once you have customized the colors and data you can export the chart as a PNG, SVG, or PDF to drop into a slide deck, report, or email.
More Business & Sales Templates
Ready to use the Profit & Loss template?
Open it free — edit the data and export in minutes.
Open in Editor