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

  1. Login to Modern Treasury.

  2. Navigate to the Counterparties Overview page.

  3. 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.
  4. If you have a file ready, click Import Counterparties to open the import modal.

  5. Click Upload file in the modal and select the CSV you wish to upload.

  1. Once uploaded, the tool maps your columns to the accepted fields needed to create the Counterparties. Verify the mapped columns and click Continue.

  2. The tool will identify any cells that need to be reviewed by highlighting them in red. Make your edits as necessary.

  3. Once you are ready to submit, click on the Submit uploaded data button in the top right.

    1. 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.

    2. 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

AttributeRequiredData TypeDescription
nameYesstringThe legal name that is attached to the Counterparty’s bank account.
emailNostringThe counterparty's email address.
account_numberNostringThe last four digits of the account number for the bank account.
account_number_typeNostringSee Account Details for list of account number types..
routing_numberNostringThe routing number of the bank.
routing_number_typeNostringSee Routing Details for the list of routing number types.
routing_number_2NostringThe 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_2NostringThe type of the second routing number.
account_typeNostringSee Internal Accounts for possible account types.
party_typeNostringEither business or individual.
address_line_1NostringStreet address of the Counterparty.
Required for wires.
address_line_2NostringApartment, suite, or unit number of the Counterparty.
Required for wires.
address_localityNostringCity of the Counterparty.
Required for wires.
address_regionNostringState of the Counterparty.
Required for wires.
address_postal_codeNostringPostal/region code of the Counterparty's address.
Required for wires.
address_countryNostringCountry of the Counterparty.
Required for wires.
metadataNostringAdditional data represented as key-value pairs separated by a | (pipe character).
Note: do not include special characters outside of ":" and "|"
send_remittance_adviceNobooleanIf true, Modern Treasury will send an email to the Counterparty whenever an associated payment order is sent to the bank.