If your NMLS report is coming wrong every time, there are many variables that we have to check, but here I am trying to summarize fields and calculations used for the NMLS report in Encompass. This is not a complete list and nothing new, but just wish to remind you that NMLS reports are complicated if fields and calculations are missed.
AC100 – c21 – The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the Loan Type (Field 1172) is conventional
d21 – The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the Loan Type (Field 1172) is conventional
F21 – The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Loan Type (Field 1172) is conventional
G 21 – The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Loan Type (Field 1172) is conventional
I21 – The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Wholesale and the Loan Type (Field 1172) is conventional
J21 – The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Loan Type (Field 1172) is conventional
AC070 – C14 – The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered or Banked – Retail and the Current Status (field 1393) is “Loan Originated”
D14 – The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered or Banked – Retail and the Current Status (field 1393) is “Loan Originated”
AC200 – F27 – The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Property Type (Field NMLS.X16) is One-to-four Family
G27 – The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Property Type (Field 1172) is One-to-four Family
AC300 C32 Home Purchase The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the Loan Purpose (Field 384) is Home Purchase.
D32 Home Purchase The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the Loan Purpose (Field 384) is Home Purchase.
F32 Home Purchase The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Loan Purpose (Field 384) is Home Purchase.
G32 Home Purchase The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Retail and the Loan Purpose (Field 384) is Home Purchase.
I32 Home Purchase The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Wholesale and the Loan Purpose (Field 384) is Home Purchase.
J32 Home Purchase The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked – Wholesale and the Loan Purpose (Field 384) is Home Purchase.
AC400 C36 HOEPA The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the HOEPA Status (Field HMDA.X13) is HOEPA Loan.
D36 HOEPA The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and the HOEPA Status (Field HMDA.X13) is HOEPA Loan.
AC600 C44 Broker Fees Collected-Forward Mortgages Total of fees from section 801 where the Paid To is set to “B”, NMLS.X1 is not “Reverse Mortgage”, and where the channel (field 2626) is set to Brokered
AC610 F45 Lender Fees Collected-Forward Mortgages Total of fees from section 801 + (NEWHUD.x15 + NEWHUD.x788) – field 1663 where the Paid To is set to “L” or blank, NMSL.X1 is not “Reverse Mortgage”, and the channel (field 2626) is set to “Banked – Retail”
I45 Lender Fees Collected-Forward Mortgages Total of fees from section 801 + (NEWHUD.x15 + NEWHUD.x788) – field 1663 where the Paid To is set to “L” or blank, NMSL.X1 is not “Reverse Mortgage”, and the channel (field 2626) is set to “Banked – Wholesale”
AC920 C55 HECM-Standard The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
D55 HECM-Standard The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
F55 HECM-Standard The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
G55 HECM-Standard The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
I55 HECM-Standard The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
J55 HECM-Standard The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is HECM-Standard.
AC930 C56 HECM-Saver The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
D56 HECM-Saver The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
F56 HECM-Saver The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
G56 HECM-Saver The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
I56 HECM-Saver The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
J56 HECM-Saver The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is HECM-Saver.
AC940 C57 Proprietary/Other The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
D57 Proprietary/Other The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Brokered and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
F57 Proprietary/Other The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
G57 Proprietary/Other The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Retail and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
I57 Proprietary/Other The sum of the total loan amount (field 2) for all loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
J57 Proprietary/Other The total count of loans where the action date (field 749) is within the report period and where the Channel (field 2626) is Banked-Wholesale and Reverse Mortgage Type (NMLS.X10) is Proprietary/Other.
Please let me know if you need more info or you want me to see in your Encompass and find out issues in NMLS report.
