SmartAnalysis Advanced Features. Terri Sullivan. Advanced Features in SmartAnalysis. Operational Structures Additional functionality in comparing accounts and services within a “pre-set” internal grouping. CSV Import
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.
Make sure your bank information is organized.
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.
Take note on how your relationship information comes into play with your account information.
SmartAnalysis Discrepancy QueryAlerts you of new or unassigned accounts
You can pick specific report criteria using operational structures that show:
With the dynamic date functionality you can create monthly expense reports for different structures within your organization.
Two reports designed specifically forOperational Structures.
There are numerous opportunities for users to add information into SmartAnalysis using formatted CSV files.
The CSV format is specific for each function.
These fields are mandatory.
SER – Service Charge Line
Incorrect formatted file
Correctly formatted file
To import your CSV file:
Signers are imported within the Signers View.
To access Signers View:
Signer CSV file format:
F = Facsimile
M = Manual
A = All
To import Signers:
Contacts can be added on the bank level, the relationship summary level and detail account level.
Contact CSV file format:
Decide the level of allocation:
Map out the accounts and amounts that you want allocated:
Select a relationship or detail account
Build and validate the allocation
This setup is allocating summarized net charges.
Check the “Use for GL Export” box to engage the allocation.
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)
and one of the following:
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.