Updating flood information for real-estate loans is a flood of work for any bank.
Every day, it involves a ton of manual, sit-at-the-computer labor. It requires that your bank’s Business Analysts pull lots of data from lots of disparate sources, and then stare-and-compare for things like expiring flood-insurance policies and paid-off flood loans.
These “disparate sources” include websites from your bank’s flood-insurance carrier… your master flood data compliance system… your loan-origination system… and others. It also means working in applications like Excel. And it entails finding the exceptions that require follow-up.
This is a huge amount of work; a typical regional bank must spend about six hours a day, every day, just for flood reporting!
Fortunately, it’s now possible to automate this tedious process with RPA, or robotic process automation, bots from The Lab, North America’s banking-automation authority.
Bots are faster than people. They don’t make mistakes or take breaks. They certainly don’t mind doing boring, tedious work. But just like people, they can “sit at the computer” and “swivel-chair” their way through lots of disparate applications that don’t talk to each other, eliminating the need for the “human glue” your bank currently uses to connect them all.
In this article, we’ll walk you through a typical bot as it powers its way through flood report reconciliations. We’ve also created an accompanying video for this article, which you can view right here:
We want to be perfectly clear: Although the bot in this example—from a real banking client of The Lab’s—is using systems specific to that bank, bots from The Lab can work with whatever systems your bank uses, with no need to change core platforms or data structures!
In the example shown in the video, the bot starts by logging in to CoreLogic “FloodCert,” a third-party automated flood-determination and compliance-management system. Just like a person, it has its own login and password. Once inside the system, it searches for and downloads the reports it needs.
Next, it logs into the bank’s flood insurance carrier’s website. Again, bots from The Lab can access any carrier; in this example, the carrier is Lee & Mason.
Once it’s in the system, it searches for the New Properties Report and downloads it.
Then it switches to the bank’s own SharePoint site, where it downloads the “ServiceLink Reports” and “Flood Worksheets,” and saves them an Excel sheet to the bank’s network drive.
Meanwhile, it also saves the CoreLogic “Daily Origination” report, as well as the Lee & Mason report, both as Excel sheets.
Why all the different Excel sheets? This is how the bot will perform the reconciliation! It literally parks the different spreadsheets—with either the bank’s internal master-flood data or the reporting sites’ data—side-by-side, and compares them. Using Excel’s “Spreadsheet Compare” function, it searches all the files, row by row, and even cell by cell, to find any differences and discrepancies.
It then exports its results, as an Exception Report, and uploads it to the bank’s SharePoint drive (incidentally, in just the right folder, with just the right rational filename).
The report, conveniently, has different tabs for easy navigation:
Is it done? Not quite. It also emails its report to the bank’s Flood Team. So all they need to do at this point is follow up on the few exceptions which the bot uncovered for them.
Parking a bot atop atop this tedious chore not only saves time—as we’ll detail momentarily. It also improves information security, because all credentials are encrypted and safely stored in a virtual vault.
So how much does this one bot save?
Well, it takes a person at this bank six hours a day, every day, to search through all of these systems and maintain an audit trail and spotlight discrepancies which require intervention. With the bot, it’s 100-percent automated, to the tune of 1,500 hours of labor eliminated each year, every year… forever.
Most importantly, the bot saves more than time. It saves people. Humans absolutely hate doing tedious computer work like this; it’s a big factor in bank employee turnover. But now, thanks to the bot, this bank is making its staffers feel more valued, as they get to work on more fulfilling activities.
The best way to appreciate this speed and game-changing power is to see it for yourself. We invite you to schedule your free, no-obligation 30-minute screen-sharing demo with The Lab. You’ll see real RPA bots in action, see how we do all this from our U.S. offices in Houston, with nothing outsourced or offshored, and get all your questions answered by our friendly experts. Hedge your bank against employee turnover. Eliminate errors and resulting losses. Simply call (201) 526-1200 or email firstname.lastname@example.org to book your demo today!