LUSID automatically categorises every journal entry line it generates to represent economic activity in portfolios into a broad economic bucket such as NA_Cost or PL_RealPriceGL.
You can use the economic bucket categorisation:
- In a posting rule to post the credit or debit amount recorded by the journal entry line to an appropriate general ledger account.
- In a cleardown rule to post the credit or debit amount recorded by the journal entry line from a P&L account to a different account at year end.
- In a general ledger profile mapping to enable breakdown of one, some or all general ledger accounts in a trial balance.
| Economic bucket | Generated by movement types… | Journal entry line amount represents… | Notes |
| Transaction activity | |||
| Increasing or decreasing positions | |||
NA_Cost | StockMovement | The adjustment to the cost basis of the holding (security or cash). | When increasing a position (opening or extending a long or short position), the
When decreasing a position (selling a long position or covering a short position), the |
PL_RealPriceGL | StockMovement | When closing a position, the market component of the realised gain or loss. | |
PL_RealFXGL | StockMovement | When closing a position in a different currency, the currency component of the realised gain or loss. | This can only be reported in the base (or portfolio) currency. |
PL_RealAmort | StockMovement | When closing a bond position where the purchase cost differs from the face value, the amortisation amount. | The amortised cost is a combination of NA_Cost and PL_RealAmort. |
PL_Other | StockMovement | ||
| Transaction-level income and expense activity | |||
PL_Carry | CarryCarryAsPnl | Can be used to balance the NA_Cost of a transaction representing a dividend, trading fee, commission, exchange fee or tax amount. (Alternatively, income or expense activity might be stored as a field or property on a purchase or sale transaction itself.) | |
| Portfolio-level income and expense activity | |||
CA_Capital | Capital | Can be used to balance the NA_Cost of a transaction representing a subscription, redemption, deposit or withdrawal. | |
PL_Fees | Fee | Can be used to balance the NA_Cost of a transaction representing a portfolio-level fee or expense. | |
Valuation activity (note that for every NA* journal entry line LUSID automatically generates a corresponding PL* line) | |||
NA_AmortisedPL_Amortised | N/A. There is no transaction type (and therefore no movements) associated with valuation activity. | The amortised amount of an investment, and an equal and opposite amount for balancing a P&L account. | The local amount of a journal entry line can be audited using the
|
NA_UnrealPriceGLPL_UnrealPriceGL | The change in investment value caused by the latest detected market price after amortisation, and an equal and opposite amount for balancing a P&L account. | The local amount can be audited using the
| |
NA_UnrealFXGLPL_UnrealFXGL | The change in investment value caused by the latest detected exchange rate after amortisation, and an equal and opposite amount for balancing a P&L account. | This is only reported in the base (or portfolio) currency. The amount can be audited using the | |
NA_AccruedPL_Accrued | The change in investment value due to interest accrued, and an equal and opposite amount for balancing a P&L account. | The local amount can be audited using the
| |
NA_CostNormalisation | The difference between the recorded cost and the trade date average cost of a cash holding in a portfolio with realised gain/loss calculated on trade date rather than settlement date. Note LUSID automatically balances cost normalisation amounts by offsetting credits for cash holdings above the trade date average with debits for cash holdings below the average. | This is only reported in the base (or portfolio) currency. The amount can be audited using the Holding/CostNormalisation metric. | |