Skip to main content

Reconcile a portfolio

Upload the reconciliation file and view the reconciliation result

To reconcile a portfolio, you need to upload the file with the data from your custodian:

  1. Import the reconciliation file in Tools → Import file → Reconciliation material.

    Reconciliation_upload.png

    1. Select the format (FA format or MT535) and choose if you want to perform the reconciliation based on the transaction date or settlement date of transactions.

    2. Upload the file from your computer. When you see the file in the file list, click Confirm upload.

  2. View the results in the Reconciliation dashboard. If there are any mismatches in reconciliation, open the task to see details.

    2160394296.png
    2160033871.png

  3. Optionally, you can view the portfolios with position reconciliation mismatches in the dynamic portfolio group Position reconciliation errors. This portfolio group can be examined in e.g. Overview.

    2160033926.png

  4. Correct the errors and re-run the reconciliation.

View reconciliation errors and correct portfolio positions

You can fix the reconciliation errors while having the window with reconsiliation results open at the same time:

  1. Open the Reconciliation - Errors in the Portfolios view. All portfolios with errors have tag Reconciliation-Errors and are listed in the view.

  2. Choose the portfolio and click Reconcile → Positions at the bottom. The Reconcile portfolio window opens.

  3. Choose the reconciliation date and click Reconcile. You will see the list of mismatching portfolio poritions.

  4. While having the window open, correct portfolio positions in FA Back views if needed or use the 'Ignore' button in the UI to ignore specific item from the reconciliation.

  5. Click Reconcile to re-run the reconciliation against updated content (and save ignored items), and show the new result.

2684125259.png

Skip extra positions in FA

By default the position reconciliation checks for any extra positions in FA. If a portfolio position is missing from the reconciliation file but present in FA, the mismatch is shown in the reconciliation.

You can change this behaviour at the portfolio or security level. Change it on portfolio level if for example the portfolio contains positions from multiple different custodians and the reconciliation is done custodian-by-custodian. Change it on security level if multiple portfolios contain additional positions in certain securities and you always want to ignore them.

To disable the extra position check, add the Reconciliation:Ignore extra positions in FA tag in the Portfolio window to ignore additional positions in a certain portfolio or in the Security window to ignore additional positions in a security in all portfolios.

reconciliation_ignore_extra_positions.png

Questions about portfolio reconciliation

I have my cash balance in correct format, but for some reason system says that file amount is 0. 

Check out the decimal separator - it needs to be “.”.

My reconciliation gives POS_NFOUND errors, even if the portfolio has these positions. 

Check out the portfolio code: it can't have comma inside the code.

In this section: