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.
Your country's version.
Each country has its two files: one fully French, one fully English. Direct download, no sign-up.
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.
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
One portrait page
Up and running in minutes.
- 01
Take the totals of your expense and income accounts for year N and year N-1.
- 02
Enter each line as a positive amount; financial and non-recurring results may be negative.
- 03
Intermediate balances and net income compute, with the change and the % of revenue.
- 04
Compare gross margin, staff cost weight and EBITDA year on year.
Your questions, answered.
In the same category.
The same cycle, automated.
Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.