CFPB FILING FAQs - I need help formatting HMDA data into a pipe delimited text file. Is there a tool that can help?

Compliance > Regulation C - HMDA > CFPB
Q:  I need help formatting HMDA data into a pipe delimited text file. Is there a tool that can help?
 
A:   Yes. Many Loan Origination Software (LOS) systems, in addition to vendor HMDA software, can produce a pipe delimited text file for submission to the CFPB’s HMDA Platform. Microsoft® Access® or Excel® may also be used for data entry and formatting.
The CFPB also provides a Loan/Application Register (LAR) Formatting Tool into which filers can enter their HMDA data. This will produce a pipe delimited text file that can be submitted to the HMDA Platform. The filer can then proceed through the HMDA Platform to submit the LAR. This tool may be especially helpful for filers with small volumes of covered loans and applications.
 
 
ADDITIONAL INFORMATION:
This information was obtained from the CFPB’s HMDA webpage - “Resources for Filers,” FAQs:   https://www.consumerfinance.gov/data-research/hmda/faq
   

Add Feedback