I've seen spreadsheets used but I guess a system code would work too. You aren't dealing with too many loans (unless your monitoring for HELOCs), so several methods would be manageable. The biggest challenge, of course, is to make sure you don't miss one that should have been counted so having a process to scrub/review every possible HMDA applicable loan is key, where the actual compilation is probably second. I would probably use system reports and treat it like an audit (possibly quarterly) and then compile everything in a spreadsheet. But again, there are several ways this could be accomplished.
_________________________
Adam Witmer, CRCM
All statements are my opinion, not those of my employer, and should not be taken as legal advice.
www.compliancecohort.com