On client database import add a field for "Partner" name to be associated with Client. And add a field for "Year End". These 2 items should populate the Client Dashboard on import.