Profit and Loss (P&L) Statement Template
This profit and loss (P&L) statement template summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period.
Below is a screenshot of the P&L statement template:
Download the Free Template
Enter your name and email in the form below or follow this link to download the free P&L template now!
Profit and Loss Statement TemplateDownload the free Excel template now to advance your finance knowledge!
#1 Monthly Profit and Loss template
The monthly P&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown. Line items include revenue, cost of goods sold, interest expense, earnings before tax, and net income.
The monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required.
#2 Annual Profit and Loss template (P&L template)
For businesses that have been in operation for several years, it may be helpful to show an annual (full year or year to date) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods.
This template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary.
More Free Templates
For more resources, check out CFI’s Business Templates Library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.