Mortgage Application Tracker
Client
Retail Bank (Mortgages)
Problem
A $20 million online mortgage system processed 80% of applications but left no way to track those which were more complex and had to be processed manually.
This team of some 120 mortgage assessors and support staff needed a way to track mortgage applications from application to credit decision.
Solution
As all users leveraged Excel, the solution was an Excel Add-In to display screens for data entry and a central database to store data.
The solution allowed management to monitor the flow of mortgage applications, plan staff requirements and manage daily workloads.
It also allowed the business to prioritise applications to ensure they honoured their customer Service Level Agreements (SLA).
Technology
Excel, MS Access, VBA
* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.
PROFESSIONAL PROJECT PORTFOLIO
Get this FREE Portfolio of VBA Projects
Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.
Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.
Click the Download button to get instant access to this project summary as a PDF you can print or share.
BENEFIT FROM EXPERIENCE
Save time, money & stress
Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.
Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.