Daily Reconciliation Files

Files pertaining to the Daily reconciliation process can be accessed by navigating to the Files tab in the top menu of the Daily Reconciliation page.

The available files are explained below: 

File Name

Description

AccountRiskSnapshot_YYYY-MM-DD.csv

.csv file that contains the EOD risk metrics pertaining to each account. For each Account, this file lists:

  • Cash

  • Unrealized PnL

  • Equity

  • Credit Line

  • NOP Limit

  • NOP Margin Group

  • Margin Required

  • Margin Excess

Accounting_rates_snapshot_YYYY-MM-DD.csv

.csv file that contains the EOD accounting rates for all currencies traded against entity base currency

AllAdjustments_YYYY-MM-DD.csv

.csv file that provides details of all cash adjustments entered into the system

AllCFs_YYYY-MM-DD.csv

.csv file that lists the details of cashflows that were captured during the EOD process

CancelledCFs_YYYY-MM-DD.csv

.csv file that lists the details of cancelled cashflow records captured during the EOD process

CancelledTrades_YYYY-MM-DD.csv

.csv file that lists the details of cancelled trade records captured during the EOD process

Nostro Positions_YYYY-MM-DD.csv

.csv file that contains the same information as the Nostros tab of the Daily Reconciliation

OpenTrades_YYYY-MM-DD.csv

.csv file that lists all open trades after the last EOD

Positions_YYYY-MM-DD.csv

.csv file that lists all open positions after the last EOD

Rates_snapshot_YYYY-MM-DD.csv

.csv file that lists the rates for all currency pairs with open positions

SettledTrades_YYYY-MM-DD.csv

.csv file that lists the trades details from the Maturing Trades section of the Daily Reconciliation Report

Vostro Positions_YYYY-MM-DD.csv

A csv file that contains the balance of each Vostro account in the entity