Building an FP&A Function From Scratch: What the First 18 Months Should Look Like

Most growth-stage companies wait too long to build FP&A. By the time they need it, they're firefighting reports rather than driving decisions. Here's how to build the function deliberately in 18 months.

David Kim
David KimSenior Financial Advisor & CFO Coach
Spreadsheets and financial planning documents on a desk

Most growth-stage companies wait too long to build a real financial planning and analysis function. The pattern is predictable: bookkeeper handles the basics, founder-CEO does the planning in spreadsheets, the board increasingly asks questions nobody can answer in real time. Eventually the CFO hire happens at $20M ARR, and the new CFO spends their first year fixing data quality issues that should have been addressed in the first year of the business.

FP&A isn't an enterprise function. Even a $5M ARR company benefits from someone whose job is to model the business and inform decisions with data. The question isn't whether to build it, but when and how.

Here's the 18-month roadmap from bookkeeping-only to a working FP&A function.

What FP&A actually does

Bookkeeping records what happened. Accounting closes the books and produces compliant financial statements. FP&A explains what those numbers mean and projects what they should be next.

The core FP&A activities:

  • Monthly business review with variance analysis (actuals vs. budget vs. forecast).
  • Rolling 12–18 month forecast updated quarterly.
  • Scenario modeling for major decisions (hiring plans, pricing changes, market expansions).
  • Unit economics analysis by segment, channel, cohort.
  • Cash flow forecasting with weekly granularity.
  • Board reporting and investor metrics.

The function exists to make decisions better, not to produce reports that nobody reads.

When to start (and not start) FP&A

The triggers that mean you need FP&A:

  • $3M+ ARR with growth above 50%/year. The business is complex enough that informal modeling produces wrong answers.
  • Multiple revenue streams or segments. Aggregate numbers hide important variance.
  • You've raised institutional capital. Investors expect monthly business reviews with proper variance analysis.
  • You're approaching a fundraise. A real model with defensible assumptions becomes a fundraising asset.

The signals you don't need FP&A yet:

  • Pre-product-market fit. Your business model isn't stable; modeling produces fiction.
  • Sub-$1M ARR. Bookkeeping + a part-time fractional CFO is enough.
  • Single-product, single-segment business with simple economics.

Most growth-stage SaaS companies should start building FP&A between $3M and $10M ARR. Earlier is fine if the founder is financially literate enough to be the first FP&A person; later is usually too late.

The 18-month roadmap

Months 0–3: Foundation

The first quarter is data quality. FP&A built on bad data produces bad analysis confidently.

The work:

  • Audit the books. Most growth-stage company books have accumulated errors and inconsistencies. A QoE-style audit surfaces them.
  • Standardize the chart of accounts. Categories that allow meaningful analysis. Revenue by segment, expenses by function, consistent vendor classification.
  • Tag transactions appropriately. Customer-attributable expenses tagged by customer or segment. Marketing spend tagged by channel.
  • Establish a monthly close calendar with hard deadlines. Books close by day 5 of the following month, max.

Without this foundation, every subsequent analysis is suspect.

Months 3–6: Reporting infrastructure

With clean data, build the recurring reports that drive decision-making.

The reports:

  • Monthly business review pack: P&L, balance sheet, cash flow, KPI dashboard, variance analysis. Distributed to leadership within 7 business days of month close.
  • Weekly cash flow forecast: 13-week rolling cash forecast, updated weekly.
  • Quarterly board package: format that investors want, with metrics that matter for your business.
  • Unit economics dashboard: CAC, LTV, payback, NRR — see SaaS Metrics That Matter.

Tooling at this stage: usually a combination of QuickBooks Online, Excel/Google Sheets, and a BI tool (Mode, Looker, Tableau). Don't over-tool early; the workflow matters more than the platform.

Months 6–12: Predictive modeling

With reporting solid, shift from describing the past to predicting the future.

