Escrow/Trust Account reports to augment accurate tracking of escrow trust accounting and includes the following reports.

1. As-of balance by account
2. Running balance by account
3. Check register by check nuber
4. Deposit register
5. Short running balance report
6. Account running balance detail for Audits
7. Individual sales transaction ledger detail for Audits
8. Ledger detail for pending transactions
9. Ledger detail for closed transactions

The open balance report, orw-1, reports all transactions for a selected asset account having a balance as-of a specified date. Included in the report are:

• The escrow/trust balance as of the date entered
• The transaction – escrow number assigned
• The property address
• The status of the transaction (C = Closed, O=Open’pending, X = cancelled)
• The close date
• Sale type
• Sales agents and the side of sale they have
• The seller and buyer names

The account total follows the detail.

Running balance report can serve many purposes. Most common is to use it to recap daily receipts and disbursements. It also serves as an "as-of" balance report.

Included are these items:

• The individual receipt or transfer (disbursement) amount.
• The running account balance after the receipt of transfer
• The trust entry number
• The journal code (CD = Cash deposit, TT = Trust transfer)
• Date of the transaction
• The description entered
• The transaction ID or escrow number
• The property address
• The status of the transaction

For each day, totals are included. A grand total is included following the end of the transaction date range specified for the report.

The escrow check register report orw3-3 is illustrated above When the report is run a check date range is entered and the report is sorted by check numbers issued within the date range.

Items included are:

• The check number
• The check date
• The BOS journal code: TT=trust transfer SB=seller balance and BB=buyer balance
• Transaction ID and address
• Buyer name(s)

If there were any check reversals these are shown also and totaled separately.

The escrow deposit report orw3-4 is illustrated above When the report is run a deposit date range is entered and the report is sorted by deposit date.

Items included are:

• The check number
• The deposit date
• The BOS journal code for check deposit
• Transaction ID and address
• Buyer name(s)

If there were any deposit reversals these are shown also and totaled separately.

To assist with account auits, the orw3-6 account Running balance report is used. Account receipt, disbursement, and running balance details can be provided for any time range.

The report title includes:

• The account number
• The date range of detail trust activity reported

Included are these items:

• The individual receipt (column 1) or transfer/disbursement (column 2) amount.
• The running account balance after the receipt of transfer
• The trust entry/transaction number
• The journal code (CD = Cash deposit, TT = Trust transfer)
• Date of the trust transaction
• The receipt/disbursement check/reference number and payee name
• The trust activity description/purpose
• The sales transaction ID or escrow number
• The property address
• The status of the sales transaction
• The names of the seller and buyer

The individual transaction ledger report is used to assist in audits as well as for insertion within the sales folder. The orw3-7 ledger shown above includes all trust activity for a selected property.

The report title includes:

• The transaction number, address, and current status
• The names of sellers and buyers
• The transaction close date
• The trust account number and name

Included for each receipt and disbursement are these items:

• Individual receipt (first column) or transfer/disbursement (column 2) amount.
• The running account balance after the receipt of transfer for the sales transaction
• The trust entry number
• The journal code (CD = Cash deposit, TT = Trust transfer)
• Date of the trust transaction/activity
• The reference or check number and payee
• The description of the escrow-transaction

These two additional reports reports have the same format but are run differently:

• orw3-8 Will report on all pending transactions within a selected pending date range

orw3-9 Will report on all closed transactins within a selected close date range