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.
Generated by movement types… | Journal entry line amount represents… | Notes | |
Transaction activity | |||
Increasing or decreasing positions | |||
|
| 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 |
|
| When closing a position, the market component of the realised gain or loss. |
|
|
| 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. |
|
| When closing a bond position where the purchase cost differs from the face value, the amortisation amount. | The amortised cost is a combination of |
|
|
|
|
Transaction-level income and expense activity | |||
|
| Can be used to balance the |
|
Portfolio-level income and expense activity | |||
|
| Can be used to balance the |
|
|
| Can be used to balance the |
|
Valuation activity (note that for every | |||
| 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 For the base amount, use |
| 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 For the base amount, use | |
| 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 | |
| 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 For the base amount, there isn't a unique metric, but you can perform the following calculation: | |
| 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 |