All work stories
Anonymized case studyFinancial software / deposit management

Separating SaaS revenue from the money managed for customers

A financial software company was revising its forecast after changing how it made money. Instead of retaining part of the return generated on customer deposits, the revised business would charge prepaid annual software plans while customers kept the yield. The model had to rebuild revenue, acquisition, retention, sales compensation and reporting around that new boundary.

Revenue-model revision and SaaS reportingFinancial model
Fictional business finance teams using a shared deposit-management platform while customer reserves and benefits remain visibly separate from the software operator.
Original concept illustration. No client data shown.
CONFIDENTIAL BY DESIGNWhy you won’t see the client workbook

Financial models contain pricing, salaries, conversion assumptions, funding plans and other sensitive data. I do not publish client workbooks, identifiable screenshots or proprietary inputs—especially where an NDA applies. This page uses an anonymized summary and original concept art to explain the business decision and my modeling approach.

Managed ≠ earnedRevenue boundary

Customer deposits and customer yield remain outside company revenue even though both matter to the product story.

ARR + MRRSaaS operating lens

Recurring-revenue reporting replaces legacy interest-income measures across the dashboard and statements.

Accrual + cashBilling timing

Annual prepayments create immediate cash while subscription revenue is recognized across the contract period.

Plan cohortsGrowth architecture

Acquisition cost, marketing allocation, retention and customer value remain visible by subscription plan.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The reconstructed structure separates company SaaS economics from customer asset and yield economics, then connects both views through plan cohorts, acquisition, retention, annual prepayments and active-customer timing.

01

The monetization changed faster than the model

The earlier forecast treated investment spread as company income and expense. Once customers retained the full yield, those lines had to leave the P&L rather than survive under new labels.

02

Annual billing created two valid monthly stories

Cash arrived with an annual prepayment, but the income statement needed monthly accrual recognition. A single revenue row could not explain both liquidity and recurring performance.

03

Customer value shared inputs with company value

Deposit balance, time under management, assumed yield and customer lifetime determined the customer benefit. Plan price, acquisition cost and retention determined company LTV. The two views needed a bridge, not a blend.

MODEL ARCHITECTURE

From operating activity
to a decision-ready view.

Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.

01

Plan cohorts

Marketing and sales activity create new customers by plan, while retention assumptions roll each cohort into active-customer counts and renewals.

02

Billing and recognition

Prepaid annual contracts generate cash at onboarding and renewal, with revenue recognized monthly through the service period.

03

Company unit economics

Plan pricing, acquisition cost, sales commission, operating expense and customer lifetime build ARR, MRR, subscription LTV and cash contribution.

04

Managed balances

Average customer deposits and days under management translate active cohorts into a separate operating measure of managed assets.

05

Customer yield

Balance, time and yield assumptions calculate annual and lifetime customer benefit without passing that return through the company income statement.

06

Dashboard and statements

Active customers, recurring revenue, managed deposits, modeled customer yield, expenses, profit and cash are reported together but retain clear ownership.

WHAT THE ANALYSIS SURFACED

Useful answers,
without exposing client data.

The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.

Reconstructed insight

Removing interest lines changed the business, not just the labels

The revised company earned subscription fees rather than a spread on customer funds. That changed revenue, gross profit, commissions, recurring metrics and the explanation of customer value at the same time.

Generalized project pattern

Annual prepayment strengthened cash before it strengthened revenue

Upfront collections improved liquidity immediately, while accrual revenue emerged over the contract term. ARR and cash therefore needed separate schedules even when they originated from the same customer.

Reconstructed insight

Assets under management became a product KPI

Managed balances and customer yield helped explain the scale and value of the service, but keeping them outside the P&L prevented a large operational number from inflating company revenue.

Generalized project pattern

The price-to-benefit comparison needed its own scenario

Putting subscription LTV beside modeled customer gain made the value proposition testable under different balance, holding-period and yield assumptions without presenting the return as guaranteed.

MODELING APPROACH

The working system
behind the answer.

  • Subscription-plan pricing, features and billing assumptions
  • Customer acquisition, retention and renewal cohorts by plan
  • Marketing budget, acquisition cost and sales-commission schedules
  • Annual-prepayment cash and monthly revenue-recognition bridge
  • ARR, MRR, active-customer and subscription-LTV reporting
  • Managed-deposit balance and holding-period schedule
  • Annual and lifetime customer-yield scenarios
  • Integrated P&L, cash flow and management dashboard

CASE CONFIDENTIALITY

This anonymized case explains the SaaS pivot and deposit-management logic without naming the company, team, product, customers, dates, plan names, plan count, prices, deposit balances, holding periods, yields, attrition, marketing budgets, acquisition costs, sales terms or private links. The original model, dashboard, source comments, cap tables, cost schedules and video remain private. The illustration is an original fictional financial-software service rather than a real interface, customer workflow or investment product.

CUSTOM PROJECTS START AT $2,500 USD

Need a financial model?
Or the complete business package?

The final fee reflects the agreed scope, complexity and deliverables. Combined packages are quoted individually.