0741 NMLS Call Report Detailed Data Flow .: Knowledge Base

Instructions for using this section:

Click the image below for the corresponding Call Report that you are generating.
A dialog box for the call report will open and some fields will be highlighted in yellow.
In RMLA Section I, click the highlighted cell under the "Amount ($)" column, and another dialog box will appear with details of how the fields are populated from each loan file.
In the Mortgage Loan Originator Data section, at the bottom of the call report dialog, click any highlighted cell and a popup box will appear with details of how the Loan Originator, Amount, and NMLS ID, is populated.

NMLS Call Report - Standard - 100% Broker	NMLS Call Report - Standard - 100% Retail

Required Point fields:

The NMLS Call Report uses fields from the Track > Status and Track > HMDA screen of every loan file in order to calculate the call report.
A minimum of two status dates should be entered between application and cancelled on the Track > Status screen.
The Action Taken, Action Taken Date, Lien Status and Property Type should be filled in on the Track > HMDA screen.

ACMLO
	Start Date of the Reporting Period:		Populates from the date that you enter before generating the report. Both the Start and End date will be used to determine the time frame in which loans were active. The report will generate for loans that were active during the report period.
	End Date of the Reporting Period:		Populates from the date that you enter before generating the report. Both the Start and End date will be used to determine the time frame in which loans were active. The report will generate for loans that were active during the report period.
	RMLA Section I
	APPLICATION DATA
		DIRECTLY RECEIVED FROM BORROWER			RECEIVED FROM 3RD PARTY
	Type of Action Taken	Amount ($)	Count (#)		Amount ($)	Count (#)
AC010	Applications In Process at Beginning of the Period			Populates the total loan amount for any loan that has an Application Date on the Track > Status screen prior to the Start Date but was active during the report period. You must have either a Closed date or a date entered in any status between Application and Closed. Any status entered between Application and Closed must fall within the report period. If a loan file has an Application date prior to the start date of the reporting period but does not have any other status date, will not appear in this section.
AC020	Applications Received			Populates the total loan amount for any loan that has an Application Date on the Track > Status screen between the reporting period. The loan will appear in this section because it was an application that was started between the start and end date of the reporting period. The Application date must be filled in and fall between the reporting period.
AC030	Applications Approved but not Accepted			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Cancelled date on or before the end of the reporting period - and an Action Taken of App approved but not accepted by application. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being approved but not accepted.
AC040	Applications Denied			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Denied date on or before the end of the reporting period - and an Action Taken of Application Denied. The loan file must have a Denied date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being denied.
AC050	Applications Withdrawn			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Cancelled date on or before the end of the reporting period - and an Action Taken of Application Withdrawn. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being withdrawn.
AC060	File Closed for Incompleteness			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a cancelled date on or before the end of the reporting period - and an Action Taken of File closed for incompleteness. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being closed for incompleteness. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank.
AC062	Pre-Approved Requests Denied			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Denied date that is during the reporting period - and an Action Taken of Preapproval request denied by financial institution The Action Taken dropdown list must be selected from the *Track > HMDA* Reporting screen, "Pre-approval Requests Denied" The loan file must have a Denied date entered on the *Track > Status* screen that is during the reporting period. The Closed date on the Track > Status screen must be blank.
AC064	Pre-Approval Requests Approved but not Accepted			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Cancelled date that is during reporting period - and an Action Taken of Preapproval request approved but not accepted The Action Taken dropdown list must be selected from the *Track > HMDA* Reporting screen, "preapproval request approved but not accepted" The loan file must have a Cancelled date entered on the *Track > Status* screen that is during the reporting period. The Closed date on the Track > Status screen must be blank.
AC070	Loans Closed and Funded			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Closed on or before the end of the reporting period - and an Action Taken of Loans Originated. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. This section will not populate any loan that has originated with a closed date after the report period. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being specified as Loans Originated.
AC080	Applications in Process at the End of the Period			Populates the total loan amount for any loan that was in process during the report period but not denied, withdrawn, closed for incompleteness, or approved but not accepted. The status of the loan as described by the call report are based from the Action Taken dropdown list on the *Track > HMDA Screen*. For Example: If your report period is between 1/1/2011 - 3/31/2011 and the loan has an application date of 2/14/2011 and a closed date of 6/1/2011; the loan amount will populate in this section.
	CLOSED LOAN DATA
	Forward Mortgages	BROKERED			CLOSED- RETAIL APPLICATION		CLOSED-WHOLESALE APPLICATION
	Loan Type	Amount ($)	Count (#)		Amount ($)	Count (#)	Amount ($)	Count (#)
AC100	Conventional			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the Conventional checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC110	FHA-Insured			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the FHA checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC120	VA-guaranteed			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the VA checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC130	FSA/RHS-guaranteed			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the USDA/RHS checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC190	Total Loan Type			Populates the total loan amount for all loans (Conventional, FHA, VA, USDA), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Property Type
AC200	One to Four Family Dwelling			Populates the total loan amount for any loan was active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of 1-4 family (other than manufactured housing) The Property Type must be selected from the *Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC210	Manufactured Housing			Populates the total loan amount for any loan that was active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of Manufactured Housing. The Property Type must be selected from the *Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC220	Multifamily Dwelling			Populates the total loan amount for any loan that active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of *MultiFamily. The Property Type must be selected from the Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC290	Total Property Type			Populates the total loan amount for loans (One to four family dwelling, manufactured housing, multi-family dwelling), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Purpose of Loan or Application
AC300	Home Purchase			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and is checked as a *Purchase.* This section will exclude any loan that is a purchase and also has a check in the *Report as Home Improvement* checkbox on the *Track > HMDA* Screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC310	Home Improvement			Populates the total loan amount for loans that were active between the reporting period - has a closed date on or before the end of the reporting period - and is checked as *Report as* *Home Improvement* on the *Track > HMDA Screen.* This section will include any loan that is a purchase, *no cash-out refi, or cash-out refi* and is also checked as *Home Improvement. The loan file must have a closed date entered on the Track > Status* screen that is on or before the End Date of the reporting period.
AC320	Refinancing			Populates the total loan amount for loans that were active between the reporting period - has a closed date on or before the end of the reporting period - and a is checked as a No-Cash Out Refi or *Cash-Out Refi. This section will exclude loans that are a refinance and is also checked Report as Home Improvement* on the *Track > HMDA* Screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC390	Total Purpose of loan or Application			Populates the total loan amount for loans (Home Purchase, Home Improvement, Refinancing), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

AC400	HOEPA			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the HOEPA checkbox on the Track > HMDA screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.

	Lien Status
AC500	First Lien			Populates the total loan amount for any first mortgage loan that was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the First Mtg checkbox on Loan Application pg. 1 and First Lien selected as the Lien Status on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC510	Subordinate Lien			Populates the total loan amount for any second mortgage loan that was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the Second Mtg checkbox on Loan Application pg. 1 and *Subordinate Lien* selected as the Lien Status on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC520	Not Secured by a Lien			Populates the total loan amount for any loan that is not a first or second mortgage - was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the *Other* checkbox on Loan Application pg. 1 and *Not Secured by a lien* as the Lien Status on the Track > HMDA screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC590	Total Lien Status			Populates the total loan amount for all loans (First lien, Subordinate Lien, Not secured by a lien), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Fee Information	Amount ($)			Amount ($)		Amount ($)
AC600	Broker Fees Collected-Forward Mortgages			Populates the total origination fees from section 1 of the Good Faith Estimate for any loan that has a closed date on or before the end of the reporting period and has Loans Originated selected as the Action Taken. Loans Originated must be selected from the Action Taken dropdown list on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. **NOTE: You should insert an "X" to exclude Int Rate Credit 1, Int Rate Credit 2, and any pass-through fee in order for the "Broker Fees Collected" to calculate correctly.
AC610	Lender Fees Collected-Forward Mortgages			This field does not populate for the NMLS Call Report - Standard - Broker. It will only calculate the amount for the NMLS Call Report - Standard - Retail and NMLS Call Report - Expanded - filtered by business channel.

NOTE: The fees for the fee information section must not include pass through fees - fees that are not retained by your company. Please place an "X" without quotes under the fees that you want to exclude from the fee information field. This will exclude the fee from the fee information aggregate calculation above for all loans. These fees are located in the Fees Worksheet in Sections 1 and 2.

Fee Name:

Loan Origination

Lender's Inspection

Mortgage Broker's

Processing

Underwriting

Wire

User Defined 1

Field ID:

1023

1000

1026

5355

5356

5357

1031,

Exclude:

Fee Name:

User Defined 2

User Defined 3

User Defined 4

User Defined 5

User Defined 6

User Defined 7

User Defined 8

Field ID:

1032

1033

1002

1020

1021

1003

1004

Exclude:

Fee Name:

Rebate

Loan Discount

Int Rate Credit 1

Int Rate Credit 2

Pricing Adj 1

Pricing Adj 2

Field ID:

14149

1024

5367

5369

11711

11718

Exclude:

Forward and Reverse Mortgage Loans

Count (#)

AC900

Total Loans Brokered by your Company

Counts the number of loans that have Loan originated selected as the Action Taken on the Track > HMDA screen.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

AC910

Total Loans Funded by your Company

This field for "Total Loans Funded by your Company" does not populate for the NMLS Call Report - Standard - 100% Broker. It will only calculate the amount for the NMLS Call Report - Standard - 100% Retail and NMLS Call Report - Expanded - filtered by business channel.

Repurchase Information

AC1000

Loans Made and Assigned but Required to Repurchase in Period

This field for "Loans Made and Assigned but Required to Repurchase in Period" does not exist in Point 7.6. Please manually calculate the total loan amount and the number of all loans that are considered to be in this category.

REVENUE DATA

Amount ($)

AC1100

Gross Revenue From Operations

Calculates the Total Revenue from the Track > Loan Profit lost screen.

When the Business Channel is selected as Brokered, this amount pulls from the Total Revenue field in the Brokered Loan section.

When the Business Channel is selected as anything else or empty, this amount pulls from the Total Revenue field in the Banked Loan section.

The loan file must have a closed date entered on the Track > Status screen that is during the reporting period.

MORTGAGE LOAN ORIGINATOR DATA

EMLOYEE NAME

Amount ($)

Count (#)

MLO NMLS ID

ACMLO

Populates the Loan Originator's name from the Borrower Information screen for any loan that was active during the report period.

Populates the total loan amount for loans of a particular loan officer that was selected on Loan Application pg. 4.

Loan Originated must be selected on the Track > HMDA screen and the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information and select their name from Loan Application pg 4.

**NOTE: The loan amount will not populate if the loan originator's NMLS ID is not entered on Loan Application pg 4.

Loan Originated must be selected on the Track > HMDA screen - and also contains the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information and select their name from Loan Application pg 4.

**NOTE: The loan amount will not populate if the loan originator's NMLS ID is not populated on Loan Application pg 4.

Loan Originated must be selected on the Track > HMDA screen and the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information. Then select the originator's name from Loan Application pg 4.

ACMLO

ACMLO
	Start Date of the Reporting Period:		Populates from the date that you enter before generating the report. Both the Start and End date will be used to determine the time frame in which loans were active. The report will generate for loans that were active during the report period.
	End Date of the Reporting Period:		Populates from the date that you enter before generating the report. Both the Start and End date will be used to determine the time frame in which loans were active. The report will generate for loans that were active during the report period.
	RMLA Section I
	APPLICATION DATA
		DIRECTLY RECEIVED FROM BORROWER			RECEIVED FROM 3RD PARTY
	Type of Action Taken	Amount ($)	Count (#)		Amount ($)	Count (#)
AC010	Applications In Process at Beginning of the Period			Populates the total loan amount for any loan that has an Application Date on the Track > Status screen prior to the Start Date but was active during the report period. You must have either a Closed date or a date entered in any status between Application and Closed. Any status entered between Application and Closed must fall within the report period. If a loan file has an Application date prior to the start date of the reporting period but does not have any other status date, will not appear in this section.
AC020	Applications Received			Populates the total loan amount for any loan that has an Application Date on the Track > Status screen between the reporting period. The loan will appear in this section because it was an application that was started between the start and end date of the reporting period. The Application date must be filled in and fall between the reporting period.
AC030	Applications Approved but not Accepted			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Cancelled date on or before the end of the reporting period - and an Action Taken of App approved but not accepted by application. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being approved but not accepted.
AC040	Applications Denied			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Denied date on or before the end of the reporting period - and an Action Taken of Application Denied. The loan file must have a Denied date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being denied.
AC050	Applications Withdrawn			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Cancelled date on or before the end of the reporting period - and an Action Taken of Application Withdrawn. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being withdrawn.
AC060	File Closed for Incompleteness			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a cancelled date on or before the end of the reporting period - and an Action Taken of File closed for incompleteness. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being closed for incompleteness. The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank.
AC062	Pre-Approval Requests Denied			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Denied date on or before the end of the reporting period - and an Action Taken of Preapproval request denied by financial institution The Action Taken dropdown list must be selected from the *Track > HMDA* Reporting screen, "Pre-approval Requests Denied" The loan file must have a Denied date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank.
AC064	Pre-Approval Request Approved but not Accepted			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a cancelled date on or before the end of the reporting period - and an Action Taken of Preapproval request approved but not accepted The Action Taken dropdown list must be selected from the *Track > HMDA* Reporting screen, "preapproval request approved but not accepted" The loan file must have a Cancelled date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. The Closed date on the Track > Status screen must be blank.
AC070	Loans Closed and Funded			Populates the total loan amount for any loan that has an Application Date before or between the reporting period - a Closed on or before the end of the reporting period - and an Action Taken of Loans Originated. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. This section will not populate any loan that has originated with a closed date after the report period. The Action Taken must be selected from the *Track > HMDA* Reporting screen and is what determines the file as being specified as Loans Originated.
AC080	Applications in Process at the End of the Period			Populates the total loan amount for any loan that was in process during the report period but not denied, withdrawn, closed for incompleteness, or approved but not accepted. The status of the loan as described by the call report are based from the Action Taken dropdown list on the *Track > HMDA Screen*. For Example: If your report period is between 1/1/2011 - 3/31/2011 and the loan has an application date of 2/14/2011 and a closed date of 6/1/2011; the loan amount will populate in this section.
	CLOSED LOAN DATA
	Forward Mortgages	BROKERED			CLOSED- RETAIL APPLICATION		CLOSED-WHOLESALE APPLICATION
	Loan Type	Amount ($)	Count (#)		Amount ($)	Count (#)	Amount ($)	Count (#)
AC100	Conventional			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the Conventional checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC110	FHA-Insured			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the FHA checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC120	VA-guaranteed			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the VA checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC130	FSA/RHS-guaranteed			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the USDA/RHS checkbox on the Borrower Information screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC190	Total Loan Type			Populates the total loan amount for all loans (Conventional, FHA, VA, USDA), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Property Type
AC200	One to Four Family Dwelling			Populates the total loan amount for any loan was active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of 1-4 family (other than manufactured housing) The Property Type must be selected from the *Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC210	Manufactured housing			Populates the total loan amount for any loan that was active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of Manufactured Housing. The Property Type must be selected from the *Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC220	Multifamily Dwelling			Populates the total loan amount for any loan that active during the reporting period - has a closed date on or before the end of the reporting period - and a Property Type of *MultiFamily. The Property Type must be selected from the Track > HMDA* Reporting screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC290	Total Property Type			Populates the total loan amount for loans (One to four family dwelling, manufactured housing, multi-family dwelling), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Purpose of Loan or Application
AC300	Home Purchase			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and is checked as a *Purchase.* This section will exclude any loan that is a purchase and also has a check in the *Report as Home Improvement* checkbox on the *Track > HMDA* Screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC310	Home Improvement			Populates the total loan amount for loans that were active between the reporting period - has a closed date on or before the end of the reporting period - and is checked as *Report as* *Home Improvement* on the *Track > HMDA Screen.* This section will include any loan that is a purchase, *no cash-out refi, or cash-out refi* and is also checked as *Home Improvement. The loan file must have a closed date entered on the Track > Status* screen that is on or before the End Date of the reporting period.
AC320	Refinancing			Populates the total loan amount for loans that were active between the reporting period - has a closed date on or before the end of the reporting period - and a is checked as a No-Cash Out Refi or *Cash-Out Refi. This section will exclude loans that are a refinance and is also checked Report as Home Improvement* on the *Track > HMDA* Screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC390	Total Purpose of loan or Application			Populates the total loan amount for loans (Home Purchase, Home Improvement, Refinancing), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

AC400	HOEPA			Populates the total loan amount for any loan that was active between the reporting period - has a closed date on or before the end of the reporting period - and a check in the HOEPA checkbox on the Track > HMDA screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.

	Lien Status
AC500	First Lien			Populates the total loan amount for any first mortgage loan that was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the First Mtg checkbox on Loan Application pg. 1 and First Lien selected as the Lien Status on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC510	Subordinate Lien			Populates the total loan amount for any second mortgage loan that was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the Second Mtg checkbox on Loan Application pg. 1 and *Subordinate Lien* selected as the Lien Status on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC520	Not Secured by a Lien			Populates the total loan amount for any loan that is not a first or second mortgage - was active between the reporting period and has a closed date on or before the end of the reporting period. There must be a check in the *Other* checkbox on Loan Application pg. 1 and *Not Secured by a lien* as the Lien Status on the Track > HMDA screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period.
AC590	Total Lien Status			Populates the total loan amount for all loans (First lien, Subordinate Lien, Not secured by a lien), that were active during the reporting period and have a closed date during the report period. From the Track > Status screen, the loan file must have an application date before or during the report period and a closed date that is during the report period.

	Fee Information	Amount ($)			Amount ($)		Amount ($)
AC600	Broker Fees Collected-Forward Mortgages		This field does not populate for the NMLS Call Report - Standard - Retail. It will only calculate the amount for the NMLS Call Report - Standard - Broker.
AC610	Lender Fees Collected-Forward Mortgages			Populates the total origination fees from section 1 of the Good Faith Estimate for any loan that has a closed date on or before the end of the reporting period and has Loans Originated selected as the Action Taken. Loans Originated must be selected from the Action Taken dropdown list on the *Track > HMDA* screen. The loan file must have a closed date entered on the *Track > Status* screen that is on or before the End Date of the reporting period. **NOTE: You should insert an "X" to exclude Int Rate Credit 1, Int Rate Credit 2, and any pass-through fees in order for the "Lender Fees Collected" to calculate correctly.

Fee Name:

Loan Origination

Lender's Inspection

Mortgage Broker's

Processing

Underwriting

Wire

User Defined 1

Field ID:

1023

1000

1026

5355

5356

5357

1031,

Exclude:

Fee Name:

User Defined 2

User Defined 3

User Defined 4

User Defined 5

User Defined 6

User Defined 7

User Defined 8

Field ID:

1032

1033

1002

1020

1021

1003

1004

Exclude:

Fee Name:

Rebate

Loan Discount

Int Rate Credit 1

Int Rate Credit 2

Pricing Adj 1

Pricing Adj 2

Field ID:

14149

1024

5367

5369

11711

11718

Exclude:

Forward and Reverse Mortgage Loans

Count (#)

AC900

Total Loans Brokered by your Company

Counts the number of loans that have Loan originated selected as the Action Taken on the Track > HMDA screen.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

AC910

Total Loans Funded by your Company

Repurchase Information

AC1000

Loans Made and Assigned but Required to Repurchase in Period

REVENUE DATA

Amount ($)

AC1100

Gross Revenue From Operations

Calculates the Total Revenue from the Track > Loan Profit lost screen.

When the Business Channel is selected as Brokered, this amount pulls from the Total Revenue field in the Brokered Loan section.

When the Business Channel is selected as anything else or empty, this amount pulls from the Total Revenue field in the Banked Loan section.

The loan file must have a closed date entered on the Track > Status screen that is during the reporting period.

MORTGAGE LOAN ORIGINATOR DATA

EMLOYEE NAME

Amount ($)

Count (#)

MLO NMLS ID

ACMLO

Populates the Loan Originator's name from the Borrower Information screen for any loan that was active during the report period.

Populates the total loan amount for loans of a particular loan officer that was selected on Loan Application pg. 4.

Loan Originated must be selected on the Track > HMDA screen and the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information and select their name from Loan Application pg 4.

**NOTE: The loan amount will not populate if the loan originator's NMLS ID is not entered on Loan Application pg 4.

Loan Originated must be selected on the Track > HMDA screen - and also contains the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information and select their name from Loan Application pg 4.

**NOTE: The loan amount will not populate if the loan originator's NMLS ID is not populated on Loan Application pg 4.

Loan Originated must be selected on the Track > HMDA screen and the Loan Originator name and NMLS ID must appear on Loan Application pg. 4.

The loan file must have a closed date entered on the Track > Status screen that is on or before the End Date of the reporting period.

To populate the NMLS ID, go to Utilities > Dropdown List > Originator and then enter the originator's information. Then select the originator's name from Loan Application pg 4.

ACMLO

0741 NMLS Call Report Detailed Data Flow

Related Articles

User Comments