Free Excel Income Statement Template — Monthly P&L with Auto Analysis
Enter revenue and expenses to automatically calculate gross profit, operating income, and net income. Includes monthly comparison dashboard and break-even analysis.
When you run a business, knowing whether you are actually profitable can be surprisingly hard to pin down. This income statement template automatically calculates your profit margins from the revenue and expense figures you enter — no accounting degree required.
Key Features
📈 Automatic P&L Structure
The template calculates the full income statement hierarchy:
- Revenue — total sales of products or services
- Cost of Goods Sold (COGS) — direct costs tied to production
- Gross Profit = Revenue - COGS
- Operating Expenses (SG&A) — rent, marketing, salaries, utilities
- Operating Income = Gross Profit - Operating Expenses
- Non-Operating Items — interest income, interest expense, etc.
- Net Income = Operating Income + Non-Operating Items
📅 Monthly Comparison Dashboard
- 12-month revenue and operating income trend chart
- Month-over-month change indicators (up/down arrows)
- Year-to-date cumulative P&L running total
📊 Cost Structure Analysis
| Metric | Description |
|---|---|
| Gross Margin | Gross Profit / Revenue |
| Operating Margin | Operating Income / Revenue |
| Expense Ratio | SG&A / Revenue |
| Break-Even Point | Fixed Costs / (1 - Variable Cost Ratio) |
A pie chart breaks down your expenses by category so you can see where the money goes.
How to Use
Step 1: Enter Revenue
In the “Revenue” sheet, enter monthly sales figures by product or service category. Category names are fully customizable.
Step 2: Enter Expenses
In the “Expenses” sheet, enter COGS and operating expenses. Separating fixed costs (same every month) from variable costs (change with sales) improves analysis accuracy.
Step 3: Review the Dashboard
The “Dashboard” sheet shows your monthly P&L trends and cost structure at a glance.
Tips
Compare Actuals to Your Business Plan
Enter your annual targets in the “Plan” column. The template will generate a plan-vs-actual comparison chart automatically.
Use It for Tax Preparation
The annual totals on this template are a useful reference when preparing your tax return. For official financial statements, work with a certified accountant.
FAQ
How should I handle sales tax / VAT?
Enter revenue figures excluding sales tax. Sales tax collected and remitted is not part of the income statement.
Can a solo freelancer use this?
Absolutely. Enter your client payments as revenue, leave COGS blank, and enter business-related expenses (software, co-working, travel) as operating expenses.