ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / Profit and Loss Statement
Free Excel template

Profit and Loss Statement

Free Excel profit and loss statement over two years: gross margin, EBITDA, operating, financial, non-recurring and net income, changes and weight as % of revenue.

Comptia by Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

Get the template by e-mail, and its updates.

Keep the six files of « Profit and Loss Statement » in your inbox, to find or share them later. The direct download stays free, no sign-up.

  • The France, Québec and Africa versions, in French and English.
  • If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
  • Your details are never sold, one-click unsubscribe.
Contents

What the workbook contains.

Profit and loss

N and N-1, intermediate balances, changes

Intermediate balances

Gross margin, EBITDA, operating income, net income

Ratios

Each line as % of revenue

Settings

Currency, decimals

Instructions

Get started in 3 minutes, cells protected without password

Print

One portrait page

How to use it

Up and running in minutes.

  1. 01

    Take the totals of your expense and income accounts for year N and year N-1.

  2. 02

    Enter each line as a positive amount; financial and non-recurring results may be negative.

  3. 03

    Intermediate balances and net income compute, with the change and the % of revenue.

  4. 04

    Compare gross margin, staff cost weight and EBITDA year on year.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
It is what the core business generates before depreciation, interest and tax: gross margin less external charges, taxes and staff costs, plus operating grants. Banks follow it closely to judge repayment capacity; it is close to, but not exactly, EBITDA.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.