In the Inflation Linked Bond panel, you can manually book an open (buy or short sell) and close (sell or buy to cover) trade for an ILB (inflation linked bond). ILBs, also known as treasury inflation protected securities (TIPS) in the United States, Real Return Bonds (RRBs) in Canada, Treasury Gilts or Treasury Stocks in the United Kingdom, or as generic inflation indexed bonds and linkers, are debt instruments whose principal and subsequent interest payments are adjusted based on the rise of inflation.

This article assumes you are familiar with the entity and security level elections that have been made for processing an ILB security.

Book Open Trades for ILB Securities

To manually book an open trade for an ILB:

Content on this page:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter Book Trade in the Start Search text box.
Click the Book Trade (Accounting Center) link to access the Book Trade tool.
You see the Query window as the default.
Complete the options in the Query window and click Start Search.
Select the row with the security you want to trade.
Click Open, and click Buy or Short Sell.
You see the Open Inflation Linked Bond panel.
Complete the options on the Open Inflation Linked Bond panel.
Click Submit.
Once the trade is booked, it follows all core accounting processes.

Open Inflation Linked Bond Panel Options

The following are the options in the Open Inflation Linked Bond panel. Note options may vary according to your selections.

Option	Tag	Description
Entity Information
Entity ID	1163	Specifies the unique identifier of the entity.
Entity Name	1164	Specifies the name of the entity.
Base Currency	86	Displays the base currency of the entity.
Issue Information
Trade Date	35	Specifies the effective date of the trade. The trade date cannot be greater than the post date, accounting date, or settlement date.
Accounting Date	36	Specifies the date the trade is reported and has an effect on the entity's holdings and cash balances. The accounting date must be greater than the trade date.
Monthly Accounting Date	4733	Displays the month end accounting date.
Settlement Date	37	Specifies the date the trade is settled.
Event Type	55	Specifies the business intent of the transaction. NOTE: The system does not currently support processing of short positions on ILB securities.
Long/Short Indicator	15	Displays an L (long) or S (short) to indicate whether the position is long or short.
Cross Reference Type	1234	Specifies the cross reference type associated with the security.
Issue Name	961	Specifies the name of the security.
Ticker	13	Specifies the trade ticker of the security.
Cross Reference ID	1233	Specifies the cross reference identifier associated with the security.
Instrument Type	11	Displays the instrument type.
Security Type	82	Displays the security type of the asset.
Issue Currency	85	Displays the local currency of the security.
Maturity Date	38	Displays the date the final principal payment is due on the security.
Coupon Rate	70	Displays the rate at which the security accrues interest. It is expressed as an annual rate.
Accounting Information
Select Values to be Calculated by STAR	7000	Determines whether the system automatically calculates the trade data or allows you to enter it manually. Options include: Traded Interest/Amort Yield/OID Yield/Trade Yield Traded Interest/OID Yield/Trade Yield Amort Yield/OID Yield/Trade Yield Traded Interest/Amort Yield/Trade Yield Traded Interest Amort Yield/Trade Yield OID Yield/Trade Yield Calculate None
Accrued Interest Type	3715	Displays the accrued interest type. The value in this field must be CUM.
Par Value	40	Specifies the original par value of the trade. This should not include any inflation adjustments.
ILB Index Ratio	4483	Displays the ILB index ratio. This value is calculated automatically using the index values loaded to the underlying index security and the Dated Date CPI (consumer price index).
Current ILB Quantity	965	Displays the inflation adjusted par value. This value is calculated automatically as Par Value * ILB Index Ratio.
Price per $100 of Par Value	45	Specifies the clean unit price, exclusive of accrued interest and inflation. The system needs the prices to be supplied as clean unit prices (without accrued interest payable/receivable or inflation). If accrued interest and/or inflation are included in the price, they will be double counted during valuation.
Amort Yield	75	Displays the rate at which a bond accretes discount or amortizes premium. It is expressed as an annual rate. NOTE: Amortization and amortization yield are not calculated for short positions, as specified in the Long/Short Indicator field.
Trade Yield	9430	Specifies the yield calculated on the trade.
Principal	165	Displays the cost associated with the trade. This value is calculated automatically as Current ILB Quantity * Price * Price Multiplier (typically 0.01).
Implied Commission Indicator	78	Indicates if commission is included in the price. Options include: No. The commission is not included in the price. Yes. The commission is included in the price.
Commission	47	Specifies the amount of the trade commission.
Tax Amount	46	Specifies the tax amount on the transaction.
Stamp Duty Tax	51	Specifies the stamp duty amount on the transaction.
Other Fee	3752	Specifies any additional fees on the transaction.
Traded Interest	49	Specifies the accrued interest bought or sold on the trade. This value is automatically calculated based on Current ILB Quantity and the bond's interest rate and day count basis. If you want to enter this data from a trading system, do not choose any option with Traded Interest under the Select Values to be Calculated by STAR field.
Local Net Amount	50	Displays the amount of cash that will be moved in local currency terms.
Settlement Currency	63	Specifies the currency in which the trade is settled.
Settlement Net Amount	64	Displays the amount of cash that will be moved in local currency terms.
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.
Base Net Amount	478	Displays the amount of cash that will be moved in base currency terms. This value is calculated using the Local to Base FX Rate that is automatically pulled into the panel.
Settlement Information
Auto 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 Contract Cash panel. Or, manually settle the transactions using the Multiple Settlements panel. NOTE: If the entity's Auto Settle Indicator field is set to Yes, as specified on the Add/Change Entity or Master Fund Setup panels, the system will create a settlement when the trade is processed. There will be no trade to settle date gain/loss. This applies even if the settlement date is in the future. Eagle recommends that you set the Auto Settle Indicator field to No for the entity and trade panels.
Broker Name	1235	Specifies the name of the primary broker.
Broker Code	88	Specifies the code that represents the broker.
Clearing Broker	1236	Specifies the name of the clearing broker, if different from the trade broker.
Clearing Broker Code	1237	Specifies the code for the clearing broker.
Custodian Bank Name	1146	Specifies the name of the custodian bank responsible for the trade. NOTE: You must establish a relationship between the custodian bank and your entity prior to booking the trade.
Custodian Bank Code	1240	Displays the code of the custodian bank.
Custody Bank Account Number	1660	Displays the custodian bank primary account number.
Custody Bank Subaccount	1661	Displays the custodian bank subaccount number.
Settle Instructions 1	1897	Allows you to add settlement notes.
Settle Instructions 2	1898	Allows you to add settlement notes.
Settle Instructions 3	1899	Allows you to add settlement notes.
Settle Instructions 4	1900	Allows you to add settlement notes.
Settle Location	43	Specifies the location in which the trade is settled.
Other Information
Transaction Notes	56	Contains user defined information about the trade.
Original Trade Ticket Number	761	Contains the trade ticket identification number. The system uses it during processing. For example, IDLOT close or cancel events use this number to locate an open lot.
Regulatory Intent	8915	If you now hold the trade in an entity/accounting basis with the new International Financial Reporting Standards (IFRS) regulatory category of Fair Value Profit Loss (FVPL) but previously held the trade in an entity/accounting basis with the old regulatory category of Fair Value Option (FVO) or Held for Trading (HFT), you can identify the old regulatory category specified for the trade at the entity/accounting basis level. You can specify a value for reporting purposes only. Options include: Fair Value Option. Indicates the trade was previously held in a regulatory category of Fair Value Option, used for instruments managed on a fair value basis. Held for Trading. Indicates the trade was previously held in a regulatory category of Held for Trading, used for instruments held with the intent of selling them.
Pending Trade Flag	3695	Specifies whether the trade is eligible for pending trade processing prior to processing by the STAR accounting engine. If you use pending trade processing, the system can assign this value to incoming transactions that meet flagged position rule criteria. Or an incoming transaction can include this value. This field is hidden. Options include Y and N.
Pending Trade Status	3720	Specifies the trade's transaction status for pending trade processing prior to processing by the STAR accounting engine. If you use pending trade processing, the system can assign a value of Pending to incoming transactions that meet flagged position rule criteria. Or an incoming transaction can include a value of Pending or a custom pending transaction status value defined in the PEND_TRD_STATUS code category. The default status is Pending if no status is provided. This field is hidden.
Holding Term	9091	Specifies the holding term for the trade based on the number of days between the original acquisition date (tag 216) and the maturity date (tag 35) on the lot. If you use ledger reporting based on ledger granularity rules to break out accounts by holding term, the system uses this value to identify the holding term for trades related to bonds and preferred stocks. Eagle Accounting's core transaction processing calculates the holding term for you, but you can manually override the value displayed in this field. Eagle Insurance clients that use ledger granularity rules have the system calculate the holding term based on the schedule associated with a lot. Options include: Short Term. Identifies a short term holding. If the Holding Term Method field (tag 11479) in the trade's accounting basis has a value of 90 days, a short term holding term is 91 days to a year. If the Holding Term Method field has a value of 3 months, a short term holding term is 3 full months to a year. Cash Equivalent. Identifies a cash equivalent holding. If the Holding Term Method field (tag 11479) in the trade's accounting basis has a value of 90 days, a cash equivalent holding term is 90 days or less. If the Holding Term Method field has a value of 3 months, a cash equivalent holding term is 3 full months or less.
User Defined Priority	2862	Specifies the user generated number that determines the event sub priority. That is, after the system accounts for the event sequence and corporate action sequence.
Order Number	1092	Specifies the order number of the transaction. This can be the same for multiple lots.