The models to build:

  • 3-statement model: P&L, balance sheet, cash flow with full linkage. See Financial Forecasting for Startups for the structure.
  • Revenue model bottom-up: by customer, segment, channel.
  • Headcount plan linked to revenue plan.
  • Scenario model: base case, conservative case, aggressive case. Refresh quarterly.

The discipline that matters: revisit assumptions monthly against actuals. The model that's never refreshed becomes fiction within 6 months.

Months 12–18: Strategic analysis

With the operational infrastructure in place, FP&A starts producing the strategic analysis that drives major decisions.

Examples of the work:

  • Pricing analysis for repackaging decisions.
  • Geographic expansion analysis (market entry economics).
  • Build vs. buy financial analysis.
  • M&A target evaluation.
  • Strategic option valuation (what's preserving cash worth in optionality?).

This is where FP&A becomes strategic rather than operational. The leadership team starts using FP&A as a thinking partner instead of a report producer.

The hiring sequence

The right hires at each phase:

First hire (months 0–3): Senior FP&A manager or fractional CFO

Someone with FP&A experience at a larger company, joining as the first dedicated finance person beyond bookkeeping. They build the foundation.

Cost: $120–180k for an FTE; $5–12k/month for a fractional CFO. Both work; the choice depends on whether you have enough work for full-time.

Best background: 5+ years of operational finance experience at a growth-stage company, ideally in your industry.

Second hire (months 6–12): FP&A analyst

Junior or mid-level analyst to do the modeling and reporting work, freeing the senior person for strategy.

Cost: $80–110k. Worth it once the function has stable rhythms to maintain.

Third hire (months 12–18): Director of FP&A or first CFO

If you've been running with a fractional CFO, this is when you'd bring in a full-time CFO. If you started with a senior FP&A manager, this is when they're promoted or replaced with a more senior leader.

Cost: $250–400k for a CFO in growth-stage SaaS.

Tooling progression

The tooling stack typically evolves:

Months 0–6 (foundation):

  • QuickBooks Online (or NetSuite if larger).
  • Excel / Google Sheets for modeling.
  • A BI tool: Mode Analytics, Metabase, or Looker Studio.

Months 6–12 (predictive):

  • A dedicated FP&A platform if at scale: Pigment, Anaplan, Cube, Mosaic. Otherwise stay on spreadsheets — they're more flexible than people give them credit for.
  • A data warehouse if data complexity warrants: Snowflake, BigQuery.

Months 12–18 (strategic):

  • More sophisticated FP&A tooling as the company grows.
  • Integration with revenue systems (Stripe, billing systems), HRIS, marketing automation.

The pattern: invest in tooling when the manual workflow becomes the bottleneck, not before. Premature tooling investment captures workflow before the workflow is right.

Common FP&A build mistakes

After working with dozens of finance teams through this build:

Mistake 1: Hiring too senior too early

Bringing in a CFO at $3M ARR usually fails. The work is too operational and detail-oriented; the CFO disengages and the function stalls. Start with a senior FP&A manager and grow into the CFO hire.

Mistake 2: Building reports nobody uses

Reports without an audience are theater. Before building any recurring report, identify who'll use it and what decision it informs. Reports without a decision get ignored regardless of how beautiful they are.

Mistake 3: Modeling without scenarios

A single forecast pretends to predict the future. Three scenarios (base, conservative, aggressive) acknowledge that you don't and force the leadership team to discuss tradeoffs.

Mistake 4: Closing the books late

If books don't close until day 15 of the following month, FP&A is producing analysis on stale data. The discipline of fast close (day 5–7) compounds across every downstream activity.


FP&A is the strategic infrastructure that lets growth-stage companies make decisions with data instead of intuition. The companies that build it deliberately in the first 18 months of serious growth find the function pays back many times over. The ones that skip it discover at $20M ARR that the foundation should have been laid at $3M ARR, and spend the next year catching up.

For underlying financial modeling, see Financial Forecasting for Startups and Capital Allocation Frameworks.

Related Articles

Header Logo