SaaS FP&A: connect recurring revenue to the company plan

SaaS FP&A connects recurring revenue performance with the company budget, delivery costs and operating spend. Start with recognized revenue by customer cohort and closed expenses by department, then explain how the differences from plan change the operating result. Keep contract indicators, accounting revenue and cash collections in separate schedules.

Give the company review a defined scope

The broader FP&A workflow links planning with financial performance. A SaaS company adds a recurring-revenue view so management can distinguish changes in the existing customer base from changes in new customer acquisition.

This review uses the approved monthly budget and recognized revenue for the same month. The revenue schedule supplies customer, acquisition cohort, product, recognition period, currency, budget version and amount. The expense export supplies department, account, period, version and amount. Include a stable account or customer identifier so a renamed label does not create a new business category.

Do not substitute cash receipts for the revenue schedule. The IRS overview of accounting methods explains the general accrual distinction between earning income and receiving payment. For management reporting, use the revenue amounts accounting has approved for the period and reconcile them to the closed ledger.

The method below owns the company finance review. Separate articles explain customer acquisition cost and net revenue retention by cohort. Those indicators help investigate an operating cause; they do not replace the income statement.

Build one monthly comparison sheet

Consider a fictional US subscription software company reviewing September 2026. Existing customers are split into two mutually exclusive acquisition cohorts, labeled A and B. The new-customer line contains only customers acquired during the review month. Each recognized revenue dollar belongs to one line.

The cost lines below cover every cost in this example's operating result. Delivery includes the company's approved service-delivery cost accounts. Operating departments contain their remaining expense accounts, including depreciation and amortization where relevant. Financing and income taxes are outside this operating comparison.

Use A1:G8 for the following sheet. Enter the first four columns from the approved exports, assign the reporting sign in F, and calculate E and G.

Enter these Excel formulas in E2 and G2, then fill down to row 8:

=D2-C2
=E2*F2

The sign column makes expense increases reduce the result. Keep the raw variance in E so department owners still see the familiar actual-minus-budget expense comparison.

Calculate the revenue and expense totals

For planned and actual revenue, use:

=SUMIFS(C2:C8,A2:A8,"Revenue")
=SUMIFS(D2:D8,A2:A8,"Revenue")

Microsoft documents SUMIFS as adding values that meet multiple criteria. In a file with several periods or versions, add those criteria too. For costs, replace the criterion with "Cost".

The company comparison is:

Operating-result variance = Revenue variance - Cost variance

Here, negative $12,000 minus positive $17,000 equals negative $29,000. A modest revenue shortfall and higher spending both contribute to the result; neither is a complete explanation on its own.

Reconcile the bridge to the original rows

Calculate the planned and actual operating result directly from the signed comparison rows:

=SUMPRODUCT(C2:C8,F2:F8)
=SUMPRODUCT(D2:D8,F2:F8)

SUMPRODUCT sums the products of corresponding values. The results are $90,000 and $61,000. The movement is also the sum of the result effects:

=SUM(G2:G8)

That sum is negative $29,000. The full bridge is $90,000 minus $6,000 plus $6,000 minus $12,000 minus $4,000 minus $15,000 plus $4,000 minus $2,000, which equals $61,000. All dollar values here are exact whole-dollar amounts.

Add a zero check that compares the two calculations:

=SUMPRODUCT(D2:D8,F2:F8)-SUMPRODUCT(C2:C8,F2:F8)-SUM(G2:G8)

Then compare the revenue total with the revenue ledger and the department totals with the expense ledger. A zero bridge proves the arithmetic, but it cannot prove completeness if the same account was omitted everywhere. Keep unmapped accounts and customers visible until their owners resolve them.

Use operating evidence to explain the result

The new-customer revenue line is below plan while sales and marketing spending is above plan. That is a reason to investigate acquisition timing and efficiency. It does not prove that acquisition cost increased: new revenue can depend on contract size, recognition dates and the mix of subscriptions and other services.

Ask the commercial owner for the customer and contract rows behind the shortfall. Ask the department owner which expense accounts explain the spending increase. Keep attribution periods aligned before connecting campaign spend with new customer activity.

Existing cohort A declined against plan while cohort B improved. Ask whether cancellations, expansion, credits or recognition timing explain those differences. Do not call the net cohort movement retention without applying the stated retention definition to the correct customer population.

Record an owner, evidence and forecast implication for each material explanation. The collaborative FP&A guide covers the handoff between finance and department owners. Finish the review with a management decision about which changes affect future periods.

Where SaaS company reviews go wrong

• Mixing revenue measures. Contract bookings, recurring-revenue indicators, recognized revenue and collections enter the same total. Give each a separate definition and schedule.
• Overlapping cohorts. Expansion from an existing customer is classified as both existing and new revenue. Assign each accounting row once.
• Changing cost coverage. Delivery costs move into overhead between periods, creating an apparent margin improvement. Preserve the mapping or show the reclassification.
• Using spend as proof of acquisition performance. Department expense rises, but no aligned customer evidence is supplied. Check the acquisition population and timing first.
• Treating blanks as zero. Missing recognition or department mappings appear as favorable variances. Resolve missing values before publishing the review.

Covirage is not affiliated with Microsoft.

Review your SaaS budget and actuals in Covirage

Bring a sample of your own recognized-revenue schedule, department actuals and matching budget. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.

See Covirage for SaaS teams for the industry context.