Keeping track of business revenue and expenses is essential for understanding financial performance. An income statement helps you see how much money a business earned, how much it spent, and whether it generated a profit or loss during a specific period.
Our free Income Statement Excel Template provides a simple and organized way to prepare an income statement using Microsoft Excel.
The template includes sections for different types of revenue and business expenses, along with formulas for calculating totals and net income. It can be customized according to the needs of a small business, organization, accountant, student, or individual user.
Download Free Income Statement Excel Template
Editable XLSX template below and customize it with your own financial information.
File Format: XLSX
Template Type: Income Statement
Editable: Yes
Spreadsheet Software: Microsoft Excel or compatible spreadsheet software
What Is an Income Statement?
An income statement is a financial statement that summarizes a business’s revenue and expenses over a particular accounting period.
It is commonly used to determine whether a business generated a profit or experienced a loss.
A simplified calculation is:
Net Income = Total Revenue − Total Expenses
For example, suppose a business has:
Total Revenue: $100,000
Total Expenses: $75,000
The resulting income before additional applicable items would be:
$100,000 − $75,000 = $25,000
An income statement can therefore provide a useful overview of financial performance.
What’s Included in This Income Statement Excel Template?
The downloadable Income Statement Excel Template includes several useful sections for recording revenue and expenses.
Revenue
The revenue section allows you to record different sources of business income, including:
- Sales revenue
- Sales returns and allowances
- Service revenue
- Interest revenue
- Other revenue
The spreadsheet includes a Total Revenues calculation to help summarize the entered revenue figures.
Business Expenses
The template provides space for many common business expenses, including:
- Advertising
- Bad debt
- Commissions
- Cost of goods sold
- Depreciation
- Employee benefits
- Furniture and equipment
- Insurance
- Interest expense
- Maintenance and repairs
- Office supplies
- Payroll taxes
- Rent
- Research and development
- Salaries and wages
- Software
- Travel
- Utilities
- Web hosting and domains
- Other expenses
This makes the spreadsheet flexible enough for different types of businesses.
Total Expenses
The template includes formulas for calculating Total Expenses from the expense figures entered into the spreadsheet.
This reduces the need to manually add every expense each time the statement is prepared.
Net Income Before Taxes
After revenue and expenses are entered, the spreadsheet calculates Net Income Before Taxes by subtracting total expenses from total revenue.
The basic formula is:
Net Income Before Taxes = Total Revenues − Total Expenses
Single-Step and Multi-Step Income Statement
An especially useful feature of this Excel workbook is that it contains worksheets for both:
Single-Step Income Statement
and
Multi-Step Income Statement
What Is a Single-Step Income Statement?
A single-step income statement generally groups revenue together and expenses together.
The basic structure is:
Total Revenues − Total Expenses = Net Income
This format can be useful when you want a relatively straightforward presentation of financial performance.
What Is a Multi-Step Income Statement?
A multi-step income statement separates financial information into additional sections and calculations.
Depending on the business and reporting requirements, this can provide more detail about operating performance and other financial activities.
Having both formats in one workbook allows users to select the approach that better matches their needs.
Why Use an Income Statement Excel Template?
Creating an income statement manually every time can be repetitive.
A preformatted Excel template provides a reusable structure.
Some benefits include:
- Organized revenue tracking
- Organized expense tracking
- Automatic calculations using formulas
- Editable financial categories
- Reusable reporting format
- Easy year-to-year comparison
- Customizable business information
- Printable financial statement
- XLSX compatibility
You can modify categories according to your organization’s accounting structure.
Who Can Use This Excel Template?
Small Business Owners
Small businesses can use the spreadsheet to organize revenue and expenses and review financial performance.
Accountants and Bookkeepers
Accounting professionals can customize the spreadsheet for simple reporting and internal calculations.
Freelancers
Freelancers can adapt the income and expense categories to track their business activities.
Students
Accounting, finance, and business students can use the template to understand the structure of an income statement and practice financial calculations.
Organizations
Organizations can customize revenue and expense categories based on their own accounting requirements.
How to Use the Income Statement Excel Template
Step 1: Download the XLSX File
Click the Download Income Statement Excel Template button.
Save the file to your computer.
Step 2: Open the Spreadsheet
Open the downloaded file using Microsoft Excel or another compatible spreadsheet application.
Step 3: Enter Your Business Information
Replace placeholder information such as the company name and reporting period with your own information.
For example:
ABC Company
Income Statement
For the Year Ending December 31, 2026
Step 4: Enter Revenue
Enter the applicable amounts for:
- Sales
- Services
- Interest
- Other revenue
Leave categories blank when they don’t apply to your business, or customize them as necessary.
Step 5: Enter Expenses
Enter your business expenses in the appropriate categories.
Make sure figures are entered in the correct accounting period or year.
Step 6: Review the Formulas
The spreadsheet contains formulas for calculations such as total revenue, total expenses, and net income before taxes.
If you add or remove rows, verify that the formulas still reference the correct cells.
Step 7: Review the Final Income
After entering the necessary figures, review the calculated results carefully.
Do not rely solely on automated formulas without verifying the source data.
Step 8: Save a New Copy
Consider keeping the original template unchanged.
Use Save As to create a separate copy, for example:
ABC-Company-Income-Statement-2026.xlsx
This gives you a clean template to reuse later.
Income Statement vs Balance Sheet
An Income Statement and Balance Sheet are both important financial statements, but they serve different purposes.
| Income Statement | Balance Sheet |
|---|---|
| Shows financial performance | Shows financial position |
| Covers a period of time | Represents a particular date |
| Includes revenue | Includes assets |
| Includes expenses | Includes liabilities |
| Calculates profit/loss | Includes equity |
For example, an income statement can show how much profit a business generated during a year, while a balance sheet can show what the business owns and owes at a particular date.
Internal Link Opportunity
Since you already have a Balance Sheet Excel Template on your website, this is a very relevant internal link.
Use something like:
You may also need our Free Balance Sheet Excel Template to organize assets, liabilities, and equity.
This is much more relevant to this article than linking randomly to unrelated Windows posts.
Income Statement vs Profit and Loss Statement
The terms Income Statement and Profit and Loss Statement (P&L) are often used to describe the same general type of financial report.
Both focus on revenue, expenses, and the resulting profit or loss over a reporting period.
The terminology used may depend on the business, accountant, organization, or jurisdiction.
Tips for Using the Excel Template
Keep Accurate Records
The spreadsheet can only produce useful results when the data entered into it is accurate.
Keep supporting records such as invoices, sales records, expense documents, and accounting entries.
Don’t Delete Formulas Accidentally
Some cells contain formulas.
When customizing the spreadsheet, be careful not to overwrite important calculation cells.
Keep Backups
Financial spreadsheets can contain important business information.
Keep backup copies on another secure storage device or an appropriate backup service.
Protect Sensitive Financial Data
Do not publicly share a completed spreadsheet containing confidential financial information.
The blank template may be downloadable, but your completed business records should be stored securely.
Review Your Financial Statements
Excel formulas can perform calculations, but they cannot determine whether your accounting treatment is correct.
For formal reporting, taxation, audits, lending, or regulatory purposes, consider having the financial information reviewed by an appropriately qualified professional.
Frequently Asked Questions
Is this Income Statement Excel Template free?
Yes. The template can be offered as a free downloadable XLSX resource on your website.
Can I edit the Income Statement template?
Yes. The spreadsheet is editable, so you can customize company information, financial periods, revenue categories, and expense categories according to your requirements.
Does the template calculate total revenue automatically?
The workbook includes formulas for calculating totals based on the values entered in relevant cells.
Does it calculate total expenses?
Yes. The template contains a Total Expenses calculation based on the expense section.
Can it calculate net income?
The template includes a calculation for Net Income Before Taxes based on total revenue minus total expenses.
Does the workbook have a multi-step income statement?
Yes. The uploaded workbook contains both SingleStep and MultiStep worksheets.
Can I use the template in Google Sheets?
XLSX files can generally be imported into Google Sheets. However, always verify formatting and formulas after importing because spreadsheet applications can handle some features differently.
Can I use it for my business?
You can customize the template for business record keeping. However, accounting, tax, and financial reporting requirements vary, so verify that your final statement meets the requirements applicable to your business.
Download Income Statement Excel Template
If you need a simple spreadsheet for recording business revenue and expenses, download the Income Statement Excel Template and customize it for your needs.
The template gives you an organized starting point for preparing an income statement without building a spreadsheet from scratch.
2 thoughts on “Free Income Statement Excel Template – Download XLSX”