Common Azure CSV Mappings

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

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

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

• Customer name: CustomerCompanyName
• Service Name: ServiceName
• Service Type: ServiceType
• Resource Name: ResourceName
• Cost: ListPrice
• Quantity: ConsumedQuantity
• Amount: PretaxCharges
• Multiply Cost by Quantity: YES
• Multiple Certain Fields: NO (These files do not have an RRP only cost price, so we can use the amount column to apply billing profiles)
• UnitPrice
• BillableQuantity
• ExcludePCtoBCExchangeRate:
• PCtoBCExchangeRate:

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: