ACH Origination Manual
Contents
1. 3 Prenota 0 0 0 GGG O GO GO GO O O G Z2 rc AMOE RS on C ERAMI 1z104z808 z 999999999999999 O 00 Prenota rc MHORTH EIC Drap llt 5080 Ed g C3 3 C3 3 3 3 63 3 3 0 00 c PELICAN PACKERS INE 125000024 999999999999999 O 00 Prenota MSIL BOES ET 1d 23220221 a a a a a a 0 00 C o c C C C OD CO C O DO C C c STAR PIJUUCTESETICSEPJ O4 30000096 999999999999999 O 00 Prenote RASMUSSEN PRESS i 0 00 Prenote Coo C OO 0 6 COO DO C DO 3 6 KOTHARI I4 999999999999999 O O0 Prenote SILE DYNASTY masm 1d 211 00782 a a a i 0 00 Prenote gt SOL MATES 1220006681 Prenote STYLES mamam m m 12. BO OO Prenota Ci CI CI CI CI CECI DI 000004 MAREKET GEOMETRY 7z2242507 a a a O 00 Prenota La m L3 oO 5O Dp D D m D Dp Dp La Dp L3 5O m D D D m m Dp La La Dp La Dp CUR ETRUST LEER 3 4 The accept file confirmation page displays 5 Click the Accept button 6 Acceptance confirmation message displays 34 2Eastern Bank Eastern TreasuryConnect Note The Potential Duplicate File page displays when the system finds more than one file matching identically on e Immediate Origin e File Creation Date e File Creation Time e File ID modifier You are given the opportunity to review the information on the potential duplicate files Choose Accept to continue the Pass Thru process or Cancel to cancel the Pass Thru request while researching the duplicate files Note The ACH file will not be sent to the bank until it has been approved See the Approving Pass Thru Files section of this manual for further details C Deleting a Loaded ACH Pass Thru File After loading the file click the Review Pending button Select file to delete Click the Delete button The delete file confirmation page displays Click the Delete button to delete from system Deletion confirmation message displ
3. 1222101 7206 m i i a 0 00 Prenote VW HORSE 06311 0843 EIE Ed 53 53 E3 E3 a a Prenote 2 TM ca VEMLIS FIRE mima E 1220006681 mi a a Frenote 2 2 P4 c Po EREREAEEIESEERESEREREIEESE 1 2012724341715 FPrenote ELEC CJ CI CI CECI EDI CH CH 2 rca CHO COMPUTER SUPPLIES mm im m ir 7 i a ooo q go ogao Prenote Pica EPF IM SSR assess 1 LE CI CI CI CECI CI CI CI LI CIEI 2 rc ASS SHIPPERS SUPPLY m r OF S4045550 O 00 Prenote 6 c VILLI MEITZLE E L iii OS1TOOOSOS C3 3 Prenota CO CD EC DO CD CD LCD DO DIDI LZ 7 i c PRIMARY INDUSTRIES m m mms 0O21 200339 999999999999999 qgo oo Prenote rac IE Thoms PRODO Di i 041d 0001 224
4. 43 SUBMITTING A REVERBSAL REQUEST sh rE ias nan aaa 43 ACH BATCH TOTALS SERVICE 43 CENITI G TOT NR 43 2Eastern Bank Eastern TreasuryConnect l ACH Product Overview Overview The ACH product is an electronic payment amp collection system that creates payment amp collection files that can be processed through the U S Automated Clearing House network The files created by ACH adhere to the operating rules and standards of the National Automated Clearing House Association NACHA The ACH product supports a wide range of applications or payment types such as direct deposit of payroll pre authorized bill payments cash concentration and disbursement and tax payments Individual ACH product services allow Corporate Customers to create ACH transactions and store them in batch files These batch files can be updated with current information and forwarded to the bank as frequently as needed ll Permissions Service Corporate Administrators must complete the following setup tasks before corporate users can utilize the ACH product Grant permissions to ACH services companies transaction types and limits through the User Admin function Use the Permissions Service under ACH Admin to Set approval requirements for ACH batch templates Change the
5. Select All Update Amounts Only Zero All Amounts Freeze All Entry Credit Debit Name ID Number Bank Account Type Amount Disc State Credit John Smith 0980808 011301 798 99999999 Checking 100 00 DB Credit Sue Winter 980887878 011301798 99999999999 Checking 200 00 Delete Selected Active Active 3 Onthe Entry Maintenance page in the Transaction Entries section choose one of the following options e Click the check box in the Entry column for each entry you want to edit e Click Select All to edit all entries in the selected batch e Click Edit Selected to view the Edit Entries page Alternatively you may e Click Update Amounts Only to make changes only in amount fields for all entries in the batch e Click Zero All Amounts to set amount fields for batch entries displayed on the page to zero 0 00 so you can make changes e Click Freeze All to change the Status of all batch entries displayed on the page to Frozen Edit Entries Customer 238156 Eastern Bank Demo Company 1043067724 Eastern Bank Dem Batch Payroll 1 Weekly Payroll Offset Account 600 Eastern Bank Demo USD Transaction Entries Batch Payroll 1 Weekly Payroll PPDCO Zero Amounts Freeze All Entry Credit Debit ID Number Bank Account Type Amount Disc State 1 Credit John Srnith 0980808 011301798 99999999 Checking 100 00 2 Credit 980987878 011301798 99999999999 Checking 200 00 Ba
6. cccsceccsceccsceccececcscscscscascscasescsccscssoscscescscsescasescesecs 2l VI ACH BATCH APPROVAL SERVI E i u u messes u alvo Eee a i ise ortu veau rv Eee curae a as 22 A APPROVING A BATCH NTCRRNRTRETRNERNKRPH E 22 B REJECTING BATCH edusaceszze esset adusoexscrtae o badesevsossvesebtedssaersacraues Dados s cessvescstelssuersdessues 23 C DELETING A ATC ccd cincnccedessscsdndienncnsdaneneabebdnacsedesnasennddssnwesavencatebdnucredesaudeandasxavesawaneabaddancvedeesadeandasxadesaweneads 24 D CANCELING AN APPROVED BATCH ccscecceccececcececcececscscccscuccececeecscaececsscecsecscecesceceecececscesescusescesescusescs 24 VI ACH BATCH TEMPLATE APPROVAL SERVICE 25 A VIEWING BATCH TEMPLATES REQUIRING APPROVAL ccccsccssccsccsccsccsccuscescescessescesscscescessessescesscuscescenses 25 B APPROVING OR REJECTING A BATCH TEMPLATE ccsccccecececcccccececccccececececescecscuceseecesecesessscseecusesescesecacess 26 XI ACH MAP DEFINITION SERVICE 27 A ADDING A DELIMITED MAP DEFINITION ccsceccsceccsceccececccceccecscecececcscecescsccscecesceceececescectsescnsescesescsecs 21 B ADDING A FIXED MAP DEFINITION ccsccececcsc
7. ACH Import Contact Mame 40 testor ACH Map Definition ACH Pass thru Report ACH PassThru ACH PT Approval li Permit the user to ACH companies If still on the User Admin page click the Permissions link otherwise Eastern Bank Eastern TreasuryConnect Click on Corporate User in the drop down list Select the User Admin tab Select a User from the User list and click on the Permissions link Click the box for the ACH companies to be assigned to the user Select the transaction types the user should have The Select All button can be selected to enable all transaction types Click submit User ACH Permissions Select All ACH Companies Transaction Types M Eastern Demo CCD wiAddenda Credits M CCD wiAddenda Debits CCD wiAddenda Mixed Credits and Debits CCD Credits M CCD Debits CCD Mixed Credits and Debits PPD widddenda Credits PPD wiAddenda Debits v PPD wiAddenda Mixed Credits and Debits PPD Credits M PPD Debits v PPD Mixed Credits and Debits Z WEB wiAddenda Debits Establish Limits If still on the User Admin page click the Limits link otherwise 1 Click on Corporate User in the drop down list 2 Select the User Admin tab 3 Click the Limits link to assign limits to users 4 Choose to keep the default amounts as they are or enter the dollar amount the user is limited to for each applicable category 5 Click S
8. Filter By Batch Code Details Edit Filter By Batch Name 122007 test recurring Appraved Payrall 1 Weekly Payroll Approved PayTax1 Payroll Taxes Customer Approved 2 On the Batch Selection page select the company for which you want to add a batch from the Available Companies list and click Add a Batch to display the Add a Batch page Add a Recurring Payment Add a Batch to Company 1043067724 Eastern Bank Dem Batch Code 12 es Transaction Select Transaction Type Deserintion 10 O Offset Account Not Applicable Discretionary Data 20 0 On the Add a Batch page enter a unique Batch Code and Batch Name Select a transaction type from the Transaction Type list box In the Entry Description field enter the description for the batch From the Offset Account list select an offset account for the batch Optional In the Discretionary Data field enter descriptive information to describe the batch Optional To add a Recurring Payment click the Add a Recurring Payment button see Adding Recurring Payments section of this manual for further instructions 9 Select the Add Batch button 10 A confirmation message displays E p Q Eastern Bank Eastern TreasuryConnect B Copying a Batch This service allows you to create a new batch template by copying an existing batch To copy a batch 1 Select
9. Pass Thru Report Selection page enter all or part of the code for the corporate customer in the Code field and click Find Refresh to list all corporate customers who match the search criteria 3 Select the corporate customer from the list for whom you want to generate an ACH pass through report 4 Choose one of the following options To generate an ACH pass through report for a range of e Dates enter the beginning date in the file processing date From field and enter the ending date in the To field Or click the calendar icon Ls to the right of the field to select the dates e File pending numbers enter the beginning file pending number in the file pending From field and enter the ending file pending number in the To field Or click the calendar icon to the right of the field to select the dates e File trace numbers enter the beginning file trace number in the file trace From field and enter the ending file trace number in the To field Or click the calendar icon to the right of the field to select the dates 5 Click Submit to submit the report request and display the ACH Pass Thru Report page 42 2Eastern Bank Eastern TreasuryConnect VIII ACH Reversal Service This service allows the Corporate User to request the reversal of individual transactions or a whole batch submitted on an ACH file using a formatted e mail service A Submitting a Reversal Request To submit the reversal request Select the ACH
10. cm a a i 0 00 Prenota FOOTHILL F Ctm pgs 122030544 a 63 53 Prenote E CI CI CECI CH CIL CI CIL CIL CL CLE a STU EMANS pd EF 100 mam oF 24132908 i i m ri 00O Prenote iii 11184007855 Cd 3 3 3 Prenota 4 z ABLE KEEPERS REBASA OB 300004 7 Prenote JALIEFEPrEEEF C FOREGO MER CLIP ERPEGEGEEJEREEESERERERESENES OS 1TOONS1O d 3 63 3 sa BO EDI CH CH CHE 4 4 GERLINGER CASTING F lt F gt m 123002011 9999999999999939 Prenote SIRT MARIMAA SSSR 1 22222 3 7 rara 7 EI CI CI CI WISER SL LE 111914742 999999999999999 0 00 Prenote C Ir E Tek EREREREBEBRESESEIESEBEBEPBEO ED 1 11 91
11. 3 BASES Live LICHCICHCHEO CIC CIHEICIDCI AE Dp ipic i i Z Z i 1118907445 1 3 545 58 Live MAIL B O ETC Sao CE21 u u0uo0U0oDoD 1 Ed d BS 45 7 Live LC CI CI CI CI CI CH CH CHO CHE CI IS CTE Batch v Std Entry Class C O O Compan iD d 50023939350 Classi Mined O a 4 Conmnpa any Hame ii P 5 Batch Debie 445 Description PAYABLE Batch Credis T 0 00 cO Batch Mersages mn ee eee ee BAe BS S EIuYLEE SALES EREBREBRBEBESEBSESEBESEEBEIEBE 301 3 3 L1 EI CI CI CI Z MICHAELS IEEE L ES RY m mms OS5310211F 999999999999999 BILE Prenote FL S gt gt E a aaa SSP Ses CJ EJ EJ EJ 3 3 FPrenote dq r4 c INTERACTIVE OPTICS a OB400001 9999999999999939 qgo oo Prenote 5 rc KHEN
12. There is 1 pending ACH Pass Thru file requiring your attention To review the detail report and accept or delete a file selectthe Process arrow to the right Load Validation in Progress must complete before a file can be further processed as E 000002 Import TXT 2 17 683 66 47 0 00 0 Cust admin 02 09 2003 11 26 PM Gloss 3 Review the information on the ACH Pass Thru Summary Report Click the Accept button to accept the file into the Magnet ICM system Note The Accept button only appears if the file loads with a successful status ACH Paeee Thru Detail z Printed on Feb OS 2003 at 11 31 Phi Pending Murnbawer O O O O O 2 File Debis 17 693 4 75 File AH Irap art 2T File Credits 0 00 cos 2 File Requested Dya Cust admin Statue Successtul with warninas File Requested on O2foof 2003 11 26 Fre File Warning Messages warning an line Pile ended without a Blocking Batch 7 Sto Entry Cians oor Company liD d 5002339350 Service Class Mined redits Marra 11 P S Batch Debis Boi 629253 Description EIL F gt hd T Batch Credite p 0 00 cO Batch Mersages CET EIST a CE CESS CE a CE L BOOKES ET BESS SS SS 12200080681 Ed d d 3 3 3
13. Transaction Type PPDCO Customer Trace 000299 Approve Selected Reject Selected Reset To Approve a Batch 1 Select the ACH group and click the ACH Batch Approval tab to display the Batch Approval Selection page with activated ACH batches needing approval 2 Choose one of the following options e o approve individual batches click the check box in the Batch column for the batch you want to approve then click Approve Selected e To approve all batches click Select and click Approve Selected The system displays an approval confirmation page B Rejecting a Batch 1 Select the ACH group and click the ACH Batch Approval tab to display the Batch Approval Selection page with activated ACH batches needing rejection 2 Choose one of the following options e reject individual batches click the check boxes in the Batch column on the same row as the batch you want to reject then click Reject Selected e To reject all batches click Select and click Reject Selected The system resets the batch back to an updated state in activation with all updates saved and displays a batch rejection confirmation popup message 23 Eastern Bank Eastern TreasuryConnect C Deleting a Batch 1 Select the ACH group and click the ACH Batch Approval tab to display the Batch Approval Selection page with activated ACH batches needing deletion 2 Click Delete x on the same row as the batch you want to
14. 11 IBI AIEO A BAT H a 11 ADDING DELETING EDITING amp FILTERING ENTRIES IN A BATCH 12 G ADDING RECURRING PAYMENTS u eroe er Yon EP Sess UTR VR HIE SP PI I SPP CPR PICS VRPePEYS 15 IV PARTICIPANTS uiii essi sau vue chins u PE uae Iunone 2 Eoo E ecu re adn uluya sss 17 A uu oM es E I LI EE te ERE 17 V ACH BATCH ACTIVATION SERVICKE 17 A VIEWING BATCHES AVAILABLE FOR ACTIVATION cccsccscecescecececccscccecccscucescuceecsceececscectsescesescesescecescs 18 B CHANGING THE EFFECTIVE ENTRY DATE ss iessiiencacencvcdeuactasassiacenbuntncwnsagsaduedsuaciasenbiaciebensatewsagsadaeduaciaucaiaacands 19 C PRCT IV A TING AINA a ACE nuit macie uM Rata nari 19 D VIEWING DETAILS FOR AN ACTIVE ACH 19 ADDING ENTRIES FROM AN ACTIVE ACH 20 F DELETING ENTRIES FROM AN ACTIVE ACH BATCH1 cccscescsccscececsceccscccscuscscucescscescscscscescscnsescesescesecs 20 G CHANGING ENTRIES IN AN ACTIVE ACH BATCH
15. Pass Thru tab to access the Pass Thru file load page 2 Enter the file s path name or click the Browse button to locate the file Double click on the file name to select it ACH Pass Thru The Path and Browse Load File Clear Review Pending Review Accepted 22 Q Eastern Bank auqa ioad dile butidA message displays stating the load validation process is in progress 4 Click the Close button The ACH Pass Thru laad validatian process is in progress The file will continue ta be processed but your session will return ta the ACH Pass Thru initial page so that you may perform other activities while the laad validation completes Remember to select ACH Pass Thru and Review Pending at later time to complete acceptance or deletion of this file Close B Accepting a Loaded ACH Pass Thru File 1 After loading the file click the Review Pending button once the load process is complete The Pending Pass Thru Report displays The potential duplicate file page displays when the system encounters a duplicate file The Corporate User may accept or cancel the duplicate file The Path and Name C unzippedi 3 4 Import TXT Browse 2 To aCCcp VI A ING VI IGCVICVV LI IZ L CLCGII I L UIIUTN LI IC AII UVV the Process column OR click the Close button to return to the ACH Pass Thru Selection Page 33 Eastern TreasuryConnect Pass Thru
16. Reversal service tab to access the ACH Reversal Entry Page Select Reversal from the drop down choose Batch or Transaction reversal The Reversal Notification Form displays Enter the company name the contact person and the contact phone number For Transaction Reversal enter the name for the item to reverse the account number and the reversal amount do not use commas in amount field and make sure to include decimal Enter the effective date of the transaction and the reason for the reversal request For Batch Reversal enter the batch name total debits total credits effective date file creation date and the reason for the batch reversal request do not use commas in amount field and make sure to include decimal 8 Select the Submit button 9 A confirmation page displays The confirmation page serves as a reference for the Corporate User and can be printed by selecting the Browser s Print button Id oe c XIV ACH Batch Totals Service This service allows the Corporate User to submit ACH file totals to the bank using a formatted e mail service A Submitting Totals To submit the totals 1 Select the ACH Totals tab to access the ACH Totals Entry Page 2 The File Totals Notification Form displays 3 Enter the Customer Name contact person contact phone 4 Enter the Total Debit Amount and the Total Credit Amount do not put any commas in the amount field make sure to include decimal 5 Select the Submi
17. Type Total Debits 0 00 Entry Description payroll Total Credits EH 1 00 Offset Creation Level Batch Total Prenotes 0 Offsct Account 600 Eastern Bank DemofUSD Total Zcro Dollar State O Discretionary Data Total Frozen 9 0 00 Total Zero Amount Active 0 search Entries Fitter By To Sort By Display Preferences Filter f Name 25 Entries per page Display Entrics Save Scarch Settings Transaction Entries Batch Payroll 1 Weekly Payroll PPDCO Credit Debit ID Number Amount Disc 1 Credit John Smith 4444444 011301798 9999999 Checking Return to Batch Selection Page Print this Page 3 Onthe Batch Detail page you can view and print batch and transaction entry detail 11 Eastern Bank Eastern TreasuryConnect F Adding Deleting Editing amp Filtering Entries in a Batch Batch templates can contain a large number of entries When you work with a batch template that contains many entries it is recommended that you Frequently click Update Batch to save your work or Limit your display to 10 to 25 entries per page When you click Next Page or Previous Page to display the next group of entries the system temporarily saves your changes You must click Update Batch to save your changes to the database The Display field in the Filter Section allows you to limit the number of entries that appear on the page To add entries to a batch 1 Sel
18. calculates the default effective entry date for each available batch The system calculates this date in compliance with NACHA standards The effective entry date is the date that the bank posts all entries in the batch to customer accounts You may change the effective entry date prior to activating the batch by typing over the default date or using the calendar icon however the date cannot be earlier than the system default date C Activating an ACH Batch Select the ACH group and click the ACH Batch Activation tab 2 Onthe Batch Activation Selection page select a batch for activation The system displays batches ready for activation that meet the criteria you selected in the Available Batches section 3 Choose one of the following To individually select batches for activation click the check box in the Batch column for each batch and click Activate Selected e select all batches for activation click Select All and Activate Selected 4 The system activates the batches and displays a confirmation popup message D Viewing Details for an active ACH Batch 1 Select the ACH group and click the ACH Batch Activation tab 2 Click Details E on the same line as the batch for which you want to view details The system displays the Batch Detail page with entries for the batch displayed in the Transaction Entries section 3 Optional To print a copy of the Batch Detail page displayed for your records click Print this P
19. delete the participant entry 8 Click Delete Participant Serial Number and all Entries to delete the selected participant V Batch Activation Service The Activation Service allows Corporate User to update entries and activate ACH batches Once a batch has been activated another User or the same User will be required to approve it before it is sent to the bank The approval function occurs through the ACH Batch Approval service 17 Eastern Bank Eastern TreasuryConnect A Viewing Batches Available for Activation Batch Activation Selection Available Batches Available Companies Number of ACH batches available for acti 4 on 9 To edit a batch or remove the Updated Status click the Edit icon beside the desired batch To activate batches select the desired batch es then click Activate Selected 1043067724 Eastern Bank Dem Display Batches Filter By Batch Code Filter By Batch Name Results Select All Batches Company 1043067724 Eastern Bank Dem Select 1043067724 Batches Effective Entry Date m Total Debits 07 0 00 Details ccdpay childsupport Descriptive Date Total Credits sooo Edit Transaction Type Effective Entry Date Total Debits 0 00 Details Fed Tax Federal Tax Payment Examp Descriptive Date Total Credits 0 00 Edit Transaction Type Effective Entry Date 03 20 2008 Total Debits 0 00 Details MA Tax3 St
20. from an active ACH Batch 1 Select the ACH group and click the ACH Batch Activation tab 2 Click Edit i on the same line as the batch for which you want to delete entries Batch Payroll 1 Weekly Payroll PPDCO Select All Update Amounts Only Zero All Amounts Freeze All Entry Credit Debit Name ID Number Bank Account Type Amount Disc State 1 Credit John Smith 0980808 011301798 99999999 Checking 100 00 Active r E Credit Sue Winter 380987878 011301798 99999999999 Checking 200 00 Active Edit Selected Delete Selected 20 Eastern Bank Eastern TreasuryConnect 3 Entry Maintenance page in the Transaction Entries section choose one of the following options e Click the check box in the Entry column for each entry you want to delete and click Delete Selected e Click Select All and Delete Selected to delete all entries in the batch NOTE The system permanently saves your changes Transaction entries are deleted from the database system deletes the entries from the batch template and activation if the batch is in Updated status G Changing Entries in an active ACH Batch 1 Select the ACH group and click the ACH Batch Activation tab 2 Click Edit the same line as the batch for which you want to edit entries Transaction Entries Batch pmt1 Weekly Payroll PPDCO Offset Account 600 Eastern Bank Demo USD Select All Update Amounts Ony Zero All Amounts Freeze C
21. sorted select it from the Sort By list box and click Display Entries e Optional To save the search criteria entered on this page click Save Search Settings G Adding Recurring Payments Corporate users can create recurring payment instructions for ACH payments to be made repeatedly When you add an ACH batch you specify the frequencies of the payments and days of the month the payments should be processed The system automatically activates batches you add with recurring instructions based on the frequency days and times you specify They are activated before the Effective Entry Date associated with the batch Batches with a locked or disabled status are not automatically activated All approval requirements defined for ACH batches apply to recurring payment instructions Recurring payments are identified in the ACH Services group by the Icon To add recurring payment instructions to a batch 1 Selectthe ACH Admin group and click the Batches tab 2 Batch Selection page from the Available Companies list select the company for which you want to add a batch and click Add a Batch 15 Eastern Bank Eastern TreasuryConnect Add a Batch to Company 1043067724 Eastem Bank Dem Batch Code 12 2 Transaction Type Select a Transaction Type EmwDesciphont O Offset Account Not Applicable Discretionary Data 0 LS 3 Complete the fields as noted the Adding a Batch
22. system approves or rejects the templates and displays a confirmation popup message 26 CQ Eastern Bank XII ACH Map Definition Service This service is used by Corporate Users to create maps to identify the format of files they want to import The system accepts Delimited and Fixed maps in addition to the NACHA format Each map will allow the user to add new records or update existing records within a batch template depending on the process mode selected at the time the file is imported Import Maps Results Filter by Map Code Customer Eastern Bank Demo CodeiMap Name NACHA U S Fitter by Map Format CH ALL StdU S ACH Zero Zero Amts Filter by Map Name Standard Create Only Standard Create Only Delimited Add and Update Delimited Add O1PPDCOL Metavante file PPDCOL PPDCOL Import Type Repetitive and Mon Repetitive Repetitive and Non Repetitive Repetitive and Non Repetitive Repetitive and Add a Delimited Map Add a Fixed Map Details Edit Update and Delete Non Repetitive A Adding a Delimited Map Definition To add a delimited map definition 1 Select the ACH Admin group and click the ACH Map Definition tab 2 Import Maps page click Add a Delimited Map Add a Map Customer 238156 Eastern Bank Demo Reminder Batches must be created before Delinuted and Fixed Map Definitions can be used to import a file Import File Map Def
23. the batch name in the Filter by Batch Name field and click Search 25 2Eastern Bank Eastern TreasuryConnect The Available Batches section displays batch templates ready for approval that meet the criteria you selected Templates are grouped by Company ID in ascending order and sorted by Batch Code in ascending order Use the Shift key to select multiple contiguous companies and use the Ctrl key to select multiple non contiguous companies 3 Click the magnifying glass icon in the Details column on the same line as the template you want to review to display the Template Approval Details page B Approving or Rejecting a Batch Template 1 2 Select the ACH Admin group and click the Template Approval tab On the Template Approval Selection page select a template for approval The system displays templates ready for approval that meet the criteria you selected in the Available Batches section To approve templates choose one of the following e To individually select templates for approval click the check box in the Batch column for each template and click Approve Selected e select all templates for approval click Select and Approve Selected To reject templates choose one of the following e To individually select templates for rejection click the check box in the Batch column for each template and click Reject Selected e select all templates for rejection click Select All and Reject Selected The
24. CQ Eastern Bank Eastern Bank TreasuryConnect Automated Clearing House ACH Origination User s Manual NOTE The ACH cutoff time is 6 00 PM ET Monday Friday Any batches created after the cutoff time will be considered as next day This user s manual provides instructions for accessing services found in ACH Admin and ACH services Within the ACH Admin group those services are Batches ACH Import ACH Map Definition Participants Template Approval Permissions VV V V Y V Within the ACH group those services are ACH Activation ACH Batch Approval Exception Report ACH Pass Thru ACH PT Approval ACH PT Report ACH Reversal ACH Report ACH Totals VV V V V V V YV V November 2015 Eastern Bank Eastern TreasuryConnect L ACHPRODUCTOSVERVIEW i u EE 4 II PERMISSIONS SERVICE 4 A ESTABLISHING ACH COMPANY TRANSACTION TYPES AND LIMITS 5 B ACH ADMIN PERMISSIONS NERONE 7 HI TRY E u u u s 9 A ADDING X BATCH I nA 9 B COPYING A BATCH nade EEN OE E 10 C CIANGING A BATCH TREE 10 D DEDBIINOG si MUERTA
25. Combined 4999999999 99 Maximum Limit 10000 00 10000 00 Customer Overall Limit 9999999999 99 9999999999 99 iii User Settings Optional ACH User Settings is for ACH Import Service Only This setting determines the type of file the selected user will import 1 Select the ACH Admin group and click the Permissions tab 2 Onthe Permissions Selection page select the user for which you want to set limits from the Users list 3 Click ACH User Settings from the Permissions Selection Page 4 Change the import type and click Submit lap ACH Map Template 2 Definition w artici parts Approval ACH User Settings EAS0430 EASTERN NEW Requested 2 8 10 at 1 28 23 PM DEMO CUSTOMER EST ADMINS MELISSA HATHAN Import Type Repetitive Only Eastern Bank Eastern TreasuryConnect Ill Batches Service Use the ACH Batch Maintenance service to add copy and manage batch templates for ACH Companies Batch templates serve as models for the transactions to activate After you define batch templates you can use them on an ongoing basis by either using them exactly as they are or changing them as needed Any changes you make to a batch template using the Batch Maintenance service are permanent A Adding a Batch To add a batch 1 Select the ACH Admin group and click the Batches tab Batch Selection Results Available Companies 1043057724 Eastern Bank Dem m Company 1043067774 Eastern Bank Dem ACH Batches
26. Disable Batch Submit Changes On the Edit Batch page you can change any field except the Batch Code and Transaction Type field Click Submit Changes to update the batch information 10 CQ Eastern Bank D Deleting a Batch To Delete a Batch 1 Select the ACH Admin group and click the Batches tab 2 Batch Selection page select an Available Company and click the Delete icon on the same line as the batch you want to delete Delete Batch Delete Batch in Company 1043067724 Eastern Bank Dem Transaction Summary Batch Code Payroll 1 Total Debits NU Batch Name weekly Payroll Total Credits 37 3 00 Transaction Type PPDCO Total Prenotes 0 Entry Description payroll Total Zero Dollar State 0 Offset Creation Level Batch Total Frozen 0 00 Offset Account 600 Eastern Bank Demo USD Total Zero Amount Active 0 Discretionary Data Delete Batch cancer 3 Onthe Delete Batch page you can verify the information and click Delete Batch to delete the batch E Displaying a Batch To Display a Batch 1 Select the ACH Admin group and click the Batches tab 2 Batch Selection page select an Available Company and click the Details icon EX on the same line as the batch you want to display Batch Detail Customer 238156 Eastern Bank Demo 1043067724 Eastern Bank Dem Batch Payroll 1 Weekly Payroll PPDCOJ Batch Summary Transaction Summary Transaction
27. MAR ELECTR OO OST 310591 Seen e e c9 c 9 69 9 6 0 00 Prenote C DO C C C HC D CH C OD D E CI CH ES ODAR GAR Cc pE Jg E OS500270F 999999999999999 O 00 Prenote Po GROUP OB TOOOOs gt e a e c9 c 9 69 9 0 00 Prenota C oc C C C DO C CO DO C C C ES c CRUMS DIRE ST 12271009024 999999999999999 O 00 Prenota noooobDgododDpodgcoo rac VWHIT TA ER S cca O4 32505131 a 0 00 Prenote ooooo0ooooooo0n04 c FLORICA SPEC MLS 999999999999999 Prenote noooononoono00n1 Tc THE STORE C h mam c 0 00 Prenote Coo cob o0 o0 O0 0 0 C1 c DATA cgOIDLIE 211370545 a Prenote Tc TOM ROBINSON mamam m 1 21 a a a i 0 00 Prenota aO ocuococooooou oou3 c CELTA CLEANER OB110250F c ee e e e ee Prenote EC CL CHO CHO CIL OL COLO O CET T ca DISTRIBUTOR Sree
28. Overall limit for a user Select a file type for ACH import CQ Eastern Bank A Establishing ACH Company Transaction Types and Limits Corporate Administrators must complete the following setup tasks before corporate users can utilize the ACH product There are additional steps that need to be taken once the user is setup and permitted ACH i Permit the ACH service to user The first step is to permit the user the ACH service Click on Corporate User in the drop down list Select the User Admin tab Select a User from the User list and click on the Services link poo ode x In the User Service Permissions column select ACH to assign all permissions or select which permissions the user should have 5 Click submit Please note that all possible ACH services are reflected in this screen shot User Information User Service Permissions User Code 12 SELECT ALL User Password 12 Retype User Password 12 User Name 40 Address 1 of 2 40 Address2ot2 40 Sd city 25 State or Province 25 Postal Code 20 01901 ACH Batch Activation ACH Batch Approval ACH Batch Maintenance ACH Exception Report ACH Participant Maintenance ACH Report ACH Reversals Telephone 25 781 5956 4495 Fax Wumber 25 781 596 4464 ACH Template Approval ACH Totals qq4qa4qqq4q qq E Mail 40 demoWmeasternbank com ACH User Permissions Enable Date 10 Oz 03 2010 ACH Import User Type Admin
29. Search for Map Filter by Map Name field and click Search e Map format accept the default ALL option or select the format from the Filter by Map Format list and click Search The system displays import maps matching your criteria in the Results section 3 In the Results section identify the map you want to use when importing an ACH file and A click Import LH on the same line as the map 4 n the Select a File Browse for File section either enter the location and name of the file you want to import in the File Path and Name field or click Browse to display a window where you can locate the file and select it Then click Import File B Enabling Imported Files When you import a NACHA formatted file into the ACH product the system e Adds a new batch template e Displays the message Batch Imported Please Review to the right of the batch template on the Batch Selection page e Selects the Disable Batch check box for the imported batch on the Entry Maintenance page When you import a Delimited or fixed format file into the ACH product the system e Displays the message Batch Locked Import in Progress to the right of the batch template on the Batch Selection page after you click Import File on the ACH Import page e Adds changes or deletes entries from an existing batch template e Selects the Disable Batch check box for the imported batch on the Entry Maintenance page Changes the message to the right of the batch template
30. age 4 Review transaction entries for the selected batch clicking Previous and Next to move among pages and display them 5 Click Return to Batch Activation Selection Page to display that page 19 Eastern Bank Eastern TreasuryConnect E Adding Entries from an active ACH Batch 1 Select the ACH group and click the ACH Batch Activation tab 2 Click Edit i on the same line as the batch for which you want to add entries Entry Maintenance 238156 Eastern Bank Demo Company 1043067724 Eastern Bank Dem Batch Payroll 1 Weekly Payroll PPDCO Offset Account 600 Eastern Bank Demo USD Transaction Entry Credits Only Create Prenote 22 1 Disc Data 2 Number Account Number 17 Oe BankaBA Account Type Checking xl samona Add Entry to This Activation Only Add Entry to Batch 3 Onthe Entry Maintenance page expand the Add Transaction Entry section to enter the participant information Then choose whether you want to add the entries e for the current activation only click Add Entry to this Activation Only e tothe batch permanently click Add Entry to Batch The system updates the batch information and displays the new entries in the Transaction Entries section Note add entries to a batch template and discard changes made to an activated batch click Remove Activation Changes on this page F Deleting Entries
31. ap Adding a Fixed Map Definition oelect the ACH Admin group and click the ACH Map Definition tab On the Import Maps page click Add a Fixed Map 28 Eastern Bank Eastern TreasuryConnect Add a Map Customer 238156 Eastern Bank Demo Reminder Batches must be created before and Fixed Map Definitions can be used to import a file Import File Map Definition Fixed File Map MapCode 12 Skip First Header Record Map Name 40 E Load Zero to Amount Fields Map System will assign Delete Unmatched Batch Template Records Import Repetitive and Non Repetiti w Allow Partial File Import Record Length Fields to Add Match or Update Field Name Match Update Position Replacement Header Definitions Start Length Match Transaction Code Match to this field in the system Update ABA Number 9 Update this field once matched Position Field position on Import File Amount m Account Number 17 Replacement Value ID Number 22 Use this value in place of the Field Position value Disc Payment Type 2 JU LB JU LB Addenda Data 3 Onthe Add a Map page in the Import File Map Definition section enter a unique code for the import map in the Map Code field In the Map Name field enter a name for the map o In the Record Length field enter the length of each record for the import map file which must include ca
32. ate Tax Payments Descriptive Date e Total Credits Ko 0 00 Edit Transaction Effective Entry Date Total Debits 0 00 Details Payroll 1 Weekly Payroll Descriptive Date Total Credits 500 00 Edit Transaction Type PPDCO Activate Selected 1 Select the ACH group and click the ACH Batch Activation tab 2 Onthe Batch Activation Selection page choose one of the following options To display e Batches for activation for all companies to which you are permitted accept the default All Companies setting and click Display Batches e Batches ready for activation for a specific ACH company select the company in the Available Companies list and click Display Batches e specific batch code select a company enter the batch code in the Filter By Batch Code field and click Search e specific batch name select a company enter the batch name in the Filter By Batch Name field and click Search The Available Batches section displays batches ready for activation that meet the criteria you selected Batches are grouped by Company Code in ascending order and sorted by Batch Code in ascending order Use the Shift key to select multiple contiguous companies and use the Ctrl key to select multiple non contiguous companies 18 2Eastern Bank Eastern TreasuryConnect B Changing the Effective Entry Date When you access the Batch Activation Selection page the system
33. ays Click the Close button to return to the File Load Page p C Reviewing an Accepted ACH Pass Thru File 1 Select the ACH Pass Thru tab to access the Pass Thru file load page 2 Click the Review Accepted button The Accepted Files Summary page displays There 5 1 ACH Pass Thru file that has been accepted for transmission to the bank Selecting the delete arrow atthe right deletes the file from this page and deletes the corresponding incoming copy ofthe file It does not delete nar prevent the accepted file from being transmitted to the bank Pend TraceNo Batches Credits Accented By 000001 200304000000 Cust_PO4o00000 2 1780365650 00 0010 Cust admin 0209 2003 i E bat ari w e 3 Select the Delete button to delete the file from the page Note Deleting a file from this page does not prevent the accepted file from being transmitted to the bank 4 Click the Close button to return to the Load Pass Thru Selection Page 35 Eastern Bank Eastern TreasuryConnect E Approving a Loaded ACH Pass Thru File Note To access the ACH Pt Approval tab you must enter a valid SecurelD Challenge Microsoft Internet Explore securlID Login Please enter SecurlD Passcode Passcode Clear Once a valid SecurlD has been accepted you will see the ACH PT Approval Selection screen ort Reversal Report Totals Number of ACH Pass Thru f
34. cens 35 REVIEWING AN ACCEPTED ACH PASS THRU FILE 2 ccceccecescececcsceccecccsceccscucescecescecscscscscnsescesescesescs 35 APPROVING A LOADED ACH PASS THRU FILE ssc0cceccecoesoscoececcocseroscccccccessercscccceccecsecseccccessecsscceces 36 ACILRBPORTS SERVICE uu OR 37 SELECTING ACH BATCHES FOR A REPORT ccccececceccececcccscccsceccsceccsceceececcececscscscsceseecesescecescesescusescesass 37 GENERATING AND EXPORTING AN ACH REPORT ccccceccececcsceccsceccececcececcecececscscscscscesescesescesescusescecacs 38 VIEWING BATCH DETAILS ON AN ACH REPORT 0ccsceececcceccecsceccececcececcscecescecesceceececescecesesctsescesesceceecs 39 CANCELING AN APPROVED BATCH cscecceccececcececcccscescecccsceccececeecscececececsecscuceecsceececeececsescesescesescuseecs 39 ACH EXCEPTION REPORTING SERVICE 40 SELECTING BATCHES FOR AN ACH EXCEPTION REPORT ccsceccsceccececcececcececcecscccscescscesescesescesescusescncacs 40 ACH PASS THRU REPORT SERVICE 42 GENERATING AN ACH PASS THRU REPORT cccccscescsccscsccscececcececcsceccecsccscscsceceecscescscssescesescesescusescecass 42 ACH REVERSAL SERVICE
35. cs section choose one of the following options e Accept the default All Statuses to report on all transaction statuses e Select the status on which you want to report from the Status list From the Group By list select how you want to group batches on the report From the Sort By list select how you want to sort batches on the report From the File Output list select the type of output file you want for the report Optional To generate an export file with the report information click Export Click Submit to submit the report criteria and characteristics then generate and display the ACH Summary Report page 38 CQ Eastern Bank ACH Summary Report Customer Name Eastern Bank Demo For Activation Date Mar 11 2008 Report Summary Report Totals 3 Total Debits B Total Credits Report Summaries by Activation Date Activation Date March 11 2008 Report Totals Total Debits 0 00 Total Credits 8 00 Cust Bank Company Company Batch Batch Tran Eff Entry Name Type Date 435 710001 1043067724 EasternBank Shannon Shannon PPDCO 03 12 2008 50 00 1 00 Deleted Dem Test Payroll 437 710002 1043067724 Eastern Bank Payroll 1 Weekly 03 12 2008 0 00 7 00 Approved C Viewing Batch Details an ACH Report 1 On the ACH Summary Report page click Details Est on the same line as the batch for which you want to view details The sys
36. delete from the system 3 Click OK on the delete confirmation popup message When you delete a batch the system adjusts the following amounts e Daily Entry Limits for the last activating user by subtracting the amount of the batch from the user s Overall Activation limit for the effective entry day totals e Daily Entry Limits for the effective entry day totals by subtracting the amount of the batch from the Customer s Overall Activation limit or the Company Overall Activation limit depending on which one applies to the batch Transaction type limits by user and effective entry date D Canceling an Approved Batch To cancel a batch that has already been approved refer to ACH Reports Service of this manual 24 Q Eastern Bank Eastern TreasuryConnect VI ACH Batch Template Approval Service Use the Template Approval service to approve ACH batch templates After you view batch template details you can choose to approve or reject the template itself Template Approval Options are set up for individual users under the Permissions tab see Permissions section of this manual The Batch Template Approval service is granted to users under the Corporate User Permissions tab If you approve a batch template that requires approval the batch template is then available for use with other ACH services If you reject a batch template that requires approval it is in the rejected state and is available for use only in the ACH Batches serv
37. eccsceccececcececcscecescscecscccscssescescscuceecsceecectecsctscscnsescesesceseecs 28 C CHANGING MAP DEFINITION 55 uu aaa qa kakkusaqkasasiwqkakayayaqayaaqaqhakkuqaqa 30 D DELETING MAP DEFINITION u G rr DISP VE ooo PUR Po Vo too HE PU ORI Urb REV 30 E WIE WING IMPORT MAP FME TE AUS is UU IS suse Asunt tub kac a mat etm poU suena 30 VIII ACH FILE IMPORT SERVICE 31 A IMPORI COATE te 31 IMPORTED 3 IDELE TING OFFSET TRANSACTION S 32 IX PASS THRU SERVICE 32 A LOADING AN ACH PASS THRU FILE wcsoxiucsccceectnducatndaducekeinsaeneierddacheatedsastinaduaensimapeneer dadaeetedsaseeadsdeusiasseawecedes 32 Q Eastern Bank mo om ow XI p XII VIII XIV Eastern TreasuryConnect ACCEPTING A LOADED ACH PASS THRU FILE cernere nre rennen rentre reso se sss se sese sesso sesso teen en 33 DELETING A LOADED ACH PASS THRU FILE c ccccesoscoccecoecssccscccceccecsecceccccocceccscascaccercescscecceccetoscse
38. ect the ACH Admin group and click the Batches tab 2 Onthe Batch Selection page select an Available Company and click the Entries icon on the same line as the batch to which you want to add delete entries Entry Maintenance Customer 238156 Eastern Bank Demo Company 1043087724 Eastern Bank Dem Batch payment ced 0 Offset Account 600 Eastern Bank Demo 20507 Add Transaction Entr Credits Only Create Prenote 2 E Disc Data 2 D Number 15 i Account Number 17 gt Bank ABA 8 Account Type Checking x Amount 11 a Addenda Input Screen Select Addenda Input Sereen Ej Addendum Add Addenda Add Entry to Batch 3 Entry Maintenance Page enter the following information Name name of participant ID Number Account Number Bank ABA 9 digit routing transit number Account Type select from list Amount Addenda Input Screen Select an addenda input screen from the list Optional Click Create Prenote to add the entry as a prenotifcation entry Optional In the Disc Data field enter discretionary data Optional Click Add Addenda if you want to associate an addenda with the entry you are adding to the batch The system displays the Addenda Input screen in a popup window 12 Q Eastern Bank Eastern TreasuryConnect 4 Click Add Entry to Batch to add the entry to the specified batch and display the Batch Sel
39. ection page with the entries you added You will see a confirmation message display that the participant has been added to the batch 5 Continue adding entries or click the Return to Batch Selection Page button To delete entries from a batch 1 Select the ACH Admin group and click the Batches tab 2 Onthe Batch Selection page select an Available Company and click the Entries icon on the same line as the batch to which you want to delete entries Batch Payroll 1 Weekly Payroll PPDCO Select All Update Amounts Only Zero All Amounts Freeze All Entry Credit Debit Name ID Number Bank Account Type Amount Disc State Credit John Smith 0980808 011301 798 99999999 Checking 100 00 Active DE Credit Sue Winter 980887878 011301798 99999999999 Checking 200 00 Active Edit Selected Delete Selected 3 Onthe Entry Maintenance page in the Transaction Entries section choose one of the following options e Click the check box in the Entry column for each entry you want to delete e Click Select All to delete all entries in the selected batch 4 Click Delete Selected to remove entries from the batch 13 CQ Eastern Bank To edit entries in a batch 1 Select the ACH Admin group and click the Batches tab 2 Onthe Batch Selection page select an Available Company and click the Entries icon on the same line as the batch to which you want to edit entries Transaction Entries Batch Payroll 1 Weekly Payroll PPDCO
40. he import map you want to edit 3 On the Edit Map page you can change all of the fields except Map Code and Map Type 4 Click Submit Changes Deleting a Map Definition Select the ACH Admin group and click the ACH Map Definition tab On the Import Maps page click E in the Delete column on the same line as the import map you want to delete On the Delete Map page click Delete Map Viewing Import Map File Details oelect the ACH Admin group and click the ACH Map Definition tab On the Import Maps page click Details on the same line as the import map file for which you want to display details On the Map Detail page review information for the import map definition you selected Optional Click Print this Page to send a copy of the Map Detail page to your printer Click Return to Map Selection Page to display that page 30 2Eastern Bank Eastern TreasuryConnect VIII ACH File Import Service This service allows the Corporate User to import a formatted file into the ACH service DO NOT INCLUDE OFFSET TRANSACTIONS follow Delete Offset Transactions below A Importing a File Select the ACH Admin group and click the ACH Import tab 2 On ACH Import page select one of the following options To search for the import map associated with the batch you want to import by e code enter the code in the Search for Map Filter by Map Code field and click Search e name enter the name in the
41. hes for an ACH Exception Report 1 Select the ACH group and click the ACH Exception Report tab 2 On the ACH Exception Report Selection page in the Search section choose one of the following options To display e Batches for all ACH companies accept the default All Companies in the Available Companies list Only companies to which you are permitted display in the list e Batches for a specific ACH company select the company from the Available Companies list Only companies to which you are permitted display in the list e A specific batch enter the batch code in the Filter By Batch Code field and click Search e specific batch name enter the batch name in the Filter By Batch Name field and click Search The Available Batches section displays batches for the criteria you selected 3 In the Available Recurring Batches section select one of the following options e To select all Available Batches click Select All e o select individual batches click the check box for the batches you want to include on the report 4 n the Report Criteria section click the type of date on which you want to report Activation Date or Effective Entry Date 40 Eastern Bank Eastern TreasuryConnect 5 You can use the calendar next to the fields to include transaction entries on the report for a e Hange of dates enter the beginning date in the From Date field the ending date in the To Date field e Specific date enter that date i
42. ice Template Approval Selection Available Companies Number of new ACH batch templates available for your approval 1 1043067724 Eastern Bank Dem m Number of updated ACH batch templates available for your approval 0 Display Batches Number of deleted ACH batch templates available for your approval 0 Filter By Batch Code To Approve select one or more batch templates and click Approve Selected To Reject select one or more batch templates and click Reject Selected Filter By Batch Mame Company 1043067724 Eastern Bank Dem select All SENSA CHE Company ID 1043067724 Total Debits 0 00 Details EA User Allowed Transaction Type Total Credits 1 00 Example i Last Modified by scrage Approve Selected Reject Selected A Viewing Batch Templates Requiring Approval 1 Select the ACH Admin group and click the Template Approval tab 2 Onthe Template Approval Selection page choose one of the following options to display batch templates ready for approval For all companies to which you are permitted accept the default All Companies setting and click Display Batches For a specific ACH company select the company in the Available Companies list and click Display Batches For a specific batch code select a company enter the batch code in the Filter by Batch Code field and click Search For a specific batch name select a company enter
43. iles requiring approval 1 rove selected files select the desired files and click Approve Selections No FileName Batches File Debits File Credits By L1 000855 1 56 685 28 1 6 685 28 9 238156 03 11 2008 10 59 AM Approve Selections Reset To approve or review delete a loaded ACH Pass Thru file 1 Select the ACH group and click the ACH PT Approval tab 2 Onthe ACH Pass Thru Approval Selection page select one of the following options e Click the check box in the Select column on the same line as a pass thru file you want to approve and then click Approve Selections to display the PT Approval Confirmation Summary page e Click the red arrow in the Review column on the same line as pass thru file you want to review and display it on the Pass Thru Detail Report page e Click the red arrow in the Delete column on the same line as a pass thru file you want to delete and click Y for Yes to the following message Are you sure you want to delete Pass Thru file PT File Number PT File Name 36 Eastern Bank Eastern TreasuryConnect X ACH Reports Service The ACH Report allows the Corporate Customer to view their current and historical ACH data This service also allows you to Export a report in NACHA or CSV Comma Separated Values formats ACH Report Available Companies Company ID Batch Batch Name n 1043067724 Payr
44. inition Delimited File Map Map Code 12 Name 40 Map Type System will assidn Import Type Delimiter End of Record ID Repetitive and Non Repetiti w New Line Fields to Add Match or Update Field Name Match Update Position Replacement Transaction Code r1 None ABA Number 9 Account Number 17 Amount ID Number 22 il Disc Payment Type 2 Addenda Data JUUUUUUL 2 Skip First Header Record Strip Quotes around fields Load Zero to Amount Fields Delete Unmatched Batch Template Records Allow Partial File Import Header Definitions Match Match to this field in the system Update Update this field once matched Position Field position on Import File Replacement Value Use this value in place of the Field Position value 2Eastern Bank 10 11 12 13 Eastern TreasuryConnect On the Add a Map page in the Import File Map Definition section enter a unique code for the map in the Map Code field In the Map Name field enter a name for the map Select a delimiter for the file from the Delimited list Select an identifier that indicates the end of a record from the End of Record ID list Optional If you want the system to ignore the first header record for import files that use this map click Skip First Header Record Select this option if the import file contains header informa
45. lows the Corporate User to change data associated with ACH Participants or delete the participant s record which in turn makes the change in all batches containing that participant A Maintaining Participants To maintain participants 1 Select ACH Admin group from drop down menu 2 Select the Participants tab to access the Participants Entry Page 3 Select the Company from the Company List box 4 Select the Participant from the Participant List box or enter a Participant Code or partial Participant Name and select the Find Refresh button The Participant Data Page is pre filled with information from the database 5 Make the necessary changes to the field entries Note Changes made in the Participants service are permanent changes to the batch template s If an individual s payment needs to be divided between checking and savings accounts make sure the individual ID is unique for each payment 233150 Companies 238156 ascern Bank Dem ACH Parnicipants TH WM mm 1043057724 Easterr Bank Dem 104305 4 Bank Dem PYYTTEN IU Bordon Batch pm Payroll PPD Credits Entry Credit Debit Name ID Number Bank Account Type Amount Disc State Last Active Delete 1 Cradit Test Person 444444 011301788 1111 Checking 0 00 Active Jul 7 2007 1 Submit Charges Reset Delete Participant 444444 6 Select the Submit Changes button to change the participant s information 7 Select Delete Participant to
46. n both the From Date field and the To Date field 6 From the Exception Reasons drop down list select the reasons for which you want to report exceptions 7 Inthe Characteristics section select how you want to group entries on the report 8 Click Submit to view the ACH Exception Report page ACH Exception Report Company 1043067724 Company Company Narme Batch Tran Type Eff Entry Date Credit dem 1043067724 Eastern Bank Dem 122007 testrecurring PPDCO 12 28 2007 000 0 00 1043067724 Eastern Bank Dem 122007 testrecurring PPDCO 01 25 2008 B 0 00 0 00 1043067724 Eastern Bank Dem 122007 testrecurring 02 29 2008 50 00 50 00 E Return to ACH Exception Report Selection 9 On ACH Exception Report page click the Error Details icon to display descriptions of errors that caused the batch with recurring payments to fall 10 Click Return to ACH Exception Report Selection to return to that page 41 Eastern Bank Eastern TreasuryConnect XII ACH Pass Thru Report Service Use the ACH Pass Thru Report service to request and display the ACH Pass Thru report This report displays all activity for ACH pass thru files processed through the ACH product A Generating an ACH Pass Thru Report uwawan file processing date 03 20 2008 HE file pending file trace Submit Reset Select the ACH group and click the ACH PT Report tab 2
47. oll payroll test 1043067724 ccdpay childsupport 1043057724 Fed Tax Federal Tax Payment Examp All Batches 2 1043067724 MA Tax3 State Tax Payments 2 lay All Compa mpanies 1043067724 Eastern Bank Dem Available Batches Filter By Batch Code Filter By Batch Name Report Criteria Type of Date From Date To Date activation E 0371972008 _ E From To Customer Trace Number Bank Trace Number Report Characteristics Status Group By Sort By Date lt Customer Trace Number File Output Comma Delimited C A Selecting ACH Batches for a Report 1 Select the ACH group and click the ACH Report tab 2 On ACH Report page in the Search section choose one of the following options display e Batches for all ACH companies accept the default Display All Companies in the Available Companies list Only companies to which you are permitted display in the list e Batches for a specific ACH company select the company from the Available Companies list Only companies to which you are permitted display in the list e History for all available and deleted batches associated with the selected company click All Batches All of the company s batches are included no subset of batches is allowed 37 2Eastern Bank Eastern TreasuryConnect 19 c op e All batches or a subset of batches associated with the selected company click Available Batche
48. on the Batch Selection page to Batch Imported Please Heview after you click Accept on the ACH Import Batch Detail page 3l Eastern Bank Eastern TreasuryConnect Before the batch template is available for activation you must e Review the batch template and verify that the imported information is correct e Select an offset account e Clear the Disable Batch check box C Deleting Offset Transactions If your file has an offset transaction entry follow these steps to delete the offset oelect ACH Admin group and click the Batches tab Select the Edit icon next to the imported batch Delete the offset entry You may add change or delete any other entries at this point Select Submit Changes pr duces x D ut If more than one batch needs to be reviewed repeat these steps See the Adding Deleting Editing amp Filtering Entries in a Batch section of this manual for further information IX Pass Thru Service Use the ACH Pass Thru service to load and manage ACH files built externally from the ACH product When you load an ACH pass thru file the system validates that the format of the records in the file matches the standard NACHA formats After the validation is complete you accept the pass thru ACH file which sends the ACH file to the ACH Approval service for approval Once approved the file is sent to the bank for processing You cannot edit pass thru files A Loading an ACH Pass Thru File 1 Select the ACH
49. redit Debit ID Number credit John Smith 8080808 011301798 099 9999399999 Chec ing Active DE est Persor 444444 011301 798 11111 Chec ing Active Edit Selected Jelete Selected Debits 0 00 Zer3 Dollar State 0 creats 0 rrozen EE 500 Prenotes 0 zero Amount Active 1 Highlighted Entries have not been activated in the last 120 days Save Changes to Ihis Actrvation Only Activation Changes Update Batch Reset Page Return to Batch Selection Page 3 Entry Maintenance page in the Transaction Entries section choose one of the following options e Click the check box in the Entry column for each entry you want to edit e Click Select All to edit all entries in the selected batch e Click Edit Selected to view the Edit Entries page Alternatively you may e Click Update Amounts Only to make changes only in amount fields for all entries in the batch e Click Zero All Amounts to set amount fields for batch entries displayed on the page to zero 0 00 so you can make changes e Click Freeze All to change the Status of all batch entries displayed on the page to Frozen 21 Q Eastern Bank Eastern TreasuryConnect 4 On the Edit Entries page make changes to batch entries displayed and click Save Changes You will see the following message Microsoft Internet Explorer X 9 Changes this page are temporarily being saved Ru vau must click the Save Changes to This Ac
50. roval Options Same User Allowed Same User Required Different User Required PPDCO PPD Credits O 5 On the Template Approval Options Page chose one of the following options for the transaction type or Same for all Transaction Types e None default e Same User Allowed Batch add change delete requests by this user can be approved by this user or a different user e Same User Required Batch add change delete requests by this user must be approved by the same user under the Batch Template Approval tab e Different User Required Batch add change delete requests by this user must be approved by a different user under the Batch Template Approval tab 6 Click Submit ii User Overall Limits Optional Allows the Corporate Administrator to set overall activation limits to be applied to all batches activated by the selected user for the same effective entry date Eastern Bank Eastern TreasuryConnect 1 Select the ACH Admin group and click the Permissions tab 2 Onthe Permissions Selection page select the user for which you want to set limits from the Users list 3 Click User Overall Limits from the Permissions Selection Page 4 Change the limits and click Submit Eastern TreasuryConnect mE ACH User s Overall Limits Page EAS0430 EASTERN NEW DEMO CUSTOMER Requested 2 8 10 at 12 20 00 PM EST Batch Activation Limit Batch Limit Batch Limits for All Companies and Transaction Types
51. rriage return line feed at the end of each line if included in the file 6 Optional If you want the system to ignore the first header record for import files that use this map click Skip First Header Record Select this option if the import file contains header information in the first record 7 Optional If you want the system to change the amount for all batch entries to zero when you import a file that uses this map click Load Zero to Amount Fields Select this option if you want the system to add the batch entry amounts as zero The system does not change amounts to zero for batch entries the import file does not update 8 Optional If you want the system to delete batch entries that are not updated when you import a file that uses this map click Delete Unmatched Batch Template Records 20 2Eastern Bank 10 Eastern TreasuryConnect Optional If you want the system to allow imported files using this map to contain some but not all required fields to update a participant click Allow Partial File Import When you select this option additional validations apply You may define only those fields contained in the file being imported Transaction Code ABA Number Account Number Amount ID Number Name Disc Payment Type Addenda Data Click Add Map Changing a Map Definition 1 Select the ACH Admin group and click the ACH Map Definition tab 2 Onthe Import Maps page click Ein the Edit column on the same line as t
52. s No deleted batches are included with this option e specific batch enter the batch code in the Filter By Batch Code field and click Search e specific batch name enter the batch name in the Filter By Batch Name field and click Search The Available Batches section displays batches for the criteria you selected Select one of the following options To select e All Available Batches click Select All e Individual batches click the check box for the batches you want to include on the report Generating and Exporting an ACH Report On the ACH Report page in the Report Criteria section from the Type of Date list select the type of date on which you want to report You can use the calendar next to the fields to include transaction entries on the report for a e Range of dates enter the beginning date in the From Date field the ending date in the To Date field e Specific date enter that date in both the From Date field and the To Date field Optional To report on transaction entries for a range of customer trace numbers enter the beginning customer trace number in the Customer Trace Number From field and the ending customer trace number in the Customer Trace Number To field Optional To report on transaction entries for a range of bank trace numbers enter the beginning bank trace number in the Bank Trace Number From field and the ending bank trace number in the Bank Trace Number To field In the Report Characteristi
53. section and click the Add a Recurring Payment button X Establish a Recurring Payment Initiation Criteria Start Date 10 Activation Time 10 20 x EDT Recurrence Pattern Daily Payment will occur on all business days atthe specified Activation Time Weekly Monthly Yearly 4 Inthe Establish a Recurring Payment section e Inthe Start Date field enter the date you want the system to use as the first effective entry date for the recurring payment e Inthe Activation Time field select from the list the time you want the system to activate the recurring payment e Under Recurrence Pattern select the frequency with which you want the system to process the recurring payment A description of the frequency you choose displays in the right hand frame e Conditional If you select a frequency for a recurring payment other than Daily the system displays the Back Dated or Future Dated field to indicated whether payments can be back dated or future dated if a batch effective entry date is a holiday or other non business day 5 Click the Add Batch button 6 To add entries to the recurring payment batch click the Entries icon from the Batch Selection page see Section F 7 To edit recurring payment click the Edit icon from the Batch Selection page and click the Add a Recurring Payment button 16 Eastern Bank Eastern TreasuryConnect IV Participants Service The Participant Maintenance Service al
54. t button A confirmation page displays The confirmation page serves as a reference for the Corporate User and can be printed by selecting the Browser s Print button 43
55. tch Totals Debits 0 00 zero Dollar State 0 Credits 7 300 00 Frozen 5 Prenotes 0 zero Amount Active 0 Highlighted Entries have not been activated in the last 120 days Save Changes Return to Entry Maintenance Page 14 Eastern Bank Eastern TreasuryConnect 4 On the Edit Entries page make changes to batch entries displayed and click Save Changes You will see the following message Microsoft Internet Explorer X changes this page are temporarily being saved you must click the update batch button the entry maintenance page to save your changes permanently cancel Click OK to return to the Entry Maintenance page To permanently save the changes you made to the batch template you must click the Update Batch Button To filter entries in a batch 1 Select the ACH Admin group and click the Batches tab 2 Batch Selection page select an Available Company and click the Entries icon on the same line as the batch to which you want to filter entries Search Transaction Entries Filter From To Display Preferences uo Filter Le 1 1 Mame bc 25 Entries per page gt Display Entries Save Search Settings 3 Onthe Entries Maintenance Page in the Search Transaction section select one of the following options Transaction entries filtered select it from the Filter By list box and click Display Entries Transaction entries
56. tem displays the Batch Detail page 2 Review transaction entries for the selected batch clicking Previous and Next to move among pages and display them D Canceling an Approved Batch If you have permission to the Approval service or if the approval status for the associated ACH Company is set to None on the ACH Summary Report page click X in the Delete column for the batch you want to delete from an ACH report The system changes the status of a batch to Deleted You can delete batches with an activated status but you cannot delete batches with a File Created status Click OK when the system displays a deletion confirmation message 39 Eastern Bank Eastern TreasuryConnect Xl ACH Exception Reporting Service Use the ACH Exception Report Service to request and display summary and detailed information for ACH batches with recurring payments and errors found during processing ACH Exception Report Selection Available Recurring Batches Available Companies Select All Company 1D Batch Name Eastern Bank Dem 1043067724 122007 rig test recurring Filter by Batch Code Filter by Batch Name Report Criteria Characteristics Type of Date Activation Effective Entry Date From To Group By Date oyis 2008 Eg wiizoos Company Exception Reasons vi Invalid Permissions Limits Error Possible Duplicates Error Invalid State Error System Error Other Errors A Selecting Batc
57. the ACH Admin group and click the Batches tab 2 Onthe Batch Selection page select the company for which you want to add a batch from the Available Companies list and click the Copy icon 20 Copy Batch Copy Batch to Compan mmary 1043067724 Eastern Bank Dem Transaction Su Batch Code 12 7 Total Debits 10 0 00 Batch Name 25 Weekly Payroll Total Credits 73 53 00 Total Prenotes 0 Transaction Type PPDCO ET Total Zero Dollar State 0 Entry Description 10 Total Frozen 0 00 Offset Account 600 Eastern Bank Demo USD Total Zero Amount Active 0 Discretionary Data 20 11 Create Prenote Disable Batch On Copy Batch page enter a new Batch Code verify the information and click Add Batch to display the Batch Selection page with the copied batch C Changing a Batch To change a batch 1 Select the ACH Admin group and click the Batches tab 2 Batch Selection page select an Available Company and click the Edit icon E Edit Batch Edit Batch in Company 1043067724 Eastern Bank Dem Transaction Summary Batch Code Payroll 1 Total Debits 1 Batch Name 25 Total Credits 7 3 00 Transaction Type PPDCO TOBE Pre fois a 0 Entry Description 10 Total Zero Dollar State 0 Total Frozen 0J 0 00 Total Zero Amount Active 0 Offset Account 600 Eastern Bank Demo USD Discretionary Data Q0 sd Create Prenote
58. tion in the first record Optional If you want the system to remove quotation marks from fields in import files that use this map click Strip Quotes around fields Select this option if the fields in import files are surrounded by quotation marks Optional If you want the system to change the amount for all batch entries to zero when you import a file that uses this map click Load Zero to Amount Fields Select this option if you want the system to add the batch entry amounts as zero 0 The system does not change amounts to zero for batch entries that the import file does not update Optional If you want the system to delete batch entries that are not updated when you import a file that uses this map click Delete Unmatched Batch Template Records Optional If you want the system to allow imported files using this map to contain only some required fields to update a participant click Allow Partial File Import When set to No you must define all required fields When set to Yes different validations apply You may define only those fields contained in the file being imported You must enter either the field position or replacement value for the following fields unless you selected Partial File Import Then enter a value for each corresponding field in the columns see Header Definitions for details e Transaction Code e ABA Number e Account Number e Amount e ID Number e Name e Disc Payment Type e Addenda Data Click Add M
59. tivation Only button or the Update Batch button the Entry Maintenance page to complete the changes Cancel Click OK to return to the Entry Maintenance page You must choose either Save Changes to This Activation Only or Update Batch button to complete the changes VI ACH Batch Approval Service The Approval Service is a security feature that allows Corporate Users to approve an activated ACH batch that requires approval before it is sent to the bank A Approving a Batch Note To access the ACH Batch Approval tab you must enter a valid SecurelD E Challenge Microsoft Internet Explore securlD Login Please enter SecurlD Passcode Passcode Clear Once a valid SecurlD has been accepted you will see the Batch Approval Selection screen 22 Q Eastern Bank Eastern TreasuryConnect Batch amp pproval Selection Activated Batches Number of ACH Batches approvak T approve batches select the desired batch es and click Approve Selected To send a batch back for maintenance select the desired batch es and cick Reject Selected Highlighted Batch es have an invalid Effective Entry Date and must be corrected to approve Available Batches Select All Batches Company 1043067724 Eastern Bank Dem Select 1043067724 Batches Effective Entry Date Total Debits ON Details P Weekly Payroll Activated 03 19 2008 1 57 21 PM Total Credits E 1 00 Delete EX
60. ubmit ACH Batch Limits ACH Company Transaction Type Maintenance Txn MaintenancelBatch Activation Txn Activation Batch Approval Txn Approval Bati CCD w Addenda astern Demo Mixed Credits and 99 999 999 99 Debits CCD Mixed Credits and Debits PPD w iAddenda astern Demo Mixed Credits and 99 999 999 99 99 999 999 99 Debits PPD Mixed Credits and Debits astern Demo 93 993 909 99 astern Demo 993 999 999 99 99 398 939 00 Corporate Administrators will use the ACH Admin Permissions service to set up additional requirements and approvals if applicable Eastern Bank Eastern TreasuryConnect B ACH Admin Permissions The ACH Admin service allows Corporate Administrator to set other Permissions within ACH i To set batch template approval requirements optional The Batch Template service allows Corporate Administrator to require batch add change and delete requests to be approved before they can be used with other ACH services Batch Template permissions are set for each user under the Permissions tab 1 Select the ACH Admin group and click the Permissions tab 2 Onthe Permissions Selection page select the user for which you want to set limits from the Users list 3 Select the company from the Assigned Companies list and click Transaction Types 4 Select an Assigned Transaction Type and click Template Approval Options 238156 Users Karen Karen Carbone A Customer ACH Settings Karen 1043067724 Template App
Download Pdf Manuals
Related Search