Sophos MSP Usage Upload - Version 1.0

Overview

The Sophos MSP Usage Upload collector processes Sophos MSP partner billing data from a CSV file export, transforming it into structured records for billing and reconciliation within Varibill.

This collector provides visibility into Sophos product usage across managed service provider (MSP) partner accounts and their end users, including device-based and user-based subscriptions, quantities, and unit pricing, enabling partners to validate Sophos charges and bill customers within Varibill.

The collector retrieves rated usage data, meaning monetary values (cost and total) are included in the data supplied by the source file. Varibill can apply markups to these values without referencing price lists.

This is a point-in-time collector, meaning each execution processes the CSV file provided at the time of collection. The data reflects the billing period covered by the exported file.

For general instructions on creating and running Source Collectors, see: Configuring a New Cloud Source Collector

Collector Summary

About Sophos

Sophos is a cybersecurity company that provides endpoint protection, firewall appliances, email security, cloud security, and managed detection and response (MDR) solutions. Sophos delivers security products and services through a managed service provider (MSP) channel, enabling partners to provision, manage, and bill Sophos security services to their customers.

The Sophos MSP program provides partners with usage and billing reports that detail product consumption across their customer base. These reports include per-end-user and per-device subscription details, product SKUs, quantities, and pricing, enabling partners to reconcile charges and bill their customers accurately.

Data Collected

The Sophos MSP Usage Upload - Version 1.0 collector processes rated MSP partner billing data from a Sophos CSV export file. Each record represents a billing line item for a specific end user or device subscription under a partner account.

The collector captures the following data for each billing record:

• Partner details — partner account name and partner EDI account number
• End user details — end user identifier (company or individual name), end user ID or device serial number, license ID, and device end user company name
• Product details — product description and SKU
• Pricing details — unit price and total quantity, used to calculate cost and total
• Billing period — the end date of the billing period (used as the last seen date)

The following processing is applied during collection:

• Cost and Total are both calculated as the unit price multiplied by the total quantity. No markup is applied during collection.

The identifiers submitted to Varibill for each record are constructed as follows:

• Client Identifier — constructed as {partnerEDIAccountNumber}#{endUserIDOrSerialNumber}. For example: 05418085#X11304BTY22GXAC
• Product Identifier — the Sophos product SKU (for example, XS116Z-MEA-1)
• Record Identifier — the product description (for example, XGS 116 Xstream Protection - MSP Monthly - MEAUSD - Device)
• Unique Identifier — constructed as {chargeNumber}#{externalId}#{licenseID}. For example: C-00510009#0fa778ad-530f-49c1-a0d4-e618c3b86bae#LN5004297955
• Tag — a multi-line value containing: Partner Account Name: {name}, End User Name: {name}, Product Description: {description}, License ID: {licenseId}, and Device End User Company Name: {companyName}

Prerequisites

Before configuring this collector, ensure that:

• You have access to the Sophos MSP partner billing CSV export for your account
• The CSV file follows the standard Sophos MSP billing report format
• You have access to the Varibill Source Collector configuration screen

Input File Format

This collector processes a CSV file exported from the Sophos MSP partner billing system. The file must include the following columns:

Configuration Parameters

The parameters below are entered when configuring the collector in Varibill. This collector has no connection, collection filter, billing, or date range parameters — it processes the CSV file provided at execution time.

Operational Parameters

These parameters control file management behavior.

Configuration Steps

Step 1: Obtain the Sophos MSP Billing CSV

1. Log in to the Sophos Central Partner portal or contact your Sophos distributor.
2. Export or obtain the MSP partner billing usage report in CSV format.
3. Verify that the file includes the required columns listed in the Input File Format section above.

Step 2: Configure the Collector in Varibill

1. In the Varibill User Interface, open the Source Collector configuration screen.

2. Enter the required field values under the Details tab:

   • Hosting Provider: Select Varibill Cloud
   • Source Collector Name: Select Sophos MSP Usage Upload - Version 1.0

3. Save the collector configuration.

Step 3: Run the Collector

Provide the Sophos MSP billing CSV file and run the collector according to your standard Source Collector execution process.

For detailed instructions, see: Configuring a New Cloud Source Collector

Troubleshooting

If the collector fails to process the CSV file, verify that:

• The CSV file is in the correct format and includes all required columns.
• The file is not empty or corrupted.
• Column headers match the expected Sophos MSP billing report format.
• The file encoding is compatible (the collector expects ISO-8859-15 encoding).

If the collector processes the file but produces unexpected results, verify that:

• The Unit Price and Total Quantity columns contain valid numeric values.
• The End Date column contains valid date values in the expected format.
• No required fields (such as Partner EDI Account Number, SKU, or End User ID) are blank for records you expect to see in the output.

Sophos References

The following resources may assist with locating values or obtaining your Sophos MSP billing data.

Sophos Documentation (External)

• Sophos Website