The HMDA Report is used to upload data from MortgagebotLOS to QuestSoft or CRA Wiz for HMDA reporting. The loans that will automatically pull into the report are the loans that are Finaled or have been at one point in the process.
For a loan to appear in this report: A Create or Import Date must be between the Loan Creation Date Range selected.
Users have the ability to filter the report results by Institution. For the Institution field, begin typing in the name of the field response and the field options will appear as a rolodex.
A Create Date Range can be selected and will be the date range that determines the loan files that will fall into the report based on the create or import date of the loan.
Enter in the Records/Page amount which can range between ten and two hundred.
Application Date will allow users to identify if the application date within the report results will be form the 1003 > Signature Date or the 1003 > Government Monitoring Interview Date.
Date Filter will allow users to filter the report by a specific date. If Action Date is selected, then then the date filter will be based off of the Closing Docs > Closing (Note) Date. If Application Date is selected, then the date filter will be based on the Application Date selected (Interview vs Signature) in the Application Date section of the report filter. If the Creation Date Based on Date Loan Created or Imported is selected, then the date filter will be based off of the actual creation/import date of the loan into the LOS.
Report Filters section will allow users to mark the check Include Loans Have Not Been Finaled. If selected, the report will pull in loans that have not had a completed Final status in the LOS.
Loan Origination Type Filters will allow users to customize the results of the report based on the loan origination type (Wholesale, Retail, etc…) Check boxes available to mark are: Retail, Wholesale, Brokered Out, Purchased, and Correspondent.
Click Submit after all applicable information has been entered.
HMDA Report results will display.
A Printer Friendly Version link will display and if clicked, users will have the ability to print the report results.
The Beginning Date and End Date previously entered on the Report Filter will display in the upper left corner of the screen along with the Total Loans included in the report and the Total Loans Volume of all loan files in the report.
A Return to Report Filter link will display and if clicked, the user will return to the report filter to make changes and re-run the report.
The Report results will display with the following parameters: Application Number, Applicant Name, Property Street, Property City, Property State, Property Zip, SUBINCL, Application Date, Lien Type, Property Type, Loan Purpose, Occupancy, Loan Amount, Pre-approval, Action, MACODE, State Code, County Code, Census Tract, APETH, CAPETH, Application Race, Co-Applicant Race, Applicant Sex, Co-Applicant Sex, TINCOME, Purchase Type, DenialR1, DenialR2, DenialR3, APR, TREASEC, Spread, Lock Date, Loan term, HOEPA, Lien State, Quality Check, Create Date, Channel, Final Date, Application Taken By, OCCUPYURLA, Branch ID, Branch Name, Loan Rep, Loan Rep Name, Note Rate, Points and Fees, Broker, Broker Name, LTV, CLTV, Debt Ratio, Combined Ratio, Applicant Credit Score, Co-Applicant Credit Score, Penalty, Loan Program, Marital, Marital C, Applicant Age, Co-Applicant Age, Cash Out, Document Type, Amortization Term, Amortization Type, Appraised Value, Lender Fee, Broker Fee, Origination Fee, Discount Points, Primary Housing Expenses, and Monthly Debt.
To Export the report in CSV format, click the button in the upper right corner of the screen, Export CSV. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.
To Export the report in Tab format, click the button in the upper right corner of the screen, Export Tab. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.