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
Banks Audit & Exam Prep Study
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
eBook: Compliance & Bank Document Management
Related Articles
“No, I Don’t Have That File”
Lisa: “Hey Tony, I’d like to borrow a loan file that you checked out. The customer is here, and I need to review a few things in his file.” Tony: “What loan ...
5 Pillars of an Effective Bank Document Tracking Strategy
Document tracking is sometimes viewed as a back-office function that deserves minimal strategic thought. Banks that hold this opinion tend to struggle with inef ...
Beehive Federal Credit Union Adopts Document Imaging with AccuAccount
We’re pleased to announce that Beehive Federal Credit Union has chosen AccuAccount for the document management needs of its commercial loan portfolio. Beehive F ...
The Definitive List of Bankers’ Banks
Thanks to community banks, consumers in the U.S. have an almost unparalleled number of options when deciding who they’re going to trust with their money: some 1 ...
3 Reasons Why Imaging is a Must for Banks in the COVID-19 Era
The coronavirus pandemic has impacted almost every aspect of life—and banking is no exception. Practically overnight, bankers across the country were thrust int ...
How to Spread Financial Statements Faster with Better Data Collection
Your financial institution has made a significant investment in its financial monitoring workflow. The latest credit spread software and a well-trained credit a ...
Bankers Online: What Is It?
Bankers Online (“BOL”) is a popular website that provides helpful content, tools, and resources for professionals who work at banks, credit unions, and related ...
5 Types of Commercial Loan Software
Commercial lending is a unique aspect of the banking industry. Unlike consumer loans, which are underwritten based on a snapshot of the customer’s current cr ...
