User’s Guide

STS Version 1.3

 

 

 

 

 

 

Associates Credit Card

Suspense Tracking System

 

 

 

 

 

 

 

 

 

 

User’s Guide

STS Version 1.3

 

 

Suspense Tracking System is used by the Credit Card Systems division of The Associates to manage credit card transactions in Suspense. The Credit Card division processes millions of credit card transactions each month. Each day, thousands of unresolved credit card transactions are tracked by STS.

Accounting records are entered daily into STS. The system intelligently "AutoClears" the majority of matching transactions based on recognition of paired data in essential fields and offsetting transaction amounts. Operators match remaining records using a special Item Matching screen that provides built-in querying methods.

Reports summarize suspense information in many different ways, giving Credit Card managers the big picture and allowing supervisors to monitor daily suspense progress.

 

 

Table of Contents

Preface go to link...

Chapter 1 - STS Panel go to link...

STS Panel and Menus go to link...

Chapter 2 – Batch Entry go to link...

New Batch go to link...

The Edit Batch Details Screen go to link...

Steps to create a new batch of suspense items go to link...

Example of a Batch Entry Screen go to link...

Important Considerations go to link...

Batch Items Form go to link...

Steps to enter suspense items go to link...

Important Considerations go to link...

Item Entry Example go to link...

Item Entry Action Buttons go to link...

ADD go to link...

INSERT go to link...

EDIT go to link...

COMPLETE go to link...

REJECT go to link...

RE-ENTRY go to link...

PRINT go to link...

AUTO CLEARING go to link...

Batch Review Mode go to link...

Steps in batch review mode go to link...

Item Re-Entry go to link...

Example Re-Entry Screen go to link...

Steps to re-enter items for validation go to link...

Amount Is Different Form go to link...

Amount is Different Example go to link...

Steps when Amount is Different form appears go to link...

Or… go to link...

Action Buttons for Amount is Different go to link...

Replace go to link...

Insert go to link...

Append go to link...

Delete go to link...

Undo go to link...

Resuming Batch Entry go to link...

Chapter 3 - STS Items go to link...

Item Browser go to link...

Example Item Browser go to link...

Item Browsing go to link...

Item Browser Action Buttons go to link...

PRINT go to link...

REASSIGN go to link...

NOTES go to link...

Or… go to link...

CLEAR ITEMS go to link...

Quick Filters go to link...

Using Quick Filters go to link...

Item Status go to link...

Cost Center go to link...

Owner, Entered By go to link...

Batch ID go to link...

Match ID go to link...

Item ID go to link...

Account Number go to link...

Control Number go to link...

Item Amount Range go to link...

Steps to apply a Quick Filter go to link...

Example of Quick Filter Usage go to link...

Standard Filters go to link...

Chapter 4 - Query Builder go to link...

The Query Builder Interface go to link...

Steps to use custom query conditions go to link...

Account Number go to link...

Control Number go to link...

Batch ID go to link...

Item ID go to link...

Match ID go to link...

Item Status: go to link...

Amount go to link...

Entry Date go to link...

Entry By go to link...

Resolution Date go to link...

Resolution By go to link...

Item Note go to link...

Owner go to link...

Last Change Date go to link...

Last Change By go to link...

Edited go to link...

Item Open go to link...

Item Open By go to link...

Write-Off Amount go to link...

Example of custom query conditions go to link...

Steps to use custom sort key go to link...

Chapter 5 - Item Clearing go to link...

Example of Item Clearing Screen go to link...

Steps to clear a suspense item go to link...

Clear as Gain go to link...

Clear as Loss go to link...

Clear with Difference go to link...

Clear Matched Items go to link...

Chapter 6 - Batch Browser go to link...

Example of Batch Browser go to link...

Open Item Detail go to link...

Re-Assign Batch go to link...

Steps to Reassign Batch go to link...

Click on Close to exit. go to link...

Chapter 7 – Report Manager go to link...

Reports go to link...

Daily Suspense Summary Report go to link...

Suspense Aging Report (by Accounting Month) go to link...

Suspense Aging Report go to link...

Suspense Resolution Report go to link...

Suspense Progress Summary Report go to link...

Suspense Labor Summary Report go to link...

Suspense User Report go to link...

Batch Summary Report go to link...

Batch Detail Report go to link...

Custom Detail Report go to link...

Report Manager Interface go to link...

Steps to view a report go to link...

Or… go to link...

Chapter 8 - STS Tracker go to link...

Suspense Tracking in Real Time go to link...

User Watch go to link...

Suspense Watch go to link...

Suspense Track Interface go to link...

Active Connections go to link...

Active Item Entry go to link...

Active Matching go to link...

Suspense Statistics go to link...

Activity Date Filter and Ownership Filter go to link...

Suspense Statistics Tracker Example go to link...

Suspense Graph go to link...

Suspense Graph Tracker Example go to link...

Legend go to link...

Perspective go to link...

Data Type go to link...

To get a refreshed graph for the same criteria go to link...

Chapter 9 - STS Maintenance go to link...

User Maintenance go to link...

STS Users Form go to link...

Steps to add a new user go to link...

Editing user properties go to link...

Steps to edit a user go to link...

Steps to delete a user go to link...

Security Level Maintenance go to link...

Steps to add a new security level go to link...

Steps to modify a security level go to link...

Important Considerations go to link...

Maximum Write-Off or Gain go to link...

Level Members go to link...

Alpha Code Maintenance go to link...

Cost Center Maintenance go to link...

Accounting Month Maintenance go to link...

Control Number Maintenance go to link...

Chapter 10 – Other STS Features go to link...

Last Batch go to link...

STS Mail go to link...

STS News go to link...

Example of STS News go to link...

 

Preface

 

The Suspense Tracking System (STS) is specially designed to carry suspense information management into the next millennium. It provides all the key features you need to resolve and manage any suspense credit card information. Compared to that of existing applications, the user interface in STS provides many additional features and enhancements, most of which are aimed at increasing user productivity and efficiency. Enhancements made internally to the way matched records are processed and to the way reports are produced will result in timesaving every day.

