Defining Accounts

Accounts are entities where the Accounting engine applies postings. Accounts are generally maintained in a General Ledger system at your organization. As the Accounting engine saves each posting, it labels the posting with an account number. These postings will then be fed into the General Ledger system.

The link between accounting events and accounts will be specified using accounting rules.

See Call Accounts for information on creating call accounts for client cash management.

 

From the Calypso Navigator, navigate to Configuration > Accounting > Accounts (menu action refdata.AccountFrame) to define accounts.

 

1. Creating Accounts

The Account panel is selected by default, it allows creating new accounts.

» Click New, and enter the fields described below to create an account.
» Then click Save to save your changes.

Note that if the Authorization mode is enabled, an authorized user must approve your entry.

You can also click SaveAsNew to create the account as a new account provided you enter a new account name.

» You can select the Translation/Revaluation panel to specify the parameters to perform FX Revaluation and FX Translation.

See FX Revaluation and FX Translation for details.

 

Fields

Description

Account Name

Enter the name of the account that will identify the account throughout the system.

The account number can be directly populated by the account name, or can be generated automatically from user-defined attributes. The definition of automatic accounts is described below.

Call Account

The Call Account field only appears if environment property USE_CALL_ACCOUNT = true.

When Call Account is selected, a new Legal Entity field is displayed for Client Sender. This field displays options to search Legal Entities with role as 'ClientSender'.

See Call Accounts for information on creating call accounts for client cash management.

Custody

The Custody field should only be used in the context of Security Custody functions.

Please refer to Calypso Client Security Custody documentation for details.

Processing Org

Select the processing organization that holds this account, or ALL.

A SETTLE account is restricted to a specific processing organization, unless it is automatic. For automatic SETTLE accounts, you can select AUTO. The account numbers will be automatically created by processing organization. The definition of automatic accounts is described below.

Ccy

Select the currency of the postings to this account or ANY.

A SETTLE account is restricted to a specific currency, unless it is automatic. For automatic SETTLE accounts, you can select AUTO. The account numbers will be automatically created by currency. The definition of automatic accounts is described below. For SETTLE accounts, ANY is not supported.

For SETTLE security accounts, the currency is not used.

Id

Unique id given by the system upon saving.

Type

Select the type of the account. The following types are associated with specific processes.

CLOSING — This is an end-of-year closing account.
LINK — This is a temporary account that can be used to balance or offset accounting entries.
SETTLE — This account is used for settlement and delivery instructions. It also identifies customer accounts. Settlement accounts can be associated with statements, billing, interest bearing, and limits.

See Defining Settle Accounts for details.

STOCK — This account is used in defining stock ledger type accounting (physical accounting).
SUSPENSE — This account is used to store short-term funds or securities until a permanent decision is made about their allocation.

Click ... to add new types of account as needed.

Subtype

Only applies to SETTLE accounts.

This is currently only used for ETD Clearing.

Please refer to Calypso ETD Clearing documentation for details.

Security

This field only appears for SETTLE accounts.

Check the Security checkbox to indicate that the account is a security account.

Auto/Template Acc

Check the “Auto/Template Acc” to create account numbers based on user-defined attributes for this account.

See Defining Automatic Accounts for details.

Orig Acc

This field only appears when you load an account number that has been automatically generated. It displays the id of the original account definition.

External Name

Enter an external name as needed. It can be used when exporting postings to the general ledger.

You can click  to load the external name definition if any. External names can be defined using Utilities > External Name.

Interface Rule

Select the rule for exporting postings on this account to the general ledger:

Aggregate - All postings on this account should be aggregated.
Detail - All postings should be individually processed.

Description

Enter a free field to describe the account.

Legal Entity (F2)

Optional.

Click ... to select the owner of the account. This is mostly used for settlement accounts to identify the agent / customer owning the account.

You can also hit F2.

Role

Select the role of the legal entity that owns the account, if applicable. You can select ALL otherwise.

Multi-Owner

For the Client role, you can define multiple owners in the Legal Entities panel.

This only applies to Security Custody.

Please refer to Calypso Security Custody documentation for details.

Creation Date

Displays the date when the account was created.

Create by Acc Engine only

This checkbox only appears for automatic accounts.

If checked, the automatic account number will only be generated by the Accounting engine. If not checked, the automatic account number can be generated by both the Accounting engine and the Transfer engine.

Closing Account

Click ... to select a closing account as applicable.

See End of Year Account Closing for details.

Last Closing Date

This is related to the End of Year Close function. It stores the last closing date.

See End of Year Account Closing for details.

Parent Account

Click ... to select a parent account as applicable. This allows creating account hierarchies. The Account Balance report allows aggregating accounts based on account hierarchies. Help is available from the report.

Parent Id

Displays the id of the selected parent account.

Balance

Check the Balance checkbox to specify that the account can generate balances.

You will be prompted to define the balance frequency.

» Select a frequency from the Freq field or click ... next to the Rule field to select a date rule. Date rules allow generating dates based on complex frequencies.

If you have selected a weekly or monthly frequency, you can select the day of the week or month in the Day field.

» Select the date roll convention from the Roll field as applicable. See Help > Date Roll Conventions for details. The balance date will be rolled according to the selected date roll convention when it falls on a holiday.

See Computing Balances for details.

 

2. Defining Automatic Accounts

The account number of automatic accounts is generated automatically from user-defined attributes. For example, an account number can be a combination of constants, trade attributes, etc.

You should create automatic accounts when you can identify a pattern in the chart of accounts. For example, a group of accounts start with 222, then contain the product type and the currency.

Once you have checked the “Auto/Template Acc” checkbox, select the Attributes panel to define the attributes.

» Click Add to add a new attribute, and enter the fields described below.
Order - Enter the order of the attribute.
Attribute - Select an attribute name, or “Constant” to specify a constant.
Value - Enter the value for Constant attributes.
» You can also click CopyFrom to copy the attributes from another account, you will be prompted to select an account.

 

Under the panel Translation/Revaluation, you can set the parameter "Propagate" to true, to propagate all the account attributes ("Attributes" panel) and properties (Properties/Attributes (f4) button) set on the "parent" account to the automatic accounts generated by the "parent" account.

If you do not want to propagate some of the attributes, you can add them to the domain "accountAutoAttributes.PropagateExclude".

 

 Ⓘ   [NOTE: For automatic SETTLE accounts, the processing org must be a specific processing organization or AUTO, and the currency must be a specific currency or AUTO - When you select AUTO, the account numbers will be automatically created by processing org and/or currency based on the selected attributes]

 

3. Defining Account Properties

Account properties can be used for selection and reporting purposes. They are user-defined.

Load an account and specify account properties as applicable.

» Enter the property value in the Value field.

If you want to specify a list of possible values for a given property, create the domain “accountProperty.<attribute name>”, and add the values to that domain - The name is case sensitive.

» You can click to define favorite properties. You will be prompted to select favorite properties.

When Utilities > Show All Properties is checked all properties are displayed.

When Utilities > Show All Properties is unchecked, only favorite properties are displayed.

» You can choose Utilities > Add Property Domain to add new properties.

 

4. Defining Settle Accounts

When a SETTLE account is defined, additional functions are available: management fees generation, statements generation, interest generation, sub-accounts, and limit checking.

See Cash Management for complete details.

 

 

4.1 Status and Account Validity Period

» Select a status as applicable. Account status codes can be added using Utilities > Add Account Status Domain, Utilities > Add Account Active Status Domain for active accounts, Utilities > Add Account Closed Status Domain for closed accounts, Utilities > Add Account Pending Status Domain for pending accounts, or Utilities > Add Account Suspended Status Domain for suspended accounts.
» Enter the Active From and Active To dates for defining the account’s validity period. Postings can only be back-dated after the Active From date. When an account becomes inactive, you will be prompted to de-activate the SDIs in which the account is used, if any.
» You can check “by Trade Date” to set the effective date to the posting’s trade date. Otherwise, it is the value date.

 

4.2 Account Closing Balance Check

To enable the balance check when closing SETTLE accounts, you need to set Comment=true, for the value CHECK_CLOSE_SETTLE_ACCOUNT in the domain “AccountSetup”.

When enabled, it is no longer possible to manually set the Active To date on a SETTLE account, or the status to a status defined in the domains “accountSuspendedStatus” or “accountClosedStatus”.

The closing process in this case, is a two-step process.

 

Step 1 - You first need to suspend the account using Process > Closure Process > Close from the Account window. You will be prompted to enter the Active To date. It will be set on the account, and the SDIs that use this account. The account status will be set to the status defined in the domain “accountSuspendedStatus”.

 

Step 2 - On the Active To date, manually change the account status to the status defined in the domain “accountClosedStatus”.

Upon saving, the system will check that there is no transfer in the future. If any, a Transfer report will be displayed with the future transfers. You may reassign those transfers to different accounts as needed.

The system will check that all inventory positions for this account are zero. The inventory positions to be checked must be added to the domain “InventoryClosurePositions”. If not set, it will check the positions defined in the domain “InventoryPositions”. If any, an Inventory Position report will be displayed with the non-zero positions.

 

4.3 Retroactivity

» Click  ... to select a date rule for defining the retroactivity period for Account Sweeps and Interest Scales.
Account Sweeps: If the Retroactivity field is empty, there is no retroactivity.
Interest Scales: The Scheduled Task ACCOUNT_INTEREST has an attribute which allows managing retroactivity. If this attribute is set to ‘true’, the system takes into account the Retroactivity date rule on the Account, and if no rule is set-up, the limit is one year.

 

4.4 Interest Bearing

Interests can be calculated on settle accounts.

» Check the “Interest Bearing” checkbox to allow the calculation of interests.
» Then select the Interests panel to associate interest rules with the account. Interest rules are defined using Process > Interest Bearing > Interest Config Window.

See Cash Management - Interest Bearing for complete details.

 

4.5 Billing

Management fees can be calculated on settle accounts.

Check the Billing checkbox to allow the calculation of management fees.

See Cash Management - Management Fees for complete details.

 

4.6 Sub-Accounts

A sub-account can be defined with a proprietary account (parent account), and a subtype.

Sub-account types can be defined in the domain "SubAccountType".

 

A proprietary account is an account defined with "Is Proprietary" checked, and with the same legal entity as the sub-account.

 

You can select sub-accounts in SDIs in place of the G/L accounts.

You can display sub-accounts in the Transfer Report and the Inventory Position.

 

4.7 Statements

Select the Statements panel to define statement generation. Statements can be generated on the Back Office position calculated by the Inventory engine.

Note that statements can be created only for accounts that have a processing organization, a currency, and an account owner (legal entity and role must be specified).

See Cash Management - Account Statement for complete details.

 

4.8 Limits

Select the Limits panel to define overdraft limits as needed.

» Enter a minimum credit balance, an overdraft limit, and the Active From and To dates as needed.
» Click ... next to the Limit Review field to select a date rule for defining the frequency to update the limits.
» Click Add. Then click Save.

See Call Accounts for complete details.

See Cash Management - Interest Bearing for complete details.

 

4.9 Consolidation

The Consolidation function is only available to call accounts.

See Call Accounts for information on creating call accounts for client cash management.

 

4.10 Clearing

The Clearing function is only available for SETTLE accounts of subtype Clearing. It currently only applies to ETD Clearing.

Please refer to Calypso ETD Clearing documentation for details.

 

5. Modifying Accounts

Select the Browse panel.

» Enter search criteria and click Load to load the corresponding accounts.
» Double-click an account to bring up the Account panel for that account.

You can modify it as applicable.

» Then click Save to save your changes.

If the authorization mode is enabled, another user will have to authorize your entry.

You can also click SaveAsNew to create the account as a new account provided you enter a new account name.

 

6. Deleting Accounts

» Load an account and click Delete.

If the authorization mode is enabled, another user will have to authorize your entry.

 

7. Account Menu

The menu items of the Account menu are described below:

Menu Items

Description

New

To create a new account – all fields are cleared.

Save

To save the current account definition.

Save As New

To save the current account definition as a new account. You need to change the account name.

Open

Brings up the Browse panel.

When a user brings up an external account selector in the Account report, the system checks if there is a custom class named tk.report.CustomReportPreviewMode that limits the number of accounts to be loaded.

If not, it checks if the new environment property ACCOUNT_SELECTOR_MAX_ROWS is set to limit the number of accounts to load. Default is 0, no limit.

The maximum number of accounts to load can also be set on-the-fly in the field Max Rows.

Browse in New Window

This menu item operates as a checkbox.

Check to open the Browse panel in a new window when Account > Open is selected.

Save As Template

To save the current account definition as a template. You will be prompted to enter a template name and specify whether the template is private or public. Other users will not be able to use private templates.

Load Template

To load a template. You will be prompted to select a template name.

You can only load public templates or private templates that you have created.

Delete Template

To delete a template. You will be prompted to select a template name.

You can only delete templates that you have created.

Set Default Template

To save a default template. You will be prompted to select a template, and to specify whether the template is public or private. Other users will not be able to use private templates.

The default template will be loaded by default when opening the Account window.

Load Default Template To load the default template.

Close

Closes the Accounts window.

 

8. Utilities Menu

The Utilities Menu items are described below:

Menu Items

Description

Add Account Status Domain

To add status codes for Settle accounts.

Add Account Active Status Domain

To add specific status codes for active Settle accounts.

Add Account Closed Status Domain

To add specific status codes for closed Settle accounts, such as the reason why the account is closed (termination, no activity on account, etc.).

Add Account Pending Status Domain

To add specific status codes for pending Settle accounts.

Add Account Suspended Status Domain

To add specific status codes for suspended Settle accounts.

Define Favorite Properties

See Defining Account Properties for details.

Show All Properties

See Defining Account Properties for details.

Add Property Domain

See Defining Account Properties for details.

External Name

To define external names based on priorities.

» Click Add to add an external name definition.
» Enter an account name and an external name, then click Save.
» You can click Apply to Accounts to set the external name on the accounts.

Sweeping

Applies to Settle accounts.

Opens the Account Sweeping Configuration to configure account sweeping rules.

See Cash Management - Account Sweeping for complete details.

Mapping

Opens the Account Mapping Configuration to store the Bank Account Relationships and map the Incoming Statement Information.

Refer to the Calypso Corporate Cash Management User Guide under Cash Management.

 

9. Reports Menu

The Reports Menu items are described below.

Menu Items Description
Account Activity Report

Applies to Settle accounts.

Brings up the Account Activity report.

The Account Activity report shows the activity that occurs on a given client/nostro account including:

The balances – positions computed by the inventory engine
All the transfers on behalf of a given client or against a given nostro account
The interest computed on the balances

See Cash Management - Interest Activity for complete details.

Account Balance Report

Brings up the Account Balance report.

The Account Balance report shows the account balances of accounts that allow balance generation ("Balance" checkbox checked, and balance frequency specified).

See Viewing Balances for details.

Audits Bring up the Audit report - Help is available from that report.

 

10. Process Menu

The Process Menu items are described below.

Menu Items Description
Dormant Process

Applies to call accounts and settle accounts.

See Call Accounts Processing for information on the Dormant process for call accounts.

See Settle Accounts Dormant Process for information on the Dormant process for settle accounts.

Blocked Process

Applies to call accounts.

See Call Accounts for information on creating call accounts for client cash management.

Interest Bearing

Applies to Settle accounts.

See Cash Management - Interest Bearing for complete details.

Limits > Bulk Create Limit

Applies to Settle accounts.

It brings up the Account Report to load or select the accounts on which you want to create a new Limit.

Limits > Bulk Update Limit

Applies to Settle accounts.

It brings up the Account Report to load or select the accounts on which you want to update the current limit.

Statements

Applies to Settle accounts.

See Cash Management - Account Statement for complete details.

Customer Transfer

Applies to call accounts.

See Customer Transfers for complete details.

Full Balance Withdrawal

Applies to call accounts.

See Call Accounts Processing for information on the Full Balance Withdrawal process.