Profit and Loss Excel Template including Examples

bizzlibrary template file type image
.xlsx (0.04 MB)
Download Bizzlibrary's free Profit and Loss template (P&L template) to create your financial statement. After downloading the Excel file have a look at the examples and the Excel formula (INDIRECT) used to create the yearly overview. Enter your business information into the blanks to create your P&L overview. The downloadable Excel file includes 2 templates and 3 examples. A Statement of Profit and Loss (also called an Income Statement) summarizes the business's income and expenses for a period of time to arrive at its net earnings for the period. The file is print-ready and uses frozen panes to keep the monthly overview. It also includes custom Excel number formatting to ensure negative numbers are shown in red and are surrounded by brackets (financial format). Depending on your region you might need to change the thousands and decimal formatting.

The content is for informational purposes only, you should not construe any such information or other material as legal, tax, investment, financial, or other advice. Nothing contained this site constitutes a solicitation, recommendation, endorsement, or offer by Bizzlibrary or any third party service provider to buy or sell any securities or other financial instruments in this or in any other jurisdiction in which such solicitation or offer would be unlawful under the securities laws of such jurisdiction.


lim rathana(8/12/2022)

This file template is very easy to download and use for lifetime

Kamndalira Phiri(5/15/2022)

Very useful website with excellent templates

Leslee Boyer(3/25/2022) - AUS

4* well deserved

Noelle Morris(3/25/2022) - NZL


Frequently Asked Questions

How to show negative numbers in brackets in Microsoft Excel in financial overviews?

  1. Select the cells you want format.
  2. Press Ctrl+1 or right click and choose Format Cells… to open the Format Cells dialog.
  3. Go to the Number tab.
  4. Select Custom in the Category list.
  5. Type in #.##0,0_ ;[Red](#.##0,0) to display. The number when negative, will show in red and including brackets.
  6. Click OK to apply formatting.

Excel tip: Thousands and decimal separators can vary based on your local settings. For example; while dot (.) usually is a thousand separator in North America, comma (,) is a decimal separator in Europe.

Last modified

You May Also Like