Finance & AdministrationAvailable for Download

Profit and Loss Statement

Show revenue, costs and net profit month by month, with every total calculated by formula. Excel workbook.

Who Should Use It:Small business owners, managers, and administrators.
Primary Task:Show revenue, costs and net profit month by month, with every total calculated by formula. Excel workbook.
File FormatsMicrosoft Excel (.xlsx)
CompatibilityMicrosoft Excel, LibreOffice Calc, Google Sheets
License100% Free for Team Use
AccessDirect Download (No Sign-Up)
Free download

Download this template

Choose the file you need, then download it. No sign-up, no payment.

Excel (.xlsx)12 KBFree

Editable Excel workbook with formulas and print setup.

Free for team useNo sign-upEditable file
Document Preview

This is the actual first page of the file. Click the preview to see it larger, then download it below. The Sample card shows a completed example, filled in with sample details.

What’s Included in This Resource

Every resource on The Office File provides a complete toolkit rather than an empty, unhelpful document shell:

  • Editable Microsoft Excel (.xlsx) workbook with built-in formulas

Sample included: Example: Profit and Loss Statement in use. Show revenue, costs and net profit month by month, with every total calculated by formula. Excel workbook.

How to Use This Template

Follow these practical steps to customize and roll out this procedure with your team:

1

1. Download the file

Get the editable Excel workbook.

2

2. Replace the example figures

Overwrite the white input cells with your own monthly figures. Grey cells are formulas, so do not type in them.

3

3. Adjust to fit

Add, remove or rename lines to match your business, keeping the total and profit rows intact.

4

4. Save and share

Save your finished workbook, print it, or share it with your team or adviser.