In our April release, we have made a number of cash reconciliation and usability enhancements.
Cash reconciliation enhancements
Roll ups in cash reconciliations
While we already have the ability to manually match many-to-many items or perform netting of multiple items on a single side, we have added roll up functionality to our cash reconciliations module. This allows the same kind of flexible automated aggregation that you are already used to from the rest of Duco.
Reconcile trade cash information
In addition to standard cash information, you are now able to also reconcile trade specific cash information. We have added the following fields to our cash domain:
Account code, Account name, Account type, Client reference, CUSIP, Custodian name, Entity, Fund name, Fund type, Instrument type,
Investment manager, ISIN, Narrative, Security name, SEDOL, Settlement location, Ticker, Trade change type, Transaction code,
Trade date, Trade price, Trade quantity, Trade ticket
Calculate missing balances
Sometimes your files only contain closing balances. In those circumstances, we now calculate the opening balance for you (by subtracting all of the cash movements from the closing balance). This will highlight the balance inconsistencies due to any missing statements when we compare the calculated opening with the previously closing.
Of course, your files may also only contain opening balances. In that case, we calculate the closing balance for you instead.
MT940 and MT950 balances in core reconciliations
If you are using our MT940 and MT950 formats in normal reconciliations, you could previously only reconcile cash movements. Now we have also added opening and closing balances as additional columns.
Export of reference data tables (which contain up to 100,000 items)
You are now able to export any reference data tables which contain up to 100,000 tables. The export will be in CSV format.
Drag and drop support for calculated results and workflow rules
You are now able to re-order calculated results and workflow rules by dragging them to the correct position.