How do I create a chart of accounts?

Providing you have suitable access control permissions, you can create a chart of accounts (CoA).

Subsequently, you can:

  1. Add general ledger accounts to the CoA.

  2. Add one or more posting modules to the CoA.

  3. Optionally, add one more cleardown modules to the CoA.

  4. Optionally, add one or more general ledger profiles to the CoA.

Using the LUSID web app

  1. Sign in to the LUSID web app as a user with suitable permissions.

  2. From the top left menu, select Financial Reporting > Mapping.

  3. On the Chart of Accounts dashboard, click the Create chart of accounts button and follow the instructions:

Using Luminesce

You can use the Lusid.ChartOfAccounts.Writer provider. More information.

Using the LUSID API

  1. Obtain an API access token.

  2. Call the CreateChartOfAccounts API, specifying a scope in the URL and, in the body of the request:

    • A code that together with the scope uniquely identifies the CoA (the code must be unique within the scope).

    • Optionally, a displayName and description. Note these are informational fields only.

    • Optionally in the properties collection, any number of custom properties from the ChartOfAccounts domain to extend the data model. Subsequently, you can add or remove properties using the UpsertChartOfAccountsProperties API.

Consider the following example, of a CoA with a scope of Abor (in the URL) and code of Standard (in the body):

curl -X POST 'https://<your-domain>.lusid.com/api/api/chartofaccounts/Abor'
  -H 'Content-Type: application/json-patch+json' 
  -H 'Authorization: Bearer <your-API-access-token>'
  -d '{
  "code": "Standard",
  "displayName": "Standard CoA",
  "description": "This is a CoA for standard reporting",
  "properties": {
    "ChartOfAccounts/Abor/FundManagerName": {
      "key": "ChartOfAccounts/Abor/FundManagerName",
      "value": {
        "labelValue": "John Smith"
      },
      "effectiveFrom": "2023-03-05T00:00:00.0000000+00:00"
    }
  }
}'

In the response, LUSID confirms that the unique identifier of the CoA consists of the scope and code:

{
  "id": {
    "scope": "Abor",
    "code": "Standard"
  },
  "displayName": "Standard CoA",
  "description": "This is a CoA for standard reporting",
  "properties": {
    "ChartOfAccounts/Abor/FundManagerName": {
      "key": "ChartOfAccounts/Abor/FundManagerName",
      "value": {
        "labelValue": "John Smith"
      },
      "effectiveFrom": "2023-03-05T00:00:00.0000000+00:00",
      "effectiveUntil": "9999-12-31T23:59:59.9999999+00:00"
    }
  },
  ...
}