STS makes data management for administrators a lot easier, as it enables them to store it on NT Oracle rather than relying on outside vendors for data management issues. The STS database is accessible to anyone on the corporate network, so STS data can be integrated with other corporate accounting systems or executive information systems in the future. At the same time, the STS database login can be integrated directly with the corporate network security by recognizing users’ active network login id and matching it against the STS user list.

Administrators can adjust the level of user accessibility to features and to important corporate information. STS makes it possible to track and know exactly how much progress has been made in resolving and managing the suspense information, at an individual user or the overall corporate level, at any given time. Enhanced features make working with STS easy, fun and productive.

 

 

Chapter 1 - STS Panel

STS Panel and Menus

 

 

 

The STS Panel is the first screen that appears once the STS application has automatically verified your login ID. There are ten icons in the screen. STS has eight basic features that work together to make suspense information management more efficient, fast, reliable, cost effective -- more productive:

In addition to the above features, STS has a unique electronic notification feature called STS Mail.

 

There are three ways a user may access the above features:

TIP

… Or…

    • Press the up/down/right/left key to move about the windows or the icons.
    • Choose by pressing enter.

 

 

Chapter 2 – Batch Entry

New Batch

 

The New Batch window enables the user to access various screens that help in making data entry easy and manageable. New Batch enables the user to do the following:

    • Create new suspense batches in the STS.
    • Specify Batch Details for each new batch.
    • Track and rectify any wrong entries in the new batch using the Re-entry option.
    • Mark a batch Complete, so that the items may form part of the STS Items to be cleared.

 

The Edit Batch Details Screen

The Edit Batch Details screen serves as the information header for new batches. It gives information like the Date of Entry (creation) of the new batch, name of user and the owner. It also asks for information regarding the number of item entries, total balance amount of the entries and the Alpha Code; this eventually helps the user by acting as a checksum against which the entries are made in the STS.

Steps to create a new batch of suspense items

 

      1. Choose "New Batch" from the main menu, from the tool panel or by clicking on the Icons.
      2. This brings up the Batch Entry screen. Certain fields like Cost center, Owner and the date may appear automatically. The batch date defaults to the entry date.

      3. Item Count – Enter the total number of items there are in the new batch in Item count.
      4. Press ENTER to move to the next field.

TIP

    • Always press ENTER to move to next field.

 

      1. Batch Balance – enter the total that all item amounts sum up to for the whole batch.
      2. Amount fields always include two decimal places and a comma separator for thousands.

        Example: if an item amount is $10, the entry should be 1000 (ignore period). Similarly, if the item amount were $3.29, the entry would be 329, if the amount were 13.43, the entry would be 1343. However, if the item amount were 13.4, the entry would be 1340.

      3. Alpha Code – chose any from the drop-down listbox.

TIP

    • For quick selection, you may type in the first character of the Alpha Code you wish to select. The drop-down listbox will exhibit Alpha Codes starting with that letter; you may then click on the one you wish to choose.

 

      1. Description – The Description field enables the user to write convenient notes and references regarding the new batch. This can be referenced later in the Batch Browser. The Description field is optional.
      2. Once you have entered all the fields, press Continue to proceed.
      3. Press Cancel at any time to cancel the batch.
      4. Pressing Continue proceeds to the Batch Details screen.

 

 

Example of a Batch Entry Screen

The following screen shows that the new batch has 9 items, and the total Batch Balance is $2068.03, the Batch Owner is Chetan and the entry is being made by Richa on 07/13/98 at the Dallas Cost Center:

 

Important Considerations

    • If a field is left unchecked (except the description field), the system does not allow the user to continue.
    • New batch cannot be created till the pending batch is completed. If the system is asked to create a new batch while still having an old batch to complete, STS System automatically brings the following message:

Batch Items Form

 

The Batch Items Form appears next. Item entries are made in this form. The upper part of the window displays the information already given in the Batch entry screen. In the beginning the Item Count and Balance in the Running Total column are blank. The Remaining column shows the number of item entries to go and the final Balance value. These values are the same as the Item Count and Balance in the Batch header information.

As the entries are made the Item Count in the Running Totals increases. This enables the user to keep track of the number of item entries that he has made against the number of entries that are left in a batch. Balance in the Running Totals also changes depending on the amounts of each item.

When the screen appears, the cursor displays itself at the Account Number field.

 

Steps to enter suspense items

 

      1. Account Number - Enter the 16 digit Account Number for an item entry. The cursor automatically moves to the next field once a field is entered.
      2. Control Number - Enter the control number of that item.
      3. Item Amount - Enter the item amount of that item.

TIP

    • Amount fields always include two decimal places and a comma separator for thousands.

 

      1. Item Notes (OPTIONAL) - Enter a note for the item. This is optional, unless it is required for each item, which the administrator dictates, depending on Alpha Code for the batch.
      2. Press Add to add the item to the batch list.
      3. After each item is added to the list, the cursor automatically returns to Account Number for the next item to enter.
      4. Press Close if you wish to exit and resume data entries later.
      5. Press Complete when you have entered all Item entries in a batch.

 

Important Considerations

    • A batch cannot be edited once it is marked Complete.
    • A batch is Complete when the Item Count and Balance in the Running total are equal to the Item Count and Balance in the Batch Header Information column.

 

Item Entry Example

The following screen shows that there are a total of 9 item entries out of which 06 entries have already been made. The highlighted entry is the latest one added to the list. The Item count in the Remaining column shows that another 3 item entries are left to be entered.

The Balance in the Running total is a negative value which is shown in red, (negative values are highlighted by showing them in red), the Balance amount may either be a positive or negative value because it depends on the Item amounts in that particular batch. Balance is a total of the suspense item amount entries. The final Balance in the Running totals, however, should be equal to the Balance in the Batch header information column.

Item Entry Action Buttons

 

