Thread Options
|
#1632590 - 11/28/11 04:38 PM
Need an effective HMDA process
|
Platinum Poster
Joined: Feb 2003
Posts: 962
PA
|
Current process - Loan officers fill out a "HMDA data collection worksheet" for those loans they determine to be HMDA reportable. A person in Loan Administration reviews all loan files and for those with a completed HMDA worksheet, enters the data onto the LAR.
Problems encountered - We have loans that should be HMDA reportable, that do not make it to the LAR. This is because the loan officers don't always catch all the reportable loans. We also have some loans entered to the LAR, and they are not HMDA reportable. Again, this goes back to the loan officer's incorrect interpretation. We also have data errors on the LAR - input errors and also errors because the loan officers fill out the worksheet incorrectly compared to the actual loan file.
Any suggestions?
|
Return to Top
|
|
|
|
#1632612 - 11/28/11 05:18 PM
Re: Need an effective HMDA process
Kathleen O. Blanchard
|
Power Poster
Joined: Sep 2010
Posts: 2,658
|
I agree with KB. The most critical element you need to implement is an effective control to review these entries for accuracy(data integrety) and to search for missing loans (omissions). Both a data integrety review and an omission review should be implemented in your process.
I have seen many banks try to implement this but still fail. Those banks that do HMDA well have one person responsible for the review process; the less hands in the pot the better. That person typically looks at loan origianation reports for each month to identify omissions and reviews all entries for accuracy. Issues are sent back to the officer/imputers to correct. Also, the Banks that do HMDA well typically conduct quarterly audits on top of the review process (conducted by someone seperate from the review process).
You will have to find a process that fits your organization. Ideally, the process will implement both a control (review) and a test (audit) of LAR accuracy (data integrety) and LAR completeness (omissions).
_________________________
Adam Witmer, CRCM All statements are my opinion, not those of my employer, and should not be taken as legal advice. www.compliancecohort.com
|
Return to Top
|
|
|
|
#1632664 - 11/28/11 06:32 PM
Re: Need an effective HMDA process
Adam Witmer
|
Platinum Poster
Joined: Feb 2003
Posts: 962
PA
|
Is that "HMDA worksheet" that the loan officers complete even worthwhile then if the data input person should be entering the info from the actual file? Maybe it just adds another step that doesn't add value to the process?
Last edited by AuditorK; 11/28/11 06:36 PM.
|
Return to Top
|
|
|
|
#1632781 - 11/28/11 09:22 PM
Re: Need an effective HMDA process
Truffle Royale
|
Gold Star
Joined: Nov 2007
Posts: 437
Nevada
|
Truffle, would you elaborate on "LAR is scrubbed using excel pivot tables"? This implies you are creating a spreadsheet from your data, rather than using a worksheet? Or are you downloading the FFIEC report to an excel format? Being unfamiliar with pivot tables, can you just summarize how they assist in the scrubbing process? We currently use a HMDA worksheet, which is completed using the application and closing docs. Trying to improve/fine tune our process.
|
Return to Top
|
|
|
|
#1632782 - 11/28/11 09:24 PM
Re: Need an effective HMDA process
Marnie
|
10K Club
Joined: Oct 2006
Posts: 14,390
Cheeseheadland
|
Out of curiosity, how many lines do you normally report annually for your LAR?
_________________________
I don't repeat gossip, so listen closely...
|
Return to Top
|
|
|
|
#1632886 - 11/29/11 02:15 PM
Re: Need an effective HMDA process
Kathleen O. Blanchard
|
Power Poster
Joined: Sep 2004
Posts: 5,249
out of the frying pan...
|
Small shop here, and I just came to this bank in late May. I have made a few small changes to the process in the name of efficiency, but it is largely still a by-hand undertaking simply because we lack the technological tools to automate it further at this time. For right now (and accuracy IS slowly improving since I've put this process in place):
1. Processors complete the HMDA form/worksheet and send it to imaging/filing with the loan. 2. Loan clerks assemble and scan the HMDA "package" to the loan record, then notify me once a week of all the HDMA loans scanned that week. The HMDA package is simply the form plus copies of any documents needed to verify the information being reported. 3. I review and verify the information in the HMDA packages, sending any necessary corrections back to the processors. 4. I key in all data to the FFIEC software after it has been verified. 5. I pull a report of all new loans booked each month with residential collateral codes and check it against the LAR to catch any that may have been missed.
I will also be performing a 100% scrub of the LAR before submitting it. It's too easy to make simple typo mistakes when keying this stuff in, plus I have not yet reviewed any of the entries that were made before I took over the reporting.
_________________________
You call it ADD. I call it multi-tasking.
|
Return to Top
|
|
|
|
#1633414 - 11/30/11 01:40 PM
Re: Need an effective HMDA process
RR Becca
|
Platinum Poster
Joined: Feb 2003
Posts: 962
PA
|
RR Becca,
This is pretty similar to how I envision changing our process. We certainly need more controls that we currently have. I want to leave some of the responsibility on the loan officers (i.e. - completing the worksheet) and then there would be one other individual to (1) review the worksheets and verify data, (2) review new loan reports to capture those missed, (3) enter the verified data to the FFIEC software. This last step may be assigned to another individual - not sure yet.
|
Return to Top
|
|
|
|
#1633428 - 11/30/11 02:03 PM
Re: Need an effective HMDA process
Kathleen O. Blanchard
|
10K Club
Joined: Sep 2002
Posts: 13,965
TN
|
Here we have someone in loan operations review all originated loans for HMDA purposes. She completes the form and forwards it on to someone else for input. I am to see all denied/withdrawn/closed for incompleteness files and review for HMDA purposes <along with Reg B>. The same individual inputs onto the FFIEC software <we have less than 500 lines per year>. Quarterly I review the HMDA additions for the previous quarter and then again before submission. Not perfect, but works fairly well.
_________________________
My Opinions Only
|
Return to Top
|
|
|
|
#1633436 - 11/30/11 02:08 PM
Re: Need an effective HMDA process
Skittles
|
Power Poster
Joined: Sep 2004
Posts: 5,249
out of the frying pan...
|
I would love to go to a system more like Skittles, but our loan operations aren't centralized. What I've got is about the best I can do for now as long as the branches are all doing their own work.
_________________________
You call it ADD. I call it multi-tasking.
|
Return to Top
|
|
|
|
#1635249 - 12/05/11 04:02 PM
Re: Need an effective HMDA process
Marnie
|
10K Club
Joined: Jul 2003
Posts: 17,400
|
Truffle, would you elaborate on "LAR is scrubbed using excel pivot tables"? This implies you are creating a spreadsheet from your data, rather than using a worksheet? Or are you downloading the FFIEC report to an excel format? Being unfamiliar with pivot tables, can you just summarize how they assist in the scrubbing process? We currently use a HMDA worksheet, which is completed using the application and closing docs. Trying to improve/fine tune our process. Marnie, sorry I didn't see this sooner. Been really busy around here. Everyone knows I'm a huge advocate of pivot tables. read this This thread had a lot of good info too. Feel free to pm me if you want pivoting help.
|
Return to Top
|
|
|
|
|
|