Sheets
7
From settings to source options
Finance Excel template
Profit and Loss Statement Template
Consultation
If you want to line up revenue, expense, and profit lines with your close process, we can help decide what stays in Excel and what moves to the web. We can also adjust the sheet layout to match your current P&L worksheet.
If you need team collaboration, mobile review, accounting attachments, review follow-up reminders, or dashboards, discuss a custom system. The system example link is available only in supported languages.
A free Excel workbook for keeping monthly revenue, cost of sales, operating expenses, taxes, net profit, retained earnings, and business-line contribution in one place. Add the rows needed for close and scenario review, then enter separately calculated metrics.
Free download
Revenue
Expenses
Scenario analysis
Annual gross profit
249,000 USD
Scenario adjusted
Annual EBIT
117,000 USD
Separately summarized example
Sample scenarios
3
Add custom rows
Reporting snapshot
Lock the reporting baseline first
Record company, fiscal year, currency, and tax assumptions in Notes or a separate section, and record the current scenario in Settings. Use that same basis for the statement, quarterly summary, and business-line detail.
Fiscal year
2026
Current scenario
Base
Annual gross profit
249,000 USD
Annual net profit
69,000 USD
Free download
What the Excel version includes
A free Excel workbook for recording monthly revenue, costs, operating expenses, taxes, distributions, scenario results, quarterly summaries, and business-line analysis. Calculations and charts must be prepared separately.
File
Profit and loss statement template.xlsx
File name: finance_profit_and_loss_statement_template_en.xlsx
Sheets
7 sheets
Purpose
Income statement, scenario analysis, and business-line profit review
Includes seven sheets: instructions, settings, monthly input, income statement, quarterly summary, business-line detail, and references.
Records revenue, cost, and expense factors for base, upside, and downside scenarios. Add rows for custom scenarios.
To review gross profit, EBITDA, EBIT, net profit, retained earnings, and contribution profit, add the required rows and enter separately calculated monthly results.
Record the company name, fiscal year, currency, and income tax assumptions in Notes or a separate section. Record the chosen scenario and its factors in Settings. Calculate adjusted amounts and profit metrics separately, then update the result tables manually.
How Excel is used
How to run a profit and loss statement in Excel
The workbook works best when assumptions, revenue, expenses, and profit are updated in that order.
Step 1
Lock the reporting month
Before changing statement values, record the reporting period and company name in Notes or a separate section, then set the scenario factors in Settings.
Step 2
Enter revenue
Enter product, service, and other revenue so the top line stays easy to read.
Step 3
Enter expenses
Record cost of sales, payroll, rent, software, marketing, outsourcing, travel, and other expenses.
Step 4
Review profit
Review gross profit, operating margin, net profit, and status together.
Excel to screen mapping
Which Excel sections become the planning screens
If each statement section has a clear destination, the workbook is easier to review and later move into a system.
Excel section
System screen
Notes
Excel section
Assumptions
System screen
Close settings
Notes
Record the reporting period and company in Notes or a separate section, with scenario factors in Settings.
Excel section
Revenue forecast
System screen
Revenue board
Notes
Keeps monthly revenue lines together.
Excel section
Expenses
System screen
Expense board
Notes
Keeps cost of sales and operating expenses together.
Excel section
Profit summary
System screen
P&L summary
Notes
Enter separately calculated gross profit, operating margin, and net profit in the required rows and review them together.