SmartAnalysis Advanced Features

1. SmartAnalysis Advanced Features Terri Sullivan

2. Advanced Features in SmartAnalysis • Operational Structures • Additional functionality in comparing accounts and services within a “pre-set” internal grouping. • CSV Import • Use CSV files to import service charges, banks, accounts, signers and contacts. • G/L Expense Allocations • Set-up configurable allocation files that can be exported in a comma-delimited file. • Bulk Statement Archive

3. Operational Structures

4. Operational Structures Provide additional functionality in comparing accounts and services within your own pre-set internal corporate organization. Examples – Districts, regions, geographic locations, subsidiaries, types of businesses within the corporation, etc.

5. Operational Structures - Preplanning Make sure your bank information is organized. • Chart out your accounts and document how each account relates to your newly developed operational structure. If new accounts are added to your banks, the system alerts you of those new accounts and allows users to add those accounts to your existing structures. • “Unassigned” Accounts shown in Discrepancy Query Take note on how your relationship information comes into play with your account information. • Aggregated accounts roll up to higher levels

6. Operational Structures • Operational Structure view and Unassigned Account view are only available from the Banking Information module. • Select view from the toolbar. • Mix banks and accounts • Combine “like” account types (depository, disbursement, lock box)

7. Creating an operational structure • To create a “Parent “ level Operational structure select icon. • To create a subgroup, highlight the “Parent” group and select icon.

8. Operational Structures • Point-and-click/drag-and-drop setup • You can delete, move or add accounts • You can easily add or delete levels • You can “explode out” or “fold up” structures SmartAnalysis Discrepancy QueryAlerts you of new or unassigned accounts

9. Operational Structures • Confirmation notice will be displayed when assigning accounts to Operational Structures.

10. Modifying an Operational Structure • Entire Operational Structures can be deleted. • or just the removal of individual accounts.

11. Operational Structure – Fee Query • Show detailed expenses by internal units • Export controlled service details to worksheets or other analysis reports.

12. Reporting on Operational Structures You can pick specific report criteria using operational structures that show: • Balance information • Discrepancy information • Service Detail information With the dynamic date functionality you can create monthly expense reports for different structures within your organization.

13. Operational Structure Reports

14. Operational Structure Reports

15. Reporting on Operational Structures Two reports designed specifically forOperational Structures. • Services By Operational Structure Report provides3 months side by side data of account totals foreach account contained in the selected Operational Structure(s). • Total Cost By Operational Structure Report providesa breakdown of bank total(s) for each Operational Structure(s) selected.

16. Operational Structure Reports

17. Operational Structure Reports

18. Operational Structure Advantages • You can compare like businesses and services regardless of the bank. • You can compare volumes in one business unit over another business unit. • Reports & Queries can be used to produce summary information by district, region or subsidiary. • Best Practices can be implemented by reviewing trends within your set operational structures.

19. CSV Importing

20. IMPORTING INFORMATION VIA CSV FILES There are numerous opportunities for users to add information into SmartAnalysis using formatted CSV files. • Users can add banks, accounts and service charges via CSV files • Signers and contacts can be added using CSV files. The CSV format is specific for each function.

21. ADDING BANKS AND ACCOUNTS IN BULK These fields are mandatory. • Bank ABA – 9 characters • Bank Name • Relationship/Summary Account Number • Relationship/Summary Account Name • Detail Account Number • Detail Account Name • Optional Fields – The following fields are optional and can be left blank • Opening Date – mm/dd/yyyy • Closing Date – mm/dd/yyyy • Account Type – choose from the Account Type listing contained in SmartAnalysis (New types must be added into software prior to importing) • Settlement Method – A - Automatic Debit • TIN – Tax Identifier Number • GL Account – client determined • Address 1 – street address • Address 2 • City • State – 2 digit State Code • Zip Code – 5 digit Zip Code • Country – 2 digit Country Code

22. ADDING BANKS AND ACCOUNTS IN BULK • When opening a CSV in an Excel program, it may look correct but users should confirm accuracy in a program such as text pad or notepad.

23. ADDING BANKS AND ACCOUNTS IN BULK • From the file menu, select Bulk Account Import • Select the CSV file to be imported • Select Create Banks and/or Create Relationship Accounts • Finish

24. ADDING BANKS AND ACCOUNTS IN BULK

25. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE • Users have the ability to import service charges via a CSV formatted file when an 822 file is unavailable. • New banks, accounts and negotiated fees can be created by selecting ‘Produce complete baseline’. • Allows import of monthly account analysis fees • Downside: • No balance information • Add account names after set up

26. SERVICE CHARGES CSV FORMATTED FILE - Format SER – Service Charge Line • Relationship Account – Relationship Account number • Account Number – Detail Account number • Service Code – AFP Code, 6 digits, no spacing, includes preceding zeroes • Unit Price – price per item • Volume • Total Price • Bank Code – Bank determined code • Balance Requirement – Balance Required to offset service charge -optional • Type – Price Identifier Code – optional • Absence of code defaults to Unit Price Times Quantity • BCH – Base Charge • FCH – Flat Charge • THP – Threshold Price • BBP – Balance Based Price • WSP – Waived Service Price • STM – Statement Line • Bank Name • Bank ABA – must be 9 characters • Start Date – mm/dd/yyyy • End Date – mm/dd/yyyy • Creation Date – mm/dd/yyyy (statement date) • DataVersion – 999

27. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE • When completing the file be sure to check the formatting. • It is easier to complete the form using Excel to open the CSV but sometimes the formatting is lost in the process. • This file looks the same in Excel with correct formatting and incorrect formatting.

28. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE Correct format • Notice the preceding zeroes are present 000230 • Dates in correct format

29. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE Incorrect format • Notice the preceding zeroes in the SER lines are missing

30. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE Incorrect formatted file Negotiated fees • Service codes do not have the appropriate spacing • Preceding zeroes are missing • Incorrect descriptions

31. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE Correctly formatted file Negotiated fees • Service codes have the appropriate spacing • Preceding zeroes present • Descriptions are displayed

32. IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE To import your CSV file: • Go to Banking Information • Import Statement • Select your file • Change file type to CSV • Select ‘Produce complete baseline’ only if a new bank is being created • Finish

33. Importing Signers (RM) Signers are imported within the Signers View. To access Signers View: • Users must be in Banking Information • Go to View • Select Signers View • Signers View window will open in the lower left corner

34. Importing Signers (RM) Signer CSV file format: Lname,Fname,Title,Limit,Email,Dept,Phone,AltPhone,Fax,Mobile,"Type(F,M,A)“ “Type”: F = Facsimile M = Manual A = All Example:

35. Importing Signers (RM) To import Signers: • While in Signers View, go to the import icon. • Select CSV file to be imported. • CSV Signer Import Notice will be displayed • No duplicate signers will be imported

36. Importing Contacts Contacts can be added on the bank level, the relationship summary level and detail account level.

37. Importing Contacts Contact CSV file format: • Name,Title,Email,Dept,Phone,AltPhone,Fax,Mobile,Address,City,State,Zip • Name and email are mandatory fields. • All other fields are optional. Sample File:

38. Importing Contacts • Select Import. • Choose the Contact CSV file. • Notification will be displayed.

39. CSV Import Summary • Data can be imported into SmartAnalysis using CSV formatted files. • Banks and accounts - Bulk Account Import • Monthly service fees • Signers • Contacts • When opening a CSV in an Excel program, it may look correct but users should confirm accuracy in another program such as text pad or notepad.

40. G/L Expense Allocations

41. G/L Expense Allocations • You can set-up custom allocation of net service charges that can then be easily exported into a .CSV file from SmartAnalysis. • Once the files have been created you can export the file and upload that information to your GL or use it to populate a worksheet showing allocated charges to other business units. • General Ledger allocation can be on the detail account level or relationship level.

42. G/L Allocations – Preplanning Decide the level of allocation: • Relationship Level • Account Level Map out the accounts and amounts that you want allocated: • What percentage of the expense goes where? • Do earnings credits come into play? • What GL accounts will you be using (optional)?

43. G/L Expense Allocations Select a relationship or detail account Build and validate the allocation • Debit and Credit Account # • Allocation % • “10” customized fields for entry identification This setup is allocating summarized net charges. Remember Check the “Use for GL Export” box to engage the allocation.

44. G/L Expense Allocation Results Once your allocations are set; you select “Export GL Data” under the main File menu and save the allocation for review. Note: This is just a flat file (.csv) • You can convert this data to any format, then upload it to your GL. • You can even pull this data into a spreadsheet and add additional information.

45. G/L Expense Allocations • Ensure the structure of the statements you're trying to export precisely match the structure of the bank setup. • Ensure each of the statement accounts being exported contains one of the following codes in the Balance Section of the statement: • 00 03 00 - Service Charges - Total - Current Period • 00 03 A0 - Service Charges Invoiced • SC - Total Service Charges-Current Period and one of the following: • 00 02 40 - Earnings Allowance • 8 - Earnings Credit • For General Ledger amounts that are negative, ensure that Excess Earnings Credit Account Allocations are set up.

46. G/L Allocations - Advantages • Quick distribution of charges • Better expense control • Variable allocation methods: • At the Relationship Level • At the Account Level • Some portion at the Corporate Level • Some portion at the Unit Level • Easy exporting • The .CSV file can be imported to a General Ledger or used to invoice other business units.

47. Bulk Statement Archive

48. Bulk Statement Archive • Allows users to do a bulk archive of statements based on a date range. • The archive can be based on individual banks or all banks.

49. Bulk Statement Delete After the statements have been archived, users can use the Automatic Statement Archive to delete archived statements. Only statements that have been archived will be deleted using the bulk deletion. This is handled the same way as archiving but the user would select the delete option. PLEASE BE AWARE THAT DELETING STATEMENTS WILL PERMANENTLY REMOVE THE DATA FROM YOUR DATABASE AND CANNOT BE UNDONE.

50. Any Questions?