Input Physical Trades Data
...
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
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*:Name of counterparty
Contract No.:Every purchase and sale contract should have its own contract number. Contract number must be unique! You may use the Auto Co function to auto-fill contract number in running number if Main Contract No. exists and Contract No. is empty
Main Contract No.: Main contract number of individual contract number, you may input as necessary
Client Contract No.:
Purchase/Sale*:Purchase/Buy or Sale/Sell 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
Trader:Name of trader
Trade Mode *:
Offshore refers to offshore contracts - Cannot input 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
Entrepot - Can input Tax Rate and Exchange Rate (If Deal Currency and Product Currency are different), cannot input Custom Tax Rate
Offshore-Cross Ccy - Can input Tax Rate and Exchange Rate (If Deal Currency and Product Currency are different), cannot input Custom Tax Rate
EFP - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Long Term - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
...
Contract Ccy* :The transaction currency stipulated in the contract. This must be filled and must be exactly the same in PS Ledger or Invoice; otherwise the contract number will not appear in the Contract No. dropdown list in PS Ledger or Received invoice table for selection
Qty*:Contract quantity. Quantity will follow this order of priority when calculating P/L, PS Ledger, Invoice and Stock Management: Settlement Qty > Contract Actual Qty > Qty.
Contract Actual Qty: The actual quantity stipulated in the contract. Quantity will follow this order of priority when calculating P/L, PS Ledger, INVOICE and Stock Management: Settlement Qty > Contract Actual Qty > Qty.
Unit*:Unit of contract/product eg metric ton
Contract Tax Rate (%):The actual tax rate stipulated in the contract
Contract Pricing Date
Invoice Month:
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 > Contract Actual Price > Provisional Price
Contract Actual Price: The actual price stipulated in the contract. 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 > Contract Actual Price > Provisional Price. This must be filled; otherwise the contract number will not appear in the Contract No. dropdown list in PS Ledger or Received invoice table for selection
Contract Actual Price before Tax:
CONTRACT PRICE BEFORE TAX = CONTRACT ACTUAL PRICE/(1+CONTRACT TAX RATE(%))
if no CONTRACT ACTUAL PRICE, use PROVISIONAL PRICE
Contract Amount : Contract Actual Price/Provisional Price*Contract Actual Quantity/Quantity
if ACTUAL PRICE FLAG = TRUE, CONTRACT AMT = CONTRACT ACTUAL QTY * CONTRACT ACTUAL PRICE
If ACTUAL PRICE FLAG = FALSE, CONTRACT AMT = CONTRACT ACTUAL QTY * PROVISIONAL PRICE
CONTRACT AMT BEFORE TAX:
CONTRACT AMT BEFORE TAX = CONTRACT PRICE BEFORE TAX * CONTRACT ACTUAL QTY
If no CONTRACT ACTUAL QTY, use QTY
CONTRACT TAX AMT:
CONTRACT TAX AMT = CONTRACT AMT - CONTRACT AMT BEFORE TAX
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 Price
Pricing Date:Actual pricing date
Pricing Contract eg forward
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 10. Stock/Inventory Data in Stock Management
WH Name & Status: Name of warehouse, each warehouse’s quantity balance and Stock Type recorded in 10. Stock/Inventory Data in Stock Management will be automatically reflected here. When your cursor hovers over the column, a pop up will appear with the details
Stock Qty: Stock In/Out quantity that has been recorded in 10. Stock/Inventory Data in Stock Management
Unstock Qty: Stock In/Out quantity that has not been recorded in 10. Stock/Inventory Data in Stock Management, Un-stocked Quantity = Quantity - Stock Quantity
PSL Amt: PS Ledger amount (sum of all values in Amount column) recorded in 3. PS Ledger will be automatically reflected here. If PSL Amt has not been input yet, PSL Amt will be 0 and Bal Amt will be = Contract Amt
PSL Date: PS Ledger date (Date column) recorded in 3. PS Ledger will be automatically reflected here
Bal Amt: PS Ledger balance amount (Unpayment Amt column) recorded in 3. PS Ledger will be automatically reflected here
Balance Amount (Unpayment Amount) = Contract Amount (can be viewed from Contract No. dropdown list). If PSL Amt has not been input yet, PSL Amt will be 0 and Bal Amt will be = Contract Amt
Balance Amount (Unpayment Amount) = Contract Amount (can be viewed from Contract No. dropdown list) - PS Ledger Amount (sum of all values input in Amount column in the table)
Inv Qty: Invoice quantity recorded in 4. Invoice - Receive (sum of all values in Inv Qty column) 5. Invoice - Issue will be automatically reflected here. If Inv Qty has not been input yet, Inv Qty will be 0 and Un Inv Qty will be = Qty
Inv Amt: Invoice amount recorded in 4. Invoice - Receive (sum of all values in Inv Amt column) 5. Invoice - Issue will be automatically reflected herein Inv Amt column) 5. Invoice - Issue will be automatically reflected here. If Inv Amt has not been input yet, Inv Amt will be 0 and Un Inv Amt will be = Amt
Inv Date 发票日期: Invoice date (Date column) recorded in 4. Invoice - Receive (Inv Amt column) 5. Invoice - Issue will be automatically reflected here
Un Inv Qty: Uninvoice quantity (Un Inv Qty column) recorded in 4. Invoice - Receive5. Invoice - Issue will be automatically reflected here. If Inv Qty has not been input yet, Inv Qty will be 0 and Un Inv Qty will be = Qty
Uninvoice Quantity (Uninv Qty) = Quantity (Qty) - (sum of all values input in Inv Qty column in the table)
Un Inv Amt: Uninvoice amount (Un Inv Amt column) recorded in 4. Invoice - Receive5. Invoice - Issue will be automatically reflected here. If Inv Amt has not been input yet, Inv Amt will be 0 and Un Inv Amt will be = Amt
Uninvoice Amount (Unv Amt) = Contract Amount - Invoice Amount (sum of all values input in Inv Amt column in the table)
Remarks:Remarks