Docs

Log in to read the version of docs relevant to your site, or use the dropdown versions

Calculation logic for expected revenue figure on the dashboard

The Expected Revenue figures displayed on the Dashboard (for live sites only) can be calculated using the following formula:

(Payments of this month* - refunds of this month**) + **subscription's next_billing_amount

*Payments of this month are calculated by navigating to Logs->Transactions->and use the filter Transaction date = this month

**Refunds of this month are calculated by navigating to Logs->Transactions->and use the filter Transaction Type is Refund and Transaction Date is This Month.

**Subscription's Next Billing Amount= Navigate to the Subscriptions Page and use the filter Next Billing Date is between 1st to today and Status is Active.

Note:
The calculation can also be configured to include trial_and_future_with_card = true
For this, the calculation above shall also include subscriptions which are in trial and are going to be upgraded this month while it should have a card added on file.
To do this, change the Subscription's Next Billing Amount filter to include status - In Trial and Future and Payment Method Type is Card.

Was this article helpful?