Within Modern Treasury, you have the option to create individual Expected Payments or create Expected Payments in bulk with CSV uploads.

🚧
Case-sensitive values
Values are case-sensitive and should match the guidance shown below.

🚧
Record limit
You can upload a maximum of 1,000 Expected Payments with one CSV.

Create Expected Payments in bulk

Login to Modern Treasury.
Navigate to the Expected Payments Overview page.
From the Create New dropdown menu, select Bulk Expected Payment to go to the Expected Payment 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 Expected Payments 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 Expected Payments. 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 Expected Payments CSV Guidance

Attribute	Required	Data Type	Description
`internal_account_id`	Yes	`string`	The ID for the account you expect the funds to land in.
`amount_lower_bound`	Yes	`integer`	The lowest amount this expected payment may be equal to. Value is in specified currency's smallest unit. e.g. $10 USD would be represented as 1000.
`amount_upper_bound`	Yes	`integer`	The highest amount this expected payment may be equal to. Value is in specified currency's smallest unit. e.g. $10 USD would be represented as 1000.
`direction`	Yes	`string`	The direction of the Expected Payment.
`type`	No	`string`	One of `ach`, `wire`, or `check`. Case sensitive.
`currency`	No	`string`	Currency that the Expected Payment is denominated in.
`date_lower_bound`	No	`date` Format: `YYYY-MM-DD`	The earliest date the payment may come in.
`date_upper_bound`	No	`date` Format: `YYYY-MM-DD`	The latest date the payment may come in.
`statement_descriptor`	No	`string`	This should reflect the statement description you expect to see on the transaction.
`counterparty_id`	No	`string`	The ID of the counterparty you expect for this payment.
`description`	No	`string`	An optional free-form description of the Expected Payment.
`metadata`	No	`string`	Additional data represented as key-value pairs separated by a \| (pipe character). Note: do not include special characters outside of ":" and "\|"