Uploading Counterparties

The Counterparty Import tool allows you to create a list of all of your Counterparties to cieTrade.net all at once.

1. Go to the  Counterparties tab.

2. Click on  TasksImport Counterparty.3. Copy and paste the information from you current spreadsheet or accounting system into the upload sheet. These three columns are the required feilds in order to click import.

In the Excel template, the columns highlighted in yellow will be the Counterparty Account information and the blue columns are each location's information associated with the account. If there are multiple locations for one Counterparty, enter it on the next line under the primary location with the same Company Short Name, and enter the location's address in the yellow columns. Company Short Name - This is the name of the business that will appear to users in Counterparty drop-down menus throughout the system. You may choose to enter a short reference name from the Counterparty within this field, as this name is primarily for internal identification of the Counterparty. If you are entering multiple locations within one Counterparty, the Company Short Name for all locations MUST be exactly the same.

PLEASE NOTE: If you are integrating cieTrade.net with an existing accounting company containing Customers and Vendors, the Company Short Name MUST EXACTLY match the name in your accounting system. It may be easier to download that spreadsheet and copy/paste directly. 

Company  Name - This is the name of the company and will display in drop-down menus throughout the system and on documentation. If you enter the same company name with different locations, cieTarde will combine all of the locations together under one Company Name.

Role (Relationship Type) - This refers to the role(s) that will define this Counterparty within the context of your business operations. You can select from the drop down which relationship type you want to set:

Currency - This field is used to establish a default Currency for the Counterparty. You can select from the populated currency dropdown:

Location Label - The Primary Address Label is an assigned name for this particular Counterparty address, which enables users to distinguish this address from other locations. For example, you may enter Invoice as the Label if this address represents the main company Invoice address/location.

Address Line 1 - this is where the street name and number go

Address Line 2 - this is where the suite or room number goes

City - this is the name of the city

Region - this pertains to Canadian and United States addresses

Postal Code - enter the zip code for the address line here

Country - this can be entered as a 2 letter abbreviation or as a whole country name

This is the contact portion, which will populate on documents, and give you the ability to email documents directly out of the system. 

Primary Contact - This is the name of the person who you work with at that Company. To add multiple contacts, enter the same Company name and a new contact per each row. 

Primary Phone - enter the phone number associated with the above contact

Primary Email - enter the email address associated with the above contact

The last portion is all optional and is used for defaults to be pulled into Orders or Worksheets

Primary and Secondary Sales Reps - these will be populated from Settings> Sales Reps

Default Payment Terms - these are also populated from Settings> Payment Terms

Default Expense Account - if you marked the Company role as an expense account (Vendor or Freight) then you will need to enter an expense account.

Credit Limit - If the Counterparty has a credit limit, this can be entered here.

4. Once you have entered the information, click Import Data. You can always edit or revise the information by going to the Counterparty tab. 


If you have additional questions, please contact the Support Team via email to  support@cietrade.net.