Views:

theRelated resources:

Explanation

Tutorials

Reference

Providing you have suitable access control permissions, you can view journal entry lines for an ABOR between two dates.

LUSID automatically generates journal entry lines when you create a trial balance but you might want to view them directly for audit purposes.

The following methods are available:

Using the LUSID API

  1. Obtain an API access token.
  2. Call the GetJournalEntryLines API, specifying the scope and code of an ABOR in the URL and, in the body of the request:
    • A start that is either a date represented as a string or the code of an accounting diary entry.
    • An end that is either a date represented as a string or the code of an accounting diary entry.
    • Optionally, a dateMode. At the time of writing, the only valid value is ActivityDate.
    • Optionally, a generalLedgerProfileCode to decorate levels (or categories) onto journal entry lines, enabling breakdown of account activity in a trial balance.
    • Optionally in the properties collection, any number of properties from the Instrument, Transaction, Portfolio, Account, LegalEntity or CustodianAccount domains to enrich the output.

Consider the following example, of journal entry lines for an ABOR with a scope of Abor and code of DailyNAV (highlighted in red in the URL):

curl -X POST 'https://<your-domain>.lusid.com/api/api/abor/Abor/DailyNAV/journalentrylines/$query'
  -H 'Content-Type: application/json-patch+json'
  -H 'Authorization: Bearer <your-API-access-token>'
  -d '{
  "start": {
    "date": "2023-01-01T00:00:00.0000000+00:00"
  },
  "end": {
    "date": "2023-07-16T00:00:00.0000000+00:00"
  },
  "dateMode": "ActivityDate",
  "propertyKeys": ["Instrument/default/Name"]
}'

The response contains one or more journal entry lines:

  • For each transaction in the associated portfolio(s) between the two dates. These have a source type of LusidTransaction.
  • For each underlying instrument in the portfolio(s) impacted by the latest market data (prices and/or FX rates) detected in the LUSID Quote Store. These have a source type of LusidValuation. More information.

The following example response has been transformed to a Pandas dataframe, and some columns renamed or omitted, for clarity:

Using the LUSID web app

Coming soon

Keywords: JE Lines