Income Statement TemplateFree in Google Sheets & Excel
Published

- Free
- Ready to use
- Editable in Google Sheets
Fill it in with AI
In development- Answer a few questions — name, niche, colours, logo.
- Get a copy in your own Drive with the text already written for you.
- Same brand applied across every template you take.
Not available yet — we are building it. Everything else on this page works today.
Rate this template
No votes yet — yours will be the first.
Template Information
- Created
- 4 February 2022
- Updated
- 27 August 2026
- Formats
- Google Sheets or Microsoft Excel
- Works with
- Google Sheets, Microsoft Excel, Apple Numbers
- Price
- Free
- Preview size
- 1024 × 1449 px
The purpose of preparing an income statement is to determine how much profit a company has made during this period and to inform users of financial statements about this. When compiling this report, as well as the balance sheet, certain principles are used that are common to all companies, regardless of their organizational and legal form.
The income statement template for Google Sheets provides the users with an opportunity to meet all of these rules during the development of this type of the documents. It can include the information describing such aspects as:
- Gross profit
- Total operating expenses
- Net profit
The presence of a wide range of the options for the editing provides the users with an opportunity to introduce any types of the changes. This approach allows the individuals to control the financial situation by having a chance to form action plans needed to achieve certain goals. The income statement templates for Google Sheets is the most effective way to save time and effort by performing routine activities.
The profit and loss statement shows the total revenue received for a certain period, reduced by the total expenses incurred. The difference between total revenue and total expenses is either profit or loss. The income statement is prepared on an accrual basis. You can also reflect this type of the data in the sheet. The profit and loss statement is used to evaluate the effectiveness of the company's operations and is one of the most important sources of information about the results of its activities.
Due to the fact that capital expenditures are presented in the income statement in a “smoothed” form through depreciation, it is often a convenient tool for not only evaluating a company’s performance in the past, but also forecasting its earnings in future periods.
How to use this template
- 1
Make your own copy
Pick “Make a copy”. The spreadsheet lands in your Drive with all formulas intact.
- 2
Enter your data
Type over the sample rows. Totals and calculated cells update on their own.
- 3
Extend the sheet
Add rows or columns as needed — copy an existing row so its formulas carry over.
- 4
Share or download
Use File → Download for an editable XLSX, or share the Drive link with your team.