Run Retrospective Amortization

In the Run Retrospective Amortization panel, you can calculate amortization retrospectively or prospectively. You can run amortization by entity/accounting basis or entity/basis/security at the position or tax lot level. 

To run amortization processing:

  1. In Accounting Center, in the left navigation pane, click Processing & Exceptions > Global Processes > Earnings > Run Retrospective Amortization.
    You see the Run Retrospective Amortization panel.

  2. Choose the entities and securities for which you want to run amortization.

  3. Complete the remaining options on the Run Retrospective Amortization panel.

  4. Click Submit.

Run Retrospective Amortization Panel Options

In the Run Retrospective Amortization panel, when you process amortization, you can select various options based on the requirements of your business.

The following are the options in the Run Retrospective Amortization panel.

Option

Tag

Description

Option

Tag

Description

Calculate Based On

2283

 Allows you to show/hide additional query filters. The system displays additional fields depending on your selection. Options include:

  • One Entity/One Security

  • One Entity/All Securities

  • Entity List/One Security

  • All Entities/One Security

Entity Name

1164

Specifies the name of the entity. This field appears if you set the Calculate Based On field to a value of One Entity/One Security or One Entity/All Securities.

Entity ID

1163

Specifies the unique identifier of the entity. This field appears if you set the Calculate Based On field to a value of One Entity/One Security or One Entity/All Securities.

Accounting Basis

21

Specifies the accounting basis for the entity.

Entity List Name

1104

Specifies the name of the entity list. This field appears if you set the Calculate Based On field to a value of Entity List/One Security.

Entity List ID

1091

Specifies the unique identifier of the entity list. This field appears if you set the Calculate Based On field to a value of Entity List/One Security.

Cost Method

22

Displays the cost method the system uses to calculate gain/loss amounts from the sale of security lots held by the selected entity/accounting basis. Options include Identified and Average.

Allow Earnings Rollback

1257

Indicates whether you want to run retrospective amortization for an End Date for which earnings were already run. If the earnings process was already run for the date selected, you must set this option to Yes so the system can process the retrospective amortization calculation. Options include Yes and No (Default).

Issue Name

961

Specifies the name of the security. This field appears if you set the Calculate Based On field to a value for one security.

Primary Asset ID

14

Specifies the identification number of the primary asset ID type for the security. This field appears if you set the Calculate Based On field to a value for one security.

Security Alias

10

Displays the asset identifier of the selected security. This field appears if you set the Calculate Based On field to a value for one security.

Retrospective Amortization Switch

9159

Determines the date used to process the amortization or indicates you are calculating amortization prospectively. Options include:

  • Original Acquisition Date (O). Default. Runs amortization from the original acquisition date. Based on the Original Acquisition Cost Local (tag 3747) and Original Settle Date (tag 154) on the tax lot. This option is solely geared for positions converted into Eagle's Accounting solution, and the system runs retrospective amortization starting from the original purchase information.

  • Conversion/Settlement Date (C). Runs amortization from the conversion date. Based on the Conversion Settlement Date or the Actual Settlement Date of the lot (tag 37), and Current Cost ID Local (tag 128) on the lot. If the lot was purchased in Eagle's Accounting solution, there is no difference between Original Acquisition Date and Conversion Settlement Date.

  • Date Specific (D). Runs amortization from a user specified date. Populates three values on each lot in the position before the earnings process is called. These include the Retro Start Date (tag 10147), the Amount of Amortization up to that Start Date (tag 9615), and the Amount of OID Amortization up to that Start Date (tag 9616).

  • Prospective (P). Allows you to calculate amortization prospectively for the specified entity/security. You can use this option when you need to recalculate a new yield based on the new current cost of the security. 

Retrospective Amortization Start Date

10147

Specifies the start date for processing retrospective amortization. This defines the date from which the system calculates retrospective amortization. This field appears if you set the Retrospective Amortization Switch field to a value of Date Specific (D).

Earn Through Date

461

Specifies the date to run the earnings process.

Position's First Effective Date

155

Displays the position's first effective date.

Partition

95

Specifies the entity partition code. This field appears if you set the Calculate Based On field to a value of All Entities - One Security.