Office Reports - Short Descriptions

Office Reports

Registers

Register of Activity in the Trust Account

Previously named: Register of Transactions in the General Trust Account
Displays all activity by date or by file in the trust account for the selected period. This report should also match the trust bank reconciliation and the trust liability G/L account.

Register of Activity in the Commission Account

Previously named: Register of Transactions in the Commission Account
Displays all activity by date or by file in the commission trust account for the selected period.

Register of Agents

Displays a real-time report showing all agents and their personal details (license number, hire date, contact information, corporation details).

Register of Brokerage Contracts

Displays a register of all brokerage contract/listing agreements represented by agents within the brokerage.

Register of Transactions

Displays a register of all deals and other income within the brokerage for a selected file number sequence.

Register of Disclosure Notices

Displays a register of all disclosure notices for a selected date range.

Register of Keys

Displays a list of transactions that have a key added to the listing.

Deals Reports**

Pending Deals Report

Previously named: Deals Report & Deals Report – Age of Files (2 reports merged)
Displays an overview of pending deals in two different versions. The summary version will display the office commission receivable and the external commission with expected closing dates. The aging version will display the commission receivable (30/60/90+ day) based on expected closing date.

Pending Deals - Potential Revenue Report

Previously named: Report of Income Forecast
Displays open/pending transactions to show the amount of revenue that will be collected by deduction categories or by file for a selected period.
Note: This report will only show open/pending transactions at the time the report is generated.

Pending Deals - Balance Receivable Report

Previously named: Deals Report (Balance Receivable)
Excel file that displays pending deal details. Details will include commission payable information and what is outstanding from outside brokerages. This report may also be referred to as the Pending Transaction Report.

Pending Deals with Unfulfilled Conditions Report

Previously named: Conditional Deals Report
Displays a list of all deals with unfulfilled conditions up to a specific date.

Deals Report (All Steps)

Previously named: Deals Report (Administrative Reports > Deal Reports)
Displays an overview of deal details for a selected period, regardless of the deal status.

Commission Reports

Commission Report (Summary/Global)

Displays the commissions paid to the office's agent and/or the external agents.
Note: Commissions will show up only if a commission calculation was processed.
The report will display the commissions per transaction and will separate the office deductions, which do not show up on the T4A of the agents, from the total commission amounts.

Commission Comparison Year Over Year Report

Previously named: Monthly Commission Statistics
Ranks agents using different criteria such as commission on closed deals, commission on pending deals, and total commission for a selected accounting period. It will compare the agent’s commission amounts year over year.

Commission Analysis & Agent Ranking Report

Previously named: Commission Volume Report
Displays the commissions on transactions with a firm date in the selected period. The commissions will be displayed whether the deal was closed or not.
The report ranks the agents based on YTD commissions and displays:

• Commission of the selected period
• YTD commissions
• Commissions on deals cancelled during the selected period

Commission Agent Ranking Report - Annual

Previously named: Annual Deal Statistics
Displays the agent rank and total commissions on deals (accepted offer date in the month) and closed deals (closed date in the month) for a selected period on a month-by-month basis. **

Commission Agent Ranking Report - Monthly

Previously named: Monthly Deal Statistics
Ranks agents based on their deal and/or closed commission amount for a selected month.

**Commission Performance Report

Previously named: Performance Report
Displays agents' commissions on pending and closed deals for the selected period.

• The deal (column) commission amount will display transactions with an expected closing date in the selected period.
• The closed deals (column) commission amount will display a transaction with a commission calculation in a selected period.

The report will also compare the selected period to year-to-date results and any forecasted amounts (if applicable).

**Commission on Firm Deals Report

Previously named: Report of Firm Deal Revenues
Ranks total commissions by agent on deals that became firm in a selected period, with an option of separating the paid commissions and the expected commissions.
If a transaction was paid in the selected period but the firm date is not, the commission will not appear on the report.

