About Holding Term Granularity

Holding term granularity adds detail to your core ledger postings by breaking out accounts by holding term classifications of long term, short term, and cash equivalent. If you use Investment Accounting, the system determines the holding term during transaction processing and then posts to the ledger based on that holding term. If you use Insurance Accounting, the system uses the Schedule D code to determine the trade's holding term.

Set Up Ledger Granularity Rules for Holding Term Granularity

Perform the following tasks to create ledger granularity rules based on holding term granularity.

To set up ledger granularity rules based on holding term granularity:

  1. Add ledger granularity rules. See the Manage Ledger Granularity Rules page for more information.

  2. Add ledger granularity rule details for holding term granularity by setting the Ledger Granularity Type field to a value of Holding Term and selecting a core ledger account. The system automatically loads the corresponding short term (ST) and cash equivalent (CE) accounts. See the Manage Ledger Granularity Rules page for more information.

  3. Assign ledger granularity rules to each entity/accounting basis that requires ledger granularity reporting. See the Set Up Entities for Ledger Granularity page for more information.

About Core Ledger Accounts and Holding Term Granularity

Holding term granularity is built into the Eagle Accounting core ledger posting process. Eagle Accounting comes installed with a core Chart of Accounts (COA) for ledger activity processing. Each core account has a description (for example, Cost of Investments) and a number (for example, 1010000100). For the 72 core G/L accounts targeted, a corresponding short term holding term core account (for example, Cost of Investments - ST) and a corresponding cash equivalent core account (Cost of Investments - CE) is available for use in holding term granularity. 

The following example indicates how the system will perform ledger account mapping for Cost of Investments based on holding term.  

Holding Term

Ledger Account Mapping 

Holding Term

Ledger Account Mapping 

 

Account Name

Account Number

Long Term

Cost of Investments

1010000100

Short Term

Cost of Investments -ST

1010100100

Cash Equivalent

Cost of Investments - CE

1010200100

In this example, the system will map long term holdings to the generic core account for Cost of Investments. The system will automatically map short term holdings to the core account, Cost of Investments -ST and will automatically map cash equivalent holdings to the core account, Cost of Investments - CE. All these core accounts are posted directly into the ledger.

Notice that there is no account explicitly created for long term holdings. Long term activity remains in the original core account used by Eagle clients who do not use ledger granularity (for example, Cost of Investments). Fixed income securities in the original core account are treated as long term. 

Also, the system does not apply holding term granularity rules to derivative securities. When you apply ledger granularity and you set up holding term granularity rules, be aware that the ledger entries for derivative securities do not reflect activity in three different buckets (Long Term, Short Term, and Cash Equivalent). Derivatives post to the core Long Term accounts.

Use Holding Term Granularity in Combination with Custom Granularity

You must create ledger granularity rules in addition to any holding term granularity details to enable ledger reports to break out a specified core account with holding term breakouts. If you want your reports to break out accounts for fixed income versus equity or other types of assets, you can define custom granularity rule details for that purpose.

When you use holding term granularity, you can break out accounts by holding term alone or by both holding term granularity and custom granularity criteria. For example, you can set up a ledger granularity rule to differentiate between long term, short term, and cash equivalent Cost of Investments and also break out the cost for long term government bonds. In this case, you define a ledger granularity rule that includes both holding term rule details and custom granularity rule details. You define custom granularity rules to identify criteria for long term government bonds. If you use a combination of holding term granularity and custom granularity in a ledger granularity rule, you must also create customized ledger accounts in your Custom Chart of Accounts to use for the breakouts.

How Eagle Determines a Lot's Holding Term in Investment Accounting

When Eagle processes a transaction, it recognizes the ledger granularity rule in effect for the transaction's entity/accounting basis and security. For holding term granularity rules, it posts to an account based on the holding term of the lot.

The system automatically determines the holding term for a lot when it processes the trade. The system compares the trade's original acquisition date to its maturity date and then uses the following criteria to assign the holding term:

  • Long Term. Long term lots have an original acquisition date greater than one year from maturity.

  • Short Term. Short term lots have an original acquisition date greater than 90 days (or 3 months) from maturity but also equal to or less than one year from maturity.

  • Cash Equivalent. Cash equivalent lots have an original acquisition date equal to or less than 90 days (or 3 months) from maturity.

