Income Statement Excel Template | 2-Year Profit & Loss Spreadsheet | Revenue & Expense Tracker

Simplify your financial reporting with this Income Statement Excel Template, designed to help organize revenue, business expenses, taxes, and net income in one professional spreadsheet. 

This reusable Excel spreadsheet provides a clear 2-year side-by-side comparison, making it easy to enter financial figures and review business performance across two reporting periods.

Simply enter your applicable revenue and expense figures and let the built-in formulas calculate key totals automatically.

What’s Included

• Single-Step Income Statement Excel Worksheet
• 2-Year Financial Comparison
• Multiple Revenue Categories
• 20 Expense Categories
• Automatic Total Revenue Calculation
• Automatic Total Expense Calculation
• Net Income Before Taxes Calculation
• Income Tax Calculation
• Income from Continuing Operations
• Automatic Net Income Calculation

Revenue Tracking

Organize several types of business income, including:

• Sales Revenue
• Sales Returns & Allowances
• Service Revenue
• Interest Revenue
• Other Revenue

The spreadsheet automatically calculates your Total Revenues.

Expense Tracking

Record common business expenses across 20 predefined categories, including advertising, commissions, cost of goods sold, depreciation, employee benefits, insurance, interest, rent, salaries and wages, software, travel, utilities, web hosting and more.

Your Total Expenses are automatically calculated from the entered figures.

How It Works

1. Download and open the spreadsheet in Microsoft Excel.
2. Add your company details.
3. Enter revenue figures for the two reporting periods.
4. Enter applicable business expenses.
5. Review automatically calculated totals and income figures.

Perfect For

• Small Business Owners
• Entrepreneurs
• Freelancers
• Bookkeepers
• Accountants
• Finance Professionals
• Independent Businesses
• Business Financial Recordkeeping

Why You’ll Love It

Keep important income statement information organized in one reusable spreadsheet. The structured layout helps reduce manual calculations while providing an easy-to-review overview of revenue, expenses, and profitability.

Important Information

This is a digital Excel spreadsheet template. No physical product will be shipped.

The template includes built-in formulas. The income tax calculation in the supplied template uses a preset 20% calculation, so users should review the template and calculations for suitability for their own accounting and tax requirements.

This spreadsheet is intended as an organizational template and does not constitute accounting, financial, or tax advice.

Digital Download • Microsoft Excel Spreadsheet • Reusable Template • Automatic Calculations