**Commission Reduction Report

Displays the amount of commission that is reduced by the agent in relation to the expected and/or average commission percentage. This report will show the amount of revenue that is “left on the table”.

**Commission Advances Report

Displays the agents' outstanding commission advances attached to a real estate transaction, whether or not the advance came from the office or an external discounter. This report will not display general advances to the agents. The period selection is based on the date of the advance.

**Commission Distribution Report

Previously named: Commissions Distribution
Displays the agent’s role, the distribution of volume (in %) and the commission amount for each transaction for a selected period.

Deduction Reports

**Deduction Report

Displays the deductions on the cheque taken on the agents' commission payments that occurred in the accounting periods selected. The report will also display all amounts that were withheld and reimbursed to the agent during the same period.

**Deduction Report - Commission Fees

Previously named: Commission Deduction Report
Displays the Commission Deductions taken on the commission calculations that occurred in the date period selected. The deductions displayed are before taxes. The date displayed is the commission calculation date.

**Deduction Report – Declining Balances

Displays how an agent is progressing in reaching the caps that were established for deductions categories. The deduction cap will be displayed at the top of the report and every deal on which a deduction was taken will be displayed, allowing to track the declining balance.

Real Estate

Accounts Receivable vs Commission Receivable Report

Displays an agent’s total commission receivable and how it compares to the amount the agent owes to the brokerage for a selected period.

**Transaction Step Status and Data Entry Report

Previously named: Real Estate Data Report
Displays a list of transactions in a specific step (Listing, Deal, Closed) for a selected period. No commission information is included. The summary version will display the number of transactions per day per month.

**Comparative 5 Years Report – Global

Compares the number of listings, the number of deals and the total commission amount by month for the selected year and the 4 previous years.

**Business Volume Report

Previously named: Summary of Business Volume
Excel file that displays a detailed list of transactions in the selected period, showing for each transaction:

• Listing and Deal volume
• Listing and Deal ends
• Listing and Deal commissions

**Transaction Volume and Ends Ranking Report

Previously names: Number of Transactions per Agent/Sub-Franchisee
Displays a ranking of agents based on volume and/or number of ends for listings, deals or closed deals.
Note: This report can be run by volume or by weighted.

Transaction Report by Step

Previously named: Transaction Statistics
Displays transactions by step type (listings, deals, cancelled deals, closed deals) for a selected period. If a transaction goes from step to step within the selected period, the transaction could appear in each section of the report.

Summary of Transactions and Commissions Report

Excel file that displays a summary of an agent’s monthly and year-to-date commission which includes listing/deal volume and listing/deal ends by expected closing date.

**Brokerage Roster Statistics Report

Previously named: Monthly Statistics
Displays the number of agents with licenses, agent numbers and deal statistics per office.

**Balance on Closed Transaction Report

Previously named: Closed Transaction Report
Displays the remaining balance in each (eZmax) bank account for closed transactions in a selected period.

Expected Closing Dates Report

List of pending transactions sorted by expected closing date.

**Listings Expired or About to Expire Report

Displays new or active listings that have an about to expire or past expiry date in a selected period. A listing with a past expiry date can be selected and marked as "Expired".

Required Documents Report

The list of any incomplete transactions with the missing required documents in those transactions.

Report of Documents in File

Displays a list, sorted by transaction, of the documents on file with the following information:

• Date the document was added
• Document name and document type
• Ability to download the document from this list

Deposit Activity on Transactions Report

Previously named: Deposit Transaction Report
Displays a list of deposit activity of a transaction, by bank account, for a selected period.

Deposit Certificates Report

Displays a list of deposit certificates by bank account for a selected period.

Mortgage Details Report

Previously named: Mortgage Referral Report
Displays all mortgage details entered in a specific deal.

Other Income Report

Displays other income commission details such as amount, type and description by file for a selected period. The other income commission calculation must be completed for it to show up on the report.