This solution applies to SQLx version 2020.01.31 or later.

FieldDescription
Strict Bond AmountStrict Bond Amount balance set initially to the bond amount at the start of the tenancy and may change over time if the strictly required bond amount (eg four times current rent) increases or decreases when rent is reviewed. The total includes Bond transaction types with the flag Strict
Bond BalanceBond Balance is the amount of bond owed by or to the tenant. The total includes Bond transaction types with the flag Strict unticked and direct Bond Lodgement transactions.
 Lodged DirectlyLodged Directly is the balance of amounts lodged directly with the Authority by a third party on behalf of the tenant or returned directly to the tenant. The total includes Bond Lodgement transaction types with the flag Direct
Lodged by usLodged By Us balance is the amount of bond lodged with the authority from amounts received by us from the tenant. The total includes Bond Lodgement transaction types with the flag Direct unticked
Total LodgedTotal Lodged balance is the total of amounts lodged directly or by us
To Be LodgedTo Be Lodged balance shows the variance between the Strict Bond Amount and the Total Lodged balances