Our June release contains a number of enhancements across usability, cash reconciliation and data ingestion & extraction:
Usability improvements
We have added new features to make it easier to deal with large amounts of data:
-
Drag and drop of fields on the data input screen
When the format of the input file changes, you can now re-order fields much more easily by dragging them to the correct position. -
Frozen headers and checkboxes
Headers and checkboxes stay on screen as you scroll which means that you can identify and act on items more quickly rather than having to scroll back to the top or the beginning of the columns. - Quick sum of items
A new quick sum shows you the sum of selected items (or the sum for one side only) - for the column of your choice.
We will remember which column you selected to sum in a process using cookies so that you do not have to reconfigure this every time you look at a process or a new run.
Cash reconciliation improvements
-
Smart statement ordering
If multiple statements and SWIFT message pages arrive on the same day, then these may arrive out of their intended order.
Duco automatically puts them in the correct order for you trying to find a matching closing balance for the current imported statement's opening balance.
If we happen to get this statement order wrong, you are able to manually reorder statements. -
New drill down links enable you to view the constituents of roll ups, automatic matches with tolerance and manual matches.
Drill down pages are filterable, sortable and paginated in the same way as the main view.
Data ingestion and extraction
-
FCA's transaction report data extract for MiFID II reconciliation
We have added support for the FCA's transaction report data extract which is used for sample transaction data requests under MiFIR/MiFID II.
-
Excel results API
Finally, we are adding support to download our results using our Excel results API.
This is available at /processes/{process_code}/runs/{run_id}/xlsx_results and works analogously to the XML API endpoint.
More documentation can be found in our API documentation.
Unlike our XML results API, our Excel results API is not intended for processing: Its results format may change from release to release.If you are looking to make use of a stable results API, where each results format change is versioned, the use of the XML results is strongly recommended instead.