Northwest Bank Business Online Banking User Guide

23

Importing Recipients Using a CSV File Add entries to a template by importing a comma-separated values (CSV) text file. Each line in the file must contain the following fields in the order listed: • Recipient Name: 1 to 22 characters; required • Recipient Nickname: 1 to 40 characters; required • Recipient Institution Name: 1 to 22 characters; required for new recipients only • Recipient Routing Number: 9 digits; required

• Recipient Account Number: 1 to 17 characters; required • Recipient Account Type: Checking, Savings, or Loan; required • Recipient Status: Active or Hold; required • Recipient Group: 0 to 40 characters

• Recipient Discretionary Data: 0 to 2 characters • Amount: Number with no dollar sign; required • Hold: TRUE or FALSE; defaults to FALSE if unspecified • Prenote: TRUE or FALSE; defaults to FALSE if unspecified • Addenda: 0 to 80 characters Please make note of the following requirements: • The first line in the file must contain valid data; the file must not contain a header record. • If any field contains a comma, the entire field must be enclosed in double quotation marks (for example, “1,234.56”). • If any required fields are missing, the file will be rejected. If a field is not required, a blank value can be provided. • If a nickname matches an existing recipient but the other fields do not match that recipient’s existing information, the file will be rejected. If a recipient with the given nickname does not exist, it will be added to the system.

ACH: Creating a Template

Made with FlippingBook - Online catalogs