ADD

The Add button enables the user to add an item entry to the batch list. It appends the entry at the bottom of the batch.

    • Enter the Account Number, Control number and the Amount fields for a particular item in the Item entry form.
    • Press Add.

 

INSERT

Insert adds a new item entry between two existing item entries.

    • Highlight the item before which you wish the new item to appear.
    • Press Insert.
    • A new row is added to the batch list between the entries. The cursor appears in the Account Number field for you to make the new entry.
    • Enter the values in the three fields.
    • Press Add to add the entry to the list.

 

EDIT

The Edit function helps in changing and editing any wrong entries. To edit an item entry:

    • Highlight the Item entry that you wish to edit.
    • The entry appears in the Item entry edit mode window. The cursor appears in the Account Number field.
    • Edit the Account Number. The cursor moves to the next field automatically.
    • If the Account Number does not need editing, press the right key to move to the next field that requires editing.
    • Press Save to add the changes.

 

COMPLETE

At the conclusion of batch entry, the user selects Complete. STS automatically compares the Balance of all amounts with the batch total entered from the original tape total. If the totals match, STS saves the entries, flags the batch as complete, and closes the Batch Entry Form. If the totals are different, STS automatically switches to Batch Review mode where user can resolve the difference.

 

 

REJECT

A situation may arise when there are either too many mistakes in the data entry. The whole batch may be rejected by pressing the Reject icon. This marks the batch unusable and removes it from suspense reporting.

A batch may also be rejected when no errors are made in the entry but the accounting Balance could be in error. For this reason, or any other reason causing cancellation, batches can be rejected, provided the user has the appropriate security level clearance to do so.

 

RE-ENTRY

An entire batch can be re-entered for review and validation purposes (Batch Review mode). In Batch Review mode, users can re-enter record data side-by-side with the original entries. Any discrepancies between the original entries and the validation entries get highlighted. Original entries found to conflict with re-entries can be edited at the user’s discretion.

 

PRINT

Users can print a batch detail report at any time, displaying exactly what is displayed in the Batch Items form.

 

AUTO CLEARING

At the conclusion of batch entry, STS automatically attempts to match entered items, based on Control Number and offsetting amounts. A message will indicate the results of the AutoClearing process for the completed batch:

 

 

 

Batch Review Mode

If the final amounts in the Batch Header Information and Running Total are not the same STS automatically switches to Batch Review mode. Following is an example of a batch that needs to be reviewed:

In the screen above, the Balance in the Running Total is different from the Balance in the Batch Header Information.

TIP

    • A red arrow that is pointing up indicates the current sum of all items is greater than the batch balance (Over).
    • A black arrow pointing down indicates the batch is Under.

Steps in batch review mode

      1. Press Re-enter. The STS Re-Entry mode starts which automatically selects all items for re-entry. This is an excellent way to verify all items in the batch, or a limited range of items.
      2. Press Continue. The item Re-Entry Form appears.
      3. Item Re-Entry

        The item reentry form enables the user to re-enter the amounts again and identify the wrong entry in the process. This form has three parts.

        The first, topmost part exhibits the Item entry details as are in the Edit Batch Details form. It has a New Amount column in which the new amount entries are made and compared with the previous entries simultaneously.

        The central part of the form shows the "Re-entry range statistics". It keeps the user informed about the number of items for which New amount field has been re-entered. Variance shows the difference between the Item count and Balance in the entries previously made and the Item count and Balance of the re-entries.

        The lower part of the form - "Batch Statistics", shows the Item Count and Balance as is given in the Batch Header. The variance here is shown between the Batch header Item Count and Balance and the re-entered Item Count and balance.

        Example Re-Entry Screen

         

        The above screen shows that the first item has already been re-entered and found correct. The next item is now in the Current row.

        Steps to re-enter items for validation

      4. ReEnter the amount (in New Amount) for the item in the Current row.
      5. Press Next
      6. If the amount for the current item re-entered in the New Amount field is the same as the one entered in the New Batch form, next item will come to the current row.
      7. Press Close to go to the Batch Items form.
      8. Amount Is Different Form

        In the Re-entry form, when the amount (of a particular entry) in the Item entry form differs from the New Amount STS automatically brings up the "Amount is Different" Form.

        Amount is Different Example

        If the item amount is 9 in the Batch Entry form, and the re-entered amount in the

        Re-entry form is 10 the following "Amount is different" Form appears when "Next" is pressed:

        Steps when Amount is Different form appears

         

      9. Choose any of the options from the "Action" list to edit the original data.
      10. Or…

      11. Edit the amount field.
      12. Choose any of the options from the "Action" list to edit the original data.

 

 

Action Buttons for Amount is Different

 

Replace

Select Replace if you wish to replace the amount entered earlier with the new amount (because the new amount is the correct amount for that item). This will replace the amount for that item, in the Batch entry form.

 

Insert

Select insert if you wish to add the new data as a new item while preserving the original one also.

 

Append

Appends the edited item to the end of the item list, while preserving the original entry also.

 

Delete

Deletes the item and discards the changed amount.

 

Undo

Enables the user to go back to the re-entry screen without making any changes, for further review.

 

 

Resuming Batch Entry

Once the amounts have been re-entered and wrong entries corrected in the Batch Re-entry Form, the Item Count and Balance in "Re-entry range statistics" and "batch Statistics" show same values. The user may resume making entries in the Batch Items form.

 

 

Chapter 3 - STS Items

Item Browser

The Item Browser provides a detailed perspective on Suspense data. All of the STS Browsers can be considered dynamic online reports that can be controlled easily by the user.

The Item Browser can be used in the following ways:

    • Identify Items using Quick Filters and Custom Queries
    • Review Item information directly in the spreadsheet view
    • Open Batch Detail information using Batch Review
    • Reassign Selected Items to a new Owner
    • Write-Off Selected Items
    • Match Selected Item to Any Other Outstanding Items (Force)

The STS Item Browser enables the user to view all or selected items depending on the criteria of selection entered by the user in the form filters. The form shows lists of Items only from the batches that are marked "Complete". The "Clear Item" button enables the user to force-match and clear suspense items in the same screen.

 

Example Item Browser

 

Item Browsing

The browsing tools available on this form are many. Three types of filters are possible: Quick Filters, Standard Filters, and the Custom Query Builder filter. See the sections below on Quick Filters and Standard Filters, and see the next chapter for detailed information on the Custom Query Builder.

 

Item Browser Action Buttons

 

PRINT

Prints the report of the list.

 

REASSIGN

Users with the appropriate security level can reassign items to any other user. This is useful for distributing the load of Item clearing or transferring ownership.

 

NOTES

Enables the user to write notes (up to one-hundred characters) for reference, for each of the item entries.

    • Click on Notes.
    • In the following screen that appears type in the note for that entry.

    • Press Save & Add, to save the note and add to the list.

Or…

    • Press Save to save the note and keep editing the same item.

 

CLEAR ITEMS

Active items in an item list need to be cleared. The items are cleared in the Item Matching Form. Clicking on the Clear Items button takes the user to the Item Matching Form.

Quick Filters

Using Quick Filters

The user may use the quick filters and specify the parameters and criteria of selection for any particular item list. The user may choose an option from the drop down window of each of these fields - Item Status, Cost Center, Owner, Entered By, Suspense Code (Alpha Code), Batch ID, Match ID, Item ID, Account Number, Control Number, and Item Amount Range.

These QuickFilter fields, available in the Item Browser and in the Item Matching form are described below:

 

Item Status

The STS Items form can exhibit all item entries irrespective of their status. A user may choose the Item status from the drop down window to view entries with only the chosen Item Status.

Item Status Quick Filters available:

All

Exhibits all entries irrespective of the Item status.

Active (A)

An Item is active if it has not been cleared – uncleared entries are active Items.

System Cleared (S)

STS System automatically clears entries having logical counterparts. These are marked as System cleared.

Difference (D)

Certain entries might be cleared through "force matching"-i.e.- all the parameters of the entries might not match but the two (or more) items may be cleared by the user. Such entries are cleared irrespective of the difference in the amount (+ value or – value).

Matched (M)

Two entries are marked "Matched" by the system when they are cleared on the basis of their equal amounts (one being +value and the other-value), ignoring all other parameters.

Loss (L) or Gain (G)

If an item is forced matched and cleared by itself it is marked as Loss or Gain by STS System depending on weather it is debit or credit.

 

Cost Center

Enables selection of item entries to be viewed on the basis of cost center.

 

Owner, Entered By

Enables selection of item entries to be viewed on the basis of the owner/particular data entry person.

 

 

Batch ID

Enables selection of item entries to be viewed on the basis of Batch ID.

 

Match ID

Enables selection of item entries to be viewed on the basis of Match ID.

 

Item ID

Enables selection of item entries to be viewed on the basis of Item ID.

 

Account Number

Enables selection of item entries to be viewed on the basis of Account Number.

 

Control Number

Enables selection of item entries to be viewed on the basis of Control Number.

 

Item Amount Range

Enables selection of item entries to be viewed on the basis of Item amount.

 

 

Steps to apply a Quick Filter

      1. Click the drop down listbox.
      2. Select any available option from the list.
      3. Enter an amount or value, if required.
      4. Use any combination of fields.
      5. Press Refresh.

 

 

 

Example of Quick Filter Usage

The above STS Items screen displays an Item List that has the following criteria for selection:

Show all items…

    • Irrespective of the Item Status (All),
    • And made at the Dallas Cost Center,
    • And which have been Assigned to or the Owner of which is MicheleH,
    • And which have been entered by LornaM,
    • And entered on the specified date (01/24/98) only,
    • And with Item Amount greater than or equal to $200.

 

 

Standard Filters

Standard Filters offer the user rapid, flexible querying of suspense records. Users select a built-in filter name from the Standard Filter dropdown list, then click the Refresh button. The results show only those records matching the prescribed set of filters – any Quick Filters used will be displayed.

The list of Standard Filters may grow, as STS Administrators identify more preset filter combinations. Any changes to the Standard Filters require a permanent change to the database. These changes need to be coordinated with the STS developers.

The most flexible option for advanced querying is to define your own custom queries using the Query Builder.

 

Chapter 4 - Query Builder

The Query Builder Interface

The Query Builder enables users to build their own ad-hoc queries and view every imaginable cross-section of Items.

The Query Builder Form has two basic sections:

    • Custom Query Conditions

Enables the user to build custom queries. It may be used when, for example, the user wishes to view an item list that displays only the items that have their Account Numbers starting with 54 or 46.

    • Custom Sort Key

The custom sort key enables the user to view a suspense item list in ascending or descending order. Example, if the user wishes to view the above query list in ascending order of the Account Numbers, the use the Custom sort key.

 

