Expected payments can also be created in bulk within Modern Treasury by a CSV upload.
How to Import
Upon clicking "+New Expected Payment" in the righthand side of the Expected Payments page, you will want to select "Bulk Expected Payment" instead of the "Single Expected Payment" option.
From here, you will see the option to download a CSV template:To see more on the information you need to include within the CSV template, click here.
When you're ready to import the Expected Payments CSV, you will want to click the Import Expected Payments button. The following screen will pop up:
Click "Upload data from file." You'll want select your prepared CSV for upload. Once uploaded, the tool will check to see how to map your columns to the accepted fields needed for the Expected Payments upload.
This can catch any cell that needs to be reviewed if we cannot match fields and will flag so that you can update column headers as needed:
Once you've edited the headers to have 100% match, you will be able to review the import before submission:
Once you click "Continue" you will be prompted to confirm the upload. You can still cancel out at this point, but as soon as you confirm upload, the CSV will be imported.
If there are no errors, you will be able to see the confirmation on the import pop up:
If your file turns out to have errors, you might see the following screen:
When you click "Ok", the cell that is causing errors will highlight in red (as well as a pop up text bubble to explain the issue):
From here, you will want to edit your CSV to correct the errors and go through the flow to re-import.