CFPB Posts 2017 HMDA LAR Tool

The Consumer Financial Protection Bureau has published an HMDA formatting tool for 2017 HMDA. The tool is available at this link.

The tool allows for data entry directly into Excel, including transmittal sheet data. When the time comes to upload to the data to the HMDA platform, simply click the Create LAR File button in the top left cell! A macro will then create the properly formatted text file for upload.

The formatting tool has the added benefit of pop-ups with the possible codes for each field. I think those who relied upon the FFIEC software will find this Excel tool very user friendly and helpful. It is ready to use as soon as you download it.