Mortgage Processing Error Register

Client

Retail Bank (Mortgages)

Problem

Mortgage processing errors were costing this bank time & money. In order to reduce errors, they needed to know where & how they were caused.

Solution

This tactical Excel Add-In let Mortgage processors to quickly submit details of applications with errors to a database which could generate insightful reports.
As data accumulated, the client could determine which 20% of mortgage application errors caused 80% of the time delays and costs and where in the process they occurred.
This allowed them to address the causes, reduce processing time and cost of incurring errors.

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.

>