Most profit and loss templates are static downloads that leave the math to you. This one is a working generator: enter your revenue and expenses below, and it calculates gross profit, operating income, and net income as you type. When you are done, download your statement as a PDF, Excel, or CSV file. Everything runs in your browser, so your numbers never leave your computer.
Your numbers stay on your computer. This tool runs entirely in your browser. GlassJar never receives or stores the figures you enter.
This tool performs arithmetic on numbers you supply. Its output is not a certified, audited, reviewed, or compiled financial statement, and GlassJar does not provide accounting, tax, or legal advice. Have any statement reviewed by a qualified professional before relying on it. See the full Tool Notice and Terms of Use.
What is a profit and loss statement?
A profit and loss statement, also called a P&L, summarizes your revenue, costs, and expenses over a period of time, usually a month, a quarter, or a year. Accountants and lenders call the very same document an income statement, so if that is the term on your loan checklist, the income statement template builds it under the title they expect.
Whatever the name, it answers one question: did the business make money during that period? Lenders ask for one when you apply for financing, landlords ask for one when you lease commercial space, and buyers ask for one when you sell the business. It is also the fastest way to spot whether spending is creeping up faster than sales.
How this template works
Instead of downloading a spreadsheet and wiring up formulas, you fill in the statement right on this page. The generator handles the structure and the arithmetic:
- Enter your business name and the reporting period.
- Fill in revenue, cost of goods sold, and operating expenses. Add, remove, or rename any line item to match your business.
- Watch gross profit, operating income, and net income calculate automatically.
- Turn on the percent of revenue column to see each expense as a share of sales, the same way an accountant reads a P&L.
- Download the finished statement as PDF, Excel, or CSV, or print it directly.
Nothing you type is uploaded anywhere. The entire tool, including the file generation, runs locally in your browser.
The three numbers that matter
Gross profit is revenue minus cost of goods sold, the direct cost of the products or services you delivered. If gross profit is thin, no amount of expense trimming below it will save the business, because the core offering is underpriced or overcosted.
Operating income is gross profit minus operating expenses like rent, payroll, marketing, and insurance. This is the profit your day-to-day operation produces before financing costs and one-off items.
Net income is the bottom line after other income and expenses, such as interest. This is the number a lender or landlord will look at first.
Common mistakes to avoid
Keep cost of goods sold separate from operating expenses; mixing them hides your true gross margin. Match the period on every line, so a quarterly statement does not contain an annual insurance bill at full value. And do not include owner draws as an expense on the P&L; draws belong on the balance sheet as a reduction of equity. If you also need a balance sheet, use the free balance sheet template, which shares this generator. Free Balance Sheet Template
When you outgrow manual statements
A hand-built P&L is a snapshot you assemble yourself. GlassJar builds these reports automatically from your actual transactions, and its customizable report library lets you choose which reports live on your dashboard, so the statement you just built by hand becomes one you never have to build again. See everything included on the features page.
Frequently Asked Questions
Is this profit and loss statement template really free?
Yes. The generator is free to use and the full statement displays on screen with no signup. We only ask for an email address if you want to download the statement as a PDF, Excel, or CSV file.
Is my financial data private?
Yes. The tool runs entirely in your browser. Your figures are never transmitted to GlassJar or stored on our servers. If you download a file, only your email address is sent to us, never your numbers.
Can I use this statement for a loan application?
You can generate a statement to hand to a lender, but it is self-prepared and unaudited. Many lenders accept self-prepared statements from small businesses; some require statements reviewed by a CPA. Check the lender’s requirements, and have a professional review the statement before you rely on it.
What period should my profit and loss statement cover?
Monthly statements are best for managing the business, quarterly for spotting trends, and annual for taxes and financing. The template accepts any date range, so you can produce all three from the same page.
Can I download the template as an Excel file?
Yes. The download options include XLSX with your line items and formatting intact, plus PDF for sharing and CSV for importing into other software.
How is this different from a downloadable P&L template?
A static template gives you a blank grid and leaves the formulas, formatting, and math to you. This generator computes gross profit, operating income, and net income as you type and produces a finished, formatted document.
