Add a Basis to a Portfolio Panel Options for Entities
In the Add a Basis to a Portfolio panel, when you add an additional accounting basis, you can select various options based on the requirements of your business.
The Add a Basis to a Portfolio panel includes the following sections:
The following are the options in the Add a Basis to a Portfolio panel.
Option | Tag | Description |
---|---|---|
Ledger Accounting Books |
|
|
Entity ID | 1163 | Specifies the unique identifier of the entity for which you are adding an accounting basis. |
Entity Name | 1164 | Specifies the abbreviated name of the entity for which you are adding an accounting basis. |
Core Accounting Fields |
|
|
Accounting Basis | 21 | Specifies the accounting basis you are adding for the entity, such as GAAP, IFRS, STAT, USTAX, or CUST. |
Controlling Basis | 4949 | Indicates whether the selected accounting basis is the entity's controlling basis for use with for same lot selection. Same lot selection allows the system to relieve the same lots across multiple bases in order to keep lots in sync across bases. Options include:
|
Regulatory Category | 12387 | Specifies the regulatory category associated with International Financial Reporting Standards (IFRS). A regulatory category is a classification that determines how to account for financial instruments. The new IFRS 9 categories that replace IAS 39 categories include Amortized Cost, Fair Value - Other Comprehensive Income, and Fair Value Profit Loss. IFRS 9 categories classify debt instruments based on their contractual cash flow characteristics and the business model in which they are held. Equity securities are classified in the FVOCI or FVPL regulatory categories. If you set the Accounting Basis field to a value of IFRS, you must specify a regulatory category. If you choose an accounting basis value other than IFRS, use of a regulatory category is optional. All investments within an entity/accounting basis must have the same regulatory category. A multi basis entity can have different regulatory categories by basis. Options include:
|
Regulatory Category Effective Date | 9137 | Identifies the date that the regulatory category is eligible for processing. This field appears after you specify a regulatory category value. When you first enter a regulatory category, this field displays the entity's inception date by default, but you can override that value. When you change a regulatory category, you can specify the effective date for that change. If you change categories, be aware that the system uses the Regulatory Category Effective Date field value to determine the chart of account in effect for reporting purposes. Reports process based on the custom chart of account that was "active" during the period, using the report end date to determine what was active. |
URGL Accounting Rule | 1079 | Specifies the URGL (unrealized gain/loss) rule for the entity/accounting basis that establishes proper treatment of unrealized market and currency gains/losses to ensure compliance with International Financial Reporting Standards (IFRS). This option is required only if you select a regulatory category of Amortized Cost, Available for Sale, Available for Sale at Cost, Fair Value Option, Fair Value – Other Comprehensive Income, Fair Value Profit Loss, Held for Trading, Held to Maturity, or Loans and Receivables. The URGL rule used for a Fair Value – Other Comprehensive Income basis determines whether the system recognizes realized gains and losses in other comprehensive income rather than earnings. For more information, see Manage URGL Rules. |
ECL Method | 18053 | Identifies the Expected Credit Losses (ECL) method used with Expected Credit Losses when you use US GAAP OR IFRS. The system assigns the ECL method based on the regulatory category you select, and you cannot change it. Values include:
|
Primary Basis Indicator | 8130 | Indicates whether the value you selected in the Accounting Basis field is the primary or secondary accounting basis on your entity. Options include:
|
Position Cash Segregation Basis Indicator | 11675 | Indicates whether to use the accounting basis as a custody basis for the selected entity for use in cash segregation. An entity can have only one custody basis. You typically assign a non primary, non controlling accounting basis as the custody basis. You must add the custody basis before you begin to process transactions for that entity. Options include:
|
Cost Method | 22 | Specifies the cost method the system uses to calculate gain/loss amounts from the sale of security lots held by the entity/accounting basis. Eagle's Accounting solution is a multiple basis accounting system. If you set up an additional accounting basis, it must have the same cost method as the primary accounting basis. Options include:
Eagle Accounting supports the cost basis legislation regulations included in the Emergency Economic Stabilization Act of 2008. These regulations, which apply to various types of securities, affect debt securities and options posted on or after January 1, 2013. If a portfolio follows these mandatory guidelines, you must perform additional setup tasks to enable cost basis reporting. For information about enabling cost basis reporting, adding rules for covered and uncovered securities, defining mixed cost basis rules to override your basis level elections for the cost basis method, and information about changing cost methods, see the Cost Basis Legislation Quick Reference Guide. |
Lot Selection Method | 27 | Specifies the lot selection method the system uses to relieve (sell) lots of a security held by the entity. Options include:
|
Cost Method Cash | 9924 | Specifies the cost method the system uses to calculate gain or loss amounts from the sale of foreign currency lots held by the entity/accounting basis. The system bypasses rollback and replay processing for same day cost of cash activity. The system processes open and close trades for the same date in the order in which the trades arrive. As a result, some close trades may be processed prior to open trades. The average cost close trades do not include the cost of open trades that have not been processed. This may result in small variances in gains and losses for entities processing average cash. There is no effect on ID lot gains and losses. You cannot edit this field after the entity has holdings. Options include:
|
Accounting Basis Lot Selection Rule | 7102 | Relieves the current holdings of a security for a non primary accounting basis. This field determines processing for the open lots that are eligible to be closed on an additional accounting basis. Options include:
|
Account Currency | 86 | Specifies the base currency for the entity/accounting basis. You cannot edit this field after the entity has holdings. |
Accounting Period Frequency | 624 | Specifies the number of accounting periods per calendar year for the entity/accounting basis. You cannot edit this field after the entity has holdings. Options include:
|
Bifurcation Method | 5825 | Specifies how the system handles gains and losses on foreign securities and foreign debt instruments for the accounting basis. Gains and losses from foreign security and debt instruments may be posted to currency gain/loss ledger accounts, capital gain/loss ledger accounts, or to both. There is no currency gain/loss for domestic securities so you can select No in this field if your organization trades only in domestic securities. For more information, see Understand the Bifurcation Method. Options include:
|
Wash Sale Inhibit Indicator | 775 | Indicates whether the system can apply the wash sale rule to trades. Options include:
|
Primary Amortization/Accretion Rule | 3197 | Specifies the amortization/accretion rule for the primary accounting basis that the system uses to process earnings. You can set up amortization/accretion rules for IFRS that amortize average cost portfolios on an effective yield basis. If you change the Primary Amortization Rule at the accounting basis level, the next time you process earnings the system creates a retrospective amortization rule calculation from the original settlement date of the trade (on all open lots). The system calculates the trade yield based on the primary amortization/accretion rule for the entity, so it is important to keep the values that exist on the entity and the primary accounting basis consistent. The system updates values changed on the entity panel via the primary accounting basis, but does not change entity values when you make the change through the Edit a Basis on a Portfolio panel. See Set Up an Entity/Accounting Basis for Amortization for more information. |
Secondary Basis Replication Rule | 7249 | Specifies which events to replicate to the secondary accounting basis. The system automatically replicates events where the Message Type is MTOPEN, MTCLOSE, MTLINK, MTCANCEL, MTADJUST, and MTCASH. It replicates events where Message Type is MTADMIN and the Sub Message Type is REBOOK. And it replicates events where the Sub Message Type is LOT_LVL_MISCINC. The system does not replicate expenses with an event type of MTQUERY and manual ledger entries with an event type of MTLEDGERPOST. To replicate capital stock and distributions, you must set the Secondary Basis Replication Rule field (tag 7249) to Replicate All Events and the Cash Processing field (tag 8125) to Yes. Options include:
|
Cash Processing | 8125 | Indicates whether the system processes cash receipts/disbursements for the entity/accounting basis. Options include:
|
Ledger Processing | 8128 | Indicates whether the general ledger is configured for the entity/accounting basis. Options include:
|
Postmatrix Type | 11708 | Specifies which ledger posting matrix the entity/accounting basis uses when determining the accounting ledger postings required for a given event. Options include:
|
Unrealized Gain/Loss Indicator | 5383 | Indicates whether the system automatically posts unrealized gains/losses to the ledger during valuation for the entity/accounting basis. Options include:
|
Gain/Loss on Paydowns | 1871 | Specifies how the system handles the gain/loss on paydowns (repayment of part of an outstanding loan balance) for the entity/accounting basis. This field is used with factor based debt instruments such as mortgage backed securities. For more information, see Understand Mortgage-backed (MBS) and Asset-backed (ABS) Securities. Options include:
|
Paydown Gain Loss Account | 4519 | Determines whether the paydown on a gain/loss is posted to the capital or income ledger account for the entity/accounting basis. This field appears when you select Gain/Loss from the Gain/Loss on Paydowns field. For more information, see Understand Mortgage-backed (MBS) and Asset-backed (ABS) Securities. Options include:
|
Principal Loss on Paydown Processing Flag | 2925 | Allows you to select the method in which to process the principal loss on a paydown. The system uses the Principal Loss Factor field (tag 2926) value specified for the final factor to process the principal loss. For more information, see Understand Mortgage-backed (MBS) and Asset-backed (ABS). Options include:
|
Call Redemption Gain/Loss Indicator | 8916 | Indicates whether the system processes gains/losses on calls, puts, and pre-refund corporate actions for the entity/accounting basis. This field is required if you process debt instruments. For more information, see About Entity Setup for Calls, Puts, and Pre-Refunds. Options include:
|
Sink Fund Gain/Loss Flag | 9923 | Specifies how the system processes gains and losses for sinking funds for the entity/accounting basis. Options include:
|
Short Term Discount Accrual | 8919 | Indicates how the system accrues interest or accretes a short term discount bond (processing security type of DBDCST) for the entity/accounting basis. If you elect to accrue short term discount bonds, disable OID amortization in the amortization rules for processing security type DBDCST. Also, set the Short Term Price Method field to Cost to avoid double counting of accrual of interest income in the mark to market process. Options include:
|
Chart of Account | 1641 | Specifies the entity's chart of account to use in ledger reporting for the accounting basis. The system is installed with a core chart of accounts that contains more than 400 account numbers and descriptions. Custom chart of accounts are also available for each of the IFRS regulatory categories. You must select a value for this field even if you are not using the general ledger. The default field value is STAR. If you edit this value after the entity has holdings, the changes go into effect on the specified Regulatory Category Effective Date field value. |
Ledger Granularity Rule Name | 8939 | Specifies the name of the ledger granularity rule associated with the entity/accounting basis. A ledger granularity rule allows you to customize both your core ledger posting for a breakout by holding term and your custom postings based on security master attributes as well as targeted securities. |
Ledger Granularity Rule | 8933 | Displays the instance number associated with the Ledger Granularity Rule Name selected. |
Ledger Granularity Rule Effective Date | 155 | Specifies the first date when transaction processing will apply the ledger granularity rule selected for the entity/accounting basis. |
Holding Term Method | 11479 | Indicates whether the entity/accounting basis calculates the holding term for short term versus cash equivalent holdings at 90 days or at 3 months. If you use ledger granularity rules to customize your core ledger posting for a breakout by holding term, this option determines how Eagle Accounting calculates that holding term. This field appears after you select a ledger granularity rule. Options include:
|
Final Close Income Recognition Date | 10070 | Specifies how the system recognizes closed earnings, amortization, and OID (Original Issue Discount) amortization. It determines on what dates the system posts the income that occurs on a disposition transaction. Options include:
|
Coupon Cash Entitlement Level | 11852 | Specifies the level at which the system drops coupons for the entity/accounting basis. Options include Position Level and Lot Level. |
Swap Accrual Method | 1184 | Specifies how the entity/accounting basis posts interest accruals and dividends for swaps. Options include:
|
Posting Cut Off Date | 11848 | Sets the cutoff date for posting transactions. Transactions where the Trade Date field is greater than the cutoff date are not allowed. The system rejects these transactions prior to executing any database reads. |
Expense & Capitalize Trans Cost for Opens & Closes | 10705 | Determines if transaction fees are expensed or capitalized for acquisitions, and if transaction fees are expensed or netted against proceeds for dispositions. This option supports International Financial Reporting Standards (IFRS) requirements for trades and transaction fees. You cannot edit this field once the entity has holdings. The following trade related fees are considered transaction fees: Commission field (tag 47), SEC Fee field (tag 48), Tax field (tag 46), Stamp Duty Tax field (tag 51), Other Fee field (tag 3752). The Federal Tax Withholding field (tag 8078) and State Tax Withholding field (tag 8079) are not considered transaction fees. Options include:
|
Backup Withholding Indicator | 2768 | Controls whether backup withholding is required. TEFRA legislation requires backup withholding for clients that have not provided a taxpayer ID. Options include No (Default) and Yes |
Cost Basis Covered Indicator | 2818 | Determines whether a portfolio follows the mandatory reporting guidelines. Options include:
|
Book Value Breakdown Flag | 2904 | Determines the book value breakdown for fixed income securities for the entity/accounting basis. Options include:
|
Business Sector | 9512 | Identifies the business sector associated with the entity. You use this field when performing Weighted Average Balance (WAB) calculations. |
Margin Transaction Fees | 3889 | Defines the treatment of commissions for securities with variation margin. Options include:
|
PIK URGL Flag | 3859 | Indicates whether unrealized gain/loss is posted for a Payment in Kind (PIK) bond interest receivable. Options include:
|
ILB Gain/Loss Flag | 3856 | Indicates how Eagle Accounting treats the catch-up inflationary income that occurs at maturity for deflation protected Inflation linked bonds in the event that the index ratio at maturity is less than the ILB Min Index Ratio. For more information, see Understand Inflation Linked Bonds. Options include:
|
No Negative Income Flag | 3857 | Determines whether the system allows a tax lot to have negative life to date income. The option to prevent a tax lot from having life to date negative income is only available for Identified Cost tax lots. This field appears if you set the Cost Method field to a value of Identified. Options include:
|
Tax Exempt Processing Flag | 4948 | Determines whether income is posted to taxable or tax exempt general ledger accounts. This field works with the Federal Tax Indicator field (tag 1545), which exists at the security level. The Tax Exempt Processing Flag field impacts the Net Investment Income (NII) process when calculating the mixed expense taxable allocation percentage. If this field set to Yes, the net distributable income is processed against tax exempt income and expenses. Options include:
|
Expense Election | 2285 | Determines whether to process mutual fund expenses with different accounting treatments on each accounting basis. Note the secondary basis expense election is tied to the primary basis expense election. Options include:
|
Cost Cash Processing | 5006 | (Hidden field) Indicates whether the accounting basis uses COSTCASH processing to track foreign cash positions. Options include:
|
Cash Based Div Recognition Flag | 16160 | Indicates whether to process cash dividend income, tax, and reclaim in the accounting ledger on ex-date or upon the settlement of the associated cash. For more information, see Recognize Dividend Income on a Cash Settlement Basis. Options include:
|
FX Election for Cash Div Recognition | 16161 | If you recognize dividend income on a cash settlement basis, indicates whether the system selects the FX rate used for foreign dividend settlement using the ex-date FX rate or the settlement date FX rate. It applies only to the settlement of dividends issued by a foreign security. This field appears if you set the Cash Based Div Recognition Flag field to a value of Yes. Options include:
|
Equity Method Treatment | 16084 | If the selected accounting basis uses the equity method of accounting, identifies the treatment of assets held under the equity method of accounting. You cannot change this value when you edit an entity/basis. Options include:
|
Income Received Accounting Flag | 16557 | Determines whether the selected accounting basis uses the income posting treatment to create separate entries within the ledger to identify interest income received and/or dividend income received in unique income ledger accounts. This option is for use by Insurance companies that need to reconcile the investment accounting activity reflected on their investment schedules to related ledger accounts on their trial balances. See Record Unique Ledger Postings for Income Received. Options include:
|
Ledger Closeout Override Period | 18570 | Specifies whether a custom transfer profile is assigned to an entity or accounting basis to override any regulatory or default closeout rules already assigned. Before you override the profile, you need to build a custom profile. For more information, see Manage Custom Profiles. |
Mark to Market Accounting Flag | 16634 | Determines whether the selected accounting basis uses the mark-to-market breakout. This breakout is for use by Insurance companies that need to reconcile the investment accounting activity reflected on their investment schedules to related ledger accounts on their trial balances. See Record Unique Ledger Postings for Income Received. Options include:
|
IO Security Amort /Income Flag | 17387 | Determines how the system recognizes amortization and accretion on the General Ledger for securities with a processing security type (PST) of Interest Only Factor Based Debt Instrument (DBFBIO). Options include:
|
Deliver By Settlement Dt | 18298 | Determines whether the system processes activity for Deliver and Interportfolio Transfer (IPT) events only on those lots that passed settlement date. Options include:
|
Begin Date By Settlement | 18299 | Identifies the date on which the system begins to process activity for Deliver and Interportfolio Transfer (IPT) events only on those lots that passed settlement date for the entity/accounting basis. Prior to this date, the system processes any activity for Deliver and Interportfolio Transfer (IPT) events on any lot based on trade date. This field appears only if you set Deliver By Settlement Dt to Yes. |
Mixed Basis Functionality |
|
|
Mixed Cost Basis Indicator | 11664 | Determines if the entity/accounting basis uses a mixed cost basis. A mixed cost basis allows you to override the entity's accounting basis level elections for the cost method, lot selection method, and lot selection rule used during transaction processing. You can define mixed cost basis rules based on transaction criteria that includes processing security type (PST) group, processing security type, security type, cost basis rule type, and asset ID, as well as by using each of these criteria in combination with a specified entity. For more information, see Manage Mixed Cost Basis Rules. Options include No (Default) and Yes. If you select Yes, the Primary Basis Mixed Cost Basis Rule Name field becomes available. |
Mixed Cost Basis Rule Name | 11666 | Specifies the name of the mixed cost basis rule to use for the entity/accounting basis. This option appears if you set the Mixed Cost Basis Indicator field to Yes. |
Corporate Action Fields |
|
|
Corporate Action FX Rule | 9705 | Specifies the foreign exchange rate that the system uses for posting corporate actions for the entity/accounting basis. Options include:
|
Awarded Rights Expiration Rule | 9921 | Specifies how the system handles the treatment of loss generated by the expiration of a right or warrant for the entity/accounting basis. Options include:
|
Cash Div Cash Entitlement Level | 9922 | Specifies whether to use lots or positions to determine cash entitlements for cash dividends for the entity/accounting basis. |
Taxable Override Indicator | 11081 | Determines whether you can override the entity tax rate. Options include No (Default) and Yes. If you select Yes, the system treats all mergers as nontaxable, regardless of whether you set them up as taxable or nontaxable. |
Non Tax Merger Close Method | 11495 | Specifies the method to use to close lots on the original security for non-taxable mergers for the entity/accounting basis. Options include:
|
Limit Gain Loss Eligible | 2487 | Determines if gain loss processing occurs for corporate actions for certain cash/stock mergers. Requires the Limit Gain Loss Indicator field (tag 8553) to be set to Yes on the corporate actions panel to be in effect. When applicable, at the lot level, the gain associated with these mergers is the lesser of the cash amount or the gain to be recognized had the entire transaction been taxable. If the result is a loss, it is disallowed. The disallowed component is then treated as a return of capital. In the case of certain taxable mergers, any loss that is generated at the lot level is disallowed. There are U.S. tax provisions that limit the amount of reportable gains and losses for certain mergers with taxable components. Options include No and Yes. If you select Yes, gain/loss processing occurs for nontaxable mergers with taxable cash. For taxable mergers, gain/loss rules are used for the calculation of losses only. |
Income/Prepayment Fee Treatment | 16739 | Identifies the types of corporate actions for the entity's selected accounting basis that use the income/prepayment fee treatment. The income/prepayment fee treatment supports NAIC accounting requirements relating to prepayment penalties, acceleration fees, and make-whole call provision fees on bonds. The system uses this setting in conjunction with the Income/Prepayment Fee Treatment field applied at the corporate action transaction level. For more information, see Understand Income/Prepayment Fee Treatment. Options include:
NOTE: If you enable use of the income/prepayment fee treatment for specific types of corporate actions at the entity/basis level, be aware that the system does not consider the basis level Redemption Gain/Loss Indicator field setting for transactions that use the income/prepayment fee treatment. If you set the Redemption Gain/Loss Indicator field to Amortization, the system treats those transactions as if you set the Redemption Gain/Loss Indicator field to Gain/Loss. |
Source Fields |
|
|
Security Price Source | 513 | Specifies the source the system uses for pricing securities for the entity/accounting basis. |
Exchange Rate Source | 514 | Specifies the pricing source the system uses for pricing foreign exchange rates for the entity/accounting basis. Used to restrict factor processing to entities with certain exchange rate sources. |
Valuation FX Rate Source | 11652 | Specifies the pricing source the system uses for pricing foreign exchange rates for the entity/accounting basis. Used for valuation, that is, calculating market value. |
Forward Price Source | 2920 | Specifies the pricing source the system uses for pricing forward contracts for the entity/accounting basis. |
MTM Rate Source | 5064 | Specifies the pricing source the system can use to mark foreign receivables to market. You can specify use of the MTM Rate Source or the FX Source (tag 1344) when you run the global mark to market process. |
Short Price Source | 5422 | Specifies the pricing source the system uses for pricing short positions for the entity/accounting basis. |
Short Term Price Method | 1872 | Specifies how the system prices short term debt instruments for the entity/accounting basis. The system identifies a short term fixed income security if the period from Issue Date to Maturity Date is less than or equal to 365 days. It does not do so by Processing Security Type. Options include:
|
Price Level | 12007 | Identifies the default price level that the system uses if the accounting basis prices short term fixed income securities priced at amortized cost. This field appears if you set the Short Term Price Method field to Cost. The field displays a value of 1 by default, but you can change it to a value of 1, 2, or 3. Eagle Accounting uses the price level in Fair Value Level reporting. |
S2P Direct Interface Fields |
|
|
Delta Process Flag | 4758 | Indicates whether the backdated transactions and affected position records are transferred from STAR to PACE for reporting purposes using the STAR to PACE Direct interface. The default is No (Default) and Yes. |
Create Performance Cash Flows in PACE | 5398 | Indicates whether the STAR/PACE integration procedure processes cash currency and copies cash flow information for the entity/accounting basis for reporting by Eagle's Performance solution. If you use Eagle Performance, select Yes. Options include No (Default) and Yes. |
Store Cash Positions in PACE | 5563 | Indicates whether the STAR/PACE integration procedure exports cash positions for the entity/accounting basis from STAR to PACE Direct. If you use Eagle Performance, select Yes. If your organization does not need currency balances, select No (default) to improve efficiency. |
Value at Cost - No Price Found | 11454 | Specifies whether to use the cost value when no price is found for the selected entity/accounting basis. This setting does not affect futures contracts market values. If you run STAR to PACE Direct in Batch mode using the Recent price option (that is, you set Price Date Switch to Recent in the Transfer Data - Batch panel), be aware that any recent price is used before the asset is priced at cost. If you select Yes to use the cost value, if no price is found, STAR to PACE Direct defaults the amortized cost into the PACE market value fields in the position detail and lot level position tables. If you select No to use the default value of 0, the amortized cost is not used even if there is no pricing available. |
Tax Equalization Fields |
|
|
European Equalization Flag | 11540 | Specifies whether to run Equalization for the selected master fund entity/accounting basis. You can use the European Equalization calculation to support German Tax and EU Savings calculations. Options include Yes and No (Default). |
European Equalization Rule Name | 11543 | Specifies the European Equalization Rule name to use. This field is required if you set the European Equalization Flag field to Yes. |
Month End Fields |
|
|
Month End Processing Indicator | 9697 | Indicates whether the accounting basis is using month end processing, which allows you to report transactions in the correct month end report without having to reopen closed daily valuation and accounting periods. Options include:
|
Month End Long Price | 9676 | Specifies the month end pricing source for long positions. This option appears if you set the Month End Processing Indicator field to Yes. |
Month End Short Price | 9677 | Specifies the month end pricing source for short positions. This option appears if you set the Month End Processing Indicator field to Yes. |
Basis Processing Rule |
|
|
Basis Processing Rule Name | 1085 | Specifies the name of the accounting basis processing rule, which contains a set of income characteristics for a specified portfolio/account basis. For insurance accounting clients, this field can also identify the Client ETF Valuation Rule Name used for processing systematic valuation on the ETF securities attached to the rule. Systematic Valuation is intended only for Statutory Accounting purposes. Insurance clients can use it on the STAT accounting basis. |
Basis Processing Rule ID | 2965 | Specifies the ID of the accounting basis processing rule. |