Home

USER MANUAL - Chesapeake System Solutions

1. Please enter your current usemame and password and your new password Username chessys SEE SE Current Pazsivord jae New Pazsword btt Confirm Hew Password 3 Select the OK button 4 If your current username and password are correct and the new password matches the confirmation password the system will grant access to SmartAnalysis and change your password to the new password Please note that the next time you log on to SmartAnalysis you will have to use the new password you entered 1 2 Troubleshooting A Failed Login Attempt There are a number of reasons why a login attempt may have failed Invalid Username or Password In most failed login attempts the problem is that the user s security credentials were entered incorrectly If this is the case please re enter your username and password again Account Not Created If repeated attempts to access the system fail it may be that the SmartAnalysis System Administrator has not yet created an account for you Please confirm that the SmartAnalysis System Administrator has setup your account Account Disabled If repeated attempts to access the system fail with a user account that worked previously it may be that your account is now inactive This can happen for a number of reason
2. yBanking Information Fee Query Balance Query Discrepancy Query WAreport Manager 04 Security Manager Selecting the The Security Manager Perspective from the Perspective Toolbar There are several core concepts in the Security Manager Managing Users The Authorities View The AuthorityGroups View 13 5 Managing Users Managing users involves several views and editors as well as the assignment of authorities and groups to users 1 The Users View 2 The User Editor 3 Why Users Cannot Be Deleted 4 Assigning Authorities and Groups 13 5 1 The Users View The Users View contains the list of all users in the system Users es a il LL bsmith chederowicz chessys dhoagie 1sixpaq rboswell B The Users View Scroll up and down to see all the users Double click on the user name to open The User Editor 13 5 2 The User Editor User accounts can be edited by the SmartAnalysis Administrator Importantly if a user s account becomes disabled for any reason typically through inactivity or by exceeding the maximum number of failed login attempts it may be reactivated here Likewise if an active account should be disabled and the user prevented from accessing the system the user account can be deactivated here To manage users you must be a SmartAnalysis Administrator If you have the requisite access follow these steps to edit a user Creating a User Users pe a F bsmith TE amp
3. Potentially Dormant Account ABC Toys LLE 1333001724 0 4 Incorrect Service Charge DEB ABC Toys LLC 13353001 724 0 0 Incorrect Service Charge CRE ABC Toys LLE 1333001724 5 0 Incorrect Service Charge yc lt gt Discrepancies Assigned To Me Dashboard Element 2 2 Configuring the Executive Summary Perspective The Executive Summary Perspective may be configured in two ways to suit an individual user s preferences The configurable options are the layout and the selected dashboard elements Please note any changes to the configuration of the Executive Summary Perspective are for the current session only and will not be saved between application launches Once the application is closed and re opened the Executive Summary Perspective returns to the default configuration 2 2 1 Changing The Executive Summary Perspective Layout The default layout of the Executive Summary Perspective divides the perspective into two equal columns In the left hand column there are two large element areas while in the right hand column there are four small element areas This layout provides a legible display for six total Executive Summary Dashboard Elements In general it is recommended that charts and graphs be displayed only in the large element areas while tables of information may be displayed in either large or small element areas fey Executive Summary Element Selection jSmell Elame oo Top Decrepances By Vanan
4. Description Sent Date 10 17 2005 Confirmed Date Bank Confirmations 3 10 Deleting a Detail Account To delete a detail account select the account in the Banking Structure View and click the Delete menu item from the view menu cing Structure I ca A i F AMSOLITH BANK 062000019 Mew gt Relationships G8 12121 RELATIONSHIP SUMMARY E Import Statement i i 41705459 THE ABC Company Fi Edit oo Statements Bank OF America 121000358 isl Delete Bank of Chesapeake 012566011 Bank of England MD 052000212 A Account QuickFind Pm eee ee ee Tee ee ee bom ee bi iy Deleting a Detail Account 3 11 General Ledger Export Every financial transaction in your company is recorded in your General Ledger General Ledgers contain many accounts including separate accounts for income expenses and losses Each time an entry is made in the General Ledger it is recorded as a debit to one account and a credit to another account SmartAnalysis handles these debits and credits by exporting a file with allocated net banking charges at either the relationship or account level The GL Export feature exports the net fees according to the allocation defined in the account or relationship setup to a delimited text file either tab or comma that can then be fed into the General Ledger or other accounting software package These allocations are created at the Relationship and Account levels to assign the appropriate service
5. Unit Rate Entering a unit rate To enter a unit rate select the per unit rate radio from the left hand side of the rate details section Input the numeric unit rate into the field 3 6 2 4 2 Flat Rate The value for this type of rate is evaluated alone and the amount listed is the expected total amount Rate Details Flak Rate Per Unit Rate 2 Threshold Rate Tiered Rate Flat Rate Entering a flat rate To enter a flat rate select the flat rate radio from the left side of the rate details section Enter a numeric value in the field to indicate what the flat rate for the negotiated fee should be 3 6 2 4 3 Threshold Rate A threshold rate is a charge structure where the per unit fee changes at an agreed level of activity When the volume of the charge equals or exceeds the threshold the calculation will use the after threshold rate Prior to that the calculation will use the before threshold rate Rate Details Before Threshold Rate Flat Rate Threshold Per Unit Rate After Threshold Rate Threshold Rate Tiered Rate Threshold Rate Entering a threshold rate To enter a threshold rate select the threshold rate radio button at the left hand side of the rate details section Enter appropriate values in the fields for the threshold rate Fields e Before Threshold Rate The rate that will be charged for volumes below the threshold e Threshold The volume at which the rate will shift to the upper rate
6. Charge Description j Sa Mea Cle Fee No Negotiated Fee is avadable Date Description The account RELATIONSHIP SUMMARY OSI00S2Z00200252 was found on the statement but has been marked as Closed in bank setup on 04 01 2005 Change History L Comment made by chessys on 08 15 2005 i Auto Resolve Tide Research This is being researched by Chris L Add Comment File Attached by chessys on 0815 2005 Bd Send E mail WD Insert Attachment amp View Statement 7 4 3 5 E mailing Discrepancy Information When viewing discrepancy details you have the option to send an e mail containing the discrepancy s information For instance you may want to send the details of the discrepancy to a manager or the bank for further review NOTE When a statement is deleted all e mail audit trails are also deleted Attaching an e mail d E mail 1 From the Discrepancy Details screen select the o l link 2 Fill in the details of the message using the E mail Dialog The details of the discrepancy will be automatically populated in the Message from SmartAnalysis section These details can be edited before the e mail is sent which allows you to remove account numbers or make other modifications E mail discrepancy details E mail information From Tao PO CG Subject Message Message from SmartAnalysis No match For service charge with service code 55 55 55 and bank code B5 for account Account A 11000 wa
7. USER MANUAL VERSION 50 SmartAnalysis is a trademark of Chesapeake System Solutions Proprietary and Confidential Trademarks SmartAnalysis and Chesapeake System Solutions words and design logo are trademarks of Chesapeake System Solutions Inc Windows Windows 95 98 and Windows NT are registered trademarks of Microsoft Inc Other trademarks referenced are the property of their respective owners All trademarks are used for identification purposes and do not establish an affiliation or soonsorship by the trademark owners of Chesapeake s products and services Copyright All Software Documentation and other Materials provided by Chesapeake are Copyright 1995 2005 Chesapeake System Solutions Inc unless otherwise stated All copyrights of third parties used with permission or under license 10220 S Dolfield Rd Owings Mills Maryland 21117 Main Office 410 356 6805 Product Support 410 356 6805 Fax 410 356 7625 All rights reserved Printed in the United States of America Notice The manual and any accompanying material Documentation are being made available to the Client in conjunction with the Client s use of the System described herein in accordance with the Client s agreement with Chesapeake System Solutions Inc Chesapeake This documentation is made conditionally available to the extent that receipt and acceptance limits its use to the purpose stated above and that the information cont
8. 3 Click OK SmartAnalysis validates your security credentials and launches the application If any of the information typed in the login screen is incorrect a warning message is displayed Click OK to continue Invalid Security Credentials A The username and password supplied do not match any users in the system 1 1 Changing Your Password During Login It is possible to change your password when logging on to the system You may wish to do this for example to change a System Administrator assigned password to something that you are more likely to remember and that only you know Depending on your Login Security System Parameters you may also be forced to change your password during login In either case follow the steps below 1 Select the Change Password button from the login screen SmartAnalysis Login j E a u a a EFEFEF ft P i Mey r a a J HTA ae e ee ee an hg yt ate a a Pa i a As i H ra pa ne e o a a ee ae a d ee x a ee ot i ee ma j A ic s rig os sitet ij F O r rY 7 5 F te P n T i i G o a i me z Ds a j pir pa E T j j ose i Please enter your Username and Password to login to SmarbAnalysis Username Password Cancel Change Passward 2 Enter your current username and password as well as your desired new password Then re type your newly selected password in the Confirm New Password field Change Password
9. Emad So hepi Bonk Aeiionawe Manager Corporate Arani 411 888 Pea bihanan ABD oon West Coast Account 0700487534 Contact Name Tt Department Phone Number AH Phone No Email Alen imiji Egesina Wanager Processing Cather aiming ABG com East Coast Account P0000712 Contact Name THe Deoarment Phone Aumber AR Phone No Emad Wengrica Hali P jcess Manager Poppecsing Center 410 356 4405 Wea SHS com Contacts By Bank Report Sample Columns The Contacts By Bank Report displays columns related to contact information 1 Contact Name The name of the contact 2 Title The contact s title 3 Department The organizational unit in which the contact works 4 Phone Number The contact s primary phone number 5 Alt Phone Number The contact s alternate phone number 6 Email The contact s email address Contact Name Title Deparment Phone Number Alt Phone No Email Contacts By Bank Report Column Header Groups The Contacts By Bank Report is grouped in the following way 1 Contact for each bank are displayed 2 Followed by the contacts for each relationship in the bank 3 Beneath which each account for the relationship is listed including any contacts 1 Bank of Chesapeake 012568011 Contact Name Title Department Phone Number Alt Phone No Email Jim MeCiellan Regional VP Regional Accounts 410 355 7798 meclellangibote cam 2 RELATIONSHIP SUMMARY 0700487535 Contact Name Tithe Department Phone Number Alt Phone No Email
10. Hold the mouse button down Banking Structure Ea 7 I ii AMSOUTH BANK 062000019 papak 1 J DEFAULT RELATIONSHIP SUMMARY DEF AUL eas 41705459 THE ABC Company itl Leb Statements a Bank OF America 121000358 amp nce se Le en ae fe ninr Managing Detail Accounts step 1 2 While holding the mouse button down drag the pointer until it is hovering over the desired destination relationship in the Banking Structure View The target relationship should become highlighted g Confirmation re vou sure vou want to drop the selected Account s onto Relationship RELATIONSHIP SUMMARY 1212147 ceel Managing Detail Accounts step 2 When the target relationship is highlighted release the mouse button A confirmation dialog appears asking you to confirm your reassignment Verify the correct destination relationship is selected and hit Ok Hit Cancel to abort the drop Banking Structure a 7 i fea ie AMSOUTH BANK Reena LS Relationships E 12121 RELATIONSHIP SUMMARY a 41705459 THE ABT Company DEFAULT RELATIONSHIP SUMMARY DEFALIL Es os statements Managing Detail Accounts step 3 3 7 Deleting a Relationship Deleting a relationship is a powerful function When a relationship is deleted all detail accounts assigned to that relationship are deleted To delete a relationship select it in the banking structure view and select Delete from the context menu You will be asked to con
11. Ledger Balance Month End 00 00 10 Collected Balance Average Met na on ii Collected Balance Qverane Procikive lt gt Selecting comparison codes will constrain the results to those service charges whose associated negotiated fees which have the selected comparison codes assigned to them Comparison Code Families Pr ym 1 J 01 General Account Services Ps 05 Lockbox Services OF Merchant Card Services 08 Purchasing Card Services 10 Depository Services 15 Paper Disbursement Services 16 Retained Asset Services F0 Paner Michiircemnent BFecnnciliatinn Service lt gt Selecting comparison code families will constrain the results to those service charges whose associated negotiated fees have one of the family s member comparison codes assigned to them Charge Amount 0 00 Entering an amount and selecting a comparison operator will constrain the service charges to those whose total amounts meet the combination of the comparison operator and the amount 8 2 The Fee Query Results View The results view displays the data representing those service charges returned by the execution of a query based on the criteria entered in the Fee Query Criteria View Sorting Charge Information Bank Code Service Code Description Unit Cost Total Units Total Cost Bank ABA Number Opri Account Name Account Numb 0m Of 00 Oo ACCT Mi 12 00 24 00 2 00 ARSOUTH BANE Go2000019 C
12. Plata fate 1 Discrepancies can be viewed for each statement in the Discrepancy Query dashboard 2 Use the criteria on the left to query on discrepancies You can double click items statements banks accounts etc to view all discrepancies for the selected item Right click on a statement for the options to Reprocess or View a Statement 3 Select Display Results to retrieve the results of the discrepancy query based on the selected criteria Select Clear Criteria to start a new discrepancy query 4 You can sort by any of the columns in the Discrepancy Results 5 You can export and or Auto Resolve individually selected or all discrepancies returned in the query using these options 6 The detail for the selected discrepancy displays in this section Here you can use the tools available for resolving the discrepancy Links are also provided to take you directly to the account or fee structure associated with the discrepancy when applicable 7 4 1 Entering Criteria The Discrepancy Criteria view provides a number of fields which allows you to query discrepancies At the very least you must select a banking entity or operational unit to query upon Criteria Sections Entity Selection Select the banking or operational entities to show only results that relate to these entities At least one entity in this section must be selected to perform a query Discrepancy Type Select the discrepancy types that you want to include in
13. ieee clederowicz chessys P 1 JE dhoagie Creating A User Select the drop down menu from The Users View Select the New item then select the User item thoward xi User Information Qew Liger User Information User Name thoward Password Confirm Password Email Address C Account Disabled 2 The New User Editor Complete the form Username password and the confirmation password are required It is recommended that the email address be provided as well 3 Save the editor Note that the username will become read only once the user is saved Editing a User Users os f e T bsmith Mew chaderowicz chess s ce Edit dhoagie Isixpaq 62 Remove jyizzle lynchi a Refresh FE E rboswell Selecting a User Select a user from The Users View Double click the user to open the editor User Information User Mame Password Hkk Confirm Password Ekk Email 4ddress nlynch someco com C Account Disabled The User Editor Complete the form Username password and the confirmation password are required It is recommended that the email address be provided as well The account status active or inactive can be toggled by selecting the checkbox next to Account Disabled If the account is currently disabled the form checkbox will already be selected and should be unselected to reactivate the user 3 Save the editor 13 5 3 Why Users Cannot Be Deleted User Accounts are used to audit many actio
14. 01 00 10 Interest Bearing Account Maintenance 01 00 20 Zero Balance Account Maintenance Master 01 00 21 Zero Balance Account Maintenance Sub Accour 01 00 22 Zero Balance Account Maintenance Bundled iw 01 07 40 General Arront Arhiwiku Mehik Poekina 4 iili gt Services By Month Report Summary Sample Step 2 3 Check Show Summary Charges Summary Charge Level Selection Show Summary Charges Services By Month Report Summary Sample Step 3 4 Execute the report Results The results display Relationship level service charges matching the comparison code selected Services By Month Baa oF Ergad bed Sea ue AL ae ea See EEE EEM ADT TEH Aa Ei H 00 Geewed Depot Acar bere tiD ix 468 Enwp Toon to RELATOR BAR eee iR Teg Ta or Berk o gare A ap as Bant F ampie CSO EELA TIRa SRE ENTIN meas fs uy SOSA Ge ACCT MANT r 00 GO eee Dee Acree bET i on abo Hi atga r niir a ADOT ba EE Di 30 66 Seanad Denai seri Lire fs to 216 50 uae Tae or ALA oe Be he eee IH DE TAE ty Epi G amema 1 Se i DIF 7E Services By Month Report Summary Sample Results 4 3 9 Signer Status Report The Signer Status Report displays the signers associated with each account This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please co
15. Account to an Operational Unit using drag and drop e Find the account in the Banking Structure View or Unassigned Accounts View that you want to assign to an operational unit e Click on that account and drag it to the operation unit in the Operational Structure View e Click OK on the confirmation dialog that appears 3 13 Unassigned Accounts View The purpose of the Unassigned Accounts View is simply to provide a full list of all accounts and relationships in the system that don t belong to an operational unit These unassigned accounts can be easily assigned to an operational unit using drag and drop See the following section for details Assigning Accounts and Relationships to an Operational Unit 3 14 Signers View The Signers View assigns accounts to signers Signers are associates in your organization that are authorized to approve expenditures for the assigned accounts To open the Signers View select the Signers View option from the View Menu Please note that you must be in the Banking Information Perspective to access the Signers View To view the accounts assigned to a signer click the icon next to the signer s name Aj Signers View x amp 2 a Ses BOE joir Daman af Shawn Kerstetter bn Ls OOOUOS041 80440 IEM CORP CUSTODY CONCENTRATION oo OOO003041 50459 IBM CREDIT LLC CUSTODY CONCENTR lee 00009102589992 IEM CORPORATION JPMORGAN CHASE nea 00009102593820 IEM CORPORATION JPMORGAN CHASE 5 0000910
16. Account THE ABC Company 122231 1488 has been charged a fee of 92 17 wif a per unit fee of 0 3 ond a volume of 7 for serze code 01 01 OD and bank code G2003 According to the SranAnayss negotiated fee setup for this code the charge should have been 2 4 0 3 x 7 0 E2003 gi pi gg DEETS POSTEL OTHER 5 21 OPEN Varanse subtotal fer type O34 Vanianoe pvbtetal for account 4 Discrepancies By Period Report Sample Columns The Discrepancies By Period Report displays data related to discrepancy information 1 2 Bank Code The bank code related to the discrepancy Service Code The service code related to the discrepancy Charge Description The string associated with the codes Variance The calculated discrepancy variance Assigned To The user to whom the discrepancy is assigned Status The status of the discrepancy Ee Asstagned To Discrepancies By Period Report Column Header Grouping The Discrepancies By Period Report groups data in several ways 1 The results are grouped by period 2 Within the period group the results are grouped by bank 3 Within the bank discrepancies are grouped by account 4 Finally the discrepancies are grouped by type Bank Of America 121000358 Dessrepancies for ABC Toys LUC 13339001724 Incorrect Senice Change Oiscrepancers Discrepancies By Period Report Groups Results Data The Discrepancies By Period Report results are displayed in two rows for each discrepancy result The
17. BII Bender Bank Rellonship Manager Corporate Banking 411 885 7756 bhenden ABC com 3 West Coast Account 0700497534 Contact Name Title Deparment Phone Number Alt Phone No Email Alex smith Processing Manager Processing Center asmihgABT cam Contacts By Bank Report Groups 4 3 4 Discrepancies By Period Report The Discrepancies By Period Report displays discrepancy records organized by time period and banking entity Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria e Discrepancy types may be selected to narrow the results to the specified types e Discrepancy statuses may be selected to narrow the results to the specified statuses e A date range can be entered to narrow the results to the specified time period e Variance amounts can be entered to narrow the results to discrepancies that fall within the variance amount range Sam Assignees may be selected to narrow the results to discrepancies assigned to the selected users le A Discrepancies By Period Report is made up of several parts These parts include the column header the groupings and the discrepancy results data Discrepancies By Period Bank Code Sendoe Code Change Oesonation mod dane 01 2005 to June 30 2005 Bank Of Aenerica 121000358 Crcrepammes for ABC Toys LUC 13330017M Incarnrect Senate Chane Oscrepancies Account AB Toys LLC 1s33001724 has been charged a fee of 0 50 wh a
18. Banking Entities or Operational Units Entity Selection Banking Operational i AMSOUTH BANE 062000019 4 Relationships ea 12121 RELATIONSHIP SUMMARY L gt Statements igi Bank OF America 121000358 fi Bank of Chesapeake 012566011 igs Bank of England MO 052000712 i BLUE BOOK OF BANK PRICES 2004 2005 200320000 i COMMERCE BANK 031201360 airs First National Bank 011200371 dip Wachovia 053000219 E QuickFind Entity selection criteria are standardized across the SmartAnalysis application Selecting banking or operational unit entities in the balance query is no different For more information on the behavior of the entity selection section please review the appropriate documentation See Entity Selection for details Date Range Date Range Select Dynamic Range Manually Set Range El Selecting a date range filter will constrain the results to those balances that exist on statements whose dates fall within the date range specified See Dynamic Date Ranges Comparison Codes Comparison Codes 00 00 00 Ledger Balance Average Met A 00 00 01 Ledger Balance Average Positive 00 00 0z Ledger Balance Average Daily Positive 00 00 03 Ledger Balance Average Negative 00 00 04 Ledger Balance Average Daily Negative 00 00 05 Ledger Balance Month End 0000 10 Collected Balance 4verage Net man 11 Callected Ralanre Awerane Procikivees lt gt Selecti
19. Cand Ina 05 00 24 We reole tail Lock 06 05 50 Pawoll Cand Cus 05 00 25 Whole tail Lock 06 99 39 Undefined Fapta 05 00 24 Wihole tail Lack OS TT TT Toal Payrol Car 05 00 30 Electrorec Lock 1 Line item Total 05 00 31 Electronic Lock Save A Changes Cance The Comparison Code Families Dialog 3 Complete the form Family name and description are required Family name is required to be unique 4 If desired assign one or more of the All Available Comparison Codes to the family Comparison Codes are assigned to and removed from Comparison Code Families using dueling tables 5 Click the Save All Changes Button 12 SmartAnalysis RM Effectively organize your complete corporate banking structure with SmartAnalysis RM This module provides immediate reference to detailed account criteria bank established cut off times internal account compliance authority and security as well as specific descriptions connected to each account s functionality With all this information at your finger tips your banking relationships are easily managed in no time at all SmartAnalysis RM eliminates the inefficiency strain on resources and potential for errors inherent in manually managing multiple accounts across multiple banks It also assists with Sarbanes Oxley compliance information that auditors or regulators may request at any time requests that could otherwise burn countless staff hours RM guards against fraud or costly mista
20. Cutoff Times 15 8 1 Transaction Cutoff Time Types 15 9 Entity Selection 16 Closing The Application 1 Perspectives A perspective is a visual container for a set of Views and Editors that represent a logical function of the SmartAnalysis application There are several perspectives in SmartAnalysis each of which is designed to perform a different application function Examples of perspectives include the Executive Summary Perspective Banking Information Perspective and Report Manager Perspective Navigating between these perspectives is done using the Perspective Toolbar Each button on the toolbar represents a different perspective Clicking on these buttons selects the specified perspective The currently selected perspective is highlighted in the perspective toolbar 2 Views A view is a viSual construct used to navigate examine or select hierarchical data For example the Banking Structure View allows users to explore the hierarchical association of banks relationships detail accounts and statements Views can be used to effectively display the structure of data allowing selection of elements for use in other portions of the application Views may also be used to provide selected data as criteria for different types of queries Finally some views support drag and drop allowing the user to quickly change the structure of the data Unlike Editors views do not have a manual process for saving so any changes made via drag and drop are immedi
21. Days in Year Reseve Requirement Rate Demand Deposit Accounts 75 00 DDA Rates Balance Information Balance information is displayed for both Relationship and Detail Account levels Balance data includes the industry code and description the balance amount and the reference date for the balance group Service Code Description Amount Jaat 12 00 AM 02 00 00 Ledger Balance Average Net 341 283 50 00 03 s0 semite Changes Debited 10 253 00 02 00 10 Collected Balance Average Net 221 393 51 DO 00 11 Collected Balance Average Positive 321 393 61 DO tht 20 Demand Deposk Account Balance Reserse Requirement a2 135 95 02 00 40 investable Balance 289 250 65 00 O4 00 Balance Equivalent Total Service Charge 6 293 305 36 00 O4 12 Excess Detch Collected Balance 6 004 054 71 00 02 40 Eamings Allowance 497 32 DO 03 31 semite Changes Balance Compensable 714 087 45 00 02 44 Excess Deck Earnings Allowance Adjusted 13 535 16 02 00 07 Ledger Balance Average Positive 241 283 50 00 00 30 Float Balance Average 79 899 89 02 03 OO semite Changes Total Current Period 14 087 49 00 02 47 Deficit Eamings Allowance Due Ths Statement 13 596 16 DO 03 14 Semice Changes Net Due Thie Statement 13 596 16 00 02 41 Excess Deck Earnings Allowance 13 535 16 Balances Service Charge Information Service Charge data is shown on the statement at both the Relationship and Detail Account levels Service Charge information includes the Incoming Bank
22. Elements available for display on the Executive Summary Perspective To change the dashboard elements displayed follow these steps 1 Select the Modify Dashboard Elements icon from the Executive Summary Perspective toolbar ie 2 Select the desired dashboard elements from the drop down menus Please note that the layout of this screen changes to reflect the current layout 2 Executive Summary Element Selection Legs Elements O m Smal Elema oo mae Total Charges By Bank Prevecus Month Top Deectepances By Vananoe All Time Small E lenient Top Unit Rate Service Charges Previous Month Lange Element Small Element Overall Changes Previous 12 Monthes Top Total Cost Serice Charges Previous Month x Small Element Top Volume Service Charges Previous Month g Save All Changes Carcel 3 Select the Save All Changes button 4 The system will reload the Executive Summary Perspective Please note that this may take a few seconds depending on the size of your database 3 Banking Information Perspective Keeping track of the bank setup is an important part of using SmartAnalysis A well maintained bank setup allows SmartAnalysis to produce the most consistently accurate evaluations of bank fee information All bank setup information can be viewed and edited using Banking Information Perspective which you can access at any time from the Perspective Toolbar d Banking Information
23. Header Rate Information Balance Information Service Charge Information Entity Header The entity header includes general information about the statement including date contact and bank data Contacts if present are displayed in a table below the header Statement Entity Hank of Chesapeake 012566011 Name Type Email Phone Number Fax Number WN Informational 4154539572 dose iguana Informatora 4157057158 Entity Header Relationships One or more Relationships may be present inside each entity The Relationship header is smaller and contains only the identity information for the Relationship Below the Relationship header is the relationship summary balance rate and service charge data Relatonship Relatonship Account Information RELATIONSHIP SUMMARY 0700497535 Relationship Header Detail Accounts Within the Relationship information any number of Detail Accounts may be displayed Detail Account information is displayed identically to Relationship information Detail information for the balance rate and service charge data is listed below the header Detail Account Account information Weel Coast Account 0700497534 Detail Account Header Rate Information Rate data is present under both the Relationship and Detail Account levels Rate data includes the rate industry code the rate amount the rate multiplier and informational period information Description Fate Muli pier Days In Period
24. Permits the user to modify existing user information Assign Authorities Groups to User Permits the user to add authority and authority group assignments to users Remove Authorities Groups from User Permits the user to remove authority and authority group assignments from users Create Authority Group Permits the user to create additional authority groups Edit Authority Group Permits the user to edit existing authority groups Delete Authority Group Permits the user to delete authority groups Assign Authorities to Group Permits the user to add new authorities to existing authority groups Remove Authorities from a Group Permits the user to remove authorities from existing authority groups 13 2 1 Authority Groups Authority Groups are collections of different SmartAnalysis Security Authorities The Authority Groups are used to organize the assignment of SmartAnalysis Security Authorities in a more aggregate way Authority Groups are listed in The AuthorityGroups View 13 3 Users Users in the SmartAnalysis system represent the people who use the SmartAnalysis application Each individual who uses SmartAnalysis should have his or her own user Please see Managing Users for more information on administering users within the application 13 4 The Security Manager Perspective The Security Manager Perspective can be accessed at any time for those with permission by clicking the Security Manager button of the Perspective Toolbar
25. S3300T H has been charped 2 fee of 4 02 witht a per unit fee of LI ane a volume of 13 for service code 01 07 00 and bana eode 22002 According to the SmartAnalsis negotiated fre setup for ihm code fhe charge should have been 4 4 10 3 12 0 amo 0101 a DESITS POSTED OTHER 2echessys OPEN Varianoe subtotal for acoourt 3 0g Cicrepances for ASC Toys LLC 1333700308 bay 01 2005 to May 31 2005 Account ABC Toya LLC 1333702505 ha been charged a fee of 318 00 with a per uni fee of 16 0 and a voluma of 1 for tenno code 01 00 00 and bank zde O01000 According to the Smartknalpsn negotiated fee taip for the code he Charge should have beer 10 0 10 0 x 1 9 alaj ina 0100 00 ACCOUNT MAINTENANCE 00 OPEN Variance subicial for coourl 5 00 Discrepancies By Period Report Sample Columns The Discrepancies By Period Report displays data related to discrepancy information 1 Bank Code The bank code related to the discrepancy 2 Service Code The service code related to the discrepancy 3 Charge Description The string associated with the codes 4 Variance The calculated discrepancy variance 5 Assigned To The user to whom the discrepancy is assigned 6 Status The status of the discrepancy Bank Code Jemie Code Charge Oesoniption Vance Asugned To Discrepancies By Period Report Column Header Grouping The Discrepancies By Period Report groups data in several ways 1 The results are grouped by type 2 Within the type group the resul
26. Tolerance Information Account level tolerance information fields are used to define the bounds for different calculations in SmartAnalysis Tolerances Discrepancy Tolerance t Charge Change Tolerance 4 Volume Tolerance 2 Tolerance Information Fields e Discrepancy Tolerance Highest amount discrepancies can be before being identified as a discrepancy This value is overridden if a negotiated fee also has a Discrepancy Tolerance e Charge Change Tolerance Percent fees in this account can vary month to month before being identified as a discrepancy This value is overridden if a negotiated fee also has a Charge Change Tolerance e Volume Tolerance Percent the expected volume for fees in this account can deviate before being identified as a discrepancy This value is overridden if a negotiated fee also has a Volume Tolerance 3 9 1 3 Additional Information The additional information section contains the general ledger account id the tax identification number and account opening and closing dates Additional Information Tax Identification Humber 140 559 9997 Account Opening Date 08 01 2002 Account Closing Date GIL Account ID 445 5009 Additional Information 3 9 1 4 Specialized Information This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales ass
27. a RELAPORGHIF SUHAR M BiA income Beita chari COIR DERGE Honi Sh Bt ur Se Te ag atte et ALL ANOWI4P DHAR in leon izer hey Baie ASE ees af a fy Bate OF Aree Callie 121000 RELATES EPRAFT itl 2 barret Savon Clee ORSON prL i gt Raline BELATIONG GUSMART oO T4 becrrect wives Change CURAIC Ody GEFEHLT e TOG BOUT Lae See BELATIORSMEP PURAF 0 Mnet Sna Chae CUREAT OE DPA TA ee OG Cea ee Samay BELATRORGHIP fear in Peer Sei ice ag CON CT ee TD eT a l CAR PELAT oA Sy GELA GRR BHP SuPer U Doare Sat at gm i Cope o T LA SELANOREHIP SUAPAN ii eoat server Charge Cue Oo DOP Te THE W CAPE cies Poienii Damai Ascot me Ga SS Ce Ep OL a Src Tobal Cau 44 tiered Count A ai A f Date of higa L L i Discrepan cy Cietalls Hi Rate of Eregiered HE EL A CoP Gee ee ea F aam breorrert yra Lhe Vern A few hor dere ON Bari Cader izim Amedeo Ul j Trais Dai Hee ER ika rh m ren pangs Decii OCH GPC Me TE ee Account BELATIOAGr iiini renner a Coole eam Peas i n Airi Cental Pinis p DA ra i d Ps a Freie E Dipi as Arri hanna Appr TE AS eee Eee Cepa i HET ee pee pee feed fee 0 eth g pear ur Leng Cred Eric bem ai 4 aed eee of i ee Seed erie A cron bo the hee ttre Berens Chel Sanu Erna reat Vee eta fie ke ee he Oe el Pee be Tr a kerari Reseed Bate Serect Gerace Lhorge dno Tota Depry Lisni bebo Copia ais brs chen eae pe A a T Tipe Cmimi fare A rai aal bi Seer al OE ose jin eee ee A
28. calculated date range is from September 1 2005 through September 30 2005 inclusive Previous Quarter This is a date range spanning the entirety of the previous quarter For example if the current date is October 18 2005 the calculated date range is from July 1 2005 through September 30 2005 inclusive Previous Year This is a date range spanning the entirety of the previous year For example if the current date is October 18 2005 the calculated date range is from January 1 2004 through December 31 2004 inclusive 15 5 Number Entry Number entry fields are devised to accept either decimal or integer values Depending on the intention of the field integer decimal etc the input will be constrained to include only the appropriate characters numbers decimal points commas etc Inappropriate characters such as letters empty spaces and most punctuation will be ignored 15 6 URL Entry Some editors allow for the entry of URLS URLS must be fully qualified and begin with http www Once a URL is entered the link becomes active and may be user to access the specified side by holding down the CTRL key while clicking the URL with the left mouse button CTRL click Website http aia Chessys com ctrl click to oper browser arnings Credit Entering a URL 15 7 Tables Tables are an important element in the SmartAnalysis user interface There are four types of tables present in the application read only
29. changes in the currently active editor Import Statement Opens the Statement Import Wizard See Importing 822 Files using the Wizard Export GL Data Opens the save file dialog to save the generated General Ledger Export spreadsheet Exit Closes SmartAnalysis 4 2 Edit Menu The Edit Menu provides access to common configuration dialogs such as Comparison Codes and Comparison Code Families The functions available on the Edit Menu are explained below 2 Smart Analysis File Edit View Window Help Comparison Codes Comparison Code Families Contact Types Sistem Parameters Users T The Edit Menu Comparison Codes Opens the Comparison Codes dialog allowing you to add or edit Comparison Codes Comparison Code Families Opens the Comparison Code Families dialog allowing you to add or edit Comparison Code Families Contact Types Opens the Contact Types dialog allowing you to add or edit Contact Types System Parameters Opens the System Parameters dialog allowing you to add or edit System Parameters Users Opens the Users dialog allowing you to add or edit Users 4 3 View Menu The View Menu contains a list of the Views available for the current perspective Many perspectives require only the default Stand Alone View but some such as Banking Information Perspective support several views The contents of the View Menu are specific to each perspective and will vary according to the currently active perspective
30. descend AG Click the title of each column to invoke the sort Clicking the column again will reverse the sort Summary Info Balance Counk 11 The total number of balances returned is displayed at the bottom of the interface Exporting 1 CSV Export All Balances Export er Pelati CSY Export Selected Balances it o Oee000019 Cor AMSOO O62000019 COF ome AMSA NEFNDA ne The Balance Query results may be export to CSV comma separated values To export balance query results select the export option from the drop down menu To export all results select the CSV Export All Balances menu option To export only those results that are selected click the CSV Export Selected Balances menu option 10 Comparison Codes The ability to compare balances and service charges across banks is a central feature of SmartAnalysis that establishes it as more than just a simple statement verification tool While a standard set of codes that identifies balances and service charges does exist not all banks use these codes on their statements and among those that do there is unfortunately no consensus about their application In addition earlier versions of the 822 EDI account analysis specification used a completely different code set This heterogeneous environment clearly complicates the comparison of balances and service charges across banks While the combination of incoming bank code incoming service co
31. e Operational Structure The operational structure view displays which operational unit to which this account is assigned 3 6 1 2 Tolerance Information Account level tolerance information fields are used to define the bounds for different calculations in SmartAnalysis Tolerances Discrepancy Tolerance t Charge Change Tolerance 4 Volume Tolerance 2 Tolerance Information Fields e Discrepancy Tolerance Highest amount discrepancies can be before being identified as a discrepancy This value is overridden if a negotiated fee also has a Discrepancy Tolerance e Charge Change Tolerance Percent fees in this account can vary month to month before being identified as a discrepancy This value is overridden if a negotiated fee also has a Charge Change Tolerance e Volume Tolerance Percent the expected volume for fees in this account can deviate before being identified as a discrepancy This value is overridden if a negotiated fee also has a Volume Tolerance 3 6 1 3 Additional Information The additional information section contains the general ledger account ID the tax identification number and account opening and closing dates Additional Information Tax Identification Number 140 555 9997 Account Opening Date 08 01 2002 Account Closing Date G L Account ID 445 8509 Additional Information 3 6 2 Negotiated Fees Tab The Negotiated Fees Tab of the relationship editor contains information for the expected fees
32. finalized
33. for the client software 5 Context Menus Context menus are available throughout the application and can be accessed by right clicking on a particular item Generally the contents of the context menu are specific to the item upon which the menu is selected This means that the context menu options for one item may differ from those of a different item This customized functionality increases the ease of using the SmartAnalysis application 6 Toolbars Toolbars provide one click access to common functions Several toolbars are generally visible in SmartAnalysis These toolbars include the perspective toolbar the general application toolbar and the view specific toolbar 6 1 Perspective Toolbar The Perspective Toolbar exists at the top of the user interface beneath the menu bar and to the right of the General Application Toolbar The Perspective Toolbar lists all available perspectives Each perspective is shown using an icon and a descriptive name Left clicking one of these buttons shows the selected perspective Once selected the button remains depressed as an indication of which perspective has been selected fot Banking Information o Fee Quey o Balance Query q gt Discrepancy Query o Repot Manager C Executive Summary The Perspective Toolbar indicating that Banking Information Perspective is currently active 6 2 General Application Toolbar The general application toolbar is located on the upper left hand side of the application wind
34. made The record of changes made includes the field title in which the change occurred as well as the value of the field before and after the change These audit entries are stored in a tree format at the bottom of the negotiated fee interface Expand the section title to view the change history Scroll through the changes using the scroll arrows at the right of the section Change History Updated on Tha Nov 3 2005 at 08 44 39 by chessys Incoming Service Tode changed trom 01 04 00 to 02 04 01 F Change History 3 6 3 The Relationship Editor Contacts Tab Detailed contact information for relationship representatives is entered on the Contacts tab of the Relationship Editor located in the bottom left of the interface M RELATIONSHIP SUMMARY 0700437535 L mens BEL a Contacts RELATIONSHIP SUMMARY 070049755 a lame Tithe Email De Phone Number Fall Benger Bank Relonship Manager bhenten SES com Coparate Banking 411 635 7756 t gt Add Delete Primary Dnfornmathon Address Informathon Hae Adress Tile Email Ciy Department State Prane Humb r Zin l Bt Phone Humber Country Fay Humber Nobile Hurk Spetiakized Information Cortact Type Notice Required General Information Negottated Fees Contacts GLExport The Relationship Editor Contacts Tab Contact information is entered Using Selectable Tables 3 6 3 1 Primary Information The Primary Information includes the name title department email
35. o Fee Query o Balance Query i Discrepancy Query gt Report Manager Executive Summary Banking Information Perspective 3 1 Banking Structure View The Banking Structure View contains the hierarchical information about a bank and the relationships accounts and statements that belong to that bank To view statements and accounts for each bank expand the tree by clicking the buttons to the left side of the name of the bank Under each bank are folders containing statements and relationship accounts The tree may be expanded to review the relationships and the accounts that belong to each relationship Banking Structure ae st i alis E 01015558 RELATIONSHIP SUMMARY lS 020255168 Johnny Software Ine Pi m fa statements Banking Structure View The Banking Structure View is the primary means of navigating and browsing your bank setup information 3 2 Creating A Bank It is possible to manually enter your bank setup information This is often a good idea to ensure that the information in your bank setup is accurate and reflects your current understanding of your relationship with the bank The first step in setting up your banking information is creating the bank To create a bank select the drop down menu from the Banking Structure View and select New gt Bank Banking Structure JJ Wachovia coa000zts uis Bank 10100 RELATIONSHI i F bi i Bank du Shawn 665598774 Creating A Ban
36. of reports and to identify those reports which are most useful to our customers We are very interested in hearing more about your experiences using the current reports and about your requirements for any new reports that we have not yet included Coming Soon The following is an overview of new features that the SmartAnalysis Team is actively investigating adding to subsequent releases What If Comparisons We are planning to build an intuitive flexible easy to use yet very powerful tool for investigating various what if scenarios We are hoping it will quickly and accurately provide you with understandable answers to questions like e What if I transfer these accounts to a different banking relationship e What if I negotiate a better price for these services e What if I negotiate an across the board percent reduction for these services e What if my volumes were to increase over time We are of course very interested in the sorts of what if questions you routinely ask and would like to be included in our upcoming module Support for International Banking Compensation Initiative Statements Recently a first draft of an international standard for bank compensation analysis statements was submitted for review by TWIST At Chesapeake System Solutions Inc we are keeping a close eye on this development in fact we have been involved throughout the development of this new specification and plan to fully support it as soon as it is
37. per uni fee of 0 2 and a volume of 2 for sense code 01 01 M and bank code GIW According to ite SmanAnaiyes negotiated e setup tor this code the change should have been 0 5 0 2 x 2 0 E2004 pidigi CRHEDMS POSTED OTHER 0 02 cha syrs OPEN Aesount ABC Toys LUC 1333001724 has been charged a fee of 2 05 wih a per one fee of 0 3 and a volume of 13 for service code D1 01 00 and bank code E2003 According to ihe SmartAnajyss negotiated fee setup for this code the change should have been 4 4 0 3 130 E2003 01 O7 06 EHTS POSTELOTHER 0 29 chessys DPEN Vanance sutta for type l 57 Vananoe subtotal for acoount TET Dscepances for ABC Toys LLC 133m0 Potentially Donam Account Desonepancers Onty 2 senice changeis is are being levied on accoum ABC Toys LLC 1333702305 This account may be unused review for prenia coring checsys OPEN Varianog subtotal for type 0 00 Variance subtotal for account 0 00 Discrepancies for THE ABC Company AP Account 12227108874 Incorrect Senie Change Orocrepancies Account THE ABC Company 1222 108874 has been charged a fee of 6 00 with a per unit fee of 0 2 and a volume of 24 for service code OT O01 0 and bunk code EAA Apandi i me HTAA a nepatmied ee eup for this code the charge should have been 5 2 0 2 24 0 e004 ti dii CREDITS POSTED OTHER 0 34 OPEN Varlanoe subtotal for type 0 24 Vanance subtotal for account 0 4 Ceserepancies for THE ABC Gompany 1222511466 Incorrest Senace Change Discrepancies
38. records for both relationships are returned Entity Selection Banking Operational l Er a Bank OF America 121000358 i a Se IS Statements 2e 10 01 2005 10 31 2005 F gt 09 01 2005 09 30 2005 PS 08 01 2005 08 30 2005 OF 01 2005 07 31 2005 06 01 2005 06 30 2005 Pin JA 05 01 2005 05 31 2005 ri pank of Chesapeake 012566011 Relationships 0700497535 RELATIONSH H Statements H A Bank of Enoland MD 052000212 iv ra Wil gt QuickFind e Description Several accounts are selected Expectation The records for each selected account are returned Entity Selection Banking Operational E Corporate P LS 41705459 THE ABC Company 12121 RELATIONSHIP SUMMA 5a area Structure ed Yo629050 RELATIONSHIP a District 1 LE 1481850 NY Centers E 2030906 NH Centers G5 3326085 DE Centers L5 4102612 CT Centers f C5 4112749 MA Centers i C5 4159983 RI Centers F District 2 Ly 5967702 MJ Centers 1 bm 5967717 PA Centers M a Ea QuickFind e Description The root node of the operational structure is selected Expectation The records for every account and relationship assigned to any operational unit below the root are returned Entity Selection Panna Operational E Corporate 41705459 THE ABC Company TAM 12121 RELATIONSHIP SUMMARY Area Structure Tage Region Bo Retail t gt QuickFind e Description An Op
39. relationship level balances are returned by the report they are sorted to the bottom of detail group July 01 2008 00 00 10 O7 DISET TJ Vissi Coas Account 217 515 39 00 00 70 BOBOOOT 164 East Coast docount 0 00 00 00 10 OF DO4eT Sas RELATIONSHIP SUMMARY 217 515 80 August 01 2005 00 00 10 OF DO4e7 EH Wiest Coast Account 242 180 4 00 00 10 S080007 154 East Coast Account 0 00 00 00 1D OHE S35 RELATIONSHIP SUMMARY a4 180 64 Balances by Type Report Detail 4 3 3 Contacts By Bank Report Contacts By Bank Report provides a listing of the contacts for each level of the bank setup grouped by bank Contacts are shown for each level bank relationship and account they are available This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate Report Criteria e A bank or set of banks may be selected to narrow the results to the specified banks If no selection is made the report includes all banks Sample A Contacts By Bank Report is made up of several parts Contacts at each level of the bank setup are represented in the results Contacts By Bank Bank of Chesapeake 012566011 Contact Name THe Degatment Phone Number AR Phone No Emad Jam Wet ILA Begong VF Regana Accown dig TTEA Moc oots com Contact Name TH Department Phone Number AL Phone No
40. rows include the following information Bank Information The bank name and ABA number for the bank associated with the charge Account Information The account name and number for the account associated with the charge Statement Date The date of the statement that the charge was drawn from Charge Unit Price The unit price of the service charge Charge Volume The volume of the service charge Cost vs Sample The absolute percentage of difference between the Sample unit price and the compared unit price 0 means the amounts are the same 50 means the compared charge is half the price of the sample and 100 means the compared charge is twice the price of the sample Cost vs Sample The absolute difference between the unit price of the Sample charge and the compared charge in dollars Senice Change Comparison For 01 00 00 Demand Deposit Account Maintenance Elri HLE LTE Linc Pr Fii National Bank 011200121 EAPO a arosto RELATONSHIF SUMMARY oT Te ithania ese DICCON MA PELE n FELATIONSHIP SUMMAS y Wi fia DEO i E DIDOL HA iiig RELATIJMSHIF SUMMARY igh FELATONSAF SUMMARY i ii kg oh 7i Bark Of Amera CATONA EPPEN Ba ek 8 Bark Of America 121000285 74 20S 8 26 11 69 Sample Comparison Results 9 Balance Query Perspective The balance query provides an ad hoc capability to display account balances The balances displayed may be easily constrained by selecting relevant crit
41. statement data This process should resolve existing discrepancies where the changes have been made NOTE Reprocessing a statement will close all existing discrepancies that have audit trails Any others will be deleted e Reprocessing vs deleting statements amp re importing o You should Reprocess a statement any time changes have been made to the statement data or bank setup data that will affect the current discrepancies for a statement o You should Delete a statement any time the bank provides a new statement that has corrections made and re import the new statement Only one monthly statement per bank can be imported in SmartAnalysis Produce and review reports Proceed to the Reports section to produce and review reports 7 2 Types of Discrepancies Types of Discrepancies supported by SmartAnalysis e Account Closed e Account Detail Missing e Ambiguous Service Charge e Duplicate Account e Earnings Credit Calculation Error e Earnings Credit Error e Earnings Credit Setup Error e Incorrect Reserve Rate e Incorrect Service Charge e Incorrect Total Service Charge e Incorrect Total Service Charge Summary e Incorrect Volume e Missing Account e Missing Charge Information e Missing Reserve Rate e Missing Total Service Charge e Multiple Service Charges e Potentially Dormant Account e Unassigned Account in Operational Structure e Unassigned Relationship in Operational Structure e Unexpected Service e Unknown
42. the contact s address information Address Information Address City State Ip Country Address Information 3 9 3 3 Specialized Information Contacts have two forms of Specialized Information Contact Types and Notice Required Contact Types provide a way to organize the bank representatives into categories These categories are entirely arbitrary and are defined by SmartAnalysis users Notice Required indicates the number of days Same day 1 day or 2 day notice that the contact requires before a change to the banking relationship can be effected 3 9 4 Detail Account Editor Signer Assignment This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate Reviewing detail account signers eta General Information Wegotiated Fees Contacts Signers GLExport Bank Confirmations Detail Account Editor Signer Assignment Click the signer assignments tab at the bottom left side of the user interface The Signer assignment screen consists of two tables The table on the left shows all signers currently unassigned to the account The table on the right shows the signers currently active on the account C West Coast Account 0700497534 i ry signer Assignment West Coast Account 0700497534 All Available Selected Name Tle SL Email _ Department N
43. to edit settings which affect every user of the SmartAnalysis application Edit Comparison Codes Families Permits the user to edit the comparison code families within the SmartAnalysis system This is a powerful authority permitting the user to edit settings which affect every user of the SmartAnalysis application Edit Contact Types Permits the user to edit the contact types within the SmartAnalysis system This is a powerful authority permitting the user to edit settings which affect every user of the SmartAnalysis application Edit System Parameters Permits the user to edit the system parameters within the SmartAnalysis system This is a powerful authority permitting the user to edit settings which affect every user of the SmartAnalysis application Access Fee Query Permits the user to access the Fee Query perspective and to execute fee query operations within that perspective Change Columns in Fee Query results Permits the user to alter the columns within the Fee Query results thus modifying the data viewable within those results Compare charges in Fee Query results Permits the user to execute the charge comparison within the Fee Query results Export results from Fee Query Permits the user to export data from within the fee query Access Balance Query Permits the user to access and execute the Balance Query Export results from Balance Query Permits the user to export results from the Balance Query Access Discrepancy Query Permits th
44. to review and examine the unassigned accounts Add Operational Unit Permits the user to add a new operational unit to the operational structure Edit Operational Unit Permits the user to modify existing operational units within the operational structure Delete Operational Unit Permits the user to delete existing operational units This is a particularly powerful authority and should only be granted with caution Remove Account from Operational Unit Permits the user to remove or unassign an account from an operational unit Assign account to Operational Unit Permits the user to assign an account to a particular operational unit View Signers Permits the user to view the signers that exist within the SmartAnalysis RM system Create Signer Permits the user create new signers within the SmartAnalysis RM system Edit Signer Permits the user the edit signers within the SmartAnalysis Signer Editor Delete Signer Permits the user to delete signers within the SmartAnalysis RM module This is a particularly powerful authority and should only be granted with caution Assign account to Signer Permits the user to assign a signer to particular account within the SmartAnalysis RM module Remove account from Signer Permits the user to remove a signer from a particular account within the SmartAnalysis RM module Edit Comparison Codes Permits the user to edit the comparison codes within the SmartAnalysis system This is a powerful authority permitting the user
45. which the change occurred as well as the value of the field before and after the change These audit entries are stored in a tree format at the bottom of the negotiated fee interface Expand the section title to view the change history Scroll through the changes using the scroll arrows at the right of the section Change History Incoming Service Code changed from 01 04 00 to Of 04 01 we Change History 3 9 3 The Detail Account Editor Contacts Tab Detailed contact information for detail account representatives is entered on the Contacts tab of the Detail Account Editor located in the bottom left of the interface gt General Information Negotiated Fees Contacts Signers GLExport Bank Confirmations The Detail Account Editor Contacts Tab Select the contacts tab from the list of available tabs at the lower left side of the editor interface Contact information is entered Using Selectable Tables 3 9 3 1 Primary Information The Primary Information includes the name title department email and phone numbers of the account representative of these at least one of name email phone or fax number are required Primary Information Mame Calvin Hobbes Tithe Account Representative Email chobbestusbank com Department Customer Service Phone Number 800 555 9755 Alt Phone Number Fas Number Mobile Number Primary Information 3 9 3 2 Address Information The Detail Account Editor Contact Tab also provides an area to enter
46. you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria Example Summary section The Overall Account Status Report provides a summary section that displays the bank setup structure for each bank reported upon Additionally all signers present on accounts in the bank are displayed Overall Account Status Report Summary infomation for Bank of Chesapeake 012566011 RELATIONSHIP SUMMARY 0700497535 Detad Accounts West Coast Account O 0U49 534 East Coast Account 9080007 164 limt Jason ankut Treasury Mansger Manua 166 ia mabi Sth GFO Focurile 500 900 00 Sawey Gikmars Saat Treesuee Maria EICO Total Number of Segrers 3 Overall Account Status Report Summary Detail Section The detail section of the Overall Account Status Report contains information for each detail account returned by the report The data returned for each detail account contains TIN EIN Number The tax identification number for the account Can be entered or modified on the Detail Account Editor in the Additional Information section Opening Date The date upon which the account was opened Can be entered or modified on the Detail Account Editor in the Additional Information section Closing Date The date
47. 1 2005 06 30 2005 F gt 05 01 2005 05 31 2005 a ii Bank of Chesapeake 012566011 Relationships fe 0700497539 RELATIONSHIP FFL statements IM ES gt QuickFind e Description A Relationship and one of its DetailAccounts are Selected Expectation The records for both the Relationship and DetailAccount are returned Entity Selection Banking Operational igi AMSOUTH BANE 062000019 a ii Bank OF America 121000358 Relationships iA 0693999999 RELATIONSHIP E 1222014921 THE ABC Cor 1222106074 THE ABC Cor 1222110371 THE ABC Cor e 15462 THE ABC Cor 1227126896 THE ABC Cor 1222205411 THE ABC Cor 1422205577 THE ABC Cor 1222205614 THE ABC Cor j 1222211191 THE SBC Cor s 1222511406 THE AB com QuickFind VN E Description Detail Account and unrelated Relationship are Selected Expectation The records for both the Relationship and DetailAccount are returned Entity Selection Banking Operational EI i Bank OF America 121000858 a 2 gt Ss S Statements os 1Of01 2005 10 31 2005 be Pn 09 01 2005 09 30 2005 J gt 08 01 2005 08 30 2005 st OF 01 2005 oF 31 2005 oe i 06 01 2005 06 30 2005 ihe Fn 05 01 2005 05 31 2005 i Banik of Chesapeake 012566011 H Relationships H EA 0700497539 RELA TIONSH E5 0700497534 West Coi LES 9080007164 East Coats QuickFind Description Two unrelated relationships are selected Expectation The
48. 10 fed 1 HIG o om FE Lop on AMESUTH BGK GbSRGROEG Corporebe py Bane Of Amaga 170a rst ODE l MPSD EH fin 46 00 ATG SUTH EAR Deis Conporshe F bee st esaesa bee fe E io nis fargo o 00 4 00 0 00 APGSUEH Gite Dib Gipo sa r Dark cf Erg FD FIO GOBE2 1D 01 1 AULT O O45 Te TRESHE AGAN H EARE mormi Corpore gt Jee FLUE Boxcar OF BANK RIFS 3 OORED IG ot 4 WATE 4 00 9608 24 00 ANBOUTHEARK 0670019 Corpornbe as pete rd One WoL 1 VAULT AN TAi ERLO APGOUTHEANE DG2000089 Cepoi CoH Tor E Le Fpl ada y PE UFE m Aei IO OL 44 WAULT O50 3400 are APGQETHEAKK Gai Corporate Se Pick Hashes Rates OLR Ol We MES ORO 0 ANBCUTHEAKK DBA000019 Corporate yy a an ric in ic 3 CES HN AT i ARR TH RARE TW repra Oi 30 fi EM t 2500 LW z0 AMEGUTH Gahi DEEDS Corporsis 7 F k Date Amige H Bank Codes b Service Codes E LAr Desert H Comparten Codes wel eal 2 Chane Sou i Cra Pi i 1444 eee Ohare Gone G Cte aes bot G4 a Oise Giri 6 1 Select the Fee Query toolbar button on the perspective toolbar to switch to the Fee Query Perspective 2 The Fee Query Criteria View is to the left of the interface This view contains many types of criteria used to narrow the results 3 Select Banking Entities from the Entity Selection Section Service charges for the selected entities that match the specified criteria will be returned 4 The Display Results button is used to execute the query Data from the criteria section
49. 1000358 44 Bank of Chesapeake 012566011 C Import Statement H E Relationships P edt Bt 0700497535 RELATIONSHIP SUMMARY 3 o Ls 0700497534 West Coast Account HG Delete s La 060007 164 East Coast Account H E Statements A Account QuickFind Ti Bank of England MD 052000212 Mark Statement Gl Editing a Detail Account 3 9 1 General Information Tab The general information tab is made up of several sections e Identity Information e Tolerance Information e Additional Information e Specialized Information 3 9 1 1 Identity Information The general information section contains information that is used to identify the detail account within the application General Information Name Wiese Coast Account Number 0700497534 Type Disbursement ha Settlement Method Account is automatically debited Operational Structure California Identity Information Fields e Name The account name provides a title for the account e Account Number The account number is the identifier assigned to the account by the bank Account numbers must be unique at the level at which they are defined e Type The account type provides additional customizable categorization of the account e Settlement Method The settlement method indicates the method by which this account performs settlement e Operational Structure The operational structure view displays which operational unit to which this account is assigned 3 9 1 2
50. 2609204 IBM WIRE TRANSFER ACCOUNTS Pays Signers View This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 3 14 1 Creating Signers To create a signer follow these steps 1 Select the Create Signer icon from the toolbar to open the Signer Editor AJ Signers View X A a Da The Signer View Toolbar 2 Complete the form Name is required Please note that the account assignment table is read only E Albert Finklehopper X Se Signer Information lt Albert Finklehoppe Primary Information Specialized Information Mame Albert Finklehopper Lirnit 100 000 00000 Title T Teasuiry Manager signer Type Facsimile Email jatinklehopper frogspace com a Department Treasury Phone Humber 8664455151 Alt Phone Number Fax Number Mobile Number Assignment Details Account Added Date i Removed Date The Signer Editor 3 Save your changes 4 The signer is added to the Signers View which you can use to the assign accounts to the signer 3 14 2 Editing Signers To edit a signer follow these steps 1 Double click the signer in the Signers View or right click the signer and select Edit from the context menu 2 Complete the form in the Signer Editor Name is required Please note that the account assignment
51. 3 57312 Earnings Credit Calculation Error RELATIONSHIP SUMMARY 0693900001 497 50000 Incorrect Total Service Charge Suri RELATIONSHIP SUMMARY 0693900001 497 50000 Incorrect Total Service Charge Sum RELATIONSHIF SUMMARY 0693900001 4 431 79000 Incorrect Total Service Charge Sum THE ABC Company INC 1465502000 175 00000 Incorrect Service Charge THE ABC Company INC 1465502000 175 00000 Incorrect Service Charge THE ABC Company 3751827393 5 11000 Incorrect Service Charge Total Count 87 Selected Count Select All Clear All e or select the drop down list and select CSV Export All Discrepancies Discrepancy Results a ULSI er Let COCR BSSOAOI260 1 155 OSA Aocourk Chesed RELATIONSHIP SUPMARY 0 Actqurk Chped RELATIONSHIP SUPAY 0 6 976 Incorrect Total Service Change Sum RELATIONSHIP SLMPRORY 0 Oa karet Total Service Change ACCOUNT BAL TEMAMCE RELATIONSHIP SLPRAY 0 i incorrect Totel Service Charge BAL TRANSMISSION Hri rE GEY iN am Tarte ee ae i n Py ed 5 E 1 mL ia ha Export Selected Discrepancies e Follow the general selection guidelines to select the discrepancies you want to export e Select CSV Export Selected Discrepancies once all discrepancies have been selected Discrepancy Results om Cte Hel aE 0 es i BSS0CRI02601 155 OSS RELATIONSHIP SLPPARY 0 RELATIONSHIP SUPP
52. 3 SmartAnalysis File Edit view window Help Boo fae Seat co 62 Operational Structure Serta Lo Signers View A Unassigned Accounts The View Menu for Banking Information Perspective 4 4 Window Menu The Window Menu provides functions for managing the current perspective and the open editors The functions available are explained below e window Help Close Ctra Cloze All Chrl Shitt yy Reset Perspective The Window Menu Close Closes the currently active editor Close All Closes all open editors Reset Perspective Resets the active perspective to the default settings This function only has meaning for perspectives that allow changes from the default like the Banking Information Perspective 4 5 Help Menu The Help Menu provides functions for managing the current perspective and the open editors The functions available are en below Help 7 Help Contents Dynamic Help I Search Send Support E mail Enable Sroarb4nalsishh About Smart nalysis The Help Menu Help Contents Opens the SmartAnalysis User Guide in a new window Dynamic Help Opens the context sensitive help entry for the currently active form field in a new editor area Search Opens the help search dialog in a new editor area Send Support Email Opens the SmartAnalysis Support Email Dialog Enable SmartAnalysis RM Opens the Enable SmartAnalysis RM Dialog About SmartAnalysis Displays the build information
53. 3 The Authority Group Editor The Authority Group Editor displays the name and a short description of the authority group The display also shows the authorities assigned to the group r ei Fee Query s o Authority Group Information Fee Query Authority Information Security Authorities in this group User Name Fee Query 3 7 Access Fee Query ii Change Columns in Fee Query results oo E Compare charges in Fee Query results ogy Export results From Fee Query Access to Fee Query Description The Authority Group Editor 14 Volume Confirmation SmartAnalysis supports two kinds of volume confirmation 1 BAI Volume Confirmation Compare volumes imported on 822 statements with BAI transactions imported using the BAI Import Utility 2 T Recs Volume Confirmation Compare volumes imported on 822 statements with transactions imported into T Recs 14 1 BAI Volume Confirmation SmartAnalysis allows you to compare the volumes imported using the BAI Import Utility to the volumes imported on an 822 statement Mismatches will be reported as discrepancies on the 822 statement When a new 822 statement is imported or reprocessed for discrepancies volumes will be confirmed if you have done the following 1 Set the option in General System Parameters to enable BAI Volume Confirmation Set the option to SA BAI Zi Import the full month of BAI files for the same month as the 822 statement you are importing reprocessing using the
54. AY 0 RELATIONSHIP SUMMARY 0 RELATIONSHIP SUPPARY 0 lt w i earar er el ge GF CS Export Selected darepancias ceo Incorrect Total Service Charge Sum Total Service Charge Lin re Bee 7 4 2 2 Auto Resolving Results The discrepancy Auto Resolve option is available for discrepancies that potentially require changes to the bank setup information This option updates the appropriate setup information including service charges tolerance amount and bank setup information to automatically resolve the discrepancy with the click of a button This option is not available for all discrepancies You may select individual discrepancies or all discrepancies for auto resolution The changes are maintained the Change History for each individual discrepancy You should always review the auto resolve actions before selecting this option to ensure the actions taken are accurate For instance you do not want to assume all Unexpected Services should be added to the bank setup some of these may be unauthorized services your bank is charging you After successfully auto resolving discrepancies they will be marked closed You can choose to reprocess the statement to make sure that the discrepancy does not re appear There are few cases in which the discrepancy may show up again since it couldn t truly be resolved In this case you should look closely at the discrepancy details and your bank setup to verify what is causing the dis
55. According te the SmartAnalysis negotiated fee sebup for this code the charge should have Seen S0 00000 Hat fee Change History a Subo Rasove There Is mo hisbory For this discrepancy 7 Add Comment ul Sei J E mall J Insert Attachment Sections e Information Fields e Change History e Links 7 4 3 1 Information Fields Type Provides the type of discrepancy Refer to Understanding Discrepancies section in this chapter for further information on Discrepancy Types Bank Code Provides the bank code for the selected discrepancy Service code Provides the industry service code for the selected discrepancy Charge Description Provides the description of the service charge Deposits etc Date Provides the statement date for which the discrepancy is generated Description Provides the details of the discrepancy generated This typically includes the setup information as well as the data found on the statement Variance Provides the variance between the calculated charge in SmartAnalysis and the actual charge on your bank statement Assigned To Provides the name of the individual responsible for the discrepancy Status Provides the status of the discrepancy which is either open pending or closed Account Provides a direct link to the Account Information window for the account associated with the selected discrepancy Fee Provides a direct link to the Fee Structure window for the fee struct
56. All records for the specified statement will be returned Entity Selection Banking Operational p E zil AMSOUTH BANK 062000019 in ite Bank OF America 121000358 E E Relationships a a Statements T RIEA 08 01 2005 08 30 2005 0710112005 07131 2005 06 01 2005 06 30 2005 05 01 2005 05 31 2005 fre Bank of Chesapeake 012566011 i Bank of England MO 052000212 ay BLUE BOOK OF BANK PRICES 2004 20 HA COMMERCE BANK 031201360 H m 4 ss es Ds bp bp First National Bank 0112003271 Rell Me gt MuickFind e Description A single bank is selected Expectation All records for the specified bank will be returned relationship or account level Entity Selection Banking Operational l o oy A AMSOUTH BANK 062000019 Ead a TRA Statements E 10 01 2005 10 31 2005 Jh 09 01 2005 09 30 2005 i Je 08 01 2005 08 30 2005 07i0l 200S oF 7351 2005 J gt 06 01 2005 06 30 2005 J gt 05 01 2005 05 31 2005 ig Bank of Chesapeake 012566011 Pi Bank of England MD 052000212 ey BLUE BOOK OF BANK PRICES 2004 20 apy COMMERCE BANK 031201360 v i First National Bank 011200321 5 ei QuickFind e Description A single bank and one of its relationships are selected Expectation All records for the relationship will be returned Functionally equivalent to selecting only the relationship Entity Selection eam
57. BAI Import Utility 3 Set the BAI ABA Number for each Bank using the Editing a Bank only if it differs from the Bank s existing ABA Number Make sure to do this even if the only difference is some O s on the front of the number Required Information Name Bank of Chesapeake ABA Mumber 999912545 BAIL ABA Number 00001111 il Reporting Period Calendar Month 1 31 7 Setting the BAI ABA number in the bank editor 4 Open the BAI Transaction Type dialog to ensure that all types you need already exist You can add any new ones using this dialog 5 Set up the mapping between fees and BAI Transaction Types by one of the following two methods 1 Assign BAI Transaction Types to Negotiated Fees For each account that you would like set up for Volume Confirmation open its editor from the Banking Structure View From here select the Negotiated Fees Tab For each negotiated fee that you would like to map to a BAI transaction select it in the table at the top of the screen and then select an item in the BAI Transaction Type select box Once you are done save the editor for each account Identity Information Incoming Bank Code 00 00 99 Incoming Service Code 00 00 99 Incoming Description Test Fee Comparison Code BAT Transaction Type OS TARGET BALANCE DEFICIENCY F Oe TARGET BALANCE DEFICIENCY 1088 TOTAL FUNDING REQUIREMENT Tolerance Informati 100 TOTAL CREDITS 101 TOTAL CREDIT AMO
58. Code the Incoming Service Code the Incoming Description the Unit Fee the Charge Volume and the Total Amount Also displayed is the Price Identifier Below the table of charges a selected series of relevant balances are displayed These balances include the Total Service Charge amount the Earnings Credit Amount and the Net Charge Total amount These balances are drawn from the balances section and are reprinted here for convenience Service Desecration Samice Code Bank Code Unit Fee Valine Total Fee Type ACH RECEIVED CREDIT 25 02 01 ACHOT1 1 00 16 00 18 00 Unit Price x Quantity 1 001TEM CASHIER S CHECKS 7 00 EACH15 05 11 cuso1s 7 00 6 00 42 00 Unit Price x Quantity CHECK SEQUENCE BASE FEE gi 03 20 STROGO 25 00 1 00 25 00 Unit Price x Quantity 25 STATEMENT CHECK SEQUENCE PER ITEM 9793 20 STROGI ni 4 792 00 191 66 Unit Price x Quantity 04 EACH COIN FURNISHED 1NROLL 100044 ROCHOIS 110 81 00 3 10 Untt Price x Quantity COPY OF CHECK OFFICE 36 0045 73 42 TELO 1 6 00 3 00 18 00 Unit Price x Quantity EACH CURRENCY FURNISHED 10 00 48 ROCDOS woa 447 600 00 442 50 Unit Price x Quantity 51 0051000 EAST COAST BASE FEE 13T 4150000 CHO300 225 00 2 00 450 00 Unit Price x Quantity ACCT 225 00 A0C0UNT FAST COAST CHECKS PAID 4150110 CHON 115 3 155 00 47325 List Price WO AR 15 9TEM PHOTOCOPY SERVICE 6 00 451342 ARP 10E 6 00 10 00 60 00 Unit Price x Quantity EACH Total Service Charges 1 726 83 Eamings Credit Amount 0 00 Total Amo
59. Discrepancies RELATIONSHIP SUMPIARY 0700 1 08000 Linknown Total Service Charge PETE ETS ae RELATIONSHIP SUMMARY G700 0 64000 Linknown Total Service Charge FED RES DISTRICT 12 4 06 ITEM West Coast Account 0700497534 0 01055 Earnings Grad Calculation Error meeen e Proceed to select discrepancies on the discrepancy selection screen 7 4 2 2 1 Auto Resolve Wizard The Discrepancy Auto Resolve wizard displays all discrepancies that you have selected to auto resolve Auto Resolve Process 1 Check uncheck the discrepancies you want to auto resolve 2 Verify selected resolution actions Each discrepancy type has different auto resolve options from which you can choose the appropriate resolution You should review each discrepancy before selecting the auto resolve option to ensure that you are not adding data to the bank setup that is not accurate 3 Once you are satisfied with the actions to be performed for each discrepancy click Finish to start the auto resolve process 4 View results Look at the results to view the details of any errors that may have occurred during auto resolution Click on any discrepancy to view the action taken and the result of that action 5 Click Close to return back to Viewing Results The results view will be refreshed based on the query criteria that you previously had selected 7 4 2 2 1 1 Auto Resolve Discrepancy Selection Discrepancy Auto Resolve Select Actions Select the actio
60. Information This displays any contacts included on the statement 6 4 2 4 Information Here you can select to mark the statement as eligible for GL Export If the statement is processed a link will be displayed allowing you quickly view the discrepancies relating to this statement 6 4 3 Account Detail Information This tab allows you to modify information at the relationship and account level in the statement 6 4 3 1 Account Hierarchy Use this hierarchy to select a relationship or account to work with Once you select one the tables at the bottom of the page will be populated with the information for what you selected 6 4 3 1 1 Adding a new Relationship You can add a new Relationship to a statement by right clicking the Entity you want to add it under and selecting Add new Relationship This will create a new relationship in the hierarchy and you can then proceed to update its name and number 6 4 3 1 2 Adding a new Account You can add a new Account by right clicking the Relationship you want to add it under and selecting Add new Account This will create a new account in the hierarchy and you can then proceed to update its name and number 6 4 3 1 3 Deleting a Relationship You can delete a relationship in the statement by right clicking on a relationship and selecting Delete When you delete a relationship for the statement all account information under that relationship will also be deleted Also any discrepancies relat
61. LATIONSHIP SUMMARY 0700497535 General Information Tolerances Name RELATIONSHIP SUMMARY Discrepancy Tolerance E Number OFO0497S35 Charge Change Tolerance Type Main Volume Tolerance 3 Settlement Method amp ccount is automaticaly debited Operational Structure Unassigned Additional Information Tax Identification Number 140 558 9997 Account Opening Date 05 01 2002 EE Account Closing Date afl Account ID 445 Ga89 General Information Negotiated Fees Contacts GLExport General Information Tab 3 6 1 1 Identity Information The general information section contains information that is used to identify the relationship summary within the application General Information Name ELATIONSHIF SUMMARY Number 0700497535 Type Main l Settlement Method Account is automatically debited l Operational Structure Unassigned Identity Information e Name The account name provides a title for the account Relationship Summary accounts must be explicitly named The name must include at least one of the words RELATIONSHIP COMPOSITE or SUMMARY e Account Number The account number is the identifier assigned to the account by the bank Account numbers must be unique at the level at which they are defined e Type The account type provides additional customizable categorization of the account e Settlement Method The settlement method indicates the method by which this account performs settlement
62. Repo 1 ie i NORTHERN TRUST 071000152 i ri TT Ebert s E Fl WELLS FARGO BANK M A 121000248 OMIL Hir F he a es Service Charge Reports al Signer Reports The Saved Report Criteria 4 2 1 1 1 Executing Saved Report Criteria Saved Report Criteria may be executed by double clicking the report criteria in the Report Selection View or by right clicking the report criteria and selecting the Execute option This will generate the report and open the results in the left hand editor pane 4 2 1 1 2 Editing Saved Report Criteria Saved Report Criteria may be edited by right clicking on the report criteria in the Report Selection View and selecting the Edit option from the context menu The Saved Report Criteria will open in a new tab in the left hand editor pane 4 2 1 1 3 Deleting Saved Report Criteria Saved Report Criteria may be deleted by right clicking on the report criteria and selecting Delete from the context menu 4 3 Report Types This section enumerates the purpose and usage of the reports in SmartAnalysis 4 3 1 Overall Account Status Report The Overall Account Status Report gives a complete detail of the current bank setup information for each account The report includes information about the bank and relationship to which the account belongs the account detail information and the signers associated with the account This feature is available as a part of SmartAnalysis RM If
63. Resolution updated Website Additional Information 3 3 1 4 Earnings Credit Information The Earnings Credit Information section of The Bank Editor General Information Tab describes the formula that the bank uses to calculate the earnings credit This description is used during statement processing to verify the earnings credit amount shown own the statement and to produce the Earnings Credit Error Earnings Credit Month Operand Calendar blonth 365 366 in leap year Discrepancy Tolerance 0 01000 select a formulas Average Net Ledger Balance Average Positive Collected Balance Net Positive Collected Balance Details Average Net Ledger Balance Average Float 1 Reserve Requirement Rate Credit Rate Daves in Month Days in Year Earnings Credit Information 3 3 1 4 1 Month Operand The Month Operand defines the formula the bank uses to calculate the fraction of the year the statement month represents SmartAnalysis supports the following month operands Calendar Month 365 366 in leap year The days in the current month 30 31 28 or 29 in leap year will be divided by 365 or 366 in a leap year This is the actual calendar time Calendar Month 365 The days in the current month 30 31 28 or 29 in leap year will be divided by 365 Leap years are ignored 30 360 Each month is treated as 1 12 of the entire year Variations in calendar days per month are ignored 3 3 1 4 2 Discrepancy Tolerance The Discrepancy
64. Sum THE ABC Company 1465101757 127 333 57312 Earnings Credit Calculation Error RELATIONSHIP SUMMARY 0693900001 497 50000 Incorrect Total Service Charge Suri RELATIONSHIP SUMMARY 0693900001 492 50000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900001 451 7 9000 Incorrect Total Service Charge Sum THE ABC Company INC 1465502000 175 00000 Incorrect Service Charge THE ABC Company INC 1465302000 175 00000 Incorrect Service Charge THE ABC Company 3751827393 5 11000 Incorrect Service Charge 4 Total Count 87 Selected Count 0 Select All Clear All Select a single discrepancy in the results to display its information in the Discrepancy Details view e Exporting Results e Auto Resolving Results 7 4 2 1 Exporting Results Once discrepancies are generated you have the option to export this information to a CSV file for further analysis You can choose to export all discrepancies or select individual discrepancies for the export Export All Discrepancies Select the option from the discrepancy results window Discrepancy Results AcCOUNE Varlance Discrepancy Tyoe RELATIONSHIP SUMMARY 0693900000 27 269 76000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900000 27 146 01000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900000 23 434 39000 Incorrect Total Service Charge Sum THE ABC Company 1465101757 127 33
65. The Earnings Credit Monthly Rate Analysis Report displays the earnings credit rate the earnings credit amount the gross service charges and the net service charges for the selected month for the selected banks Report Criteria e The report requires that you use select at least one banking entity e The report requires that you use select a month Sample The Earnings Credit Monthly Rate Analysis Report displays earnings credit related information in a clear and easy to read fashion Monthly Earnings Credit Rate Analysis for September 2005 Bank Of mes Sank of Chesapesks Bank of England MD Whe Tipe arnaga onedil rale valved ae found wiih J Dane aocounts z Rasa Freage of me alee E Seplayed Earnings Credit Monthly Rate Analysis Report Sample Columns The Earnings Credit Monthly Rate Analysis Report display useful earnings credit information in several columns These are 1 Earnings Credit Rate The earnings credit rate percentage from the statement rate data 2 Earnings Credit Amount The earnings credit dollar amount from the statement balance data 3 Gross Charge Total The total dollar amount of the service charges from the statement balance data 4 Net Charge Total The net total amount of service charges once the earnings credit amount is subtracted from the gross charge total Eamings Credit Rate Eamings Credit Amount Gross Charge Total Net Charge Total Earnings Credit Monthly Rate Analysis Report Colu
66. Tite Limit Added Date Removed Date Signer Status Report Columns Groups The Signer Status Report is organized into groups to allow quick interpretation of the signer assignment information These groups are 1 The signers assignments are grouped first by Bank 2 Followed by relationship 3 And by the detail account to which the assignments belong 4 Within the detail account signers are grouped into Inactive 5 and Active sections Bank of Chesapeake 012566011 J RELATIONSHIP SUMMARY 0700497535 4 Inactye Signer nisin Smith CFO 500 000 00 1S T40 AM 6 TDS EM AM c Acie Signer Jason Yankus Treasury Manager 16 000 06 Wega 11 44 AM Monica Rakowski Head Accountant 1 000 000 00 11 05 8 04 AM Signer Status Report Groups 5 System Parameters System Parameters are system wide configuration settings System Parameters control the behavior of the application for all users and allow the SmartAnalysis administrator to configure things such as password security decimal precision and discrepancy processing To access the System Parameters dialog select the System Parameters option from the Edit Menu 5 1 General System Parameters General System Parameters toggle configurable features of the application For example it is possible to disable the Operational Structure Discrepancy by setting the corresponding system parameter to false cig System Parameters x Use BAI statistics for volume discrepancy calculation Enabl
67. Tolerance section of the The Bank Editor General Information Tab sets the threshold for the earnings credit discrepancy If the earnings credit amount reported on the statement varies from the amount calculated by SmartAnalysis by less than the discrepancy tolerance the earnings credit discrepancy for that account will be suppressed For example if the discrepancy tolerance is 1 00 and the calculated variance is only 0 99 SmartAnalysis will not report a discrepancy 3 3 1 4 3 Earnings Credit Formula The Earnings Credit Formula defines the formula the bank uses to calculate the earnings credit amount The following formulas are supported by SmartAnalysis Average Net Ledger Balance Average Net Ledger Balance Average Float 1 Reserve Requirement Rate Earnings Credit Rate Days in Month Days in Year Average Positive Collected Balance Average Positive Collected Balance 1 Reserve Requirement Rate Earnings Credit Rate Days in Month Days in Year Net Positive Collected Balance Net Positive Collected Balance Compensating Balance Earnings Credit Rate Days in Month Days in Year None Select this option if you wish to disable the Earnings Credit Discrepancy for this bank If you wish to globally disable the Earnings Credit Discrepancy see General System Parameters 3 3 1 5 Transaction Cutoff Times Transaction Cutoff Times are a feature of SmartAnalysis RM that record the time of day at which banks stop processing t
68. Total Service Charge e Unusually High Total Service Charge e Unusually High Service Charge 7 2 1 Account Closed Description SmartAnalysis generates this discrepancy when a service charge is found on the statement when the account is marked as closed in bank setup Resolution If this account should not be closed open it in your bank setup and remove the close date 7 2 2 Account Detail Missing Description SmartAnalysis generates this discrepancy when a relationship has no supporting account detail Data in the statement is only provided at the relationship level Without this data SmartAnalysis can not make necessary comparisons between Summary level data and the account detail Resolution Contact the bank to have the 822 file corrected to include the account detail If this is a Manual entered statement you need to enter both the relationship and account level data for the statement 7 2 3 Ambiguous Service Charge Description SmartAnalysis generates this discrepancy when fee structures it is unable to determine which fee structure to verify the current service charges against This may be caused by having duplicate services defined with varying fees in your fee structure setup Resolution Verify the currently defined fee structures are correct You may need to add a new service in cases where multiple services exist with different pricing structures 7 2 4 Duplicate Account Description SmartAnalysis generates this dis
69. UNT MTO Rate Details 105 CREDITS WOT Selecting a BAI Transaction Type for a negotiated fee in the account editor 2 Set up Volume Confirmation Mappings If you have already assigned comparison codes to each negotiated fee you can simply edit volume confirmation mappings from the Edit Menu From here you can map each BAI transaction type to a comparison code Creating BAI Transaction Types To create new BAI Transaction Type follow these steps 1 Select the BAI Transaction Type option from the Edit Menu 2 Select the Add New BAI Transaction Type link Add Edit BAI Transaction Types Select Add a Type Select type to edit Add new BAI Transaction Type Type Details Code Description Save All Changes Cancel The BAI Transaction Type Dialog 3 Complete the form The Code is required is required to be unique 4 Click the Save All Changes Button Editing BAI Transaction Types To edit BAI Transaction Type follow these steps 1 Select the BAI Transaction Type option from the Edit Menu 2 Select the type to edit from the selection list Add Edit BAI Transaction Types Select Add a Type Select type to edit O10 OPENING LEDGER O10 OPENIM is LEDGER A O11 AVERAGE OPENING LEDGER MTD E O12 AVERAGE OPENING LEDGER YTO 015 CLOSINGS LEDGER 20 AVERAGE CLOSING LEDGER MTO 4dd new BAI Transaction Type Type Details Description OPENING LEDGER S
70. a unit rate select the per unit rate radio from the left hand side of the rate details section Input the numeric unit rate into the field 3 9 2 4 2 Flat Rate The value for this type of rate is evaluated alone and the amount listed is the expected total amount Rate Details Flak Rate Per Unit Rate 2 Threshold Rate Tiered Rate Flat Rate Entering a flat rate To enter a flat rate select the flat rate radio from the left side of the rate details section Enter a numeric value in the field to indicate what the flat rate for the negotiated fee should be 3 9 2 4 3 Threshold Rate A threshold rate is a charge structure where the per unit fee changes at an agreed level of activity When the volume of the charge equals or exceeds the threshold the calculation will use the after threshold rate Prior to that the calculation will use the before threshold rate Rate Details Before Threshold Rate Flat Rate Threshold Per Unit Rate After Threshold Rate Threshold Rate Tiered Rate Threshold Rate Entering a threshold rate To enter a threshold rate select the threshold rate radio button at the left hand side of the rate details section Enter appropriate values in the fields for the threshold rate e Before Threshold Rate The rate that will be charged for volumes below the threshold e Threshold The volume at which the rate will shift to the upper rate e After Threshold Rate The rate that will be charged for vo
71. across banks with differing negotiated fees 3 9 2 2 Tolerance Information Negotiated fee tolerance information is used by the discrepancy processing system to define the bounds inside which discrepancies are measured or created Tolerance Information Allowable Occurrences 1 Discrepancy Tolerance Monthly Expected Volurne Volume Tolerance Charge Change Tolerance Tolerance Information Fields Allowable Occurrences Indicates to the discrepancy processing system how many charges with this identical service code to allow when a statement is being processed A discrepancy will be created if this amount is exceeded Discrepancy Tolerance Highest amount discrepancies can be before being identified as a discrepancy If entered this value overrides the discrepancy tolerance set at the account level For negotiated fees this tolerance is currently only used for Incorrect Service Charge discrepancies Monthly Expected Volume Defines the expected volume for this negotiated fee A discrepancy will be created if the actual volume is not within a certain amount specified in the Volume Tolerance of this value Volume Tolerance Percent the expected volume can deviate before being identified as a discrepancy This is only used if the Monthly Expected Volume field is also set Charge Change Tolerance Percent fees can vary month to month before being identified as a discrepancy If entered this value override
72. ained herein is maintained on a confidential basis without disclosures to third parties All parties accepting this material thereby agree not to reproduce copy or otherwise distribute this information without the express written consent of Chesapeake Disclaimer The information provided in this Document and by our customer Support personnel is not intended as legal or accounting advice If such advice is required the services of a competent professional should be sought Publication Data Last Revised May 2007 Publication Title SmartAnalysis 5 0 User Manual SmartAnalysis User Manual Understanding the SmartAnalysis User Interface Table of Contents 1 Perspectives 2 Views 3 Editors 4 The Menu Bar 4 1 File Menu 4 2 Edit Menu 4 3 View Menu 4 4 Window Menu 4 5 Help Menu 5 Context Menus 6 Toolbars 6 1 Perspective Toolbar 6 2 General Application Toolbar 6 3 View Specific Toolbars 7 Navigating Between Perspectives 8 Opening Views 9 Opening Editors 10 Resizing Views And Editors 11 Navigating Between Editors 12 Saving Editors 12 1 Handling Data Entry Errors 13 Closing Views And Editors 14 Accessing Context Sensitive Help 15 Form Field Data Entry 15 1 Required Fields 15 2 Twistie Sections 15 3 List Selection 15 4 Date Entry 15 4 1 Date Field 15 4 2 Dynamic Date Ranges 15 5 Number Entry 15 6 URL Entry 15 7 Tables 15 7 1 Using Editable Tables 15 7 2 Using Selectable Tables 15 7 3 Using Dueling Tables 15 8 Transaction
73. alysis can validate the volumes for the account 7 3 2 T Recs Volumes Do Not Match Description SmartAnalysis assigns this discrepancy to each SmartAnalysis account mapped to a T Recs Import Account showing that no volume has been reported in T Recs for this transaction type 7 3 3 T Recs Volumes Do Not Match Description SmartAnalysis assigns this discrepancy to each SmartAnalysis account mapped to a T Recs Import Account showing that the volume reported for the comparison code in SmartAnalysis does not match the transaction type volume in T Recs 7 3 4 Volumes Do Not Exist Description SmartAnalysis assigns this discrepancy to each SmartAnalysis account that has a BAI confirmation mapping defined showing that no volume has been reported in the BAI mapping for this transaction type 7 3 5 Volumes Do Not Match Description SmartAnalysis assigns this discrepancy to each SmartAnalysis account that has a BAI confirmation mapping defined showing that volume reported for the comparison code in SmartAnalysis does not match the transaction type volume in the BAI mapping 7 4 Discrepancy Query You can query and view discrepancies for a statement at any time Queries can include any combination of criteria including banks accounts statements dates variance amounts and more Quick Look Guide iii dime fer EC Mandag Fries i TEE a Si me H i 4 BELA OR A RASA i i bane Set ae ha Te DT T A S Bere ir diet maretmeacaoe lt
74. ame The Emal Department _ John Brown Corporate jdbrownd Accounts lason Yankus Treasury fyenkuea Treasury John Brown Jr Accoun a ijrbrowndD Accountin kristin Smith CPO kemith ich Finance Monica Pak Head foco mraeaowek Bank Rece Shen Statement skerstette Development Stacey Gim Asst Trea sgimorea CasnhTrea Add a new Sagres Detail Account Editor Signer Assignment Managing detail account signers Four icons are available to manage assignment of signers These are Ei Remove all signers from the account eye Remove selected signers from the account Add selected signers to the account Add all signers to the account 3 9 4 1 Adding A Signer To add a brand new signer to an account click the add signer link at the bottom right of the interface Enter the signer information in the signer editor Save and close the signer editor to return to the detail account editor dd a new Signer Adding A Signer 3 9 5 Detail Account General Ledger Allocations Entering allocations To enter an allocation click the Add button on the editable table Select the new row using the mouse and input the credit and debit account numbers as they apply Enter an allocation percentage You may continue and enter custom fields but they are not required Repeat the process to add as many allocations as are required When finished click the Validation Allocations butto
75. amilies option from the Edit Menu 2 Select the Add New Family link 4 Add Edit Comparison Code Families Comparison Code Family Mew Family Mew Family Add New Family Display Name Mew Farily Description New Family Member Comparison Codes All Available Selected Lode Display Mame Code Display Mame OU Q 01 Ledger Balance OU O00 Oe Ledger Balance 00 OU Us Ledger Balance OU OO 04 Ledger Balance 01 02 04 MERCHANT EX Ue 09 99 OSCO SPECIAL 05 01 16 LE CHECK RE UB 03 27 Payroll Card Fun Ub 04 0z Payroll Card Ing OB 04 03 Payroll Card Ing Ub 04 04 Payroll Card Ing UB 04 10 Payroll Card Pav 06 04 20 Payroll Card Stat OB 04 21 Payroll Card Stat 06 05 OO Payroll Card Set e 05 10 Payroll Card Acc 06 05 20 Payroll Card PIM 06 05 30 Payroll Card Cus 06 05 40 Payroll Card Ina 06 05 50 Payroll Card Cus Ob 99 99 Undefined Fara DETT TT Toatl Payroll Car Line ltem Total Save All Changes Cancel The Comparison Code Families Dialog Complete the form Family name and description are required Family name is required to be unique If desired assign one or more of the All Available Comparison Codes to the family Comparison Codes are assigned to and removed from Comparison Code Families using dueling tables Click the Save All Changes Button 11 2 Editing Comparison Code Families To edit a comparison code fa
76. ancy process compares incoming service charges When carefully maintained the negotiated fee information provides accurate rate boundary and tolerance data The more accurate the negotiated fee setup is the more effective SmartAnalysis can be in helping you to identify and eradicate discrepancies Select the Negotiated Fees Tab at the lower left of the editor interface to display the negotiated fees for the relationship gt General Information Negotiated Fees Contacts GLExport Negotiated Fees Tab 3 9 2 1 Identity Information Negotiated Fee identity information is used throughout the application to match service charges to bank setup information This matching is important because it is the foundation of the discrepancy processing and reporting capabilities of SmartAnalysis It is critical to these processes that the negotiated fee setup identity information be well maintained Identity Information Incoming Bank Code AAADOL Incoming Service Code 01 4 00 Incoming Description ACCOUNT MAINTENANCE 25 Comparison Code 01 04 00 Account Analysis Automated Maintenance i Identity Information Fields e Incoming Bank Code The identifying string assigned to a service by the bank e Incoming Service Code The identifying string defining the service based on the industry standard codes e Incoming Description The charge description e Comparison Code The cross bank comparison code used to perform queries and reports
77. and phone numbers of the relationship representative of these at least one of name email phone or fax number are required Primary Information Mame Calvin Hobbes Tithe Account Representative Email chobbestusbank com Department Customer Service Phone Number 800 555 9755 Alt Phone Number Fas Number Mobile Number Primary Information 3 6 3 2 Address Information The Relationship Editor Contact Tab also provides an area to enter the contact s address information Address Information Address City State Ip Country Address Information 3 6 3 3 Specialized Information Contacts have two forms of Specialized Information Contact Types and Notice Required Contact Types provide a way to organize the bank representatives into categories These categories are entirely arbitrary and are defined by SmartAnalysis users Notice Required indicates the number of days Same day 1 day or 2 day notice that the contact requires before a change to the banking relationship can be effected 3 6 4 Relationship General Ledger Allocations Entering allocations To enter an allocation click the Add button on the editable table Select the new row using the mouse and input the credit and debit account numbers as they apply Enter an allocation percentage You may continue and enter custom fields but they are not required Repeat the process to add as many allocations as are required When finished click the Valida
78. anking relationship information e Signers e Authorized Associates e SmartAnalysis RM Specialized Account Information e Bank Confirmations e Bank Specialized Information e SmartAnalysis RM Report 12 2 1 Signers SmartAnalysis RM provides the capability to create and manage specialized contact types called Signers Signers are a type of associate that is permitted to approve expenditures for specific accounts up to a certain dollar amount SmartAnalysis RM permits the management of Signers and their assignments to detail accounts For more information on how SmartAnalysis handles Signers you may follow the links below e Signers View e Creating Signers e Managing Signer Assignments e Signer Status Report 12 2 2 Authorized Associates Authorized Associates are employees of your organization that are trusted to make decisions about and take action on the relationship with a bank They may be entered for a bank by selecting the Authorized Associates tab of the Bank Editor For more details on Authorized Associates see Authorized Associate Management 12 2 3 SmartAnalysis RM Specialized Account Information One of SmartAnalysis RM s most significant features is the capability to add a wide array of specialized information to the account setup information The benefit of this feature is that it provides rapid lookup capabilities to the SmartAnalysis user For more information about the specialized information follow the links below
79. arge discrepancies by assigning discrepancy tolerances at the account level A discrepancy tolerance reduces the number of less important or minor discrepancies each time a statement is processed for discrepancies 7 2 11 Incorrect Total Service Charge Summary Description SmartAnalysis also generates this discrepancy when the relationship summary account has a charge that does not appear in any of the sub accounts Tolerances can also be set in the bank setup information to monitor total service charge amounts If the tolerance is exceeded this discrepancy is generated Resolution Often Incorrect Total Service Charge Summary discrepancies are generated due to minor rounding discrepancies You can eliminate minor incorrect service charge discrepancies by assigning discrepancy tolerances at the account level A discrepancy tolerance reduces the number of less important or minor discrepancies each time a statement is processed for discrepancies 7 2 12 Incorrect Volume Description SmartAnalysis generates this discrepancy when the service charge exceeds the expected volume or exceeds the volume change tolerance defined for the specific service charge Resolution 7 2 13 Missing Account Description SmartAnalysis generates this discrepancy when the statement is showing an account that is not defined in the SmartAnalysis bank setup 7 2 14 Missing Charge Information Description SmartAnalysis generates this discrepancy when the bank se
80. arison code bank code exception type status responsibility and variance amount 7 1 Discrepancy Process Import the Statement or Manually Enter Statement Data During this process the information set up in SmartAnalysis is compared to the actual information found from the 822 file Importing an 822 statement will automatically be processed If you manually enter your statement data you must process the statement after you have saved the changes in order to view discrepancies Review the statement for discrepancies in the Discrepancy Query HINT Determine if any items can be closed or filtered out from the list of discrepancies to reduce the items in the list e Review the details of each discrepancy e Research the discrepancies e Assign responsibility for each discrepancy e Email discrepancy information to appropriate management and or bank personnel e Add comments or attachments e Export the list of discrepancies to a delimited text file to email to the appropriate management or bank personnel Resolving Discrepancies e HINT Use the Discrepancy Auto Resolve feature when available to enhance the process of resolving discrepancies e Identify the discrepancies from the discrepancy query e Make changes corrections to the current fee structures bank setup information or other areas in SmartAnalysis Once you make the necessary changes you can reprocess the statement to compare the updated setup information to the existing
81. asking you if you want to continue Once the statement is processed you will be taken to the Discrepancy Query where all new discrepancies for the selected statement will be displayed 6 6 Deleting a Statement There are two ways you can delete a statement First you have to select the statement you want to delete in the Banking Structure View Then do one of the following steps e Right click the statement to display the context menu then select the Delete option e Click the delete icon lin the Banking Structure View toolbar 7 Discrepancies Discrepancies are differences between the bank setup information defined in SmartAnalysis and the actual data found on the bank statement An exception status is assigned to everything on the bank statement that disagrees with the values provided in the defined setup information such as negotiated fees and service charge tolerance limits The status is initially considered open but can also be updated to pending or closed once the discrepancy is investigated The discrepancy process analyzes data at the bank relationship and account levels Once discrepancies are identified you have the option to view the discrepancy detail assign them to a particular SmartAnalysis user add any notes or attachments to the discrepancy email the discrepancy detail and also view and update the status of the discrepancy These discrepancies can be filtered by account incoming service code comp
82. ata for statements you may revert their export status to unexported Select a statement in the banking structure view and select Mark Statement GL Unexported from the drop down menu After this procedure the statement will again be eligible for General Ledger Export Banking Structure West Coast Account 0700497534 3 Bi 5 a 2 REN Ea 7 lel i 2 Saneral adaer Wiest C el T AMSOUTH BANK 062000019 blew i Bank OF America 121000358 i f ir Bank of Chesapeake 012566011 BS Import Statement gt Relationships i a Edit locat 3 B A 0700497535 RELATIONSHIP SUMMARY 7 Herat 0700497534 West Coast Account ME Delete bc La SOS0007 164 East Coast Account aan a Statements Ei Account QuickFind bc 2 10 01 2005 10 31 2005 Mark Statement GL Unexported ap etre a B5 Reprocess Statement FA 08 01 2005 08 31 2005 ie Fe 07 01 2005 07 31 2005 4S Create ie Bank of England MCO 052000712 42 cress f Relationships Ee 98001694 RELATIONSHIP SUMMARY 7 LS 012020000717636 Consolidated II E3 Create copy of statement Mark statement unexported 3 12 Operational Structure View The Operational Structure View organizes relationships and accounts by operational units Once defined the operational structure is useful for narrowing reports and queries to distinct sub units of your entire organization You can drag and drop relationships and accounts from the Banking S
83. ately saved In SmartAnalysis there are two types of views stand alone views and normal views The difference is that stand alone views cannot be closed or moved because they are so integral to the functionality of the perspective that closing them would make the perspective useless 3 Editors Editors are used to create view or modify the detailed properties of an item For example among others SmartAnalysis contains editors for banks relationships detail accounts and statements All editors have a clearly defined process where an item may be opened modified saved and closed Changes made in an editor are not saved to the database until the user saves the editor Editors may contain multiple pages which organize the data elements into logical groups You can navigate between these pages by selecting the corresponding tab at the bottom left of the editor pane 4 The Menu Bar The Menu Bar lists the available menus along the top of the SmartAnalysis application window P SmartAnalysis File Edit View Window Help The Menu Bar 4 1 File Menu The File Menu provides access to common functions used within the application The functions are explained below SmarAnalysis File Edit View Window Help a Save ies Be Import Statement Export GL Data E sit The File Menu Save Saves any changes to the currently active editor This function can also be accessed by selecting CTRL S and is only enabled if there are unsaved
84. ationship Level charges are desired you must select the Summary Charges checkbox In other conditions Relationship Level charges can be returned in a normal report The Services By Month Report organizes charges using several distinct elements Among these are the column header the group headers and the group subtotals services By Month BEN i Eger a DS tz Corrected oH MT ie Bi Gi ca ll Te ADG LAT War Pea ee h JE ik Secure Sess ae See E J efe 553 Regerd ESE a re Gear sai p os Pien a TELE ECAE SOT Paes SRT ERANECE GDC Grech Deca uss eB r Zang 1 So oo REJ DOR FRIRE WEET Ery ERE DE Branch Dah Lae 1J E peg a i aE Bao oo a 4c NT WaT PE I ODID Geese Deol Accord kere T ad Fae Be SEa6 Th E T it aa Geen ac ail ji inte Li Dem oo io pa had TEE Se Bear Geotail a LL Be afc 10 2 fe HECH Clea WEHT EaI ESPIC Erpe Deae lat HH IFE Cee T SS eh et ple MO e geet a Services By Month Report Sample Columns From left to right the columns in the Services By Month Report are i Service Code The Incoming Service Code of the Service Charge See Service Code Bank Code The Incoming Bank Code of the Service Charge See Bank Code Description The Incoming Description of the Service Charge See Description Comparison Code If a Comparison Code is associated with the Service Charge its information is displayed here Unit Price The unit price of the Service Charge from the sta
85. aye All Changes Cancel The BAI Transaction Type Dialog 3 Complete the form The Code is required is required to be unique 4 Click the Save All Changes Button Creating Volume Confirmation Mappings To create new Volume Confirmation Mappings follow these steps 1 Select the Volume Confirmation Mappings option from the Edit Menu 2 Select both a BAI Transaction Type and Comparison Code 3 Select the Add button Volume Confirmation Mappings Choose mapping to add BAI Transaction Type 021 AVERAGE CLOSING LEDGER PREVIOUS MONTH Comparison Code 00 02 30 FDIC Assessment Existing mappings BAI Transaction Type Comparison Code 011 AVERAGE OPENING LEDGER MTO 00 00 10 Collected Balance Average Met 024 AVERAGE CLOSING LEDGER YTE PREVIGUS M 0000 13 Collected Balance 4yverage Negative jes Cancel The Volume Confirmation Mappings Dialog 4 Click the Save All Changes Button Creating BAI Transaction Types To create new Volume Confirmation Mappings follow these steps 1 Select the Volume Confirmation Mappings option from the Edit Menu 2 Select a mapping from the Existing mappings table 3 Click the Delete Selected Mappings button 3 Volume Confirmation Mappings Choose mapping to add Comparison Code Existing mappings BAT Transaction TYE Comparison Code 011 AVERAGE OPENING LEDGER MTO 00 00 10 Collected Balance Ave
86. ca All Time Small Element Top Unit Rate Service Charges Previous Month Lange Element Small Element 0 werall Changes Previous 12 Monthes Top Total Cost Serice Charges Previous Month x 5 mall Element Top Volume Service Charges Previous Month gave All Changes Cancel The default layout The all large layout of the Executive Summary Perspective divides the perspective into 4 equal large element areas This layout provides a legible display for four total Executive Summary Dashboard Elements ry Executive 5 ummary Element Selection Lange Element Lange Element il otal Charges By Bank Prevactas Month Overall Charges Previous 12 Months x Large Element Lange Element Top Discrepancies By Vanance All Time Top Total Cost Serice Charges Previous Month The all large layout To change the layout of the Executive Summary Perspective follow these steps 1 Open the drop down menu of the Executive Summary Perspective A 2 Select the Select Dashboard Layout menu item Save Changes Cancel 4 Click the Save Changes button 5 The system will reload the Executive Summary Perspective Please note that this may take a few seconds depending on the size of your database 2 2 2 Changing The Executive Summary Perspective Dashboard Elements There are several Executive Summary Dashboard
87. cepts 13 2 Security Authorities 13 2 1 Authority Groups 13 3 Users 13 4 Security Manager Perspective 13 5 Managing Users 13 5 1 Users View 13 5 2 User Editor 13 5 3 Why Users Cannot Be Deleted 14 5 4 Assigning Authorities and Groups 13 6 The Authorities View 136 1 Authority Detail 13 6 2 Authority Groups View 13 6 3 Authority Group Editor 14 Volume Confirmation 14 1 BAI Volume Confirmation 14 2 T Recs Volume Confirmation 1 Accessing the System Chesapeake System Solutions Inc recommends that prior to logging into SmartAnalysis for the first time you should be trained on understanding your security access and maneuvering through the system which should include the location of all the system functions To access SmartAnalysis you must have a valid username and password established in the system Your username is the unique code that identifies you to SmartAnalysis and will be linked to your specified password Please see your System Administrator who will assign you your unique username and password To access the system follow these steps 1 Click Start gt Programs gt Chesapeake s SmartAnalysis gt SmartAnalysis SmartAnalysis displays the login window Smar nalysis Login x F ENG A CU ry PP ies ee Please enter your generis and Password to ar to ere Username chessys Password Cancel Change Password 2 Type your username and password Please note your password is case sensitive
88. cepts within the security system are SmartAnalysis Security Authorities Authorities represent the tasks or features for which access is granted to users These are the basic units of the security system Authority Groups An Authority Group is a logical construct used to gather one or more Authorities so they may be easily organized managed and assigned Users Users are the logical representations of the people accessing SmartAnalysis Every individual accessing SmartAnalysis should have their own user 13 2 SmartAnalysis Security Authorities There are numerous authorities governing access to features and functionality within SmartAnalysis Authorities are listed in The Authorities View Access Executive Dashboard Permits the user to access and view the executive dashboard feature Without this authority users are directed to the Bank Manager upon application startup Modify Executive Dashboard Permits the user to modify the types of data shown on the executive dashboard or their layout Create Bank Permits the user to create a new bank within the Bank Manager Edit Bank Permits the user to update bank specific information within the Bank Editor Delete Bank Permits the user to delete an entire bank and it s relationships detail accounts negotiated fees statements and discrepancies This is a particularly powerful authority and should only be granted with caution Create Relationship Permits the user to create Relationship Summary acco
89. cessing the System 1 1 Changing Your Password During Login 1 2 Troubleshooting A Failed Login Attempt 2 Executive Summary Perspective 2 1 Executive Summary Dashboard Elements 2 2 Configuring the Executive Summary Perspective 3 Banking Information Perspective 3 1 Banking Structure View 3 2 Creating A Bank 3 3 Editing a Bank 3 4 Deleting a Bank 3 5 Creating a Relationship 3 6 Editing a Relationship 3 7 Deleting a Relationship 3 8 Creating a Detail Account 3 9 Editing a Detail Account 3 10 Deleting a Detail Account 3 11 General Ledger Export 3 12 Operational Structure View 3 12 1 Creating Operational Units 3 12 2 Editing Operational Units 3 12 3 Deleting Operational Units 3 12 4 Assigning Accounts and Relationships to an Operational Unit 3 13 Unassigned Accounts View 3 14 Signers View 3 14 1 Creating Signers 3 14 2 Editing Signers 3 14 3 Deleting Signers 3 14 4 Assigning Accounts To Signers 3 15 Contact Types 3 16 Account Types 3 17 Account Purposes 3 18 Location Codes 4 Report Manager Perspective 4 1 Report Selection View 4 2 Executing A Report 4 2 1 Report Criteria Editor 4 2 1 1 Saved Report Criteria 4 2 1 1 1 Executing Saved Report Criteria 4 2 1 1 2 Editing Saved Report Criteria 4 2 1 1 3 Deleting Saved Report Criteria 4 3 Report Types 5 System Parameters 5 1 General System Parameters 5 2 Login Security System Parameters 5 3 Decimal Precision System Parameters 6 Statements 6 1 Importing 822 Files using the Wizard 6 2 Creatin
90. charges to the entities for that specific account Before the allocations are assigned the earnings credit is applied to the total service charge amount The remaining surplus or deficit is then applied to the entities rolling up into the account or relationship depending on the G L setup level chosen in SmartAnalysis Based on your business financial structure you can setup the G L Debit allocations at either the Relationship level or at the Account level At each level you have the option to assign allocations to as many entities as desired with the allocation percentages for each account or relationship summing 100 Setting up General Ledger Allocations e Relationship General Ledger Allocations e Detail Account General Ledger Allocations Exporting General Ledger Data Export general ledger information for statements in SmartAnalysis using the file menu option to Export GL Data it SmartAnalysis File Edit View Window Help E Sav w TA E Import Statement Export GL Data p H Exit H er di iee e eee ee m l E Bank OF America 121000358 iy Bank of Chesapeake 012566011 General Ledger Export Once the menu option is selected SmartAnalysis analyzes the statements and allocations in the system If unexported statements with allocations on bank setup accounts can be found an export file is created A file dialog allows you to save the allocation to a location of your choice Should you wish to re export the d
91. con PE or right click and select the Delete option from the context menu 3 5 Creating a Relationship TO manually create a Relationship Summary right click on the Relationships folder underneath the desired bank Select Create new Relationship for Bank Banking Structure i h f X Sa Al Y i AND OUTH BAN 82000018 Naw E Bak S Stabements gy Import Statement ad jy Bank Of America 121000356 P Edk f Bank of Chesapeake 012566011 tet Fielo i Fam ee b m a a a i a ra Toedebr Creating a Relationship 3 6 Editing a Relationship To view or edit the information for a relationship open the Relationship Account Editor from the Banking Structure View either by double clicking the relationship or by selecting Edit from the context menu Banking Suia C RELATIONSHIP SUMMARY 07 Oey ad A bad Ralatinnchin de AMSOUTH BANK TINE ea Relationships p F 12121 RELATIONSHIP SUMMARY LA Import Statement H Statements dir HEE i Edit 4 eet Bank OF America 121000356 Bank of Chesapeake 012566011 gi Delete I ie ens 10700497535 RELATIONSHIP SUMMARY 6 Account QuickFind SRE LE Nee a bas sane on ee Le SOURCE Re ee rrr E M Statements a nish tetemet t Editing a Relationship 3 6 1 General Information Tab The general information tab contains a variety of basic information about the relationship RELATIONSHIP SUMMARY 0700497535 15 Relationship Information RE
92. construct such as Views Editors or fields and is available throughout the application Context sensitive help may be accessed by pressing the F1 key This will reveal the Dynamic Help view which is used to present context sensitive help information 15 Form Field Data Entry This section describes how to effectively and efficiently use common user interface components in SmartAnalysis 15 1 Required Fields Required fields are marked with an asterisk 15 2 Twistie Sections Twistie Sections are parts of the interface that may be opened and closed as needed This simplifies the appearance of the interface while providing a full set of features for those users that desire them To open or close a Twistie Section click the toggle icon t Date Range t Bank Codes t Service Codes t Charge Description t Comparison Codes t Comparison Code Families t Amount Twistie Sections on the Fee Query Criteria 15 3 List Selection There are many places in SmartAnalysis where you may select one or more items in a list This functionality is included in the drop down selection lists as well as the lists presented in the views such as the banking structure view or the operational structure view Please note that not all lists support the selection of multiple elements since this is not always appropriate The following is an explanation of the various ways you can select items in a list To Select A Single Element of a List Us
93. crepancy Once you make the changes to fix it you can manually close the discrepancy Resolve All Discrepancies Use this option to auto resolve all discrepancies in the results view a e Select the B tion from the discrepancy results window e or select the drop down list and select Resolve All Discrepancies Discrepancy Results i e w is yt Pj Account Variance Drepa Eu ere a p West Coast Account 00700497534 2 741 51647 Earnings Credk Cakulation er Y Cee Al Discrepancies j RELATIONSHIP SUMMAR T 0700 1 50000 Linknown Totel Service Charg Resolve Selected Discrepancies FLATIONSHIP SUMMARY 0700 1 08000 Linknown Total Service Charge a eae prea t RELATIONSHIP SUMMARY 0700 0 84000 Linke Total Service Charge FED RES DISTRICT 12 4 06 ITEM Vest Coast Account 0700497534 0 01055 Earnings Credit Calculation Error crane e Proceed to select discrepancies on the discrepancy selection screen Resolve Selected Discrepancies Use this option to auto resolve only the selected discrepancies in the results view e Follow the general selection guidelines to select the discrepancies you want to auto resolve e Select Resolve Selected Discrepancies once all discrepancies have been selected Resolve All Discrepancies West Coast Account 0700497534 2 741 5164 Earnings Credit Calculation Er RELATIONSHIP SUMMARY 0700 1 50000 Linknown Tota Service Charg Resolve Selected
94. crepancy when an account number is duplicated in the statement for a relationship or an account This may indicate you are getting charged twice for the same account SmartAnalysis allows for a relationship and an account to have identical account numbers however any other combination of duplicates generates this discrepancy Resolution Contact the bank to determine why a single account appears twice on your bank statement 7 2 5 Earnings Credit Calculation Error Description SmartAnalysis generates this discrepancy to each bank statement record whose reported earnings credit is not equal to the earnings credit amount calculated by the system The system does not flag differences caused by rounding Please note that you may want to assign a tolerance for this discrepancy at the bank level Resolution The earnings credit month operand and earnings credit formula are designated on the bank information setup page When a bank is setup using an 822 file as a baseline for creating the bank these fields are not defined during that process If either of these fields are not setup this is a potential possibility for Earnings Credit discrepancies You can manually define these fields on the bank setup page Another possibility is an incorrect reserve rate used in the file causing discrepancies in which case you must contact your bank to correct the situation Information may also be missing in the 822 file to make this calculation In this case you shoul
95. d easily produce a comprehensive summary of your account analysis The remainder of this chapter describes how to effectively and efficiently use the reporting features of SmartAnalysis The Report Manager Perspective can be accessed at any time by clicking the Report Manager button of the Perspective Toolbar lt gt Banking Information gt Fee Query on Balance Query gt Discrepancy uey oe Report Manager Executive Summary Selecting the Report Manager Perspective from the Perspective Toolbar 4 1 Report Selection View The Report Selection View allows the user to browse and execute reports and saved report criteria At the top most level reports are grouped into categories of reports that display information concerning the same data type Report categories include balance reports discrepancy reports and service charge reports among others The report category folders include the report types that are defined for that category The report types in turn contain the Saved Report Criteria folder which contains any Saved Report Criteria Criteria defined for that report type Report Selection View S H Account Reports oS Balance Reports B Contact Reports j aoe Discrepancy Reports Discrepancies By Period Report p Saved Report Criteria Incorrect Senvice Charge E 4 Discrepancies By T ype Report Si EE Charge ales H Signer Reports Report Selection View 4 2 Executing A Report To execute a repor
96. d review the discrepancy to see what part of the formula is missing and understand this is not a calculation error but rather a component of the calculation missing for SmartAnalysis to make the calculation 7 2 6 Earnings Credit Error Description SmartAnalysis generates this discrepancy when there is a problem calculating the earnings credit for the statement Most likely this is because a required part of the earnings credit formula was missing from the statement Resolution Check your bank setup to make sure the correct earnings credit formula is selected for the bank 7 2 7 Earnings Credit Setup Error Description SmartAnalysis generates this discrepancy to each bank statement record does not have the required information to calculate the Earnings Credit amount Resolution The discrepancy message will give you the details on what was missing so you can make the changes to your bank setup 7 2 8 Incorrect Reserve Rate Description SmartAnalysis generates this discrepancy when the reserve requirement rate does not match the Federal Reserve requirement rate 7 2 9 Incorrect Service Charge Description SmartAnalysis generates this discrepancy for each account level service charge found on the statement that does not equal the calculated service charge in SmartAnalysis based on the fee structures defined in the bank setup For example you may be charged 100 00 on your bank statement yet the correct calculation based on the neg
97. de and incoming service description normally should identify uniquely a service charge from a particular bank there is no guarantee that this combination will match the incoming bank code incoming service code and incoming service description used by a second bank to identify what is essentially the same service In many cases this limitation prevents the generation of meaningful comparisons between banks In light of this SmartAnalysis introduced Comparison Codes Comparison Codes are a common code set defined in SmartAnalysis that when properly mapped to balances and to negotiated fees for each bank enables meaningful comparisons across banks even when the banks being compared use entirely different code sets to identify balances and service charges Where Do Comparison Codes Come From Comparison Codes come from a number of places From the SmartAnalysis Database Installation Scripts Depending on the nature of your contract SmartAnalysis may have shipped to you with one or more code sets already defined in the database SmartAnalysis can ship with scripts to load any or all of the following code sets Association of Financial Professionals AFP Codes X12 822 Balance Codes and Chesapeake System Solutions Inc Codes From the 822 File During Statement Import With Baselining When creating a baseline bank setup during statement import SmartAnalysis automatically populates the Comparison Codes with the information from the 822 file and automatical
98. e Account Additional Information e Account Specialized Information 12 2 4 Bank Confirmations The Bank Confirmations feature of SmartAnalysis RM is provides the user with the capability to record review and manage the notifications and requests made to the bank about specific accounts See Bank Confirmations for more details 12 2 5 Bank Specialized Information In addition to SmartAnalysis RM Specialized Account Information SmartAnalysis RM provides extra detail at the bank level Bank level SmartAnalysis RM features include Transaction Cutoff Times Authorized Associates and Specialized Additional Information 12 2 6 SmartAnalysis RM Report A core feature of SmartAnalysis RM is the ability to provide useful and timely reports based on the SmartAnalysis RM data SmartAnalysis RM reports are integrated with SmartAnalysis in the same fashion as any report and support the same saved report functionality See the Report Manager Perspective for more details on SmartAnalysis reporting capabilities The SmartAnalysis RM reports include e Overall Account Status Report e Contacts By Bank Report e Signer Status Report 13 Security and the Security Manager Perspective SmartAnalysis application security is centered around some core Security Concepts and is managed by the Security Manager Perspective 13 1 Security Concepts SmartAnalysis security is organized based on features and tasks within the SmartAnalysis system The main con
99. e After Threshold Rate The rate that will be charged for volumes above a the threshold 3 6 2 4 4 Tiered Rate A tiered rate is a fee structure relating a per unit fee to an activity level Rate Details Lower Bound Upper Bound Rate O Flat Rate Per Unit Rate Threshold Rate O Tiered Rate validate Tiers Tiered Rate Entering a tiered rate To enter a tiered rate select the tiered rate radio from the left hand side of the rate detail section To add a tier to the table click the add button Click on each cell of the row to edit the values for the tier Repeat the process for each tier for the negotiated fee When finished entering tiers click the Validate Tiers button to evaluate the tiers entered and ensure the consistency of the data There are a number of rules that tiered rates must follow e The first tier must contain a 0 value as its lower bound e The tiers must be sequential without gaps in the coverage or any overlap 1 10 11 20 etc e Each tier must have a rate specified e The final tier must have a blank upper bound This signifies that the bound terminates at infinity Only the final tier may have this value 3 6 2 5 Change History Negotiated fees maintain an audit trail of changes made to the fee Each change is recorded when the relationship or detail account editor is saved The audit trail contains information about the time of the change the user who made the change and a record of the changes
100. e earnings credit discrepancy calculation Enable operational structure discrepancy calculation Child operational units of visible OU should not be accessible General System Parameters The following features may be configured using the General System Parameters Use BAI statistics for volume discrepancy calculation As of release 3 5 2 SmartAnalysis supports using BAI statistics for volume confirmation Customers that receive daily BAI files and have deployed the SmartAnalysis BAI Import Utility may enable the volume confirmation discrepancy by setting this value to true For more information about using BAI files for volume confirmation please contact smartanalysis chessys com Enable earnings credit discrepancy calculation Unfortunately because of the nature of the X12 822 transaction set specification the earnings credit calculation cannot always be correctly determined Customers that find the earnings credit discrepancy to be a nuisance may disable it by setting this value to false Enable operational structure discrepancy calculation Customers that do not utilize the operational structure feature or those that for any other reason are not concerned with the operational structure discrepancy may disable it by setting this value to false 5 2 Login Security System Parameters Login Security System Parameters configure the security settings for passwords and login By setting these parameters SmartAnalysis Administrators can ensure
101. e entered with a selectable table Auto Match Codes Often SmartAnalysis can produce a reasonable baseline of Balance Mappings for a bank by matching the incoming balance code to the comparison code To have SmartAnalysis automatically generate Balance Mappings select the Auto Match Auto Match Codes Codes Button Manually Match Codes When SmartAnalysis cannot automatically determine the Balance Mapping or when the Auto Match feature has produced an incorrect Balance Mapping the codes can be matched manually To Manually Match a code follow these steps 1 Select the Balance Mapping from the selectable table or click the Add button 2 The first selection list labeled Incoming Balance Code contains all of the balance codes imported from 822s for this bank Please note that in order for this list to be populated you must have imported at least one statement for the bank Select the incoming balance code you wish to map from the selection list 3 The second selection list contains all of the comparison codes defined in the system Select the comparison code you wish to map from the selection list 4 Save your changes 3 4 Deleting a Bank Deleting a bank will remove all information about that bank from SmartAnalysis including all relationships accounts and statements Except for extreme cases banks should rarely be deleted To delete a bank select the bank in the Banking Structure View and select the delete i
102. e user to access the discrepancy query Auto resolve Discrepancies Permits the user to access and execute the discrepancy auto resolution features Export results from Discrepancy Query Permits the user export results from the Discrepancy Query Change Status of Discrepancy Permits the user to alter and save the state of a Discrepancy Change Assignment of Discrepancy Permits the user to alter and save the assignment details of a Discrepancy Add Comment to Discrepancy Permits the user to add comments to the Discrepancy audit trail Send e mail with Discrepancy Permits the user to condense the Discrepancy into an email See E mailing Discrepancy Information for details Insert Attachment to Discrepancy Permits the user to attach files to a discrepancy See Adding Notes and Attachments to Discrepancies for details Access Report Manager Permits the user to access the Report Manager See Report Manager Perspective for details Execute Report Permits the user to execute reports within the report manager Save Report Criteria Permits the user to save report criteria so they may be used later Open Saved Report Criteria Permits the user to re open previously saved report criteria Delete Saved Report Criteria Permits the user to delete existing saved report criteria Access Security Manager Permits the user to access the Security Manager Perspective Create User Permits the user to create additional users within the SmartAnalysis system Edit User
103. ed to any of the deleted relationships or accounts will be deleted from the statement 6 4 3 1 4 Deleting an Account You can delete an account right clicking on an account and selecting Delete Note that all discrepancies related to that account will be deleted from the statement 6 4 3 2 Changing a Statement Account s Name or Number Changing the Name With a relationship or account selected in the Account Hierarchy you can modify this field to update its name Changing the Number With a relationship or account selected in the Account Hierarchy you can modify this field to update its number 6 4 3 3 Account Detail This section provides tables to modify data for the currently selected relationship or account 6 4 3 3 1 Service Charges This table allows you to add delete and modify service charges for the selected relationship or account Each row is required to have either the Bank Code or Service Code as well as an Amount 6 4 3 3 1 1 Bank Code A bank specific code assigned to a service charge 6 4 3 3 1 2 Service Code The industry code assigned by a bank to a service charge 6 4 3 3 1 3 Description A description of the charge 6 4 3 3 1 4 Type The type of charge which typically is Unit Price x Quantity or Flat Charge 6 4 3 3 1 5 Unit Price The price per unit for this charge 6 4 3 3 1 6 Volume The volume recorded for this charge 6 4 3 3 1 7 Total Price The total price of the charge This field is automatically
104. elect the resources to save O Bank Of America California 121000353 Bank Of America 2 Select All Deselect Al mea The Save Resources Dialog 12 1 Handling Data Entry Errors If validation failures occur while saving a validation dialog will appear The dialog contains details about the validation failures that prevented the save Once the validation failures have been reviewed changes should be made to the editor so that the indicated validation requirements are met Once all validation failures are resolved the editor may be saved Problem encountered during execution AN 1 problem s were encountered while attempting to save the Bank lt lt Details Bank ABA Sumber is required The Validation Failure Dialog 13 Closing Views And Editors Views and Editors may be closed by clicking the Close icon px in the upper right hand corner of the tab This function may also be accessed via the context menu by right clicking on the tab for the view or editor Stand alone views cannot be closed In the case of Editors two additional options are available Close All which closes all open editors and Close Others which closes all open editors except for the currently active Editor Please note that this does not close the entire application but only the selected view or editor 14 Accessing Context Sensitive Help Context sensitive help is information concerning the currently active visual
105. ently are less likely to be compromised If set SmartAnalysis will require the user to change their password before accessing the system after the configured number of days has elapsed Valid values range from 0 to 180 days An empty value disables this security check and passwords will never expire User Account will be locked after this number of failed login attempts Configures the system to automatically disable user accounts after a threshold of failed login attempts is exceeded This prevents malicious users from indefinitely attempting to guess the password of a valid account Valid values range from 1 to 10 attempts An empty value not recommended disables this security check Users will be locked if they have not logged on within this time period Days Configures the system to automatically disable user accounts after a period of inactivity Users are prevented from logging on to the system with a disabled account Valid values range from O to 180 days An empty value disables this security check and user accounts will never be disabled automatically because of inactivity Passwords can be the same as the username The easiest passwords for a malicious user to obtain are those that are the Same as the username which is fully visible on the login form If this System Parameter is set to true SmartAnalysis will require that the password be different from the username Minimum length for passwords The security of a password is directl
106. erational Unit and one of its assigned accounts are selected Expectation The records for every account and relationship assigned to any operational unit below the selected unit are returned Entity Selection Banking Operational Ea Corporate 41705459 THE ABC Company 12121 RELATIONSHIP SUMMA h ga Area Structure Fob29050 RELATIONSHIP 5a District 1 L5 1481850 NY Centers 2030906 NH Centers L5 3326085 DE Centers i 4102612 CT Centers Ly 4112749 Ma Centers i 4159983 RI Centers F District 2 Ti per 3 H Redon QuickFind e Description Two Operational Units are selected Expectation The records for each and every relationship or account under either operational unit are returned Entity Selection Banking Operational E Corporate A LS 41705459 THE ABC Company 12121 RELATIONSHIP SUMMA h 5a area Structure fell Fo629050 RELATIONSHIP Le 1461850 NY Centers L5 2030906 NH Centers i C5 3326085 DE Centers L5 4102612 CT Centers Ly 4112749 MA Centers i C5 4159983 RI Centers F District 2 L5 5967702 NJ Centers 1 a 5967717 P Centers iM Quickfind 16 Closing The Application SmartAnalysis may be closed by selecting the Close Window icon hin the upper right hand corner of the application window or by selecting the Exit option of the File Menu SmartAnalysis User Manual Using SmartAnalysis Table of Contents 1 Ac
107. eria Banking entities operational units codes amounts and dates may be entered as criteria To execute a balance query select the relevant criteria and entities from the criteria view and click the Execute Query button Results of the query are displayed in the table to the right of the criteria Quick Look Guide martinay nta pie fat yee bni pep a Eitrigg itamibi Tee gumy Ki Chaar p Repork Manage Case Cagney Balance Query Criteria Balance Query Results ox Entity Selection iy F Baro Cyri Halama Inii bare iB AG BA enn Industry Code Deemipton ts re ccouriere Acccunt Mim mS Barrai p Ew Lody Duone Auaga ie ree eens Fian RELATE MA SL Aes dane Mim io Dessie Balance verso Het DSA 266 86 RELATIONSHIP SLAB IZZ i A iin z K A Laer bec WHE Air dae Pied yo oe Be ih Last SIP A ee Pod bi D i akeriad Bal p DWE 3 25 0 RELAT DSH SLRARA ra P F Bank OF Aeri e 120000058 m wia Elia Balance Ar E ARAS ir DELATIONSHP SUMMARY rice 3 Bide d Cael ir eee E SA Imet abe payre WIDA H 150 15 RELATIONS IMMAT IIZI i Boku E ake al MO COE mi 1 Feen Pans kene Ge njn aae AFA ATOR A DR TAITI ie But LOCK OF Babe Ep ii 00 Tanaga Changes Total Current Pened ios agda PELAIRONSHI SAHAR jiji ih ENET aii aaa ca f n LE i Pirama Egrant ite rne Charge CE Set RETO Ae FIL bi Ki Uae caine ean alee por Oi 4 we Enis Ce oae aE W SBT ae GEOGEL RT ITIL Ro mA hd bah ON kia Cisma
108. es Operational cn EEEE ea 0693999999 RELATIONSHIP SLUM H Statements iipy Bank of Chesapeake 012566011 ats Bank of England MB 052000212 ais BLUE BOOK OF BANKE PRICES 2004 20085 airs COMMERCE BANE 031201560 First National Bank 011200321 A Wachovia 053000219 lt gt QuickFind e Description A single bank one of its relationships and one of its statements are selected Expectation All records for the selected relationship that exist in the statement will be returned Entity Selection Banking Operational E is AMSOUTH BANK 062000019 al Ej i Bank OF America 121000358 iS Relationships H E 0693999999 RELATIONSHIP t I eo Statements gt 09 0 2008 ENE A 08 01 2005 08 30 2005 A oF foi f2005 073112005 06 01 2005 06 30 2005 05 01 2005 05 31 2005 Bank of Chesapeake 012566011 eS Bank of England MO 052000212 ee BLUE BOOK OF BANE PRICES 2004 20 lA COMMERCE BANK 031201360 te lt fn gt QuickFind ies leh i t y k 1 e Description A Relationship and a Bank unrelated to it are selected Expectation Nothing is returned Entity Selection barking Operational i AMSOUTH BANK 062000019 Ead S Bank OF America 121000358 ial L gt Relationships EA 0633999999 RELATIONSHIP c ee Statements E 1001 2005 10 31 2005 es 0901 2005 097302005 F gt 08 01 2005 08 30 2005 F gt 07 01 2005 07 31 2005 F gt 06 0
109. firm your choice Undo of relationship delete is not possible so use caution See the Banking Structure View for details on selecting a relationship Banking Structure EL A WE We A H AMSOUTH BANK 062000019 New gt i Bank OF America 121000358 ties Bank of Chesapeake 012566011 Ey Import Statement gt Relationships A Edit A 0700497535 RELATIONSHIP SUMMARY Ae 0700497534 West Coast Account JE Delete z a 300007164 East Coast Account H E Statements A Account QuickFind 4 Bank of England MD 052000212 A Mark Statement Deleting a Relationship 3 8 Creating a Detail Account To manually create a Detail Account select the Relationship Account that will be the parent and open the view or context menu Navigate to the New submenu and click Account for selected Relationship Banking Structure fy AMSOUTH BANE 062000019 one E Bank S Relationships Ban of 12121 RELATIONSHIP SUMMARY 2 Import Statement fictounk For selected TEETE TEE a Gi 41705459 THE ABC Company J Ee E Statements a S Creating a Detail Account 3 9 Editing a Detail Account To view or edit the information for a detail account open the Detail Account Editor from the Banking Structure View either by double clicking the detail account or by selecting Edit from the context menu Banking Structure Ea 7 e lA 4 AMSOUTH BANK 062000019 fue Bank OF America 12
110. first of the two rows contains the discrepancy detail message The second row contains the data for the report results columns This permits the review of discrepancy details while examining the pertinent column data Incorest Service Charge Discrepancies Account ABC Toys LLC 1333001724 has been changed a fee of 0 50 wah a per umi fee of 02 and a vwotume of 2 for service code D1 01 01 and bank coge B04 According to the SmarAnalysit nepotated fee aip for ihn cose the chanpe should have been 0 5 D2 i 2 0 gags mi oiT CRERTS POSTED OTHER O02 chessys OPEN bacoun ABC Toya LLC 13330017H has been charged a fee of 03 eth a per om fee of 05 and a volume of 13 for service code 01 21 00 and bank cose E2003 Accoding to the SmartAnalyss negotiated fee setup tor this coce ihe change should have been 4 4 0 9 s 13 0 B2003 i pi ga DEBITS POSTED OTHER O30 chessys OFEN Discrepancies By Period Report Results Data 4 3 5 Discrepancies By Type Report The Discrepancies By Type Report displays discrepancy records organized by type and banking entity Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria e Discrepancy types may be selected to narrow the results to the specified types e Discrepancy statuses may be selected to narrow the results to the specified statuses e A date range can be entered to narrow the results to the specified time period e Variance amounts can be entered to na
111. g a Manual Statement 7 2 1 Creating a statement from Bank Setup 7 2 2 Creating a statement from the latest statement in a Bank 7 2 3 Copying a statement 6 3 Viewing a Statement 7 3 1 Statement Structure 7 3 2 Save a copy 7 3 3 Print a statement 6 4 Editing a Statement 7 4 1 Impact on Discrepancies 7 4 2 Statement General Information 7 4 4 Import Logs 6 5 Processing a Statement 6 6 Deleting a Statement 7 Discrepancies 7 1 Discrepancy Process 7 2 Types of Discrepancies 7 3 Unsupported Discrepancy Types 7 4 Discrepancy Query 7 4 1 Entering Criteria 7 4 2 Viewing Results 8 4 2 1 Exporting Results 8 4 2 2 Auto Resolving Results 7 4 3 Discrepancy Details 7 4 3 1 Information Fields 7 4 3 2 Change History 7 4 3 3 Links 7 4 3 4 Adding Notes and Attachments to Discrepancies 7 4 3 5 E mailing Discrepancy Information 7 4 3 6 Updating Discrepancy Status 7 4 3 7 Assigning Discrepancy Responsibility 8 Fee Query Perspective 8 1 Fee Query Criteria View 8 2 The Fee Query Results View 8 3 Service Charge Comparison 9 Balance Query Perspective 9 1 Balance Query Criteria View 9 2 Balance Query Results 10 Comparison Codes 10 1 Creating Comparison Codes 10 2 Editing Comparison Codes 10 3 Deleting Comparison Codes 11 Comparison Code Families 11 1 Creating Comparison Code Families 11 2 Editing Comparison Code Families 12 SmartAnalysis RM 12 1 SmartAnalysis RM Enablement 12 2 SmartAnalysis RM Features 13 Security Manager Perspective 13 1 Security Con
112. ges The number of decimal places to display when displaying statement rate percentages amounts Overall decimal precision value overrides other precision settings The number of decimal places to display when displaying numeric data Setting this System Parameter will override the values for any other Decimal Precision System Parameters that may be set Number of decimal places for service charge volume amounts The number of decimal places to display when displaying service charge volume amounts Number of decimal places for service charge unit price amounts The number of decimal places to display when displaying service charge unit price amounts Number of decimal places for service charge total amounts The number of decimal places to display when displaying service charge total amounts Number of decimal places for discrepancy values The number of decimal places to display when displaying discrepancy values Number of decimal places for statement rate amounts The number of decimal places to display when displaying statement rate amounts Number of decimal places for balance amounts The number of decimal places to display when displaying balance amounts 6 Statements This section describes the various functions available to you for managing your statements e Import a statement into SmartAnalysis e Create a manual statement e View a PDF version of a statement e Editing the content of a statement e Processing a statement for discrepanc
113. he negotiated fees are created to best fit the service charges on the statement The consequence of this is that the negotiated fees created will reflect any inaccuracies contained in the service charges on the statement No rollback of baselined information is possible To request that the banking setup be fully baselined for the statement check the Produce complete baseline from this statement checkbox on the import wizard page Open imported statement in viewer Once the statement import process completes the statement viewer will render the statement as PDF to allow you to browse the newly imported statement If the imported file contained more than one statement multiple statement viewers will be opened 6 1 3 Finish Once the file is selected and the options are set click the Finish button This will begin the statement import process 6 2 Creating a Manual Statement There are 3 methods in which you can create a manual statement which are all are available from the Banking Structure View In each method all fees will not have the volume or total amount set e Create a new statement based on a bank in your bank setup e Create a new statement based on the latest statement for a bank e Create a copy of an existing statement in SmartAnalysis 6 2 1 Creating a statement from Bank Setup Select a bank and right click to choose this option This will create a statement based on the bank that you have selected The relationship and acc
114. he previous month Top Total Cost Service Charges Previous Month Service Code Bank Code Description Unit Rate volume A 10 04 00 RETO DEPOSITO ITE 4 0 2 000 0 35 05 24 Dazzi DRAW Dw M R 23 0 192 0 40 U2 21 20110 DIRECT PREWI O 1 33 049 0 05 01 99 O1533 INCOMING OVE Le 1 634 0 10 00 00 CHEOIO OFFICE DEPOS 1 0 1 953 0 t lt gt Top Total Cost Service Charges Dashboard Element 2 1 6 Top Volume Service Charges Dashboard Element Top Volume Service Charges Dashboard Element displays the top 10 service charges for the previous month by volume It is designed to inform the user of which bank services they are using the most Top Yolume Service Charges Previous Month Service Code Bank Code Description Unit Rake volume A 1000 48 Ro 003 CURRENCY FU 0 0 435 500 0 10 00 48 Ro 003 CURRENCY FU 0 0 202 500 0 100015 ROCoO1S DEPOSITED CU 0 0 103 250 0 501 20 Os541 INT POY ACHP 00 43 131 0 40 02 21 0110 DIRECT PREVI O 1 33 049 0 al lt gt Top Volume Service Charges Dashboard Element 2 1 7 Discrepancies Assigned To Me Dashboard Element Discrepancies Assigned To Me Dashboard Element displays the top 10 discrepancies by variance assigned to the current user It is intended to inform the current user of their highest priority discrepancies Discrepancies Assigned To Me Account Variance Discrepancy Type ha ABC Toys LLE 1333702305 Potentially Dormant Account ABC Toys LLE 1333702305
115. ht clicking the operational unit and selecting Edit from the context menu o By selecting the operational unit and selecting the Edit option from the view toolbar pa Operational Structure x Qe The Edit Operational Unit icon of the Operational Structure View toolbar 2 Enter the name of the operational unit Add Operational Unit Input the name for this operational unit BOSTON MARKET a _ The Save Operational Unit Dialog 3 Click the OK button Changing Hierarchy Of The Operational Structure Operational Units may be re ordered in the Operational Structure View by dragging and dropping To move an Operational Unit and all of its children to a new location select the Operational Unit and drag it to its new parent Operational Unit Please note that changes made in a view are automatically and immediately saved to the database 3 12 3 Deleting Operational Units To delete an operational unit follow these steps 1 Select the Operational Unit from the Operational Structure View 2 Select the Delete icon of the Operational Structure View toolbar or from the context menu RA Operational Structure X The Operational Structure View toolbar 3 Click the OK button 3 12 4 Assigning Accounts and Relationships to an Operational Unit SmartAnalysis supports drag and drop of Accounts and Relationships to Operational Units so you can easily configure your operational structure Assigning an
116. ice Charge Comparison feature of the Fee Query provides comparison of service charges showing percentage below above benchmark price i e bluebook or other designated bank price The Service Charge Comparison feature uses comparison codes to identify and match charges for comparison between banks To perform a service charge comparison follow these steps 1 Select the banking entities and query criteria to narrow the service charge results those that will be compared 2 Execute the query and filter the results to the level to be compared relationship or detail account 3 Select a single charge to be used as the baseline for the comparison Be sure the charges to be compared have comparison codes associated with them 4 Execute the comparison via the drop down menu the toolbar button or the right click context menu After processing the results will display in a dialog window Sample Source Data Source data for the comparison should be roughly homogenous meaning that the most effective comparisons will be those that involve similar types of services across multiple relationships or banks Alternatively similar charges for a single entity from different statement periods can be used to review a comparison of the charges over time Select a single charge to use as the sample charge in the comparison Charge Information Bank Code Service Code ABA Number Opuint Account Name A 00251 ia 17 00 First National O
117. ies e Deleting a statement 6 1 Importing 822 Files using the Wizard The primary method of introducing statement data into the SmartAnalysis system is via the EDI 822 Statement Importer This form of statement import supports most all EDI 822 versions SmartAnalysis will automatically process the file for discrepancies during each import process There are two ways to access the statement import wizard Open the wizard by clicking the statement import icon on either the general application toolbar or the banking structure view specific toolbar or view specific drop down Once the wizard displays use the file chooser to select the 822 file to be imported 6 1 1 Select a file Select the 822 file you wish to import 6 1 2 Statement Import Options Options Produce complete baseline from this statement Open imported statement in viewer Produce Complete Baseline from this statement SmartAnalysis 4 0 supports initial baselining of banking setup from an 822 file Baselining banking information is a useful way to create the initial setup for a new bank This is a powerful option with a number of significant consequences Baselining bank setup will create the bank relationship and detail account structure for the 822 imported as well as creating negotiated fees to match each service charge on the statement Any account or relationship on the statement will be added to the bank setup in the structure that the 822 statement specifies T
118. ing the mouse click once on an element to select it To Select All Elements of a List While working in a selectable field use CTRL A to select the entire contents of the field To Select All Elements of a List in a Contiguous Range Select the first element in the range using the left mouse button then while holding the SHIFT key select the last element in the list using the left mouse button To Select Many Non Contiguous Elements of a List Select each element using the left mouse button while holding the CTRL key To Unselect a Selected Element of a List Hold the CTRL key down and left click the selected element 15 4 Date Entry Dates can be entered two different ways e Manual entry in a Date Field e Dynamic Date Ranges 15 4 1 Date Field The date entry field is a text field used to manually enter dates A date may be entered in any of the following formats e mm dd yyyy e mm dd yyyy e mm dd yy e mm dd yy Using the Calendar Date Chooser As an alternative to manually entering dates the calendar date selector may be used to select a date Click the calendar icon E next to the entry field to display the calendar date selector EH Select a date x an fo 12 17 78 19 24 25 26 a ee The calendar date chooser Once a date is selected and the selector is closed ll the date will appear in the date entry field 15 4 2 Dynamic Date Ranges For reports and queries that use a date range SmartAnalysis supp
119. is used to retrieve Service Charge data 5 The results of the Fee Query are displayed in The Fee Query Results View at the right of the interface 6 Summary and subtotal data are visible at the bottom of the interface 8 1 Fee Query Criteria View The fee query criteria view is displayed on the far left of the interface The criteria view contains the sections used to organize the information that may be used to constrain the service charges returned as results of query Selecting Criteria Banking Entities or Operational Units Entity Selection Banking Operational ih AMSOUTH BANE 062000019 gt Relationships ea l i 1 RELATIONSHIP Statements igi Bank OF America 121000358 ats Bank of Chesapeake 0125660 i Bank of England MD 0520002 ats BLUE BOOK OF BANE PRICES 2 aig COMMERCE BAME 031201360 ait First National Bank 011200321 A Wachovia 053000219 lt gt QuickFind Entity selection criteria are standardized across the SmartAnalysis application Selecting banking or operational unit entities in the fee query is no different For more information on the behavior of the entity selection section please review the appropriate documentation See Entity Selection for details Date Range Date Range Select Dynamic Range Manually Set Range Quarter To Date Selecting a date range filter will constrain the results to those service charges that exist on statements whose dates fall w
120. ithin the date range specified See Dynamic Date Ranges Incoming Bank Codes 0000S CHECKS PAID rs OOO04 DEPOSITS o0021 ACET MAINT IF 00099 FDIC A55ESSMENT 00100 40 COUNT MAINTENANCE OO102 CHECKS P4ID DEBITS 00103 DEPOSITS CREDITS ANMAN TELEPHONE KIOTIFTCOATICN MATITERL Selecting incoming bank codes will constrain the results to those service charges that have incoming bank codes matching the selected incoming bank codes Incoming Service Codes 00 00 00 UNENC DEP RECON BRANCH DEP IT 00 0i 41 NEGATIVE COLLECTED BALANCE RT 00 O24 10 MEn COLLECTED BAL INTEREST CH 00 02 30 FDIC ASSESSMENT 00 03 35 CYCLE SERVICE CHARGE 0i 00 00 ACCOUNT MAINTENANCE 01 00 20 MASTER ACCOUNT MAIN TENGE 0100 F1 MFP RECON SUR ao INT MATTE Selecting incoming service codes will constrain the results to those service charges that have incoming service codes matching the selecting incoming service codes Charge Description Entering a charge description will constrain the results to those service charges that have descriptions matching the specified description The description entered will be compared in a case insensitive fashion Comparison Codes 00 00 00 Ledger Balance Average Met a 00 0001 Ledger Balance Average Positive 00 00 02 Ledger Balance Average Daily Posi 00 00 03 Ledger Balance Average Negative 00 00 04 Ledger Balance Average Daily Neg 00 00 05
121. k 3 3 Editing a Bank To view or edit the information for a bank open the Bank Editor from the Banking Structure View either by double clicking the bank or by selecting Edit from the context menu 3 3 1 The Bank Editor General Information Tab Basic information concerning a bank including name ABA number and contact information is entered on the Banking Information tab of the Bank Editor which is located in the bottom left hand corner of the Bank Editor Bank Information Contacts Authorized Associates Balance Mappings The Bank Editor General Information Tab 3 3 1 1 Required Information Required information for all banks includes the bank s name ABA number and reporting period General Information Marne AELATION SHIP SUMMARY Mumber 0149799999 Type Settlement Method Account is automatically debited Uperational Structure Unassigned Required Information 3 3 1 2 Address Information If known the bank s address information can be entered in the Bank Editor Address Information Address 939 Field Club Ad City Pittsburgh State PENNSYLVANIA ha ip 15238 County UNITED STATES Address Information 3 3 1 3 Additional Information It is possible to add additional contact information for a bank including the main and the customer service phone numbers and the website in the Bank Editor Additional Information Main telephone number Customer Service number Date Corporate
122. kes by internally controlling global updates to accounts and effectively communicating that information back to the banks including critical controls like signature authority SmartAnalysis RM is an optional SmartAnalysis module For further details on SmartAnalysis RM and how to become enabled contact your Chesapeake System Solutions Inc representative SmartAnalysis RM Features 12 1 SmartAnalysis RM Enablement After you ve received your SmartAnalysis RM enablement key from Chesapeake System Solutions Inc open the help menu from the left side of the menu bar A Smart nalysis Fie Edit view Window Help CA ft Banking Inl C7 Help Contents SmartAnalysisEx vnamic Help SE Search Send Support E mail Total Charges By Bank Enable SmartanalysishM About Smartanalysis SmartAnalysis RM Enablement Menu Item Enter your SmartAnalysis RM enablement key When a correct key is entered the Enable button is activated Click the Enable button to save the key Once correctly entered the key will be immutable and SmartAnalysis RM will be enabled for all users and all installations of SmartAnalysis Z SmartAnalysis RM Enablement Smartanalysis RM Key Enable Cancel SmartAnalysis RM Enablement Dialog 12 2 SmartAnalysis RM Features SmartAnalysis RM contains multiple new and exciting features These features include expanded contact types additional reporting capability and a wealth of new fields to store b
123. ll relationships must be assigned to the operational structure or they are otherwise placed in the Unassigned category To resolve this discrepancy assign the offending relationships to the operational structure If you do not intend to use the operational structure for reporting or security purposes it is suggested to turn off the operational structure system parameter 7 2 21 Unexpected Service Description SmartAnalysis generates this discrepancy when the statement account or relationship is showing a service that is not defined in the current bank setup in SmartAnalysis 7 2 22 Unknown Total Service Charge Description SmartAnalysis also generates this discrepancy when the relationship summary account contains a charge that does not appear in any of the sub accounts 7 2 23 Unusually High Service Charge Description SmartAnalysis generates this discrepancy to each service charge in the current reporting period that exceeds the maximum percentage change tolerance compared to the previous reporting period s service charge Resolution When this discrepancy is produced it is suggested that you compare the service charges from the previous month to the current month s statement Since this discrepancy is based on a tolerance assigned in the setup information it is typically a legitimate discrepancy If the discrepancy is a genuine high service charge contact the bank to resolve the issues However to eliminate unnecessary discrepa
124. llans AreaSt RELATIONS 7 00251 i 0000 1 00 wy escola OS 30002 14 Se RELATIONS U 00256 oi oo 6 00 if acct 053000214 RELATIONS oO 00700 Di 60 60 i400 Bank OF Amer 121000556 os RELATIONS o02z02 01 00 00 G7 Bank OF Amer 121000558 rmn RELATIONS 0 Sample Source Data Execution methods A number of methods are available to execute a service charge comparison for a set of results Select a single charge and use one of the following methods Toolbar button otal Units Total Cost Bank ABA Humber GpUnit tyr ee ia T 6 00 We Compare Like Charges To This Charge RE 0 00 I RE 10 00 14 00 Bank OF Amer 121000358 RE 74007 cs on Mme el OO Nee ee si ee ee oD a mr Context Menu a Ww Compare Charges Export Accounk Mame RELATIONS RELATIONS View menu Results The comparison results display the sample charge in the first highlighted row The Sample row includes the following information Bank Information The bank name and ABA number for the bank associated with the charge Account Information The account name and number for the account associated with the charge Statement Date The date of the statement that the charge was drawn from Charge Unit Price The unit price of the service charge Charge Volume The volume of the service charge Each subsequent row lists a comparison result for other matching charges in the fee query results The compared
125. lumes above a the threshold 3 9 2 4 4 Tiered Rate A tiered rate is a fee structure relating a per unit fee to an activity level Rate Details Lower Bound Upper Bound Rate Flat Rate Per Unit Rate Threshold Rate Tiered Rate validate Tiers Tiered Rate Entering a tiered rate To enter a tiered rate select the tiered rate radio from the left hand side of the rate detail section To add a tier to the table click the add button Click on each cell of the row to edit the values for the tier Repeat the process for each tier for the negotiated fee When finished entering tiers click the Validate Tiers button to evaluate the tiers entered and ensure the consistency of the data There are a number of rules that tiered rates must follow e The first tier must contain a 0 value as its lower bound e The tiers must be sequential without gaps in the coverage or any overlap 1 10 11 20 etc e Each tier must have a rate specified e The final tier must have a blank upper bound This signifies that the bound terminates at infinity Only the final tier may have this value 3 9 2 5 Change History Negotiated fees maintain an audit trail of changes made to the fee Each change is recorded when the relationship or detail account editor is saved The audit trail contains information about the time of the change the user who made the change and a record of the changes made The record of changes made includes the field title in
126. ly maps the negotiated fees created from that statement Manual Entry It is possible to manually enter Comparison Codes 10 1 Creating Comparison Codes To create new Comparison Codes follow these steps 1 Select the Comparison Codes option from the Edit Menu 2 Select the Add New Comparison Code link 4 Add Edit Comparison Codes Comparison Code New Code New Code dd new Comparison Code Code New Code US Display Name New Code Description Delete Save All Changes Cancel The Comparison Codes Dialog 3 Complete the form Code and description are required Code is required to be unique If desired you may assign this code to a comparison code family 4 Click the Save All Changes Button 10 2 Editing Comparison Codes To edit Comparison Codes follow these steps 1 Select the Comparison Codes option from the Edit Menu 2 Select the code to edit from the selection list 8 Add Edit Comparison Codes l x Comparison Code SC Total Service Charges Curent Pernod PL Average Positive Ledger Balance RRA DDA Balance Aesere AReguirement SC Total Service Charges Curent Pernod SE Service Charges Which Cannot Be Compensated by Balances Code New Code New Code Display Name Total Service Charges Current Period Total Service Charges Current Period Description Delete Save All Changes Cancel The Comparison Codes Dialog 3 Complete the form The c
127. mation Create Statement from Latest Statement Permits the user to create a statement in SmartAnalysis based on the most recent prior statement Edit Statement Permits the modify a statement in the SmartAnalysis Statement Editor Reprocess Statement Permits the user to reprocess an entire statement for discrepancies This is a particularly powerful authority to grant as reprocessing a statement has a number of repercussions that affect the discrepancies currently assigned to the statement See Reprocess Statement for further details Import Statement Permits the user to perform import of statement data into the application See Statement Import for further details on the feature secured by this authority View Statement Permits the user to create a rendered copy of the statement suitable for printing or electronic transmission in PDF format Create Copy of Statement Permits the user to duplicate a statement from within the Bank Manager Mark Statement GL Unexported Permits the user to alter the flag on the statement indicating whether it has been exported to the General Ledger Delete Statement Permits the user to delete an entire statement from the application including all accounts service charges balances and discrepancies This is a particularly powerful authority and should only be granted with caution View Operational Structure Permits the user to review and examine the operational structure View Unassigned Accounts Permits the user
128. menu bar and select the desired view from the resulting drop down menu The selected view will open within the currently displayed perspective Please note that some views are specific to a particular perspective thus potentially making the options presented in the View drop down menu different depending on what perspective is currently active 9 Opening Editors Editors are opened when a user selects an item to edit If an item is editable right click on it to display the context menu and select Edit In some cases you can also double click on an item to open it in an editor Editors will be opened in the main editing area on the right hand side of the SmartAnalysis application window 10 Resizing Views And Editors Both Views and Editors may be resized to fit your personal preferences Normal views may also be moved by clicking on the blue tab and dragging them to a new location Stand alone views and editors may not be relocated in this fashion Maximize a To maximize a View or Editor select the Maximize icon from the upper right hand corner Minimize Co To minimize a View or Editor select the Minimize icon from the upper right hand corner Restore To restore a maximized or minimized View or Editor select the Restore icon a from the upper right hand corner Manual Resize You can manually resize a View or Editor to any width or height by clicking and dragging on its border The Maximize Minimize and Re
129. mily follow these steps 1 Select the Comparison Code Families option from the Edit Menu 2 Select the Comparison Code Families to edit from the selection list P Add Edit Companson Code Families xj Comparnon Code Family 05 Lockbox Senmices Add New Family 5 05 Lockbow Serpe OF Meichan Card Sernaces 08 Purchasing Card Services Display Name ps 10 Depasilcey SeVICEs first itor Tee 13 Ps per Litsbursement Servaces a Member o RRA Codes All Available Selected bo 00 on Ledge Balance 0500 00 Wholesale Lock GO 00 0z Ledge Balance 05 00 01 Wiholesale Lock OO 00 Of Ledge balance 05 00 02 Wholesale Lock 00 00 04 Ledger Balance 05 00 03 Wholesale Lock Ti 02 04 MERCHANT EX 05 00 g Wiholesale Lock OG 09 3 OSCO SPECIAL 05 00 05 Wholesale Lock 05 01 16 LEX CHECK RE 05 00 oF Wholesale Lock 06 0327 Paroli Card Fun 05 00 10 Fetal Lock bio De 04 O2 Pavol Card Ing 0600 11 Retail Lockbox 16 04 03 Paoli Carding 0600 12 Retad Lock bere 16 04 04 Pascoll Card Ing 05 00 13 Fetal Lockbovs _ 06 04 10 Pavol Cand Pay 05 00 14 Feted Lock bance 06 04 20 Pawoll Card Stat 05 00 15 Retad Lock bux 0604 21 Pawol Card Stat 05 00 12 Fatal Lockboore 0605 00 Paoll Card Set 05 00 20 Wiholetail Lock 06 05 10 Pawoll Cand amp cc D5 00 21 Wihrole tail Lock 06 05 20 Pawoli Card FIN 05 00 22 Wihole tail Lack 06 05 30 Paoll Card Cus 05 00 2 VWihole tail Lock 06 05 40 Pawoll
130. mns Results Data Each bank returned for the report is displayed as a single row in the table Banks selected for the report which do not have data will not be present in the report output If any of the banks are missing data for the columns listed above the cell for that column in the particular bank s row will be blank Monthly Earnings Credit Rate Analysis for September 2005 Bank Of mes Sank of Lhesapesks Bank of England MD Whe Tipe earnlrege Cedi tale veost ore found wiih J banks adcounts z Hansa Frefage of Me alee E Seplayed Earnings Credit Monthly Rate Analysis Report Result Data 4 3 8 Services By Month Report The Services By Month Report displays service charges by month and banking entity The report may display relationship summary or detail account level charges Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria e Selecting to display Summary Charges will produce the report based on Relationship Summary level charges e A date range can be entered to narrow the results to the specified time period e Incoming Service Codes can be select to narrow the results to the specified service codes e Comparison Codes can be selected to narrow the results to the specified codes e Comparison Code Families can be selected to narrow the results to the specified family of codes Note When Comparison Codes or Comparison Code Families are selected and Rel
131. months Report Criteria e Banks may be selected to narrow the results to the selected banks e The report requires that the last month of data to be included be selected from the date drop down Sample A Earnings Credit Time Series Rate Analysis Report presents the rate information in an easy to understand and presentable fashion Time Series Earnings Credit Rate Analysis from November 2004 to October 2005 Ale mali peer ee ee elo eee feed ei a Bank ee ie Earnings Credit Time Series Rate Analysis Report Sample Columns Each row represents a single bank with the rate data extending from left to right At the far right is a summary column indicating the average rate over the period At the bottom of the report each column is averaged to produce an analysis of the overall rate across all banks for the month Nowember December January February August September Oclober ae sas ae aps Mah 2005 Apml2005 May 2005 June 2005 July2005 Sins are ams Perae Earnings Credit Time Series Rate Analysis Report Columns Rows For each bank in the report a single row is created For those months in the report results for which the bank has rate data an amount is entered in the cell For those months without data the cell is left blank When more than a single rate is listed for a bank a statistical average of the rates is displayed Earnings Credit Time Series Rate Analysis Report Data 4 3 7 Earnings Credit Monthly Rate Analysis Report
132. more information that you provide the more likely it becomes that we will be able to resolve your issue expeditiously cig Send E mail to Support x E mail information To Emartanalysis ichessus com o Subject SmarkAnalysis Support E mail Message Please include a description above of the steps taken that caused the problem Contact Information Name L SOS Emaii L SA Phon Loo SA Organization Note The application log fles will be attached to this e mail to assist Support in solving the problem Send Cancel The help support email form 3 Click the Send button What Changes to the SmartAnalysis Interface Would Make It Easier to Use The SmartAnalysis Team takes great pride in the new interface introduced in release 4 0 and we really hope you agree that it has made SmartAnalysis far simpler more intuitive and simply more fun to use We are very interested in hearing about your experiences with the new interface and in listening to your suggestions for improvements What Additional Executive Summary Dashboard Elements Would Make SmartAnalysis More Useful The SmartAnalysis team is very interested in either any changes you would like to see in the existing Executive Summary Perspective or in any additional summaries you would like to see become part of it What Additional Reports Would Make SmartAnalysis More Useful The SmartAnalysis team has worked hard to simplify the generation and output
133. n 0645 2005 Assigned To wes changed from gt Unasigned bo Kristin Any change made to the assigned user will be saved immediately An audit trail of the change will be added to the Change History section showing the previous and current assigned user 8 Fee Query Perspective The fee query provides an ad hoc capability to display service charges The service charges displayed may be easily constrained by selecting relevant criteria Banking entities operational units codes amounts and dates may be entered as criteria To execute a fee query select the relevant criteria and entities from the criteria view and click the Execute Query button Results of the query are displayed in the table to the right of the criteria Quick Look Guide paperen m E SmanAnalysis 4 mxi Ele Edt yew Wincom Hiei a Emiro biomi CETE query hanca Dumy y ape Query y Repat Manager i Ecdive Samary i i y Fee Query Criteria Fee Query Results h ne A Entity Sefection Charipe Informatior Banking Cpa ational Byk Code Serare Code Dengin Lint Cod Sebel Linde Total Cost fark AED hair CipLina ee OF bl LE Le fa al Of wh Of ACCT H i2 a0 i Ue APEA AH BANE Dorii Corporsbs APERAR H GARE PLS S i Cr Oo DE Oh Oe ACCT Gs Par Lino APCS DAN SS ope she a i r E E Ee 18 oi i CHECKS 1 00 ioe 2400 AMBON H BARR GAZOOOES Corporais ae Oi ton OE OL 0 E i ee an 50 La OO EOUM HEARE DGTROOIS Corporste Lees Gk
134. n to analyze the allocations for validity Allocation percentages must sum to 100 in each table General Ledger Allocations General Ledger Allocations are used when the net amount of the calculation of the general ledger export is greater than zero General Ledger Export Data Credit Account n Debit Qccount Allocation Pet Custom Field 1 Cu eee 1lOOd 2123 9997 25 5575 5 eee F000 333 9998 25 2575 6 eee S000 233 9999 25 575 7 eee 4F000 3 3 1 0000 AS 51575 0 General Ledger Account Allocation Excess Earnings Credit Allocations Excess earnings credit allocations are used when the net amount of the calculation of the general ledger export is less than zero Earnings Credit General Ledger Data Credit Account Debit Account Allocation Pet Custom Field 1 CI ee2 1200 333 9997 100 00000 9999 9 Validate Allocations Excess Earnings Credit Allocations 3 9 6 Bank Confirmations Bank confirmations are used to record and manage the requests and notifications sent to the bank The bank confirmation interface permits the entry of data into the fields in order to note what type of request or notification was sent as well as the date when it was sent and when the bank responded West Coast Account 0700497534 53 fr 2 7 e Bank Confirmations West Coast Account 0700497534 Description Sent Date Confirmed Date Bank Confirmation Information Annual review oF account signers Request new signature card From bank
135. nce to provide a snapshot of the current state of your account analysis 2 1 1 Total Charges By Bank Dashboard Element The Total Charges By Bank Dashboard Element is a chart that displays the 5 largest total service charges by bank for the previous month It is designed to inform the user of the amount of fees paid to each of the largest banks with which they do business for the previous month If the system is configured for more than 5 banks all other banks will be summarized as a sixth slice in the pie chart Total Charges By Bank Previous Month Bank Of America 121000358 27 648 51 First National Bank 011200321 24 497 22 Bank of Chesapeake 012566011 17 900 13 Bank of England MD 052000212 5 133 2 Total Charges By Bank Dashboard Element 2 1 2 Overall Charges Dashboard Element The Overall Charges Dashboard Element is a bar chart that summarizes the total amount in service charges for all banks for each month in the previous 12 months It is designed to inform the user of the total amount in bank account fees paid each month Overall Charges Previous 12 Months 80 000 70 000 60 000 20 000 40 000 30 000 20 000 10 000 g Noy Dec Jan Feb War Apr May Jun Jul Aug Sep Oct Overall Charges Dashboard Element 2 1 3 Top Discrepancies By Variance Dashboard Element Top Discrepancies By Variance Dashboard Element displays the top open discrepancies by variance over the lifetime of the applicati
136. ncies of this type you can manually change the maximum service charge change tolerance in the fee structure setup for the defined service 7 2 24 Unusually High Total Service Charge Description SmartAnalysis generates this discrepancy for the total service charges in a relationship Summary account for the current reporting period that exceeds the maximum percentage change tolerance compared to the previous reporting period s total service charges for the same relationship summary account 7 3 Unsupported Discrepancy Types The following is a list of discrepancy types not currently supported by SmartAnalysis 4 0 e T Recs Import Account is Invalid e T Recs Volumes Do Not Match e T Recs Volumes Do Not Match e Volumes Do Not Exist e Volumes Do Not Match 7 3 1 T Recs Import Account is Invalid Description not available in version 4 0 SmartAnalysis assigns this discrepancy to each SmartAnalysis account mapped to a T Recs Import Account showing where the T Recs Import Account cannot be found This may result from a deleted account in T Recs This must be corrected before SmartAnalysis can validate the volumes for the account T Recs Transaction Type is Invalid SmartAnalysis assigns this discrepancy to each SmartAnalysis account mapped to a T Recs Import Account showing where the T Recs Transaction Type cannot be found or is not assigned This may result from a deleted transaction type in T Recs This must be corrected before SmartAn
137. ncludes the name title department email address and phone numbers of the bank representative s Of these it is required to have either the name email phone or fax number Primary Information Mame Calvin Hobbes Tithe Account Representative Email chobbestusbank com Department Customer Service Phone Number 800 555 9755 Alt Phone Number Fas Number Mobile Number Primary Information 3 3 2 2 Address Information The Bank Editor Contact Tab also provides an area to enter the contact s address information Address Information Address City State Ip Country Address Information 3 3 2 3 Specialized Information Contacts have two forms of Specialized Information Contact Types and Notice Required Contact Types categorize bank representatives These categories are entirely arbitrary and are defined by SmartAnalysis users Notice Required indicates the number of days same day 1 day or 2 day notice that the contact requires before a change to the banking relationship can be effected 3 3 3 Bank Editor Authorized Associates Tab Authorized Associates are employees of your organization that are trusted to make decisions about and take action on the relationship with a bank They may be entered for a bank by selecting the Authorized Associates tab of the Bank Editor Bank Information Contacts Authorized Associates Balance Mappings Bank Editor Authorized Associates Tab Authorized Associates are ente
138. ncy C Add Commer get Send E mail D Insert Attachment i em 7 Auto Resolve Auto Resolve allows you to resolve the selected discrepancy Add Comment Select this option to add a comment to the discrepancy detail Comments are viewed by all users Send E mail Select this option to email the discrepancy information to a valid user or email address All address fields must be completed for the email to be successful You must also have an email server configured in the Configuration Wizard accurately for the email to generate Insert Attachment Select this option to add an attachment to the selected discrepancy Attachments can be viewed by all users Edit Statement Select this option to open the actual statement associated with the discrepancy This opens the statement editor so you can make any necessary changes to the statement data or just to view the statement data 7 4 3 4 Adding Notes and Attachments to Discrepancies When viewing discrepancy details you have the option to add any notes or attachments to the discrepancy information For instance you may want to attach correspondence related to the discrepancy on the notes page so you can view this with the discrepancy information NOTE When a statement is deleted all associated notes and attachments are also deleted Attaching a comment 1 From the Discrepancy Details screen select the E aad comment ink 2 Insert the title and message in the note dial
139. ng comparison codes will constrain the results to those balances whose incoming balance information matches balance mappings set up at the balance s bank See The Bank Editor Balance Mappings Tab for more details comino Balance Information 00 00 00 Ledger Balance Average Met A 00 00 01 Ledger Balance Average Positive j 00 00 05 Ledger Balance Month End 00 00 10 Collected Balance Average Met 00 00 11 Collected Balance Average Positive 00 00 12 Collected Balance Average Daily Positive 00 00 13 Collected Balance Average Negative 0a 0A ig Collected Ralanre Awerane Daile Meaenabise lt IIl u Selecting incoming balance information will constrain the results to those balances whose incoming balance industry codes exactly match the specified codes 9 2 Balance Query Results The results view displays the data representing those balances returned by the execution of a query based on the criteria entered in the Balance Query Criteria View Heiane Indormation i ESTN ry f idle Chere roi Wi z Dabi Dace aut Savin Proce bimi Eades Ral Banh Hina AEA bored eer Gelin mi At 0 Ledger Balance iverna Hai Eim TE F 1 PELACPOHSHIP SUPA eta FFS 5 a WT Lo w 00 in Dietei Bainit Avie he waa SL ORE 25 RELATIONSHIP SUMP Liz ARDOU ee g 7 Cor TG 1 Doista iassa Spvenags Positives MMs BL chee RELACONSHIP MEAR MIZ H a PRS Co Each column in the results table may be sorted ascending or
140. ni Denni Aoodunt Balance Aeperve DSN 5 eke PELE EROnMS HS SRA SiS 1 e e Wischewis EALS D F Meman Lemet ort bss Hema MLO Joi RELAT TMAS MUA zt if ii Quicktime hate Am Caiiparion Codes 0000 00 Ledger Eiance Averace am 00 C001 Ledger Bre Area i Gt es Lace Eee Aare e eg ig Leger prsest Ayre E OH gt Like Be Baers joe OE Ledger Baars Monte 0 00 10 Collected fislece deri LR LE on Takarei aliro ieee e gl A Fa b Incoming Balance brif Emis Count il Ez Shere aa 1 Select the Balance Query toolbar button on the perspective toolbar to switch to the Balance Query Perspective 2 The Balance Query Criteria View is to the left of the interface This view contains many types of criteria used to narrow the results 3 Select Banking Entities from the Entity Selection Section Balances for the selected entities that match the specified criteria will be returned 4 The Display Results button is used to execute the query Data from the criteria section is used to retrieve Balance data 5 The results of the Balance Query are displayed in the Balance Query Results at the right of the interface 9 1 Balance Query Criteria View The balance query criteria view is displayed on the far left of the interface The criteria view contains the sections used to organize the information that may be used to constrain the balances returned as results of query Selecting Criteria
141. ns in the system including changes to discrepancies and to fee structures Removing users would compromise the integrity of such audit trails and is therefore not supported by the application 13 5 4 Assigning Authorities and Groups SmartAnalysis supports drag and drop of Authorities on to both Authority Groups and Users and also Authority Groups on to Users Assigning an Authority or AuthorityGroup to a User using drag and drop e Find the Authority or Authority Group in The Authorities View or The AuthorityGroups View e Click on that Authority or Authority Group and drag it to the User in The Users View e Click OK on the confirmation dialog that appears 13 6 The Authorities View The Authorities View contains the overall list of task security items in the application See SmartAnalysis Security Authorities to read more about each of the individual authorities Authorities j Access Balance Query d Access Discrepancy Query Access Executive Dashboard Access Fee Query Access Report Manager Access Security Manager Account QuickFind Add Comment to Discrepancy Add Operational Unit Assign account to another Relationship fecinn account Fo Oinerstional Inik The Authorities View DEDEDEDED ES ED EO Cm Cm cja Scroll up and down to see all the authorities Double click an authority to open The Authority Detail 13 6 1 The Authority Detail The Authority Detail displays the name and a short description of the authorit
142. ns that will be performed on each discrepancy Discrepancies that can be resolved Unresolvable discrepancies Z Incorrect Service Charge A Incorrect Total Service Charge H Incorrect Service Charge Incorrect Total Service Charge F Missing Account Incorrect Tatal Service Charge Summary A Missing Reserve Rate Missing Total Service Charge Missing Total Service Charge Missing Reserve Rate bie Service Missing Total Service Charge 3 Description of selected discrepancy Account Account 611001 has been charged a fee of 0 55 with a per unit fee of 0 11000 and a volume of 5 for service code 55 55 53 and bank code BS According to the SmartAnalysis negotiated fee setup for this code the charge should have Been 0 50000 0 10000 x 5 00000 ctionis to be taken For selected discrepancy Update the Negotiated Fee based on the statement charge Create a new Negotiated Fee based on the statement charge e Discrepancies that can be resolved From the discrepancies you chose to resolve these are the ones that can be auto resolved by SmartAnalysis By default they will all be checked which means they will be included in the auto resolution process If you decide at this point that you don t want to include one simply uncheck it from the list Use the Select All and Select None to change the checked status of the entire list at once e Unresolvable discrepancies These are discrepancies tha
143. nt pog DF LA 1U D OHER IA RELA ONSHEP SUMMARY a A Sectember 07 2006 0000 10 ODOT West Coast Account 1 820 200 40 00 00 10 BOBDOOT 154 Epa Dowel Aotcun 0 00 Go bo ig OT Oe S35 RELATIONSHIP SUMMARY at 380 41 E Deodar 01 ue BOG 10 OF DT 5 iest Coast Anconurd 282 Bo Ta 00 00 10 SIE0O0 164 Eas Cuasi Socoue 0 00 Dd 00 10 Dr DMT S RELATIONSHIP SUMMARY 232 821 74 Balances by Type Report Sample Columns The Balances by Type Report displays columns related to the balance information L Industry Code The industry code used to categorize the balance drawn from the statement See Industry Code Account Number The unique account number for the account to which the balance belongs Account Name The name of the account to which the balance belongs Balance Amount The dollar amount of the balance See Amount Industry Code Aomun Humber Balances by Type Report Column Header Groupings The Balances by Type Report groups the balance information returned in several ways 1 First as the name indicates the report is broken into a top level group by balance type Next the results are grouped by Bank Last the results are grouped by statement date Bank of Chesapeake 012566011 July 01 200 Balances by Type Report Groups Details The Balances by Type Report detail is made up of balance information resulting from the selected report criteria Each of these rows represents a single statement balance record If
144. ntact your sales associate Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria Sample The Signer Status Report presents the signatory status information for detail accounts within the banking entities selected as criteria Signer Status Report Added Date Removed Date Bank of Chesapeake 012565071 RELATIONSHIP SUMMARY OTRI487525 West Coast Account 0700407534 Inactwe Signes Frisian Smith CFO S00 000 00 1270S 11 40 AM TVS EI AM Acbve Signers Jason Yankws Treasury Manager 10 000 00 19 05 17 44 AM Manica Fokowski Head Accountant 1 000 000 00 11 6 08 amp 04 AM inactive Signer Stacey Gilmore Asst Treasurer 100 000 00 1270S 11242 AM TOT AOS 11 42 AM Krisen Smith CFO 300 000 00 TOTS 1 40 AM 10 27 05 11 40 AM Jason Yankus Treasury Manager 10 000 00 26 05 4 00 PM WANDS 4 00 PM Active Signers John Brown Jr Jr Accountant 10 000 00 TENS 8 05 AM Signer Status Report Sample Columns 1 Name The signer s name See the Editing Signers 2 Title The signer s occupational title See the Editing Signers 3 Limit The dollar amount that represents the maximum amount the signer is authorized for See the Editing Signers 4 Added Date The date upon which the signer was added to the account See Detail Account Editor Signer Assignment 5 Removed Date The date upon which the signer was removed from the account See Detail Account Editor Signer Assignment Name
145. ociate Detail account specialized information includes data that deals with account purposes locations and overall amounts and thresholds This data is stored for informational purposes Specialized Information Account Purpose Main AF Account 4g Balance Requirement 10 000 0 Dual Signature Threshold 25 000 0 Max Check Amount 100 000 00 Target Balance 5 000 0 Statement Cycle Date 5 5 4 O 4 Accounts 125 units repi 4560 San Diego Corporate 9999 Location Code 999119 AF vendor Account lt gt Manage Location Codes Specialized Information Fields Account Purpose An arbitrary categorization of the purpose that the account fulfills Average Balance Requirement An amount established between the customer and institution that allows the customer to offset fees Dual Signature Threshold The amount at which two signers are required to authorize a check Maximum Check Amount The maximum amount that may be written on a single check Target Balance The suggested day to day balance for the account Statement Cycle Date The day of the month that is the statement end period Location Code An arbitrary categorization of accounts by location Select those location codes to assign to the account Control Click to unselect items 3 9 2 Negotiated Fees Tab The Negotiated Fees Tab of the relationship editor contains information for the expected fees that define the baseline against which the discrep
146. ode and description attributes are required If desired you may assign this code to a comparison code family 4 Click the Save All Changes Button 10 3 Deleting Comparison Codes To delete Comparison Codes follow these steps 1 Select the Comparison Codes option from the Edit Menu 2 Select the comparison code to delete from the selection list 4 Add Edit Comparison Codes Comparison Code SC Total Service Charges Current Pernod Add new Comparison Code Code SO Display Name Total Service Charges Current Period Description Total Serice Charges Current Pernod Delete Save All Changes Cancel The Comparison Codes Dialog 3 Click the Delete Button 4 Click the Save All Changes Button Please note that Comparison Codes that are referenced by balances or b negotiated fees cannot be deleted until they are no longer referenced 11 Comparison Code Families Comparison Codes may be grouped into Comparison Code Families Arranging Comparison Codes into families makes it much simpler to narrow reports and queries to include only certain types of transactions such as lockbox related service charges Typically if your purchase price included the delivery of one or more code sets as part of the implementation these code sets will already be organized into families 11 1 Creating Comparison Code Families To create a comparison code family follow these steps 1 Select the Comparison Code F
147. og that is displayed 2 Enter a note to attach Contents 3 Click Save to save the note Attaching a file UJ Insert Attachment 1 From the Discrepancy Details screen select the E insert attachment 2 Select the file that you wish to attach using the file dialog Select a file to attach Save iri E Smart nalsis Rich Client do E biy Recent Documents hay Documents My Computer am Application icom I j2sdki 4 2_04 Dire Uninstall SmartAanalysis Rich Client Ea book jar E error log E jace jar E runtime jar ES smartanalysis exe E Smart nalysis_Rich_Client_Installlog log E Swe jar ais configwiz exe S svt awit win32 3062 dll f S swt win32 3062 dl My Network Places Save az type a ki Cancel 7 File name 3 Click Save to save the file Updated Change History After you have added a comment or attached a file the change history will be updated to reflect the change The entry for a comment will display the title and full note text The entry for an attachment will contain a link which you can click to view or download the attached file This example shows the result of adding both a comment and a file to a discrepancy Discrepancy Details Type Account Closed O OZ o variance Bank Code Assigned To Unassigned Service Code Status OFEN E Account RELATIONSHIP SUMMARY OS0003200200
148. omparison code used to perform queries and reports across banks with differing negotiated fees 3 6 2 2 Tolerance Information Negotiated fee tolerance information is used by the discrepancy processing system to define the bounds inside which discrepancies are measured or created Tolerance Information Allowable Occurrences 1 Discrepancy Tolerance Monthly Expected Volurne Volume Tolerance Charge Change Tolerance Tolerance Information Fields e Allowable Occurrences Indicates to the discrepancy processing system how many charges with this identical service code to allow when a statement is being processed A discrepancy will be created if this amount is exceeded e Discrepancy Tolerance Highest amount discrepancies can be before being identified as a discrepancy If entered this value overrides the discrepancy tolerance set at the account level For negotiated fees this tolerance is currently only used for Incorrect Service Charge discrepancies Monthly Expected Volume Defines the expected volume for this negotiated fee A discrepancy will be created if the actual volume is not within a certain amount specified in the Volume Tolerance of this value Volume Tolerance Percent the expected volume can deviate before being identified as a discrepancy This is only used if the Monthly Expected Volume field is also set Charge Change Tolerance Percent fees can vary month to month before being identified a
149. on It is designed to inform the user of the highest priority discrepancies which still require resolution Top Discrepancies By Yariance All Time Account Wariance Discrepancy Type Chaja RELATIONSHIP SUMMARY 0 6 976 3 Incorrect Total Service Charge Sum 9 OH Centers 7511932 2 969 0 West Coast Account 070049 2 741 5 RELATIONSHIP SUMMARY 0 991 4 DFELATTOMZHTO SUMMAD r OF A x im Earnings Credit Calculation Error Earnings Credit Calculation Error Unknown Total Service Charge DEF eal linbanan Tatkal Sarwirs Ch araa RD I Top Discrepancies By Variance Dashboard Element 2 1 4 Top Unit Rate Service Charges Dashboard Element Top Unit Rate Service Charges Dashboard Element displays the top 10 service charges by unit rate for the previous month It is designed to inform the user of the most expensive service charges for the previous month on a per rate basis Top Unit Rate Service Charges Previous Month Service Code Bank Code Description Unit Rake Volume A eo 11 20 OOo WEBACH SWS 375 0 1 0 15 00 00 CADSO0 EAST COAST E 225 0 1 0 40 01 00 01976 BAIL TRANSMIS 200 0 1 0 4001 OO 011976 BAIL TRANSMIS 200 0 3 0 45 00 20 OU409 INVESTMENT M 200 0 1 0 na lt gt Top Unit Rate Service Charges Dashboard Element 2 1 5 Top Total Cost Service Charges Dashboard Element The Top Total Cost Service Charges Dashboard Element displays the highest total amount service charges for t
150. on about the nature of a contact To manage contact types follow these steps 1 Select Contact Types from the Edit Menu 2 To add a new contact type select Add New Contact Type or To edit an existing contact type select it from the selection list 2 Add Edit Contact Types Select type to edit Technical Contact Add new Contact Type Short name Technical Contact Description This is the person to call regarding any probleme with the transmission or parsing of the oe file Save All Changes Cancel The Contact Types Dialog 3 Complete the form Name is required This process may be repeated until all changes are entered 4 Select the Save All Changes Button when you are finished 3 16 Account Types This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate Account Types are categories you may define to provide additional information about the nature of a relationship account or a detail account SmartAnalysis defines the following account types Disbursement Depository Concentration Lockbox ZBA Main Shadow Investment Third Party Investment Credit Line Parent and Sub Account You may expand this list as you require TO manage Account Types follow these steps 1 Select Add Edit Types from the Account T
151. or potential closing Resolution When this discrepancy is identified it is suggested that the account is investigated to see if it can be closed Accounts can sometimes have only one service charge however in most cases the account is dormant and can be closed to avoid any further unnecessary service charges If the account is a valid account simply ignore the discrepancy close it or filter it from the discrepancy results 7 2 19 Unassigned Account in Operational Structure Description SmartAnalysis generates this discrepancy when an account on a statement is not part of the operational structure and the operational structure system parameter is enabled Resolution This option is common upon importing a statement containing new accounts All accounts must be assigned to the operational structure or they are otherwise placed in the Unassigned category To resolve this discrepancy assign the offending accounts to the operational structure If you do not intend to use the operational structure for reporting or security purposes it is suggested to turn off the operational structure system parameter 7 2 20 Unassigned Relationship in Operational Structure Description SmartAnalysis generates this discrepancy when a relationship on a statement is not part of the operational structure and the operational structure system parameter is enabled Resolution This option is common upon importing a statement containing new relationships A
152. orporate RELATIONS 12121 bo100 01 O01 00 ELECTR 00S LH 16 00 AMSOUTH BANE 62000019 Corporate RELATIONS 2121 Each column in the results table may be sorted ascending or descending Click the title of each column to invoke the sort Clicking the column again will reverse the sort Summary Info Charge Count 14 Charge total 1 464 44 Selected Charges Count 1 Selected Charges total 45 00 The Fee Query results are summarized at the bottom of the interface Four values are displayed e Charge Count The total number of charges returned by the query e Charge total The sum total amount of the service charges returned e Selected Charge Count The number of charges currently selected in the table e Selected Charge total The sum total of the service charges currently selected Filtering by Level Show All Show Detail Account Charges Show Relationship Charges The Fee Query results may be filtered to display only charges at the relationship or detail account level Select Show All to return to the overall view of results Exporting We Compare Charges Export The Fee Query results may be export to CSV comma separated values To export fee query results select the export option from the drop down menu To export all results select the CSV Export All Fees menu option To export only those results that are selected click the CSV Export Selected Fees menu option 8 3 Service Charge Comparison The Serv
153. orts dynamic date ranges When a dynamic date range is selected the application calculates the appropriate start and end dates relative to the current date It is important to note that the dynamic range will be re calculated each time the report is executed This is especially useful for saved report criteria as a single report criteria can be used repeatedly without editing to generate monthly quarterly or annual reports Month To Date Quarter To Date Year To Date Previous Quarter Selecting a dynamic date range Supported Dynamic Date Ranges Month to Date This is a date range from the first of the current month up to and including the current date For example if the current date is October 18 2005 the calculated date range is from October 1 2005 through October 18 2005 inclusive Quarter to Date This is a date range from the first of the current quarter up to and including the current date For example if the current date is September 18 2005 the calculated date range is from July 1 2005 through September 18 2005 inclusive Year to Date This is a date range from the first of the current year up to and including the current date For example if the current date is October 18 2005 the calculated date range is from January 1 2005 through October 18 2005 inclusive Previous Month This is a date range spanning the entirety of the previous month For example if the current date is October 18 2005 the
154. otiated Fees Tab in the account editor From here set the T Recs Trans Type field for each negotiated fee to the same transaction type in T Recs that you would like to compare with Identity Information Incoming Bank Code 00 00 99 Incoming Service Code 00 00 99 Incoming Description Sample Fee Comparison Code T Recs Trans Type Setting a T Recs Transaction Type for a negotiated fee in the account editor Communicating with the SmartAnalysis Team We work hard here at Chesapeake System Solutions Inc to make a great product for our customers and we are very interested in your experiences both good and bad and in your suggestions for the continued evolution of SmartAnalysis This chapter enumerates a number of areas that we are actively working to improve in upcoming releases but please feel free to contact us about anything smartanalysis chessys com Reporting Errors Unfortunately the occasional problem slips through our rigorous quality control process and you will encounter a runtime error SmartAnalysis now includes a convenient method of reporting any issue you may encounter that will automatically include the log files for our review It is our sincere hope that this error reporting mechanism will facilitate the speedy resolution of the issue To access this feature follow these steps 1 Select the Send Support Email from the Help Menu 2 Complete the form All fields are required except for the cc field The
155. otiated prices defined in SmartAnalysis for 1000 units at 09 per unit is 90 00 A discrepancy is generated for the 10 variance This discrepancy is also created when a service charge found on the statement is not the same type as the fee structure it matches in your bank setup For example if we expect a flat fee and the statement shows a per unit charge this would be a discrepancy Resolution Often Incorrect Service Charge discrepancies are generated due to minor rounding discrepancies You can eliminate minor incorrect service charge discrepancies by assigning discrepancy tolerances at the account level A discrepancy tolerance is assigned at the account setup information window and reduces the number of less important or minor discrepancies each time a statement is processed for discrepancies Discrepancy tolerances assigned at the account level apply only to Incorrect Service Charge discrepancies 7 2 10 Incorrect Total Service Charge Description SmartAnalysis generates this discrepancy when the totals for a particular service across all accounts do not add up to the same total shown on the relationship summary account Tolerances can also be set in the bank setup information to monitor total service charge change amounts If the tolerance is exceeded this discrepancy is generated Resolution Often Incorrect Total Service Charge discrepancies are generated due to minor rounding discrepancies You can eliminate minor incorrect service ch
156. ount hierarchy for that bank will be replicated in the statement It will also create service charges based on the negotiated fees that you already have set up Every negotiated fee for a given bank account will have a fee based on it in the statement account For each negotiated fee set up in a bank relationship a related fee will be created for each statement account under that relationship 6 2 2 Creating a statement from the latest statement in a Bank Select a bank and right click to choose this option A copy of the latest bank statement will be created and opened in an editor This will yield the same result as if you selected the latest statement yourself right clicked and chose the option to Copy a Statement 6 2 3 Copying a statement Select a statement and right click to choose this option A copy of the selected bank statement will be created and opened in an editor 6 3 Viewing a Statement You can view the contents of a statement by using the Statement Viewer which can be accessed by right clicking on a statement in the banking structure view and selecting View Statement 6 3 1 Statement Structure The statement viewer presents the statement in a PDF format The PDF is organized into sections These sections are organized in a hierarchical fashion The structure of which is similar to the following e Entity Header o Relationship Header Rate Information Balance Information Service Charge Information Detail Account
157. ow beneath the File Menu This toolbar contains two generally useful functions Saving Editors and Import Statement The toolbar may be expanded or collapsed by clicking and dragging the handles located on either the left or right side of the toolbar B ye 6 3 View Specific Toolbars The view specific toolbars reside at the top of the view and provide one click access to common functions for the view The specific buttons are defined by each view The view specific toolbar also contains a drop down menu that can be accessed by the down arrow button present on the far right of the toolbar This drop down menu can contain additional commands related to the view Banking Structure a 7 Banking Structure View toolbar 7 Navigating Between Perspectives Navigating between Perspectives is done using the Perspective Toolbar which is located at the top of the interface All perspectives available are listed on the toolbar and can be accessed by left clicking on the button for the desired perspective 8 Opening Views When accessing SmartAnalysis some views are open by default These views are typically required during general usage of a given perspective There are additional views within the application that are not automatically displayed upon startup These optional views are not necessarily needed for everyday usage of the application To access one of these additional views left click on View in the main application
158. ple Comparison Code Families are defined with dueling tables In this case the Comparison Codes are the master list while the Comparison Codes that are members of the Family are the selected elements Dueling tables support four functions Remove All K Removes all currently included elements These elements become available as part of the master list The included list is now empty Remove Selected Removes all currently selected elements These elements become available as part of the master list Add Selected Adds all selected elements in the master list These elements become part of the included list Add All j Adds all remaining elements in the master list These elements become part of the included list The master list is now empty 15 8 Transaction Cutoff Times Transaction Cutoff Times are a feature of SmartAnalysis RM that record the time of day at which banks stop processing transactions of a certain type Transaction Cutoff Times are entered Using Editable Tables Transaction cutoff times consist of a Transaction Cutoff Time Types a time and time zone The format of the time is fairly flexible At the most basic level all that is required is an integer between 1 and 23 to specify the hour Values from 13 through 23 are interpreted as military time while values from 1 to 12 are interpreted as standard time PM It is possible to fully specify the time in the format of AM PM Again only the hour is required minute
159. populated it you enter both the Unit Price and Volume fields 6 4 3 3 1 8 Balance Requirement The balance requirement for this charge 6 4 3 3 2 Balances This table allows you to add delete and modify balances for the selected relationship or account Each row is required to have an Industry Code and Amount 6 4 3 3 2 1 Industry Code The industry code assigned by a bank to a balance 6 4 3 3 2 2 Description If the description for the selected industry code is available it is displayed here This is a read only field 6 4 3 3 2 3 Amount The amount for the balance 6 4 3 3 3 Rates This table allows you to add delete and modify rates for the selected relationship or account 6 4 3 3 3 1 Code The code representing what the type of rate 6 4 3 3 3 2 Description If the description for the rate code is available it is displayed here This is a read only field 6 4 3 3 3 3 Rate The rate value 6 4 3 3 3 4 Days in Month Informational only 6 4 3 3 3 5 Days in Year Informational only 6 4 4 Import Logs This page displays a table of all statement logs If the statement was imported from an 822 file those logs will be included Every time the statement is modified and saved a log will be created here to show the user and time the save occurred 6 5 Processing a Statement Right click a statement to choose the option to Process the statement If the statement is already processed you will be prompted with a message
160. possible to save the report criteria Please see Saved Report Criteria for details 4 2 1 1 Saved Report Criteria Saved Report Criteria allow users to specify criteria for a report once and subsequently to execute the report in a single step each time an updated version of the report is desired Coupled with Dynamic Date Ranges this provides a powerful means of generating consistent reports on a monthly quarterly or annual basis To save the criteria for a report follow these steps 1 Define the criteria and save 2 Give the criteria a suitable name 4 Edit Report Criteria Input the name for this saved criteria Incorrect Service Charge Discrepancies For Bank Of America Quarter To Date cancel The Saved Report Criteria Dialog 3 The Saved Report Criteria appears in the Saved Report Criteria Folder for the Report Type d Incorect Service Charge Discrepancies For Bank Of Am Report selection View S i Account Reports mye a T Balance Reports A Jy Discrepancy Report Incore Balances By Type Report poh Ce Saved Report Criteria cy t Contact Reports A Contacts 2 Bank Report a Discrenar eno Banking Operational ies Rank Of America California 07000 E EE a Sn By Pernod Rep Ly Bank Lf gree Calitornia 121 00025 gt Saved Report Criteria ioe JPMORGAN CHASE 021000021 hee lncorect Semice Charge ew For Bank OF Anmenca Quarter To Date Discrepancies By Type
161. rage Met O24 AVERAGE CLOSING LEDGER YTO PREVIOUS M 0000 13 Collected Balance Average Negative O41 AVERAGE CLOSING LEDGER PREVIOUS MONTH 00 02 30 FOIL assessment Delete Selected Mappings Save All Changes Cancel The Volume Confirmation Mappings Dialog 4 Click the Save All Changes Button 14 2 T Recs Volume Confirmation SmartAnalysis allows you to compare the volumes imported on an 822 statement to volumes imported into T Recs Discrepancies will be reported if the volumes don t match or if the T Recs Import Account does not exist When a new 822 statement is imported or reprocessed for discrepancies volumes will be confirmed with T Recs if you have done the following 1 Set the option in General System Parameters to enable T Recs Volume Confirmation Set the option to T Recs 2 Make sure you have imported the full month of T Recs transactions for the same month as the 822 statement you are importing reprocessing 3 For each account that you would like included open its editor and set the T Recs Import Account ID field with the matching account identifier in T Recs General Information Marre Sample Account Mumber 00011111111 Type Settlement Method Account is automatically debited T Recs Import Account ID 1234 Operational Structure Unassigned Setting T Recs import account ID in the account editor 4 After setting the T Recs Import Account ID for an account go to the Neg
162. ransactions of a certain type Transaction Cutoff Times are entered using the Using Editable Tables section Transaction cutoff times consist of a Transaction Cutoff Time Types a time and time zone The format of the time is quite flexible At the most basic level all that is required is an integer between 1 and 23 to specify the hour Values from 13 through 23 are interpreted as military time while values from 1 to 12 are interpreted as standard time PM Of course it is possible to fully specify the time in the format of H AM PM Again only the hour is required minutes seconds and the time of day designator are all optional If they are specified they must conform to the indicated format the colons and spaces are required and the time of day indicator must be either PM or AM This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 3 3 2 The Bank Editor Contacts Tab Detailed contact information for bank representatives is entered on the Contacts tab of the Bank Editor located in the bottom corner of the Bank Editor second tab from the left Bank Informatio Contacts E Uthonzed Associates Balance Mappings The Bank Editor Contacts Tab Contact information is entered with a selectable table 3 3 2 1 Primary Information The Primary Information i
163. re is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 3 18 Location Codes Location Codes are codes that you may define and assign to a Detail Account to identify the physical location s of the entity or entities to which the account belongs To manage Location Codes follow these steps 1 Select Manage Location Codes from the Location Codes text box of the specialized information section of the Detail Account Editor 2 To add a new Location Code select Add New Location Type or To edit an existing location code type select it from the selection list 4 Add Edit Location Types Select type to edit Brick and Mortar Add new Location Type Short name Brick and Mortar Description Save All Changes Cancel The Location Codes Dialog 3 Complete the form Name is required This process may be repeated until all changes are entered 4 Select the Save All Changes Button when you are finished This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 4 Report Manager Perspective Reports are a powerful and informative feature of SmartAnalysis designed to quickly an
164. red with a selectable table This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 3 3 3 1 Primary Information SmartAnalysis allows you to record the name title department email address and phone numbers for an authorized associate Primary Information Marnie New Associate Title E mail Department Phone Humber Alt Phone Number Fax Number Mobile Number Primary Information This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 3 3 4 The Bank Editor Balance Mappings Tab Balance Mappings equate the incoming balance information from a bank with the SmartAnalysis Comparison Codes This allows SmartAnalysis to perform meaningful comparisons of balances across banks in reports and queries even in a heterogeneous environment where different banks are using different code sets to identify logically equivalent balances Balance Mappings are directly analogous to Negotiated Fees Identity Information To enter Balance Mappings select the Balance Mappings tab of the Bank Editor Bank Information Authorized Associates Balance Mappings The Bank Editor Balance Mappings Tab Balance Mappings ar
165. rrow the results to discrepancies that fall within the variance amount range e Assignees may be selected to narrow the results to discrepancies assigned to the selected users Sample A Discrepancies By Period Report is made up of several parts These parts include the column header the groupings and the discrepancy results data Discrepancies By Type Charge Drscrption Variant Aasin To Bani Of Amenca 121005355 Oscrepances for ABS Toys LLG 133300724 May 01 2008 to May 31 2005 Accourt ABC Toys LUC 1333001724 has been charged a fee of 16 00 wih a per unit fee of 15 0 and a volume of Tipe samice code 01 00 00 and bank cade 00100 According to te SmarAnalysis negotiated fee setup for this cade fre charge should have beer 10 0 10 0 x 10 optog 01 00 m ACCOUNT MAINTENANCE Lpg OPEN Account ABC Toys LLG TIDI ha been chapped a fee of 6 13 wih a per unit fee of 03 and a voume of tO for senita code 11 01 00 and bani opde 82003 According to the SmarAnalysis negotiated fee setup for this code he charge should have beer 6 1 0 3 u 10 0 ano i T oa DESITS POSTED OTHER 0 25 OPEN ure 01 2005 tb Jue 20 2005 Account ABC Toys LUC 1333501734 hes been charged a fee of 0 50 wih a per uni fee of 0 2 and a volume of 2 for senace code 0101 01 mma bank code BID According to the SmariAmaisis megotated fee setup for this code the change shod have been 0 5 102 2 0 a2004 0101 pi CREDITS POSTED OTHER O O2chessys OPEN Account ABC Toys LUC 1
166. s depending on your Login Security System Parameters If you believe your account is disabled contact your SmartAnalysis System Administrator to correct the problem Password Change Required If your attempt to access the system displays the password change dialog you are required to change your password before proceeding This can happen for a number of reasons depending on your System Parameters If this is the case it should be possible to access the system once you have changed your password 2 Executive Summary Perspective The Executive Summary Perspective presents an informative overview of the data in SmartAnalysis and is the default perspective displayed when a user first accesses the application The information and displays on the Executive Summary Perspective called Executive Summary Dashboard Elements provide the user with an at a glance understanding of the current state of their account analysis The Executive Summary Perspective can be accessed at any time by clicking the Executive Summary button of the Perspective Toolbar lt gt Banking Information o Fee Query Balance Guey o Discrepancy Query o Report Manager E Executive Summary Selecting the Executive Summary Perspective from the Perspective Toolbar 2 1 Executive Summary Dashboard Elements Each summary graph or report on the Executive Summary Perspective is a dashboard element The Executive Summary Perspective presents several of these dashboard elements at o
167. s seconds and the time of day designator are all optional If they are specified they must conform to the indicated format the colons and spaces are required and the time of day indicator must be either PM or AM This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 15 8 1 Transaction Cutoff Time Types Transaction Cutoff Time Types are an indication of the type of transaction the bank stops processing at the specified time SmartAnalysis is delivered with several preconfigured Transaction Cutoff Time Types including Ledger ACH Lockbox and Wire Transaction Cutoff Time Types are fully configurable however and the user may add and edit them to suit their needs To select an existing Transaction Cutoff Time Types select one from the drop down in the editable table To enter a new Transaction Cutoff Time Types select Add Edit from the drop down in the editable table This feature is available as a part of SmartAnalysis RM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysis RM please contact your sales associate 15 9 Entity Selection When using any report or query the behavior of that report or query when different combinations of banking entities are selected sho
168. s Found Send Cancel 3 Click Send to send the e mail Updated Change History After you have sent the e mail the change history will be updated to reflect the change The entry for an e mail will display the subject of the e mail as a link Clicking on this link will allow you to view the details of the entire e mail message 7 4 3 6 Updating Discrepancy Status When viewing discrepancy details you can easily change the status of the discrepancy using the Status combo shown here Discrepancy Detalls 06 30 2005 The account OC0SOiS601 165 OG20S0002601 195 was found on the statement but has been marked as Closed in bank setup on 04 01 2005 GE Update by chesays on 0815 2005 Stabs was changed From OPEN to PENDING Update by chesays on 0415 2005 Aoioned To was changed from Urseiigredd to Erat Any change made to the status will be saved immediately An audit trail of the change will be added to the Change History section showing the previous and current assigned user 7 4 3 7 Assigning Discrepancy Responsibility When viewing discrepancy details you can easily change user assigned to the discrepancy using the Assigned To combo shown here Discrepancy Details The account OC0SOi601 165 OG20S0002601 195 was found on the statement but has been marked as Closed in bank setup on 04 01 2005 EE Update by cheaays on 0815 7004 Stabs was changed From OPEN to PENDING Update by chessys o
169. s a discrepancy If entered this value overrides the tolerance set at the account level 3 6 2 3 Boundary Information Negotiated Fee boundary information is used to provide charge type agnostic price information Boundary Information Base Fee Minimum Fee Maximum Fee Tolerance Information Fields Base Fee The initial fee that the bank assesses regardless of the nature of the negotiated fee Minimum Fee The minimum fee that will be charged for a service If the calculated fee is less than this amount this amount should be charged Maximum Fee The maximum fee that will be charged for a service If the calculated fee is greater than this amount this amount should be charged 3 6 2 4 Rate Information There are several varieties of rates available for negotiated fees Each rate type provides a different method of calculation for a negotiated fee Negotiated Fee Rate Types e Unit Rate e Flat Rate e Threshold Rate e Tiered Rate Selecting a rate type Rate Details O Flat Rate Per Unit Rate Threshold Rate Q Tiered Rate Rate Information To select a rate type and reveal its fields for input select a rate type radio button from the left hand side of the negotiated fee rate details section 3 6 2 4 1 Unit Rate The value for this type of rate is multiplied by the volume to produce the expected total amount Rate Details Per Unit Rate 25 0 Flat Rate Per Unit Rate Threshold Rate Tiered Rate
170. s the tolerance set at the account level 3 9 2 3 Boundary Information Negotiated Fee boundary information is used provide charge type agnostic price information Boundary Information Base Fee Minimum Fee Maximum Fee Boundary Information Fields e Base Fee The initial fee that the bank assesses regardless of the nature of the negotiated fee e Minimum Fee The minimum fee that will be charged for a service If the calculated fee is less than this amount this amount should be charged e Maximum Fee The maximum fee that will be charged for a service If the calculated fee is greater than this amount this amount should be charged 3 9 2 4 Rate Information There are server varieties of rates available for negotiated fees Each rate type provides a different method of calculation for a negotiated fee Negotiated Fee Rate Types e Unit Rate e Flat Rate e Threshold Rate e Tiered Rate Selecting a rate type Rate Details Flat Rate Per Unit Rate Q Threshold Rate Q Tiered Rate Rate Information To select a rate type and reveal its fields for input select a rate type radio button from the left hand side of the negotiated fee rate details section 3 9 2 4 1 Unit Rate The value for this type of rate is multiplied by the volume to produce the expected total amount Rate Details Per Unit Rate 25 0 Flat Rate G Per Unit Rate Threshold Rate Tiered Rate Unit Rate Entering a unit rate To enter
171. store functions may also be accessed via the context menu by right clicking on the tab of the View or Editor 11 Navigating Between Editors Across the top of the main editor area is the editor title bar The editor title bar presents tabs that represent the different Editors currently open It is possible to have several editors open at once The currently selected editor tab will be highlighted and the editor for that tab will be displayed Clicking on a currently unselected tab will highlight that tab and display its corresponding editor In cases where there are too many open editors to display all of the available tabs the remaining editors may be accessed by clicking the double arrow gt gt on the right hand side of the last tab and selecting the desired editor from the drop down menu Additionally various commands such as close close all and close others are available to manage the displayed editors These commands may be accessed using the context menu available when right clicking the editor title tab 12 Saving Editors Changes made in an editor will not be committed to the database until they have been manually saved within the application Editors can be saved by typing CTRL S by selecting the Save option from the file menu or azzal by selecting the save icon J If you attempt to close one or more Editors with unsaved changes the system will prompt you to save them Click OK to save 3 Save Resources L S
172. t follow these steps 1 Double click the report type in the Report Selection View 2 In the Report Criteria Editor enter the criteria for the report 3 Click the Execute button 4 2 1 Report Criteria Editor Report criteria restrict the report results to a subset of the data in SmartAnalysis generating a more focused and comprehensible report The exact report criteria available for a report type are defined by that report type While there is a great deal of overlap in the report criteria between reports there is no standard set of report criteria available on any and all reports The one exception to this rule is report output The report output criteria determine the format of the report result file and thus the application used to view the report All reports support two forms of output PDF Output PDF Output is the default report output type PDF reports will be opened with Adobe Acrobat which is required to be installed on all SmartAnalysis client machines PDF reports may be saved and printed using the controls in Adobe Acrobat CSV Output CSV Output files will be opened by the default viewer defined for these files on the SmartAnalysis client machine For a Microsoft Windows with Microsoft Office installed this is typically Microsoft Excel If no default viewer is defined on the client machine a save dialog will open prompting the user to save the file CSV files may be saved and printed using the controls in the viewer It is
173. t cannot be auto resolved so no action will be taken on them You can still select them and view their details below e Description of selected discrepancy When you select a discrepancy in either list its details will be displayed in this section to help you when you need to select the action to be performed e Action s to be taken for selected discrepancy All actions available for resolving the selected discrepancy will be displayed here One will always be selected by default You can select a different action simply by selecting the radio button in front of the one you want to execute on the selected discrepancy e Click Finish to begin the auto resolve process or Cancel to close the dialog without making any changes 7 4 2 2 1 2 Auto Resolve Results Discrepancy Auto Resolve Results Results Summary 11 Total 0 Errorts Discrepancies resolyed aa Resolved 5uccessfully Errors Incorrect Reserve Rate Incorrect Service Charge Incorrect Service Charge Incorrect Service Charge Incorrect Service Charge Incorrect Service Charge Missing Account Missing Reserve Rate Missing Reserve Rate Unexpected Service Unexpected Service Action taken Result Create a NEw Relationship level Negotiated Fee based Success Fon the statement charge e Results Summary Displays a basic summary of the auto resolve process This shows how many discrepancies were attempted to be auto resolved and how many did not comple
174. table is read only E Albert Finklehopper amp h se Signer Information lt Albert Finklehoppe Frimary Information Specialized Information Mame Albert Finklehopper Lirit 100 000 00000 Title Treasury Manager Signer Type Facsimile E mall jatinklehopper frogspace com Department Treasury Phone Humber 8664455151 Alt Phone Number Fas Humber Mobile Number Assignment Details _Account_ Added Date Removed Date The Signer Editor 3 Save your changes 3 14 3 Deleting Signers To delete a Signer follow these steps 1 Select the Signer in the Signers View 2 Select the Delete icon from the toolbar AJ 5 IQners WE x The Signer View Toolbar 3 Click Yes to confirm delete Please note that changes made in a view are automatically and immediately saved to the database 3 14 4 Assigning Accounts To Signers There are several ways to assign detail accounts to a signers using the Signers View All involve dragging banking entities or signers and dropping them onto the desired signers The options are Dragging A Results In Bank All Detail Accounts in the Bank will be assigned Relationship All Detail Accounts in the Relationship will be assigned Detail Account The selected Detail Account will be assigned All accounts in the dragged signer will be assigned to the target Signer i signer 3 15 Contact Types Contact Types are categories you may define to provide additional informati
175. tables used to display query results editable tables selectable tables and dueling tables In general all columns can be sorted by clicking the column title header for each column Switching between an ascending and a descending sort is done by clicking on the column header again 15 7 1 Using Editable Tables Editable tables allow a user to edit data directly inside a table in situations where the data can be displayed entirely inside the table To add a row to the editable table click the Add button To modify fields in a pre existing or new row simply click the cell in the row to edit make the necessary changes and press Enter to complete To select an entire row click the small empty cell at the far left of the table To delete a row select the entire row and click the Delete button 15 7 2 Using Selectable Tables A selectable table provides the user with a list of elements organized into rows and columns that summarize the detailed data The user may sort and scroll through the viewable elements Selecting an element populates the fields below the table with the entire detailed data that the row in the table represents To add a row to the table click the Add button enter the new data in the fields and then save the editor 15 7 3 Using Dueling Tables Dueling tables are used whenever there is a master list of available elements to select from and a resulting list of selected or included elements For exam
176. te successfully e Discrepancies Resolved o Resolved Successfully Displays a list of all discrepancies that were successfully resolved o Errors Displays a list of all discrepancies that could not be resolved successfully o Action taken When a discrepancy is selected in either the Resolved Successfully or Errors section this displays the action that was performed on that discrepancy o Result Displays the result of the auto resolution If it was successful there still may be some additional info in this message For errors this will display a message describing the problem e Click Close to return to the Discrepancy Query 7 4 3 Discrepancy Details The Discrepancy Details window displays the detail for the selected discrepancy and all available tools for resolution You have direct link to the associated account and fee structure as well as the option to manage resolution through assigning responsibility updating the status emailing details to the appropriate parties comments attachments and Auto Resolution if available Discrepancy Details Type Incorrect Service Charge Variance 10 00000 Bark Code z Assigned to Unassigned gt Serre AD J Status OPEN Charge Cescription Test fee 52 Data 10 31 2005 Aecount Account E 11001 Fee Etg 1 Description Account Account B 11001 has been charged a flat fee of 60 00 for service code 55 55 52 and bank code B2
177. tement See Unit Price Volume The volume recorded for this charge See Volume Total Amount The total price of the charge See Total Price Services By Month Report Columns Groups The Services By Month Report results are organized into several groups First the report is grouped by period Inside the period group the results are grouped by Bank and beneath that organized by Account The results themselves are ordered by neering Service Code BEA BF Ee RA CS Comuniicioraed 04 SOOO Tee Services By Month Report Groups Subtotals The Service Charge results are subtotaled at each level of grouping ree THE ip oe eee 7 T pa Ja Chere Total er Beak o epider MO CSE A115 Ceapa Total tor iny IOO ainic Services By Month Report Subtotals Producing a summary level report 1 Select banking entities Banks Statements Relationships or Operational Units mt Bank OF America 121000358 ing Bank of Chesapeake 012566011 m Bank of England MO 052000212 E BLUE BOOK OF BANK PRICES 2004 2005 200320000 t COMMERCE BAME 031201560 i First National Bank 011200321 Wachovia 053000219 Services By Month Report Summary Sample Step 1 2 Select Comparison Codes to display or Incoming Service Codes etc Comparison Codes 00 04 41 Compensating Balance Requirement Credit Facil 00 99 99 Undefined Balance and Compensation Informatic 01 00 00 Demand Deposit Account Maintenance g
178. that all SmartAnalysis users choose passwords that meet or exceed the internal security policy cil System Parameters New passwords must be different than any of the passwords stored in the old A J i1 10 password cache Please specify the number of old passwords to cache l Passwords will expire after expiration period Days 0 180 User Account will be locked after this number of tailed login attempts 10 Users will be locked if they have not logged on within this tine period D ays 0 180 Passwords can be the same as the usemame true inmum length for passwords B 1 75 Passwords must contain special characters false Login Security System Parameters The following features may be configured using the Login Security System Parameters New passwords must be different than any of the passwords stored in the old password cache Please specify the number of old passwords to cache If set SmartAnalysis will check the new password selected by the user during password change against a list of previous passwords for that user This setting configures the size of the previous password list Enabling this System Parameter prevents users from circumventing forced password changes by simply recycling the same password or small set of passwords Valid values range from 1 to 10 An empty value disables this security check Passwords will expire after expiration period Days Passwords that are changed frequ
179. that define the baseline against which the discrepancy process compares incoming service charges When carefully maintained the negotiated fee information provides accurate rate boundary and tolerance data The more accurate the negotiated fee setup is the more effective SmartAnalysis can be in helping you to identify and eradicate discrepancies Select the Negotiated Fees Tab at the lower left of the editor interface to display the negotiated fees for the relationship gt General Information Negotiated Fees Contacts GLExport Negotiated Fees Tab 3 6 2 1 Identity Information Negotiated Fee identity information is used throughout the application to match service charges to bank setup information This matching is important because it is the foundation of the discrepancy processing and reporting capabilities of SmartAnalysis It is critical to these processes that the negotiated fee setup identity information be well maintained Identity Information Incoming Bank Code AAADOL Incoming Service Code 01 04 00 Incoming Description ACCOUNT MAINTENANCE F255 Comparison Code 01 04 00 Account Anahsis Automated Maintenance 4 Identity Information Fields e Incoming Bank Code The identifying string assigned to a service by the bank e Incoming Service Code The identifying string defining the service based on the industry standard codes e Incoming Description The charge description e Comparison Code The cross bank c
180. the results Status Select the status types that you want to see in the results By default OPEN and PENDING will be selected for you Date Range Select a date range for the discrepancies to view Only discrepancies whose statement dates are within this date range will be included in the results You can use pre selected date ranges on the Select Dynamic Range tab or manually enter the dates on the Manually Set Range tab Variance Enter the minimum and maximum variance to only show discrepancies that fall within these limits You can choose to enter just a minimum or maximum or fill in both Assignee Select from the list of available users to narrow the results to only discrepancies assigned to the selected users Selecting the Unassigned entry includes all unassigned discrepancies Executing the Query Once you are finished click Display Results to view the results of the criteria you entered You can also double click items statements banks accounts etc to display the results for the selected item 7 4 2 Viewing Results After you execute a query the results will be displayed in the Discrepancy Results view Discrepancy Results AccOUNE Varlance Discrepancy Tyoe RELATIONSHIP SUMMARY 0693900000 27 269 76000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900000 27 146 01000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900000 23 434 39000 Incorrect Total Service Charge
181. tion Allocations button to analyze the allocations for validity Allocation percentages must sum to 100 in each table General Ledger Allocations General Ledger Allocations are used when the net amount of the calculation of the general ledger export is greater than zero General Ledger Export Data Credit Account n Debit Qccount Allocation Pet Custom Field 1 Cu eee 1LOO0 213 9997 25 5575 5 eee F000 3223 9998 25 oS 6 ee e S000 223 9999 25 575 7 eee 4F000 3 1 0000 25 5575 0 General Ledger Account Allocation Excess Earnings Credit Allocations Excess earnings credit allocations are used when the net amount of the calculation of the general ledger export is less than zero Earnings Credit General Ledger Data Credit Account Debit Account Allocation Pet Custom Field 1 CI ee2 1200 333 9997 100 00000 7999 9 Validate Allocations Excess Earnings Credit Allocations 3 6 5 Managing Detail Accounts Managing detail account assignment to relationship summaries is an important part of the bank setup management process SmartAnalysis requires accurate and current bank setup to precisely calculate discrepancies and reliably produce reports To manage the assignment of detail accounts between relationships SmartAnalysis provides Drag and Drop support for detail account elements in the Banking Structure View The steps for reassigning a detail account are 1 Select the detail account to reassign in the Banking Structure View
182. tructure View or from the Unassigned Accounts View to the operational unit to which they belong To open the Operational Structure View select the Operational Structure option from the View Menu Please note that you must be in the Banking Information Perspective to use this view Operational Structure x a SE ay A aO BALTIMORE DC METRO AREA as Ta PHILADELPHIA METRO AREA Fla PITTSBURGH METRO AREA Ls 020255165 Johnny Software Ine Pittsburgh Bank du Shawn Operational Structure View 3 12 1 Creating Operational Units To add an operational unit follow these steps o To add a top level operational unit select the Add Operational Unit icon from the view toolbar o To add an operational unit as a sub unit of an existing operational unit first select the parent unit from the Operational Structure View then select the Add Operational Unit icon from the view toolbar BA Operational Structure x Qe 4 oe fy Ei O The Add Operational Unit icon of the Operational Structure View toolbar 2 Enter the name of the operational unit Add Operational Unit Input the name for this operational unit BOSTON MARKET A The Save Operational Unit Dialog 3 Click the OK button 3 12 2 Editing Operational Units To change the name of an operational unit follow these steps 1 Open the Save Operational Unit Dialog o By double clicking the operational unit o By rig
183. ts are grouped by bank 3 Within the bank discrepancies are grouped by account 4 Finally the discrepancies are grouped by period Bank Of America 121000355 Decrepancies for ABC Toys LLC 13133001724 May 0i 2005 ia May 31 3005 Discrepancies By Type Report Groups Results Data The Discrepancies By Type Report results are displayed in two rows for each discrepancy result The first of the two rows contains the discrepancy detail message The second row contains the data for the report results columns This permits the review of discrepancy details while examining the pertinent column data May DI 2005 ts May 31 2005 Account ASS Toys LLC 1233001 724 has Geen charged a fee of 315 00 with a per uni fee of 15 0 and a volume of for service code 01 00 00 and bank cade 00100 According to the SmartAnalysis negotiated fee setup for ihis come the change stoold have beer 10 0 10 0 1D 100 Di 00 00 ACCOUNT MAINTERANCE 5 00 OPEN Account ABC Toys LLC 13330017 has been charged a fee of 4 13 with a per onit fe of 0 3 and a volume of 19 for service code 01 01 00 and bana code 22003 According to he SmarAnalsia negotaied fee setup for this code the charge should have been 6 1 10 3 10 0 B2003 D101 00 ERTS POSTED OTHER 0 85 OPEN Discrepancies By Type Report Results Data 4 3 6 Earnings Credit Time Series Rate Analysis Report The Earnings Credit Time Series Rate Analysis Report displays the earnings credit rate over the previous 12
184. tup is defined using the 822 file as a basis to create all bank relationship accounts and associated fee structures and a charge is found that doesn t contain enough pricing information to create either a tiered or threshold pricing structure based on that charge This discrepancy only appears during the first import to inform you that you need to complete the tiered and or threshold pricing information setup 7 2 15 Missing Reserve Rate Description SmartAnalysis generates this discrepancy when a rate matching the Federal Reserve requirement rate is not found in the account 7 2 16 Missing Total Service Charge Description SmartAnalysis assigns this discrepancy when a service charge is found for a statement account and no related charge exists for the relationship summary account 7 2 17 Multiple Service Charges Description SmartAnalysis generates this discrepancy when multiple service charges with identical defined fee structure have been applied to a relationship or account This may indicate you are being charged twice for the same service An allowable occurrence tolerance can be applied to a service charge if you anticipate more than one occurrence of the same service charge in the statement 7 2 18 Potentially Dormant Account Description SmartAnalysis generates this discrepancy when less than two service charges have been applied to an account or relationship in the statement This indicates the account should be reviewed f
185. uld be common and well understood The results of each combination of query should be predictable and clearly documented There are three levels of entity selection available e Bank e Account Relationship and DetailAccount via direct selection or Operational Units e Statement The general condition of these is that e When Banks are selected information for both the relationship and account will be returned e When an Account or any combination thereof is selected information for each selected Account relationship or otherwise will be returned e When a Statement is selected information for all accounts relationship or otherwise on the statement will be returned e When an Operational Unit is selected it is the functional equivalent of selecting all of the accounts relationship or otherwise that exist at any level beneath the operational unit The product of this selection in the form of accounts is added to the selected Account level entities The three levels are applied in conjunction with one another This means that when a Statement and an Account are selected the information present on the statement that pertains to the account will be returned Internal to the selection level the elements are members of a disjunctive construct The Bank level can generally be thought of as a shortcut to retrieve information for all accounts relationship and otherwise Samples e Description A single statement is selected Expectation
186. unt Que 1 726 83 Service Charges 6 3 2 Save a copy TO save a copy of the statement shown in the Statement Viewer click the Save as Copy icon in the upper left corner of the window 6 3 3 Print a statement To print the statement shown in the Statement Viewer click the Print icon in the upper left of the window to the right of the Save icon 6 4 Editing a Statement In the banking structure view find the statement that you want to edit Right click on it and select Edit from the context menu to open the Statement Editor 6 4 1 Impact on Discrepancies Once you edit a statement that has already been processed its current discrepancies become out of date Upon saving a statement the following steps are taken on its current discrepancies 1 All unclosed discrepancies without audit trails will be deleted 2 All unclosed discrepancies with audit trails will be marked Closed and retained 3 All closed discrepancies will be retained as is 6 4 2 Statement General Information The first tab in the statement editor allows you to modify statement level information 6 4 2 1 Bank Information This displays any bank related information included on the statement such as the bank name and address 6 4 2 2 Statement Period You can edit the dates that this statement represents You can either select a month and year from the combo boxes or manually select the dates by clicking on the calendar icon next to the date fields 6 4 2 3 Contact
187. unts within the Bank Manager Edit Relationship Permits the user to change relationship summary specific data within the Relationship Editor Delete Relationship Permits the user to delete a Relationship Summary account as well as all the negotiated fees detail accounts etc that it may contain This is a particularly powerful authority and should only be granted with caution Create Account Permits the user to create a detail account within the Bank Manager Edit Account Permits the user to edit Detail Account specific information within the Detail Account Editor Delete Account Permits the user to delete Detail Accounts and their negotiated fees and all other data This is a particularly powerful authority and should only be granted with caution Copy Fees From Relationship Permits the user to quickly copy the Negotiated Fee information from a relationship account down to the detail account level Account Quickfind The Account Quickfind authority permits users to utilize the account quickfind feature to expedite searching for accounts within the banking or operational structure Assign account to another Relationship Permits the user to reorganize the banking structure by reassigning detail accounts to other relationships Export GL Data Permits the user to create and export General Ledger data using SmartAnalysis Create Statement from Bank Setup Permits the user to create a statement in SmartAnalysis based on a selected bank s setup infor
188. upon which the account was closed Can be entered or modified on the Detail Account Editor in the Additional Information section Account Type The arbitrary categorization of the account s type Can be entered or modified on the Detail Account Editor in the Identity Information section Average Balance Requirement The suggested average balance for the account Can be entered or modified on the Detail Account Editor in the Specialized Information section Account Purpose The arbitrary categorization of the account s purpose Can be entered or modified on the Detail Account Editor in the Specialized Information section Target Balance The target balance for the account Can be entered or modified on the Detail Account Editor in the Specialized Information section Dual Signature Threshold The threshold at which multiple signatures are required to issue a check Can be entered or modified on the Detail Account Editor in the Specialized Information section Maximum Disbursement Amount The maximum total amount that can be issued on an individual check Can be entered or modified on the Detail Account Editor in the Specialized Information section Active signer information for the account is displayed below the specialized information Account Status For West Coast Account 0700497534 TIN EIN Number 125 4444 7895 Opening Date 01 01 2000 Account Type Disbursement Account Average Balance Requirement 10 000 00 Account P
189. ure associated with the selected discrepancy This allows you to manually change the fee structure if necessary or just to view the current defined fee structure associated with the discrepancy This option is not available for all discrepancies Change History Provides information on any changes made to the discrepancy including the date amp user responsible for the changes Changes include notes attachments status updates assignment and auto resolve activity 7 4 3 2 Change History Provides information on any changes made to the discrepancy including the date amp user responsible for the changes Changes include notes attachments status updates assignment and auto resolve activity Some history items such as e mail and notes provide a link so you can view the contents of the item 7 4 3 3 Links Discrepancy Details Type Incorrect Service Charge Veine 10 0000 riba ca Assigned To Unassigned E bekeee d atus OPEN l J Aceount Account B 11001 Charge Description Test fee 52 Dats Change History 10 31 2005 Fee ck ba Wel Account Account Bt 10013 has been charged a Flat fies of 60 00 for service code 55 55 52 and bank code B2 According te the SmartAnalysis negotiated fee sebup For this code the charge should have Geen S0 00000 Flat Fes a Auto Resolve There is no hishory For this discrepa
190. urpose Main AP Account Used for all general business payment our of the home office Targat Balance 5 000 00 Dual Signatures Threshold 25 000 00 Maximum Disbursement Amount 100 000 00 ai Type mt Ensin Smith Cro Facile 00 000 00 Jason Yankus Troasury Manager Manus 10 008 00 Total Number of Signert a Overall Account Status Report Summary 4 3 2 Balances by Type Report The Balances by Type Report displays balance records for accounts and relationships organized by the type of balance the bank and the date Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria e A date range can be entered to narrow the results to the specified time period e Comparison codes can be selected to narrow the results to the specified codes e Incoming Balance Information can be select to narrow the results to the specified balance information Sample A Balances by Type Report is made up of several parts These parts include the column information groupings and detail records Each of these components is explained below Balances By Type ingusiry Gode Aonmri hunier Banik of Chesapeake 012568011 Anoa hame Haaa ATAN july 01 2008 0d 06 12 OF OT S34 Wiest Coast Accourt 217 j fe Ba Oo OO 10 Zaa rie East Dasi Soccurt 0 00 GOOD if Of Dee Ss RELATIONSHPF SUVMARY air 515 58 August 01 2004 D0 OO 10 DORTE WES Coss Account a2 E DF 60 40 aJe tba Eas Coari Accou
191. y fy Access Fee Query E3 Authority Information Access Fee Query Authority Information User Warne Description The Authority Detail 13 6 2 The Authority Groups View The Authority Groups View contains the list of defined Authority Groups Authority Groups iji ip Admin A ih Balance Query hap Bank Setup Management S49 Discrepancy Query ip Executive Dashboard Sap Fee Query ip General User sin Operational Structure Management ay options p Report Manager 8 Security Wansoer ra Roe eee eee Se see ee ee ee The AuthorityGroups View Scroll up and down to see all the authority groups Double click an authority group to open The Authority Group Editor wv g Authority Groups iji Pis ip Admin Sip Balance Query May Bank Setup Management Sap Discrepancy Query ip Executive Dashboard Sup Fee Query ip General User sip Operational Structure Management ay options ap Report Manager 80 Security Wananer A A GI Ee Be The AuthorityGroups View To create a new Authority Group click on the drop down menu and the New item then select Authority Group Fill out the information in The Authority Group Editor and save To add Authorities to an Authority Group 1 Select an Authority from The Authorities View 2 Drag it to an Authority Group in The AuthorityGroups View and release 3 Confirm the operation on the dialog that appears 13 6
192. y proportional to its length Passwords that are very short are easily compromised This System Parameter configures the system to require all passwords to exceed a threshold Valid values range from 1 to 15 An empty value not recommended disables this security check Passwords must contain special characters Setting this System Parameter to true requires the user to select passwords that contain at least one non alphanumeric character Passwords that contain characters other than letters and numbers are more secure 5 3 Decimal Precision System Parameters Configures the decimal precision used when displaying numeric data 2 System Parameters x Number of decimal places for statement rate percentages 5 ee 5 Overall decimal precision value overrides other precision settings l 0 5 Number of decimal places for service charge volume amounts 5 U 5 Number of decimal places for serice charge unit price amounts 5 5 Number of decimal places for service charge total amounts 5 0 5 Number of decimal places tor discrepancy values 5 0 5 Number of decimal places for statement rate amounts 5 0 5 Number of decimal places for balance amounts 5 0 5 Decimal Precision System Parameters The following decimal precisions may be configured using the Decimal Precision System Parameters Number of decimal places for statement rate percenta
193. ype Selection List on the Relationship Account Editor or on the Detail Account Editor 2 To add a new account type select Add New Account Type or To edit an existing account type select it from the selection list 4 Add Edit Account Types Select type to edit Concentration Add new Account Type Short name Concentration Descriptions Concentration Account Delete Save All Changes Cancel The Account Types Dialog 3 Complete the form Name is required This process may be repeated until all changes are entered 4 Select the Save All Changes Button when you are finished 3 17 Account Purposes Account Purposes are categories you may define to provide additional information about the nature of a contact To manage Account Purposes follow these steps 1 Select Add Edit Types from the Account Purpose selection list of the specialized information section of the Detail Account Editor 2 To add anew Account Purpose select Add New Purpose Types or To edit an existing account purpose type select it from the selection list 4 Add Edit Purpose Types Select type to edit Uh Yeah Add new Purpose Type Ghort name Oh Yeah Description Save All Changes Cancel The Account Purposes Dialog 3 Complete the form Name is required This process may be repeated until all changes are entered 4 Select the Save All Changes Button when you are finished This featu

USER MANUAL - Chesapeake System Solutions

Contents

Download Pdf Manuals

Related Search

Related Contents