Knowledgebase: Partner Operations
Usage Revenue Cost Report
Posted by Tech Support on 10 February 2015 01:41 PM

When trying to calulate Usage Revenue Cost (Reseller), there are a few things needed.

  1. Monthly usage, which may differ depending on the customer's usage for a particular month.
  2. Account Charges, which are $5/month. Check your products' description to see which products have the monthly charges. 
  3. Local DID Charges, which are $1/month. 

 

Monthly Usage

To find the the customer's monthly usage, do the following:

  1. Log in to our support page, http://support.clouditsp.com/.
  2. Once logged in, click on Advanced Report (either from the menu at the top or page options)
    •  If you don't see the option as noted in the screen shot, please call into support.
  3. Select the Date Range and select the customer to find the usage.
    • For a month, go from the 1st to the 1st of the next month. Example: 2015-01-01 to 2015-02-01.
  4. This tool will allow you to Download the information as a CSV file.
  5. Open the CSV file and add the last column called Reseller Cost.
    • This number is the customer's usage cost.
    • Use =SUM(j2:jX), where X is the last row. Example for this CSV: =SUM(j2:j1406) 
  6. Account fees are $5/month. In this example, we have 4 accounts, however only 3 are using the Extension Product that gets charged the $5/month fee. The Feature Product wouldn't get charged the $5/month.
  7. DID's are used when creating Accounts and are $1/month. In this example we have 4 DID's for the accounts.

 

Support Page:

Advanced Report:

Report in CSV format:

Accounts & DID's:

Calculation:

Usage (Advanced Report): $18.015
Accts ($5 x 3 Ext):  $15.000
DIDs ($1 x 4 DID): $4.000
 Total: $37.015

 

So the cost for this customer in the month of January, is $37.015.

NOTE: These numbers are just examples. Numbers will vary from customer to customer and month to month depending on usage.

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).