TLMRecsPrem2 4 1 1UserGuide

TLM Reconciliations-Premium Version 2.4.1.
User Guide
DISCLAIMER
SmartStream Technologies makes no representations or warranties regarding the contents of this document. We reserve the right to revise this
document or make changes in the specifications of the product described within it at any time without notice and without obligation to notify any
person of such revision or change.
COPYRIGHT NOTICE
2000 -2013 Copyright of SmartStream Technologies. All rights reserved. No part of this publication may be reproduced, stored in a retrieval
system, or transmitted in any form or by any means - electronic, mechanical, photocopying, recording, or otherwise - without the prior written
permission of SmartStream Technologies Limited.
INTELLECTUAL PROPERTY WARNING
The contents of this document and the software it describes are the intellectual property of SmartStream Technologies Limited. The ideas
contained in this document must not be disclosed to any third party.
TRADEMARK NOTICE
TLM® is a registered trademark of SmartStream Technologies Ltd. All rights reserved.
Other trademarks recognised and property of their respective owner.
DOCUMENT INFORMATION
Edition: 1
November 2013
Contents
Contents
About this Guide ...................................................................... 1

Introduction .......................................................................................................... 1
Who should read this guide? ................................................................................ 1
What does this guide cover? ................................................................................. 1
How is this guide organised? ................................................................................ 2
What's not included? ............................................................................................ 2
Related information .............................................................................................. 2
Conventions used in this guide ............................................................................. 3
SmartStream Technologies support ...................................................................... 3
Getting started with the software ........................................... 5

Logging on ........................................................................................................... 6
Using the main menu ............................................................................................ 8
Opening and navigating the menu .................................................................. 9
Changing password ............................................................................................ 10
Using WebConnect Help .................................................................................... 11
Rules for full-text searches ........................................................................... 11
Logging off ......................................................................................................... 12
Working with dashboards ................................................................................... 13
Launching a dashboard ................................................................................. 14
Resizing dashboards ..................................................................................... 15
Refreshing data ............................................................................................. 16
Searching for records .................................................................................... 17
Setting a dashboard as default....................................................................... 18
Closing dashboards ....................................................................................... 19
Working with grids ............................................................................................. 20
Keyboard navigation within grids ................................................................. 21
Selecting records ........................................................................................... 21
Performing actions on selected items............................................................ 23
Changing the view ........................................................................................ 24
Attaching a document ................................................................................... 24
Grid aggregates ............................................................................................. 26
Sorting Data .................................................................................................. 28
Filtering data ................................................................................................. 30
Filtering by images used for Image Decodes ................................................ 34
Exporting data ............................................................................................... 35
Working with treeviews ..................................................................................... 37
Changing how the treeview is displayed....................................................... 37
Launching child dashboards from a treeview ............................................... 39
Working with forms ........................................................................................... 41
Using manual input forms ............................................................................. 41
Comparing data in dashboards ........................................................................... 42
Working with Business Logic tools.................................................................... 43
2 Contents
Using the Audit Trail .......................................................................................... 46

Viewing the audit trail .................................................................................. 46
Viewing notes from the audit trail ................................................................ 46
Viewing the associated items from the audit trail ......................................... 47
Working with the associated items from the audit trail ................................ 47
TLM WebConnect Error messages .................................................................... 48
Managing Reconciliations .................................................... 49

Reconciliations lifecycle .................................................................................... 50
About the Reconciliations dashboards ............................................................... 52
REC Lifecycles Summary dashboard ........................................................... 52
Summary dashboards .................................................................................... 55
Detail dashboards.......................................................................................... 56
About Matching .................................................................................................. 58
Types of matching ........................................................................................ 58
Set balancing ................................................................................................. 59
Authorising Matching ................................................................................... 61
Opportunity Cost for value date differences ................................................. 61
Three-way Matching ..................................................................................... 62
Performing Manual Matching ............................................................................ 63
Matching Items ............................................................................................. 64
Cancelling a match........................................................................................ 65
Working with Pending Matches.................................................................... 65
Cancelling a pending match .......................................................................... 67
Recalling items ............................................................................................. 68
Splitting items ............................................................................................... 69
Deleting an item ............................................................................................ 71
Undeleting an item ........................................................................................ 72
Viewing match details .................................................................................. 73
Approving items and matches ............................................................................ 75
Authorising or rejecting items ...................................................................... 75
Authorising or rejecting matches .................................................................. 76
Searching for items and matches ........................................................................ 77
Searching for matches ................................................................................... 78
Searching for items ....................................................................................... 80
Other matching tasks .......................................................................................... 82
Viewing the details of an item ...................................................................... 83
Putting together items from different dashboards ......................................... 84
Viewing Exceptions ...................................................................................... 85
Creating exceptions....................................................................................... 85
Adding notes to items ................................................................................... 87
Viewing notes ............................................................................................... 88
Linking items ................................................................................................ 88
Unlinking items ............................................................................................ 89
Editing items ................................................................................................. 90
Taking ownership of an item ........................................................................ 93
Unassigning an owner from an item ............................................................. 93
Working with Proofs .......................................................................................... 94
Creating Point in Time Proofs ...................................................................... 95
Viewing proofs ............................................................................................. 95
Viewing proof details.................................................................................... 98
Viewing proof items ................................................................................... 101
Searching for a Proof .................................................................................. 102
Approving Point in Time Proofs ................................................................. 103
Viewing proof audit details ......................................................................... 103
Creating proof notes.................................................................................... 104
Viewing proof notes.................................................................................... 105
Contents 3
Authorising and Rejecting Reconciliations ...................................................... 106

Resubmitting rejected requests ................................................................... 108
Generating Reports ........................................................................................... 110
Managing Exceptions and Alerts ....................................... 115

Exception Management concepts ..................................................................... 116
Exception lifecycle ..................................................................................... 116
Allocation to an Inbox ................................................................................ 117
Alerts .......................................................................................................... 118
Automatically raising and closing exceptions............................................. 118
Inbound and outbound messaging .............................................................. 118
Exception types ........................................................................................... 119
Position Exceptions..................................................................................... 121
Working with Exceptions ................................................................................. 129
Exception Creation ..................................................................................... 129
Viewing and editing exception details ........................................................ 130
Managing exceptions messages .................................................................. 133
Sending exception messages ....................................................................... 140
Authorising outbound messages ................................................................. 142
Attaching documents to an exception ......................................................... 143
Adding notes to an exception ...................................................................... 145
Viewing exception notes ............................................................................. 146
Editing multiple exceptions ........................................................................ 147
Adding an item to an existing exception ..................................................... 148
Resolving an exception ............................................................................... 149
Cancelling an exception .............................................................................. 150
Closing a resolved exception ...................................................................... 151
Reopening an exception .............................................................................. 152
Taking ownership of an exception .............................................................. 152
Unassigning an owner from an exception ................................................... 153
Searching for Exceptions and Alerts ................................................................ 154
Searching for items with exceptions ........................................................... 155
Searching for exceptions ............................................................................. 157
Searching for alerts ..................................................................................... 159
Working with Exchange Traded Derivatives ..................... 161

ETD Proofs ....................................................................................................... 163
Viewing Realtime Total Equity Proofs ....................................................... 163
Creating and viewing Point In Time Total Equity proofs ........................... 165
Viewing Total Equity Proof details ............................................................ 165
Working with Net Asset Value Reconciliations ................ 167

NAV Rec Proofs ............................................................................................... 169
Viewing Realtime Net Asset Value Proofs ................................................. 170
Creating and viewing Point In Time Net Asset Value proofs ..................... 171
Viewing Net Asset Value Proof details ...................................................... 172
4 Contents
Working with General Ledger (GL) Reconciliations ......... 173

Working with General Ledger proofs ............................................................... 174
Scorecards ................................................................................................... 174
Proof Audit ................................................................................................. 175
Viewing GL Proofs .......................................................................................... 176
Clearing proof items ................................................................................... 178
Viewing Scorecards .................................................................................... 179
Searching for a GL Proof ................................................................................. 180
Manually adding GL items ............................................................................... 181
Editing GL Items ........................................................................................ 183
Clearing manual items ................................................................................ 185
Copying items................................................................................................... 186
Re-measurement Processing ............................................................................. 189
GL Proof approval process ............................................................................... 191
Submitting a proof for review ..................................................................... 191
Cancelling a proof submitted for Approval ................................................ 192
Approving a proof....................................................................................... 192
Rejecting a proof......................................................................................... 193
Unfreezing a proof ...................................................................................... 193
Revaluation....................................................................................................... 194
Software Support ..................................................................... 1

Calling SmartStream Technologies Support ........................................................ 1
Before you call... .................................................................................................. 2
Glossary of Terms ................................................................... 1
Index ......................................................................................... 1
About this Guide
Welcome to the TLM Reconciliations-Premium User Guide.

This section deals with:
• Introduction, see below
• Who should read this guide?, page 1
• What does this guide cover?, page 1
• How is this guide organised?, page 2
• What’s not included?, page 2
• Related information, page 2
• Conventions used in this guide, page 3
• SmartStream Technologies support, page 3
Introduction
TLM Reconciliations-Premium is the best-of-breed Reconciliations solution for
automation of cash and securities reconciliation. It delivers pre-packaged
processing and user interfaces, and leverages the power of the leading software
on the market, TLM Reconciliations, to maximise match quality, performance,
and user interface experience.
It helps users to discover the root causes of transaction failures, and take
corrective action to reduce costs and improve match rates. Exceptions can be
inspected, investigated, analysed, and resolved using the browser-based
interface.
Who should read this guide?

This guide is aimed at users responsible for managing reconciliations and
exceptions using TLM Reconciliations-Premium.
What does this guide cover?

This guide describes how to perform TLM reconciliations and exception
management tasks.
2 How is this guide organised?
How is this guide organised?

This guide is divided into the following sections:
• Getting Started with the software – describes the user interface and how to
interact with it.
• Managing Reconciliations – describes the main reconciliations tasks, such
as matching, approval, and working with proofs.
• Managing Exceptions and Alerts – describes the actions that you can
perform on exceptions to work towards resolving them.
• Working with Exchange Traded Derivatives – describes the proofing
dashboards for ETD transactions.
• Working with Net Asset Value Reconciliations – describes the proofing
dashboards for NAV balances.
• Working with General Ledger (GL) Reconciliations – describes how to
work with the proofs for GL reconciliations.
• Software Support - includes contact details.
• Glossary of terms
What's not included?

This guide does not include the following:
• Details of how to maintain the static data within your system. See the TLM
Reconciliations-Premium Administration Guide.
• Details of how to administer users and roles. See the TLM Reconciliations-
Premium User Administration Guide.
Related information
The following guides provide additional information:
• SmartStudio User Guide
• Static TLM Administration Guide
• TLM Reconciliations-Premium Administration Guide
• TLM Reconciliations-Premium Data Dictionary
• TLM Reconciliations-Premium Installation Guide (For Oracle and SQL
Server)
• TLM Reconciliations-Premium SYST Table Descriptions
• TLM Reconciliations-Premium User Administration Guide
• WebConnect Installation Guide
About this Guide 3
Conventions used in this guide

This help uses the following conventions:
Example Describes
<Enter> Pressing the Enter key
<Ctrl + Holding down the Control key and pressing the Home key
Home>
Click or left- Click the left mouse button
click
Bold Bold text indicates menu actions, for example, click Edit.
Italic Italic text is used for emphasis or to denote a particular status
Click [OK] Clicking the OK button displayed in the window
Right-click Click the right mouse button
Double-click Click the left mouse button twice in rapid succession without
moving the mouse
Drag Press and hold down the left mouse button, move the mouse,
then release the mouse.
Represents a link
Represents a note
SmartStream Technologies support

If you are unable to find the solution to your problem in this help, please contact
SmartStream Technologies Support.
Full details are given in chapter Software Support.
Getting started with the software
TLM Reconciliations-Premium is delivered through TLM WebConnect, a web-

based thin client, from which you can view, edit and process reconciliations and
exceptions using a range of pre-packaged dashboards and business logic tools.
This section describes the main features of the user interface, and how to interact
with them.
• Logging on, see below
• Using the main menu, page 8
• Changing password, page 10
• Using WebConnect Help, page 11
• Logging off, page 12
• Working with dashboards, page 13
• Working with grids, page 20
• Working with treeviews, page 37
• Working with forms, page 41
• Comparing data in dashboards, page 42
• Working with Business Logic tools, page 43
• Using the Audit Trail, page 46
• TLM WebConnect Error messages, page 48
6 Logging on
Logging on
To use the software, you must enter the launch page URL in a browser, such as
Internet Explorer. The Login page will then be displayed and you can enter your
username and password. These are allocated to you by your Administrator.
To log on
1. Enter the launch page URL in a browser.
For example, http://192.168.111.88:7001/WebConnect/login/login.jsp
The Login page is displayed:
2. Enter your Username and Password.

Passwords are case-sensitive.
3. Click [Login].
If successful, the user interface is displayed.
If unsuccessful, the system displays a warning and allows you to re-enter
your login information. Depending on whether user lockout is enabled, you
might be allowed several further attempts at logging on, before the system
locks you out.
4. If you are logging on for the first time, or if your password has expired, you
are asked to reset your password:
Getting started with the software 7
5. Enter your current password in the Old Password field.

6. Enter your New Password in the first field.
7. Confirm your New Password in the second field.
8. Click [Submit].
The passwords are validated. If the old password is incorrect or the new
password is not valid, you are prompted to enter the details again.
If you incorrectly enter the new password, you are asked to re-enter it. If
your new password is accepted, the main menu is displayed.
After logging in, your user is validated, and a message similar to the
following might be displayed:
This message means that either your user type is not licensed to use the
stated message types, or that the licences for this message type have all been
taken by other users. If you require access to the stated message types, see
your System Administrator.
8 Using the main menu
Using the main menu

The main menu displays the dashboards required to carry out reconciliations and
exceptions management, and a number of special commands such as help and
logout.
To view the menu, click Menu on the upper left of the window. For example:
The dashboards and special commands might be grouped into submenus.

Submenus are denoted by an arrow icon , and can be nested to any number of
levels.
The special commands that are usually present on the menu are as follows:
• The Options > Change Password option that enables you to change your
password, page 10.
• The Help > Contents option that launches online help, page 11.
• The Help > About option that displays the WebConnect version and build
date.
• The Logout option that enables you to logout, page 12.
Opening and navigating the menu

You can open, close and navigate the menu using both the mouse and the
keyboard.
To open the main menu

• Do one of the following:
• Click the [Menu] button
• Tab to the [Menu] button and press <Enter>
• Press <F9>.
To close the main menu

• Click anywhere in the desktop outside of the menu
• Press <Esc>.
To navigate to a menu item

• Using the mouse, hover over a top level menu or submenu to display
the contents of that menu, and then click on the required dashboard or
special command.
• Using the keyboard navigate to the required top level menu by pressing
the up and down arrow keys, then press <Enter> or the right arrow key
to open it. Use the up and down arrows within a submenu to navigate it,
and again press <Enter> or right to open further submenus or a
dashboard or special command.
Alternatively, while the focus is on the required submenu you can press
a key that corresponds to the first letter of a dashboard name to select it,
and then press <Enter>. If there is more than one dashboard name
starting with that letter, pressing the same key again will select the next
one in the menu.
For dashboards, you can use modifier keys to launch a dashboard in a
new browser, page 14.
10 Changing password
Changing password
Provided that your user role gives you access to the Change Password option,
you can change your password at any time without supervisor intervention.
If you attempt to change your password to one that has been used previously, an
error might be displayed that refers you to your system administrator. By default,
the system is configured to prevent you from reusing your last four passwords.
To change your password

1. Select Menu > Change Password.
The following window is displayed:
2. Enter your current password in the Old Password field.

3. In the New Password (repeat) fields
1. Enter your new password in the first field.
2. Confirm your new password in the second field.
4. Click [Submit].
The passwords are validated. If the old password is incorrect or the new
password is not valid, you are prompted to enter the details again.
If this is the first time that a new user has logged into TLM WebConnect,
the Change Password dialogue is automatically displayed.
Using WebConnect Help

The online help is accessed by selecting Help > Contents from the main menu.
The WebConnect Help system is displayed in a browser window, and you can
search for the information you need.
From the browser window, you can navigate using the following buttons:
Windows XP security block

If you view the Help in Internet Explorer on Windows XP SP2 and higher, a
yellow bar might be displayed stating that your active content (JavaScript) is
disabled, and the Help will not have the proper layout and won’t respond
properly to user interaction.
• To allow active contents to run for this instance, click the yellow bar and
select Allow Blocked Content from the menu.
• To disable this security block for all local content (local content is generally
a lot safer then Internet content), in Internet Explorer go to the Tools >
Internet options > Advanced window and in the Security options, select
the Allow local content to run in files on My Computer checkbox.
Rules for full-text searches

The rules for full-text searches are:
• Searches are not case-sensitive, so you can type your search in uppercase or
lowercase characters.
• You can search for any combination of letters (a-z) and numbers (0-9).
• Punctuation marks, such as the period (.), colon (:), semicolon (;), comma
(,), and hyphen (-), are ignored during a search.
• You can group the elements of your search using double quotes (".. ") or
parentheses ('.. ') to set apart each element. You cannot search for quotation
marks.
If you search for a file name with an extension, group the entire string in
double quotes ("file name.ext").
• You can use the AND, OR, and NOT operators to refine your search by
creating a relationship between search terms. If you do not specify an
operator, AND is used. For example:
• Specifying "message AND feed" finds topics that contain both
"message" and "feed."
• Specifying "Security OR alias" finds topics that contain either the term
"security" or the term "alias" or both.
• Specifying "balance" NOT "trial" finds topics that contain "balance" but
not "trial."
12 Logging off
Logging off
To log off from TLM Reconciliations-Premium
1. Do one of the following
• Select Menu > Logout option.
• Click to close the TLM WebConnect window.

The following window is displayed.
2. Click [OK] to log off.

Working with dashboards

In TLM Reconciliations-Premium, you view information using dashboards,
which provide a graphical view of data in the form of charts, grids, treeviews,
and so on. You can also use other customised controls which have been
configured for a dashboard.
A number of screenshots are used throughout this section to demonstrate how to

work with dashboards. The dashboards used in these examples are for illustrative
purposes only, and might differ from those available in Reconciliations-
Premium.
Dates
The format in which dates are displayed in WebConnect is dd/MM/yyyy.
If you want to customise the date format you must contact your System
Administrator.
Maximum row limit

The maximum number of data rows that you can view in TLM WebConnect
might be limited by the USER_ACTIVE_ROWS setting. This SYST setting
specifies how many rows you can view across all dashboards and controls at any
point in time.
When the maximum number of rows is reached, no further data will be returned
by subsequent searches, and a warning indicating that the data has been
truncated is displayed in the dashboard’s summary row. For example:
However, closing existing dashboards and controls immediately frees up rows

and enables future searches to return data.
If you want to change the maximum row limit, you will need to contact your
System Administrator.
14 Working with dashboards
Launching a dashboard
In TLM Reconciliations-Premium you might have a cash dashboard, a security
positions dashboard, or an exception dashboard. Each reconciliation service to
which you have subscribed usually will have its own dashboard. Sometimes,
however data for different instrument types, such as cash and securities is
presented in the same common dashboard because the dashboard is the same for
both.
To open a dashboard, you click on or press <Enter> on a dashboard name in the
menu. The first dashboard that you open is displayed in its designed position and
size. When you open a second dashboard, it either opens in an empty a space in
the same window, or as a new tab that overlaps the dashboard that is already
open. If you open a duplicate of an already open dashboard, it is displayed in a
new tab that overlaps the original dashboard. You can optionally open a
dashboard in a new browser window using <Shift + Ctrl>.
To launch a dashboard
1. Select Menu.
A series of menus are displayed.
2. Navigate to the dashboard you want to launch.

3. Do one of the following:
• To launch the dashboard in the current browser window, click on or
press <Enter> on the required dashboard.
• To launch the dashboard in a new browser, press <Shift + Ctrl>, and
then click on or press <Enter> on the required dashboard.
On pressing <Shift + Ctrl> the menu items are displayed with an
icon to denote that they will be launched in a new browser.
4. If a search prompt is displayed, enter some values on which to base the
search, or in some cases you can just click [Search].
For details on how to search for items, see page 80.
Launching child dashboards

Some dashboards enable you to launch child dashboards from context menus
(right-click to display the context menu), or by double-clicking on a grid row or
treeview node.
By pressing the <Shift> key when you launch a child dashboard you can open
multiple instances of the dashboard in a single space. If you launch the child
from the context menu, when you press <Shift> the dashboard is displayed in the
context menu with an icon.
Child dashboards that are launched in this way are known as orphans. For
example:
If the child dashboard is already open and you attempt to launch it again without
pressing the <Shift> key, the dashboard simply refreshes.
If the dashboards are automatically refreshed by TLM WebConnect and you

have opened multiple instances of the same child dashboard, the refresh only
works for the first child dashboard that you opened and not the orphaned
versions of the child dashboard.
Resizing dashboards
Where dashboards are displayed in separate spaces, you can maximise them by
double-clicking on the dashboard tab; double-click again to reset the dashboard
back to its original size and position.
You can also resize the dashboards by dragging the edges. For example, the
image below shows what happens when the right corner of the chart is dragged
towards the right, reducing the size of the tree:
The grey shaded lines show where the dashboards will be resized to when the
mouse button is released.
If you resize or maximise the browser window, the dashboards will
automatically resize to fit in the window.
Refreshing data
When you make changes on a dashboard, the data in that dashboard might have
to be refreshed before the changes are displayed. You might also need to refresh
the data in other open dashboards to reflect the change.
To perform a manual refresh

1. Do one of the following
• Click the refresh icon on the top right of the dashboards title tab.
• Right-click on the control's title bar and select Refresh.
If there are multiple tabbed dashboards in the space, you can alternatively
right-click and select Refresh All to update the data on each of the tabbed
dashboards.
2. The search prompt is displayed, pre-loaded with the options you selected
initially. Click [Search].
The control's data is refreshed.
If a grid row was previously highlighted, the row is now displayed as the
first row in the grid page. For example, if you had row 9 selected and the
grid displayed rows 1 to 30 on the first page, when you refresh the grid, the
data is refreshed and the grid displays rows 9 to 38, with row 9 highlighted
at the top of the page.
If the row that was highlighted is no longer returned by the search, for
example if some data in that row has been updated and it is now filtered out
by the search, the next row down in the grid is highlighted instead.
Searching for records

When you first launch a dashboard, a search prompt window is commonly
displayed. This enables you to specify criteria for the records that you want to be
returned from the search and displayed on the dashboard.
To search for records

1. In the Search Prompt dialog that is displayed when you launch a dashboard,
complete the search prompts.
Example:
The following image shows an example of a search prompt for exceptions.
If any tolerance values have been configured for an input field, they are
displayed when you hover the mouse over the field.
You can use an asterisk (*) as a wildcard in '=' or 'like' searches. You can
also use % as a wildcard in 'like' searches.
Where the search attribute is a datetime attribute, you can enter a time range
as well as a date range.
2. Click [Search].
The results of your search are displayed.
Setting a dashboard as default

You can designate a primary dashboard to launch automatically when you start
TLM Reconciliations-Premium. The default dashboard is set using a cookie, so
is made available for the computer on which it is set, regardless of which user
logs into TLM Reconciliations-Premium on that machine.
To set a dashboard as the default

1. Launch the dashboard that you want to be launched on start-up, completing
any required search parameters.
2. Right-click on the dashboard's tab and select Set As Default.
Default dashboards are displayed with a check mark next to the Set As
Default option.
When you next logon on the same computer, the dashboard is launched
automatically.
Closing dashboards
Single dashboards are closed in the usual way, by clicking the in the top right
corner of the dashboard’s tab, or by right-clicking on the tab and selecting Close
from the context menu.
You can also close all dashboards in a space, optionally leaving only the
dashboard that is currently in focus open.
To close other dashboards in a space

• Right-click the tab of the dashboard you want to remain open, and select
Close Others.
All dashboards except the current one are closed.
To close all dashboards in a space

• Right-click on the tab of any dashboard in the space, and select Close All.
20 Working with grids
Working with grids

The following image shows an example of a grid and its various features.
Click on different areas of the image for an explanation of each feature.
If there are more rows returned from the search than will fit in a single
dashboard window, use the scroll bar on the right to scroll down through all the
returned rows.
If grid data is still loading, a blue rotating circle is displayed in the top left of
the grid.
If the grid is in an error state, a red circle with a line through it is displayed in
the top right of the grid, and you cannot perform any actions on the data. You
need to close the grid and reopen it to continue to work with the data.
In situations where there are many tabbed dashboards in a single space, there
might not be enough room to display the upper business logic toolbar, and as
such, it is made available at the top-right of the space via the drop-down menu.
For example:
Keyboard navigation within grids

You can navigate within a grid using the keyboard. Such navigation does not
select a cell for processing, but does bring the focus to a cell, which is most
useful when navigating within an editable grid.
When you click on a cell within a grid, that cell is given focus, and is outlined in
grey. For example:
You can then use the arrow keys to move the focus up, down or across to the
next adjacent cell.
You can use the <Tab> key to move to focus to the next adjacent cell to the
right, and the <Shift + Tab> keys to move to focus to the next adjacent cell to the
left.
You can also use the <Enter> key to move to focus down to the next cell below,
and the <Shift + Enter> keys to move to focus up to the next cell above.
You can use the <Page Up> and <Page Down> keys to scroll through the grid,
however this does not move the focus.
In some cases, when you give focus to a cell, the heading on that cell’s column
will change. This means that the grid has been configured to use attribute names
such as the column headers, and so the column header will change each time that
you focus on an attribute with a different name to the current column header.
Selecting records
To work with a record that is displayed on a grid, you must first select the
record. You can select individual records, groups of records, a combination of
individual records and groups, or all records in a grid.
When you select one or more groups, the group selector is displayed in orange:
.
When you select individual records, the record selector is displayed in orange
with a blue tick: .
All of the selectors act as toggles, that is, clicking once selects, and clicking
again deselects.
To select records
• To select a single record, click , or right-click on the selector and select
Select.
• To select multiple records, click for each record you want to select, or
right-click on each selector and select Select.
• To deselect a single record, click for each record that you want to
deselect, or right-click on each selector and select Deselect.
• To select all the records in the grid, click , or right-click in the selector
pane and select Select All.
• To deselect all the records in the grid, click , or right-click in the selector
pane and select Deselect All.
If any records are already selected, clicking selects all remaining
records. Click again to deselect all.
• To select all groups on the grid, click , or right-click in the selector pane
and select Select All.
There might be two of these buttons in your grid; the one on the left is for
aggregate-on-change groups, and the one on the right is for break-on-change
groups. Clicking on either of these buttons will select or deselect all groups.
• To deselect all the groups in the grid, click , or right-click in the selector
pane and select Deselect All.
If any groups are already selected, clicking selects all remaining groups.
Click again to deselect all.
• To select a group of items, click . Typically, this icon spans more than
one row, for example:
There might be two lots of group selectors on your grid; the one on the left
is for aggregate-on-change groups, and the one on the right is for break-on-
change groups.
• To deselect a group, click for each group that you want to deselect, or
right-click on each group selector and select Deselect.
Performing actions on selected items

When the items that you want to work with have been selected, right-click in the
grid. The context menu for the selected items is displayed. For example:
The links contained in the context menu depend on the dashboard you are
viewing, however the following options are typically available:
• Change the view - if other views are configured for this grid, page 24.
• Links to launch any child dashboards - for example, the Item Detail
dashboard, page 15.
• Add an attachment – enables you to attach a document to an item, proof, set
or message feed, page 24.
• Edit – puts the grid into edit mode if an edit tool is configured for the grid,
page 90.
• Export the data - to a PDF or Excel document, page 35.
• Select rows and groups, page 21.
• Launch Audit Trail - for the last selected item, page 46.
• Activate business logic tools on the selected items, where available,
page 43.
If more than one item is selected, the same context menu is displayed. The action
that you select is performed on all the selected items, according to the following
rules:
• If you select a number of individual items, the business logic processes them
as one group.
• If you select a number of groups, the business logic still treats them as
separate groups.
• If you select a group and a number of selected items, the business logic
treats the group as a group and all the individual items as another group.
Changing the view

In TLM Reconciliations-Premium the format of the data is controlled by a view.
Views control the order of columns, which columns are displayed, and so on.
You can see which views are available for the grid by clicking on the view name
in the status bar, or by right-clicking on the grid and selecting Change View.
This launches a separate window listing the available views, for example:
Attaching a document
You can use the Add Attachments function to add documents to items, proofs,
sets and message feeds.
You might need to configure your browser’s security settings to enable the
document attach function to work, if your organisation permits you to do so.
To configure your browser security settings

1. In your browser, navigate to Tools > Internet Options.
2. Select the Security tab.
3. Select the Trusted Sites icon and click [Sites].
4. If the Require server verification checkbox is selected, clear this checkbox.
5. In the Add this website to the zone field, enter ‘http://’ followed by the IP
address of the Application server that the software is running on.
6. Click [Add] then [Close].
7. With the Trusted Sites icon still selected, click [Custom Level].
8. In the Downloads section, ensure that both the File download and
Automatic prompting for file downloads options are enabled, and click
[OK].
9. Click [OK].
To attach a document
1. Right-click on the relevant object in a grid and select Add Attachments.
The Add Attachment window is displayed.
2. Click the [Browse] button.

The Choose File to Upload window is displayed.
3. Navigate to and select the document that you want to attach, then click
[Open].
4. If required, enter a description of the document in the Note field.
5. Click the [Attach] button.
The document is attached to the selected object.
Grid aggregates
Grid views can have 'Aggregate on change' settings applied to one or more of the
displayed columns. These settings group items according to values in the column
you selected and insert a Totals Row. The Totals Row aggregates the numeric
data for the group according to the selected aggregate function.
For example, if the Reconciliation Status column has a sum aggregate on change
set, items with the same Reconciliation Status are displayed together in a group
with a Totals Row at the end of each group showing the sums of the amounts or
quantities that can be summed.
TLM WebConnect represents the aggregate functions with different icons. You
can display the aggregate functions that have been applied to a grid by right-
clicking on a column header and selecting Show Aggregate Criteria. A new row
with a pale blue background is displayed below the column header row, which
contains any aggregates applied to the columns.
For example, in the following dashboard, a count aggregate function has been
applied to Status, a sum aggregate function has been applied to Amount, and a
same aggregate function has been applied to Item Type:
The Aggregate On Change icon is displayed when you hover the mouse over
the column header and indicates that those columns will trigger the display of an
aggregates row whenever the value in that column changes. If required, you can
keep these icons displayed by right-clicking on the column header and selecting
Lock Symbols On.
Grid aggregate icons

The following table shows the icons for the different aggregate functions:
Icons Aggregate function
Count
Max
Absolute(Max)
Min
Absolute(Min)
Sum
Absolute(Sum)
Net
Absolute(Net)
Same
Average
Weighted Average
Weighted average
The weighted average function uses data from two columns to calculate data,
rather than just one column. The two values that are used for the calculation are
a weighted average and a weighting factor, for example Price and Quantity
respectively. The idea behind the function is to show the overall average Price
paid across the group of items for a single item. The weighted average is
calculated for those two columns as follows:
Imagine a grid that contains the following data:
Trade ID Quantity Price
1 10 10
1 15 10.5
1 20 11
The weighted average would be calculated as follows:

runningTotal = (10 x 10) + (15 x 10.5) + (20 x 11) = 477.50
runningQuantity = 10 + 15 + 20 = 45
weightedAvg = 477.50 / 45 = 10.61
In some cases you might see ' ' displayed in the aggregate row. This signifies
a divide by zero error.
Aggregates and null data

Nulls never participate in aggregations, (although zeros do). A weighted
average, for instance, does not include any rows that have a null in either the
value or weight column. In general, if there are no values, there is no value in the
aggregates row, unless it's a value count, which shows zero when nothing or no
values are selected.
Sorting Data
Each column on the grid displays a drop-down menu from which you can select
sort options for up to 9 columns. A small black arrow in the bottom right corner
of each column header indicates that there is a drop-down menu.
The priority that is set depends on what other sort options have been set for that
view. If this is the only column with sort options, the priority is 1. If there are
already, say, two other columns with sort options, the priority is 3.
Break-on-change or aggregate-on-change options are greyed out in the drop-
down menus, because users cannot specify them in TLM WebConnect.
However, if the View specifies break-on-change or aggregate-on-change options
they are highlighted in the drop-down menu and displayed in the column header
cell. The symbols for these settings are as follows:
Break-on-change
Aggregate-on-change
Note the following:
• If you change any sort options, all on-change settings defined by the view
are removed.
• If you change your view, you will lose your sort and filter settings.
For details on how to change the view, see page 24.
• If you have selected data using groups, you will lose your selection when
you update your sort and filter settings.
• The number of records that a dashboard can display is determined by your
system settings. When your search retrieves more records than the specified
number, the sorting and filtering mechanism cannot retrieve the missing
rows.
To sort data
1. Click on the header of the column you want to sort on to display the sort
menu:
2. To sort the column data in ascending order, select . To sort the data in
descending order, select .
If a column already has sort criteria, set by the user or by the selected View,
the sort is represented by the same symbols in the header cell, for example:
If a column has no sort order set, no symbol is displayed in the column

header cell. If you view the drop-down menu, the icon is selected.
To set the sort priority

1. Click on the header of the column that you want to change the sort priority
for.
The following menu is displayed:
When a sort is already specified for a column, the menu is expanded to

include priority options. In the above example, the menu shows that there
are 2 columns that have sort options set, and that this column has a priority
of 1.
2. To change the sort priority for the column, click the number you want.
If the priority order of a column is changed, the other sorted columns move
up or down the list to accommodate it. For example, if you change a
column’s sort priority from 3 to 1, the priority for the columns that are
currently priority 1 and 2 ‘move down the list’, and so become priority 2 and
3 respectively.
The priority order of sorted columns is reflected in the heading with the
numbers 1 to 9. In the following example, the primary sort is on the
Reference 1 column, and the next sort is on Value Date:
To remove sort options

• To remove the sort options from a single column, select from that
column’s drop-down menu.
• To return the sorting (and grouping) settings to those defined by the
current ‘View’ select Reset All from the drop-down menu of any
column.
• To remove all sorting and grouping settings, select Clear All from the
drop-down menu of any column.
Filtering data
You can dynamically set filtering options for any column on the grid, and for
columns that contain less than 20 distinct values, a drop-down menu is provided
from which you select a value to filter by.
By default the filter works on an exact match basis, so if for example you select
the Set ID column, and enter 123456 in the filter field, the grid displays the
records from the search where the Set ID is equal to 123456. Patterns are case-
sensitive.
Filtering values with decimal places

The number of decimal places at which numerical values are displayed on a grid
is configurable. For example, an amount attribute with a value of 10,000.25 in
the database might be displayed as 10,000 on a grid. As such, when filtering for
numerical values, the filter criteria is matched against a record’s value on the
grid, which does not necessarily contain the same amount of decimal places as
its true value in the database.
The filter also includes tolerances to compensate for decimal place rounding on
grid values. This is demonstrated in the next example, where the user is filtering
for the following two values, which are displayed to two decimal places on the
grid:
• Value 1: 2449628902.63
• Value 2: 2449628902.64
The table below details which of the above values will be returned when the user
enters various filter values:
Filter value Values returned
2449628902 None
2449628902.6 2449628902.63 and
2449628902.64
2449628902.63 2449628902.63
2449628902.635 2449628902.63 and
2449628902.64
2449628902.635 2449628902.64
0
2449628903 2449628902.63 and
2449628902.64
Filtering for signed values

Filtering for an explicitly-signed value only matches the same value with the
same sign; and an unspecified sign matches the same value but with either sign,
that is, the absolute value.
For example:
• +100 will match only +100
• -100 will match only -100
• 100 will match +100 or -100
You can use the following wild card characters:
• * (represents any number of characters, for example Re* returns
Reference1, Reed, and so on)
• ? (represents a single character, for example Ca?e returns Case, Cape, and so
on)
You can use the following range operators:
• < (is less than)
• > (is greater than)
• <= (is less than or equal to)
• >= (is greater than or equal to)
• <> (is not equal to)
• = (is equal to - this is not a required character, for example =500 and 500
both have the same effect)
Range operators cannot be combined with wild cards. The range operator can be
at the start or the end of the filter expression, with the exception of dates where it
must be at the start of the expression, otherwise it will be ignored.
If you use image decodes in your grid data, you can also filter by the images
used for those decodes.
For details on how to filter by images, see page 34.
To filter grid data

1. Right-click any header cell and select Show Filters.
A row of filter fields (with a white background) is displayed below the
header row.
If you also have the aggregate criteria row displayed, the filter row is
displayed below this.
2. Click on the cell in this row to activate the input field for the filter. For
example:
If the column contains less than 20 distinct values a drop-down menu is

displayed when you click in the cell, listing the values you can filter by. For
example:

• Enter the required filter pattern for the column in the filter input field
and press <Enter> to submit (or press <Esc> to abort).
You can also click anywhere outside of the filter field to submit the
filter criteria.
• Where available, select the required filter value from any listed in the
drop-down menu.
The grid data is filtered, and a filter icon is displayed when you hover
the mouse over the column header to show that a filter has been applied to
that column. For example:
A filter icon is also displayed in the status bar when a filter has been
applied to a grid.
To remove filter criteria

• To remove the filter criteria for a single column, delete the text in the
filter field for that column, or select [No Filter] from the drop-down
menu, where available.
• To remove filter criteria for all columns, right-click on any column or
filter field and select Clear Filters.
Filtering by images used for Image

Decodes
If you use image decodes in your grid data, you can also filter by the images
used for those decodes. A small black arrow in the bottom right corner of a filter
field indicates that a drop-down menu is available from which you can select an
image to filter by. If a description of the image has been specified (in
SmartStudio) this description is also displayed in the drop-down menu alongside
the image.
If a column contains a mixture of image decodes and other data types, you can
only filter by the images used for the image decodes.
To filter by image decode

1. Right-click any header cell and select Show Filters.
A row of filter fields is displayed below the header row.
2. Select the image you want to filter by.
3. The grid data is filtered, the image that you have filtered by is displayed in
filter field, and a filter symbol is displayed in the column header to show
that a filter has been applied to that column.
To remove the image filter criteria

• To remove the image filter criteria from a single column, from the
filtering drop-down menu, select No filter.
• To remove the filter criteria from all columns, right-click on any
column header or filter field and select Clear All Filters.
Exporting data
You can export all the data rows in a grid to a spreadsheet or a PDF.
You might have to change your browser’s security settings to enable data to be
exported, if your organisation permits you to do so.
For details on how to configure your internet security, see page 36.
To export data to a spreadsheet

1. Search for the items that you want to export.
The dashboard must return the data in a grid.
2. Right-click and select Export to Excel.
3. If asked whether to open or save the file, click [Open].
Excel is launched and contains the data from the current grid. From here you
can manipulate the data as required.
To export data to a PDF

1. Search for the items that you want to export.
The dashboard must return the data in a grid.
2. Right-click and select Export to PDF.
A new PDF is created and launched in a new browser, containing the data
from the grid. For example:
3. If required, you can save the PDF by clicking the Save button on the
toolbar.
Configuring your internet security

You might have to change your browser’s security settings to enable the Export
to Excel function to work, if your organisation permits you to do so.
To configure your internet security to enable external programs

to launch
1. In your browser, go to Tools > Internet Options.
2. Select the Security tab.
3. Select the Trusted Sites icon and click the [Sites] button.
4. If the Require server verification checkbox is selected, clear this checkbox
5. In the Add this website to the zone field, enter ‘http://’ followed by the IP
address of the application server that WebConnect is running on. If you
currently have WebConnect running, this field might already be populated
with the URL that you need to add.
6. Click [Add].
7. With the Trusted Sites icon still selected, click the [Custom Level] button.
8. In the Downloads section, ensure that Automatic prompting for file
downloads is selected, and click [OK].
9. Click [OK] again.
Working with treeviews

Treeviews are used to present a hierarchical view of the data. The following
sections describe how to interact and drill down from treeviews.
Changing how the treeview is displayed

If a treeview control is configured in SmartStudio to pivot, you can dynamically
change the grouping of data displayed in a treeview. You can check whether
pivoting has been configured for the tree by right-clicking anywhere in the tree
and if the context menu contains an option called Configure this feature is
enabled. For example:
If the context menu does not contain the Configure option, you cannot change
how the treeview is displayed, other than expanding and collapsing the nodes
using the + and - icons.
To change how the treeview is displayed

1. Right-click anywhere on the treeview and select Configure.
The following window is displayed.
The attributes displayed on this screen reflect the group bys configured in
SmartStudio. In this example, the tree has five visible group bys configured
in SmartStudio, with a default level of 3. Visible nodes are indicated by an
eye icon ( ). If you select only invisible nodes (that is, those without the
eye icon) the resulting tree will be blank.
2. To add another group by attribute to the view, select the attribute from the
left-hand list, and click .
38 Working with treeviews
3. To change the order in which the group by attributes are displayed, select an
attribute in the right-hand list and either drag and drop the attribute, or use
the and buttons to move the attribute up or down.
For example, if you configure the tree to display all 5 group bys in the
following order:
The tree is displayed as follows:
4. If you want to revert the tree back to how it was displayed when it was
initially loaded, click [Reset] on the Tree Configuration window.
Launching child dashboards from a

treeview
When you right-click on a leaf node of a treeview, if there are any child
dashboards configured for that treeview, they are listed on the context menu, for
example:
If you then select one of the child dashboards, the child is launched as a
drilldown from the currently highlighted treeview node.
If you already have an instance of the child dashboard open and you select the
same dashboard but for a different node, the existing instance of that dashboard
is replaced. If you press <Shift> before selecting the same dashboard, a new
child dashboard is opened.
If the treeview's children are configured in SmartStudio as being in sequence,
you can also use the Next in Sequence and Previous in Sequence options to
cycle through the sequence of available child dashboards. Selecting Next in
Sequence displays the next child dashboard in the sequence. When the last child
dashboard for that node in the tree has been displayed, the first dashboard for the
next node is displayed. Previous in Sequence performs the opposite function,
displaying the previous child dashboard in the sequence, working through
previous nodes in the tree.
If the treeview's children are not configured as being in sequence, selecting Next
in Sequence and Previous in Sequence simply highlights the next or previous
leaf node in the treeview.
If the treeview's children are configured in SmartStudio as being in sequence and
to allow navigation from child, you can also perform this navigation from the
child dashboard itself, using Next in Sequence on Parent and Previous in
Sequence on Parent.
These navigation options can also be performed using keyboard shortcuts,
see below.
40 Working with treeviews
Treeview navigation shortcuts

The following keyboard shortcuts are available from the number pad for
navigating treeviews in a parent/child relationship:
Shortcut Function
4 Previous in Sequence
6 Next in Sequence
1 Previous in Sequence on Parent. Cycles through each previous child
dashboard before moving up to the next leaf node.
3 Next in Sequence on Parent. Cycles through each child dashboard before
moving down to the next leaf node.
There are a few instances where the behaviour of these keyboard shortcuts
differ:
• If a treeview is launched that has no child treeview controls, keys 1 and 3
navigate its own drilldowns from node to node, in the same way as 4 and 6.
• If a child control launched from a treeview is in focus but is not a tree itself,
keys 4 and 6 navigate the parent tree drilldowns from node to node, in the
same way as 1 and 3.
• If a child control launched from a treeview is in focus, and the focus is on an
editable cell or field, or a record browser, the number pad keys are used for
number input. You must press the <Ctrl> key while using the 1, 3, 4, and 6
keys for keyboard navigation of the parent treeview.
Working with forms

For Form controls defined against the Item Universe, you can edit values in form
fields. The form fields that are editable are governed by:
• the form having the tool 'Edit Item' allocated to it
• your user Attribute Maintenance settings
Editable fields are displayed with a white background.
For datetime attributes, you cannot edit the time element. If the datetime
attribute is configured as editable, only the date element is displayed and can be
edited.
To edit a form field

1. Search for the item that you want to edit.
2. Enter or edit the text in an editable field.
3. Right-click and select Save Changes.
4. The data is checked, and if valid it is saved to the database. If the data is
invalid, an error is displayed and the data is not saved.
If you run any tools on the form after editing a form field, the changed data is
saved automatically before the tool is fired.
Using manual input forms

Some form controls are designed for inputting data. Input fields are labelled with
the attribute type that you should enter, and are blank with a white background.
To edit a form field

1. Open the form control that you want to use.
2. Enter or edit the required data.
3. Right-click and select Save Changes, or use the appropriate button if one
exists on the form.
The data is checked, and if valid it is saved to the database. If the data is invalid,
an error is displayed and the data is not saved.
42 Comparing data in dashboards
Comparing data in dashboards

If your dashboard has been configured to launch the Dynamic Compare Control,
you can select two or more rows on your dashboard to compare side by side on a
grid.
To compare two or more records on a dashboard

1. Launch the required dashboard and select two or more records on the grid
that you want to compare.
2. Right-click on the grid and select Dynamic Compare Control.
The Dynamic Compare Control child dashboard is launched and displays
the selected records side by side for you to compare. For example:
Notes on the displayed data:

• The following icons are used to indicate the state of each comparison test:
• - the values are the same
• - the values are not the same

• - the values were not compared
• The rows for which the comparison has failed are displayed in bold/italic.
• Totals are shown only for rows that contain amounts.
• The business logic tools are borrowed from the parent grid.
If you want to run a tool on the records, use the record selectors at the top of the
record columns and select the required tool. The selected records are submitted
for processing as a single group.
Working with Business Logic tools

Business logic tools enable you to carry out functions such as matching items
and raising exceptions.
On grid dashboards for which tools have been configured, you can specify items
that you want to process and then select the tool that you want to apply to them.
Tools are located on both the toolbar and the context menu, which is accessed by
right-clicking on the grid. For example:
For forms only, tools can also be fired using form buttons.
The availability of the tools depends on the item or exception status. Tools are
greyed out when they are not applicable to the selected items current status.
44 Working with Business Logic tools
Progress Window
Business logic is carried out a group at a time, and progress is displayed on a
Progress window. For example:
The status bar at the top of the window updates the following information during
processing:
The number of operations that have been completed so far.
The number of operations that are left to be processed.
The number of operations that have been completed

successfully.
The number of operations that contain warnings.
The number of operations that have failed.
The number of items that are in the group that is currently

being processed.
The lower part of the windows displays any error messages received, up to a
maximum of 10.
When processing has completed, two additional 'Show All' buttons are displayed
to allow you to see more results. For example:
If at any point you want to cancel the business logic processing for the current
group, click [Cancel].
If you activated the business logic on more than one group, the [Cancel Queued]
button is displayed. Click this button if you want to cancel the business logic
processing for groups still waiting to be processed.
When you click [Cancel] or [Cancel Queued], any groups that have already been
processed are unaffected, i.e. the processing is not rolled back. If you close the
window or the browser while the business logic is still processing items, the
behaviour is the same as if you had clicked [Cancel Queued].
Toolbar icons
The tools allow you to perform the following operations on items:
Button Description
Matches selected items
Creates a pending match for selected items
Recalls a match for the selected items
Remove an item from a pending match
Cancels a match
Deletes an item
Rejects a match
Removes an item from an exception

Splits an item
Reconciles (releases) selected items, writing them to History (in the

case of Cash or Securities items).
Adds the item to an existing exception
Takes ownership of an item
Unassign an owner from an item / reject a reconciliation request
Force balances an item

Creates a point in time proof
Resolves an exception
Cancels an exception
Closes a resolved exception
Reopens an exception
Approves a proof for a set
Authorises a reconciliation request
Undeletes a message
Loads a message to GEMS
Deletes a message
Authorises a message
Rejects a message
Used to delete a variety of items from the system such as inboxes

and products.
46 Using the Audit Trail
Using the Audit Trail

The system keeps a record of the events that have been fired. This record is
referred to as the Audit Trail. The audit trail is integrated into a number of
dashboards, including the item dashboards. You can also view a record of the
events that have been fired against a particular item using the Audit Trail viewer.
The Audit Trail viewer is available from context menus in various dashboards.
You can only view the audit trail of items that belong to a set.
You can optionally send the items associated with an audit trail entry to a target
dashboard configured with views, drilldowns, and tools, and use the dashboard
to process the associated items.
Viewing the audit trail

You can view the audit trail only of items that belong to a set.
To launch the audit trail

1. Launch a dashboard that brings back the item for which you want to view
the audit trail.
2. Select the required item.
3. Right-click and select Launch audit trail.
The audit trail for the item is displayed.
Click on any plus signs ( ) to expand that item.
Viewing notes from the audit trail

To view notes from the audit trail
• Click the line in the audit trail associated with the note:
The note text is displayed in a separate window.

Viewing the associated items from the

audit trail
The audit trail allows you to view the items associated with an entry, for
example, you can view other items associated with a match or a recall.
To view associated items from the audit trail

• Click the entry in the audit trail that you want to view the associated items
for.
The associated items are displayed in the lower part of the window, for
example:
In the Associated Items grid, you can sort and filter the data in the same way as
for any other grid.
For details on how to sort data, see page 28.
Working with the associated items from

the audit trail
You can optionally send the items associated with an audit trail entry to a target
dashboard configured with views, drilldowns, and tools, and use the dashboard
to process the associated items
To send the associated items from the audit trail to a dashboard

1. Open the dashboard that you want to send the associated audit trail items to.
2. Set this dashboard as the fast-cut target, by clicking the button on the
grid.
3. If the target dashboard is not an empty dashboard, move the pointer on the
insert bar to the required position.
4. Right-click the entry in the audit trail that you want to work with the
associated items for and select Show associated items in the target
dashboard.
The associated items are displayed in the target dashboard, and are ready to
be processed as required.
48 TLM WebConnect Error messages
TLM WebConnect Error messages

The error numbers that TLM WebConnect reports on the error dialogs are a
means to link a particular occurrence of an error with the corresponding entry in
the log file. The error number is reported in square brackets both on screen and
in the log file. For example the following error:
is shown in the log as:

2006-09-20 14:23:27,399 ERROR [actions.BaseAction] Throwable in
BaseAction (wrapped in an ActionException) [1000]
...
The error numbers start at 1000 when the application server starts and increment
by 1 for every error.
Managing Reconciliations
TLM Reconciliations-Premium is an automated, real-time reconciliations

management system that enables you to manage both cash and securities
reconciliations from a single web browser.
The software performs set-level reconciliations, comparing periodic statements
of cash movements and securities positions from your own general ledger,
against the equivalent data from your account servicer.
As part of the data comparison process, the system performs the following
monitoring and validation steps:
• Tracks the flow of balances from one day to the next. Any discrepancies
identified are quantified as missing balances.
• Uses the statement date and value date to understand the flow of the
balances and to fill in any missing balances that are unreported for particular
dates.
• Constructs the flow of balance with time, using the individual cash
movements transacted between the opening and closing balances, obtained
from both the account servicer and general ledger.
• Validates the flow of balance with time, and identifies any missing
transactions.
• Matches individual transactions between your general ledger and the
account servicer statement to ensure that the transaction data corresponds
between parties.
• Reconciliations lifecycle, see below
• About the Reconciliations dashboards, page 52
• About Matching, page 58
• Performing Manual Matching, page 63
• Approving items and matches, page 75
• Searching for items and matches, page 77
• Other matching tasks, page 82
• Working with Proofs, page 94
• Authorising and Rejecting Reconciliations, page 106
• Generating Reports, page 110
50 Reconciliations lifecycle
Reconciliations lifecycle
Each set is processed according to the following reconciliation lifecycle:
Managing Reconciliations 51
The lifecycle begins when a new session is triggered by a scheduled process or

the loading of a data file.
Items are assigned one of the following statuses, depending on their position in
the lifecycle:
• Outstanding – the item is not yet processed, or is on a suggested match.
• Pending – the item is on a pending relationship, and is awaiting an action.
• Pending authorization – the item is on a pending relationship, which is
pending authorization.
• History – the item is matched and has a complete relationship.
• Rejected – the item was on a pending relationship that was rejected during
authorization.
• Deleted – the item is deleted.
A reconciliations lifecycle is only classified as complete when all items for the
set match, and there are no missing balances.
The categories of reconciliations dashboards available for monitoring and
controlling the flow of balances throughout the set lifecycle are described in the
following sections. Instructions for undertaking a range of common
reconciliations tasks, such as viewing match details and performing manual
matching, are also provided.
52 About the Reconciliations dashboards
About the Reconciliations dashboards

The main Reconciliations function is accessed via the Lifecycles entry on the
menu, which launches the REC Lifecycles Summary Details dashboard – the
starting point for all reconciliations management tasks, page 52.
This dashboard displays a treeview representation of a set’s status, from which
you can drill down to the following two categories of dashboard:
• Summary dashboards – provide graphical and treeview summaries of items
in a set, at the level at which the dashboard was accessed in the REC
Lifecycles tree. For details on Summary dashboards, see page 55.
• Detail dashboards – display a grid containing data items returned by a
search or from drilling down from another dashboard, which you can
process using tools. You can select any individual item, match or exception
in a grid and drill down to view its details in another child dashboard.. For
details on Summary dashboards, see page 56.
REC Lifecycles Summary dashboard

The REC Lifecycles Summary dashboard is the starting point for all
reconciliations management tasks. This dashboard groups items in a hierarchical
treeview, which displays nodes categorised by reconciliation type, category
code, lifecycle status, proof status and set ID. For example:
You can view and process items at any level in the tree using the full range of
dashboards available to you, by right-clicking the required level and selecting
the dashboard that you want to launch from the context menu. For example, to
view a summary of all Nostro items with the MUMBAI category code and a
lifecycle status of Manual Matching, expand MUMBAI, right-click on Manual
Matching and select Item Status Summary from the context menu. For
example:
The Item Status Summary dashboard is launched, and displays a graphical

overview of the status of the items at the selected level.
To Launch the REC Lifecycles dashboard

1. Select the Lifecycles entry on the menu.
The REC Lifecycles search prompt is displayed, and by default, is
configured to return all sets at all lifecycle statuses with the exception of
those that are inactive or reconciled. For example:
2. If required, add to or edit the search criteria to further specify the items that
you want to display on the REC Lifecycles Summary dashboard.
For example, if you only want to view a set’s manual matching items,
ensure that this is the only checkbox selected in the Lifecycle Status area of
the search prompt.
3. Click [Search].
The results returned from your search are displayed in the REC Lifecycles
dashboard.
Summary dashboards
You can drill down to a range of summary dashboards from any level in the REC
Lifecycles Summary dashboard to view a graphical overview of the items at that
level. For details on REX Lifecycles Summary dashboard, see page 52.
For example, to view a summary of the items by status, type and a lifecycle
status of Manual Matching for a specific category, in the REC Lifecycles
Summary dashboard, expand the required category, right-click on the Manual
Matching node, and select Item Status Summary from the context menu.
The Items By Status and Type as well as the Matches by Status dashboards are
launched. For example:
You can view the Items by Type dashboard by selecting that tab. You can also
drill down to the details of the items displayed on the summary dashboards by
right-clicking on a bar or treeview node, and selecting the required dashboard
from the context menu. For example:
The following summary dashboards available, from which you can drill down to
view items in greater detail, as described in the following table:
Summary Displays Drills down to…
Dashboard
Items Status Charts providing an overview of Item by Type, Items by Status, Item
Summary items based on type and status, and Matches
a treeview categorised by match
types.
Items Items based on their age, grouped Items Ageing by Current Priority,
Ageing by priority, days past reference Items Ageing by Days Past
Summary date, and business entity and Reference Date, and Items Ageing
reason/resolution. by Business Entity and Reason
Resolution.
Items A summary of the exceptions raised Items by Exception Status, Item
Exception on items. Exceptions by Priority, Exceptions
Summary by Priority, Exceptions by Inbox,
Item Exceptions by Inbox.
Items Matches that require authorization. Items Requiring Authority and
Authority Matches Requiring Authority.
Summary
Detail dashboards
You can drill down from any level in the REC Lifecycles Summary dashboard
to a range of child dashboards that display a grid containing the items at the
selected level. For example:
For details on REX Lifecycles Summary dashboard, see page 52.

You can apply tools to items in grid dashboards and in some cases, drill down
further to view in-depth information about an item. For details on Working with
Business Logic tools, see page 43.
The detail dashboards listed in the table below can be launched from the context
menu in the REC Lifecycles Summary dashboard, to display a particular view of
the items at that level.
Dashboard Displays
Set Lifecycles A record of the most recent event for the item and its current
lifecycle status.
Realtime The current cash balancing results for the selected set.
Currency Proofs
Realtime Asset The current asset proof results for the selected set.
Proofs
Realtime Total The current Total Equity proof results for the selected set.
Equity Proofs
Realtime Net The current Net Asset Value proof results for the selected set.
Asset Value
Proofs
Point in time The cash balancing results for the selected set produced at a
Currency Proofs specified date and time. These might have been created
automatically after matching completed, or manually.
Point in time The asset proof results for the selected set produced at a
Asset Proofs specified date and time. These might have been created
automatically after matching completed, or manually.
Point in time The Total Equity proof results for the selected set produced at a
Total Equity specified date and time. These might have been created
Proofs automatically after matching completed, or manually.
Point in time The Net Asset Value proof results for the selected set produced
Net Asset Value at a specified date and time. These might have been created
Proofs automatically after matching completed, or manually.
Asset Position A list of any items that have a Position Break exception. This
Breaks exception is generated when there is a mismatch between
securities positions held by your account servicer and the
securities positions from your General Ledger or Portfolio
Management Systems.
Matches by The history of all matches according to creation type. The match
Creation Type history information that is displayed is determined by the search
criteria provided on the Matches by Creation Type search
window.
Dashboard Displays
Ad-Hoc Displays matches based on the search criteria provided in the
Matches Search Ad-Hoc Matches Search window.
Ad-Hoc Items Displays items based on the search criteria provided in the Ad-
Search Hoc Items Search window.
Ad-Hoc Item Displays items attached to exceptions based on the search

Exceptions criteria provided in the Ad-Hoc Item Exceptions Search
Search window.
Ad-Hoc Displays exceptions based on the search criteria provided in the
Exceptions Ad-Hoc Exceptions Search window.
Search
To drill down to a detail dashboard

1. In the REC Lifecycles Summary dashboard, right-click the level that you
want to drill down from in the treeview, and select the required dashboard in
the context menu.
For all dashboards except the Set Lifecycles dashboard, a search prompt is
displayed. For example:
2. Add or edit the search criteria as required and click [Search].

The dashboard is launched in the bottom of the window and displays a grid
containing any items at the level selected in the REC Lifecycles Summary
dashboard that were returned by the search. For example:
58 About Matching
About Matching
The matching process identifies and groups corresponding transactions between
your general ledger and account servicer statement, to ensure that the
transactions balance and your sets are reconciled.
The following sections describe the different types of matching as well as the
process of set balancing using write-off and net items, and how the opportunity
cost on cash items is calculated.
Types of matching
Matching in TLM Reconciliations-Premium is typically carried out both
automatically and manually. When data is first loaded into the system, perfect
matches are automatically identified and reconciled. The system also produces
suggested matches and progresses them, along with the remaining outstanding
items, to the Manual Matching stage.
Automatic matching
Automatic matching is triggered on completion of a data load, and is performed
by the Matching Service.
The Matching Service processes the items, relationships and exceptions.
Items that are perfect matches, as in the example below, are matched and moved
to history.
Item Type Amount Currency
Our Credit 100 GBP
Their Debit 100 GBP
Amount Difference 0 GBP
Items that are near matches, for example statement and ledger amounts for the
same set but with small differences, are grouped into a suggested match
relationship. For example:
Our Credit 100 GBP
Their Debit 110 GBP
When the auto-matching for a set is complete, the lifecycle status of the set
changes to Progressed and the remaining outstanding items and suggested
matches are displayed on the Reconciliations dashboards.
Manual Matching
After auto-matching is complete, manual matching can be performed on the
outstanding items and suggested matches that remain in the set.
Groups of outstanding items can be formed manually, and are progressed by
either matching or raising exceptions. Throughout this process, set balancing is
achieved through the creation of write-off and net items. For details on Set
balancing, see page 59.
Depending on the quality of the group and the user or account write-off limits,
the match might require authorization by a supervisor.
Set balancing
A set is in balance when all items form a perfect match and there are no missing
balances. However, the information required to form perfect matches might not
be available at the time the user is reconciling the data. As such, and to allow
matching in real-time, write-off items can be created to enable the user to
perform matches, and net items can be created to enable the user to perform
pending matches on unbalanced groups of items.
The ability to create write-offs is constrained by the user and account write-off
limits, as described in Authorising Matching, page 61.
Write-offs
When you match a group of items with an amount difference, a write-off item is
generated that has an amount equal to the amount difference. It is created to
ensure that the set balances, and is always an ‘our side’ ledger value.
For example, the items in the match below will generate an ‘Our Credit’ write-
off item of 10 GBP, enabling the items in the match to be moved to history:
Our Credit 110 GBP
Their Debit 100 GBP
Write-off items are assigned a status of Outstanding, and can therefore be

matched with other items in the normal way. So, for example, if the missing
Their Debit of 10 GBP is loaded later, it is matched with the Our Credit writeoff
of 10GBP, and both those items are moved to history.
60 About Matching
Net Items
Net items are similar to write-offs, in that they are created to facilitate the
matching of items with amount differences, and are always ‘Our Side’ ledger
values. However, net items are only created for pending and pending
authorization matches, and are deleted and replaced by a write-off when the
items in the pending group are matched. If the items in the pending group are
cancelled or deleted, the net item is deleted.
For example, the group of items in the pending match illustrated below will
generate an ‘Our Credit’ net item of 30 GBP:
Our Credit 110 GBP
Their Debit 100 GBP
Our Credit 20 GBP
A net item is automatically adjusted when items are added or removed from a
pending match, so that it always represents the amount difference of the items in
the group. For example, if the 20 GBP ‘Our Credit’ item was removed from the
pending match above, or a Their Credit item of 20 GBP was added to the group,
the value of the net item would change to 10 GBP.
Net items are created with the data values in the match, such as the settlement or
value date and references. Further items forwarded for reconciliation can then be
matched against the net item. This can be used to prevent charges being raised
on a set for outstanding items, when it is known that the items will be received
eventually.
If a match is found against a net item, the item is added to a pending match
group and the normal matching workflow is invoked.
Authorising Matching
During the manual matching process, the user’s ability to create matches is
constrained by the user and account write-off limits, both of which are set by the
Administrator.
If you attempt to perform a match with an amount difference within the user and
set limits, a write-off item is created and the match is sent to History. However,
if the match exceeds these limits, it is rejected. Depending on your configuration,
you might then be prompted to create a pending authorization match, whereby a
net item with the value of the amount difference is created, and the status of the
match changes to pending authorization.
Matches with a status of Pending Authorisation must be approved or rejected by
a second user, as described in Approving Matches. If the match has any
associated net items, the process of authorising the match will delete the net
items and create a write-off item to balance the set. For details on Approving
items and matches, see page 75.
If a match is rejected, the Relationship header and the items are left in an overall
status of Pending and the authorization status of both is changed to
Authorisation Rejected.
For further information about setting account write-off limits, refer to the
Administration Guide. For information about setting user write-off limits, refer
to the User Administration Guide.
Opportunity Cost for value date

differences
The opportunity cost is calculated for cash items when a match is created but a
value date differs. The amount is calculated using the Interest rates applied to the
set. The software calculates the amount of the opportunity cost, which can be
used in an interest claim according to the number of day’s difference between
the value dates.
The opportunity cost only applies to cash and currency matches.

62 About Matching
Three-way Matching
You can optionally configure sets to be reconciled on a three-way basis. As well
as the usual Ledger and Statement side, and additional Alternate side can be
loaded, and all three sides must be present for that set to be matched. If three-
way matching is enabled on a set, the calculation of Net rules takes into account
all three sides, and calculates the net figure as the largest difference between any
two of the three sides.
For three-way matches, together with the Ledger (L) and Statement (S), the
dashboard also displays the Alternate (S) side. For example:
Performing Manual Matching

During the manual matching process, you must use the dashboards and tools
provided to reconcile outstanding items and suggested matches. The tasks
involved at this stage include:
Manually matching suggested matches

You must review the Suggested matches and decide whether you want to move
them to History, or cancel the match so that you can either wait for new items to
be received, or create a different group in which to match the items.
Creating pending matches

You can create pending matches when you have found items that should be
matched, but you are not yet ready to perform the match. This is useful when, for
example, you are waiting for additional items to be loaded.
Approving pending authorization matches

Depending on your user privileges, you might be required to approve matches
with the status of Pending Authorisation. Matches with this status are created
when a user attempts to create a match that exceeds either their user or the set
limit, and must be either verified or cancelled by a second user.
Managing Items
You can also perform other operations on items, such as splitting items between
suggested matches, marking items as deleted and adding items to exceptions.
64 Performing Manual Matching
Matching Items
You use the Match tool to manually match items. You would typically match
items with a status of Outstanding or Pending. You can however, also match
items with a status of Suggested, Cancelled or Recalled.
Depending on the set and user limits, the match might require authorization
before it is completed. For example, if a match is created with a value difference,
a write-off item is created to balance the set. However, if the amount difference
is too high to be written off by the user, a pending net item is created and the
match status changes to pending authorization.
While sets can be set up to accept multiple currencies, you cannot match
multiple currencies in the same match. If a cross-currency match is attempted a
warning is displayed and the match cannot be completed.
When you manually match an item, the overall status changes to Matched.
To perform a match
1. On a grid dashboard such as Items by Status or Item Matches, select the
items that you want to match.
• Click the row selector for each item in the match, and then click the
Match button , or right-click and select Match.
• If the grid displays only the items for a single match, you can match all
items. Click the Select All button and then click the Match button
, or right-click and select Match.
The Progress window displays the status of the action. For additional
information on the results, click [Show All Results].
3. Click [OK] to continue.
The manual match is created for the selected items.
Cancelling a match
You use the Cancel tool to cancel a match. When you cancel a match, the
status changes to cancelled.
When you cancel a pending match, the associated net item’s status changes to
deleted.
To cancel a match
1. Select the match that you want to cancel.
• To cancel a single match, click the row selector to select the required
item and then click the Cancel button , or right-click and select
Cancel.
• To cancel multiple matches, click the row selector for each item that
you want to cancel and then click the Cancel button , or right-click
and select Cancel.
• To remove all matches displayed on the grid, click the Select All button
and click the Cancel button , or right-click and select Cancel.
The selected match is cancelled.
Working with Pending Matches

Pending matches are created to group items together without completing the
match. This is useful in situations where you cannot complete a match until you
have further information on the items it contains, or until you have received
additional items for the match group.
You can use the tools provided to create pending relationships, as well as to add
and remove items from existing pending matches.
Each item can only be part of one pending match at any one time.
Creating a pending match

The Pending tool enables you to create a pending match for items. You can
create a pending match for items with a status of Outstanding and for items with
a match status of Suggested, Pending, Cancelled or Recalled.
If you perform a pending match with an amount difference that exceeds the set
or user limit, a pending net item is created. When the pending relationship is
matched using the Match tool and converted from Pending to History, the
amount is written off and the pending net item is deleted.
There is a configuration option available that prevents users from creating

pending matches when the amount difference exceeds their user limit. If this
option has been set, you can only creating pending matches with differences that
fall within your user limits.
To create a pending match

1. In a grid dashboard such as Items by Status or Item Matches, select the
items that you want to include in the pending match.
• Click the row selector for each item that you want to add to the
pending match, and then click the Pending match button , or right-
click and select Pending.
• If the grid displays only the items for a single match you can add all
items to the pending match. Click the Select All button , and then
click the Pending match button , or right-click and select Pending.
The pending match is created for the selected items.
Adding items to a pending match

You can add items with a status of Suggested, Pending, Cancelled or Recalled to
a pending relationship.
To add items to an existing pending match group

• Run a search that returns outstanding items. The results should include
any net items raised for a pending match.
• Launch the pending items in one dashboard, and the outstanding items
in another, and then fast-cut the outstanding items that you want to add
to the pending groups to the pending items dashboard. For details on
Putting together items from different dashboards, see page 84.
2. Click the row selectors for the item you want to add to the group, and for
one of the items already in the pending match group, which can be the net
item, and then click the Pending match button , or right-click and select
Pending.
The item is added to the group, and the existing net item is updated to reflect
the new amount difference.
Removing an item from a pending match

You use the Remove from Pending tool to remove items from a pending
Relationship. When an item is removed from a pending Relationship, the overall
status change is set to Outstanding and the Pending net item is recalculated.
To remove an item from a pending match

• To remove a single item, click the row selector to select the required
item and then click the Remove from Pending button , or right-click
and select Remove from Pending.
• To remove multiple items, click the row selector for each item that
you want to remove and then click the Remove from Pending button
, or right-click and select Remove from Pending.
• To remove all displayed items from the match, click the Select All
button and then click the Remove from Pending button , or right-
click and select Remove from Pending.
The item is removed from the pending match, and the pending net item is
recalculated.
Cancelling a pending match

You cancel a pending match using the Cancel button . This changes the status
of the items in the pending match from Pending to Outstanding, and the
associated net item is deleted.
When cancelling a pending match, you need only to search for and select one
item from the pending match. By cancelling one item, all the items in the
pending match are cancelled. However, you need to refresh the grid to see the
status change.
To cancel a pending match

1. Select any item in the pending match group that you want to cancel.
• To cancel a single pending match, click the row selector to select one
of the items in the match and then click the Cancel button , or right-
click and select Cancel.
• To cancel multiple pending matches, click the row selector for an
item from each pending match that you want to recall and then click the
Cancel button , or right-click and select Cancel.
• To cancel all of the pending matches displayed on the grid, click the
Select All button , and then click the Cancel button , or right-click
and select Cancel.
The pending match is cancelled.
Recalling items
You use the Recall tool to recall items in a perfect match from History.
In the case of cash or securities items, this involves reversing the process of
reconciliation and returning groups of items from the status of History to
Outstanding. This might be due to matching the items in error, or because
another item arrived afterwards that needs to be included in the match.
When recalling items, you need only to search for and select one item from a
match. By recalling one item, all items in the match are recalled. However, you
need to refresh the grid to see the status change.
When recalling a match that created a write-off item, a contra write-off is

generated that is equal to the opposite of the original write-off. For example,
recalling the match below would produce an ‘our debit’ contra write-off of 10
GBP:
Item Type Amount Currency Item Status
Our Credit 110 GBP History
Their Debit 100 GBP History
Write-off 10 credit GBP Outstanding
Contra write-offs are generated with a status of Outstanding so that they can be
matched with other items, enabling the set to balance.
You cannot recall an item if:
• Its reconciliation status is Outstanding (and it is not a Netting item).
• Its reconciliation status is Deleted.
• It is part of more than one historic match.
• It is a netting item on an active case.
To recall a match
1. Perform a search that returns the matched items that you want to recall.
2. Select an item in the match group that you want to recall.
• To recall a single match, click the row selector to select one of the
items in the match and then click the Recall button , or right-click
and select Recall.
• To recall multiple matches, click the row selector for an item from
each match that you want to recall and then click the Recall button ,
or right-click and select Recall.
• If the grid displays only the items for a single match you can recall all
items on the grid. Click the Select All button , and then click the
Recall button , or right-click and select Recall.
All items in the group containing the selected item are recalled.
Splitting items
Splitting an item into smaller component items often helps the match rate, as
large value items might not match because of a tolerance limit, whereas lower
value items might fall within those limits.
In order to split an Outstanding item, Advisory items must be manually or
automatically loaded into the system, or you can create advisory items to be used
for split processing using the Item Create Split function.
Creating Advisory items for splitting

You can split an Outstanding item into a number of Advisory items, which can
then be used for split processing. The procedure is slightly different depending
on whether you are working with cash or a securities.
To create Advisory Cash items for split processing

1. Display the outstanding cash item in one of the grids that can be used for
matching, for example the Items by Status dashboard.
2. Click the selector by the item that you want to work with, then right-
click and select Item Create Split.
The following dashboard is displayed:
3. In the first row, select the item side (Debit or Credit).

4. Enter the amount for the first item that you want to create.
5. Optionally add a note.
6. Complete additional rows for each Advisory item that you want to create
from this Outstanding item.
The summary at the bottom shows you the difference between the
Outstanding item’s amount and the total amount of the Advisory items that
will be created from it. The difference must be 0 to be able to save the items.
For example:
7. When you have created all of the required Advisory items, and the
difference is 0, click [Save].
The Advisory items are created and are available for split processing.
To create Advisory Securities items for split processing

1. Display the outstanding securities item in one of the grids that can be used
for matching, for example the Items by Status dashboard.
2. Click the selector by the item that you want to work with, then right-
click and select Item Create Split.
The following dashboard is displayed:
3. In the first row, select the item side (Delivery or Receipt).

4. Enter the quantity for the first item that you want to create.
The amount and price are calculated after the quantity is entered, and these
fields are then automatically populated.
5. Optionally add a note.
6. Complete additional rows for each Advisory item that you want to create
from this Outstanding item.
The summary at the bottom shows you the difference between the
Outstanding item’s quantity and the total quantity of the Advisory items that
will be created from it. The difference must be 0 to be able to save the items.
For example:
7. When you have created all of the required Advisory items, and the
difference is 0, click [Save].
The Advisory items are created and are available for split processing.
Splitting Outstanding items

