Open the Security Deposit report to see every deposit held for your leases, and check the held amounts against the deposit trust account.
Before you start
- Your role needs the Lease Deposits permission with the Access action. Without it, the Security Deposit report does not open.
- The Trust Tieout view needs access to all properties. Without it, the view shows this notice in place of the table: "The trust tieout compares account-wide trust cash with held deposits, so it requires access to all properties."
Steps
- Select Reports in the sidebar.
- In the Property section, select Security Deposit.
- Select a view: Liability, Tenant Ledger, Trust Tieout or Activity. The report opens on Liability.
- Under Report Filters, check the As Of date. It shows today's date and cannot be changed, because deposit balances are current only. An As Of date in an old link is ignored, and the report shows today's balances. Then set any of these fields:
- From and To: the period for Tenant Ledger and Activity. They start on 30 days before today and on today.
- Property ID and Lease ID: paste an ID to limit the report to one property or one lease. Each field takes an ID in the form of a UUID.
- Only exceptions: select it to show only the leases with exceptions.
- Include historical leases: selected by default. Clear it to leave out past leases.
- Page size: the number of rows on each page, from 1 to 1000. It starts at 500.
- Select Apply.
- Read the summary cards and the table. Select Previous and Next to move between pages.
What the views show
Liability lists the deposits held on each lease. The columns are Property, Unit, Tenant, Charged, Held, Pending refund, Available and Trust backed.
Tenant Ledger and Activity list deposit lines with the columns Date, Event, Lease, Charge code, Amount, Balance after and Posting. Tenant Ledger and Activity use the From and To dates. Tenant Ledger also reads its balances as of As Of, which is today's date.
Trust Tieout lists the leases with exceptions. The columns are Lease, Held, GL liability, Trust backed and Exception.
The summary cards show Held liability, Trust backed, Pending exceptions and GL liability. The cards appear only when your role can see the trust tieout.
When deposit trust cash is more than the deposits held, a To transfer to operating card appears above the report. It lists each property with the amount that can move. The amount stays in the deposit trust account until a bank transfer moves it to the property's operating account.
What happens next
- On the To transfer to operating card, select Transfer to open a bank transfer. The transfer form is filled in with the deposit trust account, the property's operating account and the amount.
- This report has no export. Read the results on the screen.
Common problems
- Security deposit report could not be loaded. The report could not read the deposit balances for this workspace. Select Apply to run the report again.
- No security deposit report rows are available for the selected filters. No deposit matches the filters. Check Property ID, Lease ID and Include historical leases, then select Apply.
- More rows available. The report has more rows than fit on the page. Select Next, or raise Page size up to 1000 and select Apply.
- The trust tieout compares account-wide trust cash with held deposits, so it requires access to all properties. Your role does not have access to all properties, so the table is not shown. Open the report with a role that has access to all properties.
- The Transfer link is missing. The link appears only when your role can create bank transfers. Without that permission, the To transfer to operating card lists the amounts without a Transfer link. Use a role that can create bank transfers.
Related articles