Top 17 Profit and Loss Statement Templates & Examples

A profit and loss statement is a financial statement of the business or company. It describes the revenue generated, the cost of expenditures incurred in a specific accounting period. It is also known as a statement of profit and loss. In this article, we have provided you with 17 different Profit and Loss Statement Templates and Examples that will be very helpful in this regard.  

Profit and Loss Statement provides the summary of information that tells the ability of the company to generate turnover by increasing the amount of revenue and reducing the cost of expenses. A profit and loss statement is used by businesses to show the financial results of operations for a specific time period like a month, year, or another period of time.

A profit and loss statement can be prepared to get a loan from a bank and to convince customers and investors about the financial position of the company. In order to prepare a comprehensive profit and loss statement for your company, you should utilize a profit and loss statement template. The free profit and loss statement templates are added here for you in the Microsoft Excel program.

More About the Profit and Loss Statement Template

The profit and loss statement template is the summary of the revenue, cost, and expenses incurred during a specific period of time. The record of this statement provides information to an employer for reducing costs and increasing revenue. The profit gained or loss suffered is credited or debited to an entrepreneur‘s capital account.

The users of the profit and loss statement are investors, shareholders, owners, and managers. The person when preparing the statement of profit and loss calculates the gross profit. The gross profit is calculated without including expense and income. The net profit or the loss is the amount after deductions of salaries, interest expense, and the bad debts and additions of interest received or bad debt recovered from the gross profit. An accountant preparing the income statement first mentions the name of the company and the year.

Get FREE Profit and Loss Statement Templates & Examples:

Key Components of a Profit and Loss Statement

Every profit and loss statement, no matter the format, is built from the same core building blocks. Understanding what each line represents makes it much easier to fill in one of the templates below correctly and to read the finished statement with confidence.

  • Revenue (Sales): The total income generated from selling goods or services before any costs are subtracted. This is the top line of the statement and the starting point for every calculation that follows.
  • Cost of Goods Sold (COGS): The direct costs tied to producing what was sold, such as materials, direct labor, and manufacturing overhead. COGS does not include general business expenses like rent or marketing.
  • Gross Profit: Revenue minus COGS. Gross profit shows how efficiently a business turns sales into profit before accounting for overhead and operating costs.
  • Operating Expenses: The day-to-day costs of running the business that are not tied directly to production, including rent, salaries, utilities, insurance, marketing, and office supplies.
  • Net Profit or Loss: What remains after subtracting operating expenses, interest, and taxes from gross profit. A positive number is net profit; a negative number is a net loss. This is the true bottom line of the business.

Below you will find 17 ready-to-use profit and loss statement templates and examples, covering a range of formats and industries, so you can pick the one that best matches how your business tracks and reports its numbers.

Business Profit and Loss Statement Template

Business Profit and Loss Statement Template Preview

Profit and Loss Statement Outline Template

Profit and Loss Statement Outline Template Preview

Detailed Profit and Loss Statement Template EXCEL

Detailed Profit and Loss Statement Template Excel Preview

Sample Profit and Loss Statement Template

Sample Profit and Loss Statement Template Preview

Profit and Loss Statement Example for a Manufacturing Company

Profit and Loss Statement Example for a Manufacturing Company Preview

Ebay’s Year End Profit and Loss Statement Template

Ebay Year End Profit and Loss Statement Template Preview

Corporate Profit and Loss Statement Template

Corporate Profit and Loss Statement Template Preview

Profit and Loss Statement Template WORD with Explanation

Profit and Loss Statement Template Word with Explanation Preview

Profit and Loss Statement Format Template

Profit and Loss Statement Format Template Preview

Monthy Profit and Loss Statement EXCEL Template

Monthly Profit and Loss Statement Excel Template Preview

Standard Profit and Loss Statement Template

Standard Profit and Loss Statement Template Preview

Profit and Loss Income Statement Template

Profit and Loss Income Statement Template Preview

Sample Profit and Loss Statement Template in XLSX Format

Sample Profit and Loss Statement Template in XLSX Format Preview

