Income Statement Template – Monthly Excel P&L with Automatic Subtotals & Margins

Description
This Income Statement Template is a clean, formula-driven Excel document built to match the format accountants, investors, and lenders expect to see — not a generic spreadsheet, but a properly structured Profit & Loss statement ready for real business use. Whether you're a small business owner preparing monthly management reports, a startup building investor updates, or a finance professional who needs a fast, reliable P&L format, this template removes the setup work and lets you focus on the numbers.

The statement is organized in standard accounting sequence: Revenue (Sales Revenue and Other Operating Income) rolls up to Total Revenue; Cost of Goods Sold is subtracted to produce Gross Profit, with Gross Margin % calculated automatically; Operating Expenses are broken into common categories (Salaries & Wages, Rent & Utilities, Marketing & Advertising, Depreciation & Amortization, Office & Admin, and Other) and subtotaled; the result feeds Operating Income (EBIT) with an automatic Operating Margin %; Other Income and Expense items (interest income and expense) are added or subtracted to reach Income Before Tax; and after tax expense, the statement concludes with Net Income and Net Profit Margin %, clearly highlighted at the bottom.

Every month (Jan–Dec) is laid out as its own column, with an automatically calculated FY Total column and a "% of Revenue" common-size column showing every line item as a percentage of total revenue — a genuinely useful analytical feature for spotting cost trends that many free templates leave out. All subtotals and margins are live formulas, so replacing the sample data with your own actuals updates the entire statement instantly. This is the first in a three-part series (Income Statement, Balance Sheet, Cash Flow Statement), each sold separately and designed to be used standalone or combined later into a full financial model.