Import Trade Data

Go to Statements
Ensure the file features these exact columns ( any other extra colums will be ignored): Number of trades, Client Code, Trade Number, Buy Amount ZAR, Client name, Total Trade Capital, SDA, AIT, SWIFT Fee, Amount AIT PIN 1, Number AIT PIN 1, Amount AIT PIN 2, Number AIT PIN 2, Amount AIT PIN 3, Number AIT PIN 3, Allowance Year, Trade Book Date, FX Value Date, FX Broker, Dealer, Admin Person, Individual / Company, Deal Type, FX Buy Rate, FX Bank Rate, FX and Crypto Bought, FX Deal number, Sell Rate, OVEX Value Date, OVEX Spread, ST Partners Spread, Income from USDC sale, Bank withdrawal Fee, Total Revenue, Net Profit, Net Return, ID Number, Trade Cleared in OVEX, Date Cleared, Days in Trade, OVEX withdrawal, Month, Total Intermediary FX Spread, Total TOC Profit, BeztForex FX Spread, BeztForex FX Profit, STP FX Spread, STP FX Profit, Capitec admin fee, STP Net FX Profit, STP FX Return, STP OVEX Profit, STP OVEX Return, STP Gross Profit, STP Gross Return, Admin fees, STP Net Profit after fees, STP Net return after fees.
Import Requirements
  • File must be .xlsx format
  • First row must be headers specifically conforming to the trade mapping format
  • Existing trade `Trade Number` entries will be automatically updated
  • New entries will be seamlessly inserted