How do I create a chart of accounts?

You can create a chart of accounts (CoA) that constitutes a repository for the following components:

Any number of general ledger accounts.
One or more posting modules, each containing rules to post journal entry lines to particular accounts.
Optionally, one or more cleardown modules, each containing rules to transfer P&L balances to particular accounts at year end.
Optionally, one or more general ledger profiles, each enabling breakdown of account activity in financial reports in a particular way.

Methods

LUSID web app

LUSID API

Luminesce

Call the CreateChartOfAccounts API, for example:

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

Navigate to Fund Accounting > Chart of Accounts, open the Chart of Accounts tab and click the Create chart of accounts button:

Write a Luminesce SQL query using the Lusid.ChartOfAccounts.Writer provider and execute it using a tool such as the LUSID web app, for example:

Data fields and properties

This section supplements the API documentation and on-screen help text in the LUSID web app.

Fields

A chart of accounts is identified by a scope and a code that must be unique within that scope.

The displayName and description fields are information fields only.

Properties

You can optionally extend the data model of a CoA by adding custom properties from the ChartOfAccounts domain, either when you create it or subsequently using the UpsertChartOfAccountsProperties API.

Subsequent updates

You can call the PatchChartOfAccounts API to change just the displayName and description fields. To delete a CoA, call the DeleteChartOfAccounts API.