This page is for subscription brands that ship a physical product: boxes, refills and consumables. If your subscription is an app or a digital product, see our page on fractional CFO for subscription apps.
The cohort view: how do you report subscription revenue by cohort?
A cohort is every subscriber who joined in the same month. Report revenue, subscribers kept month to month and margin for each cohort separately, tracked forward from the month they joined. Subscribers leave at different rates depending on when they joined, which offer brought them in and which channel won them, and a single total hides all of that.
The first thing we build for a subscription brand is a clean cohort table, reconciled to the subscription platform and the accounts, and kept in your monthly management accounts. From there, lifetime value based on how long each cohort really stays, margin per cohort and CAC payback by cohort can be calculated rather than guessed. You see whether newer cohorts behave better or worse than older ones, which is the most reliable early warning a subscription founder can have.
Monthly versus annual prepay: what it does to your cash forecast
Annual prepay brings a full year of cash in at the start but usually needs a discount, which lowers margin on every box. Monthly billing keeps the margin but brings cash in month by month. A brand that needs cash to fund stock growth may lean to annual; a brand running comfortably on cash may lean to monthly and protect its margin. The right answer is a modelled decision, not a default.
We build both into a rolling 12-month cash forecast, alongside your stock purchases, packaging and fulfilment costs, and check it against actuals every month. Annual plans also mean you hold cash for boxes you have not yet shipped, and the forecast shows that obligation so it is not spent twice. This is part of our Fractional CFO service.
How do you calculate margin per subscriber?
Start with what a subscriber pays for each box, then take off the product, packaging, fulfilment, delivery, payment fees and any discount on their plan. What is left is the margin per box. Multiply it by how long that subscriber's cohort actually stays, then compare it with what it cost to win them.
We calculate it every month in the accounts, by plan and by acquisition channel, so you can see which offers and channels bring in subscribers worth having. That view feeds the budget, the scenarios and the board pack in our Fractional CFO service, and the investor model when you raise. Fjor, the D2C skincare brand William co-founded and ran as CFO and COO, cut CAC by 90%. Read the Fjor case study, or see how we work with consumer brands more widely.