Escrow Grouping Screen

The Escrow Grouping screen allows you to group and post escrow payments for multiple homeowners made to the same payee. For example, a single check could be written to a tax authority covering all homeowners in the city, with the individual amounts posted to each individual’s escrow disbursements. The connection between homeowner and payee is initially made on the Escrow Admin tab of the Mortgage/Payments Information screen. This can make processing and reporting easier when working with groups of homeowners. To access the Escrow Grouping screen, open the Finances tab in the Keystone ribbon and click Escrow Groups.

The arrow keys can be used with this form to provide navigation similar to a spreadsheet.

Payee Selection

Use to select the escrow recurrent payee and display the homeowners who have obligations to that payee. The category assigned to the payee is also displayed here.

Field Name	Type	Description
Escrow Payee	Drop-down	The escrow payee to be paid for all of the selected homeowners in the group list.
(Category)	Read-only	The category of the selected escrow payee.

This Payment Due Date

Use to control what homeowner obligations are shown. The displayed homeowners will have obligations matching the payee and date range set.

Field Name	Type	Description
This Month	Radio button	Select to find homeowners due for payment to the selected escrow payee this month.
Next Month	Radio button	Select to find homeowners due for payment to the selected escrow payee next month.
None	Radio button	This is the default value, which is a quality control setting. Any homeowner who has an obligation to a payee but has no due date defined in their records needs to be corrected.
All	Radio button	Shows all homeowners with obligations to the selected payee, no matter when their payment is due.
From	Entry	From and Through are used to set a date range to show homeowners whose due dates fall within the selected range. The This Month and Next Month fields (above) are used to quickly set these fields to the most common values, but you can manually enter any date range you wish.
Through	Entry	See the From field (above).

Order By

Choose criteria by which to sort the homeowner list.

Field Name	Type	Description
Name	Radio button	Select to sort the homeowner information in the lower portion of the screen by name.
Address	Radio button	Select to sort the homeowner information in the lower portion of the screen by address.
Reference	Radio button	Select to sort the homeowner information in the lower portion of the screen by reference information, such as a policy or tax number.
This Due Date	Radio button	Select to sort the homeowner information in the lower portion of the screen by the due date.

Posting

Posting information for the escrow disbursement made to the payee on behalf of all of the homeowners listed.

Field Name	Type	Description
Check Date	Entry	Once the check for this amount has been created, enter the date of the check here.
Check Number	Entry	Once the check for this amount has been created, enter the number of the check here.
Notes	Memo Entry	Use for any notes about the payment to be added to each homeowner's disbursement record.

Homeowner list pane

Field Name	Type	Description
Inc	Check box	Check to include the homeowner in the payment grouping for the payee; uncheck to exclude.
Homeowner(s)	Read-only	The name of the homeowner(s). Double-click the name to open that homeowner's family partner record.
House Address	Read-only	The homeowner's address.
(Reference)	Entry	Reference information for the payment, as in the policy number or tax ID. The column heading is taken from the Reference information stored for the selected escrow payee. This heading changes depending on the payee selected on this screen.
Due Date (Last Payment)	Entry	The date on which the last escrow disbursement for this homeowner and payee was due.
Amount (Last Payment)	Entry	The amount of the last escrow disbursement for this homeowner to the payee.
Due Date (This Payment)	Entry	The date on which the current escrow disbursement for this homeowner and payee is due.
Amount (This Payment)	Entry	The amount of the current escrow disbursement for this homeowner to the payee. Disbursements always should be recorded as a negative amount.
Due Date (Next)	Entry	The date on which the following escrow disbursement for this homeowner and payee will be due.

Other fields

Field Name	Type	Description
Only Show Included (Include pane)	Check box	Check to show only homeowners whose Inc check box is checked.
Included Out Of	Read-only, calculation	Shows how many homeowners are included (Inc check box is checked) out of the total number of homeowners in the list (as in, 9 Included Out Of 10).
Total	Read-only, calculation	The total payment for all of those homeowners marked for inclusion. This is the sum of all of the Amounts in the This Payment area.

Buttons

Set To Last (in the This Payment pane) - This button can be used to set the This Payment Amount field to the last payment amount.
Clear (in the This Payment pane) - This button can be used to clear the This Payment Amount fields from each of the included records in the homeowner list. Only the homeowners marked for inclusion are affected when you click this button.
Set All (in the Include pane) - This button checks all of the Inc check boxes for the homeowners in the list. If you only need to exclude a few of the many homeowners listed, you can click the Set All button to check all of the Inc boxes and then uncheck only those you want to exclude.
Clear All (in the Include pane) - This button clears all of the Inc check boxes for the homeowners in the list. If you only want to include a few of the many homeowners listed, you can click the Clear All button to clear all of the Inc boxes and then check only those you want to include.
Close - Closes this screen.
(Send to Excel) - Use this export button if you would like to export this data to an Excel spreadsheet. You can use this spreadsheet to provide information to the payee or to perform your own analysis on your records. Clicking the Excel button exports the data for homeowners marked for inclusion to your My Documents\MoreThanData\Exported Data.csv file. Then Keystone opens your Escrow Group template using Microsoft Excel and imports the data into it.
Get Homeowner List - You only need to use the Get Homeowner List button if you enter a custom period into the From and Through fields on the This Payment Due Date pane (see above).
Post - When you are finished entering all of the information, click the Post button to post the payment. When you click the Post button, the following events occur:

The payment amount, check date and number, payee, and any note are posted to each homeowner’s disbursement history.
The homeowner’s escrow balance is modified accordingly.
The This Payment data is moved to the Last Payment data fields.
The This Payment Due Date is set to the Next Due Date.
A new Next Due Date is created.
The homeowner Inc fields are cleared.