Eastern Bank TreasuryConnect Electronic Report Delivery (ERD
Contents
1. Passau 9 NOTIFICATION OF CHANGE 11 Ve ERD HS NO NL ROC 13 Eastern Bank Electronic Report Delivery ERD Module The ERD service allows the corporate administrators and corporate users to view reports and data the Bank makes available The corporate administrator can grant rights to users to view reports required to complete their daily task and reduce the need for paper delivery Eastern Bank offers various report and data information that can be retrieved through the ERD module The available reports are listed below ACH ACH Returns and Notification of change NOC Report ACR ACH Return and NOC file ADV Advanced Check Clearing Report ARO Account Reconciliation Outstanding Issue data ARP Account Reconciliation Paid data ARS Account Reconciliation Statement report EDI Corporate Payment Report EDN EDI Non Conforming Report RPO Repurchase Account Notice O Qo cx mw Eastern Bank ERD USER SERVICE PERMISSIONS This service allows the Corporate Administrator to permit the specific ERD reports to other users within the company A Adding ERD Report Permissions To grant user ERD permissions select the User Administration in the drop down list 1 Click on User Admin 2 Select a user from the2. Bank Eastern Bank TreasuryConnect Electronic Report Delivery ERD User s Manual This user s manual provides instructions for accessing services found within the ERD Group Those services are ERD Permissions only available to the Corporate Administrators ERD Reports August 2014 Eastern Bank Table of Contents ELECTRONIC REPORT DELIVERY ERD MODULE eeseeseseessessesseseosoesesesssesoesseseosoeseseossesoessesessosseseossesossessossesoesoesoesoesessossessesssss 3 ERD USER SERVICE PERMISSIONS ccscssscssscssscecscscesecssccsscesscssscssscssscssssssecenscssscsseesecescssessscssocsscesscssscsssesscssesssscssecsnessseeseceee 4 A ADDING ERD REPORT PERMISSIONS E 4 ERD DIO COP 5 Az VIEWING ERD REPORTS c EE 5 ACCOUNT RECONCILMENT ERD DATA FORMATS ccsccsssssssscssscccsccssccnscsscsneessccsscsscssssscssscsssssssssscssssssscssecssessseesseeseeees 6 A ACCOUNT RECONCILEMENT PAID DATA nene teen tren teen ne etr enne tenete nete nennen trente entente entren nee 6 B ACCOUNT RECONCILEMENT OUTSTANDING DATA FORMAT 7 IV ACH NACHA FORMATTED RETURN AND NOC seta seta seta se 9 A UCCHNACHA RETUBNTIEMEORMAT
3. Eastern Bank Il ERD REPORT S The ERD reports are created when there is a defined activity posted to the account that will generate the report As an option you may want to consider setting up an Alert to notify you when a report is generated This will eliminate logging into ERD daily and ensure you do not miss an important activity such as a returned ACH item A Viewing ERD Reports To view and ERD report go to ERD Reports tab 1 Click the down arrow to select a Report from the ERD Inbox 2 Select all reports or a single report 3 Select the from and to dates for the report Note Report information is accumulated for up to 90 days 4 Click the filter button Eastern TreasuryConnect ERD ERD Permissions Reports ERD Inbox 238156 adtest All Reports Load Date 06708 2004 06 15 2004 Filter All Reports ACH ACH Return and NOC Report ARO Account Reconcilement Outstanding File ARP Account Reconcilement Paid File ARS Account Reconcilement Statement File EDI EDI Corporate Payments Report The list of available reports will display by report code then load date in descending order 6 Select the file on the right hand of the screen and double click on the report Once in the report it can be saved locally or printed 7 To exit the report click on the Close button in the upper right hand corner ERD Gx SES ERD Inbox 238156 adtest All Reports Load Date 06 01 2004
4. 06715 2004 Filter Report Account 2004167000003 06 1 5 2004 06 1 4 2004 ACH ACH Return and 111111111111 01 04 05 AM 11 59 52 PM Report 2004163000002 06 11 2004 06 10 2004 ACH ACH Return and NOC 1111111111 01 04 05 AM 11 59 08 PM Report 2004162000003 06 10 2004 06 09 2004 ACH Return and 12 34 05 11 27 20 Report 2004161000003 06 09 2004 06 08 2004 ACH ACH Return and NOC 1111111111 12 34 05 AM 11 25 48 PM Report 2004160000003 06 08 2004 06 07 2004 ACH ACH Return and 1111111111 12 44 03 AM 11 36 32 PM Report 2004163000003 06 11 2004 06 1 0 2004 ACH Return and 1111111111 01 04 05 AM 11 59 08 PM Report 2004162000019 06 10 2004 05 10 2004 ARO Account Reconcilement 99999999 01 44 13 AM 12 37 23 AM Outstanding File Bank ACCOUNT RECONCILMENT ERD DATA FORMATS A Account Reconcilement Paid Data Format Outlined below is the output format for the ERD Paid data file General Information Record size 80 Block size 800 EBCDIC Record Format FB Numeric fields are right justified and zero filled Detail Record Layout FIELD POSITIONS LENGTH CHARACTERISTICS DESCRIPTION 001 001 010 10 Numeric Pic 9 10 Account Number 002 011 020 10 Numeric Pic 9 8 V99 Check Amount 003 021 030 10 Numeric Pic 9 10 Check Serial Number 004 031 036 6 Numeric Pic 9 6
5. DATA ELEMENT NAME Field Inclusion Requirement Contents Length Position 1 3 RECEIVING DFI RECORD IDENTIFICATION TYPE TRANSACTION CODE CODE IDENTIFICATION M M ii 02 03 TTTTAAAA 01 01 04 11 CHECK DIGIT Numeric 12 12 DFI ACCOUNT NUMBER Alphameric 17 13 29 Addenda Record Format for Notification of Chan FIELD DATA ELEMENT NAME Field Inclusion Requirement Contents Length Position RECORD ADDENDA TYPE TYPE CODE CODE CHANGE ORIGINAL ENTRY TRACE NUMBER 6 7 8 INDIVIDUAL IDENTIFICATION INDIVIDUAL NAME NUMBER RECEIVING COMPANY IDENTIFICATION AMOUNT NUMBER NAME M R 0000000000 Alphameric Alphameric 10 15 22 30 39 40 54 55 76 5 6 7 ORIGINAL RECEIVING CORRECTED RESERVED DFIIDENTIFICATION DATA N A R M Blank TTTTAAAA Alphameric 6 8 29 22 27 28 35 36 64 12 DISCRETIONARY DATA Alphameric 77 78 RESERVED 10 11 ADDENDA RECORD TRACE INDICATOR NUMBER Numeric 15 79 79 80 94 TRACE NUMBER Numeric 15 80 94 Eastern Bank V ERD REPORT SAMPLES 1 The ACH ACH Returns and Notification of change NOC report is a human readable report that is created when an entry has been returned or corrected by the receiving bank or the Federal Reserve Bank ACDDAENT 01 RET RETURN ITEMS REPORT 09 20 10 23 46 PAGE 1 FINANCIAL INSTI
6. Date Paid MMDDYY 005 037 056 20 Alpha Numeric Pic X 20 Customer Information Trailer Record FIELD POSITIONS LENGTH CHARACTERISTICS DESCRIPTION 001 001 010 10 9 10 Account Number 002 011 020 10 Numeric Pic 9 8 V99 Total Amount 003 021 026 6 Numeric Pic 9 6 Total Item Count 004 027 032 6 Numeric Pic 9 6 Processing Date MMDDYY 005 033 042 10 Numeric Pic 9 10 Filler Nines 9 006 043 056 14 Alpha Numeric Pic X 14 Filler Blanks Spaces Note Processing Date on the trailer record contains the cycle end date of the period not the date the data is created Bank B Account Reconcilement Outstanding Data Format General Information Record size 80 Block size 8000 EBCDIC Record Format FB No label Numeric fields are right justified and zero filled Detail Record FIELD POSITIONS LENGTH CHARACTERISTICS DESCRIPTION 001 001 003 3 Numeric Pic 9 3 Bank Number 002 004 013 10 Numeric Pic 9 10 Account Number 003 014 023 10 Numeric Pic 9 10 Check Number 004 024 031 8 Numeric Pic 9 8 Check Issue Date CCYYMMDD 005 032 044 13 Numeric Pic 9 13 lesus Amount 006 045 074 30 Alpha Numeric Pic X 30 sarintormati n 007 075 079 5 Numeric Pic X 5 Filler Spaces 008 080 080 1 Alpha Numeric Pic X 1 Stop Indicator S if active stop pay Bank Trailer Rec
7. COMPANY ENTRY COMPANY EFFECTIVE SETTLEMENTIORIGINATOR ORIGINATING ELEMENT COMPANY CLASS COMPANY DISCRETIONARY COMPANY CLASS ENTRY DESCRIPTIVE ENTRY DATE STATUS DFI BATCH NAME CODE NAME DATA IDENTIFICATION CODE DESCRIPTION DATE DATE JULIAN CODE DENTIFICATIONNUMBER Field Inclusion Inserted by Requirement M M M M R ACH Operator M M M Contents Numeric Alphanumeric Alphanumeric Alphanumeric Alphanumeric Alphanumeric Alphanumeric YYMMDD Numeric TTTTAAAA Numeric Length 16 20 10 3 10 6 6 3 1 8 7 Position 05 20 21 40 41 50 51 53 54 63 64 69 70 75 76 78 79 79 80 87 88 94 Bank Corporate Entry Detail Record Format for Returns FIELD 4 5 DATA RECORD DFI ELEMENT TYPE CHECK ACCOUNT NAME IDENTIFICATION DIGIT NUMBER Field Inclusion Requirement M R Contents TTTTAAAA Numeric Alphanumeric Length 1 17 Position 12 12 13 29 Addenda Record Format for Returns FIELD 2 3 DATA ELEMENT ADDENDA RETURN REASON ENTRY NAME CODE CODE Field Inclusion Requirement M M Contents 99 Alphanumeric Length 2 3 Position 02 03 04 06 99 99 99990 TRACE NUMBER 07 21 Alphanumeric DATE OF DEATH YYMMDD 10 Numeric TTTTAAAA 28 35 RECEIVING COMPANY NAME ID NUMBER RESERVED Alphanumeric 16 59 74 ORIGINAL RECEIVING DFI IDENTIFICATION ADDENDA INFORMATION Alph
8. EDIT RECEIVER RDFI R T NUMBER 011301798 RDFI ACCOUNT NUMBER 124356789 ORIGINATOR ODFI RYT NUMBER osioooo1l1 COMPANY ID 123456789 COMPANY BANKING COMPANY ENTRY DESC VENDOR PAY 9 The RPO Repo Account Notice provides the customer with a notification of an investment made overnight where the funds are invested the amount and the rate applied DEMO Customer OF MASSACHUSETTS INC 123 OLD COLONY AVE SOMEPLACE MA EASTERN BANK MASTER REPURCHASE CONFIRMATION NOTICE Eastern Bank sold the following Securities as of 3 21 2010 DESCRIPTION FNMA FN256802 7 1 2027 0 055 ACCOUNTS 05123456789 CUSIP 31371NGK5 BALANCE 344688 12 PAR VALUE 26 219 176 00 CURRENT RATE 0 1 MAPKET VALUE 50 000 000 00 15
9. TUTION EASTERN BANK NUMBER 272 ACCOUNT NUMBER RET TRACE N0 TYPE AMOUNTS CUSTOMER ID CUSTOMER ABA COMPANY NAME ENTRY SETTLEMENT DATE DISC D T DESCR DATE NUMBER ID DESCR 0045222221 0110001212245748 26 DR 80 22 05122 122456597 MARY K SMITH 011201798 BOSTON DEMO ACCT BOSTON CHG 09 20 10 PPD 00 100915 12245657825 REASON R02 ORIG TRACE 0112017122452425 ORIG ETT DATE 09 17 10 ORIG RDTI T R 01100012 ADDENDA INFO aaa ta RETURN ITEMS REPORT 09 20 10 22 46 PAGE 2 FINANCIAL INSTITUTION EASTERN BANK BANK NUMBER 272 F REPORT TOTALS f DDA DD CREDITS CREDIT AMOUNT DEBITS DEBIT AMOUNT CREDITS CREDIT AMOUNT DEBITS DEBIT MOUNT qot dede X tttttt SESE ETE ESS ttttttt tttttt DEP TOTALS 0 5 00 1 80 32 0 5 00 0 5 00 G L TOTALS 0 00 0 00 LOAN TOTALS 0 00 0 00 2 The ACR ACH Return and NOC file is a file format that is created when an entry has been returned or corrected by the receiving bank or the Federal Reserve Bank See section IV on how to read it 6200 5 DEMO PREMIUM DEDUCTIONS 1123456735PPDBOSTON CHG1009151009123451011000130000037 6260113017981234567891 0000001233451234 123456597MARY K SMITH 001011000132345678 7998 030113017923459435 01100013 011000131234548 20000000200011301790000000080320000000000001123456735 011000130000037 3 ADV Advance Clearing Notice provides ad
10. anumeric 44 36 79 11 DISCRETIONARY DATA Alphanumeric 77 78 12 ADDENDA RECORD INDICATOR NUMBER 80 94 79 79 TRACE NUMBER Numeric 15 80 94 Bank B ACH NACHA notification of change format NOC Company Batch Header Record Format for Notification of Chan FIELD 1 2 3 4 5 6 STANDARD DATA COMPANY ENTRY ELEMENT COMPANY COMPANY DISCRETIONARY COMPANY CLASS ENTRY DATE STATUS NAME NAME DATA IDENTIFICATION CODE DESCRIPTION JULIAN CODE Field Inclusion Inserted by Requirement M M M ACH Operator Contents Numeric Alphameric Alphameric Alphameric Alphameric Alphameric Alphameric YYMMDD Numeric Alphameric TTTTAAAA Numeric Position 05 20 21 40 41 50 51 53 54 63 64 69 70 75 76 78 79 79 80 87 88 94 Corporate Entry Detail Record Format for Notification of Chan FIELD DATA ELEMENT NAME Field Inclusion Requirement Contents Length Position 3 4 5 6 7 RECORD DFI TYPE TRANSACTION RECEIVING DFI CHECK ACCOUNT TOTAL IDENTIFICATION CODE IDENTIFICATION DIGIT NUMBER AMOUNT NUMBER M M R M Numeric Alphameric 0000000000 Alphameric Blank 8 1 17 10 15 04 11 12 12 13 29 30 39 40 54 11 ADDENDA IDISCRETIONARY RECORD TRACE INDICATOR NUMBER Numeric Bank Entry Detail Record Format for Notification of Chan
11. ions contained within it An example is below 1 2 4 5 7 8 10 11 CONTENTS OF THIS STATEMENT STATEMENT OF ACTIVITY ACCOUNT BALANCE SUMMARY PAID ITEMS ERRORS CHECKS PAID W O REGISTERS RETURN ITEMS COMBINED PD OUTSTANDING REGISTER SUMMARY REG EXCEPTION SUMMARY REG PREV CYCLED CHECKS MAINTENANCE SUMMARY ACTIVE STOP PAY LISTING R 405 R 407 R 408 R 410 R 425 R 430 R 440 R 441 R 442 R 470 R 475 7 The EDI EDI Corporate Payments Report provides detailed information for the corporate payment ACH transaction type that is either a CCD or CTX 14 Eastern Bank EDI REMITTANCES PAYMENT ADVICE SEPTEMBER 21 2010 CITY SOMEPLACE ATTN JOHN ADAMS TREASURER S OFFICE CITY HALL SOMEPLACE MA PAYMENT INFORMATION CREDIT 614 314 00 EFFECTIVE 09 21 2010 INPUT FORMAT CREDIT PARTY DEBIT PARTY ROUTING ID 011301798 ROUTING ID 0110751 50 PEMAND ACCT 12345 DEMAND ACCT 888812345 COMPANY ID 123456789 CO SUPPL CODE 011075150 8 The EDN EDI Non Conforming Report provides the customer with information on a payment that is coded as a CTX payment but is not formatted correctly REMITTANCE DELIVERY SERVICES INVALID EDI REPORT os 17 2010 DEMO SYSTEMS 123 BOSTON POST ROAD SOMEPLACE MA 01778 JOHN ADAMS PAYMENT INFORMATION PAYMENT AMOUNT 305 63 CR
12. list and click on the Services link 3 Under the section User Service Permission click Electronic Report Delivery select all the ERD services or choose which ERD services the user should be assigned and click submit User Code 12 test1234 SELECT ALL User Password 12 Same Day Report Retype User Password 12 Electronic Reporting Delivery User Name 40 tony testor ERD Report Address 1 of 2 40 195 MARKET STREET ERD Report Permissions 4 Next choose Electronic Report Delivery in the drop down list 5 Highlight the report the user should has access to use the to move it over Internet Cash Management Windows Internet Explorer v https sfeasterntest diginsite com bbwicmserverjinterface default frames cfm X Search Ele Edit View Favorites Tools Help We Be Pinternet Cash Management eEastern Bank fir mb tease HELP BULLETINS CONTACT LOGOUT EAS0430 Users ADMINS MELISSA NATHAN asheeh1 Aileen Sheehan ejacob Eileen Jacobson hdhdhddh good morning Paul Report Permissions Inactive ERD Reports Active ERD Reports E ACH Return and NOC Report No ERD Active ACR ACH NACHA Return and NOC File ADV Advanced Clearing Notice ARE Account Reconcilement Staledat ARO Account Reconcilement Outstand ARP Account Reconcilement Paid Fil I
13. ord FIELD POSITIONS LENGTH CHARACTERISTICS DESCRIPTION 001 001 003 3 Numeric Pic 9 3 Bank Number 002 004 013 10 Numeric Pic 9 10 Acasunt Number 003 014 020 7 Numeric Pic 9 7 Total Outstanding 004 021 033 13 Numeric Pic 9 13 Total Outstanding 005 034 040 7 Numeric Pic 9 7 Total Stopped Outstanding 006 041 053 13 Alpha Numeric Pic 9 13 Total Stopped Amt 007 054 079 26 Numeric Pic X 26 Filler Spaces 008 080 080 1 Alpha Numeric Pic X 1 Trailer Record Value 9 Notes 1 This format contains all outstanding registers with issue dates prior to and including the next output date It will not include void items 2 User Information will be included on the detail records if provided by the customer in the original issue file If no user information was provided this field will be filled with spaces 3 A 9 in column 80 of the record will identify the record as the trailer totals record This will be the last record in the file for a given account Bank IV ACH NACHA FORMATTED RETURN AND NOC FORMAT A ACH NACHA return item format ACH return items are sent from the Federal Reserve in a NACHA format This information will be presented through the ERD reporting feature The NACHA format is outlined below Company Batch Header Record Format for Returns FIELD 3 4 5 6 7 8 9 10 11 12 13 STANDARD DATA SERVICE
14. vance clear customers with a notification of the total dollar amount of checks that will be clearing the account the same day ADVANCED CLEARING REPORT DATE 3 22 2010 CUSTOMER Demo Mass College 123 ACCT NAME Demo Mass College ACCT 123345678 FED PRESENTMENT 26 742 99 OTHER INCLEARING 0 00 OTHER ADJUSTMENTS 0 00 OTHER CHECKS PRESENTED 1 935 35 NET FUNDING AMOUNT 28 678 24 13 Eastern Bank 4 The ARO Account Reconcilement Outstanding File is a fixed format file which provides the reconcilement customer with a list of checks that have been issued but not paid yet Refer to section IV for the format layout 37300001234560000016070201009140000000120000 37300001234560000503171200611060000000002500 37300001234560000503192200611290000000002500 37300001234560000687322201002100000000041000 37300001234560000739677200608250000000900000 37300001234560000744393200703190000000103253 5 The ARP Account Reconcilement Paid Check report provides the reconcilement customer with a list of paid checks Refer to section IV for the format layout 00012345600000397200000895536091310 00012345600002000000000895539091310 00012345600103461540000895541090910 00012345600002500000000895542091010 00012345600050813490000895543091310 00012345600020389810000895544091310 6 ARS Account Reconcilement Statement is the reconciliation statement for specified period of time This report has various sect
Download Pdf Manuals
Related Search