Income Statement preview
Monthly Detail sheet for entering revenue, COGS, payroll, rent, marketing, and other operating expense actuals and budgets month by month. 1/5

About this income statement spreadsheet template

This income statement template gives finance professionals and small business owners a complete monthly and annual financial reporting system. It includes five interconnected sheets — Monthly Detail for raw data entry, a formatted Income Statement with budget vs actual columns, a Variance Review tracker with owner and action fields, a Dashboard for visual trend analysis, and an International Setup guide for multi-currency adaptation.

Every cell, formula, and label is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. The clean dashboard layout uses consistent formatting and logical sheet flow so you can update revenue, COGS, payroll, rent, marketing, and other operating expense figures without rebuilding the structure.

The template is designed for both internal management reporting and stakeholder presentations. Use the variance review sheet to assign accountability and track corrective actions, and rely on the dashboard for at-a-glance monthly revenue and net income trends across the fiscal year.

5 interconnected sheets

Monthly Detail, Income Statement, Variance Review, Dashboard, and International Setup work together seamlessly.

Budget vs actual tracking

Compare revenue and expense line items against budget with automatic variance calculations.

Visual dashboard

Twelve-month revenue and net income trend summary for quick performance reviews.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Income Statement template is designed for monthly financial reporting, budget vs actual variance analysis, and management dashboard reviews. Customize the sample data, line items, and other editable elements in WPS Office for your own business or organization.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the financial data and structure in a Notion database; for branded financial documents, adapt the content in Adobe Acrobat.
Download the template, open it in WPS Office, and replace the placeholder revenue, expense, and budget figures, line-item labels, and other editable elements with your own financial data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for monthly management reports, investor updates, budget planning, and variance review meetings. It is available for personal and commercial projects, subject to the applicable template license.