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, Total NA, Total P&L and Total Other are automatically calculated from particular accounts, and also a Grand Total. 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:
.png "image(46).png")
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:
.png "image(47).png")
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):
.png "image(48).png")
Allowing an imbalanced trial balance
A trial balance should balance; that is, the sum of all the credits and debits in the base currency should equal zero. If it does not, an error is automatically reported to FINBOURNE.
You can specify a tolerance level to generate an imbalanced trial balance without reporting an error. To do this, override a system setting in the LUSID Configuration Store.
For example, to allow an imbalance of up to 10 major units of the base currency (ie. dollars or pounds), use the LUSID web app to open the AborSettings shared key and edit the TrialBalanceValidationTolerance setting to specify a value of 10:
.png)
To allow an imbalance of 10 minor units of the base currency (ie. cents or pence), specify a value of 0.1.