Northwest Bank Business Online Banking User Guide

24

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.

1. Click the Choose a file button. 2. Navigate to the file and click the Import button. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J KLMNOPQRST U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a

ACH: Creating a Template J KLMNOPQRST U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a

Made with FlippingBook - Online catalogs