Skip to content

CSV Import for Recipients

Overview

Instead of adding recipients one at a time, you can import multiple recipients from a CSV file. This is useful when onboarding a large list of employees, vendors, or other payees.

Accessing CSV Import

  1. Navigate to ACH Drafter → Setup tab → Step 3: Recipients.
  2. Click the Import CSV button.
  3. The import modal opens with a drag-and-drop upload zone.

CSV Template

To ensure your file is formatted correctly, download the provided template:

  1. In the import modal, click Download CSV Template.
  2. Open the template in your spreadsheet application.
  3. Fill in your recipient data following the column format.

Required Columns

Column Description Example
Name Recipient name (up to 22 characters) Jane Smith
RoutingNumber 9-digit ABA routing number 021000021
AccountNumber Bank account number 123456789
AccountType Checking or Savings Checking

Optional Columns

Column Description Example
IdNumber Recipient identifier (e.g., employee ID) EMP-0042

Uploading Your File

  1. Drag and drop your CSV file onto the upload zone, or click to browse for the file.
  2. The system parses the file and displays a preview.

Reviewing the Preview

The preview shows each row from your CSV classified as:

Badge Meaning
Valid The row passes all validation checks and will be imported.
Skipped The row is a duplicate of an existing recipient and will be skipped.
Error The row has missing or invalid data and cannot be imported.

Error rows display a description of the issue (e.g., "Invalid routing number", "Name is required") so you can correct the data and re-upload.

Confirming the Import

  1. Review the preview summary showing the count of valid, skipped, and error rows.
  2. Click Import to add all valid rows as new recipients.
  3. A success message confirms how many recipients were imported.

Skipped and error rows are not imported. You can fix any errors in your CSV and re-upload to add the remaining recipients.

Tips

  • Save your CSV file with UTF-8 encoding to avoid character issues.
  • Routing numbers must be exactly 9 digits. The system validates the check digit.
  • Duplicate detection is based on the combination of routing number and account number.
  • You can import recipients in multiple batches — new imports are added to your existing recipient list.