Calculation logic for expected revenue figure on the dashboard

Modified on: Fri, 17 Jun, 2022 at 9:43 PM


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.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
×