You can have the system use 3 months rather than 90 days as the cutoff between a short term and cash equivalent holding term by choosing a holding term method at the entity/accounting basis level. Eagle Accounting accounts for leap years when determining whether to classify a lot as long term or short term.

You can also manually override the system calculated holding term value for a trade. See the Specify the Holding Term when Booking a Trade section for more information. 

The system uses the Holding Term field at the trade level to determine ledger account mapping to core (long term), short term, or cash equivalent.

How Eagle Determines a Lot's Holding Term in Insurance Accounting

For Eagle Insurance clients who use a STAT accounting basis and use the Post STAT Unrealized process, the system can use the Post STAT Unrealized process to provide holding term information for ledger granularity. The Post STAT Unrealized process uses Schedule D codes to determine whether STAT basis positions have a holding term of long term, short term, or cash equivalent.

The system assigns the holding term during transaction processing, using the Schedule D code to determine the holding term as follows:

  • Long Term. D1, DBC1, DBA1, BA1, DBDD1, DBDDBA1, DBDD21, DL1DL1D21, D22, E1, DBDD22, DBDDBB1, DL1DL1D1, DBB1, DL1E1, DL1D21, DL1D22, DBDE1, D21, DBD1, and DL1D1.

  • Short Term. DA1, DL1DA1, and DBDDA1 (all DA1 schedules).

  • Cash Equivalent. E2, DL1E2, and DBDE2 (all E2 schedules).

The Schedule D value and the holding term value must match to keep ledger entries for unrealized gain/loss (URGL) in line with the rest of the lot level ledger postings.

How Eagle Determines the Holding Term for Corporate Actions

When you use a corporate action in Eagle Accounting to transfer an asset from one security to another security, Eagle calculates the holding term on the To side based on the original acquisition date and maturity date of that asset/lot. For non taxable corporate actions, the original acquisition date does not change in the From and To sides, and the holding term is transferred to the To side. For taxable corporate actions, the corporate action has a new original acquisition date that is equal to the trade date of the corporate action, so Eagle Accounting recalculates the holding term.

How Eagle Determines the Holding Term for Interportfolio Transfers

When you use an interportfolio transfer in Eagle Accounting to transfer an asset from one entity to another entity, Eagle calculates the holding term on the To side based on the original acquisition date and maturity date of that asset/lot. For interportfolio transfers that are transferred at market, Eagle Accounting updates the original acquisition date and recalculates the holding term. For interportfolio transfers with other transfer methods (for example, amortized cost, original cost), Eagle Accounting maintains the original acquisition cost and the holding term.

Unrealized Processing and Holding Term Granularity for Investment Accounting

If you use holding term granularity rules with Investment Accounting, be aware that the system does not break out holding term for unrealized accounts. Because the system performs unrealized gain/loss (URGL) processing at the position level for Investment Accounting, the lot level holding term information is not available at the time of URGL processing. As a workaround, the URGL process recognizes balances in the following accounts:

  • 1011100101 - NET UNREALIZED APPRECIATION OF INVESTMENTS - ST

  • 1011200101 - NET UNREALIZED APPRECIATION OF INVESTMENTS - CE

  • 1011100102 - NET UNREALIZED DEPRECIATION OF INVESTMENTS - ST

  • 1011200102 - NET UNREALIZED DEPRECIATION OF INVESTMENTS - CE

  • 1011100201 - NET UNREALIZED CURRENCY APPRECIATION OF INVESTMENTS - ST

  • 1011200201 - NET UNREALIZED CURRENCY APPRECIATION OF INVESTMENTS - CE

  • 1011100202 - NET UNREALIZED CURRENCY DEPRECIATION OF INVESTMENTS - ST

  • 1011200202 - NET UNREALIZED CURRENCY DEPRECIATION OF INVESTMENTS - CE

You can post manual ledger reclass entries from the core (long term) balances into these accounts on the day unrealized gain/loss is processed. The following day, during URGL processing, the system automatically reverses the balances in the previous accounts so there is no break in ledger balances.

Unrealized Processing and Holding Term Granularity for Insurance Accounting

For Eagle Insurance clients who use a STAT accounting basis and use the Post STAT Unrealized process, the system generates holding term accounts for each holding term category. The breakout into long term, short term, and cash equivalent accounts is based exclusively on the schedule for individual lots.