Exact Online is built to record transactions: invoices, payments, ledger. A subscription business lives on something else, namely movement in recurring revenue: new customers, expansion, contraction and cancellations. That movement appears nowhere as a single figure. As a result your revenue can look healthy for months while something breaks beneath the surface that you only see when it is too late.
Download the whitepaper as PDF
What your accounting does and does not see
Exact Online records what has happened. Complete, auditable, fiscally correct. The problem is not the quality of your accounting. The problem is that the question you have has a different shape from the data that is in it.
Your question is about movement: is my customer base growing or draining, and at what cost. That question cannot be answered with one booking. It can only be answered by comparing bookings with each other, over time, per customer.
Exact Online records transactions, not subscription dynamics.
The tipping point
Somewhere between a hundred and two hundred subscriptions no one keeps it in their head any longer. That point is rarely noticed at the time.
Why this only starts to chafe at a certain size
With fifty customers you just knew. You knew them by name, you heard it when someone hesitated, and a cancellation was an event. At two hundred or five hundred subscriptions that sense disappears. Not gradually, but abruptly: the moment you no longer keep it in your head.
From that point you rely on the system to tell you. And then it turns out the system is not about that.
- Your subscription data sits apart from your financial outcomes. What a customer costs to win sits in a completely different part of your bookkeeping than what they bring in.
- Insight comes too late. The picture is only complete once the month is already over, and by then the churn spike is no longer a signal but a fact.
- You depend on someone else. A real answer means waiting until someone exports, cleans up and calculates.
A transaction is a point, a subscription is a line
Take an invoice line from this month. On it are the amount, the customer, the invoice number and the ledger account. What is not on it is everything that gives the line meaning.
| What the invoice line records | What the line does not know |
|---|---|
| This month's amount | Whether that amount is higher or lower than last month, and why |
| That this customer has been invoiced | Whether this customer is new, or has stayed for three years |
| An annual amount on one date | What that subscription is worth per month, comparable to a monthly contract |
| That invoicing continues | That this customer cancelled last month at the end of the term |
| Revenue and costs, each in its place | What this customer cost to win |
The right-hand column does not follow from one line. It follows from comparing every line with the same line a period earlier, per customer, every month again. That is not bookkeeping work. That is a second administration on top of the first.
The moment you do make that comparison, your revenue growth breaks down into five movements. Together they form one line on your income statement. Apart, they tell a different story.
Build-up of recurring monthly revenue over one month. The revenue line here reports an increase of € 1,700. That is the number you see. Underneath sits something else: of the € 5,000 that came in, € 3,300 disappeared again. Two thirds of your new subscription revenue only offsets loss.
Your accounting knows every point. The line those points form appears nowhere.
Steering in the rear-view mirror
What you see too late you can no longer adjust. You can only explain it. Then the churn spike or the falling revenue per customer is no longer a signal you caught in time. It is a fact you are managing. You steer your subscription business in the rear-view mirror: you see sharply where you have been, and nothing of what is coming.
Three things you structurally see too late
- Churn. Cancellations come in as loose events, not as a curve. You only notice a trend once it has been running for a quarter.
- Falling revenue per customer. Your customer count grows, your average revenue per customer falls, your total stays flat. On the revenue line nothing happens, while everything is happening.
- Hollow growth. Revenue rises, entirely on the account of new customers who were more expensive than last year. The base beneath it shrinks.
All three share the same property: they began months before you noticed them. And all three would have been visible in the comparison no one made.
The test: the four questions
How much recurring revenue do you have today, and how much thirty days ago? What share of your customers from last year brings in more this year, and what share less? Which customers have contracted in the past three months without cancelling? And what does it cost you to win a customer? If the answer to one of these four starts with "I would have to look that up", then you have found the blind spot.
What it costs before you see anything
There is a way to make the comparison. Someone exports, someone pastes, someone calculates. Every month again. That is not carelessness, it is the only route there is. But it is useful to write down once what that route involves, because in that list sits the answer to why almost no one keeps this up monthly.
- Export. Pull invoices or ledger movements out of Exact Online, as a file or standard report.
- Clean up. Merge duplicate customers, tie credit notes to the right month, strip out internal invoices.
- Classify. Separate per line what is recurring and what is one-off: implementation, extra work, hours, hardware.
- Normalise. Convert annual, quarterly and monthly contracts back to one comparable monthly value.
- Compare. Lay this month next to last month and determine per customer what has happened.
- Calculate. Derive the build-up of your recurring revenue, plus churn, retention and revenue per customer.
- Distribute. Reconcile against the ledger, explain deviations, send the file round.
Seven steps, every month, by hand. But the turnaround time is not the real objection. The objection is what those hours crowd out. Someone in your business, usually someone you cannot spare, spends a fixed part of every month reconstructing something the accounting already knows but does not show. That time does not go to customers, not to pricing, not to winning back the customers about to leave. It goes to reporting on exactly those things.
And the file is finished the moment it is out of date.
An overview ready on the twelfth describes last month. So you steer structurally on a situation at least four weeks old. All that work does not remove the blind spot. It only makes it a good deal smaller a month later.
The hidden cost
The time that goes to reporting does not go to the business being reported on.
Why the familiar routes do not remove the blind spot
| Route | Where it runs aground |
|---|---|
| A spreadsheet next to Exact Online | Works up to a certain size. After that out of date on delivery, dependent on one person, and untraceable when someone asks about it. |
| The standard reporting in Exact Online | Strong in transaction overviews and tax reporting. Does not know the concept of subscription movement, so no build-up of recurring revenue, no churn, no cohorts. |
| A BI tool | Can in principle do it all. Requires a data model that someone builds and maintains, and moves the dependency to a more technical person. |
| International subscription tools | Built on a billing engine, not on your accounting. Manual invoices outside that engine fall outside it, and the cost side is missing. |
That last one is most often underestimated. A tool that hangs off your billing system knows what that system has invoiced. A tool that hangs off your accounting knows what has happened in the business. Including the invoices you made by hand, and including the costs on the other side.
The fifth route, that no one calls a choice
There is one more route, and it appears in no comparison because it does not seem a choice: doing nothing. Carrying on with revenue and bank balance, and assuming all is well as long as revenue rises.
That is by far the most chosen route. And it is defensible as long as you are small enough to keep it in your head. The problem is that no one notices when that point is passed.
The language to name the problem
Around subscription businesses a shared set of terms has emerged. Talk to an investor, a buyer, a bank or an accountant, and you talk in these terms. They are not complicated, and they are distinct enough from each other to be precise.
MRR/ARR
Recurring revenue
Monthly and Annual Recurring Revenue: your recurring revenue per month and per year, converted back to one comparable measure.
Churn
Attrition
The share of your customers or revenue that leaves in a period. In numbers and in euros those are two different figures.
NRR/GRR
Retention
Net and Gross Revenue Retention: what last year's customer base brings in this year, with and without expansions.
ARPA
Revenue per customer
Average Revenue Per Account: your average revenue per customer. The number that falls while your customer count rises.
LTV/CAC
Value versus cost
Lifetime Value and Customer Acquisition Cost: what a customer brings in over their lifetime, against what they cost to win.
Cohort
Cohort analysis
Groups of customers who joined in the same period, followed over time. Here patterns become visible that fall away in the total.
One warning about that language
There is no reporting standard for ARR. That is not a problem, as long as you have made your own definition explicit and apply it consistently. In practice that rarely happens: the definition sits implicit in formulas and shifts the moment someone resolves an exception. You only notice it during an acquisition, a financing or a change of management.
What this ultimately is
The blind spot is not an accounting problem and not a software fault. It is the difference between recording and seeing. Your accounting records what has happened. It is not built to show you what is happening.
For a business that bases its entire existence on recurring revenue, that is a curious place to have a gap.
A business that runs on recurring revenue should be able to see whether that revenue actually recurs.
About this piece
All amounts and figures in this whitepaper are illustrative, no customer data has been used. This piece gives no financial, tax or reporting advice: always check the treatment of revenue recognition with your accountant.
See whether your revenue actually recurs.
RecurBoard calculates MRR, churn, NRR and cohort retention automatically from your subscription management in Exact Online. No export, no Excel, no separate system next to your accounting. Connect your accounting and start your free 45-day trial.