Steps to use custom query conditions

      1. Select a Comparison Field
      2. The comparison field is the field by which the user wishes to compare, or view a list. The user may wish to view a list of items according to any of the following comparison fields:

         

        Account Number

        A 16 digit number that identifies each item as belonging to a specific Credit Card Account Number. STS has a check digit validation test for STS Account Numbers; if an Account Number does not pass the test the system warns the user by sending in the message. The user may wish to view a list of items with a unique Account Number, or items with the Account Numbers ranging between two values.

         

        Control Number

        Control numbers follow a standard format of six numbers. They are divided into ranges according to department or function and never overlap. Thus, each item has a unique control number which in turn falls in the range of control numbers that have been allotted to the department or Cost Center where the item is entered.

         

        Batch ID

        It is auto generated by the system for each new batch that is created.

         

        Item ID

        It is auto generated by the system for each item.

         

        Match ID

        ItemID that item is matched with.

         

        Item Status:

        An item may be active (A), or cleared through any of the following – Auto-Cleared, Manual, Difference, Loss, Gain. The user may view a list by giving item status as a criterion in the Query Builder.

        Amount

        The user may wish to set up a criterion in the Query Builder wherein the amount of the items may be involved.

         

        Entry Date

        Date on which the batch/item entry was made in STS.

         

         

        Entry By

        Name of the user, login ID of the user who entered the batch/item.

         

        Resolution Date

        Date on which the item was resolved (cleared).

         

        Resolution By

        Name of the user who resolved the item.

         

        Item Note

        A note may be written to an item/batch or a group of items/batches. The user may view a list of items selecting the Item Note as a criterion.

         

        Owner

        Each item/batch is allotted to an owner. Owner is an option field to choose from while building a query.

         

        Last Change Date

        Date on which any changes were made to an item/batch detail, example- re-assignment of batch/item to a new owner.

         

        Last Change By

        Name of the user who last made the changes to an item/batch detail, example- re-assignment of item/batch to a new owner.

         

        Edited

        Item has been edited.

         

        Item Open

        An item which is active and is presently open (being review for clearing).

         

        Item Open By

        Name of the user who is logged in and has Item Open.

         

        Write-Off Amount

        When items are Force Cleared, certain amount may be written off (since the two items may not have equal amount). Such an amount is called the Write-Off amount. The user may use this field as a criterion in the Query Builder.

         

      3. Select a Criteria (Comparison Method)
      4. The user may choose any one of the available criteria for comparison of values or text.

        If a value comparison is being formed, the standard comparison rules for numbers apply.

        Examples: 1 < 2 1 is less than 2

        1 ≥ 1 1 is greater than or equal to 1

        0 <> 1 0 is not equal to 1

         

        If a text comparison is being formed, comparison rules apply according to alphabetical order.

        Examples: Jones < Smith "Jones" is less than "Smith"

        Jones ≥ Jones "Jones" is greater than or equal to "Jones"

        ALPHA > A3 "ALPHA" is greater than "A3"

        Alpha < Alps "Alpha" is less than "Alps"

        Alpha < ALPHA "Alpha" is less than "ALPHA"

        Gamma < Gammas "Gamma" is less than "Gammas"

         

         

        Null is another comparison type, which implies "empty". Null need not be chosen for required fields, such as the Amount field, because they can never be Null. It is of special consequence when the user wishes to find a list of items/batches with missing values for the fields like Last Change By.

         

      5. Input a Comparison Value
      6. The Comparison Value is the value or text that is being sought or excluded for all possibilities in the comparison field being used. In the example below, the Account Number is input to find only the items with that Account Number.

         

      7. Click the "Add to List" button

This saves the specified condition in the list, to which others can be added. The possibility for adding an unlimited number of query conditions so easily is what makes the Query Builder such a powerful tool.

 

Example of custom query conditions

 

    • Select Account Number from the drop-down listbox in the Comparison Field.
    • Since the user wishes to view only numbers starting with specified digits - 54 and 46
    • Select Like from the Criteria drop-down listbox.
    • In the Comparison value enter 54.
    • Press Add to list
    • Select And
    • Repeat the earlier steps, replacing the Comparison value with 42.
    • Press Add to list.
    • Press OK

 

The list of items with the Account Number starting with 54 and 46 get displayed. This criterion may also be given in combination with the other parameters (fields) of criteria.

 

 

 

Steps to use custom sort key

      1. Click to unfold the Field drop-down listbox.
      2. Choose a field (by clicking) from the list.
      3. Choose Ascending/Descending from the order field to display the list according to ascending or descending order.
      4. Click on Add to List to add the entry.
      5. You can add as many fields as you like to build your custom sort key, though one or two is optimal.
      6. To remove a criterion from the custom sort key, highlight the criterion and click Remove.
      7. Click OK to complete the Custom Query and run the query.
      8.  

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Chapter 5 - Item Clearing

        The Item Clearing Form allows a selected outstanding item from the Item Browser to be matched with other outstanding items according to an entirely different set of conditions. Default conditions for matching items are pre-populated based on the source item’s Account Number and Control Number. Unmatched Balance reflects the total amount left to match. If this amount is not zero when the user clicks the "Clear Item" button, the user must either mark the matched items as pending, or Write-Off the remaining balance.

        The lower portion of the form exhibits the item that is to be cleared. In the upper portion of the form the user may fill in a criterion to get an Item Matching list, to match/force match and clear the selected item. A single item may be cleared against one or more items.

        Example of Item Clearing Screen

         

         

         

        Steps to clear a suspense item

      9. Quick Filters - Fill in the criterion of selection in the Quick Filters (using the same procedure as in the STS Items Form).
      10. Show Items Having Same window – Provides an option to view items with the same Account Number and/or Control number.

      11. Check/uncheck the Account Number and/or Control number field.
      12. Amount Filters- From the drop-down listbox choose All or enter a comparison amount in the Item Amount Range in the Amount filters.
      13. User Filters – These are similar to the User filters in the STS Items List Form and involve the same procedures.
      14. Click on Refresh.

TIP

    • Click on refresh after any changes made in the filters to view the refreshed list.

An Item Matching List is displayed in the upper portion of the form according to the criterion specified by the user in the filters. All the items exhibited are active. The lower portion exhibits the item to be cleared.

 

      1. Select an item from the Item matching List by highlighting it.
      2.  

      3. Click on Add Item
      4.  

      5. The item gets appended to the Clear item column.
      6.  

         

        Depending on the amount Difference, the lower panel exhibits one of the following options:

         

        Clear as Gain

        If the item is cleared by itself and the Difference Remaining column exhibits a negative amount value.

         

        Clear as Loss

        If the item is cleared by itself and the Difference Remaining column exhibits a positive amount value.

         

        Clear with Difference

        If there is a difference in the amounts of the two items selected to match for clearing.

         

        Clear Matched Items

        If two suspense items have equal amounts.

         

      7. To clear the selected item, click on the option that appears, as described above. The STS Items Form appears with the next active item highlighted.
      8. Click on Remove if you wish to remove an item selected from the Item matching list that is appended in the Clear List.
      9. Click Clear Item to repeat the clearing process.
      10. If you wish to keep an item pending and don’t wish to force clear it in the Item Clearing Form, press Close.

 

 

 

 

 

