Page Comparison

1. New Physical Trades tab - For Chinese version, there is no contract amt when ACTUAL PRICE FLAG = TRUE bug fixed

Enhancement

New Physical Trades

2. New Physical Trades - Settlement tab - adjustment to calculation formulas

• PRICE BEFORE TAX = SETTLEMENT PRICE /(1+SETTLEMENT TAX RATE(%))

• if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE /(1+SETTLEMENT TAX RATE(%))

• SETTLEMENT AMT BEFORE TAX = SETTLEMENT AMT /(1+SETTLEMENT TAX RATE(%))

Enhancement

New Physical Trades

3. New Physical Trades - Updated Settlement tab - can edit Settlement Tax Rate

check

1. old physical trade pricing page

2. old physical bulk update table

3. new physical updated settlement

4. check tax rate validation. e.g, offshore should not have tax rate.

5. check if multiple update successfully

6. check pl is updated correct after multiple update tax rate.

Enhancement

New Physical Trades

4. New Physical - Settlement and Updated Settlement:

a. Change formula for PRICE BEFORE TAX:

• if trade mode = offshore:

PRICE BEFORE TAX = SETTLEMENT PRICE, if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE

• if trade mode = import/export or offshore-cross ccy:

PRICE BEFORE TAX = SETTLEMENT PRICE * EXCHANGE RATE /(1+SETTLEMENT TAX RATE(%)), if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE *EXCHANGE RATE /(1+SETTLEMENT TAX RATE(%))

• all other trade modes are just as original.

b. Now set SETTLEMENT AMT BEFORE TAX: SETTLEMENT AMT BEFORE TAX = PRICE BEFORE TAX * SETTLEMENT QTY

Enhancement

New Physical Trades

1. New Physical Trade -

• CONTRACT PRICE BEFORE TAX

after CONTRACT ACTUAL PRICE

Chinese: 合同不含税价格

CONTRACT PRICE BEFORE TAX = CONTRACT ACTUAL PRICE/(1+CONTRACT TAX RATE(%))
if no CONTRACT ACTUAL PRICE, use PROVISIONAL PRICE

• CONTRACT AMT BEFORE TAX
  after CONTRACT AMT

Chinese: 合同不含税金额

CONTRACT AMT BEFORE TAX = CONTRACT PRICE BEFORE TAX * CONTRACT ACTUAL QTY

If no CONTRACT ACTUAL QTY, use QTY

• CONTRACT TAX AMT

after CONTRACT AMT BEFORE TAX

Chinese: 合同税额

CONTRACT TAX AMT = CONTRACT AMT - CONTRACT AMT BEFORE TAX

Enhancement

New Physical Trades

5. The prices of Guangzhou Futures Exchange（GFEX) have not been updated for two days bug fixed

Enhancement

New Physical Trades

1. Dashboard - New Daily Statement model

New Feature

52. PS Ledger -

Currently, users input payment and invoice information in the same tab, we need to split them into two tabs and add some new functions.

1、For PS LEDGER tab, set PSL TYPE as PAYMENT default and can’t be modified.

2、Add upload csv file function, plz refer to the attached file.

• I have highlight all the required information

• DATE = 交易日期时间

• COMPANY = 账户名称

• COUNTERPARTY = 对方户名

• LEDGER TYPE: if amount is on “借” column，LEDGER TYPE = RECEIVED; if amount is on “贷“ column，LEDGER TYPE = PAID

• AMOUNT = amount on ”借“ or ”贷“ column

• CCY = 币种

Enhancement

New Physical Trades