Steps:
| Table of Contents |
|---|
1. Set up Company Profile
Settings>Company>Company Profile
a. As the physical tradecontracts need to be linked to the Company Steps:
| Table of Contents |
|---|
...
1. Set up Company Profile
Settings>Company>Company Profile
a. As the physical tradecontracts need to be linked to the Company Name, before you use the Physical Trades function, you may need to set up your company profile first (including parent and subsidiary company details).
...
The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.
...
You may choose to filter your trades based on their contract type (Purchase or Sale). If you select Purchase or Sale from the dropdown list, all the purchase or sale contracts will be displayed in the table respectively. To display all purchase and sale contracts in the table, you may select the empty optionthe table, you may select the empty option which is the default option.
If you have selected eg ”Purchase“ to display only purchase contracts, clicking on “+ New Trade” will also automatically fill Purchase/Sale column with ”Purchase“ for ease of input. If you select the empty option, clicking on “+ New Trade” will allow you to select Purchase or Sale as per normal.
...
To delete the trades, tick the checkbox of the row and click on Delete Row at the top right corner of the page.
...
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Trade Date*：Trade date of the contract
Deal No.: Deal number of the trade. Please note that if a deal number is an existing deal number, the MTM pricing will follow that of the deal number and so it will not be fillable. If the deal number input is new, you will be able to input the MTM pricing
If select existing Deal No., Deal ID and Deal Currency will automatically appear and are uneditable- If select new
Deal No.
, Deal Currency is compulsory field and will be editable. Deal ID will be empty but will be autofilled once data is saved: Deal number of the trade. This is non-editable and will automatically be displayed once it has been input in the Settlement tab
Phy Pricing ID: ID tagged to each pricingInput is not required, once you settled your trade, the ID will be generated automatically.
Product*：Product name, for example Corn
Brand: Brand 品牌：自行定义of product
Specification：Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1
Entity of Contract*：Name of your company (can be input in Settings>Company>Company Profile page)
Counterparty*：Counterparty nameName of counterparty
Contract No.：Every purchase and sale contract should have its own contract number
Main Contract No.: Main contract number of individual contract number, you may input as necessary
Purchase/Sale*：Purchase/Buy or Sale/Sell 买/卖*：采购或是销售合同。当您选择”PURCHASE”时，会显示所有采购合同，新加入的合同也默认为采购合同且无法更改。当您选择”SALE”时，会显示所有采购合同，新加入的合同也默认为销售合同且无法更改。contract. You may use the dropdown list on the top left corner to select Purchase or Sale to display the contracts respectively.
Match No.: Assign the same match number to the corresponding purchase and sale contracts for your reference
Contract Delivery Date: Contract delivery date
Trader：Name of trader
Trade Mode *：
Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate
Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate
Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
...
Offshore companies purchase from suppliers - Offshore
Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export
Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export
Contract Ccy 合同币种：合同规定的交易币种，当结算币种与合同币种不同时，这里会显示绿色：The transaction currency stipulated in the contract, if the Settlement Currency is different from the Contract Currency, it will be displayed in green here
Qty*：Contract quantity
Contract Actual Qty: Actual quantity transactedThe actual quantity stipulated in the contract, if the Settlement Qty is different from the Contract Actual Qty, it will be displayed in green here
Unit*：Unit of contract/product eg metric tonContract Tax Rate 合同税率：合同规定的数量，当结算税率与合同税率不同时，这里会显示绿色Unit of contract/product eg metric ton
Contract Tax Rate (%)：The actual tax rate stipulated in the contract, if the Settlement Tax Rate is different from the Contract Tax Rate, it will be displayed in green here
Contract Pricing Date: Contract pricing date
Margin (%) : Collateral value % deposited with the counterparty
Provisional Price: Temporary price, will be used to calculate P/L if Estimated Price or Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Contract Actual Price: Actual price transacted, The actual price stipulated in the contract, if the Settlement Price is different from the Contract Actual Price, it will be displayed in green here. This will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Settlement Price > Estimated Price > Provisional Price 合同实际价格: 实际价格，当结算价格与合同实际价格不同时，这里会显示绿色
Contract Premium 合同升贴水:
Actual Price Flag 是否终价：当合同实际价格有输入时，这里会显示“是”。当未输入合同实际价格时，这里会显示红色字体的”否“。
Pricing Date：Pricing Date
Pricing Contract 约定点价合约
BL No. 仓提单号：进出口货物提单或运单的编号。
Loadport 装运港：货物装运的港口
LP ETD 装运港预计出发时间：日期格式
Disport 卸货港：货物卸货的港口
DP ETA 卸货港预计卸货时间：日期格式
Warehouse 仓储：仓库名字，仅做记录用
Contract Premium : The premium stipulated in the contract
Actual Price Flag：Once Contract Actual Price has been input, "True" will be displayed here, otherwise, it will display “False” in red.
Pricing Date：Actual pricing date
Pricing Contract
BL No. ：Bill of lading or waybill number for import and export of goods.
Loadport：Loading port (port of shipment)
LP ETD：Estimated time of departure at the port of shipment, date format
Disport ：Unloading port (port of discharge)
DP ETA：Estimated time of arrival (unloading) at the port of discharge, date format
Warehouse ：Warehouse name, for record purpose only
Execution Status: Status of contract eg settled, pending etc
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse, inventory and Stock Type recorded in Stock Management Function will be automatically reflected here 每个仓库的库存也会在此显示.
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amt: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
Remarks：Remarks
Once done, please click on Save Changes to save your data.
...
所有与金额以及数量有关的行均在底部添加了汇总功能：All columns related to amounts and quantities have summation function added at the bottom of the table:
...
...
b. Input Pricing Data in New Physical Trade (Settlement Tab)
...
To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.
...
当您勾选自动设置价格/数量时，结算数量和结算价格自动填充，与合同实际数量与合同实际价格一致。
right-click in the table and click on Reset Filter.
...
If AUTO P&Q is ticked, the Settlement Qty and Settlement Price will be autofilled according to Contract Actual Qty and Contract Actual Price. Otherwise, you may untick AUTO P&Q before settling your trades and the respective items will not be auto-filled accordingly. AUTO P&Q is ticked by default.
...
Please fill in the settlement data as necessary, only fields in red in the table are compulsory to be filled.
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Execution ID: Input is not required, Execution ID is generated automatically
Trade Date*：Trade date of the contract
Product 产品：自动填充
Entity of Contract 公司名称：自动填充
Counterparty 客户名称：自动填充
Purchase/Sale 买/卖：自动填充
Trader 交易员：自动填充，可以修改
Contract No.：Every purchase and sale contract should have its own contract number
Trade Mode *：
Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate
Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate
Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
If an offshore company imports/exports, there are 3 trades contracts involved:
...
Offshore companies purchase from suppliers - Offshore
...
Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export
...
Input is not required, it will be auto-filled according to your inputs in Trades tab
Product：Input is not required, it will be auto-filled according to your inputs in Trades tab
Entity of Contract*：Input is not required, it will be auto-filled according to your inputs in Trades tab
Counterparty*：Input is not required, it will be auto-filled according to your inputs in Trades tab
Purchase/Sale*：Input is not required, it will be auto-filled according to your inputs in Trades tab
Trader：Input is not required, it will be auto-filled according to your inputs in Trades tab, can be edited
Contract No.：Input is not required, it will be auto-filled according to your inputs in Trades tab
Trade Mode *：Input is not required, it will be auto-filled according to your inputs in Trades tab
Deal ID: Input is not required, once you save your Deal Number, the Deal ID will be generated automatically
Deal No.: Deal number of the trade. Please note that if a deal number is an existing deal number, the MTM pricing will follow that of the deal number and so it will not be fillable. If the deal number input is new, you will be able to input the MTM pricing
If select existing Deal No., Deal ID and Deal Currency will automatically appear and are uneditable
If select new Deal No., Deal Currency is compulsory field and will be editable. Deal ID will be empty but will be autofilled once data is saved
Cat: Category of product
Unit*：Unit of contract/product eg metric tonInput is not required, it will be auto-filled according to your inputs in Trades tab
Deal Ccy: Deal currency
Title Transfer Date: Title transfer date will be auto filled according to the Trade Date of the trade if AUTO TTD at the top right corner of the pageis auto ticked (by default). You may untick AUTO TTD and fill in the title transfer date as necessary. It cannot be earlier than physical trade date and cannot be after today's date
Qty*：Contract quantity
Contract Actual Qty 合同实际数量：自动填充
Contract Actual Price 合同实际价格：自动填充
Contract Ccy 合同币种：自动填充Input is not required, it will be auto-filled according to your inputs in Trades tab
Contract Actual Qty：Input is not required, it will be auto-filled according to your inputs in Trades tab
Contract Actual Price ：Input is not required, it will be auto-filled according to your inputs in Trades tab
Contract Ccy：Input is not required, it will be auto-filled according to your inputs in Trades tab
BM Pricing*: Benchmark Pricing - Benchmark PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the pricing of your trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Fixed price Benchmark Pricing or Settlement Price. Settlement Price will be empty if you select benchmark pricing Benchmark Pricing. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab
Premium: Premium of your benchmark pricing index
Settlement Price*: Fixed Final settlement price of trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Benchmark pricing will be empty if you select fixed pricing. Benchmark Pricing or Settlement Price. Benchmark Pricing will be empty if you select Settlement Price. This will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Settlement Price > Estimated Price > Provisional Price
Fixed Pricing Ccy*: Currency for fixed of settlement price trade
Settlement Tax Rate (%): Tax rate for fixed trade with settlement price trade. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab so this field cannot be used if benchmark pricing has been used instead of fixed pricing. This will only be applicable if your trade mode is not OFFSHORE
MTM Pricing*: MTM PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the MTM of your trade. Tax rate for MTM pricing has already been pre-set in physical pricing setting tab. You do not need to select this if your deal number is an existing deal number with its own MTM pricing
Settlement Qty: Actual settlement quantity of trade 用于结算的数量。
Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Actual Price:Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Settlement Price > Estimated Price > Provisional PriceExchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT
Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
...
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Execution ID: Input is not required, Execution ID is generated automatically
Product 产品：自动填充
Entity of Contract 公司名称：自动填充
Counterparty 客户名称：自动填充
Purchase/Sale 买/卖：自动填充
Trader 交易员：自动填充，可以修改
Contract No.：Every purchase and sale contract should have its own contract number
Pricing Mode: Indicate as WMA, FLOAT or SPOT according to the BM Pricing set up in Step b above. If Fixed Price is used instead, it will indicate as FIX.
Quantity*：Contract quantity
Cat: Category of product
Title Transfer Date*: Title transfer date, cannot be earlier than physical trade date and cannot be after today's date
Contract Actual Qty: Actual quantity of trade 合同实际数量：实际采销数量
Contract Actual Price 合同实际价格：实际采销价格，自动填充
Contract Ccy 合同币种：自动填充
Settlement Qty 结算数量：用于结算的数量。
Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Settlement Price > Estimated Price > Provisional Price
Settlement Price: Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Settlement Price > Estimated Price > Provisional Price 结算价格：用于结算的价格，将会被优先使用来计算盈亏。系统对三种价格计算盈亏的优先顺序为：结算价格>估计价格>临时价格
Fixed Pricing Ccy 固定价币种：自动填充
Premium: Premium of your benchmark pricing index (WMA, FLOAT or SPOT only). This will not be applicable for pricing mode (FIX)
Exchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT
Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
...