Using a general ledger profile to break down account activity in a trial balance

By default, LUSID reports each general ledger account in a trial balance on a single line, automatically aggregating all the debits and credits in that account.

Consider the following example, of a trial balance for a fund with four accounts and debits and credits aggregated separately for each:

You can create a general ledger profile to break down one, some or all accounts into levels (or categories), to aggregate debits and credits in a more granular way. For example, you could break down all four accounts into their constituent asset classes (see the level 1 column below). Debits and credits for accounts with multiple asset classes (1-Investments and 4-PnL) are now aggregated separately; the totals, however, remain the same:

You could go further and break down the asset classes of just the 1-Investments account by currency (see the level 2 column below). Now, debits and credits are aggregated separately for GBP equities and USD equities:

You could go further still and break down the currencies of the 1-Investments account by economic bucket (see the level 3 column below), and so on:

To enable breakdown of account activity in a trial balance in this way, you must:

1. Add a general ledger profile to your chart of accounts, with an ordered set of mappings that LUSID uses to apply levels to journal entry lines matching the rules, and which then impact the trial balance. Syntax of a mapping.

2. Apply the general ledger profile when you create a trial balance.

For each journal entry line generated in preparation for the trial balance, LUSID uses the first matching mapping found in the general ledger profile. For example, to implement the scenario above and break down all accounts by asset type, and further break down the 1-Investments account by currency and then by economic bucket, your general ledger profile might look like this:

{
  "chartOfAccountsId": {
    "scope": "Abor",
    "code": "DailyNAV"
  },
  "generalLedgerProfileCode": "DailyNAV",
  "displayName": "GL profile for daily NAV",
  "generalLedgerProfileMappings": [
    {
      "mappingFilter": "GeneralLedgerAccountCode eq '1-Investments'",
      "levels": [
        "Instrument.AssetClass",
        "DefaultCurrency",
        "EconomicBucket"
      ]
    },
    {
      "mappingFilter": "True",
      "levels": [
        "Instrument.AssetClass"
      ]
    }
  ],
  ...
}

For each generated journal entry line, LUSID:

1. Applies three levels if the journal entry line represents a debit or credit to the 1-Investments account, in the following order: asset class, currency, economic bucket.

2. If the journal entry line represents a debit of credit to any other account, LUSID applies a single level of asset class.

In this example, mapping 2 is a ‘catch all' rule that applies levels to unmatched accounts. You could omit mapping 2, in which case accounts other than 1-Investments would have a level of No matching mapping. Best practice might be to specify a final mapping that always evaluates with an empty set of levels for unmatched journal entry lines, for example:

{
  "mappingFilter": "True",
  "levels": []
}