Chapter 6 - Batch Browser

The STS Batches Form enables the user to view the details of every batch that forms part of the STS System on the same spreadsheet. It shows the Batch no, Batch date, Item Count in a batch, Batch Total, Status of the batch, Alpha Code, Entry by, Entry date, and description (if given during entry). The STS Batches Form appears when the Batch browser is clicked.

 

The Batch Browser may be used in the following ways:

    • Identify Batches using Quick Filters and Custom Queries.
    • Review Batch information directly in the spreadsheet view.
    • View Item Count and Amount Balances across multiple Batches.
    • Open Batch Detail information using the Item Browser.
    • Open Batch Detail information using Batch Review.
    • Request a Batch Report.
    • Reassign a Batch to a new Owner.
    • Reject a Batch

 

The user may use the Quick Filters and User filters (following the procedure explained earlier in the Items screen), to view a batch list with the specified criterion.

 

Example of Batch Browser

The following screen is exhibiting the detailed batch list based on the following criterion –

    • Batch status – All.
    • Entered by – Rhondac
    • Alpha Code – All
    • Batch Entry Date – From 01/01/98 to 07/22/98, i.e. entries made within this time period.

 

The STS Batches form displays the list of STS Batches. Viewing a list of STS Batches enables the user to get an overall view of all the batches in an instant. All the detailed information of each batch is given in this form.

 

Apart from the usual Quick Filters and User filters which may be used to view customized lists the STS Batches form has the following features-

 

Open Item Detail

Opens the details of the batch that is highlighted in the STS Batches form. With the help of this button the user may view the STS Item list of any particular batch in that batch list.

    • Highlight the batch that you wish to view.
    • Click on Open Item detail.

This opens the Items list of that batch which the user may view for item details, however no changes or editing can be done on the list.

    • Click Close to revert to the STS Batches form.

 

Re-Assign Batch

A batch, which has not been cleared, may be re-assigned to a new owner. This can be done only by someone having the Security Level clearance to do so.

 

Steps to Reassign Batch

      1. Click Reassign batch.
      2. The following Reassign batch screen appears (see screen image below)

      3. In the New Owner field enter/select from the drop-down listbox, the name of the person you wish to reassign the batch to.
      4. Current owner field displays the name of the person to whom the batch is currently assigned.
      5. Enter the reason for the reassignment of the batch to a new owner in the Reason field.
      6. Click OK, to return to the form.

Batch Ownership History- STS displays the detailed history of ownership of a particular batch in this part of the form.

When you have done viewing the batches, the item details, or re-assigned uncleared batches to new owners-

 

Click on Close to exit.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Chapter 7 – Report Manager

The Report Manager is the springboard to all STS reports. Users can specify filter criteria, such as a date range, using Report Filters to view and print a STS report for selected criteria.

Reports

The following reports are all available from STS Reporter:

 

Daily Suspense Summary Report

The Daily Suspense Summary Report displays Item Counts and Item Net Balances grouped by Suspense Code, and System. Totals and a Grand Total summaries item activity across suspense code categories. This report has traditionally been prepared only for a single day, but this report can now be modified using Reporter parameters to reflect item data across Date Ranges, Cost Centers, Users, or any other available Suspense criteria.

 

Suspense Aging Report (by Accounting Month)

The Suspense Code Analysis Report summarizes item Counts, item Debit totals, item Credit totals, and Net Balances by Suspense Code, as in the Suspense Summary, but also includes aging information for each Suspense Code. Totals and Grand Totals summarize categories. This report is available for any selectable period, and can be filtered by any of the other available Reporter criteria.

 

Suspense Aging Report

The Suspense Aging Report summarizes Open item activity by aging periods: Active, Current, 30-days, 60-days, 90-days, and more than 120-days. Debits, Credits, Net Balances, and Item Counts are shown with Grand Totals. This report is available for any selectable period, and can be filtered by any of the other available Reporter criteria.

 

Suspense Resolution Report

The Suspense Resolution Report summarizes item resolution. Net Balances and Item Counts are aggregated for each status - Open, Closed, Reject, Incomplete - and grouped by aging status: Active, Current, 30-days, 60-days, 90-days, and more than 120-days. Another column, "Time to Close", displays the average amount of time it has taken to close all items. This report is available for any selectable period, and can be filtered by any of the other available Reporter criteria.

 

Suspense Progress Summary Report

The Suspense Progress Summary Report is useful for analyzing the progress of Suspense Closure milestones. Using Reporter, the following key labor productivity statistics are computed across any selectable group of Suspense Items:

    • Total Items Entered
    • Total Items Reviewed
    • Total Items Rejected
    • Total Items Completed
    • Average/Total Days to Completion (since entry)
    • Total Items Closed
    • Average/Total Days to Closure (since completion)
    • Total Items Automatically Closed
    • Average/Total Days to Automatic Closure
    • Total Items Forced
    • Average/Total Days to Forced Closure (since completion)
    • Total Items Written Off (Over-and-Above)
    • Average/Total Days to Write-Off (since completion)

For example, the Progress Summary Report could be generated for several different date ranges (i.e.: quarterly) to trend Suspense movement over time.

 

Suspense Labor Summary Report

The Suspense Labor Summary Report summarizes time spent on various Suspense item activities. Using Reporter filters, the following key labor productivity statistics are combined according to any selectable group of Suspense Items:

    • Total Items Entered
    • Average/Total Time to Enter
    • Total Items Reviewed
    • Average/Total Time Review
    • Total Items Completed
    • Average/Total Time to Complete
    • Total Items Cleared
    • Average/Total Time to Clear
    • Total Items Cleared Automatically
    • Average/Total Time to Automatic Clearing
    • Total Items Forced Clear
    • Average/Total Time to Forced Clear

