Profit and Loss Statement Template (AKA Income Statement) — Excel, Word, & PDF

What is the Profit and Loss Statement Template? 

A profit and loss statement Excel template summarizes a company's revenues, expenses, and profits or losses over a specific period. Whether monthly, quarterly, or annually, this financial tool is critical for monitoring cash flow, analyzing performance trends, and forecasting future outcomes. 

This document is also called an income statement or a statement of operations. All three names describe the same underlying report: revenue, minus costs, equals profit or loss for a period. Which term you'll hear depends more on where you are and who you're talking to than on any real difference in the document itself, a small business owner in the US is more likely to say "P&L," while an accountant preparing statutory filings is more likely to write "income statement.

Big and small businesses use it to evaluate their financial health, identify areas for cost optimization, and make data-driven decisions. This guide explains how a P&L statement can simplify financial management for your business.

Importance of Profit and Loss Statement Template

Using the free Excel profit and loss statement template is essential for maintaining financial clarity and driving business success. Here’s how it helps:

Simplified Financial Reporting

The P&L template organizes income and expenses into a clear, easy-to-read format, allowing business owners to identify trends and areas requiring improvement. It provides a quick snapshot of financial performance for a given period.

Enhanced Transparency

The statement outlines income sources and categorizes expenses, offering stakeholders, investors, and creditors a transparent view of the company’s financial activities. This builds trust and facilitates informed discussions with partners.

Improved Decision-Making

By clearly showing profits or losses, the P&L statement enables businesses to pinpoint trends, optimize operations, and strategize for growth. Nonprofit organizations can use a similar format—a "statement of activities"—to highlight funding sources versus program and administrative costs.

Effective Communication Tool

A well-prepared P&L statement supports discussions with investors, creditors, and other stakeholders by summarizing a company’s financial health. It aids in assessing past performance and projecting future growth.

Strategic Planning Partner 

With insights from the P&L statement, businesses can allocate resources wisely, focus on profitable activities, and address underperforming areas. For investors and lenders, it offers critical data for evaluating a company's ability to generate cash flow and repay obligations.

What Does the Profit and Loss Statement Template Contain? 

The profit and loss statement template typically includes the following components:

Business and Period Information

• Business Details 
• Date: The date the P&L statement is prepared.
• Period: The time frame covered by the statement

Revenue Details 

• Sales Revenue: The total income generated from the sale of goods or services, including any deductions for returns and discounts.
• Other Revenue: Any additional income not directly related to sales.
• Gross Revenue: The total of sales revenue and other revenue.

Cost of Goods Sold (COGS)

• Total COGS: The costs incurred to produce or purchase the goods sold during the specified period.

Gross Profit

• Gross Profit: The difference between gross revenue and total COGS, representing the profitability before deducting expenses.

Expenses Details 

• Advertising
• Freight Expense
• Insurance
• Other Expenses

Net Income Details 

• Net Income: The final profit or loss figure, calculated as gross profit minus total expenses.

What Our Profit and Loss Statement Template Includes

Most free P&L templates online give you a blank grid and assume you already know how to structure it. This one is built with the calculation chain already in place: gross revenue minus COGS calculates gross profit automatically, and gross profit minus total expenses calculates net income automatically, so you're checking numbers, not building formulas. It also covers the terminology gap directly. If your accountant, your bank, or a government filing calls this an income statement, a statement of operations, or in the UK a profit and loss account, it's the same structure and the same file.

How to Use the Profit and Loss Statement Template

1- Enter Business and Period Information

Fill in your business name, address, and email. Specify the date the statement is prepared and the time frame it covers (e.g., “From - To”).

2- Record Revenue

Input sales revenue, ensuring any deductions for returns and discounts are factored in. Add other revenue sources and calculate gross revenue by summing these values.

3- List Cost of Goods Sold (COGS)

Enter the total cost of goods sold during the specified period. This includes all costs directly associated with production or procurement.

4- Calculate Gross Profit

Subtract total COGS from gross revenue to determine the gross profit. Input the resulting figure into the designated field.

5- Itemize Expenses

Record all operating expenses in the provided fields. Examples include wages, rent, advertising, and utilities. Use the “Other Expenses” field for any costs not explicitly listed. Sum all expenses in the “Total Expenses” field.

