Case study · project completed
Keren Paz
management fees and disclosure
Bank data on one side, a letter the client can actually read on the other.
Software we built for investment houses, for managing mutual funds and for client disclosure. It held the client and portfolio database, imported data from the banks' computers, and once a quarter printed every client a letter setting out their holdings and the management fees charged.
The route, end to end
What it had to do
Read data that was not written for it
The data arrived from the banks' computers as spreadsheets, each source in its own shape. The software worked out what actually sat in each column instead of demanding one uniform format.
Hold clients and portfolios
A database of clients and investment portfolios, onto which the quarterly figures were hung.
Compute the management fees
The calculation the disclosure rests on — and what the client finally sees in the letter.
Print to a template
A quarterly letter per client, in tailored templates, rather than a screen someone has to copy from.
What it left with us
Recognising data in a file that was not written for us, and producing an exact document per client at the end of the process — both come back today in the forms system and the document engine.
A data system for you
Data arriving from outside in a shape you did not choose, and an exact document that has to come out at the end — tell us the source and the output.