5-NEW Reports For PREA Center Users Helps for Office Fee Allocations and PREA Recruiting program reporting.

 

 Two new time saving reports have been added to the Franchise module for Prudential Real Estate Affiliates and are included in the REAL/Easy version 14.5 upgrade CD.

 

 For multiple office companies who report to PREA Center there is a new report “Batch Office Allocation Report”. The purpose of this new report is to calculate and print a report for a selected batch that allocates the AGCI from each transaction to each office. For companies who allocate this revenue and associated franchise expense, this will be a big time saver.

 How to run this report:

 

 Select the batch to be reported on and click “Print” or “Preview”

 As shown above, the report will detail the transactions by each office based on the revenue allocated to each. For each sale in the batch, the details are printed and includes the Adjusted Gross Commission Income for each office. AGCI is then totaled for each office. (Note: the AGCI figure is the “Amount Subject to Fees” from PREA headquarters standpoint).

 If any of the transactions are cross sales between different in-house offices, the revenue is split as allocated in the transaction detail and appear within each office’s detail and AGCI totals.

 For each transaction the items display include:

1. Status:  CL means closed, “OP” means an opened still pending sale, “CN” will be a cancelled (fall thru) sale.
2. Trans No.: The “REAL/Easy” or “Reference” transaction number that is reported to PREA Center.
3. Adj: “Yes” or “No” – is this an adjustment record.
4. Property Address: as reported to PREA Center
5. OfficeID: the REAL/Easy office ID that this allocation is for.
6. Residential/Commercial: “R” or “C”
7. Unimproved?: “N” or “Y”
8. Open Date: the pending date for the transaction
9. Close Date: the closed date for “CL” status, the estimated close date for “OP” sales, or the cancel date for “CN” sales.
10. Allocated-AGCI: the allocated adjusted gross commission income from the sale to the Office ID indicated in the 5^th column.

 

 The second helpful report is the “Agent Office Ranking Report”.  This report can assist franchise member reporting requirements especially for the “Recruiting Program”. 

 

 The report allows for many types of ranking options. As shown above, there are a number of options that need to be set to obtain the desired ranking report.

 As an example, a broker wishes to rank the third quarter closed AGCI production for agents in each office that were hired since the beginning of 2004.  The report is setup as follows (view above):

1. The status of “Closed” is selected (checked).
2. The “Dated By” is set to the “Closed Date” and the third quarter date range is entered (7/1/2005 thru 9/30/2005)
3. Agent start from and to is set to “1/1/2004” through the end of the third quarter “9/30/2005”.
4. The Rank By is set to “AGCI”.

 

Above – example ranking for new recruits in the “North Branch” (OFFICE1).

 

Above – example ranking for new recruits in the “South Branch”  (OFFICE2).

 Want Everyone in your Company to Run it Like a Business? run REAL/Easy 1-800-REALEASy (1-800-732-5327)