Book Close Trades for ILB Securities

The system can process both full and partial closes for an ILB security. The ILB Index Ratio is automatically calculated using the underlying index (CPI) values. The ratio is used to adjust par value, and the inflation adjusted traded interest can also be calculated. Gain or loss is realized based on the difference between the close price and the open price.

To manually book a close trade for an ILB security:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter Book Trade in the Start Search text box.
Click the Book Trade (Accounting Center) link to access the Book Trade tool.
You see the Query window as the default.
Complete the options in the Query window and click Start Search.
Select the row with the security you want to trade.
Click Close, and click Buy to Cover.
You see the Close Inflation Linked Bond panel.
Complete the fields on the Close Inflation Linked Bond panel.
Click Submit.

Close Inflation Linked Bond Panel Options

The following are the unique options in the Close Inflation Linked Bond panel. See the Open Inflation Linked Bond Panel Options section for more information about other options.

Option	Tag	Description
Accounting Information
Position Par Value	122	Displays the current quantity of the position. The value in this field must be greater than zero.
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: First In First Out (FIFO). Lots acquired first are sold first. The oldest lot is sold first based on the holding date. If you set the accounting basis Cost Basis Covered Indicator field (tag 2818) to Y, unknown cost lots are relieved first. The oldest cost lot is sold first based on the holding date. Last In First Out (LIFO). Lots acquired last are sold first. The most recent lot is sold first based on the holding date. If multiple lots share the same holding date, the lot with the greatest event sequence is relieved first. The event sequence, set internally by the system, indicates the processing order of transactions within the same position. High Amortized Cost or High Cost (HCLOT). The lots with the highest current cost are sold first. The system uses current unit cost, which includes amortization for debt securities. This method relieves the lots that can generate the maximum loss or the minimal gain. Low Amortized Cost or Low Cost (LCLOT). The lots with the lowest current cost are sold first. The system uses current unit cost, which includes amortization for debt securities. This method relieves the lots that can generate the minimal loss or the maximum gain. High Original Cost (HORIG). The lots with the highest original cost are sold first. The system uses the original unit base cost of the open lots. It relieves the lots that can generate the maximum loss or the minimal gain. Low Original Cost (LORIG). The lots with the lowest original cost are sold first. The system uses the original unit base cost of the open lots. It relieves the lots that can generate the minimal loss or the maximum gain. Identified Lot (IDLOT). The specified lot or lots are sold first, which determines cost and tax implications. You can optimize this option to specific tax situations by selecting the specific lots to be sold. If you select this method, the lower pane in the panel displays lot details for each available lot, as determined by the entity's controlling basis. If no controlling basis exists, it displays lots for the primary basis. You must specify the quantity for one or more lots that you want to relieve. The total quantity you specify for the open lots must match the quantity entered for the total close. The close trade relieves the selected lots in each of the entity's accounting bases, and keeps the lot structures in sync. The system uses the lot's Orig Event ID field (tag 457) to match a single open lot in one basis to corresponding multiple open lots in another basis, as needed. This can occur for lots fractured as a result of wash sale processing. Best Tax. The lots are selected and sold with the objective of taking losses first (short term then long term) and gains last (long term then short term). Lots are sold in the following order: Short term Losses. Lots that reflect a short term loss are sold first, beginning with lots that generate the greatest short term loss down to the least short term loss. Long term Losses. Lots that reflect a long term loss are sold, beginning with lots that generate the greatest long term loss down to the least long term loss. Short term No Gains or Losses. Short term lots that reflect no gain or loss. Long term No Gains or Losses. Long term lots that reflect no gain or loss. Long Term Gains. Lots that reflect a long term gain, beginning with lots that generate the least long term gain up to the greatest long term gain. Short Term Gains. Lots that reflect a short term gain, beginning with lots that generate the least short term gain up to the greatest short term gain. Tax Advantage (TXADV). The lots with the lowest tax liability are sold first to minimize tax liability. Versus Purchases (VSP). The lots are selected and sold based on lot purchase characteristics, such as the target purchase date and the target purchase price. This option must be specified at the trade level. Pro Rata. The lots are selected and sold based on a proportionate allocation. Tax Efficiency. The lots with the lowest tax liability are sold first to minimize tax liability. The system calculates the tax liability based on the manipulation of entity level tax factors for long and short term gains, long and short term losses, and currency gains. The system also incorporates the wash sale disallowance effect and considers the overall tax implications of closing each individual lot. Modified FIFO (MFIFO). The open lots with the same original acquisition date (tag 216) as the close transaction are sold first, starting with the lots with the lowest unit cost local. If there are no open lots with the same acquisition date as the close transaction, or all same day lots have been sold, the oldest open lots are sold first based on the acquisition date. Within a single acquisition date, the lots with the lowest unit cost local are sold first.
Prorata Credit/Noncredit Loss Reduction	16157	Indicates whether any noncredit loss associated with partial sells on the transaction is reversed prorata. This field appears only when you close less than the total outstanding quantity. Options include: Yes. Any noncredit loss associated with partial sells is reversed prorata. No. Default. Any noncredit loss associated with partial sells is reversed entirely.

Browser not supported