To split items the Advisory items and the Outstanding item must be displayed
together in the same dashboard.
When an Outstanding item is split, the Outstanding item will be replaced on the
set with the selected Advisory items, provided that at the point of matching, the
total of the Advisory items is exactly the same as the value of the Outstanding
item. The Advisory items then become Outstanding and are available for
matching, and the Outstanding item is deleted.
To split items
1. Perform a search that returns the outstanding and advisory items that you
want to split.
If the items are already displayed but on two different dashboards, you can
use the fast-cut function to put them together on a dashboard. For details on
Putting together items from different dashboards, see page 84.
2. Select the Outstanding item and any number of Advisory items that total the
same amount.
3. Click the Split button or right-click and select Split.
The original Outstanding item is marked as deleted and the Advisory items
become Outstanding. They are then available for matching.
Deleting an item
You can use the Delete tool to delete an item. This marks the item as deleted,
and is typically during testing of the system. However, this process does not
physically delete the items, so you can restore an item deleted in error, and mark
it as outstanding.
You cannot delete net items, items flagged with a status of history, or items with
outstanding cases.
You can delete items with status not reconciled or pending reconciliation and
match status suggested or recalled.
To delete an item
1. Select the item that you want to delete.
• To delete a single item, click the row selector to select the required
item and click the Delete button , or right-click and select Delete.
• To delete multiple items, click the row selector to select the required
items and click the Delete button , or right-click and select Delete.
• To delete all items displayed on the grid, click the Select All button
and click the Delete button , or right-click and select Delete.
The selected items are flagged as Deleted.
Undeleting an item
If you delete an item in error, you can restore it using the Undelete tool.
You can undelete only items that were manually deleted; items that are deleted
as part of the Pending processing cannot be undeleted.
To undelete an item
1. Right-click on a node in the Lifecycles Summary, and select Ad Hoc Items
search.
2. Click the [Clear] button to remove any existing values in the search fields,
and then select Item Status: Deleted.
3. Add any additional search criteria to help you find the item.
4. Click [Search].
A list of the deleted items is displayed.
5. Select the item that you deleted in error.
6. Click the Undelete button , or right-click and select Undelete.

The selected item is restored, and set to Outstanding.
Viewing match details

You can view the details of a match in the Match Detail dashboard, which you
can drill down to from the context menus in a number of dashboards, including
the Ad-hoc Matches Search dashboard. When the Match Detail dashboard is
displayed, the associated child dashboard Item Match Details is also displayed.
For details on Searching for items, see page 80.
The Match Details dashboard displays the following information:
• Match Details – displays information about the match including the match
type, priority and authorization status.
• Currency Interest Claims – displays the opportunity cost and value date for
cash and currency matches.
• Match Audit – displays all the operations performed on the match, when
they were performed, and the users responsible.
• Item Match Details – displays details of the items in the match.
To drill down to the Match Detail dashboard

• Locate the match that you want to view in one of the grids that displays
matches, right-click on the match and select Match Detail from the context
menu.
Information about the selected match is displayed in the Match Detail
dashboard.
Match details
This dashboard displays the following match details:
Field Description
Account The identifier to which the item belongs. For example, a
General Ledger account or a Securities Portfolio ID. It is
the local set number recognised by the reconciliations
department.
Category The name of the Relationship Category.
Relationship Type The name for the type of Relationship between the match.
Overall Status The overall status of the match, which can be any of the
following:
• Cancelled - The match has been cancelled.
• Pending - Matching has been initiated but not
complete.
• Suggested - The match has been suggested by the
system.
• Matched - The match is complete.
• Recalled - The match has been recalled.
Creation Type The match creation type.
Authorisation Status Whether the match requires authorization.
Priority The priority of the match, which can be 0, 1 or 2.
The lower the number, the higher is the priority.
Principal Amount The amount of the item.
Principal Date The date on which the entry was made or trade occurred.
Relationship Category The name of the Relationship Category.
Last Action The last action performed on the match.
Last Action Date The date and time when the last action was performed on
the item.
Last Action User The user who performed the last action.
Relationship ID The Relationship ID.
Item Link Count The count of the item link.
Approving items and matches

You can view matches that need authorization, for the selected set from the
Items Authority Summary dashboard.
The Items Authority Summary dashboard is divided into two treeviews: Items
Authorisations and Match Authorisation. The Items Authorisation treeview
displays the number of items pending authorization and Matches Authorisation
displays the number of matches that are pending authorization, for example, in
the figure displayed below, the Match Authorisations treeview has one deleted
match that requires authorization.
When reviewing a match created by another user that has an authorization status
of Requires Authorisation, you can either reject the match, or authorise the
match using the standard Match workflow.
If a match is rejected, the Relationship header and the items are left in an overall
status of Pending, and the authorization status of both is changed to
Authorisation Rejected.
Authorising or rejecting items

The Item Authorisations treeview displays the items that need authorization. You
can view the item details.
To view items that require authorization

1. Launch the REC Lifecycles Summary treeview.
2. Right-click a set in the REC Lifecycles Summary treeview.
3. Select Items Authority Summary.
The Item Authorisations and Match Authorisations treeview is displayed.
For example:
4. From the Item Authorisations treeview, do any of the following:

• Open the required node, right-click the node and select Items
Requiring Authority.
• Double-click a node.
The Items Requiring Authority grid is displayed and shows the details of the
items that need authorization.
76 Approving items and matches
Authorising or rejecting matches

The Match Authority Summary treeview displays the matches that need
authorization. You can view the match details and then Match or Reject a
selected match.
To view matches that require authorization

3. Select Items Authority Summary.
The Item Authority Summary and Match Authority Summary treeviews
are displayed. For example:
4. From the Match Authority Summary, do any of the following:

• Open the required node, right-click and select Matches Requiring
Authority.
• Double-click a node.
The Matches Requiring Authority grid is displayed and shows the details
of the matches that need authorization. For example:
5. To authorise a match, select the applicable match items, then right-click and
select Match.
Any pending net items associated with the match are deleted, and, where
required, a write-off item is created to balance the set.
6. To reject a match, select the applicable match items, then right-click and
select Reject.
Searching for items and matches

You can use the following searches to search for specific matches or items:
• Matches, page 78
• Items, page 80
From each of the dashboards displaying the search results you can use the
available tools to perform many of the typical functions for items of that type.
For details on available tools, see page 43.
You can also access some or all of the following child dashboards:
• Scratch Pad - To fast cut items to work with later, page 84.
• Item Detail - To view the details of the item, page 83.
• Match Detail - To provide the details of the match, page 73.
• Dynamic Compare - To compare the selected items, page 42.
• Exception Creation - To create an exception, page 85.
• Add Note - To create a new note and attach it to the selected item, page 87.
• Item Notes - To view the notes created for an item, page 88.
• Exception Detail - To view the details of the exceptions associated with an
item, page 130. This option is displayed only if the selected item has an
exception.
• Exceptions - To view the list of exceptions, page 85. This option is
displayed only if the selected item has more than one exception.
• Item Link - To link items by storing an unknown code as an alias for a
known code, page 88.
• Item Unlink - To remove the linking prefomed by using Item Link, page 89.
• Item Bulk Edit - To edit more than one items at a time, page 92.
• Launch Audit Trail - To view all the transactions performed on the item for
audit, page 46.
78 Searching for items and matches
Searching for matches

You can search for matches using the Ad-Hoc Matches Search option.
Using this option you can find a particular match of a cash transaction or set
security position. You can also find all the matches for a single set, group of sets
or sets held by a particular Custodian.
Ensure that sufficient details are provided into the search window to restrict your
search results. You can also retrieve all the data that has been processed, which
can take a long time if there are many years of data in the database.
To search for matches

3. Select Ad-Hoc Matches Search.
The search window is displayed.
4. Enter the required search parameters. If you want to view data for all the
options of a particular field, keep that field blank, for example, to view
matches with all the lifecycle statuses, do not select any checkbox in the
Lifecycle Status field.
If you want to view all records, do not specify any search parameters.
5. Click [Search].
Searching for all records without specifying any criteria might take a longer
time to return the records, if there are many item rows.
If the search is successful, the resulting matches are displayed in the Ad-Hoc
Matches Search grid.
6. Use the dashboard’s tools to perform the required functions. For details
see page 45.
80 Searching for items and matches
Searching for items

You can search for a particular cash transaction or set security position using the
Ad-Hoc Items Search option.
The Ad Hoc search opens a window into which you can enter as many
parameters as you need to find the item or transaction.
To search for items

3. Select Ad-Hoc Items Search.
The search window is displayed. For example:
items with all the lifecycle statuses, do not select any checkbox in the
5. Click [Search].
If the search is successful, the resulting items are displayed in the Ad-Hoc
Items Search grid.
6. Use the dashboard’s tools to perform the required functions. For details
see page 45.
82 Other matching tasks
Other matching tasks

There are a number of other common tasks that you might want to perform as
part of the manual matching process. Most of these tasks are carried out using a
child dashboard that can be accessed from the detail dashboards, and a few are
done using a tool. This section describes the following matching tasks:
• Viewing the details of an item using the Item Details dashboard, page 83.
• Putting together items from different dashboards using Fast-cut, page 84.
• Viewing the exceptions associated with an item using the Exceptions
dashboard, page 85.
• Viewing the details of an exception using the Exception Details dashboard,
page 130.
• Viewing the details of a match using the Match Details dashboard, page 73.
• Creating an exception using the Exception Creation dashboard, page 85.
• Adding a new note to an item using the Add Note dashboard, page 87
• Viewing the notes created for an item using the Item Notes dashboard,
page 88.
• Linking items by storing an unknown code as an alias for a known code
using the Link tool, page 88.
• Removing item links using the Unlink tool, page 89.
• Editing multiple items at a time using the Item Bulk Edit dashboard,
page 92.
• Take ownership of an item using the Take Ownership tool, page 93.
• Unassigning an owner from an item using the Unassign tool, page 93.
Viewing the details of an item

You can view the details of an item using the Item Detail dashboard. The
dashboard is available from context menus in various dashboards, for example,
Item by Status and Items Ageing by Current Priority. When the Item Detail
dashboard is displayed, the associated child dashboard Item Match Details is
also displayed.
The Item Detail dashboard displays the following information:
• Item Details - Displays the details of the selected item.

• Item Match Details - Displays the item match details.
• Item Notes - Displays all the notes attached to the selected item.
• Item Audit Details - Displays all the operations performed on the item.
Putting together items from different

dashboards
You can put together items from different dashboards by fast-cutting the items
from the details dashboard into the Scratch Pad dashboard. This might be useful,
for example, for putting together Outstanding and Advisory items for splitting,
or when adding items to a pending match.
The Scratch Pad dashboard is empty until items are fast cut into it.
The Scratch pad displays the same columns as the dashboard from which you cut
the items. An example of a populated Scratch Pad is given below:
To fast-cut items to a scratch pad

1. Open one or more dashboards from which you want to fast-cut items.
2. Right-click and select Scratch Pad.
The Scratch Pad dashboard is displayed.
3. Select the Scratch Pad as the fast-cut location by clicking the button at the
top right of the selection panel, above the insert bar.
4. From the dashboard containing the items that you want to work with, do one
of the following:
• To fast-cut individual items, click the button for each item you want
to move, or right-click on the item and select Fast-cut.
• To fast-cut multiple items, select the items that you want to fast-cut
using the selectors, and then right-click and select Fast-cut Selection.
5. To fast-cut subsequent items, you can specify that the items are added to an
existing group, or you can create a new group:
• To fast-cut items into an existing group, move the orange pointer on the
insert bar to point to the location where you want the items to be
added, and then fast-cut the items as before.
• To create a new group from the fast-cut items, hold down the <Ctrl>
key and then click for the item you want to move, or right-click on
the item and select Fast-cut to New Group. This new group
automatically becomes the destination for any additional items that you
fast-cut, and the pointer moves to that group to signify this.
If a grid view has aggregate-on-change settings configured and you fast-cut
items into a new group, the new group will have an aggregates row.
Viewing Exceptions
You can view the exceptions associated with selected items using the Exceptions
dashboard. The dashboard is available from context menus in various
dashboards, for example, Item Exceptions by Inbox and Items by Status.
See Viewing and editing exception details for information on what actions you
can perform on exceptions, page 130.
Creating exceptions
Exceptions can be raised, for example, if essential information is missing or if a
matched group is outside of the allowed match tolerance, and are usually raised
during manual matching. Exceptions are placed in Inboxes to ensure that the
correct user or team works on them.
Exceptions are created using the Exception Creation dashboard. The dashboard
is available from context menus in various dashboards in TLM Reconciliations-
Premium, for example, Item by Status, Item Matches and Items Ageing by
Current Priority.
To create an exception
1. Select the required item or group of items.
2. Right-click and select Exception Creation.
The Exception Creation dashboard is displayed.
3. Enter the required information, as described in the following table:

Field Description
Exception The category of the exception.
Category
Exception The type of exception. See Exception Types for a list of
Type valid options, page 119.
Exception Enter the reference of the exception.
Ref An exception reference gives context to the exception
when being displayed in grids. If this is not entered, it is
defaulted depending on the exception type.
Note Enter an appropriate note.
Exception The priority of the exception, which can be any of the
Priority following:
- Normal
- Overdue
- Critical
Select a new priority, if required, from the drop-down
list.
Inbox The Inbox to which the exception belongs. If the
ADMIN_INBOX SYST setting is populated with a
valid inbox name, you can click the button to return
the exception to the administrator’s inbox. Alternatively,
if you have the authority, you can click the More button
[…] and select a new Inbox.
Exception The reason why the exception has been raised. Click the
Reason More button […] and select a new reason to change it.
Exception The resolution action needed to close the exception.
Resolution Click the More button […] and select a new resolution
to change it.
Exception The user who has taken ownership of the exception.
Owner Click the More button […] and select a new owner to
change it.
Business The business entity of the exception. If required, click
Entity the More button […] to select a new business entity for
the exception.
4. Click [Create].
The exception is created and is ready to be dealt with by an Investigator.
Adding notes to items

You can add notes to any item. You can use notes to add any details that might
help in matching the item. You can add notes using the Add Note dashboard.
The dashboard is available from context menus in various dashboards, for
example, Item by Status and Items Ageing by Current Priority.
To add a note to an item

2. Right-click and select Add Note.
The Add Note dashboard is displayed.
3. Select a note category from the drop-down list.

4. Select a predefined note, if applicable, from the drop-down list.
5. Enter the note text, if not using a predefined note.
6. Click [Submit].
The note is created.
Viewing notes
You can view any existing notes added to an item using the Item Notes
dashboard. The dashboard is available from context menus in various
dashboards, for example, Item by Status and Items Ageing by Current Priority.
Each note that has been added to the item is displayed on a separate page which
you can switch to using the record browser. For example:
The Item Notes dashboard displays the following information:

Field Description
Note The content of the note.
Action The action performed on the item.
User Id The ID of the user who created the note.
Date The date and time when the note was created.
Time
Page The page number of the currently viewed note.
number
Linking items
Linked items are related securities. An asset register has an internal security
identifier for a security known as the internal asset identifier.
Every message has a security identifier attached to it. There are different security
coding conventions such as ISIN, CUSIP, and SEDOL. The security identifiers
are under these coding conventions. Apart from these, there are other codes
named as security aliases, which relate to the same physical security.
A security with one internal asset identifier can have other ISIN, SEDOL,
CUSIP and other identifiers. This list is stored in the asset register.
On receiving a message, GEMS converts the security identifier on the message
to the internal asset identifier using the conversion data in the asset register. This
means that the user sees the same security identifier on all items related to that
security.
A message might be loaded with a security identifier for the same security that is
not included in the asset register. You can add that identifier to the Asset
Register using the Item Link option. This option enables you to bring together
items that have different security identifiers. The unknown security identifier is
added into the asset register against the known security. Then on message input,
this newly identified security identifier is correctly translated by GEMS.
example, Item by Status and Items Ageing by Current Priority.
To link an item
2. Right-click and select Item Link.
The Item Link dashboard is displayed.
3. Click the more […] button to select the asset code to which the item is to be
linked.
4. Select the linking scope from the drop-down list.
5. Click [OK].
The selected item is linked.
Unlinking items
Linked items can be unlinked using the Item Unlink function. The dashboard is
available from context menus in various dashboards, for example, Item by Status
and Items Ageing by Current Priority. For details on Linking items, see page 88.
To unlink an item
2. Right-click and select Item Unlink.
The Item Unlink dashboard is displayed.
3. Enter the item asset code.

4. Enter the linking scope.
5. Click [OK].
The selected item is unlinked and the security identifier is removed from the
Asset Register.
Editing items
• Editing rows, see below
• Editing multiple items, page 92
Editing rows
For Sets and Items, you can edit the values in a selected row, or multiple rows on
a grid. While performing in-grid edits, the grid’s tools are not available for use
and are replaced with a Save tool and a Cancel tool. When you have saved (or
cancelled) your changes, the tools are displayed and available for use again.
The data that you can edit is governed by:
• the columns that are displayed in the current view.
• your user Attribute Maintenance settings
• the attributes that are defined as editable for your user role.
To edit a row using in-grid editing

1. Search for the items that you want to edit.
2. In the resulting grid, select the required cell that you want to edit.
Typically, the cells that contain editable attributes are displayed in a
different colour. For example:
3. Enter the required value in the cell.

If a value already exists in that cell, it is overwritten by the text that you
enter. However, if required, you can edit an existing value by single-clicking
the cell or pressing <F2> to highlight the original contents. You can then use
the mouse to position the cursor where you want to edit the text, or to select
and drag a portion of the text within the cell.
You can use <Ctrl + C> to copy a value from a cell, and <Ctrl + V> to paste
that value into an editable cell. The text that you paste overwrites any
current value within the cell. Again however, you can select the cell into
which you want to paste the value and either single-click or press <F2> to
highlight the current value and then position the cursor as required, before
pasting the value into the cell.
If the cell you have just edited is still in focus, you can undo the change
using the <Esc> or <Ctrl + Z> keys. You can undo all unsaved changes by
selecting Cancel from the grid’s toolbar.
Whilst editing the grid, you can press <Enter> to submit your changes to a
cell or where no changes have been made, to select the editable cells in the
next row down. You can also use the <Tab> and arrow keys to navigate the
grid.
If any data has not yet been saved, the row is highlighted with a black line to
denote this. For example:
When a value in a cell is entered or changed, all values within that row are
validated. If any values within the row are of the wrong datatype, or if a
mandatory field is empty, the cell with the error is highlighted with a red
dotted line and the row is highlighted with a red zigzagged line. For
example:
You must correct the data before you can save any of your changes.
4. If required, repeat step 3 for any additional cells and rows that you want to
edit.
5. When you have finished making your changes, select Save from the
grid’s toolbar.
The changes are saved to the database and recorded on the audit trail.
Editing multiple items

You can edit multiple items at a time using the Item Bulk Edit dashboard. Using
this option, you can edit the Product, Item Reason, Item Resolution, and
Business Entity details of the item. You can also add a note.
To edit multiple items

1. Select the items to be edited.
2. Right-click and select Item Bulk Edit.
The Item Bulk Edit dashboard is displayed.
3. Edit the required information:

Field Description
Product Select the product name to change it for the selected
items from the drop-down list.
Item The reason why the exception has been raised on the
Reason item.
Select a new reason from the drop-down list.
Item The action taken to resolve an exception raised on the
Resolution item.
Select a new resolution from the drop-down list.
Business The business entity to which the item belongs, for
Entity example, FX Ops.
Select a new business entity from the drop-down list.
Note Enter the note.
4. Click [Save].
The changed items are updated with a status of Pending Authorisation, and
must be authorised by a second user.
Taking ownership of an item

You can take ownership of an item using the Take Ownership tool. Taking
ownership ensures that no other user changes the item status, like including the
item in a net item or changing it to History.
To take ownership of an item

1. Select the item that you want to own.
• To own a single item, click to select the required item and click the
Take Ownership button , or right-click and select Take Ownership.
• To own multiple items, click to select the required items and click
the Take Ownership button , or right-click and select Take
Ownership.
• To own all of the items displayed in the grid, click and click the
Take Ownership button , or right-click and select Take Ownership.
The ownership changes to your name.
Unassigning an owner from an item

You can unassign an owner from an item using the Unassign Ownership tool.
To unassign an owner from an item

1. Select the item that you want to unassign.
• To unassign a single item, click to select the required item and click
the Unassign Owner button , or right-click and select Unassign
Owner.
• To unassign multiple items, click to select the required items and
click the Unassign Owner button , or right-click and select Unassign
Owner.
• To unassign all of the items displayed on a grid, click and click the
Unassign Owner button , or right-click and select Unassign Owner.
The owner is removed from the item.
94 Working with Proofs
Working with Proofs

The statements received from your account services (correspondent,
counterparty or Custodian bank) include the opening and closing balances
together with the underlying cash or asset transactions. These balances can be
included in more than one physical message and be sent throughout the day.
TLM Reconciliations-Premium tracks these balances and uses the transactions
reported within these balances to ensure that the closing balance is correct. The
opening balance plus the transactions for the date should aggregate to the closing
balance.
A statement of balances has a statement date for which the balances are to be
applied. The transactions reported in the statement have a value date, which is
considered while applying balances, for example, transactions with a date ahead
of the statement date are not considered for balances for the statement date. The
software checks the value date and then includes the applicable transactions
when validating the integrity of the opening and closing balances.
On starting the new reconciliation session, the software first writes all the set
proof information to the database. This includes creating new balance
information where balances do not exist for that date or updating balances where
the balances are already stored. This occurs where you start more than one
reconciliation process during a day.
The details of these balances can be captured in the form of a Proof. There are
two types of proofs that you can view or create in TLM Reconciliations-
Premium: Realtime proofs or Point In Time proofs.
This section primarily discusses Cash and Asset proofs. For details of Total
Equity proofs for ETD sets see chapter Working with Exchange Traded
Derivatives, and for details of Net Asset Value (NAV) proofs, see chapter
Working with Net Asset Value Reconciliations.
Realtime Proofs
If you request a realtime proof, the system calculates the balances and displays
the ‘live’ details, that is, the situation as of right now. Realtime proofs are not
saved.
Point In Time proofs

A Point In Time proof is a snapshot of the balance information at the time it is
requested. These proofs can be created automatically by the system, for example
when auto-matching, or manual matching, is completed on the set for the current
reconciliation session, or they can be created manually using the Create Point in
Time Proof tool.
You can create as many Point in Time proofs as you want, and each is stored and
can be viewed on the Point in Time Proofs dashboard. Only the most recent
Point in Time proof is considered active, older, historical proofs are marked as
Inactive.
Stored Point in Time proofs can also be viewed as a report using the reporting
tool.
Creating Point in Time Proofs

Users can create Point in Time Proofs for any balances.
To create a point in time Proof

1. Launch the REC Lifecycles Summary treeview, right-click on the set that
you want to work with and select Set Lifecycles.
2. The Set Lifecycles dashboard is displayed.
3. Click the selector for the set that you want to create a proof for, and do
one of the following:
• Right-click and select Create Point in Time Proofs.
• Click the Create Point in Time Proofs tool on the toolbar.
4. The proof is created on the set, and can be viewed.
Viewing proofs
You can view Realtime and Point in Time proofs on any set.
To view Proofs
• Launch the REC Lifecycles Summary treeview, right-click a set and
select the proof that you want to view.
• Launch the Set Lifecycles dashboard, right-click a set and select the
proof that you want to view.
A search window is displayed.
2. Enter details in the various fields. If you want to view data for all the
records with all the lifecycle statuses, do not select any checkbox in the
• After you have specified the parameters, click [Search].
• If you want to view all the data, then click [Search] without specifying
any search parameters.
Searching for all records without specifying any criteria might take a
longer time to return the records, if there are many sets.
The selected Proofs dashboard is displayed. For example:

Currency Proofs:
Securities Proofs:
The Currency proof dashboards include the following information:

Column Description
Status The status of the point in time currency proof, which
can be either Active or Inactive.
Proof Date The set proof date.
Proof Status The set proof status, which can be any of the
following:
- Unbalanced
- Balanced
- Balanced Approved/Unbalanced Approved
Category The group to which the set belongs.
A category is a group of sets.
Set The set to which the feed belongs. For example, a
General Ledger account or a Securities Portfolio ID. It
is the local set number recognised by the
reconciliations department.
Currency The currency of the feed, which is denoted using a
three letter code.
Difference The difference in the amount after balancing.
Net The sum of the closing balance of the feeds.
Balances
Net The net of all the transactions performed.
Transactions
Net Missing The net missing balance of the feeds.
Column Description
As At The date and time when the balancing was done.
Auth Status Displays whether authorization is required.
Last User The user who last worked on the item.
Last Date The date when the last action was performed.
Last Action The last action performed on the item.
Last Note The last note added on the item.
Proof ID The unique ID generated when the Point In Time
Currency Proof was created.
The security proof dashboard displays the following additional information:

Column Description
Asset Known Indicates whether the asset is known to the system,
that is, is present on the Asset Register.
Asset Code The code that identifies the asset.
Diff Bal/Trans The difference between the balance total and the
transactions total.
Diff The difference between the position total and the
Position/Trans transactions total.
Diff The difference between the running total and the
Running/Trans transactions total.
4. From the Proofs dashboards, you can:

• View the details of the selected proof, page 98.
• View the proof items, page 101.
Viewing proof details

You can view the proof details for both Realtime and Point in Time proofs by
using the Proof Detail dashboard.
The Proof Detail dashboard is displayed when you right-click an item in one of
the Proofs dashboards and select Proof Detail. You can also view this dashboard
when you double-click an item in one of the Proofs dashboards. For example:
Currency Proof details:
Security Proof details:

The Currency Proof dashboard displays the following information:

Field Description
Account The set to which the feed belongs. For example, a General Ledger
account or a Securities Portfolio ID. It is the local set number
recognised by the reconciliations department.
Category The group to which the set belongs.
A category is a group of sets.
Lifecycle The current status of the set, for example, Auto Match Requested,
Status Pending.
Proof Status The set proof status, which can be any of the following:
- Balanced
- Balanced Approved
- Unbalanced
- Unbalanced Approved
Message The message feed on which the item came in.
Feed It can be either our side or their side message feeds.
Feed type The type of feed.
Code The code of the message feed.
Closing Bal The closing balance of the feed.
CCY The currency of the feed, which is denoted using a three letter code.
Stmt Date The statement date of the incoming message.
No The number of the feed.
Pg The page on which the feed is there.
Missing The difference of balance, between the statement from the closing
Balance balance of the previous day and the opening balance on the next day.
Cnt The count of the feed.
Currency The currency of the set.
Proof
As At The date and time of the currency proof.
Account The basis of the set.
Basis
Proof Status The set proof status, which can be any of the following:
- Balanced
- Balanced Approved
- Unbalanced
- Unbalanced Approved
Latest The date of the latest statement.
Statement
Date
Closing The balance on the closing statement date.
Statement
Balance
Transactions The total amount of credit transactions. Outstanding credit numbers
- CR are displayed in the adjacent field.
Transactions The total amount of debit transactions. Outstanding debit numbers
- DR are displayed in the adjacent field.
Nets - CR The net credit amount.
Outstanding credit numbers are displayed in the adjacent field.
Nets - DR The net debit amount.
Outstanding debit numbers are displayed in the adjacent field.
Field Description
Write Offs - The total amount of credit write-offs. Outstanding credit numbers are
CR displayed in the adjacent field.
Write Offs - The total amount of debit write-offs. Outstanding debit numbers are
DR displayed in the adjacent field.
Net Total The net total of the credit and debit transactions.
Total number of outstanding transactions is displayed in the adjacent
field.
Proof The summary of the set balance.
Missing The difference of balance, between the statement from the closing
Balance balance of the previous day and the opening balance on the next day.
PROOF
Balance Net The sum of the closing statement balance of Ledger and Statement.
Transaction The sum of the loaded securities transactions.
Net
Difference The sum of balance net and transaction net amount.
Missing Bal The sum of the missing balance of Ledger and Statement.
Net
The security proof dashboard displays the following additional information:

Column Description
Asset Proof The code that identifies the asset, and whether it is known to the
system, that is, is present on the Asset Register.
Asset A description of the asset.
Description
Territory code The territory code of the asset.
Closing The quantity on the closing statement.
Statement
Quantity
Running The quantity balance from running transactions.
Transaction
Quantity
Latest Position The date of the last position balance.
Date
Position The quantity of positions for the set.
Quantity
Latest Price Date The date of the last price.
Price The price on which the balance is based.
Market Value The Market Value on which the balance is based.
Transactions The balance of the Receipt and Delivery transactions.
Nets The balance of Net items on the set.
Write Offs The balance of Write-off items on the set.
Net Totals The net totals for all transactions.
Proof Closing Difference between the Latest Closing Statement Balance and the
Stmt/Running Latest Running Transaction Balance.
Proof Closing Difference between the Latest Closing Statement Balance and the
Stmt/Position Latest Position.
Proof Difference between the Latest Position and the Latest Running
Position/Running Transaction Balance.
Column Description
Diff to Clos Stmt Absolute difference between Our and Their Latest Closing
Statement Balances.
Diff to Run Tran Absolute difference between Our and Their Latest Running
Transaction Balances.
Diff to Position Absolute difference between Our and Their Latest Positions.
Viewing proof items

You can view the details of the items captured in both Realtime and Point in
Time proofs by using the Proof Items dashboard.
To search and view proof items

1. In the Proofs dashboard, right-click the proof that you want to view the
items for.
2. Select Proof Items.
A search window is displayed.
3. Enter details in the various fields. If you want to view data for all the
• After you have specified the parameters, click [Search].
• If you want to view all records, click [Search] without specifying any
search parameters.
Searching for all records without specifying any criteria might take a
longer time to return the records, if there are many item rows.
If the search is successful, the resulting matches are displayed in the Proof
Items grid. For example:
Searching for a Proof

You can search for a specific proof using the Proof Ad Hoc Search.
To search for a proof

1. Select Menu > Ad Hoc Searches > Proofs Ad Hoc.
The following search prompt is displayed:
2. Select or enter any relevant values to help narrow down the search.
3. Click [Search].
The REC PIT Proof Ad Hoc dashboard is displayed, showing the results of
your search.
Approving Point in Time Proofs

If a Point in Time proof is unbalanced, but you are aware of the discrepancy and
are satisfied that it will be resolved, you can optionally approve the proof.
To approve a proof
1. Launch one of the Point In Time Proofs dashboards.
2. Select the proofs that you want to approve.
• To approve a single proof, click to select the required proof and click
the Approve Proof button , or right-click and select Approve Proof.
• To approve multiple proofs, click to select the required proofs and
click the Approve Proof button , or right-click and select Approve
Proof.
• To approve all proofs displayed on the grid, click and click the
Approve Proof button , or right-click and select Approve Proof.
Viewing proof audit details

You can view a record of the events that have been fired against a particular
Point In Time proof item using the Proof Audit dashboard.
To view the Proof Audit dashboard

2. Right-click a row and select Proof Audit.
The dashboard displays the following information:

Column Description
Time The date and time when the operation was performed.
User The user who is performing the action. (If they are
defined, the first name and surname of the user are
also displayed.)
More Info The extra information, if available.
Available
Creating proof notes

You can add notes to Point In Time proofs. This might be useful if, for example,
you have approved an unbalanced proof and need to explain why you have done
so.
To create proof notes

2. Right-click a row and select Add Note.
3. If required, select a note category from the drop-down list.

4. If required, select a predefined note from the drop-down list.
5. Enter the note text.
6. Click [Submit].
Viewing proof notes

You can view any notes that have been created for Point In Time proofs on the
Proof Notes dashboard.
To view proof notes

2. Right-click on the proof that you want to view the notes for and select Proof
Notes.
The dashboard displays the following information:

Field Description
Date/Time The date and time when the note was created.
User ID The ID of the user who created the note.
106 Authorising and Rejecting Reconciliations
Authorising and Rejecting Reconciliations

When matching is complete and a set is ready to be reconciled, if second user
authorization is enabled, the set’s Lifecycle Status will change to Authorisation
Requested. The reconciliation must then be authorised by a second user.
You can specify search parameters in the REC Lifecycle Summary dashboard’s
search to return sets requiring authorization. As a second user with the
appropriate role-based permissions, you can then drill down to the Set Lifecycles
dashboard to authorise or reject reconciliations, using the tools provided.
To authorise or reject a reconciliation

1. Select Menu > Lifecycles.
The REC Lifecycles Summary search prompt is displayed.
2. In the Lifecycle Status search options, select the Authorisation Requested

checkbox.
3. Click [Search].
The REC Lifecycles Summary dashboard is launched, and displays sets for
which authorization has been requested, within an Authorisation
Requested folder.
4. Right-click on the Authorisation Requested folder for the required set, and
select Sets Lifecycles.
The Sets Lifecycles dashboard is launched and displays details of the
reconciliation for which authorization was requested.

• To authorise and process a reconciliation, select the authorization
request that you want to approve, then click the Authorise tool on
the toolbar, or right-click on the grid and select Authorise.
If prompted to do so, enter a note to describe why you are authorising
the request, then click [OK].
• To reject a reconciliation, select the authorization request that you want
to reject, then click the Reject tool on the toolbar, or right-click and
select Reject.
If prompted to do so enter a note to describe why you are rejecting the
request, and click [OK].
The set’s lifecycle status changes to Authorisation Rejected and the
rejected request is moved to the Authorisation Rejected folder in the Set
Status treeview, from which it can be resubmitted for reconciliation at a
later date. For details on Resubmitting rejected requests, see page 108.
108 Authorising and Rejecting Reconciliations
Resubmitting rejected requests

If a reconciliation was rejected by an authorising user and data has subsequently
been loaded that corrects the issues preventing its authorization, you can
resubmit the request to reconcile the set.
To resubmit a reconciliation request

1. Select Menu > Lifecycles.
The REC Lifecycles Summary search prompt is displayed.
2. In the Lifecycle Status search options, select the Authorisation Rejected

checkbox.
3. Click [Search].
The REC Lifecycles Summary dashboard is launched, and displays sets for
which authorization has been rejected, within an Authorisation Rejected
folder.
4. Right-click on the Authorisation Rejected folder and select Set Lifecycles.

The Set Lifecycles dashboard is launched and displays details of the
rejected reconciliation request.
5. Select the rejected request that you want to re-submit for authorization, and
click the Reconcile tool on the toolbar, or right-click and select
Reconcile.
6. If prompted to do so, enter a note to explain why you are re-submitting the
request, then click [OK].
The reconciliation request is moved to the Authorisation Requested folder in
the Set Status tree, from which it can be authorised or rejected by an
authorising user. For details on Authorising and Rejecting Reconciliations,
see page 106.
110 Generating Reports
Generating Reports
A number of daily and monthly reports are available to enable you to monitor all
aspects of the system, including the status of matches and exceptions, as well as
daily file processing and billing.
The reports available depend on the role configured for your user, as described
in the following table:
Report Role
Cash Sec Cash Cash Cash FULL Sec Sec Sec

Admin Admin Enq Rec Super Enq Rec Super
Account         
Currency
Proof
Billing
Daily         
Exception
Daily File         
Processing
Daily     
Matching –
Cash
Settlements
Daily     
Matching –
Security
Positions
Daily     
Matching –
Securities
Transactions
Daily 
Matching
Daily Net     
Item – Cash
Settlements
Daily Net     
Item –
Security
Transactions
Daily     
Outstandings
– Cash
Settlements
Daily     
Outstandings
– Securities
Positions
Daily     
Outstandings
– Securities
Transactions
Daily     
Outstandings
Daily Write     
Report Role
Cash Sec Cash Cash Cash FULL Sec Sec Sec

Admin Admin Enq Rec Super Enq Rec Super
Offs – Cash
Settlements
Daily Write     
Offs –
Security
Transactions
Securities     
Account
Proof
STP Rates     
User     
Activity
MIS
For further information on the roles referenced in the above table, refer to the
TLM Reconciliations-Premium User Administration Guide.
Reports are generated as PDF files that you can download and save to your
machine. For example:
The reports that you can generate are listed under the Reports heading on the
menu bar. For example:
To generate a report
1. From the main menu, select Reports and then select the name of the report
that you want to generate.
The selected report dashboard is launched.
2. Click the arrow button
If there are any parameters required to generate the report, they are
displayed underneath the report and you must enter them and click the arrow
button to proceed. For example:
When the report has generated, a link is displayed, from which the report
can be downloaded. For example:
3. Click on the link.

The File Download window is displayed, from which you can choose to
open the report, or download it to your machine.
Statement / Ledger Description
report fields
Closing The ledger / statement balance on the closing statement
Statement date.
Balance
Latest Statement The date of the latest statement.
Date
Missing Balance The difference of balance, between the statement from the
closing balance of the previous day and the opening
balance on the next day.
Nets - CR The net credit amount.
Outstanding credit numbers are displayed in the adjacent
field.
Nets - DR The net debit amount.
Outstanding debit numbers are displayed in the adjacent
field.
Net Total The net total of the credit and debit transactions.
Total number of outstanding transactions is displayed in
Statement / Ledger Description

report fields
the adjacent field.
Proof The summary of the account balance.
Transactions - CR The total amount of statement / ledger credit transactions.
field.
Transactions - DR The total amount of statement / ledger debit transactions.
field.
Write Offs - CR The total amount of statement / ledger credit write-offs.
field.
Write Offs - DR The total amount of statement / ledger debit write-offs.
field.
Proof report fields Description

Balance Net The sum of the closing statement balance of Ledger and
Statement.
Transaction The sum of the loaded securities transactions.
Net
Difference The sum of balance net and transaction net amount.
Missing Bal The sum of the missing balance of Ledger and Statement.
Net
Managing Exceptions and Alerts
The Exception Management function provides an integrated, real-time exception

and alerts management system that identifies failed transactions and ensures they
are efficiently resolved and returned to the transaction flow.
Exceptions are raised, for example, if essential information is missing, or where
a matched group is outside of the allowed match tolerance. The exceptions raised
are then processed in accordance with the exception lifecycle, and can be
assigned to an inbox so that tasks can be sub-divided between users.
The Alerting service generates warnings to inform users of exceptions, so they
can take the steps necessary to resolve them using the range of dashboards and
tools available. Alerts are created to highlight high priority exceptions, and
when, for example, a high value cash item exception has been created but not
resolved after a day.
This section deals with
• Exception Management concepts, see below
• Working with Exceptions, page 129
• Searching for Exceptions and Alerts, page 154
116 Exception Management concepts
Exception Management concepts

The following sections describe a few basic concepts related to Exception and
Alert management in TLM Reconciliations-Premium.
Exception lifecycle
Exceptions are raised either automatically as a result of a match process or
manually by a user through the user interface. An exception undergoes the
following state changes:
Exceptions can also be cancelled, if raised in error, and are automatically closed
for certain exception types. For example, Position Break exceptions are
automatically closed when the items are matched and the status is changed to
History.
Managing Exceptions and Alerts 117
The following table describes each exception status:

Exception Status Description
New A new exception.
Active The exception has been acknowledged by a user, for example, a
note has been added, ownership has been taken, or it has been
edited.
Resolved The exception has been investigated, the cause is known and the
steps in order to resolve it have been performed. It is expected to
automatically close on the next data load.
Closed The problem is cleared and the exception is now closed.
Cancelled The exception was raised in error and is cancelled.
When an exception is created, the exception status is set to New. A user picks up
an exception and investigates it. At that time the exception status changes to
Active. After the exception is resolved, the status changes to Resolved. The
system waits for a confirmation for closure. The exception management process
is complete after the confirmation is received. The exception is then closed and
its status changes to Closed. An exception can be reopened after it is closed.
If required, you can generate an alert. This alert can be dismissed.
If the exception was raised in error, you can cancel it. Its status changes from
Active to Cancelled.
Allocation to an Inbox
Inboxes are used to allocate and sub-divide work. At creation time, an exception
is allocated to an Inbox. Inboxes are like workfolders where an exception type is
associated with an Inbox. Users navigate to exceptions through these Inboxes.
Inboxes display the correct set of exceptions assigned to users. This allows a
group to identify who is working on which exception. Users can take ownership
of an exception or they can be assigned to it. The access rights to Inboxes are
determined by the user roles.
Using Inboxes, users can manage exception workloads efficiently and ensure the
correct user or team works on them. An Inbox can contain any number of
exceptions or alerts.
You can move the Inbox contents from one Inbox to another. You can configure
the system to allow users to return exceptions to a default administrator inbox.
To use this function you must create an administrator inbox and specify its name
in the SYST setting ADMIN_INBOX. This displays a button on the Exception
details dashboard, which when clicked returns the exception to the default
administrator’s inbox, from where the Exceptions Administrator can reallocate it
as appropriate. If you want to constrain users to send exceptions only to the
administration inbox, and not to another named inbox, you must remove the
EXR WC Excptn CInbox tool in the REC Exception universe from the user’s
role.
Alerts
Alerts are used for notifying users about potential error conditions that have not
yet occurred, but can occur in the future. Alerts are also raised when non-critical
errors occur. Escalations can be raised when required conditions are not met
within the defined time duration, for example, an escalation might be required if
the same exception is raised several times or the time duration for which an
exception has been in a given state.
Alerts are used to notify and escalate exceptions, for example, if an exception is
raised but is not resolved within a preconfigured time, an alert is raised. Each
alert is allocated an alert type and a severity. The severity types are explained
below:
Alert Severity Description
Info Gives a notification.
Regular Indicates that a non-critical error has occurred.
Critical Indicates that potential errors have occurred, which must be
resolved immediately.
Each alert is placed in the relevant inbox, and triggers an e-mail notification to
the user.
Automatically raising and closing

exceptions
As a result of the matching process, exceptions can be automatically raised or
closed. Depending on the configuration of the business/matching logic, under
certain conditions, exceptions can be automatically generated on the current
group of items.
When items are reconciled, the system automatically deactivates the items on
open exceptions and closes the exceptions that no longer have any active linked
entities. Exceptions are automatically closed only for certain exception types, for
example, Position Break exceptions are automatically closed when the items are
matched and the status changed to History.
Inbound and outbound messaging

The system also provides the ability to send and receive email and swift
messages, to assist you with investigating and resolving exceptions. For
example, if you require further details about an exception, you can forward the
exception details to the required recipient for investigation.
Exception types
Exception Type Exception Identification Exception
Resolution
Amount/Quantity This exception should be used to track This exception
Break cash amount or security quantity/value automatically
breaks. They are identified and closes when all
created by auto match rules or by the linked transactions
user. are matched and
status changed to
History.
Amount/Value This exception is created to track The exception is
Date Break potential cash claims or value to be resolved by the
used to track exceptions relating to user, or
value date differences. They are automatically
created automatically when perfectly cancelled if the
matching a group with a value match that created
date/amount discrepancy. The set the exception is
must also have the ‘Auto Value Diff recalled.
Breaks’ parameter enabled
Value Date This exception occurs if there are The exception is
value date differences. resolved by the
user.
Value Date This exception occurs if there are The exception is

Claim value date differences. resolved by the
user. The
opportunity cost is
calculated on the
set, which can be
used to raise a
claim.
Amount/Quantity This exception occurs if there is The exception is
& Date Break combined amount/quantity and value resolved by the
date differences. user.
Outstanding This exception occurs if there are This exception
Ledger single sided exceptions (singletons or automatically
same side groups) for ledger. closes when all
linked transactions
are matched and
status changed to
History.
Outstanding This exception occurs if there are This exception
Statement single sided exceptions (singletons or automatically
same side groups) for statement. closes when all
linked transactions
are matched and
status changed to
History.
Transaction A general type used for exceptions The exception is
Break relating to security transaction automatically
discrepancies. They are identified and closed when all
created by auto match rules or by the items are matched,
user. or manually by a
user
Exception Type Exception Identification Exception

Resolution
Outstanding Txn This exception should be used for The exception is
Ledger singleton Ledger Transaction items. automatically
They are identified and created by closed when the
auto match rules or by the user. item is matched, or
manually by a user
Outstanding Txn This exception type should be used for The exception is
Statement singleton Statement Transaction automatically
items. They are identified and created closed when the
by auto match rules or by the user. item is matched, or
manually by a user
Position Break This exception occurs when This exception
reconciling positions do not net to stacks from the
zero. point the first break
is detected and
automatically
closes when the
position is next in-
balance.
Unknown This exception occurs if a security ID This exception
Security cannot be identified and therefore the automatically
security cannot be linked. closes if the
security is
subsequently linked
and a new position
perfect match is
loaded and
matched.
Aged Item This exception type should be used for The exception is
Cash/Securities items based on specific age criteria. automatically
They would typically be identified closed when the
and created by auto match rules, but item is matched, or
can also be created by the user. manually by a user
SSR Exception types

The following exception types are available on TLM Reconciliations-Premium
configurations that have been converted from SSR. All of these SSR exceptions
must be manually resolved by the user.
Exception Type Exception Identification
Converted SSR This exception occurs when there are outstanding cash items.
OS Cash
Converted SSR This exception occurs when there are problems with cash
Cash Match matches, for example when the items don’t net to zero or when
the match results in an interest claim.
Converted SSR This exception occurs when there are outstanding securities
OS Trade transactions items.
Converted SSR This exception occurs when there are problems with securities
Pos Match transactions matches. For example, when matches don’t net to
zero or where the asset codes differ.
Converted SSR This exception occurs when there are problems with securities
Trade Match positions matches. For example, for matches that don’t net to
zero or where the asset codes differs.
Position Exceptions
Overview
TLM Reconciliation Premium now provides the ability to configure multiple
position break exception types.
Prior versions of TLM Reconciliation Premium only catered for a single position
break exception type (‘Position Break’) which clients found too restrictive
because it did not allow any form of break classification.
Functional Overview
The section below provides a brief overview of the new position exception
functionality:
• A new exception category called ‘Position Breaks’ has been introduced.
• All exception types which are defined under the ‘Position Breaks’ category
will fire the same position related logic (exception storming on asset id).
• The standard Reconciliation Premium exception categories are now Cash,
Securities and Position Breaks.
• The default exception type ‘Position Break’ has been moved from the
Securities exception category to the ‘Position Breaks’ category.
• A new relationship category called ‘Position Breaks’ has been introduced.
• Matching Services has been enhanced to generate position breaks when a
perfect match is created against any relationship type under the position
breaks category.
• The position break logic has been modified to automatically create a
position break exception using the same exception type as the relationship
type which is being used to send the position items to history.
By default the relationship type lookup value and the exception type lookup
value must be identical; this is the standard way the system knows which
position break type to create.
• The default relationship type ‘Position Break’ has been moved to the new
‘Position Breaks’ category.
• A new relationship category called ‘Perfect Position’ has been introduced.
• Matching Services has been enhanced to automatically close any open
position exceptions on the same storm key (asset id) when a perfect match is
created against any relationship type under the perfect position category.
• The default relationship type ‘Perfect Position’ has been moved to the new
‘Perfect Position’ category.
• The position processing logic has been enhanced to modify the open
position exception type to reflect the latest classification. For example, if
yesterday a ‘Position Quantity Break’ was opened against the asset but when
todays data is received and processed the matching rules determine that a
Position Market Value break should be created against the asset, the items
will be stormed onto the existing open exception and the exception type will
be changed from ‘Position Quantity Break’ to ‘Position Market Value
Break’ to reflect the latest classification.
• The unknown exception type continues to operate as before.
Sample Position Break Types

The following default Position Exception Types are available:
Exception Type Relationship Type
Position Quantity Break Position Quantity Break
Position Market Value Break Position Market Value Break
Position Currency Break Position Currency Break
Position Maturity Date Break Position Maturity Date Break
Position Missing Ledger Position Missing Ledger
Position Missing Statement Position Missing Statement
Position Missing Alternate Position Missing Alternate
Position Singleton Ledger Position Singleton Ledger
Position Singleton Statement Position Singleton Statement
Position Singleton Alternate Position Singleton Alternate
Creating New Position Break Types

New position break exception types can be created using SQL (there is currently
no UI based administration function available). The process requires that a new
Exception Type is created and then a corresponding Relationship Type is created
both having the same lookup value defined.
Insert New Exception Type

The following sql statement template will create a new exception type, the
values in bold need to be updated appropriately:
Insert into EXM_REF_EXCEPTION_TYPE

( EXCEPTION_TYPE_ID,
NAME,
DESCRIPTION,
CATEGORY_ID,
BASE_PRIORITY,
LOOKUP_VALUE,
ACTIVE_STATUS,
STORMABLE,
ENTITY_TYPE
) values
( 200000001, -- (a)
'Position Quantity Break', -- (b)
'Position Quantity Break', -- (c)
200000001,
1,
'Position Quantity Break', -- (d)
1,
1,
1003
);
commit;
(a) The unique exception type id - find the maximum exception_type_id

from the exm_ref_exception_type table and increment by 1
(b) The new exception type name
(c) The new exception type description
(d) The new exception type lookup value (must be unique).
Insert New Relationship Type

The following sql statement template will create a new exception type, the
values in bold need to be updated appropriately:
Insert into TLM_REF_RELATIONSHIP_TYPE

( RELATIONSHIP_TYPE_ID,
RELATIONSHIP_CAT_ID,
NAME,
DESCRIPTION,
ACTIVE_STATUS,
LOOKUP_VALUE,
OVERALL_STATUS,
ENTITY_TYPE,
UPDATED_BY,
UPDATED_TIMESTAMP,
VERIFIED_BY,
VERIFIED_TIMESTAMP,
SOFT_LOCK_KEY
) values
( 210000003, -- (a)
200000001,
'Position Currency Break', -- (b)
'Position Currency Break', -- (c)
1,
'Position Currency Break', -- (d)
null,
null,
'SYSTEM',
sysdate,
null,
null,
1
);
commit;
(a) The unique relationship type id - find the maximum relationship_type_id

from the tlm_ref_relationship_type table and increment by 1
(b) The new relationship type name
(c) The new relationship type description
(d) The new relationship type lookup value (must be unique and the same as
the lookup value used for the corresponding exception type above).
Standard Configuration Required for Each Position

Break Type
In order to be able to use the new exception break types in the auto-matching
process the following entities need to be configured for each break type using the
TLM Recon Admin client.
• Perfect Match Initiation 1, see below
• Perfect Match Initiation 2, see page 126
• Event List, see page 126
• Workflow Tool, see page 127
Perfect Match Initiation 1

Create a new initiation of type ‘Auto Perfect Relationship’ and tick the Attach
Item to Workflow Queue check box.
Select the relationship type corresponding to the exception type to be created.

Perfect Match Initiation 2

Create a new initiation event at the REC Items level pointing to the new
initiation created above
Event List
Create a new event list at the REC Items level.
Add the initiation event created above:

Workflow Tool
Create a new workflow tool:
Add a single step:
Add the event list created above and select Commit Workflow as the next step:
Creating Exceptions of the New Position Break Type

Once the steps in Section Creating New Position Break Types have been
completed a workflow tool will exist for the new exception type. Configuring the
system to create an exception of the new type requires that the appropriate
workflow tool is selected as the Processing option against a pass quality step, the
pass quality rules for this step will define under what conditions the break will
be created.
Solution Properties
The following solution properties have been added:
Property Name Default Value Note
RECS_POSBREAK_REL_CAT_OPEN 200000001 Relationship category id
which will auto-open
position break exceptions
RECS_POSBREAK_REL_CAT_CLOSE 200000000 Relationship category id
which will auto-close
position break exceptions
RECS_POSBREAK_EXP_CAT_ID 200000001 Exception category id for
position exception types
Working with Exceptions

The main Exceptions functions are accessed by selecting Exceptions from the
main menu. This launches the following dashboards which provide a summary
of the exceptions, alerts and messages in the system. For example:
These dashboards contain the following controls, from which you can drill down
to view the exception, alert and message details in a grid dashboard:
• Rec Exceptions Inbox Summary – a hierarchical treeview representation of
active exceptions. By default, the treeview is categorised by Inbox,
exception owner, exception status and the total number of exceptions in
each exception type.
• Exceptions by Priority – a bar chart summarising the exceptions in each
exception priority. The number of exceptions is displayed next to the
exception priority name. The exception priorities are Normal, Overdue and
Critical.
• Alerts by Severity - a bar chart that provides a summary of alerts by status.
The number of alerts is displayed next to the alert status name. The alert
statuses are Info, Regular and Critical.
• Alerts by Inbox - a treeview that provides a hierarchical representation of
active alerts. By default, the treeview is categorised by Inbox and Alert
Type.
• Messages by Status – a treeview that provides a hierarchical representation
of the current exception messages in the system. By default, the nodes in the
treeview are categorised by Message Status > Inbox > Owner > Message
Name.
Exception Creation
Exceptions are usually created in the first instance by a reconciler who has
discovered a discrepancy. See Creating Exceptions for details of how this is
done, page 85.
130 Working with Exceptions
Viewing and editing exception details

You can select any exception in a grid dashboard, and drill down to the
Exception Detail dashboard to view and make changes to the exception.
The Exception Detail dashboard displays the following information:
• Exception Detail – displays information about the exception, such as its ID

and priority, and provides a set of editable fields and buttons that enable you
to make changes and perform actions on the exception.
• Exception Summary – provides an overview of the exception including the
date on which it was identified and the amount difference.
• Exception Alerts – click on this tab to display any alerts that have been
generated for the exception.
• Exception Items – displays the items associated with the exception.
• Exception Audit – displays a list of all the actions performed on the
exception, the user responsible for the actions and the date and time at
which they occurred.
• Exception Attachments – displays a list of any documents attached to the
exception.
• Exception Notes – click on this tab to display any notes that are attached to
the exception.
• Exception Messages – displays any messages attached to the exception.
Exception section and header management options

This section allows you to edit an exception. The following fields are displayed:
Field Description
Exception The exception status, which can be any of the following:
Status • New - Indicates a new exception
• Active - Indicates the exception is under investigation
• Resolved - Indicates the exception has been resolved
• Closed - Indicates the exception has been closed
Cancelled - Indicates the exception has been cancelled
Exception ID The ID generated when the exception was created.
Exception The category of the exception.
Category
Exception The type of exception. See Exception Types for a list of valid
Type options, page 119.
Count Linked The number of entities linked to the exception.
Entities
Exception Key The exception key. This field displays the exception value for a
stormable exception. For a non-stormable exception, it displays
a combination of exception ID and exception value.
Our Ref The ‘our side’ reference of the exception.
Their Ref The ‘their side’ reference of the exception.
Note Enter an appropriate note.
Exception The priority of the exception, which can be any of the
Priority following:
- Normal
- Overdue
- Critical
Select a new priority, if required, from the drop-down list.
Inbox The Inbox to which the exception belongs. If the
ADMIN_INBOX SYST setting is populated with a valid inbox
name, you can click the button to return the exception to
the administrator’s inbox. Alternatively, if you have the
authority, you can click the More button […] and select a new
Inbox.
Exception The reason why the exception has been raised. Click the More
Reason button […] and select a new reason to change it.
Exception The resolution action needed to close the exception. Click the
Resolution More button […] and select a new resolution to change it.
Exception The user who has taken ownership of the exception. Click the
Owner More button […] and select a new owner to change it.
Authorisation Indicates whether authorization is required for the exception.
Status
Last Action The user who performed the last action on the exception.
User
Last Action The date on which the last action was last performed.
Date
Last Action The last action performed on the item.
Exception The date and time when the exception was created.
Created
Business The business entity of the exception. If required, click the More
Entity button […] to select a new business entity for the exception.
Field Description
Next Message The next type of message to be sent for this exception, where
Type applicable.
Next Message The date the next message is to be sent, where applicable.
Date
Next Review The date the next message is to appear in the exception inbox
Date for review, where applicable.
Managing exceptions messages

The Messages by Status dashboard displays a treeview in which the exceptions
messages currently in the system are categorised by their status:
• Authorisation requested – this category contains outbound messages that

require approval by an authorising user before they can be sent.
• Rejected – this category contains outbound messages that have been rejected
by an authorising user.
• Unread – this category contains inbound messages that have not yet been
read.
You can use this dashboard to access the Ad Hoc Message Search, or to drill
down to the Messages by Status dashboard, in which you can view and work
with the messages in each category.
Viewing exception messages by status

You can drill down from any status in the Messages by Status tree, to view a list
of the messages with that status, in the Messages by Status grid dashboard. For
example:
You can right-click on any message displayed on this dashboard to perform any
of the following options where available on the context menu:
• View the message details, page 135
• View the message audit, page 135
• Attach to Exception, page 143
• View the exception details, page 130
• Detach from Exception, page 139
• Mark as Read
To view Messages by Status

• In the Messages by Status dashboard, right-click on any node and select
Messages by Status.
The Messages by Status dashboard is launched and displays any messages
with the selected status.
Viewing message details

You can use the Message Details dashboard to view a message, as well as
information such as its direction, status and type. This dashboard also contains
buttons for authorising, rejecting, and editing the message, as well as marking it
as unread. For example:
The availability of the buttons depends on the status and type of the message.
For example, the message illustrated above has a status of rejected. As such,
only the [Edit] button is available, so that the message can be changed and
resubmitted by the user.
To view message details

• Right-click on the exception in any grid dashboard and select Message
Detail.
The message is launched in the Message detail dashboard, from which you
can use the tools to process the message as required.
Viewing the message audit

The Message Audit dashboard displays the actions associated with the message
as well as the user responsible for those actions, and the time at which they
occurred.
An entry is written to the audit each time that a message is created, attached to
an exception, detached from an exception, sent for authorization, rejected or
sent.
To view the Message Audit dashboard

1. Right-click on a message in any grid dashboard and select Message Audit.
The Message Audit dashboard is launched.
2. If the message is attached to an exception, a flag is displayed in the Mc,

More Information available column, which you can double-click to drill-
down to the Exception Detail dashboard.
Searching for exceptions messages

You can search for messages using the Ad Hoc Messages search prompt, which
is accessed via the Messages by Status dashboard.
To search for messages

1. Right-click on any node in the Messages by Status tree and select
Messages Ad-Hoc Search.
The Messages Ad-Hoc search prompt is displayed.
options of a particular field, keep that field blank. For example, to view
inbound and outbound messages, do not select checkboxes in the Message
Direction field.
3. Click [Search]
Any messages returned by the search are displayed in the Messages by
Status dashboard.
Creating an Inbound Message

When inbound swift messages are received by the system, where possible, they
are automatically attached to the associated exception and displayed within the
Unread category on the Messages by Status tree.
The system currently supports automatic processing of inbound Swift MT999,

MT996 and MT995 messages.
For message formats such as emails that are not automatically processed by the
system, you can use the Message Creation dashboard to manually attach the
message to the relevant exception.
To manually attach a message to an exception

1. In a grid dashboard, select the exception that you want to attach the message
to.
2. Right-click and select Message Creation.
The Message Creation dashboard is displayed.
3. Enter a subject and their reference for the message, and copy the message
details into the Message field.
4. Click [Attach].
The message is attached to the exception and the appropriate audit trail
entries are created.
Viewing the messages attached to an exception

You can drill down from any exception listed in a grid dashboard, to the
Exception Messages dashboard, which lists any messages attached to that
exception.
If required, you can then use the context menu options on this dashboard to
perform a variety of actions on the exception messages displayed.
To view the messages attached to an exception

• Right-click on the required exception in any grid dashboard and select
Exception Messages.
The Exception Messages dashboard is displayed and lists the messages
attached to the exception. For example:
Copying or moving exception messages

You can copy any existing read or unread message to another exception, using
the Attach to Exception tool on the Exception Messages dashboard.
By default, copying the message to another exception detaches it from the
current exception. However, you can override this option if required.
To copy or move a message to a different exception

1. Launch the Exception Messages dashboard, and select each message that
you want to copy to another exception.
2. Right-click and select Attach to Exception, or click the Attach to Exception
tool .
The Attach to Exception window is displayed.
3. In the Exception ID field, enter the ID of the exception you want to copy the
message to.
4. If you do not want the copied message to be deleted from the current
exception, enter ‘N’ in the Delete from existing exceptions field.
5. Click [OK].
The message is copied to the selected exception.
Detaching a message from an exception

If required, you can detach an existing read or unread message from an
exception using the Detach from Exception tool on the Exception Messages
dashboard.
You can only detach a message from an exception if it is currently attached to
another exception. If this is not the case, you must copy the exception to another
message before processing the message with the Detach from Exception tool.
To detach a message from an exception

1. Launch the Exception Messages dashboard and select each message that
you want to detach from the exception.
2. Right-click and select Detach from Exception, or click the Detach from
Exception tool .
The selected messages are detached from the exception.
Sending exception messages

If you require further information about an exception, the system enables you to
send a variety of outbound message types, including swift and email, which
contain information about the exception that is derived using your choice of
preconfigured template.
The system currently supports the creation of MT999 and MT995 outbound
swift messages.
You can select from a variety of outbound message types, including swift and
email, and the message recipient can either be defined automatically from
‘Correspondent’, ‘Inbox’, or ‘Business Entity’, or alternatively sent to a third
party of your choice.
The type of message that you send will determine whether you can edit the
message contents, and also whether the message must be approved by another
user before being sent.
To send an outbound message

1. View the exception for which you want to send a message in the Exception
Detail dashboard.
2. Click the [New Message] button.
The REC Exception Comms dashboard is launched as a new tab in the
window.
3. Select the type of message you require from the drop-down menu.
The remaining fields are populated with the data dictated by the message
type template, where appropriate.
4. Populate any remaining outbound message fields and where available,
perform any required edits to the prepopulated fields.
5. Click [Send].
If the message type requires authorization, it is displayed in the
Authorisation Requested folder in the Messages by Status tree, and will not
be sent until it has been approved by an authorising user.
Outbound Message fields

The following fields are used to create an outbound message on the REC
Exception Comms dashboard:
Field Description
Type Select the type of message you want to send from the drop-down
menu.
Delivery The delivery mechanism of the message, for example Email or
SWIFT. This field is automatically populated when you select the
message type.
Recipient Choose from the following options:
• Correspondent – the message is sent to the address defined on
the exception’s set.
• Inbox – the message is sent to the address defined for the
associated inbox’s default contact group.
• Business Entity – the message is sent to the address on the
exception’s business entity.
• Third party –select this option if you want to manually select the
recipient using the To field.
To Click the More button […] to select the required recipient. This
option is only available when sending the message to a third party
recipient.
Address The Address field is automatically populated with the address of any
recipient that is selected in the To field.
Subject Where available, edit the subject line as required.
Message The body of the message. This field is prepopulated when you select a
message type.
Authorising outbound messages

For message types requiring authorization, a second user must review and
approve the outbound message before the message can be sent.
When an authorising user approves a message, it is sent immediately. If the
message is rejected, the message status changes to Authorisation Rejected and
the message is made available for the user to edit and resubmit for authorization.
To authorise an outbound message

1. In the Messages by Status tree, expand the Authorisation Requested
folder and double-click on the message that you want to authorise.
The Messages by Status dashboard is launched and displays the message
requiring authorization.
2. Right-click on the message in the grid, and select Message Detail.
The Message Detail dashboard is displayed.
3. Review the message and do one of the following:

• If you want to send the message, click [Authorize].
• If you want to reject the message, click [Reject].
The message is either sent or rejected, depending on your selection.
Rejected messages are displayed in the Rejected folder of the Messages by
Status tree, from which they can be edited and resubmitted for authorization.
Attaching documents to an exception

You can use the document attach function to add documents to your exceptions,
which is useful in situations where the exception requires missing information
that is contained in a document or spreadsheet.
You can attach documents to an exception from any grid dashboard in which the
exception is displayed, or from the Exception Detail dashboard.
You might need to configure your browser’s security settings to enable the
document attach function to work, if your organisation permits you to do so. For
details see page 24.
To attach a document to your exception

• Right-click on the exception in a grid and select Attach Document.
• View the exception in the Exception Detail dashboard and click the
[Attach Document] button.
The Attach Document window is displayed.

[Open].
The document is attached to the selected exception.
Viewing attached documents

You can view and download documents that are attached to exceptions, from
either the grid dashboard in which the exception is displayed, or the Exceptions
Detail dashboard.
To view and download documents

• View the exception in the Exception Detail dashboard, then right-click
on the entry for the required document in the Exception audit area and
select Download Attachment.
• Drill down to the Attachments dashboard from any grid dashboard in
which the exception is displayed, or from the Exception audit area of
the Exception Detail dashboard.
The Attachments dashboard is launched and lists any documents that
have been attached to the exception, as well as the date and time the
documents were attached, the document file names, the user who
attached the document, and any associated notes.
Right-click on the required document and select Download

Attachment.
The File Download window is displayed.
2. Choose whether to view the document or save it to your machine by clicking
the [Open] or [Save] button, as required.
Adding notes to an exception

You can use the Notes Creation dashboard to add notes to an exception to
describe any details that might help in resolving the exception.
This dashboard is available from context menus in various dashboards, for
example, in the Item by Status and Items Ageing by Current Priority dashboards.
To add a note to an exception

1. Select the required record.
2. Right-click and select Add Note.
3. Select the note category from the drop-down list.

4. Select the predefined note, if applicable, from the drop-down list.
5. Enter the note text.
6. Click [Submit].
The note is created.
Viewing exception notes

You can view any notes that have been added to an exception using the
Exception Notes dashboard.
example, Exceptions by Inbox, Exceptions Ad-Hoc Search and Exception by
Priority.
It includes the following columns:

Field Description
Action The action performed on the exception.
User Id The ID of the user who created the note.
Date Time The date and time when the note was created.
Editing multiple exceptions

You can edit more than one exception at a time using the Exception Bulk Edit
dashboard. Using this option, you can edit the Exception Priority, Inbox,
Exception Reason, Exception Resolution, and Exception Owner.
To edit multiple exceptions

1. Select the exceptions to be edited.
2. Right-click and select Exception Bulk Edit.
The Exception Bulk Edit dashboard is displayed.
3. Edit the required information. For details see page 147.

4. Click [Save].
The changes are updated for the selected exceptions.
Bulk exception edit fields

Field Description
Exception The priority of the exception, which can be Normal,
Priority Overdue, or Critical.
Click the More […] button to change the current priority for
the selected exceptions.
Inbox The Inbox to which the exception belongs.
Click the More […] button to change the Inbox for the
selected exceptions.
Exception The reason why the exception has been raised.
Reason Click the More […] button to change the exception reason
for the selected exceptions.
Exception The action taken to resolve an exception.
Resolution Click the More […] button to change the exception
resolution for the selected exceptions.
Exception Owner The user who has taken ownership of the exception.
Click the More […] button to change the exception owner
for the selected exceptions.
Note Enter the note.
Adding an item to an existing exception

You can use the Add to Exception tool to add an item to an existing exception.
This is done by entering the exception ID to which the item is to be added.
To add an item to an existing exception

1. Perform a search that returns the item that you want to add to an exception.
2. Select the item that you want to add.
• To add a single item, click to select the required item and click the
Add to Exception button , or right-click and select Add to
Exception.
• To add multiple items, click to select the required items and click the
Add to Exception button , or right-click and select Add to
Exception.
• To add all items displayed on the grid, click and click the Add to
Exception button , or right-click and select Add to Exception.
4. Enter the exception ID.
The selected item is added to the exception.
Resolving an exception
You use the Resolve tool to resolve an exception. You can resolve exceptions
with New or Active exception status. When you resolve the exception its status
changes to Resolved. After an exception is resolved, the exception is
automatically closed on next data load. After the exception is closed, the status
changes to Closed.
To resolve an exception
1. Select the exception that you want to resolve.
• To resolve a single exception, click to select the required exception
and click the Resolve button , or right-click and select Resolve.
• To resolve multiple exceptions, click to select the required items and
click the Resolve button , or right-click and select Resolve.
• To resolve all exceptions displayed on the grid, click and click the
Resolve button , or right-click and select Resolve.
The selected exception is resolved.
To resolve an exception from the Exception Detail dashboard

1. Launch the Exception Detail dashboard, for the exception that you want to
resolve.
2. Add a note in the Note field if required.
3. Click [Resolve Exception].
The exception status changes to Resolved.
Cancelling an exception
The Cancel tool is used to cancel exceptions raised in error. Exceptions with
status as New or Active can be cancelled. When an exception is cancelled, the
exception status changes to Cancelled.
To cancel an exception
1. Select the exception that you want to cancel.
• To cancel a single exception, click to select the required exception
• To cancel multiple exceptions, click to select the required exceptions
• To cancel all exceptions displayed on the grid, click and click the
Cancel button , or right-click and select Cancel.
The selected exception is cancelled.
To cancel an exception from the Exception Detail dashboard

cancel.
3. Click [Cancel Exception].
The exception status changes to Cancelled.
Closing a resolved exception

The Close tool is used to close an exception. You can close exceptions for
exceptions with status as New, Active or Resolved.
To close an exception
1. Select the exception that you want to close.
• To close a single exception, click to select the required exception and
click the Close button , or right-click and select Close.
• To close multiple exceptions, click to select the required exceptions
and click the Close button , or right-click and select Close.
• To close all exceptions displayed on the grid, click and click the
Close button , or right-click and select Close.
The selected exception is closed.
To close an exception from the Exception Detail dashboard

close.
3. Click [Close Exception].
The exception status changes to Closed.
Reopening an exception
The Reopen tool is used to reopen an exception. Only exceptions with an
exception status of Closed can be reopened. When a previously closed exception
is reopened, the exception status is set to New. Cancelled exceptions cannot be
reopened.
To reopen an exception
1. Select the exception that you want to reopen.
• To reopen a single exception, click to select the required exception
and click the Reopen button , or right-click and select Reopen.
• To reopen multiple exceptions, click to select the required exceptions
and click the Reopen button , or right-click and select Reopen.
• To reopen all exceptions displayed on the grid, click and click the
Reopen button , or right-click and select Reopen.
The selected exception is reopened.
Taking ownership of an exception

The Take Ownership tool is used to take ownership of the exception. This is a
quick way to change the owner to the current user. Taking ownership indicates
to other users that you are working on that exception. It acts as a flag and ensures
that no two users work on the same exception at one time.
To take ownership of the exception

1. Launch the Exception Detail dashboard, for the exception whose ownership
you want to take.
2. Click [Take Ownership].
The user name changes to your name in the Exception Owner field.
Unassigning an owner from an exception

You can unassign an owner from an exception using the Unassign Ownership
tool.
To unassign an owner from an exception

1. Select the item that you want to unassign.
• To unassign a single item, click to select the required item and click
the Unassign Owner button , or right-click and select Unassign
Owner.
• To unassign multiple items, click to select the required items and
click the Unassign Owner button , or right-click and select Unassign
Owner.
• To unassign all of the items displayed on a grid, click and click the
Unassign Owner button , or right-click and select Unassign Owner.
The owner is removed from the item.
154 Searching for Exceptions and Alerts
Searching for Exceptions and Alerts

You can use the following searches to search for specific exceptions or alerts:
• Items with exceptions, page 155
• Exceptions, page 157
From each of the dashboards displaying the search results you can use the
available tools to perform many of the typical functions for items of that type,
and you can save any changes that you make using the REC Item Save context
menu option. For details on Working with Business Logic tools, see page 43.
You can also access some or all of the following child dashboards:
• Scratch Pad - To fast cut items to work with later, page 84
• Item Detail - To view the details of the item.
• Match Detail - To provide the details of the match, page 73.
• Exception Creation - To create an exception, page 85.
• Add Note - To create a new note and attach it to the selected item, page 145.
• Item Notes - To view the notes created for an item, page 88.
• Exception Detail - To view the details of the exceptions associated with an
item. This option is displayed only if the selected item has an exception. For
details on Viewing and editing exception details, see page 130.
• Exceptions - To view the list of exceptions. This option is displayed only if
the selected item has more than one exception.For details on Viewing
Exceptions, see page 85.
• Item Link - To link items by storing an unknown code as an alias for a
known code, page 88.
• Item Unlink - To remove the linking done by using Item Link, page 89.
• Item Bulk Edit - To edit more than one items at a time, page 92.
• Launch Audit Trail - To view all the transactions performed on the item for
audit, page 46.
Searching for items with exceptions

You can view items attached to exceptions for the selected Inbox using the
search criteria provided on the Ad-Hoc Item Exceptions Search dashboard.
To search for item exceptions

3. Select Ad-Hoc Item Exceptions Search.
5. Click [Search].
If the search is successful, the resulting items are displayed in the Ad-Hoc
Item Exceptions Search grid. For example:
6. Use the dashboard’s tools to perform the required functions.

Searching for exceptions

You can search for exceptions based on the specified criteria. Launching the
Exceptions Ad-Hoc Search option from the Exceptions Inbox Summary allows
you to search for exceptions contained within the selected Inbox. This can be
overridden to view results across all Inboxes.
To search for exceptions

1. Launch the Exceptions Summary dashboard.
2. Right-click an inbox in the REC Exceptions Inbox Summary treeview.
3. Select Exceptions Ad-Hoc Search.
exceptions in any inbox, clear the Inbox field.
5. Click [Search]:
If the search is successful, the resulting exceptions are displayed in the

Exceptions Ad-Hoc Search dashboard. For example:
6. Use the dashboard’s tools to perform the required functions.

Searching for alerts

You can search for alerts using the Alert Ad-Hoc Search option. The search
returns alerts contained within the selected Inbox. This can be overridden to
view results across all Inboxes.
To search for alerts

1. Select Menu > Exceptions.
The REC Exceptions and Alert Summary dashboards are displayed.
2. In the Alerts Summary dashboard, right-click on the required inbox and
select Alert Ad-Hoc Search.
options of a particular field, keep that field blank. For example, to view
alerts within the whole range of lifecycle statuses, ensure that the
checkboxes in the Lifecycle Status field are not selected.
4. Click [Search].
If the search is successful, the resulting alerts are displayed in the Alert Ad-
Hoc Search dashboard.
5. To view the exception details for an alert from the Alert Ad-Hoc Search
dashboard, select an alert, right-click and select Exception Detail or double-
click an alert.
6. If you want to dismiss an alert, to show that you have acknowledged the
exception, select the alert and do one of the following
• Click the Dismiss button.
• Right-click and select Dismiss.
Working with Exchange Traded
Derivatives
If the Exchange Traded Derivatives (ETD) module is part of your TLM

Reconciliations-Premium configuration, you will have access to additional
functionality that enables you to reconcile ETD transactions.
The ETD transactions are processed by TLM Reconciliations-Premium in the
same was as standard cash and asset transactions; the main difference is in the
proofing dashboards for ETD balances, which are known as Total Equity Proofs.
The following ETD items, received from your clearing institutions, are loaded on
a daily basis for each fund and cover the previous business day:
• Cash Balances
• Cash Transactions
• Asset Positions
• Asset Transactions
You view these items on the REC Lifecycles Summary tree, ensuring that the
ETD-specific option on the dashboard’s search prompt is selected. When you
run the search, the dashboard is launched and displays the reconciliation status of
ETD items under an ‘ETD’ folder in the Lifecycles tree. For example:
Cash Transactions, Asset Positions and Asset Transactions are all reconciled in
the regular way, that is, internal items are matched against the items from your
clearing institutions. You can view these matches on the standard matching
dashboards. For example:
If you identify any potential issues and breaks, you can use the standard TLM
Reconciliations-Premium dashboards and tools to view, investigate and reconcile
the cash transactions, asset positions and asset transactions associated with
problematic accounts.
Cash Balances are not reconciled. For these items, you can drill down to the
Total Equity proofs dashboards to view a summary of the Total equity value of
each account. This is generated from the cash balances that are loaded into the
system, which are assigned a status of Advisory and used for the purpose of
creating Total Equity proofs.
Working with Exchange Traded Derivatives 163
ETD Proofs
The following sections describe the proofing dashboards that are specific to ETD
balances.
Viewing Realtime Total Equity Proofs

Realtime Total Equity proofs provide a real-time view of the total equity
valuation for accounts in the system, including the proof status and a summary
of the balance calculations and variance.
This information enables you to quickly identify the accounts where breaks have
occurred, and is displayed on the Realtime Total Equity Proofs dashboard.
To launch the Realtime Total Equity Proofs dashboard

1. From either the REC Lifecycles Summary dashboard or the Accounts
dashboard, right-click on the level you want to drill down from and select
Realtime Total Equity Proofs from the context menu.
164 ETD Proofs
2. Modify the search fields as required, and click [Search].

The Real Time Total Equity proofs dashboard is launched and displays the
proofs returned from the search. For example:
This dashboard contains a number of fields, including the following:
Field Description
Proof Status The account proof status, which can be any of the
following:
- Unbalanced
- Balanced
Account The Account name
Currency The Account currency, denoted by a three letter code.
Cash Net The net value of cash balances.
Option The net value of the statement and ledger unrealised
Unrealised options.
Net
Futures The net value of the statement and ledger unrealised
Unrealised futures.
Net
Other The net value of any other statement and ledger
Unrealised unrealised instruments excluding futures and options.
Net
Total Equity The net sum of the ledger cash, options unrealised and
Net other unrealised net balances, and that of the statement.
This gives an indication of the value of the account.
Outstanding The value of outstanding cash items.
Cash
Variance The total equity net minus any outstanding cash
balances
As At The date the proof was created
You can view further information on any proof displayed in this dashboard
by right-clicking on the proof and drilling down to the Proof Detail
dashboard. You can also drill down to the Proof Items dashboard to view the
balances captured at the time the proof was taken.
Working with Exchange Traded Derivatives 165
Creating and viewing Point In Time Total

Equity proofs
A point in time Total Equity proof provides a snapshot of an account’s Total
Equity proof at the time at which the snapshot was taken. They are created upon
completion of the automatic matching process when an account is reconciled, or
manually by the user.
Point In Time Total Equity Proofs are created and viewed in the same way as
standard cash and asset proofs. See chapter Managing
Reconciliations > Working with Proofs > Creating Point In Time proofs and
chapter Managing Reconciliations > Working with Proofs > Viewing proof
items.
Viewing Total Equity Proof details

You can drill down to the Proof Detail dashboard from either the RealTime or
Point in Time Total Equity Proofs dashboards.
You can use the Proof Details dashboard to view the detailed statement and
ledger data captured by a Total Equity proof. For ETD balances, this dashboard
is enhanced to display ETD-specific fields such as cash and equity variance
values. For example:
166 ETD Proofs
This dashboard contains a number of fields including:

Field Description
Opening Cash The opening cash balance. This is the previous day’s closing
Balance cash balance
Closing Cash The sum of the opening balance, the net profit and loss from
Balance trades and the outstanding cash amounts.
Cash Bal Net The net value of the statement and ledger closing balances.
Futures Unrealised The value of unrealised futures.
Futures Unrealised The net value of the statement and ledger unrealised futures.
Net
Equity The sum of the cash balances, unrealised options and any other
unrealised balances.
Initial Margin The initial deposit that covers the exchange or broker
requirement for the listed derivatives.
Margin Call Excess The difference between the current value of equities and the
initial margin.
Additional Margin This field is populated if the value of the equities becomes less
Required than the initial margin.
Forwards Unrealised The value of net commodity trades that cannot be closed and
remain open until expiry.
Forwards Net The net value of the statement and ledger unrealised forwards.
Options Unrealised Value of options if you were to liquidate all current open option
positions.
Options Net The net value of the statement and ledger unrealised options.
Value The total value of the account, which is the sum of the account’s
equities, forwards and options.
Exchange Rate The exchange rate used to calculate the value base from the
value.
Value Base The value converted to the base currency using the exchange
rate.
Value Net The net value of the statement and ledger value.
Value Net base The net value of the statement and ledger base value.
Outstanding Cash The value of outstanding cash items.
Outstanding Net The difference in the value of unmatched items.
Cash Variance The difference between the Cash Bal Net figure and the
Outstanding Net.
Equity Variance The difference between the Equity Net and the Outstanding Net.
Working with Net Asset Value
Reconciliations
If the Net Asset Value Reconciliations (NAV Recs) module is part of your TLM
Reconciliations-Premium configuration, you will have access to additional
functionality that enables you to reconcile NAV Recs.
The NAV transactions are processed by TLM Reconciliations-Premium in the
same was as standard cash and asset transactions; the main difference is in the
proofing dashboards for NAV balances.
The purpose of the Net Asset Valuation Reconciliation is to validate that the
customer's gross position held with their counterparties accurately reflects the
true gross position held in their books and records.
The following diagram gives a basic overview of the reconciliation process for
NAV Recs:
Internal: External:
High Level Reconciliation
Balance Sheet Trial Balance
Reconciliation Reconciliation
to ensure to ensure
integrity integrity
Internal: Detail Detailed Reconciliation External: Detail
High Level Reconciliation

The Internal Balance Sheet valuation is compared to the External (Fund
Administrator) Trial Balance figure. If a difference exists, an exception is raised
and the portfolio is flagged as having an issue.
168 ETD Proofs
Detailed Reconciliation
All received Positions, Cash components, and open or unsettled trades are
reconciled to look for discrepancies between them. Any breaks in these elements
are flagged up as exceptions that require some investigation.
The proofs for NAV Recs display a single Proof Status that indicates whether
there is a problem at either the Balance Sheet or Detail level.
You view NAV Rec items on the REC Lifecycles Summary tree. The tree
displays the reconciliation status of NAV items under a ‘NAV’ folder. For
example:
Cash Transactions, Asset Positions and Asset Transactions are all reconciled in
the regular way, that is, internal items are matched against the items from your
clearing institutions. You can view these matches on the standard matching
dashboards. For example:
If you identify any potential issues and breaks, you can use the standard TLM
Reconciliations-Premium dashboards and tools to view, investigate and reconcile
the transactions associated with problematic accounts.
Working with Net Asset Value Reconciliations 169
NAV Rec Proofs

The following sections describe the proofing dashboards that are specific to
NAV balances.
The NAV proofing dashboards include fields called ‘NAV Basis point variance’
and ‘Basis Point Proof’. These are the same thing, and the value is the difference
expressed as a percentage of the Net Asset Value on the Statement side.
For example, the following proof has a difference of 34661.15, and a Net Asset
Value on the Statement side of 274553767.2:
The following calculation is used to find the Basis Point:

(34661.15/274553767.2) * 100 = 0.0126
Because the resulting value is so small, it is then multiplied by 100 to give a
Basis Point value rather than a percentage, that is, 1.26.
1% is 100 basis points.
170 NAV Rec Proofs
Viewing Realtime Net Asset Value Proofs

Realtime Net Asset Value proofs provide a real-time view of the Net Asset
Value for accounts in the system, including the proof status and a summary of
the balance calculations and variance.
This information enables you to quickly identify the accounts where breaks have
occurred, and is displayed on the Net Asset Value Proofs dashboard.
To launch the Realtime Net Asset Value dashboard

1. From either the REC Lifecycles Summary dashboard or the Accounts
dashboard, right-click on the level you want to drill down from and select
Realtime Net Asset Value Proofs from the context menu.
Working with Net Asset Value Reconciliations 171
2. Modify the search fields as required, and click [Search].

The Realtime Net Asset Value proofs dashboard is launched and displays
the proofs returned from the search. For example:
This dashboard contains a number of fields, including the following:
Field Description
Proof The account proof status, which can be any of the
Status following:
- Unbalanced
- Balanced
Category The category of the account.
Account The Account name
Currency The Account currency, denoted by a three letter code.
Ledger The Net Asset Value of the internal balance sheet.
NAV
Statement The Net Asset Value of the statements.
NAV
NAV The variance between the Ledger balance and the
Variance Statement balance.
NAV The difference expressed as a percentage of the Net Asset
Basis Value on the Statement side, multiplied by 100. 100 basis
Point points is 1%.
Variance
As At The date the proof was created
You can view further information on any proof displayed in this dashboard
by right-clicking on the proof and drilling down to the Proof Detail
dashboard. You can also drill down to the Proof Items dashboard to view the
balances captured at the time the proof was taken.
Creating and viewing Point In Time Net

Asset Value proofs
A point in time Net Asset Value proof provides a snapshot of an account’s Net
Asset Value proof at the time at which the snapshot was taken. They are created
upon completion of the automatic matching process when an account is
reconciled, or manually by the user.
Point In Time Net Asset Value Proofs are created and viewed in the same way as
standard cash and asset proofs. See chapter Managing
Reconciliations > Working with Proofs > Creating Point In Time proofs and
chapter Managing Reconciliations > Working with Proofs > Viewing proof
items.
172 NAV Rec Proofs
Viewing Net Asset Value Proof details

You can drill down to the Proof Detail dashboard from either the RealTime or
Point in Time Net Asset Value Proofs dashboards.
You can use the Proof Details dashboard to view the detailed statement, ledger,
Proof and Basis Point Proof data captured by a Net Asset Value proof. For
example:
This dashboard contains a number of fields including:

Field Description
Fixed Income The value of Fixed income payments.
Options The value of Options.
Short Term The value of Short Term payments.
Equities The value of the cash balances, unrealised options and any other
unrealised balances.
Futures The value of unrealised futures.
Forwards The value of Forward payments.
Miscellaneous The value of any other balances.
Cash The value of Cash balances.
Cash The value of outstanding cash items.
Outstanding
Net Asset The resulting Net Asset Value of all balances.
Value
Basis Point The difference for each balance expressed as a percentage of the Net
Proof Asset Value on the Statement side, multiplied by 100. 100 basis
points is 1%.
Working with General Ledger (GL)
Reconciliations
General Ledger (GL) reconciliation is a corporate accounting process to

substantiate the General Ledger balances (both STAT and GAAP) through the
loading of Sub Ledger balances and entering reconciling items. The process runs
in periods defined by the organisation in a fiscal calendar, typically either
monthly or quarterly. The fiscal period being reconciled will commence after the
close of that fiscal period, and the organisation can determine a period in which
to perform that reconciliation, for example in a monthly processing cycle,
January data would be processed in February.
TLM Reconciliations-Premium supports GL Reconciliations, including loading
and balancing of GL data, creating GL proofs, managing proof approvals. This
functionality makes use of a ‘General Ledger’ reconciliation type.
The GL balance data is loaded into the database as Currency Position items.
This reuses the Positions Item Type, which requires the ‘Record Type Flag’ to
be set to ‘Proof Balance’.
GL Cash items are no different to standard Cash items; however they can be
created using the new Item Entry dashboard. The difference between a GL Cash
item and a ‘standard’ Cash item is the Reconciliation Type of the holding set. If
the Reconciliation Type is GL, the item is a GL Cash item. There is no
difference in the makeup of these items, just how the system makes use of them.
Ageing Items
During the load of items relating to the GL reconciliation process, an ageing
lookup is performed against the fiscal calendar to determine to the age date for
an item. This process is performed in addition to the standard ageing that is
already available, and is invoked using the custom POSTLOAD_PROCESS
processing hook during loading.
174 Working with General Ledger proofs
Working with General Ledger proofs

A new GL Proof Header is created as defined by the Fiscal Calendar. The PIT
Header drives the entire GL model. For example, the Scheduler will create PIT
headers for GL accounts that have the PIT header creation setting enabled, and
has Fiscal Calendar defined against it that has a (Period) Recs Start Date as of
tomorrow.
Only one header will exist for one period, and the creation trigger will be either
Automated on a scheduled basis, or Manual as needed. The typical way of
creating a Header will be on approval of the Header for the previous Period.
When a Proof is first created it has an Approval Status of New. When any of the
following actions are performed, the Approval Status is updated to In Progress:
• Add note
• Add attachment
• Insert GL Item
• Submit for Review
The GLR AUTO Period Header MakeInactive process checks for proofs with
reconciliations end date past current date and inactivates them. It can be
scheduled to run every day, which would mean that all GL proofs that are found
with a reconciliations end date earlier than today would be automatically closed.
The proof is moved to an approval status of Approved-Unreconciled, and the
Overall status is set to Inactive. The operation is displayed on the Audit trail of
the proof as Force Approved.
Scorecards
A scorecard is used as a measure of risk against a Proof Header. One scorecard
is created per unique ‘Opportunity’ across Message Feeds belonging to a
particular GL account. They track a number of rated objectives/criteria that are
either met, not met, or have not yet been evaluated. Scorecards are displayed as
part of the proof details, and are often used by approvers when determining
whether the proof is ready to be signed off.
A range of ‘Custom Criteria’ attributes are available for customising the
attributes that should be evaluated and displayed in the Scorecard tab as part of
the GL proof data. These criteria can have automated processes behind them that
test whether a particular test passes, or they can be for manual steps and used as
a checklist item that the user updates to Yes on completion.
When scorecard is first created, all values are initially set to Untested. When a
Refresh is subsequently performed, either manually or as a result of any of the
following operations:
• adding a note to a proof
• adding an attachment to a proof
• inserting a GL item
the criteria with automated processing behind them are tested, and the values are
updated to Yes or No accordingly. Manual criteria are not affected by the refresh,
that is, the status remains as Untested unless manually changed.
When the proof is approved, if all values are Yes or Untested, the status will be
set to Approved - Reconciled. If there are any No values among the criteria, the
status is set to Approved - Unreconciled.
Working with General Ledger (GL) Reconciliations 175
Before the final approval of the scorecard is processed, users should refresh the
scorecard so that the values of any automatic criteria are populated with the
latest values, and the approval status can be accurately determined.
Proof Audit
The following operations that are performed on proofs are audited:
• Balanced Approved
• Unbalanced Approved
• Reset On Loading
• Reset On Auto Assignment
• Reset On Manual Item Insert
• Submitted For Review
• Approved
• Force Approved
• GL Item Inserted
• Inactive
• Rejected
• Cancelled
• Reset On Regrouping
• Unfreezed
• Created
• Scorecard Updated
• Added Note
The audit details are displayed on the Audit dashboard, which is launched when
the Proof Details dashboard is selected.
176 Viewing GL Proofs
Viewing GL Proofs
There will typically be only one active General Ledger proof at any one time,
which is the proof for the fiscal period that is currently being reconciled. You
can also view inactive (old) GL Proofs.
Proofs become Inactive when the Overall Status is Frozen, the Approval Status
is Approved, and the Recs End Date for the Period is today.
To view GL proofs
1. From the Menu, select GL Reconciliations.
A search prompt is displayed.
2. Enter or select any values to help narrow down the search, or leave all the
fields blank to return all proofs, and click [Search].
The REC PIT Proof Summary Tree is displayed. For example:
3. Double-click the set or level in the tree for the proofs that you want to work
with.
A number of chart summaries are displayed. For example:
• If you want to view the Proofs By Status graph, click the Proofs by
Status tab.
• If you want to view the Proofs Balance Summary, click the Proofs
Balance Summary tab.
4. Double-click on the relevant bar in one of the graphs to display the details of
the associated proofs. For example:
This dashboard includes the following columns:
Column Description
Category The category to which the proof belongs.
Period The name of the fiscal period for the proof.
Set The set to which the proof belongs.
Doc Displays a paperclip icon if a document is attached to the
item.
Var Displays a green circle if the proof is within the specified
variance; displays a red circle if the variance is greater than
that specified.
Status The status of the proof. Can be one of the following:
• New
• In Progress
• Frozen
• Inactive
Auth The authorization status of the proof.
Reconciler The nominated reconciler for the proof.
st
1 Reviewer The nominated 1st reviewer for the proof.
2nd Reviewer The nominated 2nd reviewer for the proof.
Period Start The start date of the fiscal period.
Period End The end date of the fiscal period.
Proof Start The start date of the proof reconciliation period.
Proof End The end date of the proof reconciliation period.
Last User The user ID of the last user to have acted on the proof.
Last Date The date of the last action on the proof.
Last Action The last action on the proof.
Last Note The last note added to the proof.
Proof ID The unique ID of the proof.
178 Viewing GL Proofs
5. Double-click the row for the proof that you want to view the details for.
The Proof Detail dashboard is displayed. For example:
There are a number of additional tabs that display additional data:

• Items– displays details of the items that contribute to the proof balance.
For details see page 178.
• Scorecard – displays a set of scorecard criteria for each opportunity and
whether each criteria has been evaluated to true, false, or untested. For
• Notes – displays any notes that have been added to the proof.
• Attachments - displays any attachments that have been added to the
proof.
• Audit – displays audit details of all changes that have been made to the
proof.
Clearing proof items

The items tab displays details of the items that contribute to the proof balance.
For example:
If there is an item listed that should not be included in the proof calculation, it
can be Cleared. The cleared item then has no effect on the proof calculation.
If an item is cleared by mistake, it can be uncleared.
To clear an item from a proof

1. Select the Items tab.
2. Use the selectors on the left to select the item that you want to clear.
• Select the GLR WC Clear Item tool on the toolbar.
• Right-click and select GLR WC Clear Item.
The item status is marked with a status of Cleared, and marked with a blue
circle.
To unclear a cleared item

1. Select the Items tab.
2. Use the selectors on the left to select the cleared item.
• Select the GLR WC Unclear Item tool on the toolbar.

• Right-click and select GLR WC Unclear Item.
The item is reinstated and included in the proof calculation again.
Viewing Scorecards
One scorecard is created per unique ‘Opportunity’ across Message Feeds
belonging to a particular GL account. They track a number of rated
objectives/criteria that are either met, not met, or have not yet been evaluated.
The status of each of the criteria is displayed on the Scorecard tab. For example:
The icons displayed mean the following:
- criteria failed
- criteria passed
- criteria untested
Some criteria might be for manual tasks, and therefore not updated automatically
by the system. These criteria can be updated manually.
To update the scorecard

1. Select the Scorecard tab.
2. Right-click on the row for the opportunity that you want to update some
criteria for and select Update Scorecards.
The Edit window is displayed. For example:
3. Use the dropdown list for the relevant criteria to change the status.
4. Click [OK].
5. The criteria are updated accordingly.
180 Searching for a GL Proof
Searching for a GL Proof

You can search for a specific proof using the Proof Ad Hoc Search.
To search for a proof

1. From the Menu, select Ad Hoc Searches > Proofs Ad Hoc.
The following search prompt is displayed:
2. Select the Reconciliation type of GL Recs, and enter any other values to
help narrow down the search.
3. Click [Search].
The REC PIT Proof Ad Hoc dashboard is displayed, showing the results of
your search.
Manually adding GL items

You can insert new or edit existing Item or Balance (currency position) data.
This is typically used where you know you are expecting a particular amount and
until it is received the proof cannot balance to 0 (zero). You should add some
evidence as to where the expected amount will come from when creating the
item. The item is created as an outstanding Ledger item.
The changes made are subject to validation to check that values are correct. This
form bypasses the normal GMMI interface as there is no message, and this is
always a single item or balance per use.
When creating a new item or balance, it is automatically linked to the in-
progress Proof Header, provided that is still open (that is, not Frozen). If an item
is added, all proof information and calculations are reset and recalculated.
The Item form can be used only to create items in a Set identified as a General
Ledger Reconciliation Type.
After adding the item, you would typically add an attachment that justifies why
the manual item is required.
To manually add a GL item

1. From the Proofs By Approval dashboard, right-click on the proof for which
you want to add a GL Item and select Insert GL Item.
The Insert GL Item dashboard is displayed. For example:
2. Enter the required data in the fields, as described in the following table:
Field Description
Classification Configurable Classification. Can be one of:
• Open
• Recorded
• Unreconciled
Feed ID Select the Message Feed from the list, from where the
Currencies will be taken, if automatic amounts are
selected.
Code The Message Feed short code, automatically
populated when the Feed ID is selected.
182 Manually adding GL items
Field Description
Item Type Type of item. Can be one of:
• GL Credit
• GL Debit
• SL Balance
• SL Credit
• SL Debit
Reason The reason that the manual item is required,
automatically populated when the Reason ID is
selected.
Reason ID Select the reason that the manual item is required.
Transaction Date Select the date of the transaction.
Entered Currency Select the applicable currency from the list.
Entered Amount Enter the relevant amount for the item.
Description Enter a description of the item
Functional Currency Select the applicable function currency from the list.
Note that this currency will be taken from the message
feed for revaluation.
Local Reporting Ccy Select the applicable reporting currency from the list.
Note that this currency will be taken from the message
feed for revaluation.
Automatic Amounts If yes, the currencies will be taken from the message
feeds and the amounts automatically evaluated.
If no, currencies and values must be entered manually.
Functional Amount Functional value. Affected by Automatic Amounts
Local Reporting Local Reporting value. Affected by Automatic
Amount Amounts
Corp Reporting Corporate Value. Affected by Automatic Amounts
Amount
Transaction Reference for the transaction.
Reference
Owner Select the user ID of the owner
Estimated clearing Date for estimated clearing. Will be after the start of
date the reconciliations period.
Item Actual Clearing Date for actual clearing. Will be after the start of the
Date reconciliations period.
PL Impact Profit/Loss Impact
PL Impact Flag Flag Profit/Loss Impact – yes or no.
3. Click [Save]
The item is created on the relevant account.
To attach a document
1. Right-click on the item that you have just created and select Add
Attachments.
The Add Attachment window is displayed. For example:

[Open].
The document is attached to the new item.
Editing GL Items
You can edit GL items directly in an item details grid, or you can edit them using
a form. For details see chapter Managing Reconciliations > Other matching
tasks > Editing items > Editing rows.
All of the fields can be edited, except for the following:
• Item Type
• Amount
• Functional and reporting currencies
• Item owner
• Age
• Item resolution
• Audit fields
Using the form you can also add additional data to the item, such as additional
references and clearing dates.
184 Manually adding GL items
To edit GL items using a form

1. In an item details grid use the selectors on the left to select the items to be
edited.
2. Right-click and select Edit.
The Edit dashboard is displayed. For example:
3. Edit the required values.

4. Click [Save].
Clearing manual items

If you have manually created a GL Item or Balance, this will remain in the
system with a status of Outstanding. When the real item is loaded into the
system, the manually-created item is no longer required, and can be cleared. The
Reconciliation Status of a cleared item is set to Cleared. It then has no affect on
the proof calculation.
Cleared items can also be uncleared, meaning that they are put back into a state
of Outstanding, and will affect the proof calculation.
To clear a manually-created GL item

1. Search for the Item that you want to clear.
2. Select the item in the details grid using the selectors on the left.
3. Click the Clear button on the toolbar, or right-click and select Clear.
To unclear a cleared GL item

1. Search for the Item that you want to unclear.
2. Select the item in the details grid using the selectors on the left.
3. Click the Unclear button on the toolbar, or right-click and select
Unclear.
186 Copying items
Copying items
For statutory reconciliation, it is sometimes useful to manually copy a record
from a non-statutory account to a statutory account and vice-versa where
necessary.
The copy function is only available for sets of reconciliation type General
Ledger. You can only copy items of this reconciliation type to a message feed
belonging to a General Ledger set, provided it is not in an exception.
The copied item is a wholly new version with the same data attributes and has a
link to the original item.
Constraints for copying

To be able to copy an item, the following constraints have to be fulfilled:
• The item must have a reconciliation status of Outstanding, Matched or
Cleared.
• Only items that are Ledger Ccy Credit(Activity), Ledger Ccy
Debit(Activity), Stmt Ccy Credit(SL Activity), Stmt Ccy Debit(SL Activity)
or SL Balance(SL Balance can be manually inserted) can be copied.
Net and Writeoff items may not be copied.
• Items cannot be copied if they are linked to an open exception.

• Only items that belong to a set of reconciliation type ‘General Ledger’ will
be available to copy.
• Only the user who has the Reconciler role assigned can copy. However, this
restriction can be extended during implementation as required allowing
other users to have execution rights.
• Only copy if the current proof status of the destination set is either New or
In-Progress.
• The message feed to be copied must exist in the target set selected and is
located in the destination General Ledger set.
Selection of target set/message feed

The message feed to create the copy into is selected by the user on execution of
the copy. In order to keep the selection as simple as possible for the end user,
some new fields of data is available to facilitate this process.
It is possible to specify a target set/message feed for copy at both the set and the
message feed level. Auto Assignment functionality is extended to have the
ability to assign the target set/message feed using custom implementations.
Additionally, the standard administration functions allow you to edit the target
set/message feed. This helps to potentially avoid the need to select a target
set/message feed manually, although it ispossible to override the default values if
necessary.
Furthermore, additional validations are in place if to validate the selection just in
case the overridden selection is invalid for the source set/message feed.
When items are selected for copying and the dashboard is launched for selection
of target set/message feed (see screenshot above), the target set/message feed is
auto populated depending on the selection of the source data, i.e. if the source
set/message feed already has a direct link to the target set/message feed (setup as
part of the AA process), then the target details will be auto populated. If none of
the links are setup, then the approach for selection is to set first followed by
message feed, i.e. user can first select the set using the chooser which displays
all the sets in the system and then select the message feed using the chooser
which displays a list of message feeds that belong to the set selected earlier.
188 Copying items
Data, that cannot be copied

All data attributes of the original item are copied with the following exceptions:
• Data used to identify the set/account/message feed (corr_acc_no, short_no)
• Item IDs
A new ID will be generated for the copied item.
• System entry date
The entry date of the copied item is the day when it is copied.
• Direct links to relationships or any other status indicator (e.g. reconciliation
status) are reset to 0.
The copied item won’t have a link and receives the status Outstanding.
• Item ageing
The item ageing of the copied item will be re-evaluated with the Calendar
details for the target set.
• Item audit
• Items of more than one set cannot be copied
• Items of more than one message feed cannot be copied
• M-M items
• Items of different types
All items that are selected to copy must of same type, this ensures that it can
be copied to one Message Feed. (i.e. all ledgers to ledgers, all statements to
statement types).
Item Audit
In the Item Audit window it is indicated that the item has been used for copying
or it is a copy of another item.
Active proofs
The creation of the new item resets any active proof of the target account.
To copy items
1. Select Menu > Ad-Hoc Searches > Items Ad-Hoc.
The Search Prompt - REC Items Ad-Hoc window is displayed.
2. Enter your search criteria and click [Search].
The REC Items Ad-Hoc dashboard is displayed.
3. Select the items you want to copy.
4. Right-click to select Item Bulk Copy.
The Item Bulk Copy window is displayed.
5. Select the Target Set.
6. Select the Target Message Feed.
7. Click [Copy].
Re-measurement Processing
If a set is defined that it requires the re-measurement processing, it derives a rate
that is used on all substantiating items entered for that period or reconciliation
process.
The re-calculation is based on the current General Ledger balance in the original
currency, the current MOR (i.e. the known operating rate) and data from the
previous period (the original and reporting currency balances).
The following diagram illustrates the flow of processing done to calculate the
rate to be used for substantiating items.
getGLPreviousPeriodDetails – Get OC Balance and RC Balance from the

previous period.
getGLCurrentPeriodDetails – Get OC Balance and Monthly Operating Rate
(MOR) of current active period.
calculateReMeasurementValues – This is to calculate the following.
1. findNetChange – NetChange = Current OC Balance – Previous OC Balance
2. findExpectedChange – ExpectedChange = NetChange * MOR
3. findExpectedBalance – ExpectedBalance = ExpectedChange + Previous
RC Balance
4. calculateEffectiveRate – EffectiveRate = ExpectedBalance / Current OC
Balance
persistDetails – This will persist the calculated EffectiveRate into database for
the Period
Process trigger
When General Ledger balances of the current period are loaded automatically
into the system, the re-measurement process is executed.
A flag at the set level indicates whether it is to be done or not.
Opening position – On-boarding

To on-board a set for this processing it is necessary to disable the Re-
measurement processing using the administration option and load the General
Ledger balance for the newly created set for the previous General Ledger period.
Then enable the Re-measurement processing for the set if required and load as
normal.
190 Re-measurement Processing
Storage of the rate

Rates are recorded on the period that it is calculated for. It will be over-written
when a newer General Ledger balance feed has been loaded or when any other
reason results in re-calculating the rate.
Usage of the rate

Once the rate has been calculated and stored for the current period, all items
inserted for substantiation will make use of the rate to derive the item’s reporting
currency value. You can override it manually in the insert item form, if required.
If the rate is re-calculated after substantiating items have been created for the
current period, those items will have their reporting currency amount re-
calculated.
Re-grouping message feeds

If a message feed has been re-grouped into or out of a set with the re-
measurement processing enabled, it is necessary to trigger a refresh calculation
of the re-measurement rate.
GL Proof approval process

A GL proof is created for each GL account (set) at the start of the reconciliation
period. On completion of the reconciliation, the Reconciler can submit the Proof
for formal review which can be a 1- or 2-step process as defined on the Account.
A proof must balance to 0 (zero) before it can be submitted for review. This
might require that you create a manual GL item to make the proof balance. For
Submitting a proof for review

When the reconciler submits a proof for review, the data is frozen and a snapshot
of the Proof Header and all data associated with it is captured. The data stored
includes:
• Proof Header and details
• Set and Message Feed data
• All Scorecards
• All notes / attachments for that Header
• All balance items
• All outstanding item data, and notes / attachments for them
The status of the Proof Header Overall Status is changed to ‘Frozen’.
To submit a proof for review

1. From the Proofs By Approval dashboard, select the proof that you want to
submit for review using the selectors.
• Click the Submit for Review tool on the toolbar.

• Right-click and select Submit for Review.
All Proof data is frozen.
If you have implemented a 2-stage approval process, the Approval status is
updated to First Review. If you have implemented a 1-stage approval
process, the Approval status is updated to Final Review.
192 GL Proof approval process
Cancelling a proof submitted for Approval

The reconciler has the option to cancel a Proof that they have submitted for
review at any time up until the Proof is approved by the final reviewer. This may
be required where new information has been received that affects the fiscal
period. The proof data is unfrozen and the approval process is restarted.
To cancel a proof that you have submitted

cancel using the selectors.
• Click the Cancel tool on the toolbar.

• Right-click and select Cancel.
All Proof data is unfrozen and the Approval status is updated to In Progress.
Approving a proof
The designated reviewers, at both the first review and final review stage, have
the option to approve the proof.
To approve a proof
approve using the selectors.
2. Before the final approval of the scorecard is processed, refresh the scorecard
so that the values of any automatic criteria are populated with the latest
values, and the approval status can be accurately determined. Do one of the
following:
• Click the Refresh Scorecard tool on the toolbar.
• Right-click and select Refresh Scorecard.
3. To approve the proof, do one of the following:
• Click the Approve tool on the toolbar.

• Right-click and select Approve.
If you have implemented a 2-stage approval process and this is the first
approval, the Approval status is updated to Final Review. If you have
implemented a 2-stage approval process and this is the final approval, the
Approval status is updated to Approved.
If you have implemented a 1-stage approval process, the Approval status is
updated to Approved.
Rejecting a proof
The designated reviewers, at both the first review and final review stage, have
the option to reject the proof.
To approve a proof
reject using the selectors.
• Click the Reject tool on the toolbar.

• Right-click and select Reject.
Unfreezing a proof
Proofs with an Approval Status of Approved can be ‘unfrozen’ if, for example,
new data has been identified that needs to be added. Proofs can be unfrozen only
up until the Reconciliation End date, as defined by the Fiscal Calendar for the
Header. When unfreezing a proof, all frozen data in ITEM, MESSAGE_FEED
and BANK for that proof will be deleted.
To unfreeze a proof
unfreeze using the selectors.
• Click Unfreeze tool on the toolbar.

• Right-click and select Unfreeze.
The overall status is updated to Active.
194 Revaluation
Revaluation
You would typically revalue items where the applicable currency rates have
changed since the item was loaded.
Revaluating values converts the base item amount (stored in the amount field,
with the corresponding currency in the currency field) to Local Reporting,
Corporate Reporting and Functional equivalents. The actual currencies must be
supplied in a message feed; they cannot be entered manually. If no currency is
present for the Local Reporting, Corporate Reporting or Functional currency,
that field will be empty on revaluation.
The process directly converts the amount for each of the following attributes,
into the corresponding currency:
Amount Amount field Currency field
Functional Amount amount_6 currency_6
Local Reporting amount_3 currency_3
Amount
Corp Reporting amount_2 currency_2
Amount
As part of this processing, the rates between the base currency and the
item.currency_6 for example, are identified using the rate configured in the
Currency Rates Group for the Set. If a Currency Group is not configured for the
Set, a warning is displayed stating that the currency conversion cannot complete.
These other currencies can be reviewed when you are looking for a missing
amount in a different currency to the base currency.
To revalue items for updated currencies

1. In an item details grid, such as Items by Status use the selectors on the left to
select the item that you want to revalue
2. Select the Revalue GL Item tool on the toolbar, or right-click and select
Revalue GL Item.
Software Support
More information about SmartStream Technologies software can be found in the

product documentation supplied with the product.
If you are unable to find the answer to your question in any of these resources,
contact SmartStream Technologies Support. Details are given below.
Calling SmartStream Technologies Support

Before you call, you should consult the Before you call... checklist given on page
2, to ensure that you have all relevant information to hand.
Area Postal Address Contact Details
Europe SmartStream tel: +44 (0) 1454 888485
Technologies fax: +44 (0) 1454 888486
1690 Park Ave email: ssrsup.uk@smartstream-
Aztec West stp.com
Almondsbury
Bristol, BS32 4RA
UK
North and South SmartStream tel: +1 212 763 6505
America Technologies tel (US internal): 877 215 8227
61 Broadway fax: +1 212 763 6501
Suite 710
New York email: ssrsup.usa@smartstream-
NY 10006 stp.com
USA
Australia and Asia SmartStream tel: +65 6224 7689
Technologies fax: +65 6222 4039
80 Robinson Road email: ssrsup.sea@smartstream-
#11-01A stp.com
Singapore
068898
2 Before you call...
Before you call...

You will be asked... Notes
Your name and your You must have already been registered with SmartStream
company name Technologies Support Desk by your main support contact,
otherwise the call will not be accepted
Software type: test or If this is a test issue, it will be treated as a chargeable call
production? unless a software bug is proven.
Software version number Can be found by selecting Help > About from the software
menu.
RDBMS Type & Version Confirm RDBMS Type (Sybase/Oracle/SQLServer) and
Version.
Server Operating System Confirm operating system (UNIX or Windows) and
- Type & Version Version.
Priority of call (1 to 4) Based on business criticality.
1 - Unable to process any transactions.
2 - Partially inoperable - transactions restricted
3 - Operational but functionally impaired
4 - Cosmetic problem or enquiry
Full description of Please provide as much detail as possible
problem being
experienced
Any supporting screen This information should be sent to your nearest support
shots, reports or server centre as listed above. Please ensure that the Heat call
logs that may help reference that you will be provided with is clearly
identify your problem indicated on any emails and faxes.
Can you reproduce the Yes or No.
problem?
Has this problem Yes or No.
occurred before?
Customer Call ref. Please provide us with your own call reference if you have
(optional) one.
Glossary of Terms
Alerts
Notify users about potential error conditions that have not yet occurred, but can
occur in future.
Audit Trail
A record of all the operations performed on the account.
Cash Balancing
The reconciliation of cash or currency accounts. Cash balances are calculated for
each account currency. Cash account balances are reconciled between your
General ledger balances and those of your account servicer. Moreover balances
are tested to ensure that they flow from closing to opening and then again to
closing balance positions across and within accounting days.
Contact
A user who is going to work on exceptions and reconciliations.
Contact Group
A group of specific type of contacts.
Dashboard
A window that displays a graphical view of the items in the database, in the form
of charts, grids or treeviews.
Dashboard control
The individual element of a dashboard, for example, grid, form or treeview.
Dashboards can contain several controls.
Escalation
An Escalation is raised in the form of an Alert, when the required conditions are
not met in the defined time duration.
Exception
An exception is raised when a match is outside the allowed match tolerance.
2 Glossary of Terms
GEMS server
The GEMS (Generic Messaging System) server loads incoming messages into
the database tables. The contents of these tables are then checked by GEMS to
make sure that the information is as expected and if it is, the data is flagged as
validated and can be processed further within the system.
Inbox
A workfolder used to allocate and sub-divide work.
Item
The cash or security position message once stored in the database is known as an
item.
Knowledge Base
(KB) - Used by GEMS to load files to the database. Defines how incoming data
is to be mapped to the database.
Lead Account
A Lead Account, identified by the Financial Lead Parameter on an Account, has
a configurable Write-off amount. During processing, the lead account for the
account being processed is identified, and the amount is compared to the net
total of the current group.
Lead User
A Lead User has a configurable Write-off amount. During processing, the lead
user for the current user is identified, and the amount is compared to the net total
of the current group.
Lifecycle
The set of pre-determined stages that an Item passes through during its life on
the TLM OnDemand system.
Matches
The reconciliation of items with one or more common data values. A match will
include two or more items, with at least one from your side and one from your
Custodian, counterparty or correspondent bank.
Netting item
New item created to reflect an amount difference in a match. Further items
forwarded for reconciliation can then be matched against the netting item.
Product
Data enrichment feature that allows you to relate a code on an incoming item
with something more meaningful to your organisation such as the method of
financial transaction, for example, shares, bonds or units.
Glossary of Terms 3
Quality Rules
A rule that tests items' attributes to determine how good a match they are
(quality) and therefore which Relationship Type the items are assigned to. These
rules also determine whether the items are to be automatically matched.
Reason Type
Explains the cause of an exception and can be attached to an exception.
Reconciliation
Comparing two sets of data and ensuring that they match.
Relationship Type
Used to define groups of a specific type.
Relationships
Matched items are grouped in a relationship.
Release
The reconciling of items to history. Also referred to as matching.
Resolution Type
Indicates the course of action undertaken to resolve an exception
Securities
The financial products that are traded between institutions in the form of shares,
bonds, warrants and other forms of stock, on behalf of asset managers or global
custodians.
Session
Identifies the commencement of a matching process.
Set type
Type determines whether a set is a Cash or Securities.
4 Glossary of Terms
Trial balance
Provides a '‘snapshot'’ of the balances and volumes of data. This information
should be in balance normally and the screen is generally used to identify any
currencies or assets that are out of balance and that might require corrective
action. The displayed data is for information purposes only and cannot be
amended.
Universe
A collection of attributes that relate to an entity in the TLM OnDemand system.
Examples of universes include Item, Case Summary, Message Header and
Message Type.
A match 65
Exceptions 150
General Ledger Proofs 192
Changing grid view 24
Changing password 10
Index Clearing
General Ledger items 185
Clearing proof items 178
Closing
Resolved exceptions 151
Copying
Exceptions messages 139
Creating
Exceptions messages 137
Creating exceptions 85
A Creating proofs 95
Adding
General Ledger items 181 D
Adding notes to items 87
Ad-Hoc Item Exceptions Search 155 Dashboards
Closing 19
Ad-Hoc Items Search 80 Launching 14
Ad-Hoc Matches Search 78 Overview 13
Aggregates and grids 26 Resizing 15
Alert Ad-Hoc Search 159 Setting as default 18
Alerts 115 Data
Searching for 159 Exporting 35
Approving Filtering 30
Items and matches 75 Refreshing 16
Proofs 103 Deleting
Approving General Ledger Proofs 191, 192 Items 71
Attaching documents 24, 143 Detaching
Audit of GL proofs 175 Exceptions messages 139
Audit proof details 103 Detail dashboards 56
Audit trail Document attach 24, 143
Overview 46 Viewing documents 144
Viewing 46 Downloading documents 144
Viewing items 47
Viewing notes 46
Working with items 47 E
Authorising
Exceptions messages 142 Editing
Items 75 Exception details 130
Items and matches 75 General Ledger items 183
Matches 76 Rows 90
Proofs 103 Editing multiple items 92
Authorising reconciliations 106 Error messages 48
Resubmitting request 108 Exception details 130
Exception management
Alerts 118
B Automatic management 118
Basic concepts 116
Bulk editing Bulk edit fields 147
Exception bulk edit fields 147 Cancelling an exception 150
Items 92 Closing resolved exceptions 151
Multiple exceptions 147 Exception types 119
Business Logic tools 43 Excpetions lifecycle 116
Icons 45 Inboxes 117
Progress window 44 Introduction 115
Reopening exceptions 152
Resolving 149
C Searching for ad-hoc item exceptions 155
Searching for alerts 159
Cancelling Searching for exceptions 157
2 Index
Taking ownership of exceptions 152 Keyboard navigation 21

Unassigning owners 153 Selecting records 21
Viewing notes 146
Working with exceptions 129
Exception manahement H
Searching exceptions and alerts 154
Exception messages 118 Help 11
Exceptions
Adding items to 148
Attaching documents 143 I
Bulk editing 147
Creating 85
Inboxes 117
Viewing 85 Internet security 36
Viewing documents 144 Items
Exceptions Ad-Hoc Search 157 Adding notes 87
Adding to existing exceptions 148
Exceptions message audit 135
Authorising 75
Exceptions message details 135 Bulk editing 92
Exceptions messages Deleting 71
Authorising 142 Fast-cutting 84
Copying 139 Linking 88
Creating 137 Matching 64
Detaching 139 Recalling 68
Field descriptions 141 Rejecting 75
Managing 133 Removing from pending matches 67
Searching 136 Splitting 69
Sending 140 Taking ownership 93
Viewing 134, 138 Unassigning owners 93
Excpetion management Undeleting 72
Adding notes to exceptions 145 Unlinking 89
Exporting data 35 Viewing item details 83
Items authority summary 75
F
Filtering data 30, 34
K
Forms 41 Keyboard navigation in grids 21
Full-text searches 11
L
G
Lifecycle
General Ledger Reconciliations 50
Proofs 174 Lifecycle authorization 106
General Ledger items Linking items 88
Adding 181 Logging off 12
Clearing 185 Logging on 6
Editing 183
General Ledger Proofs
Approval 191
Approving 192
M
Audit 175 Main menu 8
Cancelling 192 Managing
Items 178 Exceptions messages 133
Rejecting 193 Match
Scorcards 179 Other tasks 82
Searching 180
Match details 74
Submitting 191
Unfreezing 193 Matching
Viewing 176 Adding items to exceptions 148
Authorising and rejecting 76
Getting Started 5
Cancelling a match 65
Graphical decodes 34 Deleting an item 71
Grid aggregate icons 26 Introduction 58
Grids Match details 74
Changing the view 24 Matching items 64
Introduction 20 Opportunity cost 61
Index 3
Pending matches 65
Recalling items 68 R
Removing items from pending matches 67
Realtime proofs
Searching for items and matches 77
Viewing 95
Splitting items 69
Viewing details 98
Undeleting an item 72
Viewing items 101
Viewing details 73
Realtine proofs
Multiple item editing 92
Overview 94
REC Lifecycles dashboards 52
N Recalling items 68
Reconciliations
Navigating the menu 9 Detail dashboards 56
Navigation grids 21 Introduction 49
Notes Main reconciliations dashboards 52
Adding to exceptions 145 Matching 58
Adding to items 87 REC Lifecycles dashboards 52
Creating proof notes 104 Summary dashboards 55
Viewing 88 Reconciliations lifecycle
Viewing audit trail notes 46 Introduction 50
Viewing exception notes 146 Records 21
Viewing proof notes 105 Searching 17
Refreshing data 16
Rejecting
O General Ledger Proofs 193
Items 75
Online Help 11 Matches 76
Opening the menu 9 Rejecting authorisations 106
Opportunity cost 61 Reopening
Other matching tasks 82 Exceptions 152
Ownership Reports
Of exeptions 152 Introduction 110
Of items 93 Resizing dashboards 15
Resolving
Exceptions 149
P Resubmitting rejected reconciliations requests 108
Pending matches 65 Revaluation 194
Point In Time proofs Rows
Editing 90
Approving 103
Audit details 103
Creating 95
Creating Notes 104 S
Overview 94
Scorecards 174, 179
Viewing 95
Viewing details 98 Searching
Viewing items 101 Exceptions messages 136
Viewing notes 105 For alerts 159
For exceptions 157
Progress window 44
For exceptions and alerts 154
Proof For items 80
Audit details 103 For items with exceptions 155
Proof details 98 For matches 78
Proof items 101 General Ledger Proofs 180
Clearing 178 Introduction 77
Proof notes 104, 105 Proofs 102
Proofs Records 17
Approving 103 Second user authorization 106
Creating 95 Selecting records 21
Creating roof notes 104 Sending
General Ledger 174 Exceptions messages 140
Searching 102 Sorting data 28
Viewing 95
Splitting an item 69
Viewing proof notes 105
Submitting General Ledger Proofs 191
Summary dashboards 55
Support 1
4 Index
T
Toolbar icons 45
Tools
Progress window 44
Types of exception 119
U
Unassigning
Owners from exceptions 153
Owners from items 93
Undeleting
Items 72
Unfreezing
Unlinking items 89
V
Viewing
Exception details 130
Exceptions message audit 135
Exceptions message details 135
Exceptions messages 134, 138
Proof items 101
Scorecards 179
Viewing documents 144
Viewing match details 73
Viewing proof details 98
Viewing proofs 95
Views 24
W
Working with Dashboards 13

TLMRecsPrem2 4 1 1UserGuide

Uploaded by

Copyright:

Available Formats

TLMRecsPrem2 4 1 1UserGuide

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TLMRecsPrem2 4 1 1UserGuide

Uploaded by

Copyright:

Available Formats

TLM Reconciliations-Premium Version 2.4.1.

About this Guide ...................................................................... 1

Getting started with the software ........................................... 5

Using the Audit Trail .......................................................................................... 46

Managing Reconciliations .................................................... 49

Authorising and Rejecting Reconciliations ...................................................... 106

Managing Exceptions and Alerts ....................................... 115

Working with Exchange Traded Derivatives ..................... 161

Working with Net Asset Value Reconciliations ................ 167

Working with General Ledger (GL) Reconciliations ......... 173

Software Support ..................................................................... 1

Glossary of Terms ................................................................... 1

Welcome to the TLM Reconciliations-Premium User Guide.

Who should read this guide?

What does this guide cover?

How is this guide organised?

What's not included?

Conventions used in this guide

SmartStream Technologies support

TLM Reconciliations-Premium is delivered through TLM WebConnect, a web-

2. Enter your Username and Password.

5. Enter your current password in the Old Password field.

Using the main menu

The dashboards and special commands might be grouped into submenus.

Opening and navigating the menu

To open the main menu

To close the main menu

To navigate to a menu item

To change your password

2. Enter your current password in the Old Password field.

Using WebConnect Help

Windows XP security block

Rules for full-text searches

• Click to close the TLM WebConnect window.

2. Click [OK] to log off.

Working with dashboards

A number of screenshots are used throughout this section to demonstrate how to

Maximum row limit

However, closing existing dashboards and controls immediately frees up rows

2. Navigate to the dashboard you want to launch.

Launching child dashboards

If the dashboards are automatically refreshed by TLM WebConnect and you

To perform a manual refresh

• Right-click on the control's title bar and select Refresh.

Searching for records

To search for records

The following image shows an example of a search prompt for exceptions.

Setting a dashboard as default

To set a dashboard as the default

To close other dashboards in a space

All dashboards except the current one are closed.

To close all dashboards in a space

Working with grids

Keyboard navigation within grids

Performing actions on selected items

Changing the view

To configure your browser security settings

2. Click the [Browse] button.

Grid aggregate icons