Online Treasury Manager: Balance Reporting
Contents
1. Online Treasury Manager Balance Reporting SUNT RUST Online Treasury Manager Balance Reporting User Manual Table of Contents re peace cee gree ao ees cette ensee recte ttre canteen E E E 1 POY SUG TNE Za CCS EEA create cant A I eas N E E N O E AOE E IAE A E E A E E E E T 1 Lonin Lorut Procede ar A E E eee ee nee ee AE E E A eee ee 2 Online Treasury Manager Modules sisccusrseieureisusisenine nid ai a E EAO EE E E A T E 2 CCE SING TAGS in T E EE EE E E T EE 3 System Availability and Cut Off TINICS ssscscssscsccersacsscassssivesvesesiavssecenseaticsssisontessssvavstacaiatunssaieinieuasasssiavsavsnecststanasutaiuavaneds 3 BALANCE REPORTING c ssresinn ee ee ee ee ee 6 Previous and Same Day Balance Reports sisssccesessetnisssasenstccinsiviocensassovistasicetnenssetsigevacensasvadiiassiseussisiadtesdeioxiassssetiutiiansucets 7 IRV reae o EE E E A R E css cost A A N A A TE A A E E O A E A E 9 MaliDay REPOT eii a REE E EET 13 SUNTRUST 031005 page i Online Treasury Manager Balance Reporting User Manual OVERVIEW With Online Treasury Manager you can stay connected to SunTrust over the Internet There s no software to load no security devices to install and no intensive programming efforts to send and receive files Just link to SunTrust using a standard web browser and you re connected to the source for you treasury management needs To ensure the privacy of your company s financial information SunTrust provides multiple levels of2. sort orders by amount ascending or descending bank reference customer reference date or BAI type code e Totals for reporting status level and summary level transaction type codes Bank will total the same type of status and summary level information across all accounts within a given bank for a single day Report totals the same type of status and summary level information across all banks for a single day File Output Exports the balance reporting data to an external accounting application You can select the format from the File Output drop down list and click the Export button File output type Application Comma Delimited CSV MS Excel han IIF Import Quick Books BAI Output DOS applications STI CSV MS Excel alternative form Keep in mind that the application used to open an exported file is dependent on your PC s settings to open specific file name extensions For example your PC might open a comma delimited file in Excel but it can also be opened in Notepad SUNT RUST 03105 page 10 Online Treasury Manager Balance Reporting User Manual _ SuNT RUST Online Treasury Manager BR Reports Ls ABC COMPANY ADMINISTRATOR Bank SUNTRUST ATLANTA Account 8800772314 ABC CO GEORGIA SERVICES USD 07 19 2004 Opening Ledger Balance 07 15 2004 Opening Ledger Balance 07 15 2004 Closing Ledger Balance 07 19 2004 Closing Ledger Balance 07 19 2004 Average Closing Ledger Balance 12 Mo Avg 07 15 2004 Average
3. 1 00 A M Current Month Bank provides on line access to images of paid One Month of checks from previous business day History Stop Images Mid 11 00 A M 45 Calendar Atlantic Accounts Days Wire 8 00 A M 5 30 P M Wires received after 5 30 P M are subject to next day processing Wire Domestic wires and international wires in US Dollars can be future dated a max of 30 calendar days in advance Foreign currency wires cannot be future dated Wire By Phone 8 30 A M 4 30 P M Wires done by phone ONLY Wire Report 186 Cal Days This is only for the Wire Report under the Wire Transfer module All times are in Eastern time zone SUNTRUST 031005 page 5 Online Treasury Manager Balance Reporting User Manual BALANCE REPORTING Online Treasury Manager offers several different types of balance reports These reports include either Previous Day or Same Day account balance information The MultiDay activity report provides a summary statement report for a range of dates Note For image retrieval access to the viewer requires the installation of the Imagelnsight Java applet To download the applet please see Accessing Images in the Introduction section of this document For cut off times retention and other processing notes please refer to System Availability and Cut off Times in the Overview section of this user manual Feature Functionality The Balance Reporting module is labeled BR Reports i
4. Closing Ledger Balance 12 Mo Avg 07 15 2004 Opening Available Balance 07 19 2004 Opening Available Balance 07 19 2004 Collected Balance 07 15 2004 Collected Balance 07 15 2004 Beginning Statement Balance 07 19 2004 Beginning Statement Balance 07 19 2004 Average Balance for Preceding 3 Months 07 15 2004 Average Balance for Preceding 3 Months 07 15 2004 Adjusted Average Collected Balance Mtd 07 19 2004 Adjusted Average Collected Balance Mtd 1 055 698 49 1 055 698 49 836 162 86 836 162 86 565 026 00 565 026 00 789 118 37 789 118 37 761 005 49 761 005 49 1 206 373 70 1 206 373 70 661 655 00 661 655 00 438 219 81 438 219 81 Help Bulletin Manuals Contacts Logout Previous Day Balance Report 3 Jul 15 2004 thru Jul 19 2004 Printed on Sep 28 2004 at 01 43 PM Individual ACH Credit Received Individual ACH Credit Received 07 19 2004 07 15 2004 19 95 19 95 87654321 87654321 Previous Day Balance Report with consolidate multi day option SuNTRUST Online Treasury Manager BR Reports ABC COMPANY ADMINISTRATOR BAI File containing 226 records was created successfully gt To DOWNLOAD BAI File Download BAI File Help Bulletin Manuals Contacts Logout BAI Output As of Jul 19 2004 to Jul 19 2004 Created on Sep 28 2004 at 02 13 PM Previous Day Balance Report with BAI file output export option i SUNTRUST 03105 page 11 Online Treasury Mana
5. a Zu Check Image The following tools are available to facilitate online image research e Save Save the displayed image to disk for future use tif format e Print Prints the front and bank of the imaged item on a single page e Zoom Zooms in and out on the image e Reverse Changes image from black on white to white on black to make small or fine print easier to read e Rotate Turns the image 90 degress to read endorsements etc e Brightness and Contrast Adjust either image attribute to make dark or faint print more legible e Front and Back Alternate between the front and back of an image a SUNTRUST 031005 page 9 Online Treasury Manager Balance Reporting User Manual Report Options Balance reports may be customized to your specifications for account balance type transaction group date and amount ranges You can define the layout of your report by selecting the report characteristics In addition you can export the data to various accounting applications Account Number to select individual or all accounts Balance Types to display all balances and transactions or to display only the status balances summary totals detail debit transactions or detail credit transactions Transaction Groups allow you to select the type of BAI codes you want to include in a report Two types of groups are available predefined transaction groups by SunTrust and customized transactions groups unique to your co
6. ance Reporting 7 00 A M 93 Cal Days Date range inquiries limited to 45 days at a Previous Day time Balance Reporting 93 Cal Days Previous Day Images Balance Reporting Vary upon service 93 Cal Days ACH Transactions 7 30 a m Same Day Account Transfers Real time Controlled Disbursement Late Presentment 10 00 a m Lockbox 8 30 a m Wire Transfers Real time ERD Special Reports T 7 Cal Days 5 Business e ao i i i ERD ACH EDI 9 00 a m 7 Cal Days Receiving Positive Payment Report Available at 9 A M 93 Cal Days This is the earliest time the Positive Payment Exceptions Images reports are available for exception decision Pos Pay accounts only making Positive Payment 12 00 P M Same Day This is the deadline to notify the Bank Exception Pay Return regarding the validity of the current business Decision Making day s mismatched checks A Pay or Return decision is required by this time Positive Payment Report Available at 9 A M 93 Cal Days This is the earliest time the Positive Payment Reverse Positive reports are available for exception decision Payment and Payable making Images of checks or draft items are Thru Draft Check Return available through the Image or Balance Reporting modules Positive Payment Return 12 00 P M Same Day This is the deadline to notify the Bank Decision Making regarding the validity of the previous business Reverse Positive day s paid checks Return
7. decisions are Payment and Payable required by this time Thru Draft Check Return nal ow O Deadline Positive Payment Images Available at 7 00 A M Current Month PREV DAY One Month of CPR accounts only History Positive Payment Report Available at 1 00 P M 93 Cal Days This is the earliest time the Positive Payment Images Exceptions reports are available for exception decision CPR accounts only making Bank provides on line access to images of the current day s mismatched checks SUNTRUST 03105 page 4 Online Treasury Manager Balance Reporting User Manual Positive Payment 12 00 P M Next day Exception Pay Return Decision Making This is the deadline to notify the Bank regarding the validity of the previous business day s mismatched checks A Pay or Return CPR accounts only decision is required by this time Stop Payments Placed 8 00 A M 10 00 186 Cal Days Stop should be available to tellers within P M seconds during normal bank business hours DDA and ARP Otherwise the stop is in queued status Stops Accounts Only are effective for 6 months 12 00 P M 10 00 P M CPR Accounts Only Stop Payment and Paid ARP and DDA 93 Cal Days Information is stored for 186 calendar days Item Inquiry accounts no time about 6 months constraints 12 00 P M 10 00 P M CPR Accounts Only Stop Payment Reports Ft 186 Cal Days about 6 months Stop Images Availability 1
8. e report for all accounts The default settings will produce a balance report for all accounts listing their balances and all debit and credit transactions under those accounts For complete examples of the report content please refer to the Balance Reporting Sample Report Package eI SUNTRUST y 031005 page 7 Online Treasury Manager Balance Reporting User Manual SunTrusr Online Treasury Manager Help Bulletin Manuals Contacts Logout BR Reports ABC COMPANY ADMINISTRATOR Previous Day Balance Report w As of Jul 19 2004 Printed on Sep 28 2004 at 01 38 PM Bank SUNTRUST ATLANTA Account 8800772371 ABC CO FLORIDA SERVICES USD Opening Ledger Balance 4 951 14 Closing Ledger Balance 9 799 06 Collected Balance 596 14 Total One Day Float 4 313 00 Total Two or More Days Float 42 00 Total Credits 153 410 49 5 Total ACH Credits 128 054 47 3 Total ACH Return Credits 0 00 Total Debits 148 562 57 30 Total ACH Debits 117 451 76 2 Total ACH Return Items 0 00 Individual Wire Debit 3 00 UNIPAC 12345678ABC 0123456789 Previous Day Balance Report a SUNTRUST Online Treasury Manager BR Reports a ABC COMPANY ADMINISTRATOR Same Day Balance Report As of Jul 20 2004 Printed on Sep 28 2004 at 03 32 PM Help Bulletin Manuals Contacts Logout Bank SUNTRUST ATLANTA Account 8800772363 ABC CO MID ATLANTIC SERVICES USD Total Controlled Disbursing Debits 212 436 83 Tota
9. ed CSV S 8800772314 ABC CO GEORGIA SERVICES USD 0088 8800772363 ABC CO MID ATLANTIC SERVICES USD 0088 8800772371 ABC CO FLORIDA SERVICES USD 0088 Help Bulletin Manuals Contacts Logout by date ie Click the Submit button for the default month to date MultiDay report for all accounts The default settings will produce the statement report for all accounts with the date range beginning with the first business day of the current month through the previous business day a SUNTRUST 03105 page 13 Online Treasury Manager Balance Reporting User Manual SuNTRuUST Online Treasury Manager BR Reports se MultiDay Help Bulletin Manuals Contacts Logout Account Activity Report S Requested Dates Jul 15 2004 thru Jul 19 2004 Generated on Sep 28 2004 at 01 46 PM Bank SUNTRUST ATLANTA Account 8800772314 ABC CO GEORGIA SERVICES USD Account Summary Amount Opening Ledger as of 07 16 2004 836 162 86 Total Credits 218 266 94 Total Debits 437 802 57 Closing Ledger as of 07 19 2004 836 162 86 01 01 2005 Individual ACH Credit Received 23 49 ACHCAMERICAN 33333333 01 01 2005 Individual ACH Credit Received 27 39 ACHCAMERICAN 11111111 01 01 2005 Individual ACH Credit Received 23 29 ACHCDISCOVER 123123121 01 01 2005 Individual ACH Credit Received 29 40 ACHCAMERICAN 444444444 01 01 2005 Individual Other Deposit 23 49 ACHCAMERICAN 33333333 01 01 2005 Ind
10. ger Balance Reporting User Manual Report Preferences The Preferences button allows you to modify the default report layouts for your Previous Day and Same Day balance report You can specify the order in which the accounts are displayed transaction sort order report style how totals are displayed and whether to display summary or detailed transaction information Your preferences will remain in effect until you make changes a SuNIRUST Online Treasury Manager BR Reports Help Bulletin Manuals Contacts Logout style Table Horizontal with text notes Y sort bytype code sort 2 by amount totals show totals 8800772371 ABC CO FLORIDA SERVICES 88007 72314 ABC CO GEORGIA SERVICES 88007 72363 ABC CO MID ATLANTIC SERVI Account Number Ascending a Ns SUNT RUST 031005 page 12 Online Treasury Manager Balance Reporting User Manual MultiDay Report The MultiDay report provides previous day balance and transaction information as a statement snapshot containing a summary section then credit and debit transactions It can be exported to a comma delimited file This report can access up to 65 business days of history To generate a MultiDay report e Select Multi Day from the task bar and click the Submit button eS ss SunTrust Online Treasury Manager BR Reports y From To AccountNumber s ile utput 07 01 2004 07 31 2004 MEE Comma Delimit
11. ility and Cut Off Times Online Treasury Manager can be accessed 24 hours a day seven days a week for information reporting and transaction initiation services Specific account information is updated at various times throughout the day When new features and functions become available these releases are introduced on weekends during non business hours to minimize any disruption to your usage of the service ACH Initiate 10 30 A M 2 30 P M The cut off for both Debits and Credits is 7 30 5 30 P M and 7 30 P M ET two days prior to effective date Files P M received by 10 30 A M ET one day prior will be processed on a best effort basis ACH Batches ACH Batches can be sent a max of 14 calenda days in advance ACH Pass Thru 7 00 P M Follow same guidelines as ACH Initiate ACH Reversal In order for an ACH batch to meet the 4 00 P M deadline it will have to have been received prior to the 2 30 P M cutoff time ACH Reports 486 Cal Days OTM ACH initiated activity about 6 months SUNT RUST y 031005 page 3 Online Treasury Manager Balance Reporting User Manual Account Transfer M If it is done before 5 30pm it is the Same Day If it is after 5 30 it is Next Day Account Transfers are processed by the ACH system Account Transfers Account Transfers can be sent a max of 14 calendar TT in advance Account Account Transfer Reports Reports Account Transfer Reports 186 Cal Days about 6 months 6 months Bal
12. ividual Other Deposit 27 39 ACHCAMERICAN 11111111 01 01 2005 Individual Wire Credit 23 29 ACHCDISCOVER 123123121 MultiDay Account Activity Report SuNIRUST Online Treasury Manager BR Reports A 654321 Multi Day Activity Report Requested Dates Jul 15 2004 through Jul 19 2004 Generated on September 28 2004 at 14 04 56 Bank SUNTRUST ATLANTA Account 8800772314 ABC CO GEORGIA SERVICES USD 1 g 3 4 5 6 i 8 Account Summary Amount Opening Ledger as of 07 16 2004 836 162 86 Total Credits 218 266 94 Total Debits 437 802 57 Closing Ledger as of 07 19 2004 836 162 86 DETAIL CREDIT TRANSACTIONS Date Detail Credit Transactions Amount Availability Bank Ref Cust Ref Notes 7 19 2004 Individual ACH Credit Received 131 94 ACHCDISCOVER 987654321 O 2NNA Individual ACH Credit Received 494 2 ACHCAMERICAN 987654322 Multiday Account Statement Exported To CSV Format Report Options Selecting accounts and specifying a date range can customize the MultiDay statement snapshot report The report may be further sorted by amount ascending or descending bank reference customer reference date or BAI type code Pai SUNTRUST 031005 page 14
13. l CDA 1st Presentments Debits 93 180 79 Total CDA 2nd Presentments Debits 93 870 37 Individual Lockbox Credit 0 Day Float 1167330 tem Count 1 Individual Wire Debit 3 00 0111111 IMAD 12345678ABC REF 0123456 oo oo Same Day Balance Report a SUNTRUST y 031005 page 8 Online Treasury Manager Balance Reporting User Manual Image retrieval If you have access to online images you can obtain images for most paper based transactions from your Balance Report Detail Debit Transactions INDIVIDUAL DEBIT FOR LIST POST SUMMARY 179 887 59 Bank Ref SUDR000000000000 INDIVIDUAL CPR PAID CHECK 149 262 18 et Bank Ref CPRP000000000000 Cust Ref 123456 INDIVIDUAL CPR PAID CHECK 16 100 00 Bank Ref CPRP000000000000 Cust Ref 123456 To access an image e Click the Image icon checkbook picture from the balance report Online Treasury Manager presents the associated check image in the enhanced image viewer Dae Amount Account Number Serial Number N Close Close 09 05 03 390 33 8888888888 1234567 81211232 File Edit View Qa QIK aaea ern 5 ABC Company CHECKNO 1234567 SunTrust BANK 123 Main Street CHATTANOOGA NLA CHATTANOOGA TN Anytown USA 12345 87 41 613 DATE AMONT 09 04 2003 390 33 PAY THREE HUNDRED NINETY DOLLARS and 33 CENTS OF THE HONORS COURSE INC PAYROLL ACCOUNT Jane Smith i i a a tome John Doe OADER E 9999999 1 666886668861 OL9 G8
14. mpany s specific needs Your company s Security Administrator maintains the customized transaction groups Query from to allow you to specify date and amount ranges for your report Note the maximum report date range is 45 calendar days To access the Previous Day or Same Day Balance Report for the all of Online Treasury Manager s historical data 93 calendar days of information you would need to run multiple queries If inquiring on a large date range check the Consolidate multi day report box to eliminate the repetition of data Instead of receiving a report for each day in the range Online Treasury Manager produces a single report adding a date value for each item in the report Report Characteristics e Type detail providing all details of the report transactions such as reference information and text or summary providing only a description of the transaction and an amount e Style report table style e Table displays information using a minimum amount of horizontal space e Table horizontal with text notes Displays information using a minimum amount of vertical space and includes a text column within the detail transaction section e Table horizontal no text notes Displays information using a minimum amount of vertical space but does not include the text column within the detail transaction sections e Raw Displays the table report in non formatted plain text e Sort 1 and 2 primary and secondary
15. n the group drop down menu The following features are available Previous Day Access Previous Day Report Retrieve Images Export Report Data Set Report Preferences Same Day Access Same Day Report Retrieve Images Export Report Data Set Report Preferences MultiDay e Access MultiDay Report e Export Report Data SUNT RUST y 031005 page 6 Online Treasury Manager Balance Reporting User Manual Previous and Same Day Balance Reports To generate a balance report e Select BR Reports on the group drop down menu e Select either Previous Day or Same Day from the task bar and click the Submit button jE SuNTRUST Online Treasury Manager AccountNumber 8800772314 ABC CO GEORGIA SERVICES USD 0088 8800772363 ABC CO MID ATLANTIC SERVICES USD 0088 8800772371 ABC CO FLORIDA SERVICES USD 0088 Help Bulletin Manuals Contacts Logout All Balances amp Transactions Raggi No Transaction Groups No Transaction Groups Status Balances 1ACHCDA SAME DAY ACH AND CDA 00000000001 Test Summary Totals ACH ACH Transactions 0001 Checks Paid date 07 19 2004 07 19 2004 type detail v amount style table horizontal with text notes Y O Consolidate multi day report sort by type code sort 2 by amount amp totals show totals Y a Click Submit to obtain the default Previous or Current Day balanc
16. ry Manager Balance Reporting User Manual Accessing Images Online Treasury Manager utilizes the Imagelnsight java applet distributed by CheckWorks Inc to retrieve and distribute images to your desktop When you click on an Image icon for the first time the java applet downloads to your desktop dynamically This Java Plug in Security Warning window appears Do you want to install and run signed applet distributed by CheckyYorks Incorporated Publisher authenticity verified by VeriSign Inc oO L The security certificate was issued by a company that is trusted Click Grant Always A The security certificate has expired or is not yet valid Caution CheckyVorks Incorporated asserts that this content is safe You should only install view this content if you trust CheckvYorks Incorporated to make that assertion Grant this session Deny Grante Nays View Certificate e Click on the Grant Always button Within a few seconds you should see your image e Ifyou do not see the image within a few minutes close the image window and start over e If you still do not see an image within the next 5 minutes contact your IT department as you may not have admin rights to install software on your PC If so your Administrator will have to logon and install the Java applet for you If you continue to have problems contact the Technical Services Group at 1 877 785 6925 System Availab
17. security From firewalls to passwords and encryption the system is designed to safeguard your privacy In addition your Security Administrator determines who in your company can access information as well as who can initiate and approve transactions System Access Online Treasury Manager can be accessed on the Internet at this address https onlinetreasurymanager suntrust com IDs and Passwords A combination of 4 elements Customer ID Customer Password User ID User Password is required to access Online Treasury Manager You will be required to create a new password when you access the system for the first time Your password must be changed every 30 days Online Treasury Manager prohibits the re use of your previous 12 passwords Inactivity Time Out The system will time out suspending access if your session is idle for more than 15 minutes However during a timeout period your browser can remain connected to Online Treasury Manager Access can be regained by re entering your user password Activity in Online Treasury Manager is recorded by screen changes or the use of the Submit button If inactivity exceeds 30 minutes you will have to re enter all login information to sign back into the system Please note that data entry alone is not considered activity When entering large blocks of data click on Submit Changes periodically to avoid inactivity time out Important Notes When using Online Treasury Manager please do no
18. t use your browser s Refresh button In some cases this could cause a form to be submitted twice Do not use the Back button unless specifically instructed While clicking the back button will return you to the previous page it will not reverse any transactions performed prior to your clicking the back button Required fields With exception to the login screen required data entry fields for Online Treasury Manager are noted in red SUNTRUST y 031005 page 1 Online Treasury Manager Balance Reporting User Manual Login Logout Procedures After entering your Customer ID customer Password your User ID and your user Password and click on the Login button Online Treasury Manager Password User ID q P Password q 2004 SunTrust Banks Inc All rights reserved Equal Housing Lender Member FDIC Pri Security ACY diy To exit the system you must click Logout found at the top of the screen after this logon page Online Treasury Manager Modules Each module of Online Treasury Manager is accessible from the drop down box at the top left of your screen a SuNTRuST Online Treasury Manager Help Bulletin Manuals Contacts Logout Select a grou p v Selecta group K e menu to get started Corporate Users ERD Admin Transfer Admin Wire Admin Wire Transfer You will only see those groups that your user ID has permission to access i SUNTRUST y 031005 page 2 Online Treasu
Download Pdf Manuals
Related Search