For software companies with HubSpot and a subscription business

Before the buyer checks your ARR, I check it.

Before a sale, a succession, an investor coming on board or a funding round, I reconcile your recurring revenue with contracts, invoices, incoming payments and your books. Every number leads back to its source document. Whatever doesn't add up, you know about it before the other side does.

Results on the test dataset of Velmont Software GmbH, a fictitious company with 590 active customers, cut-off date 30 Sep 2026:

ARR
€11.49m
+€799k in twelve months
Net Revenue Retention
101.1%
Gross Revenue Retention 96.0%
Bridge reconciliation
€0.00
difference on both calculation methods
High-impact findings
42
from 23 checks, each with its record

Where ARRproof fits into a transaction

Before the other side starts asking questions, your numbers are backed by documents and the gaps are known. If you start early, you have time to close them.

  1. TodayThe date is set or on the horizon.
  2. ARRproofI analyse HubSpot, invoices, bank and books and present the list of findings within two to three weeks.
  3. Clean-upWhatever can be fixed beforehand gets fixed, directly in HubSpot by us if you like.
  4. Data roomNumbers and exports are ready, each one traceable to its source document.
  5. Due diligenceThe other side's reviewers work with the same data.
  6. SigningOpen data questions are settled by then.

What I look at in your ARR

Three places I check first in established software companies, because that is where a buyer looks most closely.

Schematic ARR bridge: from starting ARR through new customers, moves from maintenance, expansion by volume and price, contraction and churn to ending ARRARR startNew customersFrom maintenanceExpansion volumeExpansion priceContractionChurnARR end
Schematic illustration

The ARR bridge

The bridge shows how the ARR of twelve months ago turns into today’s ARR, through new customers, expansion, contraction and churn. A buyer reads from it where the growth comes from.

It tends to get distorted in two places. When a maintenance customer moves to subscription, they quickly count as a new customer. And a price increase lands in the same bucket as additional licences. I separate both and calculate the bridge two ways until it reconciles without a remainder.

Schematic cohort curve: the same cohort, built once from contract start and once from the CRM field customer since, shows a different course120 %100 %StartYear 1Year 2Year 3Year 4from the contractsfrom “customer since”
Schematic illustration

Cohorts and net revenue retention

Do customers stay, and do they buy more over time? To see this, they are grouped by the year they started, and the revenue of each cohort is tracked.

The start has to come from the contracts. In established portals, the CRM field “customer since” is rarely kept reliably. Grouping by it puts customers into the wrong cohort, and the curve tells a different story.

Schematic reconciliation per customer of contract, invoice and payment, plus invoices against the revenue accounts in the books each monthContractInvoicePaymentCustomer Aconsistent throughoutCustomer Bpayment open over 90 daysCustomer Ccontract without invoiceCustomer Dinvoice without contractEach month: invoices against revenue accounts
Schematic illustration

Contract, invoice, payment, books

The ARR is in the contract. Whether it was also invoiced, paid and booked only shows in the reconciliation, customer by customer and month by month.

Where things drift apart, I look for the reason: contracts without invoices, invoices without contracts, open payments, manual postings. Every gap goes into the list of findings with its record and amount, so you have the explanation before anyone asks.

What you have in hand afterwards

Everything as a view to walk through together and as files for the data room and working papers.

ARR bridge
ARR at the cut-off date and every movement of the last twelve months, per customer
Cohorts
NRR, GRR and customer retention by starting year
Reconciliation
Contract, invoice and books for every month
List of findings
Every affected record with its HubSpot ID and amount
New business and plan
Win rate, loss reasons and a check of your business plan against past figures
Legacy contracts
Maintenance and hosting in the ARR, switches to subscription and the uplift that came with them
Clean-up
What should be corrected in HubSpot before the review, done by us if you like
Source trail
For every customer, the path from the number to the source document

What the other side would otherwise find first

Four findings from the test dataset. In a due diligence, each of them becomes a discussion if the other side finds it first.

R03 Billing gap
€147k

ARR from nine active contracts with no current invoice

R02 Duplicate line items
€36k

ARR overstated because four contract line items appear twice in the CRM

R06 Debtor without CRM company
€169k

from 23 invoices to debtors that don't exist in the CRM

R11 Amount as TCV
114 deals

with the total contract value in the Amount field, where the others hold the annual value

If the other side values your company at a multiple of ARR, every euro it does not accept comes off the purchase price at that multiple.

How much ARR still depends on maintenance contracts

In established software companies, some customers often still have a perpetual licence with a maintenance contract alongside the subscriptions. Whether a buyer accepts that maintenance as recurring revenue is a valuation question. I calculate everything with and without maintenance and show how the customer base has moved to subscription so far.

Schematic customer base per year: the share with subscription grows, the base with maintenance or hosting only shrinksCustomers with subscriptionMaintenance or hosting onlyYear 1Year 2Year 3Year 4Year 5Today
Schematic illustration

In the test dataset, cut-off date 30 Sep 2026:

Customers with maintenance or hosting only
120
20% of active customers
ARR of these customers
€1.72m
14.9% of ARR
Switches to subscription
213
since 2016, 15 of them in the last twelve months
Uplift on switching
1.60×
subscription MRR after twelve months vs. maintenance before, median

How it works

You don't need any new software for this. I work with read access to HubSpot and exports from your systems. The analysis runs on my own tool, so every number is reproducible.

  1. Intro call about the occasion, the date and your systems.

  2. Non-disclosure agreement, read access to HubSpot, exports from ERP and accounting.

  3. I run the analysis and present the list of findings to you within two to three weeks.

  4. We go through the results together, and then you get all documents for the data room.

I'll give you the price after the intro call. It depends on how many contracts and systems are involved.

For due diligence advisors and investors: If an advisor is already engaged, I support their work. Every number can be traced back to its source document and taken over as a file. The judgement stays with the advisor. CogniCore is not an audit firm.

Confidential from the start

Before a sale, usually only a few people know about it. On your side, all it takes is read access to HubSpot and the exports from ERP and accounting. You decide who finds out.

Agreement first

Before I see a single record, we sign a non-disclosure agreement.

Read only

I read HubSpot and change nothing there. Corrections happen only on your explicit instruction.

Analysed locally

The analysis runs on my own computer. What I receive from HubSpot and your exports goes to no cloud or AI service.

Deleted after 30 days

30 days after handover I delete all data I received from you.

Dominik Siegers
About me

Dominik Siegers

I'm the founder and managing director of CogniCore IT Solutions GmbH in Cologne. With my team I help mid-sized companies make their processes clearer and easier to plan, mostly with HubSpot as the central system. I'm also an authorised coach in INQA, a German federal programme, for new business models and the workplace of the future.

I come from IT and ran an IT services company for six years. As a consultant I developed portfolio companies from the owners' point of view, and as an investment manager I built the structures investors used to assess startups looking for capital.

ARRproof is part of this work. It brings together the view of owners and investors and my experience with HubSpot since 2016.

HubSpot Solutions PartnerAuthorised INQA coachMicrosoft PartnerCologne

Tell me your cut-off date.

From data access to the list of findings, I plan two to three weeks. I'll tell you what can be done by your cut-off date.