Home

SmartAnalysis User Manual

Contents

1. Proprietary and Confidential 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 Help gt Send Support Email 2 Complete the form All fields are required except for the cc field The more information that you provide the more likely it becomes that we will be able to resolve your issue expeditiously a Send E mail to Support E mail informa thon Subject SmartAnalyse Support Emad Message Please indude a desoupbon above of the siepi ken that caused the orodhem Contact Information hame Emal Prone Organization Note The app
2. Mame Calin Hobbes Title Account Representative E mail chobbestusbank com Department Customer Service Phone Number 800 555 9155 Alt Phone Number Fas Number Mobile Humber SmartAnalysis is a trademark of 70 Chesapeake System Solutions Proprietary and Confidential Primary Information Address Information The Detail Account Editor Contact Tab also provides an area to enter the contact s address information Address Information cy Address Information 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 Specialized Information Contact Type Notice Required Specialized Information Detail Account Editor Signer Assignment NOTE This feature is available as a part of SmartAnalysisRM If you have not purchased this module you will not have access to this feature If you are interested in purchasing SmartAnalysisRM please contact your sales associate Reviewing detail account signers General Information Negotiated Fees Contacts Signers GLExport Bank Confirmations Detail Account Editor Signer Assignment Select t
3. ESOL Uoeuuudl9 cor AMSJ O62000019 Cor AMSA nae Oar 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 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 code 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 g
4. Proprietary and Confidential 7 Select the Service Code to narrow the results to the specified incoming service codes 8 Select the Comparison Codes to narrow the results to the specified comparison codes 9 Select the Comparison Code Families to narrow the results to the specified comparison code family 10 Select Execute The Service Code Detail Report displays Signer Status Report The Signer Status Report displays the signers associated with each account A Signers Status Report l Entity Selection Banking Operational H i FHORGAN CHASE BANK N A 021000021 gi JPMORGAN CHASE BANK M A 071000013 H Afi WELLS FARGO BANK NLA 121000248 Tikini Report Output Type POF Output CS Gurpue Signers Status Report NOTE 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 SmartAnalysis is a trademark of 122 Chesapeake System Solutions Proprietary and Confidential Report Criteria e The report requires that you select at least one Banking or Operational entity from the Entity Selection criteria e The report requires that you select either PDF or CSV as your report Output Type Sample The Signer Status Report presents the signatory status information for detail accounts within the banking entities selected as criteria
5. 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 relationship level balances are returned by the report they are sorted to the bottom of detail group July 01 2006 00 00 10 OT DISET EJH Wesi Cossi Account 217 315 30 00 00 10 agpi 164 East Coast Aocount 0 00 00 00 10 OF DD4eT S35 RELATIONSHIP SUMMARY 217 515 50 August 01 2004 00 00 10 OF DO4ey EH Wiest Coast Account 242 180 4 00 09 10 G0e0007 154 East Coast Aooount 0 00 00 00 10 OF DO4eT 535 RELATIONSHIP SUMMARY 242 189 24 Balances by Type Report Detail Contacts by Bank Report The 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 that they are available a Contacts By Bank Report Criteria Editor Bank Selection PTORGAN CHASE BANK NLA O02 1000071 PHORGAN OF ASE BANE ALA 071000013 WELLS FARGO BON Aum 12 1000243 Report Output Type POF Output C CSV Output Contacts By Bank Report SmartAnalysis is a trademark of 99 Chesapeake System Solutions Proprietary and Confidential NOTE This feature is available as a part of SmartAnalysisRM 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 as
6. a person responsible for managing tasks associated with a specific bank This is a bank level option only This person would be named on the corporate resolution This person may or may not have signer responsibilities Signer an authorized representative of the company who signs company checks An organization would typically have multiple signers on each account Signers who are authorized on one account may not be an authorized signer on other accounts Some accounts may require more than one signer if the amount of the check is in excess of a predetermined amount Banks usually handle accounts with signer requirements manually Corporate Resolution a required document allowing representatives of a company to do business with a bank on behalf of the company Client Location Number Store Number Location Number This represents a number identifying a physical location within an organization company Each location would be associated with one bank account Corporate locations would be associated with multiple accounts Signature Card a legal document required by the bank displaying a signature of an authorized signer on an account Average Balance Requirement is determined by deducting the deposit float compensating balance requirement from the average balance over the statement period prior to interest calculation Dollar limits for check writing this is an up to amount If the amount were set at 1000 00 the signer wou
7. at Service Charge Comparison Viewer 2 loka i te Teo elie Shes le rr n ganire your Azanja wk WA J fies 6 a ea 4 5 ea anaa RELATIONSHIP BUMMARY Firmi National Bank 011200171 g a ea OTD Is 25 00 LBs RELATIONSHIP SUMMARY ia DODO TAD 0 0 g 30 00 Ts Wahai D000 ipii J 005 6 00 1 00 28 D0 9 00 RELATIONSHIP SUMMARY 2 erar Uke 5 ia ig Dee g ormin j iF F j Ai 70 ie Wachovia DES000219 A OTD V2005 po 8 00 B00 20 00 RELATIONS SUMMARY a 12100088 PONZ ti 14 00 Th Bark Of Amanca 121000258 ao ooong OTD 2005 po 0 00 10 00 RELATEOMGAIF TUMMAR y America 12000004 Orta 87 00 100 2200 Bank Of Amera i rem ey OTe 2 00 fae ba 00 F we 3 26 11 69in of 1 Hg Sample Comparison Results SmartAnalysis is a trademark of 173 Chesapeake System Solutions Proprietary and Confidential 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 criteria 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 select Execute Query Results of the query are displayed in the table to the right of the criteria Quick Look Guide Smarthnatyts Pie fOr yeh pnd pep b Ebtehg kioman Gree Quay Ki Entity Selection B
8. 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 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 account 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 SmartAnalysis is a trademark of 136 Chesapeake System Solutions Proprietary and Confidential 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 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 Viewi
9. If repeated attempts to access the system fail it may be that the SmartAnalysis System Administrator has not yet created an account for you 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 reasons 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 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 selecting Executive Summary on the Perspective Toolbar
10. Operational Structure Management 45 Options 835 Report Manager Secure Mananer The Authority Groups 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 Authority Groups View and release 3 Confirm the operation on the dialog that appears 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 Fee Query 6s m Authority Group Information Fee Query Authority Information Security Authorities in this group User Name Fee Query if Access Fee Query ie Change Columns in Fee Query results 5 Compare charges in Fee Query results Export results From Fee Query Access to Fee Query Description The Authority Group Editor 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 SmartAnalysis is a trademark of 197 Chesapeake System Solutions Proprietary and Confidential 2 T Recs Volume Confirmation Compare volumes imported on 822 statements with transactions imported
11. SmartAnalysis User Manual Version 6 0 Chesapeake System Solutions Inc Two Owings Mills Corporate Center 10461 Mill Run Circle Suite 600 Owings Mills Maryland 21117 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 sponsorship by the trademark owners of Chesapeake s products and services Copyright All Software Documentation and other Materials provided by Chesapeake are Copyright 1995 2011 Chesapeake System Solutions Inc unless otherwise stated All copyrights of third parties used with permission or under license Two Owings Mills Corporate Center 10461 Mill Run Circle Suite 600 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 S
12. 05 31 2005 igi Bank of Chesapeake 012566011 Bank of England MD 052000212 digg BLUE BOOK OF BANK PRICES 2004 20 i A COMMERCE BANK 031201360 ime QuickFind e Description A Relationship and a Bank unrelated to it are selected Expectation Nothing is returned SmartAnalysis is a trademark of 18 Chesapeake System Solutions Proprietary and Confidential Entity Selection Banking Operational igi AMSOUTH BANE 062000019 Pa Ti Bank OF America 121000358 Relationships EA 0693999999 RELATIONSHIP gt Statements 2 1001 2005 10 31 2005 2 0901 2005 09 30 2005 2 08 01 2005 08 30 2005 2 07101 2005 07 31 2005 J gt 06 01 2005 06 30 2005 J gt 05 01 2005 05 31 2005 4g Bank of Chesapeake 012566011 gt Relationships ea OFO04975355 RELATIONSHIP Statements ba QuickFind e Description A Relationship and one of its Detail Accounts are selected Expectation The records for both the Relationship and Detail Account are returned Entity Selection Banking Operational is AMSOUTH BAME 062000019 rn T Bank OF America 121000358 Relationships EA 0693999999 RELATIONSHIP La 1222014921 THE ABT Cor a 1222106874 THE ABC Cor La 1222110371 THE ABT Cor a 1222115482 THE ABC Cor Ca 1222123321 THE ABC Cor a 1222126596 THE ABC Cor a 1222205411 THE ABC Cor a 122220557 THE ABC Cor a 1222205614 THE ABC Cor a 1222211191 THE ABC
13. 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 Dent Cod ma ig m E a DEA 0 Eg he HE ee MELATIOASHP SAAJAT SED Se 1108 95 Hi AEDT WARTEN ACE Di 00 00 Senedd Depa Aceari Lereenece 76008 1 46 50 feck H Amerke 2100068 RELATIONS P SRA EST i gj rei ir DEPOSIT ORT Sue ACCT MANT Dt 00 00 Cesena Depam Actcurt bisirtenasce La 2E 20 i dea iisi ACCOUNT MNRTENANCE Di 00 00 Demani epee Accourt iari 156 135 2130 DAE Tate tor RELATOR aA DEI M450 rps Tare tor Berk Sf Amence E Mad Eag Tome ors w Services By Month Report Summary Sample Results Service Summary Report The Service Summary Report provides a breakdown of the bank service fees by service code bank code and or description To create a Service Summary report 1 Select the Report Manager Perspective 2 Click the to open the Service Charge Reports folder 3 Double click Service Summary The Service Summary Report Criteria Editor displays SmartAnalysis is a trademark of 116 Chesapeake System Solutions Proprietary and Confidential P I Service Summary Report Repor Criteria Edtor Entity Selschon Service Codes Banking Operatora DO 00 06 POSTIVE DATS A 1 2 CITIBANK N A 021000089 0
14. Signer Status Report Name Tite Limit Added Date Removed Date Bank of Chesapeake 012500011 RELATIONSHIP SUMMARY 0700487535 West Coast Account 0700 EE Inactive Signers Kristin Smith CFO S00 000 00 127 05 11 40 AM 116005 0 014 AM Active Signers Jason Yankus Treasury Manager 10 000 00 WIWI 17 44 AM Monica Rakowski Head Accountant 1 000 000 00 118 05 amp 04 AM East Coast Account 9080007 164 Inactive Signers Stacey Gilmore Asst Treasurer 100 000 06 10 27 05 17 42 AM 10 2 7705 11 42 AM Kristin Smith CFO 00 000 00 127 05 11 40 AM 10 27 05 11 40 AM Jason Yankus Treasury Manager 10 000 00 220 05 4 08 PM 6 26 05 4 08 PM Active Signers John Brown Jr Jr Accountant 10 000 00 11 6 05 8 05 AM Signer Status Report Sample Columns 1 Name Refers to the signer s name See the Editing Signers 2 Title Refers to the signer s occupational title See the Editing Signers 3 Limit Refers to the dollar amount that represents the maximum amount the signer is authorized for See the Editing Signers 4 Added Date Refers to the date upon which the signer was added to the account See Detail Account Editor Signer Assignment 5 Removed Date Refers to the date upon which the signer was removed from the account See Detail Account Editor Signer Assignment Name Title 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 as
15. Success on 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 complete successfully e Discrepancies Resolved e Resolved Successfully Displays a list of all discrepancies that were successfully resolved e Errors Displays a list of all discrepancies that could not be resolved successfully e 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 e 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 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 SmartAnalysis is a trademark of 160 Chesapeake System Solutions Proprietary and Confidential Discrepancy Details Type Bank Code Service Code Charge Description Dabe Desoiption C
16. 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 Select Start gt Programs gt Chesapeake s SmartAnalysis gt SmartAnalysis SmartAnalysis displays the login window ee eee 5 le es a a a Please enter your Username and Password to login to Smarb4nalysts Username chessys l Password Cancel Change Password SmartAnalysis Login Window 2 Enter your username and password NOTE Your password is case sensitive 3 Select 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 Invalid Security Credentials f The username and password supplied do not match any users in the system SmartAnalysis is a trademark of 25 Chesapeake System Solutions Proprietary and Confidential Changing your Password during Login Password Requirements are assigned at the System Parameters level The Minimum length for passwords can be set here from 2 15 lt 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 y
17. code B2003 According ic the SmartAnalyss negotiated fee setup for this code the change shouid have been 4 4 0 3 x 13 0 B2003 01 01 00 DEBITS POSTED OTHER 0 20 chessys OPEN Vanlance subtotal for type 4 37 Variance subtotal for acoount 037 Cescrepances for ABC Toys LLC 13337023905 Patentai Domani Account Desorepancees Only 2 service change s is are being levied on account ABC Toys LLCO 13397023065 This account may be unused review for polenta ciosing chess OPEN Variance subtotal for type 0 00 Variance subtotal for account 0 00 Discrepancies for THE ABC Company AP Account 1222100874 Incorrect Sere Change Orcrepancies Account THE ABC Company 1222108874 has been charged a fee of 4 00 with a per unit fee of 0 2 and a volume of 24 for service code 01 01 01 and bank code 82004 According to the SmartAnalyais negotiated fee setup for this code the charge should have been 5 8 0 2 x 24 0 20i ti 0i fi CREDITS POSTED OTHER 0 24 OPEN Warianoe subtotal fer type 0 24 Variance subtotal for account a Discrepancies for THE ABC Company 1222311486 Incerrest Sence Change Orecrepancies Account THE ABC Company 122221 1488 has been charged a fee of 2 17 with a per uni fee of 0 3 und a volume of 7 for service code 01 01 0D and bank coje RADD According to the SmanAnales negotiated fe setup for this code the change should have been 2 4 0 3 7 0 E2003 0160100 DEBITS POSTED OTHER 0 21 OPEN Variance subtotal for type 0 21 Vanano
18. displays 3 Enter the name for the What lf Bank created for this bank 4 Select OK The Create What If Scenario dialog displays Create What if Scenario Enter the new name for the What Scenario Fees L Create What If Scenario dialog 5 Enter the new name for the What If Scenario 6 Drag and Drop the Banking Structures that you want to compare into your scenario 7 Right click the What If Scenario and select Edit The What If Scenario Setup window displays SmartAnalysis is a trademark of 207 Chesapeake System Solutions Proprietary and Confidential fe What lf Scenario Setup What If Banks in Comparison Test WELLS FARGO BAME NA Wachovia Source Data t Relationship Sethings Select the source data for this What If Bank 93 Month Average 6 Month Average Latest Statement Select Statement M01 Fa008 1180 2008 Opthos Comparison Report Type Fees to include in comparison Serice Level Summary All Fees Structured based on source data Comparison Family Structured comparison options 00 Balance and C TORES 01 General Account Services C Show relationship summary 05 Lockbox Services O7 Merchant Card Services C Show account summary 08 Purchasing Card Services Cl Show fee details C Fees with the same waue C Fess wth a different values Fees not found on a what F bank What If Scenario Setup 9 Select your Source Data for each bank structure in your scena
19. existing 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 Types of Discrepancies 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 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 det
20. 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 SmartAnalysis is a trademark of 93 Chesapeake System Solutions Proprietary and Confidential Rate Details Oper unitate Threshold CY Tiered Rate Balance Based 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 e After Threshold Rate The rate that will be charged for volumes above the threshold Tiered Rate A tiered rate is a fee structure relating a per unit fee to an activity level Rate Details Flat Rate Lower Bound Upper Bound Per Unit Rate Threshold Rate Tiered Rate Balance Based Delete 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 proc
21. Add a Comparison Code Family Cupan Code Famiy BALANCE AND DORR SEA TION DROS ATION al Add New Family Comparison Code Famil 0 GENERAL ACCOUNT SERVICES 05 LOCKBOM SERVICES Display Mare 00 05 PAYROLL CARD SERVICES O7 MERCHANT CARD SERVICES Description BALANCE AND COMPENSATION INFORMATION Member Comparison Codes All Available Code Diamar Hane 00 00 9 POCE FEE 00 Of 3i TAGP 255 5S ENT IDS STATEMENT ITEM S28 Parol Card Maintenance Payrol Card AccountfCard Parol Card incpary Manier Cofected Balance Averag Payrol Card Enroiimert A 7 Codected Balanoe Averag Payrol Card Enroiment M Coected Balance Averag Fayrol Card leuance Be Coiected Balance Averag Payal Card esuance Int Co ected Balance Ayverag Paya Card Detuance Gu i Uncoieciesd Furce Laag Payrol Card Leauance Du Co ected Balance Gayligh Payrol Card Replacement Balance Mon nierest Baa Parol Card Replacement Balance Other Subject T Payrol Card Vale Losing Balance Other Mot Subj Payrol Card Value Loading Li Fioat Balance Average Payrol Card Value Adusi imesta Balance Payrol Card Value Adusi i Investaile Balance Postve Sore Grae 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 th
22. Alk i Open File Export tal Data Exit T 4 Import Statement Ckrl i 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 changes in the currently active editor Import Statement Opens the Statement Import Wizard See Importing 822 Files using the Wizard This function can also be accessed by selecting CTRL i Schedule Statement Import Opens the Scheduled Statement Import Wizard This function can also be accessed by selecting CTRL Alt i Open File Displays the Open File dialog where you can select the file that you want to open Export GL Data Opens the save file dialog to save the generated General Ledger Export spreadsheet Exit Closes SmartAnalysis SmartAnalysis is a trademark of 4 Chesapeake System Solutions Proprietary and Confidential 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 Edt View Window Help Comparison Codes Comparison Code Families Contact Types System Parameters 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 Cont
23. Ce Amga 17100055 oo 41 10 i mS 10 4 80 46 00 ANGOUTH BANK O62000019 Conporste ira fan of We Op 44 IG GS 14 Taso i 3 00 e a ARLE H EAE Dn oo OP Dor E l saih Dank of Engl mo oiod COES2 10 OL 1 WAULTD O95 TE SHSM ANGOLWTHEANK O62000019 Corporis L iy BLUE BOOK OF BAN RIES COED IO Ob 44 VAULT C 400 16 00 400 ANGOLTHEAME 62000019 Corporate fy COMMERCE mane 021 201 800 De ioa al WAAT N THE RLON AMBOUTHEANK DG2000019 Corporate re a ce opga iQ DL a4 VAULT O50 3400 766 00 AMBOUTHEANK OG62000089 Corporpbe E L ET E NN aige eC ieo FO AMBCUTHEANK 62000009 Corporate gi Wachee 00019 ri ree a0 fc 39 ACR a0 Ant gt iii AMROTH RAN AAS Crepneshe Diw 2 0D it ETI t n 25000 500 2 06 APECGUTH BAM Dicis Cirpo sta i Wiha F Datt Amige b Bank Codes b Sprvice Doki E Liane Desiri F Comparten Codes z Charge cout gi Charge toak leii da Seanad haa Gounk 5 Selected Charges bobm Sj a7 r no 4 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 window 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 i
24. Centers F District 2 f i i Distrig 3 tle Region C 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 Corporate ps 5 41705459 THE ABC Company 12121 RELATIONSHIP SUMMA 55 4rea Structure 73629050 RELATIONSHIP _ 2 Dene Ls 1481850 NY Centers L5 2030906 NH Centers L5 3326085 DE Centers iy 4102612 CT Centers i 4112749 MA Centers i 4159983 RI Centers F F e District 2 Ly S967 702 NJ Centers l E 5967717 P Centers al s QuickFind Closing The Application SmartAnalysis may be closed by selecting the Close Window icon x in the upper right hand corner of the application window or by selecting File gt Exit SmartAnalysis is a trademark of 22 Chesapeake System Solutions Proprietary and Confidential Chapter Two Using SmartAnalysis SmartAnalysis is a trademark of 23 Chesapeake System Solutions Proprietary and Confidential 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
25. Confidential 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 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 Display Results button Results of the query are displayed in the table to the right of the criteria Emanan ME He Edt Yew Wincow Help i E Baning Information C i Fee Query 9 P Aalance Query v CiscrepsncyQuey gy kapat Manager Esmu ummary Fee Query Criteria Fee Query Results y T Y E tial Entity Sehection Charge Information Beis Gretational Bark Code Serene Code Description lint Cost etalLints Total Cost Bank ABA Kiuerbser Opli j pe i PPE iti Di op oe AT A i200 4 2 00 APEGUTH BAKE Metina Corporatia 2 AMEGUEH BANE 062000015 E3 be ee Aad oo d OL OL OF CICcTR cs nt Lie ANDOUNIOANK OG2000089 Cu persbe aaa Wes oo 02 15 OL Of CHES O08 4 32 20 AMBOUTH BANK O62000009 Corporsts a oo 00 DE OL 01 iea 0 50 iag 6 AMSOUTH BANK 062000019 Corpore T oS aie Oo 40 10 OS 1 ETIS C Gog ior Lo On GPEC BAe Oi TUE Lorp me ip Bank
26. Department Phone Number Alt Phone No Email Contacts By Bank Report Column Header SmartAnalysis is a trademark of 100 Chesapeake System Solutions Proprietary and Confidential Groups The Contacts By Bank Report is grouped in the following way 1 Contacts 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 4 Bank of Chesapeake 012566011 Contact Name Title Department Phone Number Alt Phone No Email Jim McClellan Regional VP Regional Account 470 255 779a medelam bote cami 2 RELATIONSHIP SUMMARY 0700407535 Contact Name Tithe Cepariment Phone Number Alt Phone No Email Bll Bender Bank Rettionship 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 Discrepancies By Period Report The Discrepancies By Period Report displays discrepancy records organized by time period and banking entity SmartAnalysis is a trademark of 101 Chesapeake System Solutions Proprietary and Confidential a Discrepancy Report ReportCritenaEdto Entity Selection Status By PMORGAN CHASE BANK N A 021000021 ey E f JPMORGAN CHASE BANK NLA 071000013 Sa i H WELLS FARGO BANE NLA 12100024
27. Location Codes Negotiated Fees Tab Identity Information Tolerance Information Boundary Information Rate Information Per Unit Rate Flat Rate Threshold Rate Tiered Rate Balance Based Change History The Detail Account Editor Contacts Tab Primary Information Address Information Specialized Information Detail Account Editor Signer Assignment Adding a Signer Detail Account General Ledger Allocations Bank Confirmations Deleting a Detail Account General Ledger Export Exporting General Ledger Data Operational Structure View Creating Operational Units Editing Operational Units Changing Hierarchy of the Operational Structure Deleting Operational Units Assigning Accounts and Relationships to an Operational Unit Unassigned Accounts View Signers View Creating Signers Importing Signers Creating the Signer Import file Importing Signers Editing Signers Deleting Signers Assigning Accounts to Signers SmartAnalysis is a trademark of vii Proprietary and Confidential Chesapeake System Solutions Contact Types 83 Account Types 83 Account Purposes 85 Location Codes 86 Report Manager Perspective 87 Report Selection View 87 Executing a Report 88 Report Criteria Editor 88 PDF Output 88 CSV Output 88 Excel Output 89 Saved Report Criteria 89 Executing Saved Report Criteria 90 Editing Saved Report Criteria 90 Deleting Saved Report Criteria 90 Report Types 90 Closed Account Type 90 Overall Account Status Report 91 Report Criteria 92 F
28. Price or Volume The report can also be configured to display relationship level or detail account level data shown to the right of the sample Please keep in mind that this report can only access service charges on statement accounts with corresponding bank setup accounts NOTE In instances where the bank uses the same service code to represent more than one service you can select the unique bank code to distinguish the charge The Yearly Service Summary Report shows 12 months of data Use the ending date criteria to indicate when the end date should be The ending date is inclusive meaning if you select January 2009 the 11 months preceding January and January will be reported Sample The Yearly Service Summary Report provides a 12 month view of the trend of service charge values for a selected set of services The report summarizes the values at the bank level on the first page Following pages examine the records at either the relationship or detail account level dependant on narrowing criteria Layout The Yearly Service Summary Report displays data in 13 columns The first 12 columns represent the months displayed in the report from earliest to latest left to right The 13th column is the summary amount of the row SmartAnalysis is a trademark of 120 Chesapeake System Solutions Proprietary and Confidential Example data layout 1 Banking entity name Refers to the name of the account or bank the records represent 2 Ser
29. Rate defined 49 62 entering 49 62 TIN EIN Number 82 Tolerance Information 56 Toolbars general application 7 introducing 7 perspective 7 view specific 7 Top Discrepancies By Variance Dashboard Element defined 30 Top Total Cost Service Charges Dashboard Element defined 3 Top Unit Rate Service Charges Dashboard Element defined 3 Top Volume Service Charges Dashboard Element defined 3 Total Charges by Bank Dashboard Element defined 29 Transaction Cutoff Time Types 173 defined 6 entering new 6 selecting 76 Transaction Cutoff Times defined 76 39 T Recs Volume Confirmation 63 166 Twistie Sections SmartAnalysis is a trademark of 219 defined Type 56 Unassigned Account in Operational Structure 118 Unassigned Accounts View 7 Unassigned Relationship in Operational Structure 118 Unexpected Service 118 Unit Rate defined 45 61 entering 61 Unknown Total Service Charge 118 Unsupported Discrepancy Types 119 Unusually High Service Charge 119 Unusually High Total Service Charge 119 URL entry 4 Use BAI statistics for volume discrepancy calculation 100 User Editor 158 Username explained 27 Users 152 creating new 59 editing 159 managing 158 Users View 758 Using Editable Tables entering transaction cutoff times 39 Validate Allocations 66 Validation failures 70 Validation Dialog 0 View Menu functions 5 Views closing 71 defined 3 normal 3 opening S resizi
30. Rate Flat Rate 250 00 O Per Unit Rate Threshold Rate Tiered Rate Balance Based 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 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 time the calculation will use the before threshold rate Rate Details Tiered Rate Balance Based 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 SmartAnalysis is a trademark of 68 Chesapeake System Solutions Proprietary and Confidential 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 e After Threshold Rate The rate that will be charged for volumes above the threshold Tiered Rate A tiered rate is a fee structure relating a per unit fee to an activity level Rate Details O Flat Rate Lower Bound Upper Bound Rate Per Unit Rate Threshold Rate Tie
31. 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 alohanumeric character Passwords that contain characters other than letters and numbers are more secure Decimal Precision System Parameters Configures the decimal precision used when displaying numeric data SmartAnalysis is a trademark of 130 Chesapeake System Solutions Proprietary and Confidential 28 System Parameters X Humber of decimal places for statement rate percentages 5 5 Overall decimal precision value overrides other precision settings 5 Number of decimal places for service charge volume amounts z 0 5 Number of decimal places for service charge unit price amounts A 5 Number of decimal places for service charge total amounts 5 5 Number of decimal places for discrepancy values a 0 51 Number of decimal places for statement rate amounts z 5 Number of decimal places for balance amounts a 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 percentages The number of decimal places to display when displaying
32. about the bank and relationship to which the account belongs the account detail information and the signers associated with the account NOTE This feature is available as a part of SmartAnalysisRM If you have not purchased this module you will not have access to this feature SmartAnalysis is a trademark of 91 Chesapeake System Solutions Proprietary and Confidential If you are interested in purchasing SmartAnalysis RM please contact your sales associate 1 Select the Report Manager The Report Selection View displays 2 Double click Closed Account Report The Overall Account Status Report Criteria Editor displays Report Criteria 1 Select at least one entity from the Entity Selection criteria 2 Select the Report Output Type 3 Select Execute ry l 1 4 Overall Account Status Report gt Report Criteria Editar Entity Selection Banong Operators HEL JPMORGAN CHASE BANK N A 02 1000021 th Fy IPMOR GAN CHASE BANK N A OF 10000135 ay WELLS FARGO BANK HLA 121000248 Crack ind Report Output Type POF Output CSV Output Clear Criteria Overall Account Status Report SmartAnalysis is a trademark of 92 Chesapeake System Solutions Proprietary and Confidential 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 ar
33. added location code displays in the All Available column NOTE This feature is available as a part of SmartAnalysisRM 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 Manager Perspective Reports are a powerful and informative feature of SmartAnalysis designed to quickly and 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 selecting Report Manager on the Perspective Toolbar 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 defined for that report type SmartAnalysis is a trademark of 87 Chesapeake System Solutions Proprietary and Confidential Report Selection View Account Reports E i Audit Reports Ba
34. 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 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 SmartAnalysis is a trademark of 186 Chesapeake System Solutions Proprietary and Confidential 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 Security and the Security Manager Perspective SmartAnalysis application security is centered round some core Security Concepts and is managed by the Security Manager Perspective Security Concepts SmartAnalysis security is organized based on features and tasks within the SmartAnalysis system The main concepts 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
35. and saved on the system the account will move to the Closed Folder under the Relationship Level Folder This will enable you to display or hide closed accounts and only show open accounts e Operational Structure The operational structure view displays which operational unit to which this account is assigned Tolerance Information Account level tolerance information fields are used to define the bounds for different calculations in SmartAnalysis Tolerances Discrepancy Tolerance 9 Charge Change Tolerance oOo O O Volume Tolerance o Tolerance Information Fields e Discrepancy Tolerance Represents the highest amount that 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 Represents the 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 Represents the 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 Additional Information The additional information section contains the General Ledger Account ID the Tax Identification Number and Account Opening Date Additional Information Tax Identification Number ee Account Op
36. appears in the Saved Report Criteria Folder for the Report Type Report Selection View S A Incorrect Service Charge Discrepancies For Bank OF Arm H a Account Reports HA Balance Reports AP Discrepancy Report Incore B di Balances By Type Report nans gt Saved Report Criteria s Entity Selection 4 a Contact Reports E Contacts i Bank Report vy Operational Bar Bitswisintsla Bro H Rank OFA mernna California 071000 A PEA By Period Rep i z ii Bank OF America California 121000358 Boe Saved Report Criteria E ig JPMORGAN CHASE 021000021 Incorrect Service Charge e For Bank OF America Quarter To Date fl O10 Ei oe Discrepancies By Type Repol Hfi NORTHERN TRUST 071000152 BE T ee ee OAT i B Semice Charge Reports E itt WELLS FARGO BANE M A 127000248 H LS Signer Reports The Saved Report Criteria SmartAnalysis is a trademark of 89 Chesapeake System Solutions Proprietary and Confidential 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 right hand editor pane 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 conte
37. 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 Signers View Creating Signers Managing Signer Assignments Signer Status Report 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 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 e Account Additional Information e Account Specialized Information 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 Bank Specialized Information In
38. attach correspondence related to the discrepancy on the notes page so you can view this with the discrepancy information SmartAnalysis is a trademark of 162 Proprietary and Confidential Chesapeake System Solutions NOTE When a statement is deleted all associated notes and attachments are also deleted Attaching a comment 1 From the Discrepancy Details screen select E7 add comment The Enter a Note to attach dialog displays 2 Enter the title and message F Enter a note to attach Title Contents 3 Click Save to save the note Attaching a file UJ Insert Attachment 1 From the Discrepancy Details screen select E insert attachment The Select a file to attach dialog displays 2 Browse and select the file that you wish to attach using the file dialog SmartAnalysis is a trademark of 163 Chesapeake System Solutions Proprietary and Confidential n Select a file to attach Save In B Smark4nalvsis Aich Client ad E My Recent Documents Desktop My Documents My Computer _ hy Network Places C Application O com igsdki 4 2 04 dire Uninstall SmartAnalysis Rich Client book jar EES configwiz exe E error log EN emartanalysis exe E Smart nalysis_Rich_Client_Installlog log E swt Jar S svwt ayut win32 3062 dll swt win32 3062 dll File name Save as type Cancel 3 Click Save to save the file Updated Change History After y
39. been 6 1 0 2 x 16 0 B2003 0107 00 DEBTS POSTED OTHER 0 95 OPEN Discrepancies By Type Report Results Data Earnings Credit Time Series Rate Analysis Report The Earnings Credit Time Series Rate Analysis Report displays the earnings credit rate over the previous 12 months SmartAnalysis is a trademark of 108 Chesapeake System Solutions Proprietary and Confidential pa Time Series Eamings Credit Rate Analysis Report critena Ed Bank Selection JPMORGAN CHASE BANK N A 021000021 JPRORGAN CHASE RANE HAL 071000013 WELLS FARGO BANK HLA 121000248 Display data for 12 Months up to and including Month Petry ae Year 2011 w Report Output Type PDF Output O CSV Gutput mer Time Series Earnings Credit Rate Analysis 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 e You have the option of displaying this report in PDF or CSV output Sample An Earnings Credit Time Series Rate Analysis Report presents the rate information in an easy to understand and presentable fashion SmartAnalysis is a trademark of 109 Chesapeake System Solutions Proprietary and Confidential Time Series Earnings Credit Rate Analysis from November 2004 to October 2005 ihe mice meni ceed ae velo are Sead esn ae ec eet eye oe Pe ae a ie eye Earnings Credit Time Series Rate Analysis
40. complete 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 Review the details of each discrepancy Research the discrepancies Assign responsibility for each discrepancy Email discrepancy information to appropriate management and or bank personnel Add comments or attachments Export the list of discrepancies to a delimited text file to email to the appropriate management or bank personnel Resolving Discrepancies HINT Use the Discrepancy Auto Resolve feature when available to enhance the process of resolving discrepancies Identify the discrepancies from the discrepancy query 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 SmartAnalysis is a trademark of 145 Chesapeake System Solutions Proprietary and Confidential
41. credit amount is subtracted from the gross charge total Earmings Credit Rate Eamings Credit Amount Gross Charge Total Net Charge Total Earnings Credit Monthly Rate Analysis Report Columns 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 Eaminoas Credit Rate Eaminas Credit Amount Groce Charoe Tatal Net Chame Total Sank of Chesapeake oma 14 067 A0 Whe Muliipee earhlrege credit tale waived gre found within a banis aocouris a GatBica average of ihe rales E deplayed Earnings Credit Monthly Rate Analysis Report Result Data SmartAnalysis is a trademark of 112 Chesapeake System Solutions Proprietary and Confidential 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 A 4 Services By Month Report Report CritenaEdtor Entity Sebecbon Service Codes F f PMORGAN CHASE BANK N A 021000021 fede sea E ener i of Si JPMORGAN CHASE BANK N A 071000013 0100 21 ZERO BALANCE SUB ACCOUNT H WELLS FARGO BANK MLA 121000248 010100 DESITS POSTE
42. edit the comparison codes within the SmartAnalysis system This is a powerful authority permitting the user 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 Quer
43. 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 SmartAnalysis is a trademark of 16 Chesapeake System Solutions Proprietary and Confidential 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 All records for the specified statement will be returned Entity Selection Banking Operational aig AMSOUTH BANE 062000019 rn ist Bank OF America 121000356 H Relationships 2 Statements Ee 2 gt 09 01 2005 09 30 2005 J 08 01 2005 08 30 2005 2 0701 2005 07 31 2005 gt 06 01 2005 06 30 2005 2 05 01 2005 05 31 2005 iipy Bank of Chesapeake 012566011 Pai Bank of England MO 052000712 4ie BLUE BOOK OF BANK PRICES 2004 20 igi COMMERCE BANK 031201360 j t First National Bank 011200321 bd QuickFind 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 H Relationships gt Statements 2 1001 2005 10 31 2005 J gt 09 01 2005 09 30 2005 f gt 08 01 200
44. from one of the displayed email addresses 9 Enter the email address of the person that you would also like to receive this email in the Cc field if desired 10 Enter the Subject of the email 11 Enter your desired Message 12 Select Send 13 To insert and attachment select D Insert Attachment The Select a file to attach dialog display 14 Browse and select the file that you want to attach and select Save The attached file displays in the Bank Case Folder 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 icon PE or right click and select the Delete option from the context menu SmartAnalysis is a trademark of 45 Chesapeake System Solutions Proprietary and Confidential Archiving a Bank Banks or Accounts that are no longer relevant can be moved from the banking structure view into the Archive area To archive a bank account 1 Right click the bank account that you want to move into the Statements Archive folder 2 Select Archive The Archive view opens on the right of the Banking Structure window and displays the archived bank account Reversing the Archive Process Banks accounts can be returned from Archive to the Banking Structure To reinstate an archived
45. 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 data 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 C west Coast Account 0700497534 23 P a ts R E i ng A iD fsanaral l adaer West a ais AMSOUTH BANE G62000019 Banking Structure New H lt ipy Bank OF America 121000358 Bank of Chesapeake CL Import Staternen di Bank of Ch ke 012566011 C Import Statement Re lationshi i gt Relationships Z Edit T ea 0700497535 RELATIONSHIP SUMMARY gt 09 01 2005 09 30 2005 2 08 01 2005 08 31 2005 gt 07 01 2005 07 31 2005 E ip Bank of England MD 052000217 aes gt Relationships ae I 98001694 RELATIONSHIP suMMaRy Create copy of statement G 012020000717636 Consolidated 1 2 Ly 0700497534 West Coast Account HE Delete i a 080007164 East Coast Account an 25 S Statements au iaai 25 OO 1 2005 10 31 2005 p Mark Statement GL Unexported a Reprocess Statement Mark statement unexported Operational Str
46. of the discrepancies shown on the monthly summary statistics tab SmartAnalysis is a trademark of 127 Chesapeake System Solutions Proprietary and Confidential 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 Select Edit gt System Parameters to access the System Parameters dialog 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 General Logn Geomal Predson Enae amigs Credit cect Cau Sor Default Fee Query Results Account Enae operations siructure dscrepancy calculation Enable volume confirmation General System Parameters The following features may be configured using the General System Parameters 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 Default Fee Query Results Account You have the option to select from the following op
47. sample row includes the following information Bank Information The bank name and ABA Swift 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 rows include the following information Bank Information The bank name and ABA Swift 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 SmartAnalysis is a trademark of 172 Chesapeake System Solutions Proprietary and Confidential e Charge Volume The volume of the service charge e 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 e Cost vs Sample The absolute difference between the unit price of the sample charge and the compared charge in dollars
48. 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 The 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 Finish Once the file is selected and the options are set select Finish This will begin the statement import process Scheduling 822 Files for Subsequent Import into SmartAnalysis Many SmartAnalysis users may find it convenient to schedule statement imports for subsequent processing In particular users that receive more than a few statements on the same date receive statements on a predictabl
49. statement rate percentages amounis 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 amounis Number of decimal places for service charge unit price amounts The number of decimal places to display when displaying service charge unit price amounis 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 SmartAnalysis is a trademark of 131 Chesapeake System Solutions Proprietary and Confidential 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 P
50. the option to T Recs 2 Made sure that you have imported the full month of T Recs transactions for the same month as the 822 statement that you are importing reprocessing 3 For each account that you would like included open it s editor and set the T Recs Import Account ID field with the matching account identifier in T Recs SmartAnalysis is a trademark of 201 Chesapeake System Solutions Proprietary and Confidential General Information Marnie Sample Account Mumber 00011111111 Type Settlement Method 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 navigate to the Negotiated 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 What lf Banks and Scenarios The What If module answers the question What will happen to my service fees if change X The What lf Manager lets you review the impact of changing your banking structure adding changing or deleting banks accounts or services You can save modified What If Banks
51. 0 BALANCE AND COMPENSATION INFORMATION we ka The Comparison Codes Dialog 3 Select Delete 4 Select Save All Changes to accept the delete and save your change Note Comparison Codes that are referenced by balances or by negotiated fees cannot be deleted until they are no longer referenced 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 Creating Comparison Code Families To create a comparison code family follow these steps 1 Select Edit gt Comparison Code Families The Add Edit Comparison Code Families dialog displays SmartAnalysis is a trademark of 181 Chesapeake System Solutions Proprietary and Confidential Add Edit Comparison Code Families 2 Select Add New Family SmartAnalysis is a trademark of 182 Chesapeake System Solutions Proprietary and Confidential Add Edit Comparison Code Families Select Add a Comparison Code Family Comparison Code Family New Family New Family Comparison Code Family Details bk Name New andy All Avatla bhe Code Display Hae 00 00 Fa POncE FE
52. 0 00 11 Collected Balance Average Positive 0000 12 Collected Balance Average Daily Positive 0000 13 Collected Balance Average Negative na oA 14 Collected Balance Oversoe Daile Wleoskive Selecting incoming balance information will constrain the results to those balances whose incoming balance industry codes exactly match the specified codes 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 Sorting Balance Indormation Tiry Cocke Deania Data Cor 8 cena Nair Account Number Relais Ral Bank Nama ABA hunbar Opila aL i a 0i oi Ledger Balance ivars Mat tu Se E RELATIONSHIP METAR Lele aR Wmns E m oo io Dikata Haat Ate Het wW SLS RELATROMSHIP SLMMARS 17H BASS O82000039 Cir I 11 Dosta fasana iaraa Postres CUS Sil RELATIONSHIP SPFERT 21Z1 ie Ad TS oF 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 Balance Count 11 The total number of balances returned is displayed at the bottom of the interface SmartAnalysis is a trademark of 176 Chesapeake System Solutions Proprietary and Confidential Exporting CSV Export All Balances Export er Pelati PSY Export Selected Balances it
53. 00 20 Ipi DOPORALE MGT BAGO iD 20 20 Grams Cech 1J 26 93 yiJ Page TEP i ge E feel ddae T PEJE Pe Change TAM Soe BaT et Eegieee ODES EERE Services By Month Report Sample Columns From left to right the columns in the Services By Month Report are 1 Service Code Refers to the Incoming Service Code of the Service Charge See Service Code 2 Bank Code Refers to the Incoming Bank Code of the Service Charge See Bank Code 3 Description Refers to the Incoming Description of the Service Charge See Description 4 Comparison Code If a Comparison Code is associated with the Service Charge its information is displayed here 5 Unit Price Refers to the unit price of the Service Charge from the statement See Unit Price SmartAnalysis is a trademark of 114 Chesapeake System Solutions Proprietary and Confidential 6 Volume Refers to the volume recorded for this charge See Volume 7 Total Amount Refers to the total price of the charge See Total Price ae ee ee ERE ce ALT 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 Incoming Service Code M SSCCC DEA OF gaa AAD SC Comeniiciorted 4 SSC Tee Services By Month Report Groups Subtotals The Service Charge resu
54. 146 01000 24 434 59000 lemesan le 432 50000 492 50000 431 79000 175 00000 175 00000 ac 1 1000 Incorrect Total Service Charge Sum Incorrect Total Service Charge Sum Earnings Credit Calculation Error Incorrect Total Service Charge Sum Incorrect Total Service Charge Sum Incorrect Total Service Charge Sum Incorrect Service Charge Incorrect Service Charge Incorrect Service Charge 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 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 e Select the Discrepancy Results RELATIONSHIP SUMMARY 0693900000 RELATIONSHIP SUMMARY 0693900000 THE ABC Company 1465101757 RELATIONSHIP SUMMARY 0693900001 RELATIONSHIP SUMMARY 0693900001 RELATIONSHIP SUMMARY 0693900001 THE ABC Company INC 1465302000 THE ABC Company INC 1465302000 THE ABC Company 3751827393 q Total Count 87 Selected Count 0 27 146 01000 ed tat 39000 Ve aaa ale 492 50000 492 50000 431 73000 175 00000 175 00000 ag 11000 i option from the discrepancy results window Incorrect Total Service Charge Sum Incorrect Total Service Charge Su
55. 202 NSFPAID ITEM E Ei PNG Unit Test 123456789 00 02 30 DEPOSIT INSURANCE FEE y JPMOCRIGEN CHASE BANE Wafa Lio 1545 0 02 31 TAGP ASSESSMENT 2 i HK NAT h 04 00 02 40 Eamings Alowanoe ae eves WATIOMAL ASSOCIATION 042001039 0003 71 INVOICE FEE a Zh TO Bark 011202510 01 00 00 ACCOUNT MAINTENANCE H Pra TD Bank 026013673 0100 20 CROSS BORDER TARGET BALANCING wi E 3 THE HUNTINGTON NATIONAL BANK 044000021 2 U S BANK 202000021 ee ia ra US BAM A ee EE e Ei 00 gg P L dgj Fla Average fee we 2 yj WELLS FARGO BANK M A 171000246 00 00 01 Ledger Balance Average Positive 00 00 02 Ledger Balance Average Daly Posie 00003 Ledger Balance Average Negative 00 00 04 Ledger Balance Average Daly Negative 00 00 05 Ledger Balance Month tnd 00 00 06 POSITIVE DATS z TA tf alara Palana doverane Ra i gt Quickfind t Comparison Code Families Summary Charge Level Selection Show Summary Charges Grouping of Service Change Selection _ Group Charges By Description t Date Range Report Output Type G POF Output CSV Output 2 Excel Output Service Summary Report 4 Select the Banking Entity or Operational Entity Selection 5 Select Show Summary Charges to report upon charges at the relationship level If this is not selected detail charges will display on the report 6 Select Group Charges By Description to organize your services by Service Charge Description only 7 Se
56. 21 JPMORGAN CHASE BANE M A 071000013 WELLS FARGO BANE N A 227000248 Select a Month Month March w Year 211 Report Output Type e Excel Queput Monthly Summary Statistics SmartAnalysis is a trademark of 126 Chesapeake System Solutions Proprietary and Confidential Select the Bank s that you want to include Select the Month and Year to be included in the report Excel Output is selected by default Select Execute The File Download dialog display You may either Open and view the file or Save it to your workstation The Report Results display the following statistics which can be accessed from the appropriately labeled tabs e Balance Data e Discrepancy Data e Service Charge Data Example data layout Balance Data 1 2 3 4 3 Banking entity name The name of the account or bank that the records represent Avg Ledger Balance Gross Charges Represents the total monthly bank fees Earnings Credit Represents the total monthly earnings credit Net Charges Represents the gross charges minus the earnings credits Discrepancy Data 1 2 Banking entity name The name of the account or bank that the records represent Total Discrepancies Precautionary Discrepancies Economic Discrepancies Potential Overcharges Potential Undercharges The Service Charge Statistics tab displays the service charge families by Bank The Monthly Discrepancy Detail tab provides a breakdown
57. 248 Select a Month Meevthi Muench Year 2011 Report Output Type PDE Output O CSV Output Monthly Earnings Credit Rate Analysis 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 e The report requires you to select the Report Output Type You have the option of selecting PDF or CSV output Sample The Earnings Credit Monthly Rate Analysis Report displays earnings credit related information in a clear and easy to read fashion SmartAnalysis is a trademark of 111 Chesapeake System Solutions Proprietary and Confidential Monthly Earnings Credit Rate Analysis for September 2005 Eamings Credit Rate Eamings Credit Amount Gross Charge Total Net Charge Total Ahen Pr pe earninge Credit rale valued are found within a banks socoumiae a Sasa WveTage of ihe rales E danlayed 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
58. 3 505 56 00 04 12 Excess Deki Collected balance 0P 054 71 DO 02 49 Eamings Allowance 491 33 DO 03 31 Sepite Charges Balance Compensate 14 087 49 DO 02 44 Excess Deki Earnings Allowance Adjusted 13 596 16 00 00 07 Ledger Balance Average Posie 1 289 50 00 00 30 Float Balance Average 19 599 69 D0 03 0D Semice Charges Total Current Pernod 14 087 49 00 02 47 Deficit Eamings Allowance Due This Statement 13 596 16 DO 03 14 Service Changes Net Cue Ths Statement 13 596 16 DO 02 41 Excess Deki Earnings Allowance 13 536 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 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 Description Service Code Bank Code unit Fee Volume Total Fee Type ACH RECEIVED CREDIT 25 02 01 ACHO11 1 00 16 00 18 00 Unit Price x Quantity 1 001TEM CASHIER S CHECKS 7 00 EACH15 05 11 cusoi5s 7 00 6 00 42 00 Unit Price x Quantity CHECK SEQUENCE BASE FEE pi 03 20 STROEO 25 00 1 00 25 00 Un
59. 5 08 30 2005 gt 07 01 2005 07 31 2005 2 06 01 2005 06 30 2005 05 01 2005 05 31 2005 Bank of Chesapeake 012566011 gt Bank of England MD 052000712 aig BLUE BOOK OF BANK PRICES 2004 20 it COMMERCE BANE 031201360 gt First National Bank 011200321 5 bs QuickFind e Description A single bank and one of its relationships are selected Expectation All records for the relationship will be returned This is functionally equivalent to selecting only the relationship SmartAnalysis is a trademark of 17 Chesapeake System Solutions Proprietary and Confidential Entity Selection eae Operational i Ee ia 0693999999 RELATIONSHIP SUM gt Statements Bank of Chesapeake 012566011 ity Bank of England MD 052000212 BLUE BOOK OF BANE PRICES 2004 2005 att COMMERCE BAME 031201360 att First National Bank 011200321 4ies Wachovia 053000219 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 AMSOUTH BANE 062000019 Ay Ti Bank OF America 121000358 gt Relationships eA 06935999999 RELATIOMSHIF gt Statements 10 01 2005 10 31 2005 09 01 2005 09 30 2005 08 01 2005 08 30 2005 OF 01 2005 07 31 2005 06 01 2005 06 30 2005 2 05 01 2005
60. 5 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 Detal Account Acoount Information West 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 Rate Mutt pier Days In Pered Days in Year Reserve Requirement Rate Demand Depost Account 15 9 DOA 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 SmartAnalysis is a trademark of 138 Chesapeake System Solutions Proprietary and Confidential Semire Code Description Amount Waw 12 00 AM 00 00 02 Ledger Balance Average Net 1 289 50 00 03 S0 Semice Charges Debited 10 259 00 00 00 10 Collected Balance Average Net 221 383 61 00 00 11 Collected Balance Average Positive 271 383 51 DO t 20 Demand Deposk Account Balance Resenme Requirement a2 1338 96 00 00 47 inveclabe Balance 289 250 65 00 O4 00 Balance Equivalent Total Service Charge 6 29
61. 5 1 ae TURAK GIK DEP Gia Tom ee SNNN BELATIONGHIP SUMMARY 0 53i oerect Sei vce Chae ge CIK CPST Heed STD BAT p DASH FAE a BELA NOMSHIP SURAR 0 AZ Dreccrriec Sete vain Ci aie pe EURO DER IDA TA en BELATIOMSHIP SUMMARY 0 38 8 Incormect Serene Charge OUR OO DEPOT i B F E a ie a NDN PR RE SE CAPE BS SETI Potentially Dormant Aout amp 01 200 os E D A Tota Cai ga Selected Count coer N Ei rai Of Chee m L Discrepar CY Metalls Bare of Ergad HO aos COPS AHE Coe stl ee po leret Seven here YEN 4 OD H o a a a 01 LR Fa Bark Cada 4710 aj j h rere OE iig ll Auge Iy Uae Fha diiy j Account MELATIONSHEP JUHART Mnri acer Te A Coar es Cee ere a ea ee eer chee bee ot fe T th peer ah fem ar 6 and ecko 10 bee sere code 9000 11 ed bee code 4108 Serd bo the emt negotiated fee getup foe the coats thee Chee Heak bere bee GOO ath Change Denier COUN CERO TON TD Be pest Innere Aleseres Api Teori tran Charge Feie Total e Change Ceres mEt by chee me H LTH The oomigied her A rahad Pinks bian nici lt E Seed rp eee coe e 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
62. 6 Date Range Select Dynamic Range Manually Set Range Variance hiram Wanarce Mandmum Variance Asskpnee rasped ukin chessys Discrepancy Type Account Closed A Account Detad Mesng Service Change Extra Options Dupirate Account Eamings Credit Caloulaton Error Cl Show audit tais Earnings Credit Error Earnings Credit Setup Error Report Output Typ Incorrect Reserve Rabe rr eee a en ee Pe a _ 2 POF Output CCS Output Discrepancy Report Report Criteria e The report requires that you select at least one entity from the Entity Selection criteria e Discrepancy types can be selected to narrow the results to the specified types Discrepancy Type Account Closed Account Detail Missing Ambiguous Service Charge Duplicate Account Earnings Credit Calculation Error Earnings Credit Error Earnings Credit Setup Error Incorrect Reserve Rate p ee eee a Discrepancy Type e Discrepancy statuses can be selected to narrow the results to the specified statuses SmartAnalysis is a trademark of 102 Chesapeake System Solutions Proprietary and Confidential Y Status Status e A date range can be entered to narrow the results to the specified time period Date Range Select Dynamic Range Manually Set Range Date Range e Variance amounts can be entered to narrow the results to discrepancies that fall within the variance amount ran
63. 60 Ai First National Bank 011200321 Wachovia 053000219 QuickFind Entity selection criteria are standardized across the SmartAnalysis application Selecting banking or operational unit entities in the balance query is no different 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 SmartAnalysis is a trademark of 175 Chesapeake System Solutions Proprietary and Confidential Comparison Codes Comparison Codes 00 00 00 Ledger Balance Average Net A 00 00 01 Ledger Balance Average Positive j 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 Met mn 17 Collected Balance Awerane Brnicitive P LUI gt Selecting 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 Incoming Balance Information 00 00 00 Ledger Balance Average Met A 00 00 01 Ledger Balance Average Positive i 00 00 05 Ledger Balance Month End 00 00 10 Collected Balance Average Met 0
64. 7 Modify Dashboard Elements 34 Month Operand 172 defined 38 Monthly Expected Volume 46 59 Multiple Service Charges 117 Negotiated Fee boundary information defined 60 Negotiated Fee Boundary Information 47 Negotiated Fee Identity Information 58 Negotiated Fee Rate Types 47 60 Negotiated Fee Tolerance Information 46 defined 59 Negotiated Fees rate information 47 Negotiated Fees Identity Information 47 Net Positive Collected Balance 39 Notice Required defined 52 Number Entry Fields explained 4 Operational Structure 56 assigning accounts and relationships 7 Operational Structure View 69 opening 69 Operational Unit adding 69 creating 69 deleting 7 editing 70 Operational Units changing hierarchy 7 Overall Account Status Report defined 81 Chesapeake System Solutions Proprietary and Confidential Overall Charges Dashboard Element defined 30 Password changing during login 28 explained 27 PDF Output 79 Perspective Toolbar defined 7 Perspectives defined 3 navigating amp Potentially Dormant Account 118 Relationship deleting 54 Relationship Account Editor 43 general information tab 43 Relationship Editor contacts tab 50 negotiated fees tab 45 58 Relationship Summary enter an allocation 52 manually creating 42 Report Categories groupings 78 Report Category Folders groupings 78 Report Criteria defined 79 Report Manager Perspective accessing 78 Report Output Criteria
65. 8 ROCDD CURRENCY FU 0 0 202 500 0 1000 15 ROLO1S DEPOSITED CU 0 0 105 250 0 2001 20 03541 INT PAY ACHP 00 4a 1351 0 40 02 21 20110 DIRECT PREVI 1 323 049 0 i Top Volume Service Charges Dashboard Element Discrepancies Assigned to Me Dashboard Element Discrepancies Assigned to Me Dashboard Element displays the top ten 10 discrepancies by variance assigned to the current user Itis intended to inform the current user of their highest priority discrepancies NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title SmartAnalysis is a trademark of 30 Chesapeake System Solutions Proprietary and Confidential Discrepancies Assigned To Me Account variance Discrepancy Type Cha iad ABC Toys LLE 1333702305 Potentially Dormant Account 9 ABC Toys LLE 1333702305 Potentially Dormant Account ABC Toys LLE 1333001724 0 4 Incorrect Service Charge DEB ABC Toys LLE 1333001724 0 0 Incorrect Service Charge CRE ABC Toys LLE 13353001 F24 5 0 Incorrect Service Charge ACC lt iiil gt Discrepancies Assigned To Me Dashboard Element Configuring the Executive Summary Perspective The Executive Summary Perspective may be configured in two ways to suit an individual user s preferences The configura
66. A 021000089 88 248 78000 U S BANK 1273000848 76 255 08000 EWELLS FARGO BANK MLA 121000248 13 990 27000 ALL OTHERS Total Charges by Bank Dashboard Element 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 selected date range It is designed to inform the user of the total amount in bank account fees paid each month NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title Overall Charges Previous 6 Months 750 000 3 200 000 Overall Charges Dashboard Element SmartAnalysis is a trademark of 28 Chesapeake System Solutions Proprietary and Confidential Top Discrepancies by Variance Dashboard Element Top Discrepancies by Variance Dashboard Element displays the top open discrepancies by variance for the selected date range It is designed to alert the user to the highest priority discrepancies which still require resolution NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title Top Discrepancies By Yariance All Time i A
67. 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 structure associated with the selected discrepancy This allows you to manually change the fee structure if necessary or just to view the current 161 Chesapeake System Solutions Proprietary and Confidential defined fee structure associated with the discrepancy This option is not available for all discrepancies e 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 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 Links Discrepancy Details Type Incorrect Service Charge Variance Assigned To Rank Code Bz Service Code 555 52 Charge Description Test fee 52 Dake 10 31 2005 Chasscription Status Acoount F
68. 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 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 SmartAnalysis is a trademark of 187 Chesapeake System Solutions Proprietary and Confidential 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 accounts within the Bank Manager Edit Relationship Permits the user to change relationship summary specific data within the Relationship Editor Delete Relationship Permits the u
69. Collected Balance Average Negative Cancel The Volume Confirmation Mappings Dialog 4 Select Save All Changes Creating BAI Transaction Types To create new Volume Confirmation Mappings follow these steps SmartAnalysis is a trademark of 200 Chesapeake System Solutions Proprietary and Confidential 1 Select the Volume Confirmation Mappings option from the Edit Menu 2 Select a mapping from the Existing mappings table 3 Select Delete Selected Mappings Volume Confirmation Mappings Choose mapping to add Existing mappings BAl Transaction Type Comparison Code a O11 AVERAGE OPENING LEDGER MTD 024 AVERAGE CLOSING LEDGER YTD PREVIOUS M O21 AVERAGE CLOSING LEDGER PREVIOUS MONTH 00 00 10 Collected Balance Average Net 00 00 13 Collected Balance Average Negative 00 02 30 FDIC Assessment Delete Selected Mappings Save All Changes Cancel The Volume Confirmation Mappings Dialog 4 Select Save All Changes 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
70. 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 results are grouped by bank 3 Within the bank discrepancies are grouped by account SmartAnalysis is a trademark of 107 Chesapeake System Solutions Proprietary and Confidential 4 Finally the discrepancies are grouped by period Bank Of America 121000355 Discrepancies for ABC Toys LLC 13353001724 May 01 2005 to May 31 2005 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 01 2005 to May 31 2005 Aocount ABC Toys LLC 1335001724 has been charged a fee of 15 00 with a per uni fee of 15 0 and a volume of 1 for service code 01 00 00 and bank code 00100 According to the SmarAnalysis negotiated fee setup for this code the charge should have been 10 0 170 0 1 0 00100 0100 00 ACCOUNT MAINTENANCE 5 00 OPEN Account ABC Toys LLC 133300174 has been charged a fee of 5 12 with a per unit fee of 0 3 and a volume of 19 for service code 01 01 00 and bank code 82003 According to the SmartAnalysis negotiated fee setup for this code the charge should have
71. Cor CS 1227311488 THE ABC ha QuickFind e Description Detail Account and unrelated Relationship are selected Expectation The records for both the Relationship and Detail Account are returned SmartAnalysis is a trademark of 19 Chesapeake System Solutions Proprietary and Confidential Entity Selection Banking Operational Th Bank OF America 121000358 gt Relationships 2 10 01 2005 10 31 2005 2 09 01 2005 09 30 2005 2 08 01 2005 08 30 2005 07 01 2005 07 31 2005 2 06 01 2005 06 30 2005 2 05 01 2005 05 31 2005 4 Bank of Chesapeake 012566011 Relationships 0700497535 RELATIONSH Ls 0700497534 West Cox A 9060007164 East Coal 4 gt uickFind e Description Two unrelated relationships are selected Expectation The records for both relationships are returned Entity Selection Banking Operational ig Bank OF america 121000356 gt Relationships 2 10 01 2005 10 31 2005 J gt 09101 2005 09730 2005 2 08 01 2005 08 30 2005 2 07101 2005 07 31 2005 2 06101 2005 06 30 2005 J gt 05 01 2005 05 31 2005 4 Bank of Chesapeake 012566011 Relationships Se 0700497535 RELATIONSH H Statements 4 Bank of Enaland MD oszogo212 4 lt te QuickFind e Description Several accounts are selected Expectation The records for each selected account are returned SmartAnalysis is a trademark of 20 Chesapeake System Solutions Propr
72. D 010101 CREDIT POSTED ELECTRONIC D101 12 CONTROLLED DISS FUNDING 0103 OF BASIC PLUS INTERNET STATEMENT 0103 10 ADOTTIONAL ADORESS PAPER Comparison Codes 00 00 00 Ledger Balance Average Met A 00 00 01 Ledger Balance Average Positive G0 00 02 Ledger Balance Average Daly Positive 00 00 03 Ledger Balance Average Negative 00 00 04 Ledger Balance Average Daly Negatwe 00 00 05 Ledger Balance Month End Banking perabonal 00 02 30 DEP INSURANCE ASSESSMENT MIHLY O0 00 10 Colecied Balance Average Het i ii e Pete aara o rana Dra of k nd Comparton Code Families Summary Charge Level Selection Show Summary Char 0 BALANCE AND COMPENSATION INFORMATION A 0 01 GENERAL ACCOUNT SERVICES Date Range 105 LOCKBON SERVICES 04 PAYROLL CARD SERVICES Saec Dynamic Range amusdy Set Range O7 MERCHANT CARD SERVICES i 08 PURCHASING CARD SERVICES Me 10 DEPOSITORY SERVICES 15 PAPER DISSURSEMENT SERVICES 16 RETAINED ASSET SERVICES G POF Output Cies Output Report Output Type Execute Clear Criters Services By Month Report 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 Sma
73. Display Results to retrieve the results of the discrepancy query based on the selected criteria Select Clear Criteria to start a new discrepancy query SmartAnalysis is a trademark of 153 Chesapeake System Solutions Proprietary and Confidential 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 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 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 i
74. E 00 02 31 TAG ASSESSMENT 0100 Oy al 010359 DS STATEMENT ITEM SUB 06 00 05 Payrol Card Maintenance 06 00 01 Payrol Card Account Card 06 00 02 Payrol Card Inquiry Maite 06 0100 Payrol Card Enrolment A 060101 Poyrod Card Enrodment Hi 06 02 00 Payrol Card bausme De 06 02 01 Payrol Card sguance Int 06 02 10 Payrol Card Issuance Du 06 02 11 Payrol Card pmb Ou 06 02 20 Payrol Cand Replacement 06 02 21 Payrol Card Replacement 06 03 10 Payrol Card Value Loading 0603 il Payrod Card Vaeme Loading 060312 Payrol Card Value Adjustm 0603 13 Payrol Card Value Adjust The Comparison Code Families Dialog 3 Enter a unique Comparison Code Family Name in the Display Name field This is a required field 4 Enter the Description This is a required field 5 If desired assign one or more of the All Available Member Comparison Codes to the family Comparison Codes are assigned to and removed from Comparison Code Families using the provided dueling tables 5 Select Save All Changes Editing Comparison Code Families To edit a comparison code family follow these steps 1 Select Edit gt Comparison Code Families The Add Edit Comparison Code Family dialog displays 2 Select the Comparison Code Family to edit from the dropdown list SmartAnalysis is a trademark of 183 Chesapeake System Solutions Proprietary and Confidential Add Edit Comparison Code Families Select
75. Eroen Liat Price x Qhaartty ai ah a Pat uate fie ae 9500 7103 oo ST Let Prete s Chay Ee rri ea ee Emu e i i at a A EXSY M PER PPE yal ori sth Amna Bf FR at Tois jim Foa prasi i Ge Bapo bere Ses Birin Ra A l 2 00 ET ECER Pee Tots 11 747 50 1747 50 l bora ELINE 10 40 Fee Total EELEE irainia sT SEET ora What If Scenario Structured View Results SmartAnalysis is a trademark of 210 Chesapeake System Solutions EA OF Buecvtre tuemary jij Barking himaan Sp Feness We Balance Query Ty Gecrenance Query Mf hepsi Manager fh Security Maree gE what if Comparsa Hasita S160 G0 Kap UDOT Ped beg Mey se DOA Sin Eaters i Pay OLEI 10 DOA S tes erat Mar Pier 6460 0 DRE 5 neater Sia toe oa ey Att analyse Pie i Oe io Viie Libor eer Te oe Withee Lis Fue Pror ones i Veale Line Staging Aptech CUF Verak Line Photonaoy oon IF Wehbe Ube Bet Evry if Pen Sg L Vetan Lis Diery Prep CP Pood Fe Withee Lbr Daia Capt RA Coe VWehade Lie Date Captain oon 30 Virada Live Barty liaheaae EEEN Lis ero Byte ed orot Io Ube ley Ebera iinr cece ee eo Err The TETE Deveni Det Deben Pre 1000 Ww Beh Dip Con A Curr ae l Lo i aa Birda Coen Beer Curr Onde EE Bereich Purn Ogin Rina TEE B a0 ag Wale Dates What lf Scenario Summary View Results z A O Execs tummary fh Barking Information Fee Query e Deano Query Yaj Cecrenancy Query j Report Manager ih Securty Maraga FE what if
76. 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 Service Charge Comparison The Service 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 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 Alternati
77. IONSHIP SUMMARY 0700 0 84000 Linknown Total Service Charge FED RES DISTRICT 12 f 06 ITEM wen coer poate 0700497534 0 01055 Earrangs Credit Calculation Error i AAA a Fa Phin BE cle Fahl amela TL m a a m PPEP APE PPR iit A7 PPPE e Proceed to select discrepancies on the discrepancy selection screen 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 SmartAnalysis is a trademark of 157 Chesapeake System Solutions Proprietary and Confidential SmartAnalysis is a trademark of 158 Chesa
78. L open during Statement Import To import a Twist XML file 1 Select File gt Import Statement The Statement Import dialog displays 2 Select File and browse for the Statement Data File 3 Select the Twist XML radio button 4 Select your options e Produce complete baseline from this statement and or e Open imported statement in viewer 5 Select Finish SmartAnalysis is a trademark of 135 Chesapeake System Solutions Proprietary and Confidential Scheduling Twist XML Files for Import Many SmartAnalysis users may find it convenient to schedule statement imports for subsequent processing In particular users that receive more than a few statements on the same date receive statements on a predictable recurring schedule or both may wish to schedule their Twist XML file for processing To schedule the Twist XML Import 1 Select File gt Schedule Statement Import The Statement Import dialog displays 2 Enter a Name for this import 3 Select the Files for this import 4 Select Next gt 5 Select the option if you want to Produce a complete baseline from this statement 6 Enter the Recipients for the Status Email NOTE Each email entry must be separated by a comma 7 Select Directory and Browse for the folder which will be the new location for the processed files 8 Select Finish Creating a Manual Statement There are 3 methods in which you can create a manual statement which are all are available
79. MOHITE WES Cosst Account 242 1804 00 00 70 2060007 164 Ear Coari Appou afia DO 00 10 DF CUERE T RELAT IOMSHIP SUMALA 242 Tet Seqiember 01 2006 00 00 10 OTOOOTSS4 West Coast Account 1 620 200 40 00 00 10 BOBDODT 164 Eas Casi Appuni 0 00 po 00 10 0700407525 RELATIONSHIP SUMMARY 321 380 81 Ocidar 01 2005 00 00 10 DOETE Wesi Comst Account 232 8014 00 00 10 BOGOOOT 164 East Coast Account 000 DO 00 10 DOETS RELATIONSHIP SUMMARY 232 B14 Balances by Type Report Sample Columns The Balances by Type Report displays columns related to the balance information e Industry Code The industry code used to categorize the balance drawn from the statement See Industry Code e Account Number The unique account number for the account to which the balance belongs e Account Name The name of the account to which the balance belongs e Balance Amount The dollar amount of the balance See Amount Industry Code Account Number 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 2 Next the results are grouped by Bank 3 Last the results are grouped by statement date Bank of Chesapeake 012588011 July 01 2008 Balances by Type Report Groups SmartAnalysis is a trademark of 98 Chesapeake System Solutions Proprietary and Confidential Details
80. OMSHI MAHAR RELATIONSHIP SUMPLAR 7 1 Select the Balance Query toolbar button on the perspective toolbar to switch to the Balance Query Perspective 8 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 9 3 Select Banking Entities from the Entity Selection Section Balances for the selected entities that match the specified criteria will be returned SmartAnalysis is a trademark of 174 Proprietary and Confidential Chesapeake System Solutions 10 4 The Display Results button is used to execute the query Data from the criteria section is used to retrieve Balance data 11 5 The results of the Balance Query are displayed in the Balance Query Results at the right of the interface 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 Banking Entities or Operational Units Entity Selection Banking Operational itt AMSOUTH BANK 062000019 Relationships EA 12121 RELATIONSHIP SUMMARY Statements igi Bank OF America 121000358 dipy Bank of Chesapeake 012566011 ats Bank of England MD 052000712 ait BLUE BOOK OF BANK PRICES 2004 2005 200320000 ait COMMERCE BAME 0312013
81. Proprietary and Confidential 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 L P Executive Summary 2 Banking Information y Fee Query T Balance Query Gis Discrepancy Query Report Manager Ki Securty Manager T3 what If Perspectives Toolbar 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 U
82. Purposes Dialog 5 Complete the form Name is required This process may be repeated until all changes are entered 6 Select Save All Changes when you are finished The newly added account purpose displays on the dropdown list NOTE This feature is available as a part of SmartAnalysisRM 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 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 1 Within the Banking Structure right click a relationship and select New gt Account for Selected Relationship The Account Information window displays 2 In the Location Codes field of the Account Information window select Manage Location Codes 3 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 SmartAnalysis is a trademark of 86 Chesapeake System Solutions Proprietary and Confidential Select Add a Type Select type to edit Balbmore Type Details eo nae GAT E Deen tan The Location Codes Dialog 4 Complete the form Name is required This process may be repeated until all changes are entered 5 Select Save All Changes when you are finished The newly
83. 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 October 2004 a one a005 March 2005 Apii 2005 May 2005 Jume 2005 July 2005 3005 2005 3005 AVETSAgeE 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 Earnings Credit Monthly Rate Analysis Report 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 SmartAnalysis is a trademark of 110 Chesapeake System Solutions Proprietary and Confidential Monthly Eamings Credit Rate Analysis Bank Selection Report Criteria Edic JPMORGAN CHASE BANK NLA 022000021 IPMORGAN CHASE BANK N A 071000013 WELLS FARGO BANK NLA 1271000
84. Service Charges Dashboard Element displays the highest total amount service charges for the selected date range NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title SmartAnalysis is a trademark of 29 Chesapeake System Solutions Proprietary and Confidential Top Total Cost Service Charges Previous Month Service Code Bank Code Description Unit Rate Volume al 10 04 00 RETO DEPOSITO ITE 4 0 000 0 35 05 44 Uzzi DRAW Dw M RL 23 0 192 0 40 U2 21 20110 DIRECT PRET 0 1 33 049 0 0501 99 O1S33 INCOMING OVE Le 1 634 0 10 00 00 CHEOLO OFFICE DEPOS 1 0 1 853 0 Bh lt gt Top Total Cost Service Charges Dashboard Element Top Volume Service Charges Dashboard Element Top Volume Service Charges Dashboard Element displays the top ten 10 service charges for the selected date range It is designed to inform the user of which bank services they are using the most NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title Top Yolume Service Charges Previous Month Service Code Bank Code Description Unit Rate volume A 10 00 48 ROCOOS CURRENCY FU 0 0 435 500 0 10 00 4
85. 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 View gt Signers View from the menu NOTE 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 Ei SIQhers Wien X ohnr Damar E a Shawn Kerstetter n O0000304180440 IEM CORFP CUSTOD CONCENTRATION mE QUOUOS041 804593 IEM CREDIT LLC LUSTOD Y CONCENTRA mE 00009102569992 IBM CORPORATION JPMORGAN CHASE oo 00009102593820 IBM CORPORATION JPMORGAN CHASE ST 00009102609204 IBM WIRE TRANSFER ACCOUNTS P r Signers View NOTE This feature is available as a part of SmartAnalysisRM 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 SmartAnalysis is a trademark of 19 Chesapeake System Solutions Proprietary and Confidential Creating Signers To create a signer follow these steps 1 Select or Create Signer from the dropdown menu to open the Signer Editor Ei Signers View X 2 A O The Signer View Toolbar 2 Complete the form Name is required NOTE The account assignment table is read only E Albert Finklehopper AYT Signer Information Albert Finklehopper Frimary Inform
86. SmartAnalysis Eii Banking Information yp Fee Query Ti Balance Query kj Discrepancy Query H Report Manager 6 Security Manager FE what If Selecting the Executive Summary Perspective from the Perspective Toolbar Executive Summary Dashboard Elements Each summary graph or report on the Executive Summary Perspective is a dashboard element The Executive Summary Perspective presents four of these dashboard elements at once to provide a snapshot of the current state of your account analysis Total Charges by Bank Dashboard Element The Total Charges by Bank Dashboard Element is a chart that displays the five 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 five 5 banks all other banks will be summarized as a sixth slice in the pie chart SmartAnalysis is a trademark of 2 Chesapeake System Solutions Proprietary and Confidential NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title Total Charges By Rank Change Bement Refresh Cuptomire TD Bart 026013673 246 808 36000 JPMORGAN CHASE BANK N A 124001545 99 683 98000 CITIBANK N
87. Tab The general information tab contains a variety of basic information about the relationship SmartAnalysis is a trademark of 47 Chesapeake System Solutions Proprietary and Confidential Relationship Information General Information Tolerances Mamei Dacrepancy Tolerance 5 Mumber Change Change Tolerance 35 Types w Volume Tolerance 56 Settlement Method Account is automaticaly debited w Account Closing Date FEl Operstonal Structure Linassqned Additional Information Tax Identi caton Murer Account Opening Date ek G L Account ID General Informasen Megotieted Fees Contacts GLExpert General Information Tab Identity Information The general information section contains information that is used to identify the relationship summary within the application General Information Name BEBE STORE 701 Number 4944068162 Type Settlement Method Account is automatically debited Account Closing Date 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 SmartAnalysis is a trademark of 48 Chesapeake System Solutions Proprietary and Confidential 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 uniq
88. To create new Comparison Codes follow these steps 1 Select Edit gt Comparison Codes The Add Edit Comparison Codes dialog displays 2 in lt Add Edit Comparison Codes Select Add a Compariton Code Comparison Code 00 00 00 Ledger Balance Average Net Comparison Code Details Code o0 o0 00 Display Name Ledger Balance Average Net Description The sum af the day endag ledger balances both poate and negative dvided by the number of days in the analyse period A negaitve oned value inchcates a negative average net balance Balances ore net of orent period adjustments 00 BALANCE AND COMPENSATION INFORMATION Add Edit Comparison Codes dialog 2 Select Add New Comparison Code 42 Add Edit Comparison Codes Comparison Code New Code New Code Add new Comparison Code Code New Code Display Name New Code Description Delete Save All Changes Cancel The Comparison Codes Dialog 3 Enter the Code Code is required and must be unique 4 Enter the Description Description is a required field 5 If desired you can click the Group dropdown arrow and assign this code to a comparison code family SmartAnalysis is a trademark of 179 Chesapeake System Solutions Proprietary and Confidential 4 Select Save All Changes Editing Comparison Codes To edit Comparison Codes 1 Select Edit gt Comparison Codes The Add Edit Comparison dialog displays 2 Select the code to edit
89. Unit from the Operational Structure View 2 Select the Delete icon of the Operational Structure View toolbar or from the context menu a Operational Structure The Operational Structure View toolbar 3 Select OK SmartAnalysis is a trademark of 78 Chesapeake System Solutions Proprietary and Confidential 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 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 Unassigned Accounts View The purpose of the Unassigned Accounts View is simply to provide a full list of all accounts and relationships within the system that do not belong to an operational unit 1 Select View gt Unassigned Accounts from the menu to view a list of unassigned account The Unassigned accounts display as a new window on the right side of the open window 2 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 Signers View The
90. able 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 Setting this 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 0 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 Domains Allowed for Domain Authentication Enter the names of the domains that are to be allowed for Domain Authentication Is Domain Authentication Permitted You may select either True or False Selecting True allows the user to bypass SmartAnalysis login if their domain is listed within the domain authentication field Minimum length for passwords The security of a password is directly proportional to its length Passwords that are very short are easily compromised
91. 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 amp ay bsmith Mew 9 Ues chederowicz chessys P dhoagie Creating A User 1 Select the drop down menu from the Users View 2 Select New gt User The User Information editor displays SmartAnalysis is a trademark of 193 Chesapeake System Solutions Proprietary and Confidential User Information User Name Password Confirm Password Email Address Account Disabled _ Force Password Change The New User Editor 2 Complete the form User Name Password and Confirm Password fields are required It is recommended that the Email Address be provided as well 3 Select Force Password Change to enforce this option 3 Save the editor Note The username will become read only once the user is saved Editing a User Users 2 a ey Sal ea smith blew q Chederowicz H chessy s ce Edit a dhoagie gy isixpag ae H jyizzle ta mench oy Refresh H rboswell Selecting a User 1 Select a user from the Users View Double click the user to open the editor or select Edit from the menu as displayed above SmartAnalysis is a trademark of 194 Chesapeake System Solutions Proprietary and Confidential User Information User Name Password Confirm Password Email Addre
92. act 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 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 Operational Structure ex Signers View E Unassigned Accounts Le Working Sets View Menu for Banking Information Perspective Window Menu The Window Menu provides functions for managing the current perspective and the open editors The functions available are explained below SmartAnalysis is a trademark of 5 Chesapeake System Solutions Proprietary and Confidential s UlUlt Window Help Close Ctr Close 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 Help Menu The Help Menu provides functions for managing
93. actual calendar time e 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 e 30 360 Each month is treated as 1 12 of the entire year Variations in calendar days per month are ignored Discrepancy Tolerance The Discrepancy Tolerance section of the Bank Editor General Bank 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 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 SmartAnalysis is a trademark of 37 Chesapeake System Solutions Proprietary and Confidential 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 Comp
94. ail If this is a manually entered statement you need to enter both the relationship and account level data for the statement SmartAnalysis is a trademark of 146 Chesapeake System Solutions Proprietary and Confidential Ambiguous Service Charge Description SmartAnalysis generates this discrepancy when 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 that 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 Duplicate Account Description SmartAnalysis generates this discrepancy 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 Earnings Credit Calculation Error Description SmartAnalysis generates this discrepancy for each bank statement record where reported earnings credit is not equal to the earnings credit amount calculated by the system The system does not flag differences caused by rounding P
95. alance Mappings Case Folder Bank Editor Authorized Associates Tab Authorized Associates are entered with a selectable table by selecting the add button NOTE 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 Primary Information SmartAnalysis allows you to record the name title department email address and phone numbers for an authorized associate Primary Information Mame New Associate Title Email Department Phone Number Alt Phone Number Fas Number Mobile Humber Primary Information 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 Contacts Authorized Associates Balance Mappings Case Folder The Bank Editor Balance Mappings Tab Balance Mappings are entered with a selectable table by selecting the add button SmartAnaly
96. amine 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 un assign 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 Allows the user to create new signers within the SmartAnalysis RM system SmartAnalysis is a trademark of 189 Chesapeake System Solutions Proprietary and Confidential Edit Signer Permits the user to 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
97. ark Op rm kial ARETE BGM ESOS 4 eS Bank OF Areia 120000058 7 Bari of Chitika 00 ee a ii Bah u Grial Ce 4 BLUE EO OF BARE PEER 20 COMPVERICE SARE 01120130 zih eH hiad Bak On DEE a Wehea Eae b Ciki E Date Barge Doniarion Codes BETA ee aaa ar oc 00 00 Ledger Siit 00 OL Ledger Balance joo 00 ae opon ry 100 00 ce Lekar Erani Lee Fror rrop Likar Eaa Aa Leger Ease Menr Collected halama Arari as Crier tert Aundrea r Dine i D000 0 log i ig rin m Lh ls E moming Eiane a ED Balsas Information Fani Code Deecription Bo OO fo Mi io GO Wei Ce Sg i 40 Teri aa oo agi i i mH bz w H ji his Kecadhoee eas Aaroa ie Codected Balance Averoge Met Codecbed Bainin Aer das Petia Piece it et i Fries Sines Go eheri Service Changes Total Current Pere Balance Bquaaent Titel rae Charge Enos efit Cobected Balance Garand Dept Samun Balance Hejma Denard Dengi Aouri Balance Remya Oe fo 06 Sai eS ae Heo rs hee ary ne iA ote ame a 0 Ss OSes aes ae PS BL Date iout z1 4044 02 31 356 86 31 255 55 POF A 1i 120 15 a AA as FS m 2 BES TTT aiie Ari Account karre MELATIH p AHA RELATIONSHIP SUMBAP RELATIONS HIF SLUMMAP RELA TLONSHI GAHAR POLST TONSA SUPPL EF BTS PARA REATO HE SL IMRAR RELATIONSHIP MMRR PELSTIONSHIF SMPR RELATR
98. assigned to the selected users You can select the Extra Option to Show audit trails You have the option to display the report in PDF or CSV output A Discrepancies By Period Report is made up of several parts These parts include the column header the groupings and the discrepancy results data SmartAnalysis is a trademark of 106 Chesapeake System Solutions Proprietary and Confidential Discrepancies By Type Hank Code Service Code Charge Desorption Vananor Assigned To Decepanses of type Incomect Senice Charge Bank Of America 121000356 Oscrepances for ABS Toys LLC 1333001724 May 01 2005 to May 31 2005 Account ABC Toys LLC 1333001724 has been charged a fee of 15 00 wih a per unit fee of 15 0 and a volume of 1 for service code 01 00 00 and bank eode 00100 According to ite SmartAnalysis negotiates fee sep for this code he charge should have been 10 0 10 0 x 10 O0100 01 00 Oo ACCOUNT MAINTENANCE 5 00 OPEN Account ABC Toys LLC 1333001724 has been charged a fee of 4 13 with a per unit fee of 0 3 and a volume of 19 for service code 01 01 00 and bank oade 82002 According te the SmarAnalysis negotiated fee setup for this code he charge should have been 6 1 0 3 x 18 0 52003 0101 00 DEBITS POSTED OTHER 0 25 OPEN June 01 2005 to June 20 2006 Account ARS Toys LLC 1333001724 has been charged a fee of 0 90 with a per unit fee of 0 2 and a volume of 2 for service code 01 01 01 and barik cade 82004 According to
99. at the account level For negotiated fees this tolerance is currently only used for Incorrect Service Charge discrepancies e 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 e 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 e Charge Change Tolerance Percent fees can vary month to month before being identified as a discrepancy If entered this value overrides the tolerance set at the account level Boundary Information Negotiated Fee boundary information is used to provide charge type agnostic price information Boundary Information Tolerance Information SmartAnalysis is a trademark of 51 Chesapeake System Solutions Proprietary and Confidential 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 Rate Information There are several varieties of rates available for negotiated fees Each rate typ
100. ate 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 Statement General Information The first tab in the statement editor allows you to modify statement level information Bank Information This displays any bank related information included on the statement such as the bank name and address 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 Contact Information This displays any contacts included on the statement Information Here you can select to mark the statement as eligible for GL Export SmartAnalysis is a trademark of 140 Chesapeake System Solutions Proprietary and Confidential lf the statement is processed a link will be displayed allowing you quickly view the discrepancies relating to this statement Account Detail Information This tab allows you to modify information at the relationship and account level in the statement 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
101. ation Specialized Information Name Albert Finklehopper Lirnit 100 000 00000 Tite Signer Typs Facsimile gt E mail atinklehopperfrogepace com Department Treasury Phone Number 8884455151 Alt Phone Number Fas Humber Mobile Humber Mi Assignment Details Added 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 Importing Signers If you have your signer information saved in a csv file you can import this information and populated Signer Information without having to manually enter each signer Creating the Signer Import file To create the signer import file 1 Open Microsoft Excel SmartAnalysis is a trademark of 80 Chesapeake System Solutions Proprietary and Confidential 2 Enter the signer information in the following format Last Name First Name Title Limit Email Dept Phone Alt Phone Fax Mobile Type F M A 3 Save the file as a csv file Importing Signers To import signers 1 Inthe Banking Information view select View gt Signers View The Signers View window displays ret a H i 2 Select or click the down arrow and select Import Signers The Select File to Import dialog displays 3 Browse for the csv file containing your signer information and select Open The names of your signers display in the Signers View and the data from your signer file displays on the Signer Information w
102. audit trails are also deleted Attaching an e mail 1 From the Discrepancy Details screen select eral The E Mail discrepancy details dialog displays 2 Enter the From name 3 Click the arrow and select the To contact information Contacts added when the Banking Structure is setup will display on the dropdown list 4 Enter a Cc email if desired 5 Enter a Subject for the email 6 Enter a Message to be included on the email 7 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 allowing you to remove account numbers or make other modifications E mail discrepancy details E mail information From Ta ct Subiect Message Message from SmartAnalysis No match For service charge with service code 55 55 55 and bank code BS For account Account 4 11000 was Found Send Cancel 3 Select Send to send the e mail SmartAnalysis is a trademark of 165 Chesapeake System Solutions Proprietary and Confidential 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 Updating Discrepancy Status When viewing discrepancy details you can easily change the status of the discrepanc
103. bank account 1 Select View gt Archive The Archive view displays 2 Right click the bank account in the Archive view 3 Select Undo archive The archived bank account returns to the Banking Structure view Viewing the Archive To view archived items 11 Select View gt Archive The Archive editor displays the archived banks SmartAnalysis is a trademark of 46 Chesapeake System Solutions Proprietary and Confidential Creating a Relationship To manually create a Relationship Summary right click on the Relationships folder underneath the desired bank Select New gt Relationship for selected Bank H Bank OF America California 121000358 ia Bank of Chesapeake 111111111 Bank of England MD 052000212 Ek 5 Creating a Relationship 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 Structure 3 RELATIONSHIP SUMMARY 07 Ea 7 a F Ralatinnchin AMSOUTH BANK 062000019 Reis lt Relationships ea 12121 RELATIONSHIP SUMMARY Es Import Statement gt Statements 2 Edit Bank OF America 121000358 fi Bank of Chesapeake 012566011 HE Delete J E Relationships E 0700497535 RELATIONSHIP SUMMARY A Account QuickFind Statements wy Editing a Relationship General Information
104. ble options are the layout and the selected dashboard elements 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 Changing the Executive Summary Perspective Dashboard Elements There are several Executive Summary Dashboard Elements available for display on the Executive Summary Perspective To change the dashboard elements displayed 1 Select the Change Element link The Customize Dashboard Elements dialog displays Customize Dashboard Element OEE Select the dashboard element to display here Overall Charges By Month Overall Charges By Month Highest Per Item Cost Service Charges Highest Total Cost Service Charges Highest Volume Service Charges Top Discrepancies by Variance Customize Dashboard Element 2 Select the dashboard element to display here from the dropdown list The Dashboard Layout Selection dialog displays 3 Select Save The changed element loads and displays in the selected frame of the Executive Summary SmartAnalysis is a trademark of 31 Chesapeake System Solutions Proprietary and Confidential Customizing the Executive Dashboard Elements To customize the information displaying in each of the dashboard elements 1 Select the Customize link The Customize Dash
105. board Element displays defaulting to the Banking Entities tab Customize Dashboard Element Name Overal Changes By Month Tyme Overall Charges By Month Banking Entities Service Code Groups Date Range Banking Entities Bh Bank Of America Calfornia 121000353 Fy Citigroup Inc 021000089 E Bey FNS Unit Test 123456789 iy Infor TriSyn Group Dnesen 026009993 2 By uyhy 113000609 2 iy JPMORGAN CHASE BANK NLA 021000021 fy STATE STREET BANK 011000028 B h TD Bank 260136737 yy TD Bank 025013673 py US BANM 12000848 E By WELLS FARGO BANK NLA 122000248 A WELLS FARGO BANK NLA 102000076 Leave empty to ncude all banks in results Customize Dashboard Element dialog 2 Click to select the Banking Entities that you want to display on the selected dashboard element Multiple banking entities can be selected by depressing the Ctrl key on your keyboard as you make your selections 3 Click D gt to move the selected banking entities to the Selected column 4 Select Save 5 Select the Service Code Groups tab SmartAnalysis is a trademark of 32 Chesapeake System Solutions Proprietary and Confidential Customize Dashboard Element Tyme Overall Charges By Month Service Code Groups tab 6 Click to select the Service Code Groups that you want to include on the selected dashboard element Multiple service code groups can be selected by depressing the Ctrl key on your keyboard as yo
106. ccount Yariance RELATIONSHIP SUMMARY 0 6 976 3 OH Centers 7511932 2 969 0 West Coast Account 070049 2 741 5 Discrepancy Type Chaja Incorrect Total Service Charge Sum Earnings Credit Calculation Error Earnings Credit Calculation Error RELATIONSHIP SUMMARY 0 991 4 Unknown Total Service Charge DEP DFI ATOR HTO IMAMA r D mn oF A PIink newin Toakal Gearwire Charna Feo E lt gt Top Discrepancies By Variance Dashboard Element Top Unit Rate Service Charges Dashboard Element Top Unit Rate Service Charges Dashboard Element displays the top ten 10 service charges by unit rate for the selected date range It is designed to alert the user to the most expensive service charges for the selected date range on a per rate basis NOTE To have the Date Range Display on the element select Customize Next select the Date Range tab and choose the desired date range from the dropdown list Finally type the date range in the Name field beside the element title Top Unit Rate Service Charges Previous Month Service Code Bank Code Description Unit Rate Volume eo 11 20 OUgs WEBACH SWS 375 0 1 0 15 00 00 CADSO0 EAST COAST B o 225 0 1 0 40 01 00 01976 BAIL TRANSMIS 200 0 1 0 4001 00 01976 BAI TRANSMIS z00 0 3 0 45 00 20 OU409 INVESTMENT MH 200 0 1 0 lt gt Top Unit Rate Service Charges Dashboard Element Top Total Cost Service Charges Dashboard Element The Top Total Cost
107. cess 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 Qccounk Debit Gccount Allocation Pet Custom Field 1 C1 fee 1700 333 9997 100 00000 9999 9 Validate Allocations Excess Earnings Credit Allocations 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 SmartAnalysis is a trademark of 58 Chesapeake System Solutions Proprietary and Confidential Drop support for detail account elements in the Banking Structure View The steps for reassigning a detail account are Select the detail account to reassign in the Banking Structure View Hold the mouse button down Banking Structure EL 7 we A AMSOUTH BANK 062000019 Relationships a 12121 RELATIONSHIP SUMMARY 7 DEFAULT RELATIONSHIP SUMMARY DEFAUL a 41705459 THE ABC Company Statements Bank OF America 121000358 SMe eel ML ee el mdi ae ee Managing Detail Accounts step 1 2 While holding the mouse button down drag the pointer until it is hovering over the desire
108. cription 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 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 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 SmartAnalysis is a trademark of 152 Chesapeake System Solutions Proprietary and Confidential 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 E EESE RELATKAGHIP 3UPPART 00 O S5 tiii incra Sei vce Charge OEM DEPOT irok SE BA VL I ee e MELA TOMSHIF SUHAR 0 fi maret Sever Chm Babi TED AF Te HTL iy Sart Of America Calfin LESA RELATIONSHIF SUPMARY 0 T Iaret Sie Charge CURE ACCOM DEF p10 T CA gt Adirah AELATIOMGMIF SUMMARY Ti THA Incorect Maver Change CURR ACCEN HIFI Ona T A E in GORI PLAT IP Sd RELATE aE in
109. ct 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 Incorrect Total Balance Description This discrepancy is generated when the Balance Summary the amount reported at the relationship level differs from the sum of that same balance amount at the account level SmartAnalysis is a trademark of 148 Chesapeake System Solutions Proprietary and Confidential Resolution Report the difference to the bank involved 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 charge discrepancies by assigning discrepancy tolerances at the account level A discrepancy tolerance reduces the number of less important or minor discrepancies eac
110. ction account level 6 bank level 6 statement level 6 Exception Status defined 112 Chesapeake System Solutions Proprietary and Confidential Excess Earnings Credit Allocations defined 53 Executive Summary Perspective changing layout 32 configuring 32 defined 29 Export GL Data 4 Fee Query Criteria View 135 Fee Query Results View 137 File Menu 4 Flat Rate defined 48 61 entering 61 G L Debit Allocations setting 68 General Information Tab identity information 56 sections 56 General Ledger 67 exporting data 68 General Ledger Allocations deatil account 68 defined 52 relationship 68 General System Parameters purpose 99 GL Export 68 Help Menu functions 6 Import Statement 4 Incoming Bank Code 46 59 Incoming Description 46 59 Incoming Service Code 46 59 Incorrect Reserve Rate 115 Incorrect Service Charge 116 Incorrect Total Service Charge 116 Incorrect Total Service Charge Summary 116 Incorrect Volume 117 List Selection explained 2 Location Codes adding new 77 defined 77 editing 77 Login failures 2S SmartAnalysis is a trademark of 217 Login Security System Parameters defined 100 Manual Statement creating 104 Manually Match Codes 42 Mark Statement GL Unexported 68 Maximum Disbursement Amount 82 Maximum Fee 47 60 Menu Bar 4 Minimum Fee 47 60 Missing Account 117 Missing Charge Information 117 Missing Reserve Rate 117 Missing Total Service Charge 11
111. d destination relationship in the Banking Structure View The target relationship should become highlighted di Confirmation Are you sure you want to drop the selected 4ccount s onto Relationship tf RELATIONSHIP SUMMARY 1212137 cancel Managing Detail Accounts step 2 3 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 select OK Select Cancel to abort the drop Banking Structure xt EX 7 al ir AMSOUTH BANE 062000019 gt Relationships 68 12121 RELATIONSHIP SUMMARY a 41705459 THE ABT Soe HE ay er ee ee Managing Detail Accounts step 3 SmartAnalysis is a trademark of 59 Chesapeake System Solutions Proprietary and Confidential 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 confirm 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 EA 7 A ii AMSOUTH BANK 062000019 ews i Bank OF America 121000358 i Bank of Chesapeake 012566011 Ed Import Statement Rela
112. d side by holding down the CTRL key while clicking the URL with the left mouse button CTRL click Website http Aiwa chessys com Be ET ctrl click to open browser Entering a URL Tables Tables are an important element in the SmartAnalysis user interface There are four types of tables present in the application e Read only Tables used to display query results e Editable Tables e Selectable Tables e 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 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 Add To SmartAnalysis is a trademark of 14 Chesapeake System Solutions Proprietary and Confidential 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 Delete 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 po
113. d 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 Trees may be expanded to review the relationships and the accounts that belong to each relationship SmartAnalysis is a trademark of 34 Chesapeake System Solutions Proprietary and Confidential i Bank of England MD 052000212 Relationships 98001694 RELATIONSHIP SUMMARY z i Statements it rs is rs rs s s is le 03 01 2007 02 01 2007 01 01 2007 11 01 2006 10 01 2006 09 01 2006 08 01 2006 07 01 2006 03 31 2007 02 28 2007 01 31 2007 11 30 2006 10 31 2006 09 30 2006 08 31 2006 07 31 2006 Banking Structure View The Banking Structure View is the primary means of navigating and browsing your bank setup information Creating a Bank lt 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 1 Select the drop down menu from the Banking Structure View 2 Select New gt Bank The Bank Editor displays defaulting to the Bank Information window Editing a Bank To view or edit the information for a bank open the Bank Editor from the Banking Structure View e
114. dialog will confirm the successful generation of the CSV file 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 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 O0 to 01 04 01 y Change History The Relationship Editor Contacts Tab Detailed contact information for relationship representatives are entered on the Contacts tab of the Relationship Editor located in the bottom left of the interface General Information Negotiated Fees Contacts GLExport SmartAnalysis is a trademark of 99 Chesapeake System Solutions Proprietary and Confidential Relationship Editor Contacts Tab RELATIONSHIP SUMMARY 0700497535 L a Contacts RELATIONSHIP SUMMARY OTOO497S35 Ja Mame Title Emad Department Phone Number Bil Benger Bank Reltionship Manager bhendenaiae com Corporate Baring 411 635 7756 lt ct Del
115. djustment d Enter the Change Amount e Select Add Rule The new rule populates the field below the Add Rule button NOTE To delete a rule click the rule to select it and click the Delete button Select Generate to run the scenario The Comparison Results display SmartAnalysis is a trademark of 209 Chesapeake System Solutions Proprietary and Confidential Tlen af Badii his Sharir Tomi paren Aralt amp Change Cierra E Baan 0 en ot Charaka Coy di Rank of Che eapeake Copy Fj p RELA TIGH SHI SUM AR Y i i r i i ii 2 J i 5 i a f l k l DODI MAAARI net Pina a kamni Ee art fart EL por unit fee at oct a ed PODS Pa PIO0 BoP bay EDIO Node 29 E Anari pi Er Total i307 LNs Toball iLe 00 OL GS bo GTR Lit Pree T Diam ity i I Rey eal iga Da Eas PATH ee ee E Voter L rr a ed errie g Total ee RD ee Teta pii pan m OLOA QO AARDT Liet Price Camry Benu fee at iti ELOD Pam fee at iinoa j a0 AENT HATE 23 0 Vere m i Arri mS D o i Tola 63g ALA inn ThE pa Pe Lr 1 a GS a Loo LFW Pear aaay Per urii fee wt AEU Da ut a ai es aiara MECTECHES OCT MALTES hamse eb dreien ey Tola pW THa Higa 2 2y AEAEE TET Urn Prope m Guant Beuil fee aLa T r urit fee at 1100D i heed O27 TRANEN KHT Vime E Arson 430 00 Tois 120 00 Teim 990 00 39 00 fing of Chanaan Syntace Doir OPT ds ELLE ob ae HL fg Pea Tou 23 FF BES tah oe a bik Lie ae Cheapeske System Solutions HHEPHOT ay 0103 20
116. e provides a different method of calculation for a negotiated fee Negotiated Fee Rate Types Unit Rate Flat Rate Threshold Rate Tiered Rate Balance Based Selecting a rate type Rate Details Flat Rate O Fer Unit Rate Threshold Rate O Tiered Rate Balance Based 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 Per Unit Rate The value for this type of rate is multiplied by the volume to produce the expected total amount SmartAnalysis is a trademark of 52 Chesapeake System Solutions Proprietary and Confidential Rate Details Flat Rate PET ENEE awe Per Unit Rate Threshold Rate Tiered Rate Balance Based 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 Flat Rate The value for this type of rate is evaluated alone and the amount listed is the expected total amount Rate Details Fiat Rate FatRate o Per Unit Rate Threshold Rate Tiered Rate Balance Based 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 Threshold Rate
117. e recurring schedule or both may wish to schedule their 822 processing To schedule a statement import 1 Select File gt Schedule Statement Import The Statement Import dialog displays 2 Enter a Name for this import 3 Select the Files for this import 4 Select Next gt SmartAnalysis is a trademark of 133 Chesapeake System Solutions Proprietary and Confidential 5 Select the option if you want to Produce a complete baseline from this statement 6 Enter the Recipients for the Status Email NOTE Each email entry must be separated by a comma 7 Select Directory and Browse for the folder which will be the new location for the processed files 8 Select Finish Creating and Importing CSV Service Charge Files SmartAnalysis allows you to import your Service Charge Fees in CSV text file format This is provided as an alternative for users unable to get a bank analysis file statement To create a CSV Service Charge Import file 1 Open Microsoft Excel 2 Enter the bank charges information in the following format FLAG Hank Hame Hanks BA art Date End Oaie emini Daie rH ST AAC Hank Leyes WA DANVAD oe oa ps Fiag Real neh ACO ACO Numher Service Cade Uni Price 3 Yodlume Told Friu hank OH Balance egrement Type A LAST mhr OZAN X a_i ma Bank Code O EKKEKKH XM UPO SHA LAE har mA x a_i ma Bank Code 1 KENKXKKK NE UPO A LAST O ITE X Fa III aii XXXXXAX HK HHF 3 Save the file as a csv file and follow the directions be
118. e Bank Editor Additional Information Main telephone number Customer Service number p Date Corporate Resolution updated Website Po SmartAnalysis is a trademark of 36 Chesapeake System Solutions Proprietary and Confidential Additional Information Earnings Credit Information The Earnings Credit Information section of The Bank Editor General Bank 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 on the statement and to produce the Earnings Credit Error Earnings Credit Month Goer and Calendar Month 365 356 in leap year s Derepanicy Thera 0 01000 Select a formula 3 Average Net Ledger Balance average Positve Colected Balance i Met Poste Cohected Balance C Investable Balance Ce tas Average Net Ledger Balance Average Ficat 1 Reserve Requirement Rate Earnings Credit Rate Days in Month Days in Year Earnings Credit Information 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 e 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
119. e displayed Overall Account Status Report Summary information for Bank of Chesapeake 012566011 RELATIONSHIP SUMMARY 0700497535 Detal Accounts West Coast Account 0 0049 7534 East Coast Account 3080007164 Sera Name Tt a Jason Yankus Treasury Manager Manua 10 000 00 Krein Srmith CFC Facarmile 500 000 00 Stacey Gilrare Assi Tressurer Manus TO0 000 00 Total Number of Sigrers i 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 e 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 e 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 e Closing Date The date upon which the account was closed Can be entered or modified on the Detail Account Editor in the Additional Information section e 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 e 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 e Account Purpose The arb
120. e family Comparison Codes are assigned to and removed from Comparison Code Families using dueling tables 5 Select Save All Changes to save your changes SmartAnalysisRM Effectively organize your complete corporate banking structure with SmartAnalysisRM 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 SmartAnalysis is a trademark of 184 Chesapeake System Solutions Proprietary and Confidential mistakes 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 Enablement Af
121. e is required is required to be unique 4 Select Save All Changes Editing BAI Transaction Types To edit BAI Transaction Type follow these steps 1 Select Edit gt BAI Transaction Type 2 Select the type to edit from the selection list SmartAnalysis is a trademark of 199 Chesapeake System Solutions Proprietary and Confidential Add Edit BAI Transaction Types Select Add a Type Select type to edit O10 OPENING LEDGER Add new BAI Transaction Type 10 OPENING LEDGER P AVERAGE OPENING LEDGER MTO Type Details AVERAGE OPENING LEDGER TD janie CLOSING LEDGER Code 010 AVERAGE CLOSING LEDGER MTD Description OPENINGS LEDGER Save All Changes Cancel The BAI Transaction Type Dialog 1 Complete the form The Code is required is required to be unique 2 Select Save All Changes Creating Volume Confirmation Mappings To create new Volume Confirmation Mappings follow these steps 1 Select Edit gt Volume Confirmation Mappings 2 Select both a BAI Transaction Type and Comparison Code 3 Select Add Volume Confirmation Mappings Choose mapping to add BAI Transaction Type 921 AVERAGE CLOSING LEDGER PREVIOUS MONTH Comparison Code 00 O2 30 FDIC Assessment F Existing mappings BAI Transaction Type ss Comparison Code a 011 AVERAGE OPENING LEDGER MTD 00 00 10 Collected Balance Average Met 024 AVERAGE CLOSING LEDGER YTD PREVIOUS M 00 00 13
122. e pubtetal for account O21 Discrepancies By Period Report Sample SmartAnalysis is a trademark of 104 Chesapeake System Solutions Proprietary and Confidential Columns The Discrepancies By Period Report displays data related to discrepancy information e 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 e Status The status of the discrepancy 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 ee Within the bank discrepancies are grouped by account iN Finally the discrepancies are grouped by type Bank Of Amenca 121000358 Descrepancies for ABC Toys LLC 1333001724 Incorrect Semice Charge Discrepances Discrepancies By Period Report Groups Results Data The Discrepancies By Period 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 Incomrect Service Charge Discrepanc
123. ed 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 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 we suggest that you turn off the operational structure system parameter SmartAnalysis is a trademark of 150 Chesapeake System Solutions Proprietary and Confidential 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 discrepancy is common when importing a statement containing new relationships All relationships must be assigned to the operational st
124. editor Accessing Context Sensitive Help Context sensitive helps information concerning the currently active visual 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 Form Field Data Entry This section describes how to effectively and efficiently use common user interface components in SmartAnalysis Required Fields Required fields are marked with an asterisk 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 Click the toggle icon i to open or close a Twistie Section Date Range t Bank Codes Service Codes t Charge Description t Comparnson Codes t Comparnson Code Families t Amount Twistie Sections on the Fee Query Criteria SmartAnalysis is a trademark of 11 Chesapeake System Solutions Proprietary and Confidential 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
125. ee 10 0000 E Unassigned zl Account B 11001 Account Account B 11001 has been charged a Aat fee of 60 00 for service code 55 55 52 and bank code B According to the SmartAnalysis negotiabed fee sebup for this code the charge should have been S0 00000 at Fee Change History ubo Resolve There is mo history For this discrepancy Add Comment ed Send E mail L D Insert Attachment ge ee b m Edit Statement Auto Resolve Select this option to resolve the selected discrepancy Add Comment Select this option to add a comment to the discrepancy detail Comments will be viewable 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 accurately configured in the Configuration Wizard for the email to generate Insert Attachment Select this option to add an attachment to the selected discrepancy Attachments are viewable 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 view the statement data 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
126. ee Structure Audit Report 94 Balances by Type Report 96 Report Criteria 97 Contacts by Bank Report 99 Discrepancies By Period Report 101 Discrepancies By Type Report 106 Earnings Credit Time Series Rate Analysis Report 108 Earnings Credit Monthly Rate Analysis Report 110 Services By Month Report 113 Service Summary Report 116 Yearly Services Summary Report 118 Report Criteria 119 Sample 120 Layout 120 Service Code Detail Report 121 Report Criteria 121 Signer Status Report 122 Signers Status Report by Department 124 Monthly Summary Statistics Report 126 System Parameters 128 General System Parameters 128 Login Security System Parameters 129 Decimal Precision System Parameters 130 Statements 132 Importing 822 Files using the Wizard 132 Select a file 133 Statement Import Options 133 Finish 133 Scheduling 822 Files for Subsequent Import into SmartAnalysis 133 Creating and Importing CSV Service Charge Files 134 Scheduling CSV Service Charge Files for Import 135 Importing Twist XML Files 135 Scheduling Twist XML Files for Import 136 Creating a Manual Statement 136 Creating a statement from Bank Setup 136 Creating a statement from the latest statement in a Bank 137 SmartAnalysis is a trademark of vill Chesapeake System Solutions Proprietary and Confidential Copying a statement 137 Viewing a Statement 137 Statement Structure 137 Save a copy 140 Print a statement 140 Editing a Statement 140 Impact on Discrepancies 140 Statement Gen
127. electing dynamic range e Manually Set Range Date Range Select Dynamic Range Manually Set Range Manually Set Date Range 6 Select the Audit Type Audit Type Audit Type Update Audit Type 7 Select the Report Output Type Your options are e PDF Output e CSV Output 8 Select Execute to create the report 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 SmartAnalysis is a trademark of 96 Chesapeake System Solutions Proprietary and Confidential o Balances By Type Report Resortcrteriatdtm Entity Selection Compariton Codes Barking Operatonal 00 00 00 Ledger Balance Average Net A i F 00 00 01 Ledger Balance Average Positive E JPMORGAN CHASE BANK N A x T ih saint l P pee 00 00 02 Ledger Balance Average Daily Positive bki i JPMORGAN CHASE BANK N A 071000013 00 00 03 Ledger Balance Average Negative E A WELS FARGO BANK H A 121000245 00 00 04 Ledger Balance Average Daly Negeine 00 00 05 Ledger Gatance Month End 00 0 10 Cobected Balance Average Mei Owe Wa s ete Rieder a Bt ee Drapia gt Incoming Balance Information 00 00 00 Ledger Balance Average Net A 00 00 01 Ledger Balance Average Positive 00 00 03 Ledger Balae Average Negative 00 00 10 Cofected Balance Average Met 0000 11 Colected Balance Ave
128. eneration 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 automatically maps the negotiated fees created from that statement SmartAnalysis is a trademark of 177 Chesapeake System Solutions Proprietary and Confidential Manual Entry It is possible to manually enter Comparison Codes SmartAnalysis is a trademark of 178 Chesapeake System Solutions Proprietary and Confidential Creating Comparison Codes
129. ening Date G L Account ID Po Additional Information Specialized Information NOTE This feature is available as a part of SmartAnalysisRM 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 SmartAnalysis is a trademark of 62 Chesapeake System Solutions Proprietary and Confidential Detail account specialized information includes data that deals with account purposes and overall amounts and thresholds This data is stored for informational purposes Specialized Information Account Purpose Main AP Account v 4g Balance Requirement 10 000 00 Dual Signature Threshold 25 000 00 Max Check Amount 10 000 00 Target Balance 5 000 00 Statement Cycle Date 5 5 4 i Specialized Information Fields e Account Purpose Represents an arbitrary categorization of the purpose that the account fulfills e Average Balance Requirement Represents an amount established between the customer and institution that allows the customer to offset fees e Dual Signature Threshold Represents the amount at which two signers are required to authorize a check e Maximum Check Amount Represents the maximum amount that may be written on a single check e Target Balance Represents the suggested day to day balance for the account e Statement Cycle Date R
130. ensating 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 Transaction Cutoff Times Transaction Cutoff Times are a feature of SmartAnalysisRM that record the time of day at which banks stop processing transactions of a certain type Transaction Cutoff Times are entered using the Using Editable Tables section Transaction Cut off Times Time zone Transaction Cut off Times 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 4 4 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 NOTE 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 purchasin
131. epresents the day of the month that is the statement end period Location Codes NOTE This feature is available as a part of SmartAnalysisRM 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 The Location Codes setup allows you to select all the location codes for an account as well as to Add Edit Location Types To add a location code 1 Select the Manage Location Codes link The Add Edit Location Types dialog displays SmartAnalysis is a trademark of 63 Chesapeake System Solutions Proprietary and Confidential Add Edit Location Types Select Add a Type Select type to edit Mew Type Type Details Short mene ew Type Desonoten Add Edit Location Types 2 Select Add new Location Type New Type in the Short Name field becomes highlighted 3 Enter a Short Name for the Location Type This is a required field 4 Enter an optional Description 5 Select Save All Changes The newly created location code displays in the All Available column of the Locations Code section To edit a location code 1 Select the Manage Location Codes link The Add Edit Location Types dialog displays 2 Using the dropdown select the location type that you need to edit 3 Make your changes to the Short Name or Descriptions fields 4 Select Save All Changes 5 The edited location code displays in the A
132. eral Information 140 Bank Information 140 Statement Period 140 Contact Information 140 Information 140 Account Detail Information 141 Account Hierarchy 141 Adding a new Relationship 141 Adding a new Account 141 Deleting a Relationship 141 Deleting an Account 141 Changing a Statement Account s Name or Number 141 Account Detail 141 Service Charges 142 Bank Code 142 Service Code 142 Description 142 Type 142 Unit Price 142 Volume 142 Total Price 142 Balance Requirement 142 Balances 142 Industry Code 142 Description 142 Amount 143 Rates 143 Code 143 Description 143 Rate 143 Days in Month 143 Days in Year 143 Import Logs 143 Processing a Statement 143 Deleting a Statement 143 Discrepancies 144 Configuring Enabled Discrepancies 144 Discrepancy Process 145 Types of Discrepancies 146 Account Closed 146 Account Detail Missing 146 Ambiguous Service Charge 147 Duplicate Account 147 Earnings Credit Calculation Error 147 Earnings Credit Error 147 Earnings Credit Setup Error 148 Incorrect Reserve Rate 148 Incorrect Service Charge 148 Incorrect Total Balance 148 SmartAnalysis is a trademark of Ix Chesapeake System Solutions Proprietary and Confidential Incorrect Total Service Charge 149 Incorrect Total Service Charge Summary 149 Incorrect Volume 149 Missing Account 149 Missing Charge Information 149 Missing Reserve Rate 150 Missing Total Service Charge 150 Multiple Service Charges 150 Potentially Dormant Account 150 U
133. ervice 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 Oooo O O Incoming Service Code Po Incoming Description Po Comparison Code Identity Information e Incoming Bank Code Represents the identifying string assigned to a service by the bank This is a required field SmartAnalysis is a trademark of 65 Chesapeake System Solutions Proprietary and Confidential e Incoming Service Code Represents the identifying string defining the service based on the industry standard codes This is a required field e Incoming Description Represents the charge description e Comparison Code Represents the cross bank comparison code used to perform queries and reports across banks with differing negotiated fees 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 Discrepancy Tolerance 5 Do O O Monthly Expected Volume Do O O Volume Tolerance 5 Po Charge Change Tolerance Po Tolerance Information e Allowable Occurrences Indicates to the discrepancy processing system how many charges with this ide
134. ess 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 SmartAnalysis is a trademark of 04 Chesapeake System Solutions Proprietary and Confidential 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 Balance Based The Balance Based rate is based on the bank account balance For instance if the balance was over 5 000 but under 20 000 then the fee would be 100 but if the balance was 20 000 and over the fee might be zero and anything under 5 000 the fee might be 250 The fee could also be a instead of amount Export Negotiated Fees to CSV You can save the negotiated fees in the Coma Separated Value CSV format by clicking Export Negotiated Fees to CSV at the bottom of the Negotiated Fees tab You can select the structures under one bank or multiple banks To export negotiated fees to CSV 1 Select Eart Negotiated Fees to CSV The Select file dialog displays 2 Browse for the location 3 Enter the File name 4 Select Save The Export File Generated
135. ete Primary Information Address Informathon Hane fides Tle Email Cry Department State Phone Number Zip it Phone Humber Country Fax Number mad Mobile Humber Specialized Infonmetion Contact Type Notice Required General Information Negotiated Fees Contacts GLExport The Relationship Editor Contacts Tab Contact information is entered Using Selectable Tables by selecting the Add button Alternatively you can select the Import button to import the desired csv file required to populate these fields Primary Information The Primary Information includes the name title department email 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 E mall chobbesmusbank com Department Fhone Number o00 555 9155 Alt Phone Number Fas Humber Mobile Number l Primary Information Address information The Relationship Editor Contact Tab also provides an area to enter the contact s address information SmartAnalysis is a trademark of 96 Chesapeake System Solutions Proprietary and Confidential Address Information cy Sd Address Information 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 en
136. for a service If the calculated fee is less than this amount this amount should be charged e Maximum Fee Represents the maximum fee that will be charged for a service If the calculated fee is greater than this amount this amount should be charged 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 Flat Rate Per Unit Rate Threshold Rate Tiered Rate Balance Based Selecting a rate type Rate Details Flat Rate Per Unit Rate Threshold Rate Tiered Rate Balance Based 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 Per 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 Threshold Rate Tiered Rate Balance Based SmartAnalysis is a trademark of 67 Chesapeake System Solutions Proprietary and Confidential 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 Flat Rate The value for this type of rate is evaluated alone and the amount listed is the expected total amount Rate Details O Flat
137. for what you selected 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 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 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 related to any of the deleted relationships or accounts will be deleted from the statement 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 Changing a Statement Account s Name or Number Changing the Name You can modify this field to update its name by selecting a relationship or account in the Account Hierarchy Changing the Number You can modify this field to update its number by selecting a relationship or account in the Account Hierarchy Account Detail This section provides tables to modif
138. formation Additional Information Earnings Credit Information Month Operand Discrepancy Tolerance Earnings Credit Formula Transaction Cutoff Times The Bank Editor Contacts Tab Creating a Bank Editor Contacts Tab Importing your Contacts Manually Entering Contact Information Bank Editor Authorized Associates Tab Primary Information The Bank Editor Balance Mappings Tab The Case Folder Tab Deleting a Bank Archiving a Bank Creating a Relationship Editing a Relationship General Information Tab Identity Information Tolerance Information Additional Information Negotiated Fees Tab Identity Information Tolerance Information Boundary Information Rate Information Per Unit Rate Flat Rate SmartAnalysis is a trademark of vi Proprietary and Confidential Chesapeake System Solutions 17 22 23 25 26 26 27 Dik Zi 28 29 29 29 30 30 31 31 32 34 34 35 35 35 36 36 36 37 37 37 37 38 39 39 39 41 4 41 43 45 46 47 47 47 48 49 49 50 50 51 51 a2 52 53 Threshold Rate Tiered Rate Balance Based Export Negotiated Fees to CSV Change History The Relationship Editor Contacts Tab Primary Information Address Information Specialized Information Relationship General Ledger Allocations Managing Detail Accounts Deleting a Relationship Creating a Detail Account Editing a Detail Account General Information Tab Identity Information Tolerance Information Additional Information Specialized Information
139. from the Comparison Code dropdown list Add Edit Comparison Codes Gx Select Add a Comparison Code Comparison Code 00 0001 Ledger Balance Average Positive w Comparison Code Details Code 00 00 02 Ledger Balance Average Positive The sum of the daly ending postive ledger balances dded by the number of days n the analyse pened Balances are net of current period adjustments TI BALANCE AND COMPENSATION INFORMATION we 1 The Comparison Codes Dialog 3 The Comparison Code Details will display Make any desired edits The code and description attributes are required If desired you may assign this code to a comparison code family 4 Select Save All Changes to save your edits Deleting Comparison Codes To delete Comparison Codes follow these steps 1 Select Edit gt Comparison Codes The Add Edit Comparison Codes dialog displays 2 Select the comparison code to delete from the Comparison Code dropdown list SmartAnalysis is a trademark of 180 Chesapeake System Solutions Proprietary and Confidential Select Add a Comparison Code Comparison Code 00 0001 Ledger Balance Average Positive w add new Comoe Cod Comparison Code Details Code 90 00 01 Diapay Name Ledger Balance Average Postive Desmiptoni The sum of the daly ending postive ledger balances divided by the number of days in the analysa pened Balances are net af current penod adjustments
140. g SmartAnalysis RM please contact your sales associate SmartAnalysis is a trademark of 38 Chesapeake System Solutions Proprietary and Confidential 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 Information Authorized Associates Balance Mappings Case Folder The Bank Editor Contacts Tab Contact information is entered with a selectable table by selecting the add button and manually adding the Primary Information Address Information and Specialized Information Alternatively you can select the Import button and select the desired csv file containing this information to import into these fields Creating a Bank Editor Contacts Tab To create the Contacts Import File 1 Open Microsoft Excel 2 Enter the contact information in the following format Name Title Email Dept Phone Alt Phone Fax Mobile Address City State Zip 3 Save file as a csv file Importing your Contacts To import your contacts 1 Select the Import button The Select File to Import dialog displays 2 Browse and select the csv file containing your contact information 3 Select Open The file populates the Contacts fields Manually Entering Contact Information Primary Information The Primary Information includes the name title department email address and phone numbers of
141. ge Variance Minimum Variance Maximum Variance Variance e Assignees may be selected to narrow the results to discrepancies assigned to the selected users Assignee ie Assignee e Extra Options allows you to choose to Show audit trails Extra Options Show audit trails SmartAnalysis is a trademark of 103 Chesapeake System Solutions Proprietary and Confidential Extra Options e Report Output Types gives you the option to view the report in either PDF Output or CSV Output Report Output Type PDF Output CSV Output Report Output Type 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 Period Bank Code Sensor Code Change Oesonpdtion Pernod June 01 2005 to June 30 2005 Bank Of America 127000958 Discrepancies for ABC Toys LLC 13330017M Incorrect Senate Change Orscrepancies Account ABS Toys LLC 1332001724 has been charged a fee of 30 50 wih a per une fee of 0 2 and a volume of 2 for servece code 01 01 01 and bank code EIH According ip the SmarAnalyss negetated fee setup for this code the charge should have been 0 5 0 2 x 2 0 E2004 010101 CREDITS POSTED OTHER 0 02 hae yrs OFEN Account ABC Toys LLC 1333001724 has been charged a fee of 4 03 wiih a per un fee of 0 3 and a volume of 13 for service code 01 01 00 and bank
142. ging the handles located on either the left or right side of the toolbar SmartAnalysis is a trademark of 7 Chesapeake System Solutions Proprietary and Confidential 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 selecting hal on the far right of the toolbar This drop down menu can contain additional commands related to the view Banking Structure Banking Structure View toolbar 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 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 menu bar and select the desired view from the resulting drop down menu The selected view will open within the currently displayed per
143. h time a statement is processed for discrepancies Incorrect Total Service Charge Summary Description SmartAnalysis 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 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 Missing Account Description SmartAnalysis generates this discrepancy when the statement is showing an account that is not defined in the SmartAnalysis bank setup Missing Charge Information Description SmartAnalysis generates this discrepancy when the bank setup is defined using the 822 file as a basis to create all bank relationship accounts and associated fee structures anda charge is found that doesn t contain enough pricing information to create either a tiered o
144. hange History Sections Incorrect Service Change Be 65 55 52 Test fee 52 10 31 2005 10 0000 Unassigned OPEN Account B 11001 Chick to view the related Negotiated Fee Account Account B 11001 has been charged a Aat fee of 60 00 For service code 55 55 52 and bank code B2 According to the SmarbAnalysis negotiabed fee setup For this code the charge should have been 5000000 Hat fee Variance Assigned To Satus Account Fee a Aubo Resolve There is mo hishory For this discrepancy ql Add Comment i Send E mail U Insert Attachment O Gait Statement e Information Fields e Change History e Links Information Fields SmartAnalysis is a trademark of Type Provides the type of discrepancy Refer to the 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
145. have created the What If bank you can begin to evaluate the changes made to your fee structure by creating what If scenarios The What If scenarios provide a detailed comparison of all banks selected for the scenario This can include a combination of all existing banks all What If banks or a combination of both existing and What If banks The changes derived from the What lIf process may be an increase or a decrease in the volume for a particular AFP code a change in the fee structure example a move from a per unit fee to tiered pricing or a change in the amount paid for a specific service These changes are reflected in the What If Scenario Summary which can be printed or exported to a tab delimited or comma delimited text file Creating a What If Bank using a Current Bank as a Baseline To create a What lf Bank using a current bank as a baseline 1 Select a what from the toolbar 2 In the What lf Banking Structure window right click the bank that you want to use as the baseline This list contains only those banks that are currently set up in the Bank Manager 3 Select Create New What lf Bank From This Bank An entry will display on the list noting that it is a copy of the selected banking structure Manually Creating a What lf Bank You may want to include banks that are being evaluated for future use but are not currently part of the SmartAnalysis process These Banks do not already appear in your Bank Manager so you wi
146. he signer assignments tab at the bottom of the user interface The Signer assignment screen consists of two tables The table on the left shows all signers currently SmartAnalysis is a trademark of 11 Chesapeake System Solutions Proprietary and Confidential unassigned to the account The table on the right shows the signers currently active on the account cif Signer Assignment test izes Detail Account Editor Signer Assignment Managing detail account signers Four icons are available to manage assignment of signers These are x Remove all signers from the account IEJ Remove selected signers from the account 4 Add all signers to the account ic Add selected signers to the account SmartAnalysis is a trademark of 72 Chesapeake System Solutions Proprietary and Confidential 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 Odd a new Signer Adding a new Signer Detail Account General Ledger Allocations Entering allocations To enter an allocation select Add 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 alloca
147. hese 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 SmartAnalysis is a trademark of 88 Chesapeake System Solutions Proprietary and Confidential Excel Output Excel Output files will be opened by Microsoft Excel for those machines with Microsoft Office installed NOTE It is possible to save the report criteria Please see Saved Report Criteria for details 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 1 Select the desired report from the Report Selection View 2 Define the criteria and Save The Edit Report Criteria dialog displays 2 Enter a unique name for the report criteria that you want to save and select OK Edit Report Criteria Input the name for this saved criteria incorect Service Charge Discrepancies For Bank OF America Quarter To Date Cancel The Saved Report Criteria Dialog 3 The Saved Report Criteria
148. hich you want to add the relationship A dropdown menu displays 3 Select New gt What lf Relationship for selected What Ilf Bank The What lf Relationship Information window displays SmartAnalysis is a trademark of 204 Chesapeake System Solutions Proprietary and Confidential What lf Relationship Information General Information Mame Account Number Negotiated Fee Informstion Incoming Bank Code Incoming Service Code Comparison Code Incoming Description Service Infomation New Negobished Fee Blank fes Mew Negotiated Fes Blank fer Identity Information Incoming Bare Goce Incoming Service Code Incoming Cxrscription Nie Negotiated Fee Comparison Coie il Whiat IF Yoluma Override Rate Details Per Lint Rate C Flat Rate 2 Per Link Rake C Threshold Rate C Tiered Rate What lf Relationship Information window 4 Enter the Name This is a required field 5 Enter the Account Number 6 Select Add in the Negotiated Fee Information 7 Enter the Incoming Bank Code This is a required field 8 Enter the Incoming Service Code This is a required field 9 Enter the Incoming Description 10 Select the Comparison Code from the dropdown list 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 ident
149. ial 2 Save Resources Ea Select the resources to save O Bank Of America California 127000353 Bank Of America E Select All Deselect All rea The Save Resources Dialog 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 f 1 problem s were encountered while attempting to save the Bank lt lt Details Bank 4564 Number i required The Validation Failure Dialog SmartAnalysis is a trademark of 10 Chesapeake System Solutions Proprietary and Confidential Closing Views And Editors Views and Editors may be closed by clicking the Close icon 1 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
150. ial Amount Refers to the amount for the balance Rates This table allows you to add delete and modify rates for the selected relationship or account Code Refers to the code representing the type of rate Description lf the description for the rate code is available it is displayed here This is a read only field Rate Refers to the rate value Days in Month Informational only Days in Year Informational only 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 Processing a Statement Right click on the statement to process the statement If the statement is already processed you will be prompted with a message 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 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 SmartAnalysis is a trademark of 143 Chesapeake System Solutions Propr
151. icaton log fhes wil be attached to thes emil to aiast Support in sahing fhe problem boi The help support email form SmartAnalysis is a trademark of 211 Chesapeake System Solutions Proprietary and Confidential 3 Select Send What Changes to the SmartAnalysis Interface Would Make It Easier to Use We are very interested in hearing about your experiences 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 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 Support for International Banking Compensation Initiative Statements Recently a first draft of an international standard for bank compensation analysis statements was submitted for
152. ies Account ABC Toys LLC 13339001724 has been charged a fee of 0 50 wiih a per unt fee of 0 2 and a volume of 2 for service code 01 01 01 and bank code E2004 Acoarding to the SmartAnalyan negotated fae setup for ihr code ihe chanpe should have been 0 5 0 2 x 2 0 gag Di Di Di CREDITS POSTED OTHER O02 chessys OPEN Account ABC Toys LLC 1339001724 has been charged a fee of 4 03 wah a per umi fee of 0 3 and a volume of 13 for service code 01 01 00 and bank code E2003 According to the SmarAnalysis negotated fee setup for this code the change should have been 4 4 0 2 x 13 0 B2003 010100 DEBITS POSTED OTHER 439 chessys OFEN Discrepancies By Period Report Results Data SmartAnalysis is a trademark of 105 Chesapeake System Solutions Proprietary and Confidential Discrepancies By Type Report The Discrepancies By Type Report displays discrepancy records organized by type and banking entity Report Criteria Sample The report requires that you select at least one entity from the Entity Selection criteria Discrepancy types may be selected to narrow the results to the specified types Discrepancy statuses may be selected to narrow the results to the specified statuses A date range can be entered to narrow the results to the specified time period Variance amounts can be entered to narrow the results to discrepancies that fall within the variance amount range Assignees may be selected to narrow the results to discrepancies
153. ietary and Confidential Entity Selection Banking Operational Corporate A 41705459 THE ABC Company eal 12121 RELATIONSHIP SUMMA ga area Structure fal 3629050 RELATIONSHIP I District 1 Ls 1481850 NY Centers L5 2030906 NH Centers 5 3326085 DE Centers iy 4102612 CT Centers t a 4112749 MA Centers i i 4159983 RI Centers f District 2 L5 S967 702 NJ Centers l 5 5967717 PA Centers 1 lt gt 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 Le 41705459 THE ABT Company CaM 12121 RELATIONSHIP SUMMARY Grea Structure Te Region A k Retail s gt QuickFind e Description An Operational 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 SmartAnalysis is a trademark of 21 Chesapeake System Solutions Proprietary and Confidential Entity Selection Banking Operational Corporate 41705459 THE ABC Company 12121 RELATIONSHIP SUMMA h ga rea Structure 73629050 RELATIONSHIP 22 Districl 1 1481850 NY Centers L5 2030906 NH Centers i L5 3326085 DE Centers L5 4102612 CT Centers E5 4112749 MA Centers E5 4159983 RI
154. ietary and Confidential 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 comparison code bank code exception type status responsibility and variance amount Configuring Enabled Discrepancies There are numerous discrepancy types that are available when performing a discrepancy query Because you may not wish to see every discrepancy type or you are only interested in viewing specific discrepancy types SmartAnalysis provides a feature that will allow you to customize your discrepancy search based on your individual requirements To select the discrepancy types that you want to see when pe
155. iew e Select the ion from the discrepancy results window SmartAnalysis is a trademark of 156 Chesapeake System Solutions Proprietary and Confidential or select the drop down list and select Resolve All Discrepancies Discrepancy Results are Resolve All Discrepancies West Coast Account 0700497534 2 741 51647 Earnings gt Cie alain Er RELATIONSHIP SUMMARY 0700 1 50000 Linknown Tote Service Charg A Resolve Selected Discrepancies RELATIONSHIP SUMMARY 0700 1 08000 Linknown Total Service Charge OIE STS prank RELATIONSHIP SUMMARY 0700 0 64000 Linknown Total Service Charge FED RES DISTRICT 12 4 06 ITEM at m nate t 0700497534 0 01055 caress Credit Calculation Error mrze i 2 a A a i Pi Faim nle Fah ee ie OR PPP MPEP PTE iti rna PPr 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 Discrepancy Results West Coast Account o700997591 T TALSI Team Credit Salon er Resolve Al Discrepancies RELATIONSHIP SUMMAR Y 070 1 50000 Linknown Total Service Charg _ Resolve Selected Discrepancies RELATIONSHIP SUMMARY apie 1 08000 Linknown Total Service Charge rr z RELAT
156. ify balances and service charges SmartAnalysis is a trademark of 205 Chesapeake System Solutions Proprietary and Confidential 11 Enter the What If Volume Override 12 Select the desired Rate Details option You may choose from e Flat Rate Selecting this option enables the Flat Rate field Enter the appropriate Flat Rate e Per Unit Rate Selecting this option enables the Per Unit Rate field Enter the appropriate Per Unit Rate e 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 Selecting this option enables fields where you select e Before Threshold Rate 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 Rate that will be charged for volumes above the threshold e Tiered Rate A tiered rate is a fee structure relating a per unit fee to an activity level The tiers must be sequential without gaps in the coverage or overlap Each tier must have a rate specified Selecting this option enables fields where you can add e Lower Bound The first tier must contain a 0 value as It is the lower bound e Upper Bound The final tier must have a blank upper bound
157. indow 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 NOTE The account assignment table is read only SmartAnalysis is a trademark of 81 Chesapeake System Solutions Proprietary and Confidential E Albert Finklehopper X As Signer Information Abert Finklehapper Primary Information Specialized Information Name Albert Finklehopper Lirnit 100 000 00000 Tile Signer Type Fecsinie J Email alinklehoppertrogspace com Department Phone Number Bed 4 557 51 Alt Phone Humber Fax Number Mobile Humber l Assignment Details Added Date The Signer Editor 3 Save your changes 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 Al SIQhers View X The Signer View Toolbar 3 Select Yes to confirm delete NOTE Changes made in a view are automatically and immediately saved to the database Assigning Accounts to Signers There are several ways to assign detail accounts to 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 Relationsh
158. into T Recs 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 Select the option in General System Parameters to enable BAI Volume Confirmation Set the option to SA BAI 2 Import the full month of BAI files for the same month as the 822 statement you are importing reprocessing using the 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 Reguired Information Reporting Period Calendar Month 1 31 Setting the BAI ABA number in the bank editor 4 Open the BAI Transaction Type dialog to ensure that all of the types that 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 6 Assign BAI Transaction Types to Negotiated Fees e For each account that you would like set up for Volume Confirmation open its editor from the Banking Structure View e From here select the Negotiated Fees Tab e For each negotiated fee that you would like t
159. ip will be assigned SmartAnalysis is a trademark of 82 Chesapeake System Solutions Proprietary and Confidential Detail A The selected Detail Account will be assigned ccount Sj All accounts in the dragged signer will be assigned to the target igner signer Contact Types Contact Types are categories you may define to provide additional information about the nature of a contact To manage contact types 1 Select Edit gt Contact Types The Add Edit Contacts Types dialog displays 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 il echnical Contact x Add new Contact Type Ghort name Technical Contact Description This is the person to call regarding arny problems with the transmission or parsing of thel Bzz 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 Save All Changes when you are finished Account Types NOTE This feature is available as a part of SmartAnalysisRM 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 na
160. iption SmartAnalysis generates this discrepancy to each bank statement if the record does not have the required information to calculate the Earnings Credit amount Resolution The discrepancy message will give you the details on what is missing so you can make the changes to your bank setup Incorrect Reserve Rate Description SmartAnalysis generates this discrepancy when the reserve requirement rate does not match the Federal Reserve rate requirement Resolution Adjust the reserve requirement so that it matches the Federal Reserve Rate requirement 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 negotiated 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 incorre
161. it Price x Quantity 25 STATEMENT CHECK SEQUENCE PER TEM gi 03 20 STROE i 4 792 00 191 68 Unit Price x Quantity 04 EACH COIN FURNISHED 1NROLL 100044 ROCKS win 81 00 3 10 Unit Price x Quantity COPY OF CHECK OFFICE 36 0045 13 42 TELO 1 6 00 3 00 18 00 Unit Price x Quantity EACH CURRENCY FURNISHED 1000 48 ROCKS p00 447 600 00 442 80 Unit Price x Quantity 1 00 1000 EAST COAST BASE FEE 15T 4500 00 CHO300 225 00 2 00 450 00 Unit Price x Quantity ACCT 225 00 V0C0UNT EAST COAST CHECKS PAID 1501 10 CNO 1 115 3 155 00 473 25 List Price WID AR 5 151TEM PHOTOCOPY SERVICE 5 00 457342 ARPIOE 6 00 10 00 60 00 Unit Price x Quantity EACH Total Service Charges 1 726 83 Eamings Credit Amount min Total Amount Due 1 726 83 Service Charges SmartAnalysis is a trademark of 139 Chesapeake System Solutions Proprietary and Confidential Save a copy Click the Save as Copy icon in the upper left corner of the window to save a copy of the statement shown in the Statement Viewer Print a statement Click the Print icon in the upper left of the window to the right of the Save icon o print the statement shown in the Statement Viewer 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 Impact on Discrepancies Once you edit a statement that has already been processed its current discrepancies become out of d
162. it Statement Permits the user to modify a statement in the SmartAnalysis Statement Editor Reprocess Statement SmartAnalysis is a trademark of 188 Chesapeake System Solutions Proprietary and Confidential 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 to review and ex
163. iteria entered in the Fee Query Criteria View Sorting Charge Information Bank Code Service Code Description Unit Cost Total Units Total Cost Bank ABA Number ocount Name Account Numb 00021 01 OD 00 ACCT M 12 00 24 00 2 00 AMSOUTH BAME 062000019 Corporate RELATIONS M7171 00100 01 01 OO FIFC TR 09 1 44 l6 00 ARSOUTH BARE O6A000019 Corporate PELATIONS ill 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 Charge Count The total number of charges returned by the query Charge total The sum total amount of the service charges returned Selected Charge Count The number of charges currently selected in the table Selected Charge total The sum total of the service charges currently selected SmartAnalysis is a trademark of 170 Chesapeake System Solutions Proprietary and Confidential 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
164. ith an area to add comments case notes and attachments to the file and to email those entries to a selected email address Selecting the Case Folder tab displays the history for the bank Bank Information Contacts Authorized Associates Balance Mappings Case Folder Case Folder Tab 1 On the Bank View select the Case Folder tab The Bank Case Folder window displays the history for the bank 2 Select Ly Add Comment to attach a note to the case folder The Enter a note to attach dialog displays SmartAnalysis is a trademark of 43 Chesapeake System Solutions Proprietary and Confidential Enter a note to attach Tite Contents There have been contact changes made for thas hank 3 Enter the Title of the comment 4 Enter the Contents of the note to be attached to the case folder 5 Select Save The comment displays in the Bank Case Folder Bank Case Folder C Comment made by chessys on 00 15 2011 Tile Change Bank Case Folder Comment 6 To send the displayed bank case folder to an email recipient select 2 Send E mail SmartAnalysis is a trademark of 44 Chesapeake System Solutions Proprietary and Confidential Bank E Mail E mail information Frami Prowl chessys com Tas hyvitasdichessys com Ce Subject Contact Changes Message Contact changes have been made 7 Enter your From email information 8 Enter the To email address or select the arrow and chose
165. ither by double clicking the bank or by selecting Edit from the context menu The Bank Editor General Information Tab Basic information concerning a bank including name ABA Swift 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 Case Folder The Bank Editor General Information Tab SmartAnalysis is a trademark of 35 Proprietary and Confidential Chesapeake System Solutions Required Information Required information for all banks includes the bank s name ABA or Swift number and reporting period The field labeled BAI ABA Number will only display if SA BAI is selected for Enable volume confirmation on the General tab of the Systems Parameters dialog Required Information Reporting Period Calendar Month 1 31 Required Information Address Information If Known the bank s address information can be entered in the Bank Editor NOTE Selecting a country other than United States will replace the States field dropdown menu option with a data entry text field for State Region Address Information Address City Zip Postal Code Address Information Additional Information It is possible to add additional contact information for a bank including the main phone number the customer service phone numbers and the website in th
166. itrary categorization of the account s purpose Can be entered or modified on the Detail Account Editor in the Specialized Information section e Target Balance The target balance for the account Can be entered or modified on the Detail Account Editor in the Specialized Information section e 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 e 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 SmartAnalysis is a trademark of 93 Chesapeake System Solutions Proprietary and Confidential NOTE Active signer information for the account is displayed below the specialized information Account Status For West Coast Account 0700497534 Disbursement Account 10 000 00 Main AP Account Used for all general business payment our of the home office 5 000 00 Maximum Disbursement Anount Te me Kristin Smith CFO Facpimile 00 000 00 dason Yankus Treasury Manager Manua 10 000 00 Total Number of Signers 2 Overall Account Status Report Summary Fee Structure Audit Report The Fee Structure Audit Report provides the capability to report upon the change information for Fee Structures in the SmartAnalysis bank setup To run a Fee Structure Audit Re
167. k Operational Af JPMORGAN CHASE BANK N A 021000021 E gy JPMORGAN CHASE BANK N A 071000013 E ii WELLS FARGO BANK M A 121000243 t Bank Codes Service Codes 00 02 30 DEF INSURANCE ASSESSMENT MTHLY 01 00 00 ACCOUNT MAINTENANCE 0100 20 ZERO BALANCE MASTER ACOGUNT 0100 21 ZERO BALANCE SUG ACCOUNT 010100 DESITS POSTED 0101 02 CREDIT POSTED ELECTRONIC 0101 12 CONTROLLED DISS FUNDING 0103 07 BASIC PLUS INTERNET STATEMENT 0103 10 ADDITIONAL ADDRESS PAPER x Comparison Codes 0000 00 Ledger Balance Average Net A 00 00 01 Ledger Balance Average Posive 100 00 02 Ledger Balance Average Daly Positive 00 00 03 Ledger Balance Average Negative 00 00 04 Ledger Balance Average Dally Negative 00 00 05 Ledger Balance MontheGnd 00 00 10 Cobected Balance Average het z Quickfind AW 17 alara Ralanra Duanana Deets Display data for 12 Months up to and including Comparison Code Families Month March fear 211 he 00 BALANCE AND COMPENSATION INFORMATION A rroma ba 01 GERERAL ACCOUNT SERVICES n by 05 LOCKHEON SERVICES Yoke Type _ S 06 PAYROLL CARD SERVICES 07 MERCHANT CARD SERVICES E Total Amount Ci Relationship O08 PURCHASING CARD SERVICES E 10 DEPOSITORY SERVICES ahah Detal Account 15 PAPER DISBURSEMENT SERVICES C Volume 16 RETAINED ASSET SERVICES v Report Output Type POF Output CSV Output C Esl Outpu
168. l Ee Select a date E4 The calendar date chooser Once a date is selected and the selector is closed Axl the date will appear in the date entry field Dynamic Date Ranges For reports and queries that use a date range SmartAnalysis supports dynamic date ranges When a dynamic date range is selected the application calculates the appropriate start and end dates relative to the current date Itis 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 criterion can be used repeatedly without editing to generate monthly quarterly or annual reports Month To Date Quarter To Date Previous Month 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 curre
169. l unit Add Operational Unit Input the name for this operational unit Boston Market Add Operational Unit dialog 2 Select OK The newly created Operational Unit displays under the Operation Structures Editing Operational Units To change the name of an operational unit follow these steps 1 Open the Save Operational Unit Dialog e By double clicking the operational unit SmartAnalysis is a trademark of 11 Chesapeake System Solutions Proprietary and Confidential e By right clicking the operational unit and selecting Edit from the context menu e By selecting the operational unit and selecting the Edit option from the view toolbar aa Operational Structure x PO Wy la TO 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 The Save Operational Unit Dialog 3 Select OK 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 NOTE Changes made in a view are automatically and immediately saved to the database Deleting Operational Units To delete an operational unit follow these steps 1 Select the Operational
170. lance Query executing 141 Balance Query Criteria View 42 Balance Query Perspective defined 141 Balance Query Results view 743 Balances by Type Report columns 84 SmartAnalysis is a trademark of 215 criteria 83 defined 83 details 85 groupings 84 Bank creating 36 edit 36 view 36 Bank Editor authorized associates tab 40 contacts tab 39 general information tab 36 Bank Editor Balalnce Mappings Tab defined 4 Bank Editor Contacts Tab address information 40 primary information 40 Bank Information Cintacts Tab specialized information 40 Banking Information Perspective defined 35 Banking Structure View defined 35 Banks additional contact information 37 address information 37 deleting 42 earnings credit information 38 required information 37 Base Fee 47 60 Baselining defined 104 Before Threshold Rate 62 Change History 50 63 Charge Change Tolerance 44 46 57 59 Comparison Code 46 59 Comparison Code Families creating 147 editing 148 explaining 147 Comparison Codes creating new 145 deleting 146 editing 1 45 introducing 144 Contact Types Chesapeake System Solutions Proprietary and Confidential adding new 75 defined 52 75 Contacts notice required 64 specialized information 64 Contacts by Bank Report defined 85 Contacts By Bank Report 85 columns 86 groupings 86 Context menus defined 6 Context Sensitive Help explained 71 Corporate Resolutio
171. lance Reports H Contact Reports H Custom Reports Discrepancy Reports E aA Discrepancies By Period Repi gt Saved Report Criteria E3 aA Discrepandes By Type Repo 4 Earnings Credit Reports Service Charge Reports i Signer Reports Summary Reports Report Selection View Executing a Report To execute a report 1 Double click the report type in the Report Selection View 2 Inthe Report Criteria Editor enter the criteria for the report 3 Select Execute 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 at least 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 t
172. ld be authorized to sign checks written in amounts up to but not exceeding 1000 00 Cash on Hand Fund Balance start up money that is maintained at each location SmartAnalysis is a trademark of 213 Chesapeake System Solutions Proprietary and Confidential Corporate Resolution a legal document defining which individuals are authorized to act on behalf of a corporation Statement Cycle date the date a statement is produced EDIFACT Electronic Data Interchange for Administration Commerce and Transport NSF non sufficient funds SmartAnalysis is a trademark of 214 Chesapeake System Solutions Proprietary and Confidential Account Closed 114 Account Detail Missing 114 Account Level Tolerance Information Fields defined 44 Account Number 56 Account Purpose 82 Account Purposes adding new 76 defined 76 editing 76 Account Types adding new 76 defined 75 editing 76 After Threshold Rate 62 Allocations entering 65 General Ledger 66 Allowable Occurrences 46 59 Ambiguous Service Charge 114 Authorities View 52 Authority assigning 160 Authority Detail 6 Authority Group assigning 160 Authority Group Editor 62 Authority Groups 52 157 Authority Groups View 6 Authority Groups View 157 Auto Match Codes 42 Average Balance Requirement 82 Average Net Ledger Balance 39 Average Positive Collected Balance 39 BAI Transaction Type creating 164 editing 764 BAI Volume Confirmation 63 Ba
173. lease 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 there is a potential 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 may cause 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 should 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 Earnings Credit Error Description SmartAnalysis generates this discrepancy when there is a problem calculating the earnings credit for the statement Normally this is caused by a required part of the earnings credit formula being missing from the statement SmartAnalysis is a trademark of 147 Chesapeake System Solutions Proprietary and Confidential Resolution Check your bank setup to make sure the correct earnings credit formula is selected for the bank Earnings Credit Setup Error Descr
174. lect the Date Range Your options are e Select Dynamic Range e Manually Set Range 8 Select the Report Output Type Your options are e PDF Output e CSV Output e Excel Output SmartAnalysis is a trademark of 117 Chesapeake System Solutions Proprietary and Confidential 9 Select the desired Service Codes to narrow the results to the specified incoming service codes 10 Select the desired Comparison Codes to narrow the results to the specified comparison codes 11 Select the desired Comparison Code Families to narrow the results to the specified comparison code family 12 Select Execute The Service Summary Report displays Yearly Services Summary Report The Yearly Service Summary Report summarizes data for particular services over the course of the year This report allows the display and analysis of service charge total amounts unit prices and volumes for a full year of data for services selected as part of the criteria Provides totals or averages as appropriate To create a Yearly Service Summary Report 1 Select Report Manager The Report Selection View displays 2 Click the to open the Service Charge Reports folder 3 Select the Yearly Service Summary Report The Yearly Service Summary Report Criteria Editor displays SmartAnalysis is a trademark of 118 Chesapeake System Solutions Proprietary and Confidential Fa 4 Yearly Service Summary Report Report Criteria Ector eiee Entity Selection Ban
175. ll Available Location Codes column To delete a location code 1 Select the Manage Location Codes link The Add Edit Location Types dialog displays 2 Using the dropdown menu select the location code that you want to delete 3 Select Delete The location code is removed from the All Available column of the Location Codes SmartAnalysis is a trademark of 64 Chesapeake System Solutions Proprietary and Confidential Location Codes All Available Selected Code Code 211212712 I Ls 423 789 12487 a Manage Location Codes Location Codes Negotiated Fees Tab The Negotiated Fees Tab of the relationship editor contains information for the expected fees 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 General Information Negotiated Fees Contacts Signers GLExport Bank Confirmations Negotiated Fees Tab Identity Information Negotiated Fee identity information is used throughout the application to match s
176. ll have to add them manually much the same way as you added a bank to the Bank Manager To manually create a What lf Bank 1 Select Z hat TF from the toolbar 2 Select the down arrow on What IF Banking Structure to display a dropdown menu 3 Select New gt What lf Bank The What lf Bank Information window displays SmartAnalysis is a trademark of 203 Chesapeake System Solutions Proprietary and Confidential A What If Bank Information Required Information Name ABA Number Description Scenarios this what if bank is part of What lf Bank Information window 4 Enter the Bank Name This is a required field 5 Enter the ABA Swift Number 6 Enter a Description 7 Select the Save icon on the menu or select File gt Save The new What lf Bank displays in the What lf Banking Structure list 8 Select the Save icon on the menu or select File gt Save The new What lf Bank displays in the What lf Banking Structure list Manually Creating a What If Relationship Once a What lf Bank has been created either manually or using a current bank as a baseline you may want to include a relationship that was not created in the process In this case you can create a What lf relationship manually similar to the way you would using the Bank Manager To manually create a What lf Relationship 1 Select what IF from the toolbar 2 Inthe What lf Banking Structure window right click the Bank for w
177. low to import To import a CSV Service Charge file 1 Select File gt Import Statement The Statement Import dialog displays 2 Select File and browse for the Statement Data File 3 Select the CSV Service Charge radio button 4 Select your options e Produce complete baseline from this statement and or e Open imported statement in viewer 5 Select Finish SmartAnalysis is a trademark of 134 Chesapeake System Solutions Proprietary and Confidential Scheduling CSV Service Charge Files for Import Many SmartAnalysis users may find it convenient to schedule statement imports for subsequent processing In particular users that receive more than a few statements on the same date receive statements on a predictable recurring schedule or both may wish to schedule their CSV Service Charge processing To schedule the CSV Service Charge Import 1 Select File gt Schedule Statement Import The Statement Import dialog displays 2 Enter a Name for this import 3 Select the Files for this import 4 Select Next gt 5 Select the option if you want to Produce a complete baseline from this statement 6 Enter the Recipients for the Status Email NOTE Each email entry must be separated by a comma 7 Select Directory and Browse for the folder which will be the new location for the processed files 8 Select Finish Importing Twist XML Files The international version of a EDI822 file can be imported by selecting the Twist XM
178. lts are subtotaled at each level of grouping ee THE i eed E a DST TT nad 14 Chapt Tain for kiih of Bagara MO ois AILE L Total io hisy 200E a1hiG Services By Month Report Subtotals Producing a summary level report 1 Select banking entities Banks Statements Relationships or Operational Units Banking Operational lite AMSOUTH BANK 062000019 dri Bank OF America 121000358 ig Bank of Chesapeake 012566011 Bank of England MD 052000712 BLUE BOOK OF BANK PRICES 2004 2005 200320000 iy COMMERCE BANK 031201360 ii First Mational Bank 011200321 Ah Wachovia 053000219 E E EF E Services By Month Report Summary Sample Step 1 2 Select Comparison Codes to display or Incoming Service Codes etc SmartAnalysis is a trademark of 115 Chesapeake System Solutions Proprietary and Confidential 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 gg 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 01097 00 General Aeccuot Arhiwike Mehik Bockino lt Mm gt i Services By Month Report Summary Sample Step 2
179. m Earnings Credit Calculation Error Incorrect Total Service Charge Sum Incorrect Total Service Charge Sum Incorrect Total Service Charge Sum Incorrect Service Charge Incorrect Service Charge Incorrect Service Charge Account Yariance Discrepancy Type ia RELATIONSHIP SUMMARY 0693900000 27 269 76000 Incorrect Total Service Charge Sum m Select All Clear All e or select the drop down list and select CSV Export All Discrepancies SmartAnalysis is a trademark of Proprietary and Confidential 155 Chesapeake System Solutions Discrepancy Results Ce LS CO CANINA 1165 aa RELATIONSHIP SUMMA 0 RELATIONSHIP SUMMARY 0 6 976 Incorrect Total Service Change Sum RELATIONSHIP SUMMARY 0 i meore Tota Serko Change ACCOUNT PAINTEHARCE RELATIONSHIP SURPMAY 0 j Incorrect Total Servia Change BAL TRANSMISSION HF pa amar ii ra I rere Lees ae AA oe Ee ae 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 CCA OUR MAY LC LOR OSS0S0002601155 OFS0000 RELATIONSHIP SUPRAVY 0 RELATIONSHIP SUMMARY 0 6 576 Dncorrect Total Sere Change Sum RELATIONSHIP SUMMARY 0 i meore Totel Service Change ACCOUNT PAIWNTENARCE RELATIONSHIP SUMPLRY 0 0 000 incorrect Total Service Change BAL TRANSMISSION E iF e
180. n 172 CSV Output 79 Date Entry Calendar Date Chooser 3 dynamic date range 2 fields 72 manual entry 2 Decimal Precision System Parameters 102 Detail Account manually create 55 reassigning 53 Detail Account Editor editing 55 Discrepancies defined 112 types 113 Discrepancies Assigned To Me Dashboard Element defined 32 Discrepancies By Period Report columns 90 criteria 87 defined 87 grouping 90 Discrepancies By Type Report criteria 89 defined 89 Discrepancy Process explaining 112 Discrepancy Tolerance 44 57 59 172 defined 38 Discrepancy Tolerance 46 SmartAnalysis is a trademark of 216 Dual Signature Threshold 82 Dueling Tables functions 5 using 15 Duplicate Account 114 Dynamic Date Ranges 80 explained 3 Month to Date 3 Previous Month 4 Previous Quarter 4 Previous Year 4 Quarter to Date 3 Year to Date 4 Earnings Credit Calculation Error 114 Earnings Credit Error 115 Earnings Credit Formula defined 38 Earnings Credit Monthly Rate Analysis Report defined 92 Earnings Credit Setup Error 115 Earnings Credit Time Series Rate Analysis Report defined 91 EDI 822 Statement Importer defined 103 Edit Menu functions 4 Editable Tables using 15 Editors closing defined 3 navigating between 9 opening S resizing amp saving 9 Enable earnings credit discrepancy calculation 100 Enable operational structure discrepancy calculation 100 Entity Sele
181. n the fee structure setup for the defined service 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 SmartAnalysis is a trademark of 151 Chesapeake System Solutions Proprietary and Confidential T Recs Import Account is Invalid Description 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 SmartAnalysis can validate the volumes for the account 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 T Recs Volumes Do Not Match Des
182. nassigned Account in Operational Structure 150 Unassigned Relationship in Operational Structure 151 Unexpected Service 151 Unknown Total Service Charge 151 Unusually High Service Charge 151 Unusually High Total Service Charge 151 T Recs Import Account is Invalid 152 T Recs Transaction Type is Invalid 152 T Recs Volumes Do Not Match 152 T Recs Volumes Do Not Match 152 Volumes Do Not Exist 152 Volumes Do Not Match 152 Discrepancy Query 153 Entering Criteria 154 Viewing Results 154 Exporting Results 155 Auto Resolving Results 156 Auto Resolve Wizard 157 Auto Resolve Discrepancy Selection 159 Auto Resolve Results 160 Discrepancy Details 160 Information Fields 161 Change History 162 Adding Notes and Attachments to Discrepancies 162 E mailing Discrepancy Information 165 Updating Discrepancy Status 166 Assigning Discrepancy Responsibility 166 Fee Query Perspective 167 Quick Look Guide 167 Fee Query Criteria View 168 Selecting Criteria 168 The Fee Query Results View 170 Service Charge Comparison 171 Balance Query Perspective 174 Quick Look Guide 174 Balance Query Criteria View 175 Selecting Criteria 175 Balance Query Results 176 Comparison Codes 177 Creating Comparison Codes 179 Editing Comparison Codes 180 Deleting Comparison Codes 180 Comparison Code Families 181 Creating Comparison Code Families 181 Editing Comparison Code Families 183 SmartAnalysis is a trademark of X Chesapeake System Solutions Proprietary and Confidential Sma
183. ncluded 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 eniry 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 Viewing Results After you execute a query the results will be displayed in the Discrepancy Results view SmartAnalysis is a trademark of 154 Chesapeake System Solutions Proprietary and Confidential Discrepancy Results Account Variance Discrepancy Type RELATIONSHIP SUMMARY 0693900000 27 269 76000 Incorrect Total Service Charge Sum RELATIONSHIP SUMMARY 0693900000 RELATIONSHIP SUMMARY 0693900000 THE ABC Company 1465101757 RELATIONSHIP SUMMARY 0693900001 RELATIONSHIP SUMMARY 0693900001 RELATIONSHIP SUMMARY 0693900001 THE ABC Company INC 1465302000 THE ABC Company INC 1465302000 THE ABC Company 3751827393 4 Total Counk 87 Selected Count f
184. ng amp Stand alone 3 Volume Confirmation 62 Volume Confirmation Mappings create new 65 166 Volume Tolerance 45 57 59 Volume Tolerance 46 Chesapeake System Solutions Proprietary and Confidential What If understanding 167 What If Bank creating 168 creating from existing bank 171 manually creating 168 What If Manager SmartAnalysis is a trademark of 220 defined 167 What If Relationship manually creating 169 What If scenario creating 174 Window Menu functions 5 Chesapeake System Solutions Proprietary and Confidential
185. ng 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 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 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 SmartAnalysis is a trademark of 137 Chesapeake System Solutions Proprietary and Confidential Statement Entity Bank of Chesapeake 012566011 Name Type Email Phone Number Fax Number KWN Informational 4154539672 Jose iguana Informational 41570571568 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 Relationship Relatonship Account Information RELATIONSHIP SUMMARY 070048753
186. nlike Editors views do not have a manual process for saving so any changes made via drag and drop are immediately 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 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 SmartAnalysis is a trademark of 3 Chesapeake System Solutions Proprietary and Confidential The Menu Bar The Menu Bar lists the available menus along the top of the SmartAnalysis application window 2 SmartAnalysis File Edt View Window Help The Menu Bar File Menu The File Menu provides access to common functions used within the application The functions are explained below SmartAnalysis wie Edit View Window Help a Schedule Statement Import CErl
187. nt 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 calculated date range is from September 1 2005 through September 30 2005 inclusive SmartAnalysis is a trademark of 13 Chesapeake System Solutions Proprietary and Confidential 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 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 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 specifie
188. ntains 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 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 pdated on Thu Now 3 2005 at 08 44 39 by chessys Incoming Service Code changed from 01 04 00 to 01 04 01 y Change History The Detail Account Editor Contacts Tab Detailed contact information for account representatives is entered on the Contacts tab of the Detail Account Editor located in the bottom left of the interface 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 bottom of the editor interface Contact information is entered Using Selectable Tables Click the Add button to manually add your contact information or Import to import these details on a csv file 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
189. ntical service code to allow when a statement is being processed A discrepancy will be created if this amount is exceeded e Discrepancy Tolerance Represents the 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 e 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 e Volume Tolerance Represents the 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 e Charge Change Tolerance Represents the percent fees can vary month to month before being identified as a discrepancy If entered this value overrides the tolerance set at the account level Boundary Information Negotiated Fee boundary information is used provide charge type agnostic price information Boundary Information SmartAnalysis is a trademark of 66 Chesapeake System Solutions Proprietary and Confidential Boundary Information e Base Fee Represents the initial fee that the bank assesses regardless of the nature of the negotiated fee e Minimum Fee Represents the minimum fee that will be charged
190. o 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 e Once you are done save the editor for each account SmartAnalysis is a trademark of 198 Chesapeake System Solutions Proprietary and Confidential Identity Information Incoming Bank Code 00 00 99 Incoming Service Code 00 00 99 Incoming Description Comparison Code BAI Transaction Type 037 TARGET BALANCE DEFICIENCY 037 TORGET BALONCE DEFICIENCY l f 088 TOTAL FUNDING REQUIREMENT Tolerance Informati i oq TOTAL CREDITS 101 TOTAL CREDIT AMOUNT MTO Rate Details 105 CREDITS NOT Selecting a BAI Transaction Type for a negotiated fee in the account editor 7 Set up Volume Confirmation Mappings e lf you have already assigned comparison codes to each negotiated fee you can simply edit volume confirmation mappings from the Edit Menu e 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 Edit gt BAI Transaction Type The Add Edit BAI Transaction Types dialog displays 2 Select Add New BAI Transaction Type 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 Cod
191. or create new ones and retain comparative scenarios for later review or modification This can be a comparison between existing banks already created in SmartAnalysis or may be a comparison between an existing bank and a fictitious or What If bank The What If module allows you to use existing or fictitious banks service changes and fee structures to create a What If scenario This scenario may be manipulated to evaluate what effect adding or changing specific fee structures will have on gross service charges You may also include banks that are being evaluated for future use but are not currently part of the SmartAnalysis process by manually creating the What If Bank information The What lf module allows you to immediately gauge how changes in the way that you do business with a bank will affect your service charges Additional examples of What If scenarios may include e Analyzing pricing between multiple existing banks e Determining total financial effect of moving services to prospective banks e Determining total financial effect of moving services between existing banks e Determining total financial effect of adding reducing services used SmartAnalysis is a trademark of 202 Chesapeake System Solutions Proprietary and Confidential e Analyzing total cost savings of pricing changes for services e Analyzing effect of anticipated service activity volume changes e Developing comparisons between projected and actual charges Once you
192. ou 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 Wariance Ze Bank Code Assigned To Unassigned Service Code Stabus OPEN Charge Description Date 06 30 2005 ACCOUNT RELATIONSHIP SUMMARY OS0003200200 Fee No Negotiated Fee is available Description The account RELATIONSHIP SUMMARY OS0003200200252 was found on the statement but has been marked as Closed in bank setup on 04 01 2005 Change History fl L Comment made by chessys on 08 15 2005 Sa Auto Resolve Title Research This is being researched by Chris m ed Send E mail W File Attached by chessys on 0815 2005 Reoort xis U3 Insert Attachment gt View Statement SmartAnalysis is a trademark of 164 Chesapeake System Solutions Proprietary and Confidential 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
193. our Login Security System Parameters you may also be forced to change your password during login In either case follow the steps below 1 Select Change Password on the login screen The Change Password window displays SmartAnalysis Login Please enter your Username a Password te to login to EEN Usemame o Password Cancel Change Password 2 Enter your current username and password as well as your desired new password Re enter your newly selected password in the Confirm New Password field Change Password Please enter your curent username and password and your new password Usemame chessys Curent Passwords New Password fmm Confirm New Password fr o cae 3 Select OK 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 NOTE The next time you log on to SmartAnalysis you will have to use the new password you entered Troubleshooting a Failed Login Attempt There are a number of reasons why a login attempt may have failed SmartAnalysis is a trademark of 26 Chesapeake System Solutions Proprietary and Confidential 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 re enter your username and password Account Not Created
194. peake System Solutions Proprietary and Confidential Auto Resolve Discrepancy Selection Discrepancy Auto Resolve Select Actions Select the actions that will be performed on each discrepancy Discrepancies that can be resolved Unresolvable discrepancies a Incorrect Service Charge Incorrect Total Service Charge 7 Incorrect Service Charge Incorrect Total Service Charge H Missing Account Incorrect Total Service Charge Summary F Missing Reserve Rate Missing Total Service Charge H Missing Reserve Rate Missing Total Service Charge F Unexpected Service Missing Total Service Charge Description of selected discrepancy Account Account 6 11001 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 B3 According to the SmartAnalysis negotiated fee setup for this code the charge should have been 0 50000 0 10000 x 5 00000 Gction s 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 lis
195. port 1 Select the Report Manager The Report Selection View displays 2 Click the to open the Audit Reports folder 3 Double click Fee Structure Audit Report The Fee Structure Audit Report Criteria Editor displays SmartAnalysis is a trademark of 94 Chesapeake System Solutions Proprietary and Confidential rp Fee Structure Audit Report Report Criteria Eitor Entity Selection Banking Operational Ge Jy Bank Of America California 121000358 E Citigroup Ine 022000089 E f ANG Unit Test 173456709 E ify Infor Trim Group Divison 024009593 W uh 113000509 H Pal FRAGAN CHASE BNE MA 022000021 E STATE STREET Bane 011000028 fe fy TO Bank 260135737 Ge iy TD Bark 026013873 Goi U S BANK 123000848 E f WELLS FARGO BANK N A 121000248 Gel iP WELLS FARGO BANK N A 102000078 Chaciefing Date Range Select Dynamic Range Manualy Set Range Audit Type CG POF Output CSV Output Execute Clear Criteria Fee Structure Audit Report 4 Select the Entity for which you want to view the fee structure audit report 5 Enter the Date Range if desired A date range can be entered to narrow the results to the specified time period Your options are e Select Dynamic Range SmartAnalysis is a trademark of 95 Chesapeake System Solutions Proprietary and Confidential Month To Date rn Quarter To Date a Year To Date Previous Month Previous Quarter b Dropdown menu for s
196. pulates the fields below the table with the entire detailed data that the row in the table represents Click Add to add a row to the table Enter the new data in the fields and then Save the editor 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 example 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 Ki 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 E Adds all remaining elements in the master list These elements become part of the included list The master list is now empty Transaction Cutoff Times Transaction Cutoff Times are a feature of SmartAnalysisRM 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 Type a time and
197. purpose 79 Report Selection View defined 78 Report Types 78 Reports executing 79 understanding 78 Required Fields defined 77 Reset Perspective 6 Save defined 4 Saved Report Criteria 78 defined 80 deleting 81 editing 81 SmartAnalysis is a trademark of 218 executing 80 Schedule Statement Import 4 Security Concepts 52 Security Manager Perspective 57 Select Dashboard Layout 34 Selectable Table using 5 Service Charge Comparison 138 performing 138 Services By Month Report defined 94 Settlement Method 56 Signer adding new 65 Signer Assignment 64 Signer Status Report defined 97 Signers assigning detail accounts 74 creating 72 deleting 74 editing 73 Signers View 72 74 opening 72 SmartAnalysis accessing 27 SmartAnalysis Comparison Codes 4 smartAnalysis Security Authorities 52 157 160 SmartAnalysisRM 1749 enablement 50 features 150 reports 5 Statement copying 105 viewing 105 Statement Import Wizard accessing 103 Statement Structure 105 Statement Viewer 104 Statements deleting 111 editing 108 managing 103 processing 111 saving 108 System Parameters Chesapeake System Solutions Proprietary and Confidential accessing 98 defined 98 Tables dueling 5 editable 4 read only 74 selected 5 sorting columns 5 Target Balance 82 The Authority Group Editor 62 Threshold 62 Threshold Rate defined 49 entering 49 62 explained 61 Tiered
198. r SmartAnalysis is a trademark of 149 Chesapeake System Solutions Proprietary and Confidential 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 Missing Reserve Rate Description SmartAnalysis generates this discrepancy when a rate matching the Federal Reserve requirement rate is not found in the account Missing Total Service Charge Description SmartAnalysis generates this discrepancy when a service charge Is found for a statement account and no related charge exists for the relationship summary account 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 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 for potential closing Resolution When this discrepancy is identified it is suggested that the account be investigated to see if it can be clos
199. r 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 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 SmartAnalysis is a trademark of 19 Chesapeake System Solutions Proprietary and Confidential Edit View Window Help O Save cirl s la Eh Import Statement Ctrlt Eh Schedule Statement Import Ctrl Alt 4 Open File Export GL Data Exit General Ledger Export Once the menu option
200. rage Met a 000001 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 Ledger Balance Month End 0000 10 Collected Balance Average Net nn 141 Collected Balance fverane Pricikivve Selecting comparison codes will constrain the results to those service charges whose associated negotiated fees which have the selected comparison codes assigned to them SmartAnalysis is a trademark of 169 Chesapeake System Solutions Proprietary and Confidential Comparison Code Families 01 General Account Services P 05 Lockbox Services OF Merchant Card Services IF 08 Purchasing Card Services 10 Depository Services 15 Paper Disbursement Services 16 Retained Asset Services 70 Paner Kichorcement Beconciliation Service 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 gt 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 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 cr
201. rage Positive 00 00 13 Cofected Balance Average Negative 00 00 20 Batance Nor Interest Bearing CO AP Si Bales a Geet Ta Deere gt Quacicfird Date Range Select Dynamic henge Manually Set Range Suppress Zero Valves _ Suppress Zero Values Report Output Type PDF Output CSV Output Gear Gite Balances By Type Report 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 e You have the option of a PDF or CSV Report Output Type e You have the option to Suppress Zero Values if desired 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 SmartAnalysis is a trademark of 97 Chesapeake System Solutions Proprietary and Confidential Balances By Type industry Cade Accomm Munn Anoa Marne Halang Arraut Bank of Chegapeake 012560011 July 01 2005 00 00 10 OF Dae 534 Wiest Coast Anoourt 277 615 50 00 00 10 G06000714 East Coast Account 000 00 00 i0 OF Dai 55 RELATIONSHIP SUMMARY 277 615 50 Augues 01 2005 og 00 10
202. rain the results to those service charges that exist on statements whose dates fall within the date range specified See Dynamic Date Ranges SmartAnalysis is a trademark of 168 Chesapeake System Solutions Proprietary and Confidential Incoming Bank Codes 0000S CHECKS PAID rS 00004 DEPOSITS l 00021 ACET MAINT IF 00099 FDIC amp SSESSMEMT 00100 ACCOUNT MAINTENANCE OO102 CHECKS P4ID DEBITS 00103 DEPOSITS CREDITS ANIAN TELEPHONE KIOTIFTCOATION MATMTEM lt gt 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 O0 00 UNENC DEP RECON BRANCH DEP IT 00 0i 41 NEGATIVE COLLECTED BALANCE RT 00 O24 10 MEn COLLECTED BAL INTEREST CH 00 O2 30 FDIC ASSESSMENT OO 03 35 CYCLE SERVICE CHARGE O1 00 00 ACCOUNT MAINTENANCE 01 00 20 MASTER ACCOUNT MAIN TENGE Oo F1 MFP RECON SUR coo IMT MATTE x l gt 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 Ave
203. red Rate Balance Based 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 Balance Based Rate Details O Flat Rate Per Unit Rate Threshold Rate Tiered Rate Balance Based Balance Based SmartAnalysis is a trademark of 69 Chesapeake System Solutions Proprietary and Confidential NOTE Negotiated Fees can be exported to a CSV file by clicking the following link at the bottom of the window 2 Export Neaotiated Fees to CSV 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 co
204. 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 finalized SmartAnalysis is a trademark of 212 Chesapeake System Solutions Proprietary and Confidential Glossary The following definitions are provided as a guide However there are a number of different interchangeable and overlapping terminologies used e g location store client location ABA the unique nine digit number assigned to identify banks and their regional location along with a check digit to verify the authenticity of the number Transaction Cutoff Time the time the bank has set that it will not post process any other transactions for the current business day This may vary based on products ACH Wire Ledger etc There will be multiple types and cut of times You can also determine domestic and international cut offs Contact an authorized representative of the bank who communicates with the user Contact types include but are not limited to Relationship Manager Treasury Sales Manager Implementation Product Manager Customer Service Representative Return Item Manager Branch Manager Operations Manager Cash Vault Manager Courier and Electronic Funds Manager Contacts will be defined at each level of the hierarchy bank relationship and account Authorized Associate
205. rforming a discrepancy query 1 Select Edit gt Discrepancies The Configure Enabled Discrepancies dialog displays Configure Enabled Discrepancies Choose the discrepancies to enable Disa bhed Enabled Type Type Potentialy Dormant Account bicang Reserve Raise Mistry Total Service Charge H Mulhole Service Charges Tec mpy t account E Ivete T ecs Transacton Type is Invakd Ttece Volumes Do Not Exe TAa Volumes Do Not Match Total Servite Charge Amount Balance Doe r Tota Servie Charge Amount Balance Boe H Unasigned Account in Operabonal Structure Unassigned Relationship in Oneratonal Str Unrekpacted Service Unknown Total Service Change LIF Lae Hon Senice Dhage Unusuaiy High Tota Service Change Volumes Do Mot Ext Volumes Do Hot Match wF Save Al Changes Cancel Configure Enabled Discrepancies dialog SmartAnalysis is a trademark of 144 Chesapeake System Solutions Proprietary and Confidential 2 Click to select the discrepancy type that you want to disable from within the Enabled field 3 Click ko move the selected discrepancy to the Disabled field The selected discrepancy will not display when the discrepancy query runs 4 Repeat Steps 2 and 3 until all of the discrepancies that you want disabled have been moved to the Disabled field NOTE Discrepancies can be returned to the Enabled field by selecting the discrepancy from the Disabled field and clicking 5 Select Save All Changes when
206. rio Your options are e 3 Month Average e 6 Month Average e Latest Statement 10 Select Statement Selecting this option enables the field that allows you to select from the available statements 11 Select your Data Options SmartAnalysis is a trademark of 208 Chesapeake System Solutions Proprietary and Confidential a Comparison Report Type Select Service Level Summary if the Account Structure is different or select Structured based on source data if your Account Structure is the same Selecting this option enable the following Structured comparison options o Show relationship summary o Show account summary o Show fee details e Fees with the same value e Fees with a different value e Fees not found on a What lf Bank Fees to include in comparison Select All Fees to include all fees or select Comparison Family to enable the dropdown menu where you may select by group of fees Relationship Settings Relstionshape Extra Rides per Relationechip DOODOIIDeD I 1228 RELATIONSHIP SUMMARY Fes Change Type Change Amour Add Rule Change Type Change Relationship Settings Click on Relationship Settings to change volumes or price at the relationship level by a Overall percentages either Price or Volume b Service Group percentages Select the Extra Rules per Relationship b Select the Fees from the drop down list c Select the Change Type of either Pricing Adjustment or Volume A
207. rocessing a statement for discrepancies e Deleting a statement 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 statement importer 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 Basic Statement Import Statement Data File Select Fie File Type 822 C Twist XML OCN Serw Charge Options Produce complete baseline from this statement Open imported statement in viewer Statement Import dialog SmartAnalysis is a trademark of 132 Chesapeake System Solutions Proprietary and Confidential Select a file Select the 822 file you wish to import Statement Import Options Options J Produce complete baseline from this statement Open imported statement in viewer Produce Complete Baseline from this statement SmartAnalysis 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
208. rt 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 Permits the user to modify existing user information Assign Authorities Groups to User SmartAnalysis is a trademark of 191 Chesapeake System Solutions Proprietary and Confidential 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 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 Authority Groups View Users Users in the SmartAnalysis system represent the people who use the SmartAnalysis application Each indi
209. rtAnalysis is a trademark of 113 Chesapeake System Solutions Proprietary and Confidential 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 e You have the option of either displaying this report in PDF or CSV output NOTE When Comparison Codes or Comparison Code Families are selected and Relationship Level charges are desired you must select the Summary Charges checkbox In other conditions Relationship Level charges can be returned ina normal report Sample 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 Bare af Erga d Aan Conmdikiried i li MOOT eS aes Ts ais AGS Si ia BAA E 27 S658 DET Bagel Acca Glee ipa ig tie Be 1D Do oo 2 Pa u DEP OoTo Ban Gt ren Geman 245 PPB Moe fa 20 00 Ins TELEPSONE HOTRIOATION HAHTEHAHCE 1000 00 Grench Cermat jaie a 2 00 mp i0 Bono F E DDS hale WoT Bao ESO G0 Erpe Carer iJ i943 Rl GRIYE TR We CPE SSC Tr ei 1a Goer eked I LSS ENE Bi 50 5G tee ACSSUNT WAT BAe 24 20 80 Demand Depari Acra Aaria ih oe x 33 E 150 80 PDF SE Sats ITE rence Gemah PEN imig ei 19 00 00 IITA m iin eigr DIDID Brint Deccde 4 e 45 i9
210. rtAnalysisRM SmartAnalysis RM Enablement SmartAnalysisRM Features Signers Authorized Associates SmartAnalysis RM Specialized Account Information Bank Confirmations Bank Specialized Information SmartAnalysis RM Report Security and the Security Manager Perspective Security Concepts SmartAnalysis Security Authorities Authority Groups Users The Security Manager Perspective Managing Users The Users View The User Editor Why Users Cannot Be Deleted Assigning Authorities and Groups The Authorities View The Authority Detail The Authority Groups View The Authority Group Editor Volume Confirmation BAI Volume Confirmation T Recs Volume Confirmation What If Banks and Scenarios Creating a What If Bank using a Current Bank as a Baseline Manually Creating a What If Bank Manually Creating a What If Relationship Creating a What If Bank from an existing Bank Balance Mappings Tab What If Scenarios Creating What If Scenarios Communicating with the SmartAnalysis Team Reporting Errors Coming Soon Glossary SmartAnalysis is a trademark of xi Proprietary and Confidential Chesapeake System Solutions 184 185 185 186 186 186 186 186 186 187 187 187 192 192 192 192 193 193 195 195 195 196 196 197 197 198 201 202 203 203 204 206 207 207 207 211 211 212 213 Chapter One Understanding the SmartAnalysis User Interface SmartAnalysis is a trademark of 1 Chesapeake System Solutions
211. ructure 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 we suggest that you turn off the operational structure system parameter 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 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 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 generated we suggest 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 discrepancies of this type you can manually change the maximum service charge change tolerance i
212. s are entered 7 Select Save All Changes when you are finished The Newly created account type s are added to the Type dropdown in the General Information field Account Purposes Account Purposes are categories you may define to provide additional information about the nature of a contact To manage Account Purposes 1 Within the Banking Structure right click a relationship and select New gt Account for Selected Relationship The Account Information window displays 2 Inthe Specialized Information field of the Account Information window click the down arrow for Account Purposes Specialized Information Account Purpose Avg Balance Requirement yyy i Dual Signature Threshold Do O O Max Check Amount DOO O O Target Balance Po Statement Cyde Date ssid Account Purposes field 3 Select Add Edit Types The Add Edit Purpose Types dialog displays Add Edit Types gad Select Add a Type seect type fo edi Type Details SEEN Erama Descriptor Add Edit Purpose Types dialog SmartAnalysis is a trademark of 85 Chesapeake System Solutions Proprietary and Confidential 4 To add a new Account Purpose select Add New Purpose Types or to edit an existing account purpose type select it from the selection list The Type Details fields become active Select Add a Type Select tye to edt Tert Type Details Short name Test Ceescrin tion Save Al Changes Delete Cancel The Account
213. s 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 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 is P Executive Summary 2 Banking Information p Fee Query Sp Balance Query Gi Discrepancy Query Mi Report Manager jih Security Manager TF what IF The Perspective Toolbar indicating that Fee Query Perspective is currently active General Application Toolbar The General Application Toolbar is located on the upper left hand side of the application window beneath the File Menu This toolbar contains two generally useful functions Saving Editors 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 changes in the currently active editor Statement Import Displays the Statement Import Wizard for Basic Statement Import The toolbar may be expanded or collapsed by clicking and drag
214. s that the negotiated fee setup identity information be well maintained Identity Information Incoming Bank Code Incoming Service Code Incoming Description Comparison Code BAI Transaction Type Ul 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 across banks with differing negotiated fees e BAI Transaction Type The identifying string that identifies the type of data being reported as the transaction type SmartAnalysis is a trademark of 90 Chesapeake System Solutions Proprietary and Confidential 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 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
215. s used to retrieve Service Charge data SmartAnalysis is a trademark of 167 Chesapeake System Solutions Proprietary and Confidential 5 The results of the Fee Query are displayed in The Fee Query Results View on the right side of the window 6 Summary and subtotal data are visible at the bottom of the window 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 i AMSOUTH BANE 062000019 Relationships ea l21l21 RELATIONSHIP Statements fi Bank OF America 121000358 ats Bank of Chesapeake 0125660 lt iig Bank of England MD 0520002 ie BLUE BOOK OF BONE PRICES 2 i COMMERCE BAME 031201360 i First National Bank 01120032 Wachovia 053000219 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 l Selecting a date range filter will const
216. s value is overridden if a negotiated fee also has a Volume Tolerance 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 123 567 9999 Account Opening Date 03 01 2011 G L Account ID 235 8888 Additional Information SmartAnalysis is a trademark of 49 Chesapeake System Solutions Proprietary and Confidential Negotiated Fees Tab The Negotiated Fees Tab of the relationship editor contains information for the expected fees 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 General Information Negotiated Fees Contacts sLExport Negotiated Fees Tab 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 processe
217. ser 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 information Create Statement from Latest Statement Permits the user to create a statement in SmartAnalysis based on the most recent prior statement Ed
218. signment information These groups are 1 The signers assignments are grouped first by Bank 2 Followed by relationship SmartAnalysis is a trademark of 123 Chesapeake System Solutions Proprietary and Confidential 3 And by the detail account to which the assignments belong 4 Within the detail account signers are grouped into Inactive and Active sections 1 Bank of Chesapeake 012508011 F RELATIONSHIP SUMMARY 07004 Er pag Inacove Signers Knstin Smith CFO 300 000 00 127 05 1140 AM 11 6705 8 04 AM 5 Achwe Sighers Jason Yankus Treasury Manager 10 000 006 18 08 11 44 AM Monica Rakowski Head Accountant 1 000 000 00 116 05 2 04 AM Signer Status Report Groups Signers Status Report by Department The Signer Status Report by Department allows the signer report to query by department In order to query by department the department must be designated when the signer is set up on the Signer Information window NOTE 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 To create a Signers Status Report by Department 1 Select Report Manager The Report Selection View displays 2 Click the to open the Signer Reports folder 3 Select the Signers Status Report By Department The Signers Status Report By Department Criteria Editor displays SmartAnal
219. sis is a trademark of 41 Chesapeake System Solutions Proprietary and Confidential wr Balance Mappings Unnamed Bank Balance Mapping Deplay Only Unmsaged Incoming Balance Codes Comparison Code l Balance Mappings SmartAnalysis is a trademark of 42 Chesapeake System Solutions Proprietary and Confidential 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 Auto Match Codes 5 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 select Add 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 The Case Folder Tab The Case Folder tab provides you w
220. sociate Report Criteria 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 You have the option of selecting either PDF or CSV Report Output Type 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 012560011 Contact Name Tie Deparment Phone Number A Phone No Emad Jim Mecielian Begona VF Begong Accounts 10 288 7784 Moc bots com RELATIONSHIP SUMMARY 0700407535 Contact Name Tile Department Phone Number AK Phone Mo Emad Ba Sender Bank Fellionewp Manager Corporate Bareing 411 888 7784 Doenserg ABC oom West Coast Account 0700487534 Contact Name THs Department Phone Number AK Phone No Emad Aja BMH Processing anager Processing Center asMENGQABS com East Coast Account B080007 164 Contact Name Tre Department Phone Mumber AK Phone No Emad Vengica Hall Process Manager Processing Genier 410 356 9805 WaeAS com Contacts By Bank Report Sample Columns The Contacts By Bank Report displays columns related to contact information Contact Name The name of the contact Title The contact s title Department The organizational unit in which the contact works Phone Number The contact s primary phone number Alt Phone Number The contact s alternate phone number Email The contact s email address Contact Name Title
221. spective 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 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 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 SmartAnalysis is a trademark of 8 Chesapeake System Solutions Proprietary and Confidential Maximize To maximize a View or Editor select the Maximize icon from the upper right hand corner Minimize To minimize a View or Editor select the Minimize icon 7 from the upper right hand corner Restore To restore a maximized or minimized View or Editor select the Restore icon 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 Restore functions may also be accessed via the con
222. sponded Description sent Date Annual Review of account Si 03 01 2011 New Confirmation Add Bank Confirmation Information Request New Signers card from bank Description Confirmed Date Bank Confirmations SmartAnalysis is a trademark of 74 Proprietary and Confidential Confirmed Date Chesapeake System Solutions Deleting a Detail Account To delete a detail account select the account in the Banking Structure View and select the Delete from the view menu cing Structure I Es P W AMSOUTH BANK 062000019 T gt gt Relationships 699 12121 RELATIONSHIP SUMMARY Import Statement La 41705459 THE ABC Company F Edit Statements Bank OF America 121000358 He Delete Bank of Chesapeake 012566011 Bank of England MD 052000212 A Account QuickFind Pm Meee Oe ee Tee ee ee oa Lu Cu ee bi Fab Deleting a Detail Account 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 o
223. ss Account Disabled _ Force Password Change The User Editor 2 Edit the user as required 3 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 Why Users Cannot Be Deleted User Accounts are used to audit many actions 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 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 Authority Group to a User using drag and drop e Find the Authority or Authority Group in The Authorities View or The Authority Groups 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 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 SmartAnalysis is a trademark of 195 Chesapeake System Solutions Proprietary and Confidential Authorities j ey Access Balance Query fe Acce
224. ss Discrepancy Query Access Executive Dashboard Access Fee Query Access Report Manager Access Security Manager Account QuickFind 4dd Comment to Discrepancy 4dd Operational Unit Assign account to another Relationship fecian account ka omerskiacal Lirik The Authorities View DEDEDEDEDEDEDEDED Scroll up and down to see all the authorities Double click an authority to open The Authority Detail The Authority Detail The Authority Detail displays the name and a short description of the authority 1 4 Access Fee Query 23 Authority Information Access Fee Query Authority Information User Mame Description The Authority Detail The Authority Groups View The Authority Groups View contains the list of defined Authority Groups Authority Groups iji fay A Admin A 8ip Balance Query ip Bank Setup Management Discrepancy Query 8jy Executive Dashboard Fee Query ip General User Operational Structure Management H Options Report Manager 8 Securit Wanaoer The Authority Groups View Scroll up and down to see all the authority groups Double click an authority group to open The Authority Group Editor SmartAnalysis is a trademark of 196 Chesapeake System Solutions Proprietary and Confidential Authority Groups A Admin A 8ip Balance Query Bank Setup Management Discrepancy Query ip Executive Dashboard 855 Fee Query General User
225. t Execute Gear crena Yearly Services Summary Report Report Criteria 4 Select the desired Banking or Operational Entity The report requires that you select at least one entity from the Entity Selection criteria 5 Select the Display data for 12 Months up to and including criteria The report requires that the last month of data to be included be selected from the date drop down 6 Select the Value Type that you want to narrow your report by Your aggregate values options are e Total Amount e Unit Price e Volume SmartAnalysis is a trademark of 119 Chesapeake System Solutions Proprietary and Confidential 7 Select the Account Type that you want to narrow your report by Selecting Detail or Relationship level will constrain results to charge present at the selected level Your options are e Relationship e Detail Account 8 Select the desired Report Output Type Your options are e PDF Output e CSV Output e Excel Output 5 Select the Service Codes to narrow the results to the specified incoming service codes 6 Select the Comparison Codes to narrow the results to the specified comparison codes 7 Select the Comparison Code Families to narrow the results to the specified comparison code family 8 Select Execute to create the Services By Month report The Yearly Service Summary Report can display several different service charge values visible at the left of the sample These values are Total Amount Unit
226. t Use the Select All and Select None to change the checked status of the entire list at once e Unresolvable discrepancies These are discrepancies that 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 SmartAnalysis is a trademark of 159 Chesapeake System Solutions Proprietary and Confidential Auto Resolve Results Discrepancy Auto Resolve Results Results Summary 11 Total D0 Errorfs Discrepancies resolved 4 Resolved Successfully 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 Action taken Create 4 new Relationship level Negotiated Fee based
227. ter a new Transaction Cutoff Time Types select Add Edit from the drop down in the editable table NOTE 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 Entity Selection When using any report or query the behavior of that report or query when different combinations of banking entities are selected should 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 Detail Account 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
228. ter you ve received your SmartAnalysisRM enablement key from Chesapeake System Solutions Inc open the help menu from the left side of the menu bar ahi SmartAnalysis File Edit View Window Help E LA 2 Banking Inl F Help Contents i SmartAnalysisEx emi Help SE Search Send Support E mail Total Charges By Bank Enable SmartanalysiskM bout Smart nalysis SmartAnalysis RM Enablement Menu Item Enter your SmartAnalysis RM enablement key When a correct key is entered the Enable button is activated Select Enable 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 SmartAnalysis RM Enablement Smartanalysis RM Key Cancel SmartAnalysis RM Enablement Dialog SmartAnalysisRM 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 banking relationship information Signers Authorized Associates SmartAnalysis RM Specialized Account Information Bank Confirmations Bank Specialized Information SmartAnalysis RM Report SmartAnalysis is a trademark of 185 Chesapeake System Solutions Proprietary and Confidential Signers SmartAnalysis RM provides the capability to create and manage specialized contact types called Signers Signers
229. text menu by right clicking on the tab of the View or Editor 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 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 by selecting the Save icon Ae If you attempt to close one or more Editors with unsaved changes the system will prompt you to save them Select OK to save SmartAnalysis is a trademark of 9 Chesapeake System Solutions Proprietary and Confident
230. the SmartAnalpsis megohated fee setup for this code he charge should have been 0 5 102 x 2 0 amm 010101 CREDITS POSTED OTHER O 02ichessys OPEN Account ABC Toys LLC 1233001724 has been charged a fee of 4 03 with a per unit fee of 0 2 and a volume of 13 for service code 01 01 00 and bank code 82003 According to the Smart nalysis negotiated fee se up for this code the change should have been 4 4 0 3 x 12 0 amos 0101 00 DEBITS POSTED OTHER O 3echessys OPEN Variance subtotal for account 3 68 Cecrepances for ABC Tays LLC 1333702305 May 01 2005 to May 31 2005 Account ABC Toys LUC 1333702305 has been charged a fee of 16 00 wih a per unit fee of 16 0 and a volume of 1 for senace code 01 00 00 and bank eode 00100 According to the SmartAnalysis negotiated fee seiup for this code the charge should have been 10 0 10 0 x 1 0 00100 0100 00 ACCOUNT MAINTENANCE 5 00 OPEN Vanance subtotal for account 5 00 Discrepancies By Period Report Sample Columns The Discrepancies By Period Report displays data related to discrepancy information e Bank Code The bank code related to the discrepancy e Service Code The service code related to the discrepancy e Charge Description The string associated with the codes e Variance The calculated discrepancy variance e Assigned To The user to whom the discrepancy is assigned e Status The status of the discrepancy Senaoe Code Charge Oesonpton Varance Asugned To Discrepancies By Period Report
231. the bank representative s Of these it is required to have either the name email phone or fax number SmartAnalysis is a trademark of 39 Chesapeake System Solutions Proprietary and Confidential Primary Information Phone Number Po Alt Phone Number Doo O O Mobile Number Doo O OS Primary Information Address Information The Bank Editor Contact Tab also provides an area to enter the contact s address information Address Information Address City State Zip Postal Code ll Country Address Information 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 Specialized Information Contact Type Notice Required Specialized Information SmartAnalysis is a trademark of 40 Chesapeake System Solutions Proprietary and Confidential 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 B
232. the current perspective and the open editors The functions available are explained below F Help Contents Dynamic Help 2 Search Send Support E mail Enable SroiartAanalysiskhM Key Assist CErl ShiFE L Software Updates d About Smarbanalysisth The Help Menu Help Contents Opens the SmartAnalysis Help System 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 SmartAnalysisRM Dialog Key Assist Opens a popup window displaying available shortcut keys and their functions Software Updates Allows you to Find and Install Software Updates or Manage Configuration SmartAnalysis is a trademark of 6 Chesapeake System Solutions Proprietary and Confidential About SmartAnalysis Displays the build information for the client software 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 Toolbars Toolbar
233. 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 Using 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 Date Entry Dates can be entered two different ways e Manual entry in a Date Field e Dynamic Date Ranges 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 display the calendar date selector next to the entry field to SmartAnalysis is a trademark of 12 Chesapeake System Solutions Proprietary and Confidentia
234. tication Permitted Folge WF Minimum length for passwords z 2 15 Paords must conien panal characters Tae ne 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 selected 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 SmartAnalysis is a trademark of 129 Chesapeake System Solutions Proprietary and Confidential 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 frequently 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 Setting this configures the system to automatically dis
235. 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 4 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 SmartAnalysis is a trademark of 15 Chesapeake System Solutions Proprietary and Confidential NOTE 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 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 en
236. tions SmartAnalysis is a trademark of 128 Chesapeake System Solutions Proprietary and Confidential e Show All Combines the summary information with the detailed information e Show Detail Account Charges Only shows the detail information e Show relationship Charges Only shows the summary information 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 Enable volume confirmation Allows you to track daily BAI volume data Login Security System Parameters Login Security System Parameters configure the security settings for passwords and login By setting these parameters SmartAnalysis Administrators can ensure that all SmartAnalysis users choose passwords that meet or exceed the internal security policy General Login Decimal Predsion Mew passwords must be different than any of the passwords stored in the old oetoword cache Please gedy the number of off peenrad to cache Passwords wi expre after expiration period Days 0 180 Liser Account wil be loded after this number of faded login attempts Oo 10 Users wil be lbodked if they have not logged on within this time period Days 0 180 Passwords can be the same as fhe username Fus w Doman Alpwed for Doman Authentication a Ts Domain Authen
237. tions as required When finished select Validate Allocations 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 Qccounk Debit Account o Allocation Pek Custom Field 1 Cu eee 1O00 3233 9997 25 5575 5 2 000 333 9998 25 5575 6 ee2 S000 333 9999 25 5575 7 eee 4000 3233 10000 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 SmartAnalysis is a trademark of 73 Chesapeake System Solutions Proprietary and Confidential Earnings Credit General Ledger Data Credit Gccount Debit Account 22 1200 333 9997 100 00000 validate Allocations Allocation Pek Custom Field 1 C1 9999 9 Excess Earnings Credit Allocations NOTE Click the checkbox to Use for GL Export Bank Confirmations Bank confirmations provide you with the capability to record review and manage the notifications and requests made to the banks about specific accounts 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 re
238. tionships P Edit cal 0700497535 RELATIONSHIP SUMMARY LS 0700497534 West Coast Account Delete a 9060007164 East Coast Account gt Statements A Account QuickFind i Bank of England MD 052000212 Way Deleting a Relationship Creating a Detail Account To manually create a Detail Account Banking Structure a 3 SSOUTH BAME 062000019 New b Bank gt Relabonships 2a 12121 RELATIONSHIP SUMMARY a mpat Stebemert Recount for selected Relationship a 41705459 THE ABC Company J Ede Statements x oy Creating a Detail Account 1 Select the Relationship Account that will be the parent 2 Open the view or context menu 3 Select New gt Account for selected Relationship The Account Information window displays 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 SmartAnalysis is a trademark of 60 Chesapeake System Solutions Proprietary and Confidential Banking Structure a Ea 7 lA ais AMSOUTH BANK 062000019 Bank OF America 121000358 474 Bank of Chesapeake 012566011 Relationships EA 0700497535 RELATIONSHIP SUMMARY New P EA Import Statement i Edit 5 0700497534 West Coast Account HE Delete Les 900007164 East Coast Account gt Statemen
239. tirely 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 Specialized Information Contact Type Notice Required Specialized Information Relationship General Ledger Allocations General Information Negotiated Fees Contacts GLExport GL Export Tab Entering allocations To enter an allocation 1 Click the Add button on the editable table 2 Select the new row using the mouse and input the credit and debit account numbers as they apply 3 Enter an allocation percentage 4 You may continue and enter custom fields but they are not required 5 Repeat the process to add as many allocations as are required SmartAnalysis is a trademark of 57 Chesapeake System Solutions Proprietary and Confidential 6 When finished select Validate Allocations 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 Debit Account Allocation Pct Custom Field 1 Cu fee 1000 333 9997 z5 cp75 5 222 2000 2233 9995 25 5575 6 eee S000 333 9999 z5 o575 7 2ee 4000 333 1 0000 z5 5575 0 General Ledger Account Allocation Ex
240. to signify that the bound terminates at infinity Only the final tier may have this value e Rate Specified rate for each tier NOTE You may select Validate Tiers to verify that the entered information is valid e Balance Based Creating a What If Bank from an existing Bank To create a What lf Bank from an existing bank 1 Select BS what IF from the toolbar 2 Right click the desired bank within the Banking Structure window A menu appears SmartAnalysis is a trademark of 206 Chesapeake System Solutions Proprietary and Confidential 3 Select Create New What lf Bank From This Bank An exact copy of the bank including accounts and fees displays in the What lf Banking Structure 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 What If Scenarios Creating What If Scenarios To create a What lf scenario 1 Right click the desired bank in the Banking Structure 2 Select New gt What If Comparison The Enter name for What If Bank dialog
241. ts ir Bank of England MO 052000712 Ei Account QuickFind ee Editing a Detail Account General Information Tab The general information tab is made up of several sections Location Codes Identity Information General Identity Information Tolerance Information Additional Information Specialized Information Address Information The general information section contains information that is used to identify the detail account within the application General Information Mame Mumber Type Settlement Method BEBE STORES STORE 92 4344060151 en Account is automatically debited w Account Closing Date 02 13 2009 x EE Operational Structure Unassigned Fields Identity Information 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 SmartAnalysis is a trademark of 61 Chesapeake System Solutions Proprietary and Confidential e Account Closing Date Clicking the calendar allows you to select the date of the account closing Once this date is selected
242. ture of a relationship account or a detail account SmartAnalysis defines the following account types Disbursement Depository Concentration Lockbox ZBA Main Shadow SmartAnalysis is a trademark of 83 Chesapeake System Solutions Proprietary and Confidential Investment Third Party Investment Credit Line Parent and Sub Account You may expand this list as required To manage Account Types 1 Within the Banking Structure right click a relationship and select New gt Account for Selected Relationship The Account Information window displays 2 Click the down arrow for Type in the General Information section 3 Select Add Edit Types The Add Edit Account Types dialog displays Add Edit Account Types Select type to edit Concentration 7 Addnew Account Type Short name Description Concentration Account Delete Save All Changes Cancel The Account Types Dialog 4 To add a new account type select Add New Account Type or to edit an existing account type select it from the selection list The Type Details field becomes active gai Select Add a Type Select hoe io edi Mew Type Type Details Short name hen Type Descrimtion 5 Enter a Short Name for the Account Type This is a required field 6 Enter a Description if desired SmartAnalysis is a trademark of 84 Chesapeake System Solutions Proprietary and Confidential NOTE This process may be repeated until all change
243. u make your selections 7 Click Ds to move the selected service code groups to the Included column 8 Select Save 9 Select the Date Range tab SmartAnalysis is a trademark of 33 Chesapeake System Solutions Proprietary and Confidential Customize Dashboard Element BIX Name Overal Charges By Month Type Overall Charges By Month Banking Entbes Service Code Groups Date Range Select a date range Previous Imente oe Date Range tab 10 Select a date range from the drop down menu to include in the selected dashboard element 11 Select Save The Dashboard Element updates and displays the defined information 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 the Banking Information Perspective which you can access at any time from the Perspective Toolbar 7 Eh P Executive Summary 23 Banking Information F Fee Query po Balance Query t Discrepancy Query 4 Report Manager S Security Manager d What If Banking Information Perspective 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 expan
244. ucture 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 Structure 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 NOTE You must be in the Banking Information Perspective to use this view SmartAnalysis is a trademark of 76 Chesapeake System Solutions Proprietary and Confidential fon shi ai Structure X a oe My Ei F pen a2 BALTIMORE DC METRO AREA bese L PHILADELPHIA METRO AREA go PITTSBURGH METRO AREA oe 020255168 Johnny Software Ine Pittsburgh Bank du Shawr Operational Structure View Creating Operational Units To add an operational unit follow these steps e To add a top level operational unit select the Add Operational Unit icon from the view toolbar e 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 a Operational Structure x Qe i ag ns la OO The Add Operational Unit icon of the Operational Structure View toolbar 1 Enter the name of the operationa
245. ue 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 Account Closing Date Clicking the calendar allows you to select the date of the account closing Once this date is selected and saved on the system the account will move to the Closed Folder under the Relationship Level Folder This will enable you to display or hide closed accounts and only show open accounts e Operational Structure The operational structure view displays which operational unit to which this account is assigned 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 Volume Tolerance 4 Tolerance Information 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 Thi
246. vely 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 SmartAnalysis is a trademark of 171 Chesapeake System Solutions Proprietary and Confidential Charge Information 00251 oo256 00100 ooz202 Bank Code Service Code Description Unt Cost Total Units Total Cost Bank ABA Humber Account Mame aes nL i 01 00 00 ACTOU 16 00 16 00 1 00 wWadhovia 03000219 RELATIONS O 01 00 DORMA 5 00 40 00 6 00 Wadovia 53000214 RELATIONS oO 01 00 00 ACTOU 15 00 210 00 14 00 Bank Of Amer 121000358 RELATIONS 0 01 00 00 DEPOSI 3 00 171 00 57 00 Bank Of Amer 121000358 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 Results Toolbar button otal Units Total Cost Bank ABA Number OpUnit Ac n Fe aE T a eT 6 00 We Compare Like Charges To This Charge Ri 0 00 wena ae E RE 10 00 14 00 Bank OF Amer 121000358 RE 7405 ca a Mmeel EG A Context Menu ie mer We Compare Charges G Account Mame Export RELATIONS RELATIONS View menu The comparison results display the sample charge in the first highlighted row The
247. vice information Refers to the code and description of the service displayed 3 Value information Refers to the value Total Amount Unit Price or Volume 4 Row summary value Refers to the total amount of values in the row if Total Amount or Volume or the average if Unit Price 5 Column summary value Refers to the total amount of the values for the month in the column for the banking entity 6 Overall summary value Refers to the total amount of the row summary values Service Code Detail Report The Service Code Detail Report provides a breakdown of the bank fees by service code with description sub totaling at the bank code level To create a Service Code Detail Report 1 Select Report Manager The Report Selection View displays 2 Click the to open the Service Charge Reports folder 3 Select the Service Code Detail report The Service Code Detail Report Criteria Editor displays Report Criteria 4 Select the desired Entity The report requires that you select at least one entity from the Entity Selection criteria 5 Select Show Summary Charges to report charges at the relationship level If this is not checked detailed charges will display on the report 6 Select the Date Range Your options are e Select Dynamic Range e Manually Set Range 7 Select the Report Output Type Your options are e PDF Output e CSV Output e Excel Output SmartAnalysis is a trademark of 121 Chesapeake System Solutions
248. vidual who uses SmartAnalysis should have his or her own user Please see Managing Users for more information on administering users within the application The Security Manager Perspective The Security Manager Perspective can be accessed at any time for those with permission by selecting Security Manager of the Perspective Toolbar There are several core concepts in the Security Manager e Managing Users e The Authorities View e The Authority Groups View Managing Users Managing users involves several views and editors as well as the assignment of authorities and groups to users 1 The Users View SmartAnalysis is a trademark of 192 Chesapeake System Solutions Proprietary and Confidential 2 The User Editor 3 Why Users Cannot Be Deleted 4 Assigning Authorities and Groups The Users View The Users View contains the list of all users in the system Users Fs Ay bsmithi chederowicz chessys dhoagie jsixpaq jyizzle d miynch rboswell The Users View Scroll up and down to see all the users Double click on the user name to open the User Editor 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
249. xt Sensitive Help Form Field Data Entry Required Fields Twistie Sections List Selection Date Entry Date Field Using the Calendar Date Chooser Dynamic Date Ranges Supported Dynamic Date Ranges Number Entry URL Entry Tables Using Editable Tables Using Selectable Tables Using Dueling Tables Transaction Cutoff Times Transaction Cutoff Time Types Entity Selection SmartAnalysis is a trademark of Proprietary and Confidential Chesapeake System Solutions oe OF o F FHF WANN NY Cna Aa WO WO UOU N ek N poh jk ee me e e i i i i i i i ee NNWNaArninmntb Shp hwwonrdndnrnrN NK m Samples Closing The Application Chapter Two Using SmartAnalysis Accessing the System Changing your Password during Login Troubleshooting a Failed Login Attempt Executive Summary Perspective Executive Summary Dashboard Elements Total Charges by Bank Dashboard Element Overall Charges Dashboard Element Top Discrepancies by Variance Dashboard Element Top Unit Rate Service Charges Dashboard Element Top Total Cost Service Charges Dashboard Element Top Volume Service Charges Dashboard Element Discrepancies Assigned to Me Dashboard Element Configuring the Executive Summary Perspective Changing the Executive Summary Perspective Dashboard Elements Customizing the Executive Dashboard Elements Banking Information Perspective Banking Structure View Creating a Bank Editing a Bank The Bank Editor General Information Tab Required Information Address In
250. xt menu The Saved Report Criteria will open in a new tab in the right hand editor pane Deleting Saved Report Criteria Saved Report Criteria may be deleted by right clicking on the report criteria and selecting Delete from the context menu Report Types This section enumerates the purpose and usage of the reports in SmartAnalysis Closed Account Type The Closed Account Report displays a listing of the closed accounts for a specified bank To create a Closed Account Report 1 Select the Report Manager The Report Selection View displays 2 Click the to open the Account Reports folder 3 Double click Closed Account Report The Closed Account Report Criteria Editor displays SmartAnalysis is a trademark of 90 Chesapeake System Solutions Proprietary and Confidential gt Closed Account Repon Repor CnteriaEdter Bank Selection JPMOAGAN CHASE BARE M A 0210071 JFR GAN CHASE BAME MA 07 100013 WELLS FARGO BANK HLA 121000245 Report Output Type POF Output CI CSV Output C Excel Quiput Closed Account Report 4 Select the Bank for which that you want to view the closed accounts 5 Select the Report Output Type Your options are e PDF Output e CSV Output e Excel Output 6 Select Execute to create the report 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
251. y Export results from Balance Query SmartAnalysis is a trademark of 190 Chesapeake System Solutions Proprietary and Confidential Permits the user to export results from the Balance Query Access Discrepancy Query Permits the 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 Allows the user to export results from the Discrepancy Query Change Status of Discrepancy Allows the user to alter and save the state of a Discrepancy Change Assignment of Discrepancy Allows 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 Repo
252. y using the Status dropdown menu displayed below Discrepancy Details Type Bank Code Service Code Charge Description Date 06 30 2005 A aS CoS A No Negotiated Pee is availaier Description The account 0G0080006601 155 042090002601 155 was found on the statement but has been marked as Closed in bank setup on 04 01 2006 Change History Update by chesays on 0845 7005 Status was changed from OPEN to PENDING Update by chessys on 615 7005 Aesoned To was changed from Uressgmed to Kristin 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 Assigning Discrepancy Responsibility When viewing discrepancy details you can easily change user assigned to the discrepancy using the Assigned To dropdown displayed below Discrepancy Details Type Bank Code Service Code Charge Description No Negotiahed Fie is avadabes Description The account GA0S0002601 155 0CS030002601 185 was found on the statement but has been marked as Closed in bank setup on 04 01 2005 Change History SL Update by chesays on 08 15 2004 Status was changed from OPEN to PENDING Update by chessys on 6015 2005 Assigned To was changed from Unassigned bo Kristin SmartAnalysis is a trademark of 166 Chesapeake System Solutions Proprietary and
253. y data for the currently selected relationship or account SmartAnalysis is a trademark of 141 Chesapeake System Solutions Proprietary and Confidential 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 Bank Code A bank specific code assigned to a service charge Service Code Refers to the industry code assigned by a bank to a service charge Description Refers to a description of the charge Type Refers to the type of charge which typically is Unit Price x Quantity or Flat Charge Unit Price Refers to the price per unit for this charge Volume Refers to the volume recorded for this charge Total Price Refers to the total price of the charge This field is automatically populated it you enter both the Unit Price and Volume fields Balance Requirement Refers to the balance requirement for this charge 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 Industry Code Refers to the industry code assigned by a bank to a balance Description lf the description for the selected industry code is available it is displayed here This is a read only field SmartAnalysis is a trademark of 142 Chesapeake System Solutions Proprietary and Confident
254. y iD waert Teral Serna Chae DEP EF RACCOLTE 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 discrepancy 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 v
255. ysis is a trademark of 124 Chesapeake System Solutions Proprietary and Confidential y Signers Status Report By Department gt Report Criteria eater Entity Selection Barking Operational B PMORGAN CHASE BANK N A 021000021 S i JPMORGAN CHASE BANK N A 071000013 iy WELLS FARGO BANK N A 121000248 Quacicfine Department Selection Report Output Type PDF Output Oes Output Signers Status Report By Department Report Criteria 4 Select the desired Entity The report requires that you select at least one entity from the Entity Selection criteria 5 Select the desired Department Departments must be set up in the Signers View to populate this field 6 Select the desired Report Output Type Your options are e PDF Output e CSV Output 5 Select Execute to create the Signers Status Report SmartAnalysis is a trademark of 125 Chesapeake System Solutions Proprietary and Confidential Monthly Summary Statistics Report The Monthly Summary Statistics report displays a summary of Balance Discrepancy and Service Charge data for your banks To create a monthly summary statistics report 1 Select the Report Manager Perspective 2 Open the Summary Reports folder on the Report Selection View 3 Double click Monthly Summary Statistics Report The Report Criteria Editor displays Py r 4 Monthly Summary Statistics Report crtens Este Bank Selection JPMORGAN CHASE BANE M A 0200000
256. ystem 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 contained 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 March 2011 SmartAnalysis is a trademark of Chesapeake System Solutions Proprietary and Confidential Publication Title SmartAnalysis 6 0 User Manual SmartAnalysis is a trademark of i Chesapeake System Solutions Proprietary and Confidential Table of Contents Chapter One Understanding the SmartAnalysis User Interface Perspectives Views Editors The Menu Bar File Menu Edit Menu View Menu Window Menu Help Menu Context Menus Toolbars Perspective Toolbar General Application Toolbar View Specific Toolbars Navigating Between Perspectives Opening Views Opening Editors Resizing Views And Editors Navigating Between Editors Saving Editors Handling Data Entry Errors Closing Views And Editors Accessing Conte

Download Pdf Manuals

Related Search

Related Contents

Manual  NGS C-6  Panasonic MC-V7312 Vacuum Cleaner User Manual    extricación del politraumatizado en accidentes de tráfico  Let Your Imagination Soar With Our New, Larger and Faster UV  Redes Telefônicas - Faculdade de Tecnologia  CARAFON, CHIEN D`IVROGNE,  PROJECTOR PJ1000 ST DLP  

Copyright © All rights reserved. Failed to retrieve file