Guide

Recurring Billing Report:Active Agreements, Plan MRR, Failed and Expiring Cards, Renewals Due and Visits Owed Against Billed

Recurring billing report for maintenance plans: active agreements, plan MRR, failed and expiring cards, renewals due and visits owed against billed.

By Published Updated

13 min read

A recurring billing report for a service business tracks five figures each month: active maintenance agreements, monthly recurring revenue from plans, failed charges and cards expiring before their next charge, renewals due in the next 60 days, and visits owed against visits billed. Each figure has one formula and one source record, set out below.

The report goes wrong in ways that show up months later. Monthly recurring revenue is read from invoices, so a busy repair month looks like plan growth. An annual plan paid in March counts as March revenue and as nothing for the other eleven months. A card expires, the charge fails, and the plan keeps receiving visits for free. Renewals lapse because nobody listed them, and prepaid visits sit undelivered at year end. This guide is one of the fieldranger.ai invoicing and getting paid guides. It defines the five measures and their formulas, then covers each one in turn, works through a sample month for a 240-agreement book, sets out which HubSpot reports can show each figure at each subscription tier, and closes with a checklist and the software question.

Three terms carry the report. An agreement is a maintenance plan sold to one customer, with a price, a billing frequency, a visit entitlement and a term. Monthly recurring revenue (MRR) is the monthly-normalized value of the agreements in force, as distinct from the cash collected in the month. A visit entitlement is the number of visits the agreement promises in its term.

Recurring billing report: the five measures and their formulas

Each measure is read as of one date, such as the last day of the month, and from one system of record.

The five measures in a recurring billing report
MeasureFormulaSource record
Active agreementsAgreements with start date on or before the as-of date, end date after it, and no cancellationAgreement record in the CRM or billing system
Plan MRRSum of each active agreement's price ÷ months in its billing periodAgreement price and billing frequency
Failed charges and expiring cardsFailed ÷ attempted recurring charges in the month; count of cards expiring before their next charge datePayment system
Renewals due and renewal rateAgreements ending in the next 60 days; renewed ÷ due in a closed periodAgreement end date and renewal status
Visits owed against billedVisits billed in the current term − visits delivered in the termAgreement entitlement, invoices and completed jobs

The five measures answer different questions. Active agreements and MRR describe the size of the book; failed charges and expiring cards describe cash at risk this month; renewals describe next quarter; visits owed describe the work already paid for and not yet done.

Active agreements: status rules and the as-of date

An active count is only as good as its status rules. An agreement is active on a date when it has started, has not ended, and has not been cancelled. A plan whose charge has failed but which has not been cancelled is still active, and belongs in a separate column rather than out of the count.

Stripe's definitions show one consistent way to draw the line. Stripe counts a subscriber as active when it has positive MRR in an active or past_due status, and treats a subscription that is canceled or marked unpaid as churn (Stripe Docs, Billing analytics, checked November 12, 2026). A service business that bills through another system can adopt the same three states: active, past due, and churned.

Churn has a formula of its own. Stripe's subscriber churn rate is the number of subscribers churned in the past 30 days divided by the active subscribers 30 days ago plus the new subscribers in the same 30 days (Stripe Docs, Billing analytics). New agreements are added to the denominator because a customer who signed and cancelled inside the month was at risk of churning in it.

Monthly recurring revenue from maintenance plans

Plan MRR normalizes every agreement to a monthly value, whatever its billing frequency. Stripe defines MRR as the sum of the monthly-normalized value of all subscriptions in active and past_due status, excluding taxes, subscribers on free plans and metered products; its example counts a plan at 600 USD per year as 600 ÷ 12 per month (Stripe Docs, Billing analytics, checked November 12, 2026).

The rule for a service business follows directly:

  • Annual prepaid plan. Price ÷ 12. A $228 plan paid in full in March is $19.00 of MRR in every month of its term, not $228 in March.
  • Monthly plan. The monthly price.
  • Quarterly or per-visit plan. The quarterly price ÷ 3, or the per-visit price × visits per year ÷ 12.

