Views:

Related resources:

Explanation

Tutorials

Reference

Providing you have suitable access control permissions, you can add a set of general ledger accounts to an existing chart of accounts (CoA), and update the set at any time.

The following methods are available:

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 Accounts dashboard, select the parent Chart of Accounts from the dropdown (highlighted in red below).
  4. Click the Create general ledger button and follow the instructions:


     

Using the LUSID API

You can add 2,000 accounts in a single API call. An account is created if its code is not yet registered with the CoA, and updated if it is.

  1. Obtain an API access token.
  2. Call the UpsertAccounts API, specifying the scope and code of the parent CoAin the URL and, for each account in the body of the request:
    • A code for the account that uniquely identifies it within the CoA.
    • A type of either Asset, Liabilities, Income, Expense, Capital or Revenue.
    • Optionally, a status of Inactive to signify that the account is no longer in use. The default is Active.
    • Optionally in the properties collection, any number of custom properties from the Account domain to extend the data model. Alternatively, you can add or remove properties using the UpsertAccountsProperties API at any time.

Consider the following example, of a Cash account and a Revenue account added to a CoA that has a scope of Abor and code of Standard (highlighted in red in the URL). The code of each account is the unique account number (in yellow):

curl -X POST 'https://<your-domain>.lusid.com/api/api/chartofaccounts/Abor/Standard/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/Abor/AccountantName": {
        "key": "Account/Abor/AccountantName",
        "value": {
          "labelValue": "Jane Miller"
        },
        "effectiveFrom": "2023-01-02T00:00:00.0000000+00:00"
      }
    }
  },
  {
    "code": "2-Accruals",
    "description": "Dividends",
    "type": "Revenue",
    "status": "Inactive",
    "properties": {
      "Account/Abor/AccountantName": {
        "key": "Account/Abor/AccountantName",
        "value": {
          "labelValue": "Fred Bloggs"
        },
        "effectiveFrom": "2021-05-15T00:00:00.0000000+00:00",
        "effectiveUntil": "2023-06-12T00:00:00.0000000+00:00"
      }
    }
  }
]'