An excellent application of this report would be to compare STS productivity between Cost Centers. This report can also be generated for each user, so quantified productivity tracking could be included in individual (or team) performance appraisals and status reports.

This report could also be useful for observing the learning curve involved in the new STS system implementation, or for new employees. Average Time to Complete should drop over time!

 

 

Suspense User Report

The Suspense User Report displays all STS users and their system settings.

 

Batch Summary Report

The Batch Summary Report presents overall information about each batch or multiple-selected batches, limited to the following fields:

    • Entry Date/Time
    • Entered By User Name
    • Batch ID
    • Batch Date/Time
    • Cost Center
    • Original Batch Total
    • Total Item Balance
    • Batch Description

Batch Detail Report

The Batch Detail Report shows much more information about each batch or multiple-selected batches. An Item Detail section showing all relevant Item fields are appears for each batch, along with the following fields:

    • Entry Date/Time
    • Entered By User Name
    • Batch ID
    • Last Review Date/Time
    • Last Review User Name
    • Verify Date/Time
    • Batch Date/Time
    • Cost Center
    • Original Batch Total
    • Total Item Balance
    • Batch Description
    • Complete Item Detail

 

Custom Detail Report

The Custom Detail Report displays all critical Suspense data fields for all selected Suspense Items. The user can display whichever Suspense Items they choose, using the Reporter filters and custom query.

 

 

Report Manager Interface

The STS Reports Screen lists the various reports that may be previewed and printed.

 

 

 

Steps to view a report

      1. Select the type of report you wish to view by highlighting it.
      2. Enter the fields in Report Filters to select a criterion for the report.
      3. Click on Preview to open the detailed report in a separate window.
      4. Click the Print icon at the top of the report preview.
      5. Or…

      6. Click directly on Print, in the STS Reports Form.

In the above example screen, Daily Suspense Summary Report is highlighted, and the report filters for the same are entered. The following report window is displayed when Preview is clicked:

 

 

The report gives a summary report for the period 03/23/98 to 07/23/98, entered at all Cost centers by Rhondac.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Chapter 8 - STS Tracker

 

Suspense Tracking in Real Time

STS Tracker is a powerful suspense monitoring tool, allowing the Administrator, or anyone else with Tracker privileges, to "take the pulse" of crucial system activity. Paper is out – viewing information online is definitely the direction all businesses are going. This Tracker tool combines dozens of reports into an Active View (a window displaying links to live data that can be updated on demand).

By instantly surveying all STS users (across the corporate network) and analyzing STS system database performance, the Tracker engine automatically summarizes real time statistics. Results are displayed in a friendly interface that can be refreshed and displayed in either of the following views:

 

 

User Watch

The User Watch track shows how many users are currently connected. Detailed user monitoring includes the location and names of all current users, how long they have been logged in, and which system activities they are currently engaged in. Productivity statistics are also available in user watch programs, including time and volume statistics for selectable users.

 

 

Suspense Watch

The Suspense Watch track charts mission-critical suspense item statistics so suspense supervisors can see a picture of where all suspense items are in the system. Graphs display live suspense item volumes and Balance summaries grouped by switch-able criteria.

 

 

Having this online information at your fingertips in real time is one of the strongest features available now with STS. We anticipate this feature will be very popular with the suspense supervisors who want to understand what the situation is with suspense information, right now!

 

 

Suspense Track Interface

The STS Suspense Track form enables the user to access all the features of the Tracker.

Active Connections

Shows detailed list of the STS sites and users logged on to STS.

Fields – Cost Center, Name, User ID, Logged on since (Date and Time).

Active Item Entry

Shows detailed list of the active entry sites in STS.

Fields – Cost Center Name, User ID, Batch Open since, Batch, Items.

 

Active Matching

Shows detailed list of the active matching sites in STS.

Fields – Cost Center, Name, User ID, Item Open since, Item ID.

 

Suspense Statistics

Gives the statistics of the suspense items across various fields, like –

Item Count, Debit Total, Credit Total of all suspense items –

Being Entered, Completed, Pending, Force Matched, Gains, Losses, Differences, Manual Cleared (total), Auto Cleared (total), Total Cleared.

 

Activity Date Filter and Ownership Filter

The user may enter a date criterion to see the statistics of suspense items in that particular period. Ownership filters enable the user to specify the ownership criteria for the suspense items he wishes to view, across the following fields – Location (Cost Center), Owner, Entry By.

    • Specify the criterion of selection in the Filter fields.
    • Click Refresh Statistics.

 

Suspense Statistics Tracker Example

The following Suspense Statistics screen shows the values across the various fields by the following selected criteria - Entries made between 02/23/98 and 07/23/98, at the Dallas Cost Center. Owned and entered by all users.

 

Suspense Graph

The Suspense Graph engine presents two basic charts that turn Suspense statistics into pictures that can be deciphered quickly. The 3-D chart can even be rotated with the mouse.

TIP

    • To rotate the 3-D column chart, press the CTRL key, hold the left mouse button down and drag the mouse using circular movements.

 

Suspense Graph Tracker Example

Following is a three dimensional graphical representation of the suspense items, of which the statistics against various parameters are given above.

 

 

Legend

An index of the colors that represent suspense items in different stages and types.

Example:

Red – Suspense batches which are marked Complete.

Green – Suspense items that are pending.

 

Perspective

The Graphs may be viewed using two or three dimensions (flat or 3-D).

    • Choose by clicking on the perspective you wish to view the graph in.

 

Data Type

You may choose from Item Volumes or Net Amounts.

Item VolumesGraphical representation of the Item Volume data statistics for each legend item is displayed.

Net Amounts – Graphical representation of the Net Amounts data statistics for each legend item is displayed.

The above graph example is displaying the Item Volume statistics, in which the Completed batches are about 50, Forced matches are a little more than 10, Loss is negligible, Differences are about 30, and Cleared are 50.

 

