Tenant Statements Balances Reports

Tenant Statements Balances Reports


There are two tenant statement options available for users to access:
  1. Statement Balances
  2. Detailed Statement Balance

1. To access the various statement reports, start by clicking on Accounting in the Main Menu.


2. Click on Tenant Statements.



3. Click on Balances on the main menu



4. From the sub-menu, the user can access the following Tenant Statement reports:
  1. Statement Balances
  2. Detailed Statement Balance

Statement Balances report

The Statement Balances report displays the closing balances on all tenant statements as of the chosen date.
1. Click on Statement Balances from the menu.



2. The Statement Balances report will open. 
3. Select the Date on the calendar. The Tenant Balance column will update to the closing balances for the selected date. 
  1. Tenants in arrears – this will appear as a negative amount (e.g. -6300.00)
  2. Tenants in credit – this will appear as a negative amount (e.g. 875.99)
  3. Tenants up to date – this will appear as a zero or null (e.g.0.00)

4 Optional: Export report to excel or PDF.

Detailed Statement Balance report

The Detailed Statement Ledger report provides a comprehensive overview of all tenant statement ledgers across all customer files.
1. Click on Detailed Statement Balance from the menu.



2. The Detailed Statement Balances report will open. 
3. Select the Date Range. 



4. User is able to filter report:
  1. File Status: Choose between Active, Inactive and All. 
  2. Account Balance Status: Choose between: View All Accounts, Exclude Zero Balances, Zero Balances Only, Arrears Balances Only and Credit Balances Only.


5. Optional: Export report to excel or PDF.

    • Related Articles

    • Bulk Exporting Reports from PropWorx Web

      IMPORTANT NOTICE Each company will have different requirements for what reports they would like to download. The reports discussed here below are the most commonly downloaded reports, but there may be others that you may require. You are welcome to ...

    • Bulk Exporting Reports from PropWorx Desk

      IMPORTANT NOTICE Each company will have different requirements for what reports they would like to download. The reports discussed here below are the most commonly downloaded reports, but there may be others that you may require. You are welcome to ...

    • Audit Ready: Audit Reports & Processes

      IMPORTANT NOTICE Each company has different requirements for the reports they need to download. The reports discussed below are the most commonly downloaded, but you may need others. Feel free to contact us if you have additional requirements. These ...

    • Tenant Opening Balance

      Clients have the option to request a tenant opening balance import. They will receive a spreadsheet to input the balances, and PropWorx will handle the process of importing these balances. (fee based) 1. Click Admin on the Main Menu. 2. Click on ...

    • Consolidated Detailed Ledgers

      Consolidated ledgers will combine all the Ledgers into one report for the cashbooks of the same type (i.e. trust, business, or deposit). 1. Click Accounting on the Main Menu. 2. Click Balances 3. On the main ribbon bar, select Consolidated Ledgers. ...