Three things stay out of plan MRR. Repair work sold to agreement customers is job revenue, not plan revenue, even when a member discount applies. Sales tax is collected for the state. One-time set-up fees are paid once. A report that adds them in shows growth in any month the phones are busy.

MRR also has a movement view. Stripe's MRR growth starts with MRR at the beginning of the period, adds new, reactivation and expansion MRR, and subtracts contraction and churn MRR (Stripe Docs, Billing analytics). For a maintenance book, expansion is an upgrade from one system to two, and contraction is a downgrade from a premium plan to a basic one.

Failed charges and expiring cards

A failed charge is cash the business has already earned the right to collect, and the report separates the failures by what fixes them. The failure rate is failed recurring charges divided by attempted recurring charges in the month.

Stripe's decline codes sort the failures into groups with different next steps (Stripe Docs, decline codes, checked November 12, 2026):

  • expired_card: "The card has expired", and the customer needs to use another card.
  • insufficient_funds: the customer needs to use an alternative payment method.
  • issuer_not_available and processing_error: the payment can be attempted again.
  • generic_decline and do_not_honor: the customer needs to contact the card issuer.

An expired card needs a phone call or an email with a payment link; a processing error needs only a retry. A report that shows one total for "failed" sends the office to call customers whose charge would have cleared on the next attempt.

Expiring cards are the failures that have not happened yet. The report lists active agreements whose card on file expires before the agreement's next charge date. Stripe states that it "automatically attempts to update saved card details whenever a customer receives a new card". The service is widely supported for US-issued American Express, Visa, Mastercard and Discover cards, and Stripe adds that it is not possible to identify which cards support automatic updates (Stripe Docs, how cards work, checked November 12, 2026). Because no card can be known in advance to update itself, every card on the list gets a request for new details before its charge date, and the cards that do update drop off the list on their own.

The retry schedule, card-on-file terms and dunning emails behind these figures are covered in the guide to recurring billing for maintenance plans, including the automated charge itself.

Renewals due and renewal rate

A renewal list is a date filter on the agreement's end date. Agreements ending in the next 60 days are the list the office works this month; agreements that ended in a closed period, such as last quarter, give the renewal rate.

The renewal rate is agreements renewed divided by agreements due in the period, both counted on agreements whose end date fell inside it. An agreement that auto-renews still counts as due, because its renewal can fail at the charge, and an agreement cancelled before its end date is churn rather than a non-renewal.

