midQORT supports a range of service functions to reconcile data with other systems.
- Reconciliation of the balance of securities with the data from QUIK.
This operation is used to verify the current security positions given by the trading system.
A report is generated based on the verification results.
Reconciliation may be helpful to find short-term discrepancies for positions resulting from recently executed trades that have not been yet completely processed in the internal accounting system.
- Daily reconciliation with the backQORT back office performed at the end of the trading day.
An easy-to-use interface of the system allows the user to perform reconciliation for all reports at once with minimum actions and obtain discrepancy reports right at the workstation.
- Reconciliation of cash balance using the Intermediate Database (IDB).
This functionality is used to verify information about current positions of accounts.
The data stored in midQORT is verified against the data received from external applications via the IDB.
Based on the reconciliation results, the system displays the number of verified records and the number of discovered discrepancies, and generates a verification report. The verification results can be used to adjust positions.
Reconciliation with reports from external systems
- Reconciliation with reports from exchanges and clearing organisations
midQORT uses exchange reports to verify data against the internal accounting parameters calculated based on the information received from QUIK or another front office system, and to import missing data which is available only in the form of exchange reports.
For each report type, a certain set of fields is checked.
Discrepancies discovered during verification are recorded into a separate table named Records with discrepancies.
During the reconciliation process, not only data is verified, but it is also imported from exchange reports to the Intermediate Database for further use by other applications.
- Reconciliation with reports of the servicing broker
The system allows for reconciliation of data with reports of the servicing broker whose client is the owner of midQORT.
During reconciliation with primary broker's reports, backQORT automatically imports credited and written-off variation margins. Discrepancies discovered during reconciliation of the servicing broker with the internal accounting data are recorded into a separate table.
The system can report OTC trades to the London Stock Exchange (LSE).