This solution applies to SQLx version 2020.01.31 or later.
|Strict Bond Amount||Strict 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 Balance||Bond 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 Directly||Lodged 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 us||Lodged 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 Lodged||Total Lodged balance is the total of amounts lodged directly or by us|
|To Be Lodged||To Be Lodged balance shows the variance between the Strict Bond Amount and the Total Lodged balances|