Importing recipients and amounts to create a payment

You can import a list of recipients and amounts from a 5‑column CSV file to add recipients and amounts to a new ACH Batch, ACH Collection, or Payroll.

The CSV file must contain the following columns:

  • Recipient name
  • Routing transit number
  • Account number
  • Account type
  • Amount

The recipient name does not need to match an existing recipient. The import uses the name and the order of the file to create recipients and amounts. You can include a recipient multiple times to create multiple payments. The payments can be to the same account or different accounts.

To import recipients and amounts to create a payment

  1. In the navigation menu, click or tap Commercial > Payments.
  2. In the New Payment drop-down list, click or tap Payment From File.
  3. Do the following:
    1. In the Payment Type drop-down list, select the Payment Type.
    2. Click or tap Select a file to import.
  4. In the Open dialog box, locate the file that you want to upload, and click or tap Open. The process to locate the file varies, depending on your device.
  5. On the Payment From File page, click or tap Upload File.

    6. Note:  You can see the recipients and recipient information in a table on the Payment From File - Additional Information page. The table is read-only if the ACH Class Code is PPD or CCD. However, if the ACH Class Code is WEB or TEL, you need to set the Payment Type Code in the Recipients table.

  6. Do the following:
    1. Select an ACH Class Code.
    2. Select the Pay From/Pay To account.
    3. Select the Company/Subsidiary, if required.
    4. Select the Effective Date.
    5. (Optional) Enter a Company Entry Description.
    6. Select a Company/Subsidiary.
    7. (Optional) If you have multiple Recipients, click or tap Single-Entry or Recurring on the Set All To: menu. This option is available when you select an ACH Class code of WEB or TEL, and you can change individual Payment Type Codes in the Recipient information row.
    8. Click or tap Draft or Approve.
  7. In the success message, do one of the following:
    • Click or tap Close.
    • Click or tap View in Activity Center.

Tip:  If the file wasn't uploaded, an error message will prompt you to edit the file before resubmitting it.