Unclaimed financial assets, reconciled across every register we keep. Every dividend remitted to UFAA, every claim paid back through a holder's letter, and the balance still waiting - per shareholder, per broker, per investor pool.
Each client company's register is kept apart, in its own space. Load the files you already have - however large - and the list keeps itself reconciled.
The "Dividend 1, 2, 3 ..." sheets of amounts remitted to UFAA, loaded per shareholder and per dividend round, with every row total checked against the file.
Claims paid back through UFAA, matched to shareholders. Where the holder's letter date is not on record, the year of the claim stands in for it - and is shown as such.
CDSC accounts split into broker code, 13-digit CDSC number and investor pool, so balances roll up by broker and by pool.