Billing Kaspersky Services
- Panagiotis Papanastasiou
- Niki Rousaki
- Panagiotis Mastrogiannis
On this page, you will find an overview of how you Import the Kaspersky usage records of your resellers' end customers into our platform and how these usage records are processed and invoiced.
Billing occurs monthly and is designed for efficiency, typically requiring only a few minutes to complete. This process involves a simple file modification to ensure compatibility with our platform’s data, followed by the upload of the file through our consumption importer tool. Before finalizing charges, you can review, modify, or restart the import process in case of errors. Invoices are generated per reseller, yet they provide detailed breakdowns for each end customer, with all consumed Kaspersky services itemized on separate lines.
The following video shows how to seamlessly upload your Kaspersky consumption file to the interworks.cloud platform, ensuring accurate monthly charge generation for your resellers.
For more details, follow the simple steps below.
Preparation Before Importing Kaspersky Usage Records
Each month, when you receive the sales report from Kaspersky for each of your resellers, you can prepare it for importing into the interworks.cloud platform. Make sure the file includes these columns:
Customer Name (Column D)
Period Start (Column I)
Period End (Column J)
Product Description (Column M)
Quantity (Column V)
Special Conditions Price (Column S)
Distributor Final Price (Column U)
Our system requires one additional piece of information, which is the “Subscription Name”. When a subscription is created for an end customer, the Interworks.cloud platform automatically uses the customer's name and the service name (e.g., "ABC Company - Kaspersky Services").
To meet this requirement, add a new column (Subscription Name) next to Column D in the Kaspersky sales report. Combine the end customer’s name with the Kaspersky service name as shown in the interworks.cloud platform. You can do this easily using the CONCATENATE function in this format: =CONCATENATE(D7;" - ";"Kaspersky Services").
Once you've made the necessary adjustments, the file is ready for import. Please refer to the screenshot below for the columns required for the import process, marked in green.
Important Notes:
Do not change the subscription name in the interworks.cloud platform.
Resellers should also avoid assigning a friendly name during the checkout process for the Kaspersky PPU service on the Storefront.
If any subscription names are changed, you will need to update the import file to ensure each end customer has the correct subscription name.
When reviewing the Sales Report for Kaspersky, please consider the following:
Which price should be used as the selling price for each service?
We strongly propose using the Special Conditions Price (Column S), which reflects the selling price after all discounts have been applied by Kaspersky even if the MSRP price (Column N) for each service is included in the sales report.Is it possible to invoice my customers in a local currency?
If you wish to invoice your resellers in a secondary currency, you need to add two new columns to the billing file to apply the exchange rates and calculate the prices in your local currency.
Locating the Usage Data Importer
The Usage Data importer tool can be found in BSS by navigating to BSS > Billing > Usage Data.
Within this tool, the BSS user can import Kaspersky usage records along with their billing data and update the initial quantities of newly created PPU Subscriptions, from manually created Excel spreadsheets, directly into interworks.cloud platform.
Importing Kaspersky Usage Records
To import usage records from Kaspersky into the Usage Data tool, each row must be filled in with the respective data representing the Account identifier (it can be the account description), the Subscription name, the Resource name of that subscription (Kaspersky plans), the Quantity of each resource, the Start and End Date of the billing period, the Unit Price and Unit Cost of each resource.
To begin the import of the Excel spreadsheet containing the Kaspersky usages per Subscription resource and per end customer, the BSS user can proceed with the following steps:
Click on the Import File button.
Choose the Import Usage Data with Billing Information method
Then upload the previously created file, by clicking on the Browse button and applying the necessary Excel spreadsheet
Once the Excel spreadsheet is loaded, you have to map the required fields of the import tool with those defined in the billing file from Kaspersky.
These are the following columns for mapping:
interworks.cloud | Kaspersky | Note |
|---|---|---|
Account identifier (i.e. Account Description) | Customer Name |
|
Subscription | Subscription Name | The subscription name is not included in the Kaspersky billing file and must be added manually. |
Resource | Product Description |
|
Quantity | Quantity |
|
Start Date | Period Start |
|
End Date | Period End |
|
Unit Cost | Distributor Final Price |
|
Unit Price | Special Conditions Price |
|
Viewing the Usage Data Import Results
Once the import process is completed, you have the option to select the submission page and review the Usage Data object view page.
On this page, you will find the following sections:
Success Tab: This tab displays the records successfully imported from the Sophos consumption file.
Failed Tab: This tab shows the records that failed to import. You can fix any issues encountered during the import and resubmit these records.
Invoicing of the Kaspersky Usage Records After the Import
Once the import of the Kaspersky resources is completed, an invoice is created on the same date from our billing engine containing each Kaspersky service as an invoice item. The billing period will be defined by the start date specified in the Excel spreadsheet and the end date of the corresponding subscription billing cycle.