The Sales menu is divided on:

Payments
Scheduled
Charts

The reports include data on:

Sales of airtime (calls and SMS),
Additional services and products – e.g. DIDs, Intl Mobile Top Up (IMTU), plans and packages etc.
Balance top-ups and balance transfers,
Scheduled payments – subscriptions

The airtime sales is the revenue generated by clients’ calls and SMSes. Every single chargeable traffic event is deducted from the client balance which makes it a debit type transaction. The sum of airtime revenue and the other debit type transactions (sales of DIDs, plans etc.) is the total spending of a client. This figure plus the actual balance value (what is left on the client account) must agree with the credit type transactions made by the client, i.e. must be offset by client’s payments (top ups).

Payments

The data used in the payment reports are stored in the payments table. The events written to this table have different sources as they may come from different voipswitch applications. In general all the transactions that occur on client accounts are stored. The exceptions are the charges for the traffic related events i.e. calls and SMSes. Their costs even though being reflected in the account balances are treated separately.

The following fields are available:

Debit – shows the payment type (name), e.g. DID purchase. In this column only the debit type payments are shown, i.e. the transactions that deduct money from the client balance
Credit – shows the transactions that add money to the client balance
Login – the login of the client who is the transaction’s subject
Amount - the monies which are either deducted or added to the client balance
Description – detailed description of the transaction
Date
Source – the application which executed the transaction, e.g. mobile app, Online Shop etc.

The reports can be filtered by the following criteria:

Period
Login – narrows the report to payments done by a particular client
Client type – shows payments made by clients of a particular type only
Sales type – shows debit or credit or all type of transactions

The filtered records can be exported to a csv file - click on the More/Export menu.

Scheduled TODO

Charts

The sales charts provides the following types of reports:

Airtime sales
Payments

Airtime sales

The data presented in the chart include:

Calls revenue – the sum of all amounts deducted from client accounts for calls completed during the interval
Cost – the total cost for calls completed during the interval, the costs are calculated according to the cost tariffs assigned to destinations (gateways, registrars)
Profit – total revenue minus the total cost
Calls – number of completed calls, in the interval
Calls revenue per call – an average, calculated as total revenue divided by the number of calls
Cost per call – average cost, calculated as total cost divided by number of calls
Markup (%) – the profit divided by the cost
Margin (%) – the profit divided by the revenue (selling price)

The data can be grouped by a destination – a route through which the calls were sent.

Browser not supported