Work 365 performs a check between the Reconciliation file and the Daily Rated Usage file received from Microsoft for a given Provider Invoice. The check confirms that the pretax amounts for the two files are in agreement within a certain tolerance. It is expected that there are differences in the totals for the two files as Microsoft uses different levels of decimal precision when creating them. The tolerance can be adjusted to a threshold the covers the decimal precision differences but catches any stark billing errors from Microsoft's end. The tolerance threshold will depend number of Azure Subscriptions provisioned for all customers. If relatively few customers have Azure Subscriptions that tolerance may be $0.50. For partner with a larger base of Azure consumption among their customers that threshold may need to be adjusted to $10.00, $50.00 or even $500.

Adjusting the default tolerance

To adjust the default tolerance for Azure usage:

1. Within Work 365, use the area selector at the bottom of the left-hand navigation to change to the Administration area, then select Admin Hub.
2. In the tab strip at the top of the page, select Integrations.
3. Locate your Microsoft Partner Center integration. At the right edge of the row, select the Settings ⚙️ dropdown and choose Edit.
4. In the Partner Settings grouping, enter your desired threshold for Usage Mismatch Tolerance. Then click Save.

Note: if you sell in multiple CSP regions and have multiple connections those various Partner Center instances, the Usage Mismatch Tolerance must be set for each connection. The tolerance can be different for the different regions depending on the amount of Azure usage in any given region.

Viewing Checksum Mismatches

When an invoice fails to import for a Checksum amount exceeding the specified tolerance, you can download a .csv file that contains the list of line items where the Recon file's total did not match the Daily Rated Usage file's pre-tax billing total. It is sorted in descending order from highest difference amount to lowest difference amount in order to quickly identify highest sources of inconsistency. To view the checksum.csv for a provider invoice:

1. Within Work 365, use the area selector at the bottom of the left-hand navigation to change to the Provider Management area, then select Provider Invoices.
2. In the upper left of the Provider Invoices grid, change the view selector to Inactive Provider Invoices.
3. Select an errored Provider Invoice. In the Timeline section will be a note with the checksum.csv attachment available to download.