Peoples Bank and Trust Business Accounts

63

Commercial

Import File

If you use a separate accounting software, you can generate a 5-column Comma Separated Values (CSV) file and import it to Corporate Online Banking. When making a new payment, this allows you to quickly add recipients and amounts to payroll, ACH Batches or ACH Collections. Importing a CSV file

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 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

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

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

In the Commercial tab, click Payments. 1. Click the New Payment button and select “Payment From File” from the drop-down. 2. Select the type of payment to send using the “Payment Type” drop-down. 3. Using the “Import File” option and select the CSV file you would like to upload. 4. Click the Upload File to upload the file. 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 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 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 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 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 11a 12a 13a 14a 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 1d 2d 3d 4d 5d 6d 7d 8d 9d J1 A1 B1 C1 D1 E1 F1 G1 H1 I1 Note : The CSV file should contain five columns: Recipient Name, Routing Number, Account Number, Account Type and Amount. 11a 12a 13a 14a 15a 16a 17a 18a 19a 20a A2 B2 C2 D2 E2 F2 G2 H2 I2 A3 B3 C3 D3 E3 F3 G3 H3 I3 11a 12a 13a 14a 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b J2 J3

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

A1 B1 C1 D1 E1 F1 G1 H1 I1 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b

J1

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

J2

A2 B2 C2 D2 E2 F2 G2 H2 I2 J1

A1 B1 C1 D1 E1 F1 G1 H1 I1

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

J3

A3 B3 C3 D3 E3 F3 G3 H3 I3 J2

A2 B2 C2 D2 E2 F2 G2 H2 I2

J3 A1 B1 C1 D1 E1 F1 G1 H1 A2 B2 C2 D2 E2 F2 G2 H2 A3 B3 C3 D3 E3 F3 G3 H3

A3 B3 C3 D3 E3 F3 G3 H3 I3

Commercial: Import File

Made with FlippingBook - Online magazine maker