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 ...

• Trial Balance Report - Trust, Deposit and Trial Balance

  How to view the Trial Balances Reports 1. Click Accounting on the Main Menu. 2. Click Balances on the main ribbon bar. 3. On the main ribbon bar, select Trial Balances. 4. Trial Balances is split into three sections: Trust Trial Balance - Displays ...

• 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 ...

• Audit Ready: Cashbook Recon, Financial Reports, and Year End

  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 ...

• 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 ...