Within Modern Treasury, you have the option to create Counterparties in bulk with CSV uploads. This is typically used to backfill counterparty data in Modern Treasury, such as when moving from another platform.

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

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`	See Account Details for list of account number types..
`routing_number`	No	`string`	The routing number of the bank.
`routing_number_type`	No	`string`	See Routing Details for the list of routing number types.
`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`	See Internal Accounts for possible account types.
`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.