action.skip

Cash Metrics

← Reporting and Analytics ← KPI Metrics

Cash metrics display a business's expected cash flow. They track current changes to the amount of one-time, recurring and transactional items of active subscriptions. That is, they produce a cash flow forecast based on current data, but do not show the actual cash flow history.

One cash metric record corresponds to a monthly invoice run for a subscription. That is, JustOn "simulates" an invoice run per month and aggregates the amount of the resulting invoice line items for each subscription in the Amount field of the cash metric record.

Cash metrics are related to the account and the subscription.

MRR metrics or cash metrics?

The decision whether to create MRR metrics or cash metric depends on your reporting requirements. Investors or shareholders of a business may want forecasts on recurring revenues. In this case, you would create account metrics or subscription metrics and build reports based on the produced MRR and churn data. A business's directors or managers, however, may rather need a cash flow forecast – so you would create cash metrics and build reports upon them.

For details on configuring the cash metrics creation, see Cash Metrics.

Cash Metrics Data

Field Description
Subscription The related subscription (primary master-detail); the metric record is deleted when the subscription is deleted.
Account The related account (secondary master-detail); the metric record is deleted when the account is deleted.
Date The effective date of this metric (month and year, always first day of a month)
Amount The sum over all items of this month for the subscription
Month The month of the effective date
Year The year of the effective date

Cash Metrics Generation

Typically, you want JustOn to run the cash metric algorithm when the subscription or a related item changes. To this end, you create dedicated flows that run on subscriptions and items.

The conditions that trigger cash metric updates may include

  • Modified start/end date or activation status for subscriptions
  • Modified next billing date, start/end date, activation status, billing period or modified quantity, price or discount values for items

Implementation Details

If set up accordingly, JustOn creates and updates cash metric records when relevant fields of existing subscriptions or items change.

The following conditions apply:

General

One cash metric record corresponds to a monthly invoice run for a subscription. That is, JustOn "simulates" an invoice run per month and aggregates the amount of the resulting invoice line items for each subscription in the Amount field of the cash metric record.

Cash metrics reflect current values and do not look back. That is, a recent cash metric record cannot reproduce previous changes to a subscription or item.

Consequently, JustOn cannot restore deleted cash metric records.

Relevant period

Since a cash metric record represents a (simulated) monthly invoice run, JustOn applies the same logic for determining the relevant period. That is, an item is subject to the cash metrics generation if its period corresponds – at least partially – to the subscription period and the invoice run period (see Start Date and End Date).

JustOn creates cash metrics up to the specified end date of the subscription or item. If the automatic subscription renewal is enabled, cash metric records are produced for the defined extension period as well.

If there is no end date set, JustOn creates cash metric records for the next 12 months.

With a monthly invoice run on recurring items without end date, you can create new cash metrics on a monthly base. Using the Item field Next Service Period Start as a flow trigger, JustOn will produce cash metric records for the next 12 months with every invoice run.

Amount

With respect to transactional items, the monthly amount of transactional items is derived from the Expected Revenue field of the item record (ONB2__ExpectedRevenue__c).

If this field is empty, the relevant record will be ignored on metrics creation.

Cash Metrics Example

The following example illustrates the cash metrics generation.

There is a subscription with the start date set to 2022-06-01, no specified end date, and the following items:

cash_metrics_items

# Type End Date Notes
1 One‑Time Will be considered once in the cash metric record for the first month of the relevant period
2 Recurring Will be considered for all produced cash metric records – in this case, for 12 months, since there is no end date set for the subscription
3 Recurring Will be considered for the four cash metrics produced up to its end date (June – September)

Based on the given subscription and subscription items, an accordingly configured cash metrics flow produces these cash metric records:

cash_metrics_records

# Amount Included Items
1 18,00 #1: 10,00 (one-time)
#2: 5,00 (recurring w/o end date)
#3: 3,00 (recurring w/ end date)
2..4 8,00 #2: 5,00 (recurring w/o end date)
#3: 3,00 (recurring w/ end date)
5..12 5,00 #2: 5,00 (recurring w/o end date)