How do I create a trial balance for an ABOR?

Providing you have suitable access control permissions, you can create a trial balance for an ABOR.

To do this, you must have already created an ABOR that references one or more transaction portfolios.

The following methods for creating a trial balance are available:

• Method 1: Using the LUSID web app
• Method 2: Using the LUSID API
• Method 3: Using Luminesce
   

Using the LUSID web app

1. Sign in to the LUSID web app as a user with suitable permissions.
2. From the left-hand menu, select Financial Reporting > Reporting.
3. On the Trial Balance dashboard, select the ABOR to create a trial balance for (highlighted in red below).
4. Select the start and end dates, or choose one of the preset periods such as YTD (highlighted in green).
5. Optionally, apply a general ledger profile to break down account activity in the trial balance (highlighted in yellow).

Note the following:

• You can click on a blue debit or credit amount to drill down into an account and examine the underlying journal entry lines.
• LUSID automatically calculates subtotals for Net Asset, P&L and Other accounts, and a grand total for all accounts, for you.

Using the LUSID API

1. Obtain an API access token.
2. Call the GetTrialBalance 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 valid LUSID datetime or the code of an accounting diary entry.
   • An end that is either a valid LUSID datetime or the code of an accounting diary entry.
   • Optionally, a dateMode. The default value is ActivityDate. The alternative is AccountingDate. More information.
   • Optionally, a generalLedgerProfileCode to break down account activity in the trial balance.

Consider the following example, of a trial balance created 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/trialbalance/$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": {
    "diaryEntry": "20230716"
  },
  "dateMode": "ActivityDate",
  "generalLedgerProfileCode" : "STEM"
}'

If you:

• Have not specified a generalLedgerProfileCode, the response contains one line per general ledger account, with all the debits and credits for that account aggregated.
• Have specified a generalLedgerProfileCode, the response may contain multiple lines per account (depending on the profile's levels), enabling you to see debits and credits aggregated at a more granular level.

The following example response, for a trial balance with a general ledger profile that has one level for every account and three for the 1-Investments account, has been transformed to a Pandas dataframe for clarity. Note LUSID does not calculate subtotals or a grand total for you; you must calculate these yourself: