Skip to main content

Looking for Valuant? You are in the right place!

Valuant is now Abrigo, giving you a single source to Manage Risk and Drive Growth

Make yourself at home – we hope you enjoy your new web experience.

Looking for DiCOM? You are in the right place!

DiCOM Software is now part of Abrigo, giving you a single source to Manage Risk and Drive Growth. Make yourself at home – we hope you enjoy your new web experience.

Looking for TPG Software? You are in the right place!

TPG Software is now part of Abrigo. You can continue to count on the world-class Investment Accounting software and services you’ve come to expect, plus all that Abrigo has to offer.

Make yourself at home – we hope you enjoy being part of our community.

Using Better Data for Loan Origination

Abrigo
May 5, 2016
Read Time: 0 min

In 2015, Abrigo held a focus group of more than 100 bankers to understand their goals and challenges. A recurring theme within loan origination was time-wasted with data entry – reading tax returns and typing the data into spreads. That wasted time meant lenders were spending less time trying to grow the portfolio and fostering relationships with prospective borrowers. These high-value activities were supplanted by low-value administrative activities.

The focus groups also underscored that manual entry created a risk of error and inconsistency, which causes problems during origination, loan review, and examinations. Examiners want consistency, and that’s difficult to guarantee when you have several analysts entering data in their own unique ways during origination and reviews.

The Electronic Tax Return Reader speeds loan origination

Electronic Tax Return Reader (ETRR) was created to solve these problems, saving time and improving data quality for banks. ETRR is an important component of the efficiency that a loan origination system can provide.

ETRR is a Sageworks patented technology powered by Abrigo that imports tax returns produced from a tax package and extracts the financial data using X-Y coordinates. This means that, in just a few minutes, lenders can have business, financial and real estate data ready for analysis. The technology can save lenders or analysts on average 30 minutes per return – cutting significant time for origination's tight turnarounds. The new technology makes the data accessible in any desired output, such as spreads within Sageworks Credit Analysis, in-house spreadsheets, XML data feeds, financial statements, etc.

ETRR equips bankers to upload multiple years of information at one time for individuals and businesses, so information is uniform and consistently analyzed year to year. One of the most significant features of ETRR is its ability to pull address information from the Schedule E, Part 1 from returns, which is critical for making collateral dependent loans but can often be a huge drain on time.

The technology also pulls shareholder information from a 1065 and 1120s to create a 1040 with that shareholder’s information, saving time and increasing consistency in how those relationships are analyzed at origination.

The Electronic Tax Return Reader's accuracy

Bankers may be familiar with Optical Character Recognition (OCR), which reads a scanned document and attempts to interpret the information. Abrigo's patented technology is different from OCR because of the accuracy it provides. OCR can read any tax return, even those that are scanned, but with significantly less precision. This results in a lot of data validation for the analysts.

 

Find out how your institution can benefit from better insights.

request more information

Conversely, the ETRR technology examines only electronic returns but is much more precise because the data is extracted using X-Y coordinates, meaning bankers use the right data for their analysis.

In order for ETRR to be truly innovative, there were several goals that needed to be accomplished during the development of the product. Tax return data is complex and must be entered in several places in a typical bank. For an average loan, nine tax returns are required, which are often entered three times. Intuit’s mantra for their software applications is NED2 – Never Enter Data Twice. Abrigo takes it to the next level with ETRR and its mapping technique: NED1 or Never Enter Data Once.

A hurdle in the development of the solution was identifying the minor differences produced by different software packages and then refining the mappings for each package and tax year. In addition, the software had to be smart enough to handle repeating tax schedules, large numbers, small numbers, blanks, negatives, etc. To overcome this hurdle and to attain accuracy rates of >95%, the development team had to test the technology through lots of manual iteration and technology refinement until the technology could handle the different combinations that bankers could come across.

Many banking clients using ETRR have modified their document requests to borrowers to now request electronic tax returns so this technology can be applied to an even larger portion of the portfolio, increasing efficiency across the bank. As a result, it’s transforming their processes to give analysts better quality information for decisioning and give it to them faster.

To learn more about how the ETRR can help your institution, explore the solution.

About the Author

Abrigo

Abrigo enables U.S. financial institutions to support their communities through technology that fights financial crime, grows loans and deposits, and optimizes risk. Abrigo’s platform centralizes the institution’s data, creates a digital user experience, ensures compliance, and delivers efficiency for scale and profitable growth. Make Big Things Happen.

Full Bio

About Abrigo

Abrigo enables U.S. financial institutions to support their communities through technology that fights financial crime, grows loans and deposits, and optimizes risk. Abrigo's platform centralizes the institution's data, creates a digital user experience, ensures compliance, and delivers efficiency for scale and profitable growth.

Make Big Things Happen.