Sheets
7
From settings to source options
Finance Excel template
Download the income statement template for free. Keep revenue, costs, expenses, taxes, scenario analysis, and business-line profit in one workbook.
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 data entry, photo uploads, corrective action reminders, or dashboards, view the systemized version.
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. It works well for teams that need a clear close view and scenario review.
Free download
Revenue
Expenses
Scenario analysis
Annual gross profit
249,000 USD
Scenario adjusted
Annual EBIT
117,000 USD
Auto summarized
Scenarios
4
Customizable
Reporting snapshot
Lock the reporting baseline first
Set the company, fiscal year, currency, income tax rate, and current scenario first so the statement, quarterly charts, and business-line detail share the same basis.
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 entering monthly revenue, costs, operating expenses, taxes, and distributions, then automatically generating scenario-adjusted income statements, quarterly summaries, charts, and business-line analysis.
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 settings, monthly input, income statement, quarterly charts, business-line detail, and source options.
Supports base, upside, downside, and custom scenarios with adjustable factors for revenue, costs, and expenses.
Tracks gross profit, EBITDA, EBIT, net profit, retained earnings, and contribution profit month by month.
Start with company name, fiscal year, currency, income tax rate, and current scenario.
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
Lock the reporting month, company name, and scenario factors before changing any statement values.
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
Keeps the reporting month, company name, and scenario factors together.
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
Shows gross profit, operating margin, and net profit together.