What is a trial balance?

A trial balance is a summary view of all the general ledger accounts underlying a particular ABOR between two points in time. See how to create a trial balance.

By default, LUSID reports each account on a single line, automatically aggregating all the journal entry lines representing debits and credits in that account, and providing an opening and closing statement in both local and base currencies.

In the LUSID web app, subtotals for Net Asset, P&L and Other accounts, and a grand total for all accounts, are automatically calculated. Note you must calculate these totals yourself if you create a trial balance using the API or Luminesce.

You can click the Configuration icon in the web app (highlighted in red below) to show or hide columns, from where an Add column button is available to add account properties to the trial balance if you wish.

In the LUSID web app, you can click a blue debit or credit amount to drill down into an account and examine the underlying journal entry lines:

You can optionally apply a general ledger profile to the trial balance (highlighted in red below) to break down account activity and aggregate debits and credits at a more granular level. Here, the four accounts above are broken down firstly into their constituent economic buckets (the Level 1 column), and then into their holding types (the Level 2 column):