Consolidated Detailed Ledgers

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.



4. Consolidated Ledgers is split into three (3) sections:
  1. Consolidated Trust Ledgers
  2. Consolidated Business Ledgers
  3. Consolidated Deposit Ledgers


5. To view Consolidated Ledger, click on the consolidated report button to open. 

Consolidated Trust ledger 

  1. Will show ledgers where any trust cashbook transactions, trust journals, fees or trust-business transfers have been posted. 


Consolidated Business Ledger

  1. Will show ledgers where any business cashbook transactions, business journals, fees or trust-business transfers have been posted. 


Consolidated Deposit Ledger

  1. Will show ledgers where any deposit cashbook transactions and deposit journals have been posted. 


6. Selected Consolidated ledger report will open.



Filter & Report Features


Filter By File Status

Select between Active, Inactive or All Files from the Status drop-down



Filter By File

Select between ALL Files or select an Individual File from the File drop-down



Filter by Date Range

Select the date range to view transactions that occurred in the selected range. 



Choose to Exclude Zero Balances

Tick to exclude files with zero balances for the specified data range.



Export Reports

To export the report, click on Export Button and select between PDF & Excel.



Search Text

To search for data within the report, type in the search field and click on the search icon (). 

    • Related Articles

    • General & Deposit Ledgers

      General ledgers will use a double-entry accounting system, which means that the transaction affects two general ledger accounts. 1. Click Accounting on the Main Menu. 2. Click Balances 3. On the main ribbon bar, select General Ledgers. 4. General ...

    • Deposit Management: Deposit Required vs Deposit cashbooks vs Deposit Investments

      The deposit that will appear on the tenant statement will depend on the manner that deposits are managed on PropWorx. Option 1: Deposits are held in the rental bank account When you choose to keep deposits in the same bank account as the rental ...

    • Loading & Managing Tenant Expenses (charges, payments, fees, deposits, provisions, general debit, credit note)

      1. Click Admin on the Main Menu. 2. Click on Customer Files. 3. Select Rental on the menu heading. 4. Click on the File Name to open the file. 5. Customer File will open. Click on Tenant Charges on the file tab ribbon bar. 6. Tenant Charges tab ...

    • Manage Deposit on Lease Tab

      The deposit that will appear on the tenant statement will depend on the manner that deposits are managed on PropWorx. Option 1: Deposits are held in the rental bank account – deposits will be journaled to the Deposit Holding account. The deposit held ...

    • Trial Balances Report

      1. Click Accounting on the Main Menu. 2. Click Balances 3. On the main ribbon bar, select Trial Balances. 4. Trial Balances is split into three (3) sections: Trust Trial Balance Deposit Trial Balance Trial Balance 5. To view trial balance, click on ...