What a Profit and Loss Statement Template Is
A profit and loss statement, also called a P&L, income statement, or profit loss statement template, is a financial document that summarizes your revenues and expenses over a specific period, typically a month, quarter, or year. The bottom line is net income: what you actually kept after paying all costs.
Unlike a balance sheet, which shows a snapshot of assets and liabilities at one moment, a P&L covers a time range. That makes it the go-to document for understanding business performance over time, comparing one quarter to another, or showing a lender that your business generates sustainable income.
- Shows total revenue (money you brought in)
- Subtracts cost of goods sold to get gross profit
- Subtracts operating expenses to get operating income
- Accounts for interest and taxes to reach net income
- Covers a defined period: monthly, quarterly, or annually
Key Parts to Include in Your P&L Template
A complete profit and loss statement template has several distinct sections. Skipping any of them will give you an incomplete picture of business health. Here is what every section covers and why it matters.
Revenue is straightforward: every dollar your business received from sales or services goes here. Some businesses also have other income lines like interest earned or rental income. List them separately so you can see which revenue streams are growing or shrinking.
- Revenue: all income sources broken out by product, service line, or category
- Cost of Goods Sold (COGS): direct costs tied to producing what you sell (materials, direct labor)
- Gross Profit: revenue minus COGS, showing efficiency before overhead
- Operating Expenses: rent, payroll, marketing, software, insurance, and other indirect costs
- Operating Income (EBIT): gross profit minus operating expenses
- Net Income: operating income after interest and taxes, the true bottom line
How to Use This Profit and Loss Template Step by Step
You can copy the template above directly into a Google Doc, Word document, or paste it as a starting layout in Google Sheets or Excel. The spreadsheet version is usually most practical because you can enter formulas to auto-calculate totals.
In Google Sheets or Excel, put each line item in column A, the dollar amount in column B, and totals as SUM formulas so they update automatically. For the free profit and loss template, you just need to replace each [PLACEHOLDER] with your actual figures. Save a copy for each accounting period so you can compare months side by side.
- Copy the template into Google Sheets (or Excel) and label the period in the header
- List every revenue source in the Revenue section with its actual amount
- Add up your COGS: materials, direct labor, or direct service costs only
- Calculate Gross Profit by subtracting Total COGS from Total Revenue
- List every operating expense below, including subscriptions you may forget
- Subtract Total Operating Expenses from Gross Profit to get Operating Income
- Subtract interest and estimated taxes to arrive at Net Income
- Save as a new file each period (e.g., PL_2026_Q1.xlsx) for comparison
Profit and Loss Template Formats: Excel, Google Sheets, Word, and PDF
The most popular format for a profit and loss statement template in Excel or Google Sheets because formulas eliminate manual math errors. Excel gives you more formatting control and is easy to share as a PDF later. Google Sheets is the best free option because it auto-saves to Drive and you can share it with a bookkeeper or accountant without emailing files back and forth.
A Word or Google Docs version works fine for very simple businesses with just a handful of line items, or when you need to paste the P&L into a larger report or business plan. The profit and loss statement template free version here is designed to work in any of these formats: just copy the layout and adapt it.
- Google Sheets: free, auto-saves, shareable link, easy to add SUM formulas
- Excel: great for complex formulas, conditional formatting, and multi-tab setups
- Word / Google Docs: fine for simple one-page P&Ls or embedding in a report
- PDF: best for sending to lenders, investors, or your accountant as a final copy
Common P&L Mistakes and How to Avoid Them
One of the most frequent mistakes is mixing personal and business expenses. Every line on your profit and loss template should be a legitimate business cost. Mixing in personal spending distorts your numbers and creates problems at tax time.
Another mistake is forgetting non-cash expenses like depreciation. If you bought equipment, the cost is spread over time as depreciation, and it should appear on the P&L even though no cash left your account that month. Similarly, prepaid expenses (like an annual software subscription) should be allocated monthly, not all in the month you paid.
- Keep personal and business expenses completely separate
- Include depreciation for equipment, even though it is non-cash
- Allocate prepaid annual expenses across the months they cover
- Check that COGS only includes direct costs, not overhead
- Reconcile your P&L totals against your bank statements each period
- Use consistent categories month to month so comparisons are meaningful
Who Needs a Profit and Loss Statement Template
Any business that earns revenue needs a P&L, but it is especially critical for freelancers and self-employed individuals who often skip formal financial tracking until tax season arrives. A simple monthly profit and loss template helps you see whether your side hustle is actually profitable after accounting for software, supplies, and time-adjacent costs.
Lenders and investors almost always ask for a P&L when you apply for a small business loan or approach investors. Having a clean, consistent profit and loss statement template in Excel or Google Sheets ready to share builds credibility and speeds up the application process. LLCs, sole proprietors, S-corps, and partnerships all benefit from keeping a current P&L on file.
- Freelancers and independent contractors tracking project profitability
- Small retail businesses monitoring product margins
- Service businesses comparing labor costs to revenue
- Anyone applying for an SBA loan, line of credit, or business grant
- Partnerships that need to report income splits to partners
Copy-and-paste template
Download .xlsxPROFIT AND LOSS STATEMENT
Business Name: [YOUR BUSINESS NAME]
Period: [START DATE] to [END DATE]
Prepared by: [YOUR NAME]
REVENUE
Product/Service Sales: $[AMOUNT]
Other Income: $[AMOUNT]
Total Revenue: $[TOTAL REVENUE]
COST OF GOODS SOLD (COGS)
Materials / Inventory: $[AMOUNT]
Direct Labor: $[AMOUNT]
Total COGS: $[TOTAL COGS]
GROSS PROFIT: $[TOTAL REVENUE - TOTAL COGS]
OPERATING EXPENSES
Rent / Office: $[AMOUNT]
Utilities: $[AMOUNT]
Payroll / Contractors: $[AMOUNT]
Marketing / Advertising: $[AMOUNT]
Software / Subscriptions: $[AMOUNT]
Insurance: $[AMOUNT]
Travel: $[AMOUNT]
Miscellaneous: $[AMOUNT]
Total Operating Expenses: $[TOTAL OPEX]
OPERATING INCOME (EBIT): $[GROSS PROFIT - TOTAL OPEX]
Interest Expense: $[AMOUNT]
Taxes: $[AMOUNT]
NET INCOME (PROFIT / LOSS): $[OPERATING INCOME - INTEREST - TAXES]