Profit & Loss
Template Generator
Fill in your revenue, costs, and expenses — get instant gross profit, operating income, and net income. Switch between monthly and annual views. Free. No signup.
How to Use the Profit & Loss Template
Enter Your Business Name and Period
Start by entering your company name and the period your P&L covers — for example 'January 2025' for a monthly statement or 'FY 2025' for a full fiscal year. You can enter monthly amounts and toggle to the Annual view to see them multiplied by 12.
Enter Your Revenue
Add all income your business earned during the period. Common categories include product sales, service revenue, and consulting income. Click '+ Add row' to add custom revenue lines that match your business. The template auto-calculates Total Revenue.
Enter Cost of Goods Sold (COGS)
COGS are the direct costs of producing your products or delivering your services — materials, direct labor, and shipping. The template calculates Gross Profit (Revenue minus COGS) and your Gross Margin percentage automatically.
Enter Operating Expenses
Add your ongoing business expenses: rent, payroll, marketing, software subscriptions, professional fees, insurance, depreciation, and more. The template calculates Total Operating Expenses and your Operating Income (Gross Profit minus Operating Expenses).
Enter Other Income and Expenses, Then Download
Add interest income, interest expense, and income tax expense in the Other section. The template calculates Net Income and Net Margin. Once complete, download your P&L as an Excel (.xlsx) file for sharing with accountants or as a PDF for lenders and investors.
Profit & Loss FAQs for Small Business Owners
What is a profit and loss statement (P&L)?
What is the difference between gross profit and net income?
What is COGS and what does it include?
What are operating expenses?
What is operating income (EBIT)?
What is the difference between monthly and annual P&L views?
Is this P&L template suitable for LLCs?
How is a P&L different from a cash flow statement?
More Free Business Finance Tools
Balance Sheet Template
Build a complete balance sheet with assets, liabilities, and equity. Includes balance validation and Excel/PDF export.
Break-Even Calculator
Find out how many units you need to sell to cover your fixed and variable costs.
Markup Calculator
Calculate markup percentage, gross margin, and profit from cost and selling price.
Disclaimer
This profit and loss template is provided for educational and planning purposes only. It does not constitute accounting, tax, or legal advice. All calculations are based on the values you enter and may not reflect generally accepted accounting principles (GAAP) or your jurisdiction's requirements. Consult a licensed accountant or CPA before using this P&L for tax filings, loan applications, or legal purposes.
Free Tax & Finance Tips
Get notified when we add new calculators and tax guides. No spam.