How to Generate a Cashbook - Owner Ledger Report

The Cash Book displays all cash transactions for a selected period, including money received and paid, with opening, running, and closing balances.

It can be generated by:

• Bank Account – shows all transactions for the selected bank account

• Property Manager – shows transactions for all properties in the selected portfolio

• Property – shows transactions for one or more selected properties

Access:

• Trust Accountant: Accounting Reports > Cash Book

• Property Manager: Accounting Reports > Cash Book

Generate a Cash Book Report

1. Go to Accounting Reports > Cash Book

2. Select the reporting period (date range or all dates)

3. Choose to report by Bank Account, Property Manager, or Property

4. Optionally select an individual Lease or Supplier

Optional filters:

• Transactions: All, Payments only, or Receipts only

• Accounts: All codes, range, multiple codes, or portfolio fund

• Sort by Date or Account Code

• Display options: AP Invoice #, Processing Date, or @Bank

• Format: PDF, Excel, or Screen

• Show zero balance: Yes or No

5. Click Generate Report

If PDF or Excel is selected, a download link will appear at the top of the screen.