Azure Usage Reconciliation in Work 365

Work 365 performs a reconciliation check between the Reconciliation file and the Daily Rated Usage file received from Microsoft for a given Provider Invoice. This check ensures that the pre-tax amounts in both files are in agreement within a specified tolerance threshold.

Why Differences Occur

Microsoft uses different levels of decimal precision when generating these files, so minor differences in totals are expected. The tolerance is designed to:

• Account for precision differences
• Catch significant billing errors from Microsoft's end

Setting the Tolerance Threshold

The appropriate tolerance threshold depends on the volume of Azure subscriptions across all customers:

• Small customer base: Threshold may be as low as $0.50
• Larger customer base: Threshold may be increased to $10.00, $50.00, or even $500.00

Adjusting the Default Tolerance

To change the default tolerance for Azure usage:

1. In Work 365, use the area selector at the bottom of the left-hand navigation to switch to the Administration area.
2. Select Admin Hub.
3. In the tab strip at the top, go to Integrations.
4. Find your Microsoft Partner Center integration.
5. On the right side of the row, click the Settings ⚙️ dropdown and choose Edit.
6. Under Partner Settings, enter your desired value for Usage Mismatch Tolerance.
7. Click Save.

Note: If you operate in multiple CSP regions with separate Partner Center connections, you must set the tolerance individually for each connection. Thresholds can vary by region depending on Azure usage volume.

Viewing Checksum Mismatches

If an invoice fails to import due to a checksum mismatch exceeding the tolerance:

• A .csv file is generated listing the line items where the Reconciliation file total does not match the Daily Rated Usage file pre-tax total.
• The file is sorted in descending order by the difference amount to help identify the largest discrepancies quickly.

To download the checksum.csv file:

1. In Work 365, switch to the Provider Management area using the area selector.
2. Select Provider Invoices.
3. In the upper-left of the grid, change the view to Inactive Provider Invoices.
4. Open the errored Provider Invoice.