SaaS ARR: definition, calculation and recurring revenue bridge

SaaS ARR is the annualized value of eligible recurring subscription charges at a reporting date, measured under a stated company policy. It is a recurring run rate, not GAAP revenue, cash collected or the full value of signed contracts. A valid calculation needs both the contract rows and the rules that decide which rows qualify.

Define the basis before calculating

ARR is a company-defined operating measure. CFI's ARR guide explains why contract structures and inclusion policies differ and why companies should apply their definition consistently.

For the US software company below, the policy is: include fixed recurring subscription and support charges active on October 31, 2026; annualize their current contractual rate; exclude one-time services, uncommitted usage and contracts that have not started. An unchanged renewal replaces the old subscription row when it becomes effective.

That last rule prevents a customer from appearing twice. Finance should own the definition, sales operations should confirm effective dates, and the contract owner should resolve amendments. Keep the approved policy beside the reporting workbook.

A monthly cancellable subscription can qualify under this policy. Its annualized amount remains a run rate; the annualization does not extend the customer's legal commitment. For prepaid contracts, use the covered service months rather than the invoice month.

The ARR formula and export rows

Line ARR = Eligible recurring charge / Months covered × 12

Company ARR = Sum of eligible line ARR at the reporting date

Closing ARR = Opening ARR + New ARR + Expansion ARR − Contraction ARR − Churned ARR

The first formula assumes a flat recurring rate throughout the stated coverage interval. For a ramped contract, use the rate effective at the reporting date under this example's policy, rather than averaging future price increases into today's ARR.

The exclusion of setup and professional service fees is consistent with Wall Street Prep's ARR calculation. Do not divide an entire mixed contract value by its term before separating those charges.

Export customer ID, contract ID, line ID, charge type, recurring amount, months covered, effective start, effective end and currency. Include amendment references and a reporting-date eligibility flag. Billing rows alone may repeat an annual charge across several documents, so identify the underlying contract line before summing.

Calculate the closing balance

All eligible lines below are active on October 31, 2026. Amounts are USD; monthly equivalents and ARR are exact, with no rounding needed.

The charge column totals charges covering different lengths of service. Its $363,000 total is an export control, not a comparable annual measure. Monthly equivalents total $32,000, and multiplying that total by twelve proves the $384,000 ARR.

With charge in B, months in C, monthly equivalent in D and ARR in E, enter these formulas in row 2 and fill through row 6:

=B2/C2
=D2*12

The total check is:

=SUM(E2:E6)-SUM(D2:D6)*12

It must return zero. Reject blank or zero coverage months before applying the formulas; silently replacing them with zero ARR hides missing contract information.

These excluded lines remain visible in a separate control table:

Reconcile the customer movements

Compare customer totals at September 30 and October 31, using the same eligibility rules. Northstar's closing total combines its core subscription and recurring support from the preceding table.

The proof is $342,000 + $72,000 + $12,000 − $6,000 − $36,000 = $384,000. The bridge and the independent closing contract calculation agree. An unchanged renewal has no movement; reactivation would need its own category if a previously churned customer returned.

This identifies different operating questions. Pine explains new customer growth. Northstar's amendment explains expansion. Mariner requires a downgrade review, while Cedar requires a cancellation review. Seat utilization can inform a renewal conversation, but unused seats do not reduce contracted ARR until the effective commercial terms change.

Keep the bookings versus ARR bridge separate: a signed future contract can enter bookings before this policy includes it in ARR. The accounting reconciliation belongs in bookings, billings and revenue.

Where it goes wrong

• Annualizing every invoice. Quarterly charges and annual prepayments need their actual coverage months. An invoice date does not define the recurring rate.
• Including both sides of an amendment. Superseded contract lines must leave the active population when replacement terms begin.
• Treating renewals as new growth. Replacing a subscription at the same rate preserves ARR; adding the renewed amount again doubles it.
• Changing the usage or currency policy. Keep variable consumption separate and disclose any currency translation movement rather than calling it customer expansion.
• Using ARR as recognized revenue. A closing snapshot does not establish what was earned during the preceding year.

Calculate ARR from your own contract export

Bring a sample of your own billing and contract export, with recurring flags and effective dates, to Covirage. Covirage maps the columns, and its tools compute customer ARR and check the opening-to-closing reconciliation; the external AI model explains the movements with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See Covirage for SaaS businesses for the industry context.