SaaS Income Statement Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Monthly Income Statement sheet: review the pre-loaded revenue tiers and adjust the plan names to match your pricing (for example, Starter, Professional, Enterprise). Add or remove tiers as needed — the formulas use range references and pick up new rows automatically. Then review the cost of revenue and operating expense line items and rename any labels that don't match your chart of accounts. This setup takes 15–20 minutes and you only do it once.

Each month, enter your subscription revenue by tier, professional services revenue, and any usage or add-on charges at the top. Then fill in cost of revenue: pull your cloud infrastructure bill from AWS or GCP, add payment processing fees (typically 2.2–2.9% of revenue), and allocate the portion of customer success salaries tied to service delivery. Work down through R&D, S&M, and G&A using your payroll reports and expense categorizations. The gross profit, operating income, EBITDA, and net income lines calculate automatically. Then open the SaaS Metrics sheet and enter your new, expansion, contraction, and churned MRR for the month.

Review the SaaS Metrics sheet after each monthly close. If your NRR is running below 100%, that means your existing customer base is shrinking in revenue — a problem that growth in new ARR can mask for a few quarters but can't hide forever. If gross margin is below 60%, look at infrastructure costs relative to revenue — that's the most common culprit in early-stage SaaS where infrastructure isn't yet optimized for the load you're running. Founders and finance teams who review the full income statement monthly alongside the SaaS metrics — not just the MRR dashboard — tend to catch efficiency problems earlier and have cleaner data when it's time for a funding conversation.

SaaS income statements look different from those of other businesses, and that difference matters when you're talking to investors, lenders, or a board. Revenue isn't just a single top-line number — it's subscription revenue, professional services, and usage or add-on charges, each with different margin profiles. Cost of revenue isn't product cost in the traditional sense — it's infrastructure spend, payment processing, and the delivery-side portion of customer success. And operating expenses need to be split into R&D, Sales and Marketing, and G&A, because that's how investors and acquirers model efficiency ratios. A generic business income statement won't capture any of this, which means you'll spend hours reformatting it every time you need to share it with someone who knows SaaS.

Gross margin is the foundational number in a SaaS income statement. Well-run SaaS companies typically target 70–80% gross margin at scale — enough headroom to fund the S&M and R&D spend required to grow while still generating positive cash flow eventually. Early-stage companies often run lower (60–70%) because they're over-provisioned on infrastructure relative to current revenue and haven't yet optimized their cloud spend. Gross margin below 60% usually signals a structural problem: too much human cost tied to service delivery, underpriced plans, or infrastructure that doesn't scale efficiently. The income statement is where this shows up first, before it appears in any other metric.

The income statement becomes a strategic tool when you read it alongside the SaaS metrics that explain the revenue line. If MRR grew but NRR is below 100%, that growth is happening despite contraction in your existing base — a fragile position. If S&M spend as a percentage of revenue is rising while new MRR growth is flat, your customer acquisition is getting less efficient. If R&D is consuming 40% of revenue at a stage where the product is relatively mature, that's worth examining. None of these insights come from reading the income statement in isolation, but all of them become clear when you have both the income statement structure and the subscription metrics in the same place — which is what this template is designed to provide.