Androscoggin Treasury Management Online Banking
141
Commercial Services
Upload From File
You can import a list of recipients and amounts from a 5-column Comma Separated Values (CSV) file to add recipients and amounts to a new ACH Batch, ACH Collection or Payroll. This allows you to import recipients and amounts swiftly and efficiently. Note : 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.
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
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
Creating a New File Map In the Commercial tab, click New Payment (ACH/Wire) . Select a payment type using the New Payment button and choose ACH Batch, ACH Collection or Payroll. J K L M N O P Q R S T U V W X Y Z A B C D E F G H I 1a 2a 3a 4a 5a 6a 7a 8a 1b 2b 3b 4b 5b 6b 7b 8b 1c 2c 3c 4c 5c 6c 7c 8c 1d 2d 3d 4d 5d 6d 7d 8d
1. Click the “Upload From File” link. 2. Click the New Mapping button. 3. Select the CSV file you would like to upload.
11a 12a 13a 14a 15a 16a 17a 18a
10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d
11b 12b 13b 14b 15b 16b 17b 18b
A1 B1 C1 D1 E1 F1 G1 H1 A2 B2 C2 D2 E2 F2 G2 H2 A3 B3 C3 D3 E3 F3 G3 H3
11a 12a 13a 14a 15a 16a 17a 18a 19a 20a
11b 12b 13b 14b 15b 16b 17b 18b 19b 20b
A1 B1 C1 D1 E1 F1 G1 H1 I1
J1
Commercial Services: Upload From File
J2
A2 B2 C2 D2 E2 F2 G2 H2 I2
J3
A3 B3 C3 D3 E3 F3 G3 H3 I3
Made with FlippingBook Digital Publishing Software