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 uploading 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; however, they provide detailed breakdowns for each end customer, with all consumed Kaspersky ESET services itemized on separate lines.

Follow these simple steps to seamlessly upload your ESET consumption file to the interworks.cloud platform. This will enable you to accurately generate monthly charges for your valued resellers:

Preparation Before Importing ESET Usage Records

Each month, when you download the consumption report from ESET for each of your resellers, you can prepare it for import into the interworks.cloud platform. Make sure the file includes the following columns:

• Site / Customer (Column D)

• Product (Column G)

• Monthly Seat Days (Column J)

• #DAILYPRICE (Column K) - MSRP

• MSP Daily Price (Column N) - Sell price, the price that charges your Resellers

➡️ Our system requires additional prerequisite information that the initial ESET consumption file does not include: Subscription Name, Start & End date, and Distributor's Cost Price.

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., "End Customer 1 - ESET").

To meet this requirement, add a new column (Subscription Name) next to Column D in the ESET consumption file. Combine the end customer’s name with the ESET product name as shown in the interworks.cloud platform. You can do this easily using the CONCATENATE function in this format: =CONCATENATE(D2;" - ";"ESET").

Start & End Date

When a subscription is created, the Interworks.cloud platform automatically uses the Start Date (first day of the month) & End Date (last day of the month) to bill for the covered period.

To meet this requirement, add two new columns (Start Date) and (End Date) as shown in the screenshot below.To ensure proper date display in your spreadsheet, format the relevant cells using the "Format Cells" option and selecting a desired date format.

Distributor’s Cost Price

The distributor unit cost is not included in the initial ESET consumption file. To add it as a column, you'll need to combine a second file, the pricelist. Add the pricelist file in a second sheet in the consumption file.

Follow these two formulas :in order to add the distributor unit cost in your consumption file.

1. To create a Product SKU for the pricelist, concatenate in new Column the Product Code, Price Tier, and Customer Type using this formula:

   =CONCATENATE([@ProductCode],"-B",LEFT([@[Price Tier]],SEARCH("-", [@[Price Tier]])-1),IF([@[Customer Type]]="Regular","-MSP","-MSP-EDU"))

2. Use XLOOKUP to find the Unit Cost based on the Product SKU you created above:

   =XLOOKUP([@SKU],Preisliste!A:A,Preisliste!B:B,0,0)

*Note: Ensure that you put the correct sheet name, eg. in our example that the name of your pricelist sheet is "Preisliste".

Once you've made the necessary adjustments, the file is ready for import. Please refer to the screenshot below for the columns required (red) for the import process, marked in green.

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 ESET 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 ESET Usage Records

To import usage records from ESET 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, 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 ESET usages per Subscription resource and per end customer, the BSS user can proceed with the following steps:

Click on the Import File button.

1. Choose the “Import Usage Data with Billing Information” method

and then upload the previously created file, by clicking on the Browse button and applying the necessary Excel spreadsheet

2. 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 Sophos.

These are the following columns for mapping:

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 ESET Usage Records After the Import

Once the import of the Kaspersky ESET resources is completed, an invoice is created on the same date from our billing engine containing each Kaspersky ESET 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.