Create Counterparties in Bulk
A guide to bulk Counterparty creation using CSV uploads.
Within Modern Treasury, you have the option to create individual Counterparties or create Counterparties in bulk with CSV uploads.
Record limit
You can upload a maximum of 1,000 Counterparties with one CSV.
Create Counterparties in bulk
-
Login to Modern Treasury.
-
Navigate to the Counterparties Overview page.
-
From the Create New dropdown menu, select Bulk Counterparty to go to the bulk import page.
- From here, you can click the Download Template CSV button to obtain a template CSV that includes all possible header fields. See the "Bulk Counterparty CSV Guidance" section in this guide for more information about each column.
-
If you have a file ready, click Import Counterparties to open the import modal.
-
Click Upload file in the modal and select the CSV you wish to upload.
-
Once uploaded, the tool maps your columns to the accepted fields needed to create the Counterparties. Verify the mapped columns and click Continue.
-
The tool will identify any cells that need to be reviewed by highlighting them in red. Make your edits as necessary.
-
Once you are ready to submit, click on the Submit uploaded data button in the top right.
-
If there are no errors, you will see a success modal. Click on View Bulk Import to open a new tab to the resulting bulk import.
-
If there are data errors, you will see a submission failure message:
The tool will highlight any cells with remaining errors in red along with an error message. Make your corrections and re-attempt the upload as necessary.
-
Bulk Counterparty CSV Guidance
Counterparty Attributes
Attribute | Required | Data Type | Description |
---|---|---|---|
name | Yes | string | The legal name that is attached to the Counterparty’s bank account. |
email | No | string | The counterparty's email address. |
account_number | No | string | The last four digits of the account number for the bank account. |
account_number_type | No | string | One of iban , clabe , wallet_address , hk_number , nz_number or other . Use other if the bank account number is in a generic format.For international payments, use iban . |
routing_number | No | string | The routing number of the bank. |
routing_number_type | No | string | Should be one of aba , swift , ca_cpa , au_bsb , gb_sort_code , in_ifsc . |
routing_number_2 | No | string | The second routing number. 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 , in_ifsc , ca_cpa , etc.) |
routing_number_type_2 | No | string | The type of the second routing number. |
account_type | No | string | Can be checking, savings or other. |
party_type | No | string | Either business or individual . |
address_line_1 | No | string | Street address of the Counterparty. Required for wires. |
address_line_2 | No | string | Apartment, suite, or unit number of the Counterparty. Required for wires. |
address_locality | No | string | City of the Counterparty. Required for wires. |
address_region | No | string | State of the Counterparty. Required for wires. |
address_postal_code | No | string | Postal/region code of the Counterparty's address. Required for wires. |
address_country | No | string | Country of the Counterparty. Required for wires. |
metadata | No | string | Additional data represented as key-value pairs separated by a | (pipe character). Note: do not include special characters outside of ":" and "|" |
send_remittance_advice | No | boolean | If true , Modern Treasury will send an email to the Counterparty whenever an associated payment order is sent to the bank. |
Updated 9 days ago