Daily Cash Report


Asset Manager


Each fund manager was responsible for multiple funds.
However, to see their consolidate daily cash summary required querying a web application.

This required one query per fund, which generated a CSV (text file).

Each text file then needed to be manually consolidated.
With almost 200 funds, this was time consuming and error prone.


This Excel template allowed a user to select a fund manager and extract all their fund’s cash balances with a single click.
This produced weekly and month cash summaries with a ‘Top 10’ chart.
Reports could be easily emailed to all interested managers.
A ‘maintenance’ screen allowed you to assign funds to each manager and email recipients for each report.
This cut the task from hours to minutes.


Excel, VBA, Outlook, ActiveX Data Objects (ADO)

* 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.