Finswitch File Processing and Failed Confirmations

Moorgate will process the entire FS file and import what it can and show you everything that failed on one screen -Failed Confirmations. From this screen you can edit transactions, add missing transactions, follow up on static data errors and remove or reprocess failed confirmations. Finswitch files can contain only AB/ZB balances, only HO/HC balances or a mixture of both in the file. If a single account/batch has both balance types present, AB/ZB will be used and HO/HC ignored. AB/ZB and HO/HC are treated in exactly the same way

Confirmation imports will fail for the following reasons:

• 1. Account cannot be found in Moorgate (if Missing Account setting on a Product Company level is set to fail otherwise they are ignored)

     1. Moorgate looks at the External Codes to do this check

  2. Account cannot be mapped uniquely

  3. Records have no balances (if Missing Balances setting on a Product Company Level is set to fail otherwise they will be imported and get Moorgate's balances)

  4. Opening Balance is not equal to Previous Closing Balance where the difference is greater than the import tolerance

  5. Opening Balance + sum(Transactions) is not equal to Closing Balance on Finswitch file where the difference is greater than the import tolerance

  6. Opening Balance is not zero for first import into the account (if Non-zero Opening Balance setting on a Product Company Level is set to Fail. Otherwise the batch will be imported with the non-zero opening balance)

  7. Batch is incomplete (No closing balance record when an opening balance record is present and vice versa)

• • For errors 1 and 2, we will show you what data we can map and which data we can't and allow you to go the applicable screen to fix your static data. Once all the data has been fixed, you can Reprocess the batches to import them

  • For errors 3, 4, 5 and 6 you can view the batch details alongside Moorgate's balances, capture any missing transactions if needed and save the batch to the Confirmations table

  • When an import tolerance is applied to a Fund Company, any differences between balances that is less than this tolerance (default is 1 Unit) will be imported with Moorgate's balances. This setting has been added to allow you to easily import batches where the difference is because of rounding differences. When the difference is larger than this tolerance, it typically indicates a missing transaction which needs to be captured

  • If it is the first batch imported into the account, you can also edit the Opening Balance and Date (set it to 0 units in a case where the opening balance from Finswitch was non-zero)

  • For error 7 we show you a link at the top of the failed confirmations screen which contains the records we cannot resolve into batches. We do not attempt to import this data, you will need to follow up and capture them manually

  • Once an item has been resolved it is marked as fixed

  • You can remove any failed batches without fixing them. These batches will then need to be manually captured

  • Unresolved transactions remain on the screen until fixed or removed. Fixed batches will remain on the screen for the day they were imported only

When you import the file, the dashboard will include a link 'Edit Failed Confirmations'. You can also get to this screen from Transactions>Failed Confirmations