Simple Trading and Profit and Loss Statement Template

Simple Trading and Profit and Loss Statement Template Preview

Professional Profit and Loss Statement Template

Professional Profit and Loss Statement Template Preview

Profit and Loss Statement Example of a Company in DOC Format

Profit and Loss Statement Example of a Company in DOC Format Preview

Editable Profit and Loss Statement Template

Editable Profit and Loss Statement Template Preview

How to Prepare a Profit and Loss Statement Using These Templates

Once you have downloaded the template that fits your business, follow these steps to complete it accurately:

  1. Choose your reporting period. Decide whether you are preparing the statement monthly, quarterly, or annually, and use the same period consistently so figures can be compared over time.
  2. Record total revenue. Enter all income earned from sales during the period, before any deductions.
  3. List the cost of goods sold. Add up direct production costs such as materials and direct labor, then subtract this from revenue to find gross profit.
  4. Itemize operating expenses. List every recurring business cost, from rent and payroll to software subscriptions and marketing, grouped in the categories the template provides.
  5. Account for interest and taxes. Subtract any loan interest and applicable taxes from your operating profit.
  6. Calculate net profit or loss. The final figure after all deductions tells you whether the business was profitable during that period.
  7. Review and compare. Compare the completed statement against previous periods or your budget to spot trends, unexpected costs, or opportunities to improve margins.

Common Mistakes to Avoid

A profit and loss statement is only useful if it is accurate. Watch out for these common errors:

  • Confusing cash flow with profit. A business can show a profit on paper while still running short on cash, or vice versa, because a P&L statement records income and expenses when they are earned or incurred, not necessarily when cash actually changes hands. Track cash flow separately.
  • Omitting small or irregular expenses. Minor costs like bank fees, software renewals, or one-off purchases add up quickly and can distort your real profitability if left out.
  • Using inconsistent reporting periods. Comparing a four-week month to a five-week month, or switching between cash and accrual accounting without noting it, makes trends misleading.
  • Not separating fixed and variable costs. Lumping rent in with materials, for example, makes it harder to see which costs scale with sales and which stay constant, which matters when planning for growth or a slow season.

Using Your P&L Statement to Make Better Business Decisions

A profit and loss statement is more than a compliance document, it is a decision-making tool. Reviewing it regularly helps you spot which products or services are actually driving profit, identify expenses that are creeping up faster than revenue, and set realistic budgets and pricing based on real numbers rather than guesswork. Many business owners find it useful to track gross and net profit margins month over month, since a shrinking margin often signals a problem, whether that is rising costs, discounting too aggressively, or a shift in the sales mix, well before it shows up as a cash shortage. Sharing a clear, consistent P&L with lenders, investors, or partners also builds credibility, since it demonstrates that you understand and actively manage the financial health of your business.

Frequently Asked Questions

How often should a profit and loss statement be prepared?

Most small businesses prepare a P&L statement monthly to track performance closely, while some also produce quarterly and annual versions for taxes, lenders, or investors. The right frequency depends on how actively you need to monitor the business.

What is the difference between a profit and loss statement and a balance sheet?

A profit and loss statement shows income and expenses over a period of time and ends in a net profit or loss figure. A balance sheet, by contrast, is a snapshot of what a business owns and owes at a single point in time, listing assets, liabilities, and equity.

Do freelancers and sole proprietors need a profit and loss statement?

Yes. Even a one-person business benefits from tracking income against expenses, both to understand real earnings after costs and to have documentation ready for tax filing, loan applications, or client proposals.

What is a good profit margin to aim for?

Healthy profit margins vary widely by industry, so it is more useful to compare your own margin over time and against similar businesses in your sector than to chase a single universal number. Consistent, gradually improving margins are generally a stronger sign than a single high number in one period.

The information on this page is provided for general educational purposes and is not a substitute for professional advice. Every business has unique circumstances, so it is a good idea to consult a qualified accountant or tax professional before relying on a profit and loss statement for tax filing, financing, or major financial decisions.