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 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.
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"))
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.
Please note:
It’s important not to change the subscription name in the interworks.cloud platform.
Resellers should also avoid assigning a friendly name during the checkout process for the ESET 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 ESET, please take the following into consideration:
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 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.
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
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:
interworks.cloud | ESET | Note |
|---|---|---|
Account identifier (i.e. Account Description) | Customer Name | |
Subscription | Subscription Name | The subscription name is not included in the ESET billing file and must be added manually. |
Resource | Product | |
Quantity | Monthly Seat Days | |
Start Date | Start Sate | The Start Date is not included in the ESET billing file and must be added manually *(create a new column and put as Start Date the first day of the month, eg. 1/10/2024 |
End Date | End Date | |
Unit Cost | Distributor Final Price | The Distributor Final Price is not included in the ESET billing file and must be added as described above. |
Unit Price | #DAILYPRICE or MSP Daily Price | You can choose either #DAILYPRICE (SRP) or MSP Daily Price (the price you charge your Resellers). For more details check here. |
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 ESET resources is completed, an invoice is created on the same date from our billing engine containing each 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.