6- Determine Net Income

Subtract total expenses from gross profit to calculate the net income. This figure represents the business’s profitability for the period covered.

7- Review and Finalize

Double-check all entries for accuracy. Ensure the Excel P&L template is completed clearly and professionally before using it for internal analysis or sharing with stakeholders.

Profit and Loss Statements in the United States

In the US, "income statement" is the formal GAAP term, not "profit and loss statement." The FASB's Accounting Standards Codification uses ASC 220, "Income Statement — Reporting Comprehensive Income," as the governing standard, and for public companies, SEC Regulation S-X requires net income or net loss to be presented on the face of the financial statements. "Profit and loss statement" and "P&L" are the terms small business owners actually say out loud; "income statement" is what shows up in the audited filing. If you're a sole proprietor or single-member LLC, there's also a specific IRS version of this idea worth knowing: Schedule C (Form 1040), "Profit or Loss From Business," is the tax form where you report exactly this, revenue minus expenses, to calculate the profit or loss that flows onto your personal tax return. This template isn't a substitute for Schedule C, but the numbers you calculate here (gross revenue, COGS, total expenses, net income) map directly onto what that form asks for.

Profit and Loss Statements in the United Kingdom

In UK company law, the statutory term is actually "profit and loss account," not "profit and loss statement" or "income statement." The Companies Act 2006 requires every company's directors to prepare accounts including a profit and loss account that gives a true and fair view of the company's profit or loss for the financial year. Where a company reports under IFRS or FRS 102 instead of UK GAAP, the same document is described as an income statement, and under FRS 102 it can be presented as part of a combined statement of comprehensive income. In practice, this means the file itself doesn't change, but if you're preparing UK statutory accounts, label it "profit and loss account" to match what the Companies Act and Companies House expect to see.

Profit and Loss Statements in Australia

Australian companies work from the same base concept but under different legislation. The Corporations Act 2001 requires most companies to prepare an annual profit and loss statement alongside a balance sheet and cash flow statement, with the Australian Accounting Standards Board's AASB 101, aligned with IFRS, formally naming it a "statement of profit or loss." Small proprietary companies are generally exempt from preparing a full annual financial report unless directed to by shareholders holding at least 5% of votes. If you're operating as a proprietary limited company below that threshold, this template still works for internal tracking even without a statutory filing requirement attached to it.

Profit and Loss Statements in Malaysia

Malaysian companies file under the Companies Act 2016, with financial statements lodged with the Companies Commission of Malaysia (SSM) through the Malaysian Business Reporting System in XBRL format. Under the Malaysian Financial Reporting Standards (MFRS), which are fully converged with IFRS for most companies, this document is formally called a "Statement of Profit or Loss," one of the mandatory components in every SSM filing alongside the statement of financial position, statement of changes in equity, and statement of cash flows. Smaller private companies may instead follow the Malaysian Private Entities Reporting Standards (MPERS), a simplified version of the same standard.

Frequently Asked Questions

Is a profit and loss statement the same as an income statement?

Yes. They're two names for the same document: revenue minus expenses equals profit or loss for a period. "P&L" and "profit and loss statement" are more common in everyday business use; "income statement" is more common in formal accounting and US GAAP contexts.

How often should I prepare a profit and loss statement?

Monthly is standard for actively tracking a business, with quarterly and annual versions prepared for tax filing, statutory reporting, or investor updates. The same template works for any period, just change the date range.

What's the difference between gross profit and net income on this template?

Gross profit is revenue minus the direct cost of goods sold, before any operating expenses are deducted. Net income is what's left after every operating expense, rent, wages, insurance, advertising, and so on, is subtracted from gross profit. Gross profit tells you if your pricing and production costs work; net income tells you if the whole business is profitable.

Can nonprofits use this template?

Not directly. Nonprofits typically use a similar but distinctly-named format called a "statement of activities," which separates funding sources from program and administrative expenses rather than tracking sales revenue and COGS.

Does Enerpize generate this automatically?

Yes. Enerpize builds your profit and loss statement in real time from recorded transactions, so revenue, COGS, and expenses populate automatically instead of being entered by hand.

About the Author

Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.