Bulk Counterparty CSV Template Guidance

Counterparties can be uploaded into Modern Treasury, or updated, in bulk using a CSV.

To bulk upload a list of counterparties

Navigate to the Counterparties page, within the "Payments" section. From the 'Create New' dropdown menu in the upper right corner, click on 'Bulk Counterparty'. 

Then click the 'Download Template CSV' link to access the CSV template. 

Once this link is clicked, a CSV file will download and columns can be populated based on the below guidance.

• Column A: Name
  • Required, will need to be the legal name that is attached to Counterparty’s bank account.

• Column B: Email
  • Required only if bank account details for the Counterparty are still needed. If so, then add the email address here in order to send an invitation to the Counterparty directly from MT. 
  • Optional if bank account details are already acquired and able to be entered in template.

• Column C: Account_number
  • Required for both Domestic & International
  • See more info on Account Details here.

• Column D: Account_number_type
  • Required for both Domestic & International. For international payments, use IBAN.
  • See more info on Account Details here.

• Column E: Routing_number
  • Required for wires for both Domestic & International. 
  • This is the routing number of the bank. The format will differ depending on the routing number type that is designated with the counterparty_routing_type field in column G. 
  • See more info on Routing Options here.

• Column F: Routing_number_type
  • Required for International.
  • Should be one of aba, swift, ca_cpa, au_bsb, gb_sort_code, in_ifsc.
  • See more info on Routing Options here.

• Column G: Routing_number_2
  • Optional
  • There are some types of international bank accounts that require two routing numbers: one SWIFT code and one local routing number (e.g. au_bsb, ifsc, ca_cpa, etc.)
  • See more info on Routing Options here.

• Column H: Routing_number_type_2
  • Optional
  • There are some types of international bank accounts that require two routing numbers: one SWIFT code and one local routing number (e.g. au_bsb, ifsc, ca_cpa, etc.)
  • See more info on Routing Options here.

• Column I: Account_type
  • Optional but useful information to include. Can be checking, savings or other.

• Column J: Party_name
  • Required and should match column A, the legal name of the account owner

• Column K: Party_type
  • Optional
  • Either business or individual. More info here.

• Columns L-Q: Address_line1, Address_line2, Address_locality, Address_region, Address_postal_code, Address_country
  • Required for wires both Domestic & International
  • Optional for ACH either way

• Column R: Metadata
  • Optional
  • Additional data represented as key-value pairs. Both the key and value must be strings.
  • See more info about Metadata here.