To get a refreshed graph for the same criteria

      1. Click on Refresh Statistics.
      2. Click Close to return to STS main menu Window.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Chapter 9 - STS Maintenance

The maintenance browser takes the user straight to the Maintenance Form that enlists the following categories and fields over which the Administrator has control.

 

    • Users
    • Security Level
    • Alpha Codes
    • Alpha Code groups
    • Cost Centers
    • Accounting Months
    • Control Numbers
    • Credit Card Systems

 

 

User Maintenance

STS Users Form

Displays details of STS Users, including their User ID, Network ID, Name, Security Level that they enjoy, phone number, owner and cost center (location). The browser form enables the System Administrator to easily manage the entire collection of STS users.

Quick Filters facilitate the administrator in viewing customized lists.

Guests, or non-users, may have access to the system according to the security level assigned to the built-in user name "Guest". All other users need to be added to the system. User Admin allows the System Administrator to add users, delete users, and change user settings.

 

Steps to add a new user

      1. Click on New.
      2. The following form appears:
      3.  

      4. Enter each field under User Account Details.
      5. Select the security level from the drop-down listbox, in the User Security Level field.
      6. Enter the Default owner of new items field.
      7. Click on Save.
      8. The new user can login once added by the Administrator.
      9.  

        Editing user properties

        The Edit User Detail Form enables the administrator to edit and make changes in the user lists. This is of special use when the administrator wishes to change the user ID or any field in the User Account Details, or wishes to make changes in the Security level of any user.

         

        Steps to edit a user

      10. Select the record you wish to edit by highlighting it in the STS Maintenance form.
      11. Click Edit.
      12. The edit form appears.
      13. Click on the field you wish to edit.
      14. Edit the field
      15. Click Save.
      16. Click Cancel, if you wish to cancel the changes.
      17.  

        Steps to delete a user

      18. Select the record you wish to delete by highlighting it.
      19. Click Delete.
      20.  

         

         

        Security Level Maintenance

        The STS Levels Maintenance Form offers the System Administrator flexible and powerful system security management. Security Admin provides an easy to use interface that lets you assign any number of security levels for STS usage. Each security level has a set of options available for accessibility to various system features.

        The Level maintenance form offers the System Administrator flexible and powerful system security management. It provides an easy to use interface and lets you assign any number of security levels for STS usage. Each security level has a set of options available for accessibility to various system features.

        The System Administrator assigns a Level Name and Level Description for each security level, along with many access options.

         

        Steps to add a new security level

      21. Click New on the Maintenance form.
      22. The New Security Level form appears.
      23. Enter the Level name and a brief description of the level.
      24. The Level Details form appears (see Edit Level Details form below)
      25. Check the access options that you wish to offer to the persons having that particular security level.
      26. Click Save.
      27.  

         

        Steps to modify a security level

        The administrator might want to add or delete some of the options for a particular security level. Changes made to a security level will apply to every user that is assigned to that security level. Changes are enacted the next time the user logs in.

      28. Select the security level to be edited by highlighting it.
      29. Click Edit on the Maintenance form.
      30. The following Edit Level details form appears:
      31.  

      32. Check/uncheck the options to provide/cancel access.
      33. Click Save

Important Considerations


Maximum Write-Off or Gain

This field enables the administrator to give the level members a limit up to which they may Write-Off or Gain item amount total.


Level Members

Displays the list of users who enjoy particular Security Level. (To add/delete/edit go to Users Maintenance form in USERS)

Alpha Code Maintenance

The STS Alpha Code Maintenance form will offer a simple user interface for maintaining the list of Suspense Codes. The System Administrator can easily add, remove or change, (using New/Edit/Delete), Suspense and Accounting Code information, including:

    • Alpha Code
    • Accounting Code
    • Code Description

Quick Filters assist in displaying custom lists for maintenance purposes.

 

Cost Center Maintenance

Location Maintenance or Cost Center form enables the administrator to add/ edit

/delete the names of cost centers using New/Edit/Delete.

Above is an Edit Location Details form which displays the list of users (names and user ID) in the DALLAS cost center.

 

 

Accounting Month Maintenance

The Custom Accounting Months Form displays the details of each accounting month. The dates may be edited by clicking the Edit button on the edit form. The accounting month period defines the start and end date for months that are shown in reports. For example, the month of APRIL may be defined to begin April 3rd and end on May 2nd.

 

 

Control Number Maintenance

Each STS Cost Center is allotted a set of Control Numbers, which may range between two limited numbers. These control numbers are allotted by the administrator to avoid any confusion in identifying items. Each item, irrespective of the cost center, has a unique control number. Control Number allotment may be managed and maintained through the Control Number Maintenance Form.

 

 

 

 

Chapter 10 – Other STS Features

Last Batch

The Last Batch browser takes the user straight away to the last batch that is in data entry stage and has not been marked Complete (open batch).

If no batch is in the data entry stage, the following message is displayed.

In such a situation the user may proceed to create a new batch from the New Batch browser, or choose to go to any other browser.

 

 

 

STS Mail

STS Mail is an additional feature and provides the users inhouse services. It works like other email programs, but is contained within STS. Only STS users read and send STS mail.

 

 

STS News

STS Messages and information are delivered by STS News. It informs of any pending job that needs to be completed to the new login to STS System, as soon as the login ID of the user is verified. This helps save time and works as a reminder, helps get an overall view of all the pending work.

 

 

Example of STS News

The following screenshot demonstrates a typical STS News window on startup of the STS application:

 

In the above example, STS News has three messages to deliver:

    • New items were re-assigned to the current user. Clicking the "Open News Item" icon will open the Item Browser and display the items that were re-assigned.
    • There are incomplete batches since yesterday (STS News has reported this independent of location). Clicking the "Open News Item" icon will open the Batch Browser and display the batches still incomplete.
    • An open batch needs to be completed. Clicking the "Open News Item" icon will open the batch details edit form for the pending batch.