How do I add general ledger accounts to a chart of accounts?

You can add one or more general ledger accounts to an existing chart of accounts (CoA).

Methods

LUSID web app

LUSID API

Luminesce

Call the UpsertAccounts API, for example:

curl -X POST 'https://<your-domain>.lusid.com/api/api/chartofaccounts/CoAs/DailyCoA/accounts'
  -H 'Content-Type: application/json-patch+json'
  -H 'Authorization: Bearer <your-API-access-token>'
  -d '[
  {
    "code": "1-Investments",
    "description": "Cash",
    "type": "Asset",
    "status": "Active",
    "properties": {
      "Account/CoAs/AccountantName": {
        "key": "Account/CoAs/AccountantName",
        "value": {
          "labelValue": "Jane Miller"
        },
        "effectiveFrom": "2023-01-02T00:00:00.0000000+00:00"
      }
    }
  },
  {
    "code": "2-Accruals",
    "description": "Dividends",
    "type": "Revenue",
    "status": "Active",
    "properties": {
      "Account/CoAs/AccountantName": {
        "key": "Account/CoAs/AccountantName",
        "value": {
          "labelValue": "Fred Bloggs"
        },
        "effectiveFrom": "2021-05-15T00:00:00.0000000+00:00",
        "effectiveUntil": "2023-06-12T00:00:00.0000000+00:00"
      }
    }
  }
]'

Navigate to Fund Accounting > Chart of Accounts, open the Accounts tab, select the parent CoA and click the Create general ledger button:

Write a Luminesce SQL query using the Lusid.ChartOfAccounts.Account.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

An account is identified by a code that must be unique within the parent CoA.

An account has an optional status field that defaults to Active. You can set this to Inactive using the API only if you wish.

An account must have a type that LUSID automatically aggregates into a particular total in a trial balance as follows:

Account `type`	Aggregated into in a trial balance…
`Asset`, `Liabilities`	Total NA
`Income`, `Expense`, `Revenue`	Total P&L
`Capital`	Total Other

Properties

You can optionally extend the data model of an account by adding custom properties from the Account domain, either when you create it or subsequently using the UpsertAccountProperties API.

Subsequent updates

You can call the UpsertAccounts API again and specify the code of a particular account to change any of its attributes (other than the code).

To delete an account, call the DeleteAccounts API, with a deleteMode of either:

Soft to set the account status to Inactive.
Hard to permanently delete the account.