Impaired Asset Manager


Corporate & Institutional Bank


‘Impaired assets’ are loans which borrowers are having difficulty repaying.
The client needed a solution which to:

  1. 1
    collate supplied Impaired Asset numbers, 
  2. 2
    reconcile these numbers against the General Ledger, and
  3. 3
    report the results to impacted managers.


This solution employed a database to centralise the submission of data.
The data was viewed and managed via screens displayed in an Excel Add-In.
Each manager could view and edit data relevant to them.
Data could be extracted to Excel using preformatted templates or pasted as raw data for further analysis.


Excel, VBA, MS Access

* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.


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.


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.