Azure CSV Mappings for Partner Billing

Common Azure CSV Mappings

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-maildickercsv@sync365license.com 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


PAX8

To get your CSV file log into your PAX8 portal, go to Billing> Invoices and click the export CSV button next to the month you want.


  • Customer name: company_name
  • Service Name: details
  • Service Type:<doesnt exist, pick anything>
  • Resource Name:<doesnt exist, pick anything>
  • Cost: cost_total
  • Quantity: quantity
  • Amount: cost_total
  • 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

    • Related Articles

    • Azure billing reconciliation breakdown

      Azure billing reconciliation breakdown This article explains how to review an Azure billing period in Sync 365 and understand the values used to calculate the amount sent to your PSA. Azure billing can include Microsoft retail pricing, distributor ...

    • Azure cost does not match distributor invoice

      Azure cost does not match distributor invoice This article explains why the Azure cost or sell price shown in Sync 365 may not match your distributor invoice exactly, and what to check before contacting support. This is most common for Indirect CSP ...

    • Azure CSP Billing

      To mostly automate your Azure CSP billing we have a fantastic function to allow you to upload your CSV reconcilliation file and automatically bill your customers in your PSA tool! There are a couple components to this Setting up your billing profile ...

    • Azure Automated Billing - Initial Setup (Indirect CSP)

      Overview As an Indirect CSP partner, you work through a distributor to access Microsoft services. This guide covers initial setup including vendor markup configuration to start using our Azure Automated Billing. Prerequisites PSA configured in Sync ...

    • Azure Automated Billing - Overview

      What is Azure Automated Billing? Azure Automated Billing is a feature that streamlines the process of billing your customers for their Azure consumption. Instead of manually uploading CSV files, the system automatically retrieves consumption data ...