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

    • Infrastructure Security Overview

      This article is aimed to provide an overview of how we secure our Sync 365 environment and the infrastructure that is used Location and Hosting provider Sync 365 is hosted in Microsoft Azure and is located in Australia datacenters. From a back ...

    • IP Addresses to Whitelist

      If you restrict any access to your PSA tool or Office 365 environments to specified IP’s or a geolocation, you will need to whitelist the following IP addresses. This list of IP’s is a complete list that our scale out platform may use as it scales ...

    • Granular Delegated Admin Permissions - GDAP Overview

      This article explains how Granular Delegated Admin Permissions (GDAP) impact access to customer tenants and the requirements for full functionality in Sync 365. Microsoft Resources for GDAP Granular Delegated Admin Privileges (GDAP) Introduction - ...

    • Override start date for initial sync to your PSA

      When performing your initial set up of Sync 365 License, it is common that you would have already been billing your customers. One feature we have is to override the start date when you first set up your customers. This allows you to time the product ...

    • Pre-Sales Frequently Asked Questions

      What PSA's (Professional service automation) tools does Sync 365 work with? Sync 365 currently integrates with: ConnectWise Manage Autotask (Datto Autotask) Does Sync 365 Integrate with My Microsoft Licensing Vendor? Sync 365 is vendor-agnostic and ...