Build a P&L Template in Google Sheets: FP&A Guide

The tab structure you choose in the first 10 minutes determines whether this model is maintainable in 6 months or a liability you hand off apologetically. Each tab should have exactly one job — inputs, source data, calculation, or output — and the data flow should run in one direction.

A workable 8-tab layout for an FP&A P&L template:

Every hardcoded input in the model lives on this tab. No exceptions. Embedding a growth rate inside a Revenue tab formula is technical debt that will surface during a board prep sprint at the worst possible time. The Assumptions tab is where you change one cell and watch the entire model update.

Structure it with labeled sections separated by blank rows, with named ranges on every key input cell.

Revenue should break out by product line or segment, with monthly columns driven off the Assumptions model period anchors. As of May 2026, the most common structure for a SaaS business is MRR → ARR → recognized revenue, with separate rows for new business, expansion, and contraction/churn.

The formula pulling actuals into a recognized revenue row:

=SUMIFS(
  Actuals!$D:$D,
  Actuals!$B:$B, ">="&Assumptions!$B$3,
  Actuals!$B:$B, "<"&EDATE(Assumptions!$B$3,1),
  Actuals!$C:$C, "Revenue - SaaS"
)

COGS is where multi-product P&L models get sloppy. Costs get lumped into a single line and suddenly you can't disaggregate which product line is dragging the blended 61.5% gross margin down to 58%. Build COGS at the same granularity as Revenue — one row per cost category, mapped to the product line it supports.

For a SaaS business with professional services revenue, a clean COGS structure:

OpEx is the densest part of the model. According to APQC's FP&A benchmarking data, personnel costs represent 60–70% of total operating expenses for software and technology businesses — which means the headcount schedule drives most of your OpEx tab, and errors there cascade directly into EBITDA.

Build a headcount schedule first: a grid of department × quarter showing current headcount and planned additions. The formula pulling headcount cost into the OpEx summary:

=SUMIFS(
  'OpEx'!$E:$E,
  'OpEx'!$B:$B, "Engineering",
  'OpEx'!$C:$C, "Headcount"
)

EBITDA on the P&L tab is a straight subtraction of COGS and OpEx from Revenue, then an add-back of D&A from Assumptions. The EBITDA bridge — showing the period-over-period walk — belongs either in a dedicated section of the P&L tab or in a named range block that feeds the Board Summary.

The EBITDA calculation pulling across tabs:

='Revenue'!C3 - 'COGS'!C25 - 'OpEx'!C42 + (Assumptions!rev_pct_da * 'Revenue'!C3)

Where C25 is total COGS, C42 is total OpEx, and rev_pct_da is your D&A-as-%-of-revenue named range (2.3% in this model).

The P&L feeds retained earnings on the Balance Sheet and provides the starting net income line for the Cash Flow statement. Both links must be formula-driven — hardcoding either breaks the three-statement reconciliation the moment actuals come in.

Under FASB ASC 225-10 (Income Statement — Overall), the income statement must reconcile to changes in equity, which means the retained earnings roll on the Balance Sheet has to tie exactly to the P&L's net income line.

The retained earnings link:

='Balance Sheet'!$C$42 + 'P&L'!C58

Where C58 is net income for the period and $C$42 is prior period retained earnings. The Cash Flow starting point:

='P&L'!C58

A P&L template that only you can read isn't a deliverable. The Board Summary tab translates model outputs into something a board member can read in 90 seconds — no formula bars, no raw references, no 8-digit dollar amounts in default number format.

Key formatting rules for the Board Summary: