Allocate Miscellaneous Income/Expense Across Lots

Eagle's Accounting solution allows you to allocate miscellaneous income or expenses/fees across lots. In the Allocate Misc. Income Across Lots panel, you can allocate income across lots. In the Allocate Misc. Expense Across Lots panel, you can allocate expenses and fees across lots. You can use these panels to allocate income/expense across lots rather than post directly to specific open lots. These panels allow you to enter the total income or expense/fee and prorate it across all the open lots as of the trade date. 

To allocate miscellaneous income or miscellaneous expense across lots:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Misc. Income & Expense.

  2. Click one of the following options to access the panel:
    –  Allocate Misc. Income Across Lots
    –  Allocate Misc. Expense Across Lots
    You see the selected panel.

  3. Complete the options on the panel.

  4. Click Submit.

Allocate Misc. Income/Expense Across Lots Panel Options

In the Allocate Misc. Income Across Lots panel or the Allocate Misc. Expense Across Lots panel, you can allocate miscellaneous income or expense across lots manually. The options may vary according to your selections.

Option

Tag

Description

Option

Tag

Description

Entity Information

 

 

Entity ID

1163

Specifies the unique identifier of the entity. 

Entity Name

1164

Specifies the name of the entity. 

Accounting Basis

21

Displays the primary accounting basis of the entity. For example, USTAX, GAAP, or IFRS.

Base Currency

86

Displays the base currency of the selected entity.

Income/Expense Information

 

 

Income/Expense Date

35

Specifies the effective date of the income/expense.

Accounting Date

36

Specifies the date the income/expense is reported and has an effect on the entity's holdings and cash balances. 

Monthly Accounting Date

4733

Displays the month end accounting date.

Event Type

55

Displays the business intent of the event. For example, LOT_LVL_MISCINC, LOT_LVL_MISCEXP.

Rec/Pay Event Name

1827

Specifies the receivable/payable event type name. 


Cash Category

62

Specifies the classification of cash. Options include:

  • Income (Default)

  • Principal

Security Information

 

 

Cross Reference Type

1234

Specifies the cross reference type associated with the security. 

Cross Reference ID

1233

Specifies the cross reference identifier associated with the security.

Issue Name

961

Specifies the name of the security. 

Position As of Date

221

Specifies the end of period date.

Asset Currency

85

Displays the asset currency code.

Settlement Currency

63

Specifies the currency in which the security is settled.

Accounting Information

 

 

Local Net Amount

50

Specifies the net amount of the transaction in local currency for the selected accounting basis.

Local to Base FX Rate

87

Displays the foreign exchange rate used to calculate the net base amount. The value must be greater than zero.

Net Amount Base 

478

Displays the base amount of the trade. This amount is calculated based on the following formula: Local Net Amount / Local to Base FX Rate. The value must be greater than zero.

Settlement Information

 

 

Settle Trade Indicator

58

Indicates whether the system settles the trade, coupon, and miscellaneous income and expenses automatically. Options include:

  • Yes. The system automatically settles the trade, coupon, and miscellaneous income and expenses. The system retrieves the settle date FX rate if the local currency does not equal base and generates a trade to settle date gain/loss.

  • No. Default. The system does not automatically settle the trade, coupon, and miscellaneous income and expenses. You must schedule the settlement for these transactions using the Run Contract Cash global panel. Or, manually settle the transactions using the Run Multiple Settlements panel. If you use cash segregation based on actual cash settlements, you can schedule settlements using the Run Cash Auto Match panel and create settlements manually using Cash Matching. 

Payment Date

37

Specifies the settlement date for the payment.

Bank Account Information

 

 

Custodian Bank Name

1146

Specifies the name of the custodian bank responsible for the transaction. If you select an entity that uses cash segregation, you must identify the custody location. The field lookup allows you to select the custodians that have bank account relationships defined for the entity or for the composite associated with the entity. When you select a value, the system displays values for the Custody Bank Account Number field, Custody Bank Subaccount field, Cash Account Name field and Cash Account Number field, based on the bank account relationships and cash account relationships that apply to the transaction.

Custodian Bank Code

1240

Specifies the code of the custodian bank responsible for the transaction.

Custody Bank Account Number

1660

Specifies the custodian bank primary account number. The panel displays the value associated with the selected bank account relationship for the custodian.

Custody Bank Subaccount

1661

Displays the custodian bank subaccount number. When you use cash segregation, the panel displays a value of OTHER as the custodian bank subaccount number for the transaction.

Cash Account Name

11696

Specifies the name of the cash account for the custodian.

Cash Account Number

11697

Specifies the account number of the cash account for the custodian.

Other Information

 

 

Trade Ticket Number

761

Contains the trade ticket identification number. The system uses this value during processing. For example, IDLOT close or cancel events use this number to locate an open lot.

Â