NCB National Cooperative Bank Treasury 24/7 User Guide

80

Commercial Banking

Upload From CSV File

A list of recipients and amounts can be uploaded via a 5-column Comma Separated Values (CSV) or NACHA file for a new ACH Credit or ACH Debit The CSV file must contain the following columns: Recipient name, Routing transit number, Account number, Account type and Amount. • Account Type is a numeric value: Checking = 1; Savings = 2; and Loan = 3 • For 5-column imports, you will be prompted to select a SEC code, select a Pay From/Pay to account, select a Subsidiary (where applicable) and select an effective date. transactions. NACHA Files • NACHA files are not processed as uploaded into the system. The system is extracting the information (Routing Number, Account Number, Amount(s), Effective Date, SEC Code, and Subsidiary/Originator) needed to create an ACH Payments, ACH Collections, or ACH Payroll Online Banking transaction. To upload a NACHA file and have it processed as uploaded, please use ACH PassThru. • Classifying the payment as PPD or CCD, selecting Pay From/Pay To account, selecting a Subsidiary, and selecting an Effective date should not be necessary as that info should be in the balanced file. • 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 a different account.

11 12 13 14 15 16 17 18 21 22 23 24 25 26 27 28 1 2 3 4 5 6 7 8 K L M N O P Q R U V W X Y Z A B C D E F G H 1a 2a 3a 4a 5a 6a 7a 8a 1b 2b 3b 4b 5b 6b 7b 8b 1c 2c 3c 4c 5c 6c 7c 8c

Creating a New File Map In the Business Banking tab, click Electronic Payments . Select a payment type using the New Payment button and choose ACH Credit or ACH Debit. 1. Click the “Upload From File” link.

1d 2d 3d 4d 5d 6d 7d 8d

Commercial Banking: Upload From CSV File

11a 12a 13a 14a 15a 16a 17a 18a

11b 12b 13b 14b 15b 16b 17b 18b