What is the LAR Formatting Tool?


The LAR (Loan/Application Register) Formatting Tool is a free spreadsheet that is available for bankers to download at: https://ffiec.cfpb.gov/tools/lar-formatting. It is designed to assist banks in formatting loan application data in the appropriate manner to support ongoing compliance with Home Mortgage Disclosure Act (HMDA) requirements.

Using the LAR Formatting Tool

The LAR Formatting Tool provides a standard template for submission of a bank’s HMDA data, such as:

  • Application date
  • Loan type
  • Loan purpose
  • Loan amount
  • Action taken (and date)
  • Address
  • Ethnicity of applicant
  • Race of applicant
  • Income
  • Reason for denial

The spreadsheet also includes a tab containing a “quick start guide.” The quick start guide offers seven steps for using the LAR Formatting Tool. In this tab, bankers can also access quick links to resources provided by FFIEC, HUD, and other organizations.

Streamlining Data Management

Loan application workflows in AccuAccount can make LAR reporting faster and easier. For example, users can use flex fields within the software to collect necessary information, visualize it with dynamic reporting in AccuAccount, and then export the data to populate the LAR spreadsheet.

Loan Management Resources

For more information about banking and loan management, be sure to check out our extensive resource library with free spreadsheets, whitepapers, and ebooks.

Browse our banking definitions page for more terminology.

Free Downloads

Bank auditor who is sitting at a desk and reviewing financial statements

Banks Audit & Exam Prep Study

[Study] Banks Audit & Exam Prep Learn how 187 other community bankers manage audit and exam prep. What’s Covered in this Summary Report? AccuSystems recently conducted a survey of 187 banking professionals, representing over $70 billion in combined assets at

Download for Free »
Desk that contains a laptop with the TicklerTrax spreadsheet

TicklerTrax Exception Spreadsheet

TicklerTrax™ Exception Spreadsheet Downloaded 1,000+ Times Looking for a free spreadsheet to track your financial institution’s exceptions? TicklerTrax might be the perfect tool for you! We’ve taken some of the basic logic from our top-rated document tracking system and boiled it

Download for Free »
Banker's desk that contains a stack of documents, a computer, and smartphone

eBook: Compliance & Bank Document Management

[eBook] Compliance & Bank Document Management Compliance is a tricky subject – especially when your financial institution is reliant on paper documents and manual tickler systems. In this free eBook, published by technology company, AccuSystems, you’ll encounter three compliance-related situations

Download for Free »

Related Articles