Rounding Adjustments (RA)

[obar11]

Not sure if this is important here but what I have noticed that for the MCA (or EA) contracts with non-USD currency there is something like rounding adjustment amount. Rounding adjustment will only be visible in Cost Management at the Enrollment scope for Enterprise Agreement (EA) scope or at the Billing Profile scope for Microsoft Customer Agreement (MCA) in Azure Portal, but not in the invoice (cost usage file). But RA is part of FOCUS file. This can cause difference in the cost data validation. Cheers.

[flanakin]

@obar11 Yes, this is correct. The Commerce data ingestion pipeline generates "rounding adjustment" records in all cost details datasets to account for the difference between raw data and how the invoices are aggregated.

To explain why this happens, usage is summed at a meter level per subscription in EA and per invoice section in MCA. Each of these summed values is then trimmed to 0-2 decimal places, depending on the currency (e.g., USD is 2 decimal places, JPY is 0 decimal places). This means a raw data value of 12.3456789 will show as 12.34 on the invoice while the cost data will show an extra 0.0056789. All those extra numbers add up. The rounding adjustment takes away the extra amount so the total matches the invoice.

I'll keep this open and talk to the Cost Management team about documenting this more explicitly.

/cc @jojohpm, @bandersmsft

[jojohpm]

@flanakin : Please see if this doc explains it: https://learn.microsoft.com/en-us/azure/cost-management-billing/automate/understand-usage-details-fields#rounding-adjustment-details

[obar11]

Thanks. Maybe it's worth to highlight that for some currencies RA has different roundings: (e.g., USD is 2 decimal places, JPY is 0 decimal places).