To help you out we have listed a few of the common Azure CSV mappings we are aware of.

If you're a direct CSP you can download the file from Microsoft Partner Centre 

Click 'Download File' and select Reconciliation-Closed

NOTE: These are a guide, you can also replace fields of your choosing with a field in your csv to display that relevant data on an invoice.

These are in the format of

<Our field name>: <CSV Field name>

Microsoft Direct Partner – New Commerce Experience (Azure Plan)

This is the column layout to map with the Microsoft Direct Partner reconciliation file. (the one you download from the partner center).

• Customer name: CustomerName
• Service Name: ProductName
• Service Type: SkuName
• Resource Name: MeterDescription
• Cost: SubTotal
• Quantity: BillableQuantity
• Amount: SubTotal
• Multiply Cost by Quantity: NO
• Multiple Certain Fields: NO (if using Markup, YES if billing with a different base currency (i.e. CAD/USD)
  • UnitPrice: UnitPrice
  • BillableQuantity: BillableQuantity
  • ExcludePCtoBCExchangeRate: unticked
  • PCtoBCExchangeRate: PCToBCExchangeRate

Synnex Australia (possibly USA too?)

• Customer name: Customer_company_Name
• Service Name: AZU_ServiceName
• Service Type: AZU_ServiceType
• Resource Name: AZU_ResourceName
• Cost: Price_EX
• Quantity: Quantity
• Amount: Amount_EX
• Multiply Cost by Quantity: Yes
• Multiple Certain Fields: NO if you would like to use your own markup, YES if you would like to use RRP
• If YES
  • UnitPrice: RRP_EXC
  • BillableQuantity: Quantity
  • ExcludePCtoBCExchangeRate: NO
  • PCtoBCExchangeRate:

Ingram Micro USA

• Customer name: CustomerName
• Service Name: ProductName
• Service Type: SkuName
• Resource Name: MeterName
• Cost: UnitPrice
• Quantity: Quantity
• Amount: UnitPrice
• Multiply Cost by Quantity: NO
• Multiple Certain Fields: NO (if using Markup, YES if billing with a different base currency (i.e. CAD/USD)
  • UnitPrice: UnitPrice
  • BillableQuantity: BillableQuantity
  • ExcludePCtoBCExchangeRate: unticked
  • PCtoBCExchangeRate: PCToBCExchangeRate

Dicker Data Australia/New Zealand

N.B  when you receive/download the CSV from Dicker please e-mail [email protected] and this will convert the XLS to a CSV.  This will take less than 10 minutes for the conversion.

• Customer name: TENANT NAME
• Service Name: CATEGORY
• Service Type: SUB CATEGORY
• Resource Name: RESOURCE NAME
• Cost: TOTAL AMOUNT (EX)
• Quantity: Quantity
• Amount: TOTAL AMOUNT (EX) 
• Multiply Cost by Quantity: NO
• Multiple Certain Fields: NO