HubSpot builds the list without a reporting add-on. Its documentation shows relative date filters such as "less than 45 days from now" and "more than 10 days ago" on object index pages and in segments, available with all products and plans (HubSpot Knowledge Base, today's date in the CRM, updated February 18, 2026). An agreement end date stored as a date property on the deal, or on whichever record holds the agreement, can be filtered to "less than 60 days from now", and the saved view is the renewal list.

Visits owed against visits billed

The last measure compares the work promised with the work done, in both directions.

Billed ahead of delivery is an obligation. On a prepaid plan, visits owed = visits billed in the current term − visits delivered in the term, and their value is visits owed × the plan's price per visit. That value is money already collected for work the crew has not yet performed, and it is a liability until the visit is made or the money refunded.

Delivered ahead of billing is a leak. On a per-visit plan, visits completed in the month − visits invoiced in the month should be zero. A positive number is work done and not billed, and it grows quietly because the customer has no reason to report it.

A schedule test sits between the two. Entitlement to date = visits in the term × months elapsed ÷ months in the term. Delivered visits below entitlement to date mean the crew is behind on the book, which is the line that predicts a crowded last month and missed visits at renewal.

Sample month: a 240-agreement maintenance book

The sample is a hypothetical HVAC and plumbing company's agreement book on October 31, 2026. Plan prices, counts, failures and visits are sample inputs, labelled as such; the formulas are the ones above, with MRR and churn defined as Stripe documents them.

Sample agreement book, October 31, 2026 (sample inputs)
PlanAgreementsPriceBillingMRR eachPlan MRR
Annual prepaid, 2 visits120$228 a yearOnce a year, on the anniversary$19.00$2,280.00
Monthly, 2 visits80$19 a monthCard on file, monthly$19.00$1,520.00
Quarterly per visit40$75 a visitAfter each visit$25.00$1,000.00
Total240$4,800.00
Sample October figures for the five measures (sample inputs)
MeasureCalculationResult
Active agreements238 at October 1 + 5 new − 3 cancelled240
Subscriber churn rate3 ÷ (238 + 5)1.23%
Plan MRRFrom the table above$4,800.00
Recurring charges attempted10 anniversaries + 80 monthly + 11 per-visit invoices101
Failed charges3 `expired_card`, 2 `insufficient_funds`, 1 `generic_decline`6, or 5.9%
Amount failed3 monthly at $19 + 2 per-visit at $75 + 1 annual at $228$435.00
MRR in past-due status3 × $19 + 2 × $25 + 1 × $19$126.00, 2.6% of MRR
Cards expiring before next chargeCount from the payment system7
Renewals due by December 30Annual agreements ending in the next 60 days22
Renewal rate, August and September18 renewed ÷ 21 due85.7%
Prepaid visits owed240 billed − 151 delivered in current terms89 visits, $10,146.00 at $114 a visit
Schedule test, annual plans240 × 7 ÷ 12 months elapsed on average140 entitled; 151 delivered
Per-visit plans, delivered not billed13 completed − 11 invoiced2 visits, $150.00

Three findings come out of the sample that no single invoice total shows. The $435 that failed is less urgent than its size suggests, because the one annual failure carries only $19 of MRR while three expired cards need a customer to act. The $10,146 of prepaid visits is cash the company holds against work it owes, and it is on schedule only because delivered visits run 11 ahead of entitlement. The $150 leak on per-visit plans is small and grows every month the two missing invoices stay unraised.

Recurring billing reports in HubSpot by subscription tier

HubSpot can show each measure, and the tier decides how. The table below is drawn from HubSpot's knowledge base pages as dated.

HubSpot reporting routes for each measure (HubSpot Knowledge Base, checked November 12, 2026)
MeasureHubSpot routeTier stated by HubSpot
Renewals due, expiring cards (if stored as dates)Index page or segment with a relative date filterAll products and plans ([updated February 18, 2026](https://knowledge.hubspot.com/properties/use-todays-date-in-the-crm))
New and churned subscriptions, MRR waterfall, net new MRRRevenue analytics suite: subscription and contract reportsProfessional or Enterprise, or Revenue Hub ([updated August 21, 2026](https://knowledge.hubspot.com/reports/create-reports-in-the-revenue-analytics-suite))
Billed against actual revenue, invoice status, agingRevenue analytics suite: invoice reportsProfessional or Enterprise, or Revenue Hub ([updated August 21, 2026](https://knowledge.hubspot.com/reports/create-reports-in-the-revenue-analytics-suite))
Visits owed against billed, across objectsCustom report builderProfessional or Enterprise ([updated July 24, 2026](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder))
Formula fields inside a reportCustom report builderData Hub Enterprise only ([updated July 24, 2026](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder))

HubSpot's revenue analytics suite lists subscription reports for new and churned subscriptions and their value, invoice reports for aging summary, balance due, billed against actual revenue and invoice status, and contract reports for MRR waterfall by month, net new MRR and booked MRR (HubSpot Knowledge Base, updated August 21, 2026). The same page lists no failed-payment report, so the failure rate and the decline-code split come from the payment system's own records. The custom report builder sits under Reporting > Reports > Create report > Custom report (HubSpot Knowledge Base, updated July 24, 2026).

A portal below Professional can still run the report. The renewal and expiry lists are saved index-page views, and plan MRR is the count of active agreements per plan times each plan's monthly value, multiplied out in a spreadsheet from an export. The visits measure needs job and invoice counts beside the agreement, which is where the job system comes in.

Recurring billing report checklist

  1. Fix the as-of date and the three states: active, past due, churned.
  2. Store each agreement's price, billing frequency, visit entitlement, start date and end date as properties, not in a note.
  3. Normalize every plan to a monthly value, and keep repair revenue, tax and one-time fees out of plan MRR.
  4. Pull failed charges from the payment system with their decline codes, and split them into retry, new card and contact-issuer groups.
  5. List cards expiring before their next charge date, and request new details for every one.
  6. Save a renewal view filtered to end dates less than 60 days from now.
  7. Calculate the renewal rate on a closed period, counting auto-renewals as due.
  8. Compare visits billed with visits delivered on prepaid plans, and visits completed with visits invoiced on per-visit plans.
  9. Run the schedule test: delivered visits against entitlement to date.
  10. Verify the report: active agreements × average MRR each should equal plan MRR, and the month's attempted charges should match the payment system's count.

Agreement visits and invoice data in FieldRanger

FieldRanger charges an agreement's recurring work automatically to the card on file, so the scheduled charge starts from the same record as the visits. The visit side of the report is where FieldRanger supplies the records.

Recurring job templates create the visits for maintenance contracts and repeat service calls, as the recurring jobs page describes, and job completions, notes and updates are logged to the HubSpot timeline. The invoice is generated from the completed work order, payment can be taken in the field through Stripe, and invoices and payments sync with QuickBooks. The contractor invoicing software page covers that step, and an invoice template shows the fields a per-visit invoice carries. FieldRanger fields can be mapped to HubSpot custom properties, so the job data a report needs can sit on the HubSpot records that HubSpot's report tools read.

Inside FieldRanger, revenue reports show job revenue and margin by customer or service type, and custom reports are built with a drag-and-drop report builder. Scheduled reports email a report to people on a schedule, and any report downloads as CSV or Excel. A monthly scheduled report of completed agreement visits is the count that steps 8 and 9 compare against billing. Plans are listed on pricing, and Start free trial runs 14 days with no card.

Frequently asked questions

What is a recurring billing report?

A monthly report on a business's recurring plans: how many agreements are active, the monthly recurring revenue they represent, which charges failed and which cards will expire before their next charge, which agreements are due for renewal, and how many paid visits are still owed.

How to calculate MRR for annual maintenance plans?

Divide each annual plan's price by 12 and add the results across all active and past-due agreements. A $228 plan paid in March is $19 of MRR in every month of its term; repair work, tax and one-time fees stay out.

How to calculate the failed payment rate for recurring billing?

Divide failed recurring charges by attempted recurring charges in the same month. Split the failures by decline code, since an expired card needs new details from the customer while a processing error needs only a retry.

Can HubSpot report on recurring billing?

Yes, at different tiers. Relative date filters for renewal lists work on all plans; the revenue analytics suite, with new and churned subscription reports, MRR waterfall and invoice aging, needs a Professional or Enterprise hub or Revenue Hub; and the custom report builder needs Professional or Enterprise.

What is the difference between visits owed and visits billed?

Visits billed are the visits a customer has paid for in the current term; visits owed are the part of those not yet delivered. On a prepaid plan, their value is money held against work still to be done.

How to calculate renewal rate for service agreements?

Divide agreements renewed by agreements whose end date fell in a closed period, such as last quarter. Count auto-renewing agreements as due, and treat cancellations before the end date as churn rather than non-renewals.

A maintenance book billing $4,800 a month can hold $10,146 of visits already paid for and not yet made, and no invoice total shows it; the visits-owed line shows that money before a technician has stood in front of each system.

Run field service on HubSpot with FieldRanger

Estimates with e-signature, scheduling and dispatch, a technician mobile app and invoicing, synced to the HubSpot deals and contacts the business already keeps.

Book a demo