Calculating real money P&L from the revenue report
Calculating Real Money P&L From The Revenue Report
So how do we calculate the real money P&L from the revenue report?
1. First we need to learn how the different actions affect the balance for example deposit will add funds to the balance while withdrawal will deduct funds from the balance
1. First we need to learn how the different actions affect the balance for example deposit will add funds to the balance while withdrawal will deduct funds from the balance
* P&L = Profit (of the company) - Losses (of the company) - is also an action that deduct funds from the balance
Therefore the balance difference (End of the month - Start of the month) must be equal to all the actions that occured during that month.
2. Second, we need to know how to distinguish between actions that affect real money from bonus actions.
For example - Bonus P&L is an action that will affect the bonus wallet only!
The formula:
Available cash(End date)+Reserved(End date)-Available cash(Start date)-Reserved(Start date) =
Deposit + Refund + Transfer in + Pending bonus released + Tradeable bonus released - Withdrawal - Manual charge - Transfer out - profit cancellation - Real money P&L
Deposit + Refund + Transfer in + Pending bonus released + Tradeable bonus released - Withdrawal - Manual charge - Transfer out - profit cancellation - Real money P&L
Therefore ; Real money P&L = Deposit + Refund + Transfer in + Pending bonus released + Tradeable bonus released - Withdrawal - Manual charge - Transfer out - profit cancellation - [Available cash(End date)+Reserved(End date)-Available cash(Start date)-Reserved(Start date)]
* Note that the revenue report balance area is end of the day data so if you want to check July's information the start date Available cash and Reserved should be from June 30th.