Skip to main content

Reconcile a portfolio

Note

This page describes how to reconcile data in FA Back. We recommend using FA Operations application for reconciliation. For instructions, see FA Operations.

To reconcile position or cash balance data from an external source in FA Back, upload the file with external data, view the reconciliation results in the Tasks view, and correct the mismatches.

Upload the reconciliation file and view the reconciliation result

Upload the file with the data from your custodian:

  1. Open Tools → Import file → Reconciliation material and select the file from your computer. 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. View the results in the Tasks view, Reconciliation dashboard. If there are any mismatches, open the task to see details.

    2160394296.png
    2160033871.png
  3. (Optional) View the portfolios with position reconciliation mismatches in the "Position reconciliation errors" dynamic portfolio group. You can find this group, for example, in the Overview.

    2160033926.png

Correct portfolio positions

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

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

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

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

  4. While having the window open, correct portfolio positions in FA Back views if needed or use the Ignore to ignore an item.

  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 behavior on the portfolio or security level. Change it on the portfolio level if, for example, the portfolio contains positions from multiple different custodians, and the reconciliation is done custodian-by-custodian. Change it on the security level if multiple portfolios contain additional positions in certain securities that you want to ignore always.

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

Questions about portfolio reconciliation

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

Check out the decimal separator - it needs to be a dot (“.”).

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

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