Eastern Bank TreasuryConnect Balance Reporting User Manual
Contents
1. 16 oh D fp dir 17 T M 17 Previous Day Report 17 Same Day Real Time 19 He 19 IREPORT on 20 OEastern Bank l User Admin The User Admin function allows the corporate admin to setup new Users or edit existing users Services Permissions and Limits To add a new user Assigning User Balance Report BR services 1 Click on User Administration in the drop down list 2 Click on User Admin and click the Services link 3 Click on BR functions the user is entitled to 4 Click the Submit button User Information User Service Permissions User Code 12 test123 SELECT ALL User Password 12 BR Administration Retype User Password 12 BR Transaction Groups User 40 tony testor Transaction Group Accounts Address 1 of2 40 195 MARKET STREET BRFavorite Reports Address 2 of 2 40 BR Favorite Reports City 25 BR Previous Day ee mm MultiDay Activity Report Postal Code 20 01901 Previous Day Quick Reports Telephone 25 781 596 4495 isses Fax Number 25 781 596 4461 O Taman cena E Mail 40 demomea2. BR Transaction Groups LBdep Lockbox Deposits 04 Wires ALLTRAM All Transactions DEP Deposits LBX Lackbox Deposits PDCKS Paid Checks Permit Accounts Display Accounts li Creating a new Transaction Group To create a transaction groups go to the Transaction Group tab 1 Inthe Code field enter the alohanumeric code identifier of the new Transaction Group you want to add 2 Inthe Name field enter the alohanumeric name of the new Transaction Group 5 am lore Balance Rpt Admin Accounts EASGOA30 Transaction Groups ER Eimaretresn Mo Transaction Groups matched your selection Eastern Bank 3 Click Add The Transaction Groups Data Entry page displays with an empty Active BAI Codes list Choose the code or codes you wish to setup for instance to set up a group for all incoming ACH items select 165 or to view all return deposited items select 555 Highlight the code then click the gt arrow key to move it over BrGroup Code 12 test Briroup Name 40 tesi test BrGroup Inactive Codes cm Active BAI Codes 162 Corporate Trade Payment Settlement No Type Codes Available 163 Corporate Trade Payment Credits 164 Corporate Trade Payment Credit 165 Preauthorized ACH Credit 166 ACH Settlement 167 ACH Settlement Credits 168 ACH Return Or Adjustment 169 Miscellaneous ACH Credit 170 Total Other Check Deposits 171 Loa
3. Day Real Time Report The Same Day Real Time Report service provides an accurate summary of account information for the current business day This a real time report so you can only view today s information You also can use this service to export the information to an external file for use in other applications To generate a same day real time report select Balance Report in the drop down list and go to the Same Day Real Time tab 1 Select Account s all accounts one account or multiple accounts Select Balance Type Options are All Balances amp Transactions Status Balances Detail Credit Transactions Detail Debit Transactions oelect Submit to view this report If you wish to export the report in a CSB format click on Export button Online Same Day Balance Report Account Selection Awallable Accounts eC Search Al Balances amp Transactions Status Balances Detail Credit Tranzactionz 11 Eastern Bank C Account Activity The Account Activity report will provide a single view of your accounts with multiple date ranges to search history or view current day activity It provides up to date account balances and transactions The default date range on the Account Activity report is Last 7 days but there are other options available The different options available in the Date Range drop down list are Last 7 Days Today Previous Day Month to Date and Custom You also can create a favorite within Account
4. Eastern Bank Eastern Bank TreasuryConnect balance Reporting User Manual This user manual provides instructions for setting up or editing a user and accessing services within the three Balance related groups Within the Balance Report Admin The service is gt Transaction Group gt Tran Group Accounts Within the BR Quick Reports Group The services are gt Previous Day Report Within Balance Report Group The services are Previous Day Same Day Real Time Account Activity Multi Day Favorite Reports Transaction Download Vv VV V V WV April 2013 Eastern Bank Table of Contents I USER ADMIN GG 513553 53222 32500 00 2 2 9 99 m1 00 0 0 0 3 Assigning User Balance Report BR 3 A OO AC COMES LO S 3 I BRADMINISTRATION udine 4 LRAT ACTIO iu Modi E URINE DU SEU 4 Using a Bank Defined Transaction 4 ii Creating a new Transaction 4 ERAN GROUT OUN T 5 Adding accounts to BR Transaction b Displaying Tran Group eese essnn trn nnne ees se ni enhn 6 BROU E REPOR 7 PREVIOUS DAY QUICK 7 Ge
5. Move Transaction Groups Up or Down ACHdebit Preauthorized Debit Pla ctor ost Uline a Move highlighted aroun un 2 Enter the preferences for the report type report style sort order 1 sort order 2 and totals 3 Click Submit The system saves your Previous Day report Account sort settings and generates displays a copy of the report 4 Choose the account sort order next To move individual Accounts within the list hierarchy in the Account Number Display Order list box highlight the Accounts you want to reposition and click the appropriate Up Down arrow to move them 5 Follow a similar procedure to select the sort order of the Transactions groups Click Submit and save your changes 2Eastern Bank iii Exporting Report s To export a previous day report go to the Previous Day tab 1 Select the File Output Format Options follow Comma Separated Value CSV BAI output CS Basic CSB PDF 2 Select the Export button 3 Follow instructions on the File Download Window File Download Do you want to open or save this file 1 Mame pdesvexport csy Microsoft Office Excel Comma Separated Values File From 63 172 237 118 con ees While files fram the Internet can be useful some Files can potentially harm your computer not trust the source do not open or save this What s the risk 10 2Eastern Bank B Same Day Real Time i Generating a Same
6. Or More Days Float summary Totals Anon Total Credits Total Lockbox Deposits Total Debits Date Detail Credit Transactions Amount 01725 2010 Incoming Wire Transfer 0 25 Bank Name Eastern Bank Accoumt 7 12245678 Account Name Eastern Bank Demo USD Date 01 25 2010 Amount 1 DayFloat 0 00 2 Days Float 50 00 3 More Days Float 50 00 Date 01 25 2010 summary Totals Amount Total Credits 1 0 25 Total Lockbox Deposits Si 50 00 Total Debits fti 0 00 I Date Detail Credit Transactions Amount Availability Bank Ref Cust Ref Image Text 01 25 2010 Incoming Wire Transfer 0 25 Credit Count 1 50 25 18 Eastern Bank li Same Day Real Time Report Bank Eastern Bank Account 555555 Account Name EASTERN BANK DEMO 1 Date 12 08 2011 Account Summary Balance Amount 50 00 50 00 50 00 25 76 150 17 14 76 472 17 50 176 00 532 183 834 81 Transactions TRANSFER 038001208130329 REF 3421303L FUNDS TRANSFER FRM DEP 666666 FROM BUSONLINEBKNG DEC 08 2011 14 03 1 00 lii Account Activity Search Criteria j Favorites ExportAs Print This Page Date Range Categories Accounts Types Other Search Critera All Categories All Accounts From To Deposits 5055555 Eastern Loans Eastern Demo 2 Amount Investments Check Other 09 27 2012 10 03 2042 Submit Reset Save a
7. Reports adjustments Report Eileen Jacobson 3 Adding a Favorite Report From the Favorite Reports page click Add Report The system displays the Define a Favorite Report page Enter format and parameter characteristics for the new Favorite Report minimally you must enter a name in the Report Name field and select one or more account numbers to associate with this report Click Save to add your new Favorite Report to the system or click Cancel to return to the Favorite Reports page without saving the report To run or export an existing Favorite Report From the Favorite Reports page click in the Run column to the right of the Favorite you want to run The system generates and displays the HTML output of the report or creates an export file in the format defined depending on the output definition of the Favorite Report If you are running the Export file of the report a download dialog box prompts you to either open the file or save it to your computer click Save to navigate to the folder in which you want to save the export file Click Close or click the Favorite Reports service tab to return to the Favorite Reports page To edit characteristics of an existing Favorite Report From the Favorite Reports page click Ez in the Edit column to the right of the Favorite you want to update The system displays the Define a Favorite Report page in Edit mode showing previously defined field
8. This total along with the Closing Available total will be reflected in the Opening Available field 2 Days Float These funds will be immediately available the day after tomorrow or later Float that is greater than 2 days will remain in this bucket Same Day Real time report Current Balance amp Ledger Balance This is the closing balance as of last night Account Available Balance This balance is a real time balance and will include today s transactions One Two and Two Float The float is not reported so they will always be zero Cycle to Date Debit Amount amp Count This is a cumulative total number of debits and dollar amount since the last statement Cycle to Date Credits amp Count This is a cumulative total number of credits and dollar amount since the last statement Last Statement Account Balance The ending balance when the statement was cut Accessible Available Balance This balance includes any related account balances such as sweeps or loans that can be drawn on for book and money transfers 20
9. Activity or export the report in a csv format with or without headers Balance Report ccount Activity Search Criteria Date Range Categories All Categories Last 7 Days 1040 2012 1046 2012 submit Reset Save ss Favorie Accounts 5555565 Eastern Demo Eastern Demo 2 Date Ranges available Same 8 Aceaunt Altinay zzii Real Ti me Multi Day pownload y Favorites E amp Export As Print This Pa Other Search Critera From amom Check Last 7 Days Provides information for the last 7 calendar days Today Provides same day information Previous Day Provides the previous day information Month to Date Provides a view of the month to date activity Custom Provides an option to view prior activity to 365 days If you want to view extended account history up to 365 days you need to search in 90 day increments li Create a Favorite within Account Activity You can create Favorites within Account Activity to save commonly used account searches for all date ranges except Custom You can choose what the accounts you would like in the report or just include debits or credits Click the Save as Favorite button Search Criteria Date Range Categories All Categories Deposits Loans 10 03 2012 investments 0 10 03 2012 Other Accounts j Favorites 6 Export As B Print This Page Other Search Crit
10. Reports Run a Favorite Report Add new Favorite Report T Mote Your selection wil automatically generate the repart HOCGHHESEREHON Available Accounts From date 10 5 2012 Humber b Name EE Search To date 10 75 2012 From amount Sort Number C Preferences eceimalipt All Eastern LISp Eastern Bank ramis Cs x 1 Eastern Bank Demo 2 LISpPrj Eastern Bank Report Characteristics Style Register notes Sorted By cust ret Sort 2 By amount Totals Shows totals Balance Types All Balances amp Transactions al ud Ein Eastern Bank ii Setting Report Preferences This service allows you to set your report characteristic defaults These values stay the same until you decide to change them using this capability To change Report Preferences go to the Previous Day tab 1 Select the Preferences button Setup preferences Report Style Register notes Sort Order 1 By cust ref T Order 2 By amount Totals Show totals Account Display Order Accounts Account Ordering Number Desc Name Asc Name Desc Move Accounts Up or Down 4603 Eastern Bank Demn USD Eastern Bank 4 Move highlighted account up 4691 Eastern Bank Demo 2 USD Eastern Bank EJ Mowe highlighted account down Transaction Group Display Order Transaction Groups Transaction Group Ordering ACHcredit Preauthorized ACH credit
11. ay quick report go to the Prev Day Report tab 1 Select the File Output Format Options follow Comma Separated Value CSV BAI output CS Basic CSB 2 Select the Export button Follow instructions on the File Download Window 2Eastern Bank IV Balance Report A Previous Day i Generating a Previous Day Report This service provides balance and transaction information for accounts from one or more previous business days and allows you to export the report information to other applications This information is available for 365 days To generate a previous day report select Balance Report in the drop down list and go to the Previous Day tab 1 Select Account s all accounts one account or multiple accounts 2 Select Balance Type Options are All Balances amp Transactions Status Balances Summary Totals Detail Credit Transactions Detail Debit Transactions 3 Select Transaction Group s Options are No Transaction Groups ACH Credits ACH Debits Deposits Lockbox Deposits Paid Checks Return Deposited Items Wires In and Wires Out 4 Select Query Options report dates transactions amounts or check number range Note leave blank for all amounts if you select a range of dates please note the system displays 90 days of information at one time 5 Select Submit to view this report avorite Prewious Same Day CE po Previous Day Balance Report Download ta Quicken Quickbooks Favorite
12. counts Permitted to DEP EASTERNBAWNE Trans Group 5555555 Eastern Bank 66666666 _ Eastern Bank Demo 2 OEastern Bank Ill BR Quick Reports A Previous Day Quick Report i Generating a Previous Day Quick Report This service displays a snapshot of balance and transaction information for accounts and allows you to export the report information to other applications To generate a previous day quick report select Bal Quick Reports in the drop down list and go to Prev Day Report tab 1 The system displays a default table of all accounts for the previous business day 2 To generate a previous day quick report for a different date enter valid dates 3 Select the Submit button Highland Industries Previous Day Balance Report xe rer ater Sep 13 2000 at 0353 3 THN amp 00200000 Corina C8 VI V Bank of Hew Zealand Operations USD 13937 3801095 agn ax 5 361 81 52 724 hi 35 600 00 Reported 5196 680 00 k Dienur seme ns QUSE 12006750 recurre Trust dai 290 45 381 21 52 704 B1 36 600 00 Hol 199 680 00 gt Operations 3 20 06 recur Trust zx 39 124 24 106 953 00 3835461 Not 84 209 13 P rais Combined Total ogi 200 51 840 16 21247212 160 748 01 0 00 401 560 13 4 Use the detail arrow to review transaction details for the account ii Exporting Report s To export a previous d
13. equence by report owner name Click again to sort the list in descending alphabetical sequence by report owner name 15 2Eastern Bank D Transaction Download Use this page to download cleared transactions into Personal Financial Management PFM software such as Intuit Quicken or QuickBooks Files you download using this service are in Open Financial Exchange OFX format This page displays when you select the Balance Report group and click the Transaction Download tab To download cleared transactions to Quicken or QuickBooks 1 Onthe Transaction Download page in the Accounts field select one or more accounts for which you want to download cleared transactions You can press and hold the Shift key to select a range of accounts in the list or the Ctrl key to select multiple noncontiguous accounts Balance Report avorite Previous Same Day Account Day R eal Time 8 Activity Multi Day Transaction Download All Accounts EE Eastern Bark 1866666 Eastern Bartk 2 0 017 E CJ Download to Download to mp 3 2 In the From Date field enter the beginning date for which you want to download transactions You can enter the date manually or click the calendar icon to select a date In the To Date field enter the ending date for which you want to download transactions You can enter the date manually or click the calendar icon to select a date 4 Click one of the following a
14. era All Accounts 555555 Eastern Demo BBBBBB Eastern Demo 2 All Types From To Credits Debits Amount submit Save as Favorite Deposits Account 555555 Eastern Bank Demo Description Electronic Transfer Total Debits Total Credits 1 10 00 Transaction Description TRANSFER DEBIT 12 Collapse Opening Ledger 10 Closing Ledger 15 Current Available no CRS 5 50 250 00 Not Available Reference 2Eastern Bank D Multi Day The Multi Day Report is used to provide previous day account balance activity in a statement format for a specific date or range of dates You can also export information to an external file for use in another application l Generating a Multi Day Report Select the accounts or leave default of All Accounts Select the From and To date the default is the current month Change the Sort by if you do not want by date p oU I9 xe Click Submit to view report 5 f you wish to export the report in a CSV format click the Export button Balance Report lultiDay Balance Report Setup parameters Account Number d Accounts 5 0 eae re ene a ee From date 10 01 2012 555665 Bank lema To date BBBBBbb Eatern Bank 7 Sort File Output The report will display the Opening ledger on the first day of the date range total c
15. n Proceeds B Tran Group Accounts This service allows a Corporate Administrator or User to assign multiple accounts to transaction group used to filter the previous day report Once you assign an account to the transaction group when the transaction is selected in balance reporting all accounts assigned to the group will display the information Adding accounts to Transaction Group To permit accounts to transaction groups go to the Tran Group Accounts tab 1 Select a transaction group from the list of available types 2 Click on the Permit Accounts button 3 Usethe arrow buttons to move selected accounts between the inactive and active account lists Select the account s you want to add remove from the list by using the Shift key to select a range of accounts in the list or the Ctrl key to select multiple accounts in the list LBEX Lockbox Deposits PDCKS Paid Checks Display Accounts BR Accounts Permitted to DEP Available BR Accounts EASTERNBANK Trans Group 666666666 Eastern Demo 2 555555555 Eastern Bank Demo Eastern Bank li Displaying Tran Group Information To display the transaction group details go to the Tran Group Accounts tab 1 Select a transaction group from the list 2 Select the Display Accounts button The system will display the list of accounts assigned to the transaction group BR Transaction Groups LEs Lockbox Deposits FDCKS Paid Checks Permit Accounts BR Ac
16. nd follow the prompts to save the file 16 2Eastern Bank Appendix A Report Samples i Previous Day Report Samples Register report format without the Account Summary expanded Date range Jan 25 2010 thru Jan 25 2010 Generated on Jan 27 2010 at 04 01 PM Accounts returning data Bank Name Eastern Bank Account Account Name Eastern Bank Demo USD Account Summary Description Customer Ref Image Debit Credit Balance 01 25 2010 Incoming Wire Transfer Account 99765 4927 Account Name Eastern Bank Demo 2 USD Description Customer Ref image Debit Credit Balance 01 25 2010 Outgoing Wire Transfer Register report format with Account Summary expanded Accounts returning data Bank Name Eastern Bank Account Account Name Eastern Bank Demo USD Account Summary 10 16 2012 Amount 1 Day Float 50 00 2 Or More Days Float 50 00 3 Or More Days Float 50 00 Today s Opening Available 57 33 Closing Available 45 7 33 Opening Ledger 10 57 33 Closing Ledger 15 87 33 Average Closing Ledger MTD 59 00 Average Closing Available MTD 59 30 Average Closing Available YTD 51 00 Average Closing Ledger YTD 551 00 Total Credits 0 00 Total Lockbox Deposits 50 00 D NN 0 00 17 C2Eastern Bank Table report format Accounts Bank Namie Eastern Bank Account 12335578 Account Name Eastern Bank Demo USD Aamicurt 4 Day Float 3
17. nerating a Previous Day Quick pes Uds MEE TRC DOTS NET 4 IV BALANCE aep HN 8 PREVIO b qup 8 Generating Previous Day Report 8 Setting Report Preferences ves AERE HERES TUR pU FEY YE PEN 9 Hil A 10 SAME DASCISE ott dU E E MEIN DNE RD 11 Generating a Same Day Real Time Il PINT GUN LA II 12 E RENE 12 li Create d Favorite withun Account ACUVIY occ cic a sop Yin E OE es Eo dO Dn DE tua dias 12 MOCT DA T 13 Generating a VIII COP vectes 13 FAVORITE REPORTS T ees Ge na tn eee Em 14 Adame a 14 To run or export an existing Favorite 14 iii To edit characteristics of an existing Favorite Report esses eene eene nnne nennen nnns 14 We Todelete an existing Favorite a tee n nun 15 Report COMMIS 15 D TRANSACTION DOWNLOAD
18. redits and total debits for the account during the date range and the Closing ledger on the last day of the date range No other summary or status totals will display Date range Oct 01 2012 thru Oct 15 2012 Generated on Oct 16 2012 at 04 1 Bank Marre Eastern Hank Accounts Account Marne Eastern Bank Demo USD Account Summary Aornmount Open ing Ledger taf of 1070172012 10 90 Total Credis 312 00 Total Debts S415 5S7 Closing Ledger tas of 1071572012 rc Detail Credit raeanseactiens amount Bank Hef Cust Ret Motes REF 2770817L FUNDS TRANSFER 10 03 2012 Book Transfer Credit 51 00 FRMDEP 4681 FROM BUSONLINEBKNGOCT 0 3 2012 09 17 REF 27815091 FUNDS TRANSFER 10 04 2012 Book Transfer Credit RE FRMDEP 4691 FROM BUSONLINEBKNGOCT 0 420172 15 09 REF 284101581 FUNDS TRANSFER 10441042012 Book Transfer Credit 10 00 FRMDEP 46947 FROM BUSONLINEBKNGOCT 1 0 2012 11 15 item Court 12 00 Detail Debit Transaction Ament Bank Ref Cust Hef Motes REF 7540500141 FUNDS TRANSFER TO j1 z01 2012 Book Transfer Debit GA o SOl 13 Eastern Bank E Favorite Reports Use this page to edit delete or run your saved Favorite Reports You can also define new Favorite Reports from this page Balance Report j Favorite Account Reports Day Real lime li Activity vat i Download avorite Reports Available
19. s Favorite Deposits E Expand All E Account Total Debits Total Credits Opening Ledger 10 Closing Ledger 15 Current Available no CRS 556556 Eastern Bank Demo 2 12 07 ul 10 90 Not Available 49 990 BEBE Eastern Bank Demo 2 al 104 10 Not Available 10 197 755 19 Eastern Bank B Report Definitions Previous Day report Opening Ledger This is the total amount of funds in your account at the beginning of the day regardless of their availability i e all funds reported in your ledger balance may not be currently available This is equal to yesterday s Closing Ledger Closing Ledger Balance This is the total amount of funds in your account at the end of the day regardless of their availability i e all funds reported in your ledger balance may not be currently available This is equal to Opening Ledger plus any credits less any debits Today s Opening Available This reflects the opening available balance of today All other totals and items on the previous day report reflect balances and items from the previous business day This is equal to Closing Available plus 1 Day Float Closing Available This is the total amount of available funds in your account at the end of the day Available funds are funds that are available for immediate withdrawal This is equal to Closing Ledger less Closing 1 Day and 2 Day Float 1 Day Float These funds will be immediately available on the next business day
20. s for this Favorite Report Make necessary changes to runtime parameters and report characteristics You can change all fields except the Created By and Last modified on fields Click Save to update your edited Favorite Report on the system or click Cancel or the Favorite Reports service tab to return to the Favorite Reports page without saving your changes 14 Eastern Bank iV To delete an existing Favorite Report 1 From the Favorite Reports page click E in the Delete column to the right of the Favorite Report you want to delete A Delete Confirmation dialog box displays which prompts you to delete this Favorite Report 2 Click OK to delete the Favorite Report from the system or Cancel to return to the Favorite Reports page without deleting the selected report 3 The system displays the refreshed Favorite Reports page V To sort Favorite Report columns On the Favorite Reports page click the appropriate column header to sort the list of Favorite Reports e Shared Groups all shared Favorite Reports at the top of the list Click again to group all private reports at the top of the list e Report Name Sorts Favorite Reports in ascending alphabetical sequence Click again to sort the list in descending alphabetical sequence e Type Groups all HTML Favorite Reports at the top of the list Click again to group all export file reports at the top of the list e Owner Sorts Favorite Reports in ascending alphabetical s
21. sternbk com BR Same Day Enable Date 10 02 05 2010 Same Day Quick Reports User Type Admin Contact Name 40 tony testor ii Assigning Accounts to users If still on the User Admin page click Permissions link otherwise 1 Click on User Administration in the drop down list 2 Click on User Admin and click the Permissions link 3 Select the accounts for BR previous and BR same day 4 Click the Submit button User Account Permissions Select All BR BR Bank AcctNum Acct Name Previous Same Book Money Positive Day Day Transfer Loans Transfer Pay Stops Eastern Bank Demo Eastern Bank BR Administration A Transaction Groups Use this service to create groups of transactions that contain one or more BAI Bank Administration Institute type codes The Transaction Groups service enables you to customize output for the Previous Day reports The Bank has predefined the following groups ACH Credits ACH Debits Deposits Lockbox Deposits Paid Checks Return Deposited Items Wires In and Wires Out Using a Bank Defined Transaction Group To utilize a Bank defined Transaction Group you must first select an account and permit it to the transaction group 1 Goto the Balance Rpt Admin select the Tran Group Account tab 2 Highlight which group you want and click on the Permit Accounts button 3 Choose the account and use the arrow to move it over Group Groups 8 Accounts
Download Pdf Manuals
Related Search