Program Allocation by Payee Report
The Program Allocation by Payee report provides information on the amount of funds disbursed by program for each payee as well as the number of homeowner applications assisted for each payee.
To run the report:
Navigate to the Reports panel, and then select Program Allocation by Payee in the left navigation menu.
The report viewer opens in a new tab.
The report defaults to showing data for the current date. You can change the As of Date if needed.
In the report toolbar, you can page through the report; refresh the data; zoom in or out; save to Excel, PDF, or Word; print; and search.
The summary section lists the number of mortgages/expenses assisted as well as the total amount by payee.
The detail section shows a breakdown of homeowner applications assisted by payee and the total amount disbursed per program or for all programs combined.
Field | Description |
|---|---|
Summary Program Allocation by Payee | |
Payee Name | The Entity Name. |
Entity Role | The Entity Role for the payee. |
Projected Total Assistance | The sum of Actual Assistance and Remaining to be Paid. |
Remaining to be Paid | The sum of all disbursements where the Created Date <= As of Date and Current Status is Pending, or Paid Date >= As of Date. |
Actual Assistance | (The sum of all Paid Disbursements where the Created Date <= As of Date and Paid Date <= As of Date) - (The sum of all associated returns with a return date <= As of Date) |
# of 1st Mortgages Assisted | The count of all first mortgages where a payment (one-time or regular) is created and disbursed as of the As of Date. |
# of Mortgages Reinstated | The count of all distinct mortgages where a one-time payment is created and disbursed as of the As of Date. |
# of Mortgages Assisted | The count of all distinct mortgages where a regular payment is created and disbursed as of the As of Date. |
Detailed Program Allocation by Payee | |
App # | The unique application number. |
Applicant | The Homeowner Name. |
Program | The Program Alias from the Edit Program screen. |
Projected Total Assistance | The sum of Actual Assistance and Remaining to be Paid. |
Remaining to be Paid | The sum of all disbursements where the Created Date <= As of Date and Current Status is Pending, or Paid Date >= As of Date. |
Actual Assistance | (The sum of all Paid Disbursements where the Created Date <= As of Date and Paid Date <= As of Date) - (The sum of all associated returns with a return date <= As of Date) |
Underwriter AMI/NMI | Underwriter % of AMI/Underwriter % of NMI from the Edit Program Qualification screen. |
Lien # | If paying a mortgage, the numeric indication of whether it is the first mortgage, second, or so on. |
Account Number | The account number being paid. |
Property County | The County from the Property Info tab of the Edit Homeowner Application screen. |
Property Census Tract | The Census Tract from the Property Info tab of the Edit Homeowner Application screen. |