An income statement brings revenue and expenses together to show profit or loss for a defined period. Use the templates below to group sales, direct costs, operating expenses, and other income or charges consistently. State the reporting dates clearly and use figures from the same accounting period so comparisons are meaningful.
For related tasks, see our ledger templates, annual report template, and sales revenue report templates.
What Is an Income Statement?
An income statement summarizes revenue, expenses, and profit or loss over a defined accounting period. It is also called a profit and loss statement. Businesses use it to review operating performance, compare periods, support planning, and provide information for management or reporting.
Main Sections of an Income Statement
- Sales or operating revenue
- Returns, allowances, or revenue adjustments
- Cost of goods sold or direct costs
- Gross profit
- Operating expenses
- Operating income
- Other income and expenses
- Tax expense and net income or loss
Revenue and Cost of Sales
Record revenue earned during the reporting period using the accounting basis followed by the business. Match cost of sales or direct costs with the related revenue where applicable. The difference between net revenue and cost of sales is gross profit.
Operating Expenses
Group expenses into useful categories such as payroll, rent, utilities, marketing, insurance, depreciation, professional fees, and office costs. Use consistent categories from period to period so comparisons remain meaningful. Do not mix owner withdrawals or balance-sheet items with operating expenses.
Using the Excel Template
Enter the reporting period and replace sample categories with the business’s chart of accounts. Input revenue and expense amounts as numbers and review all formulas after adding or deleting rows. Compare the resulting totals with the ledger or trial balance before relying on the statement.
Monthly and Annual Statements
A monthly income statement helps monitor short-term changes, while quarterly and annual statements provide a broader view. Comparing actual results with a prior period or budget can highlight changes in revenue, margins, and expenses that require investigation.
Important Review Steps
Confirm the reporting period, accounting basis, account classifications, signs, subtotals, and formulas. Investigate unexpected negative values, duplicate accounts, and material differences from the ledger. A qualified accounting professional should review the statement when formal reporting, tax, lending, or regulatory requirements apply.
Download Free Income Statement Template in Excel
Click on the download button and make this income statement template your own.
Two More Free Income Statement Templates
This page includes three downloadable income statement templates with different layouts. Choose the format that fits your workflow and customize it before use.
Monthly Income Statement Template
This editable Excel template uses a structured table layout for income statement tasks.
Download Monthly Income Statement Template
Quarterly Income Statement Template
This Excel alternative uses a distinctly different worksheet structure.
Download Quarterly Income Statement Template
How to Use These income statement templates Effectively
The Excel layouts are intended for performance reporting: they show whether revenue covered direct and operating costs during a defined period. The resource is designed for small businesses, startups, bookkeepers, project owners, and nonprofit managers. Before editing, decide who will complete the document, who will review it, and what final record must be retained. That small planning step prevents a visually polished file from becoming difficult to use in practice.
Choose the Right Version for the Task
Start with the layout that matches the real workflow rather than choosing only by appearance. Common applications include monthly reporting, quarterly review, annual accounts, budget comparison, and profitability analysis. A short, frequently used document should be easy to scan and complete. A formal record may need more instructions, approvals, references, and space for supporting details.
Download a clean copy before making changes. Rename the working file with a meaningful project, client, class, or reporting-period reference. Keep an untouched master so future versions do not inherit old names, amounts, dates, or confidential information.
Important Details to Include
Review every label before distribution. Depending on the selected layout, useful information normally includes:
- revenue categories
- cost of goods sold
- gross profit
- operating expenses
- other income and expenses
- net profit or loss
Remove fields that do not serve a genuine purpose and add any information required by your organization. Clear labels are more useful than dense instructions. If several people will use the file, include a short example or completion note wherever a field could reasonably be interpreted in more than one way.
A Reliable Customization Workflow
- Define the purpose. Write one sentence explaining the decision, transaction, activity, or record the document must support.
- Confirm the audience. Adjust vocabulary and instructions for the person completing the form and the person reviewing it.
- Edit the structure. Keep the relevant sections, remove unused placeholders, and add approval or reference fields only where needed.
- Test the document. Complete one sample with realistic information to check spacing, calculations, page breaks, and print quality.
- Control the final version. Add a revision date or file version, protect formulas where appropriate, and save completed records securely.
Quality and Accuracy Checks
Check spelling, dates, numbering, totals, names, and terminology before using the finished file. Make sure table columns remain readable after editing and that important text does not move onto an unexpected page. For Excel files, test formulas with several values, including zero, discounts, and unusually large figures. For Word files, review both the editing view and a PDF or print preview.
The most important issue to avoid is mixing cash flow with profit, misclassifying owner withdrawals, or comparing periods prepared on different bases. Use consistent formats for dates, currency, units, and names. If the document affects money, employment, legal rights, health, safety, or official records, have an authorized person review it before release. A downloadable template is a starting point and should be adapted to applicable policies and local requirements.
Saving, Sharing, and Maintaining the File
Use a predictable filename and store completed copies in a location with appropriate access controls. Avoid emailing editable files containing sensitive information when a secure system is available. If signatures are needed, state whether typed, handwritten, or approved electronic signatures are accepted. Archive final copies separately from blank masters.
Review the template whenever the process, responsible person, pricing, policy, regulation, or branding changes. Periodic review keeps the document accurate and reduces the chance that staff continue using an outdated copy. These practical controls make the template easier to reuse and more dependable as an operational record.
Monthly Income Statement
Monthly Income Statement adds a practical Excel option to this collection. The editable workbook separates input fields from calculated results, with formulas tailored to this record. Enter your own dates, quantities and amounts, and keep the stated period and units consistent.
Frequently Asked Questions
Can I edit this income statement template?
Yes. Download the file and replace the sample text, labels, amounts, and organization details with information appropriate to your situation.
Can I print the completed template?
Yes. Review the page layout and print a test copy first to confirm that tables, margins, and signature areas fit correctly.
Should I keep a copy?
Keep the completed document and relevant supporting records according to your organization’s record-retention procedures and any applicable requirements.
