Smartanalysis advanced features
This presentation is the property of its rightful owner.
Sponsored Links
1 / 50

SmartAnalysis Advanced Features PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

SmartAnalysis Advanced Features

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Smartanalysis advanced features

SmartAnalysis Advanced Features

Terri Sullivan


Advanced features in smartanalysis

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


Operational structures

Operational Structures


Operational structures1

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.


Operational structures preplanning

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


Operational structures2

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)


Creating an operational structure

Creating an operational structure

  • To create a “Parent “ level Operational structure select

    icon.

  • To create a subgroup, highlight the “Parent” group and select

    icon.


Operational structures3

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


Operational structures4

Operational Structures

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


Modifying an operational structure

Modifying an Operational Structure

  • Entire Operational Structures can be deleted.

  • or just the removal of individual accounts.


Operational structure fee query

Operational Structure – Fee Query

  • Show detailed expenses by internal units

  • Export controlled service details to worksheets or other analysis reports.


Reporting on operational structures

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.


Operational structure reports

Operational Structure Reports


Operational structure reports1

Operational Structure Reports


Reporting on operational structures1

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.


Operational structure reports2

Operational Structure Reports


Operational structure reports3

Operational Structure Reports


Operational structure advantages

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.


Csv importing

CSV Importing


Importing information via csv files

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.


Adding banks and accounts in bulk

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


Adding banks and accounts in bulk1

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.


Adding banks and accounts in bulk2

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


Adding banks and accounts in bulk3

ADDING BANKS AND ACCOUNTS IN BULK


Importing service charges via csv formatted file

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


Service charges csv formatted file format

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


Importing service charges via csv formatted file1

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.


Importing service charges via csv formatted file2

IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE

Correct format

  • Notice the preceding zeroes are present

    000230

  • Dates in correct format


Importing service charges via csv formatted file3

IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE

Incorrect format

  • Notice the preceding zeroes in the SER lines are missing


Importing service charges via csv formatted file4

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


Importing service charges via csv formatted file5

IMPORTING SERVICE CHARGES VIA CSV FORMATTED FILE

Correctly formatted file

Negotiated fees

  • Service codes have the appropriate spacing

  • Preceding zeroes present

  • Descriptions are displayed


Importing service charges via csv formatted file6

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


Importing signers rm

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


Importing signers rm1

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:


Importing signers rm2

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


Importing contacts

Importing Contacts

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


Importing contacts1

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:


Importing contacts2

Importing Contacts

  • Select Import.

  • Choose the Contact CSV file.

  • Notification will be displayed.


Csv import summary

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.


G l expense allocations

G/L Expense Allocations


G l expense allocations1

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.


G l allocations preplanning

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)?


G l expense allocations2

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.


G l expense allocation results

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.


G l expense allocations3

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.


G l allocations advantages

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.


Bulk s tatement archive

Bulk Statement Archive


Bulk statement archive

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.


Bulk statement delete

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.


Any questions

Any Questions?


  • Login