New Physical Trades

Steps:

1. Set up Company Profile

Settings>Company>Company Profile

a. As the physical trade contracts 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 user can set up a company, or multiple companies, and the first company to input in the page has to be the Parent Company. A company can have many groups under its management, and many group members can be invited under each group. The data input by each group member can be shared to and used by other members in the same group. Please refer to Step 3. Set up Group for more details.

Once the Company Profile Creator has login to the portal, please click on Settings>Company>Company Profile.

b. Please input the details (only fields with * are compulsory) and click on Save Details once done. Relevant fields input in this page will appear in the Physical Trades function for your convenience. Once members have been added to the same group as the Company Profile Creator, the members' Company Profile page will be auto filled according to that of the Company Profile Creator, so the members need not input the company profile on their own. Please refer to Step 3. Set up Group for more details.

 For more information, please access Company Profile .

2. Input Physical Trades Data

The New Physical Trade function allows users from different departments/teams to access the designated pages to input their data, ensuring a consistent operational workflow and clear delegation of responsibilities for different teams.

Please note that all data input in New Physical Trade will appear in the old Physical Trade page, and vice versa. Trades created in the New Physical Trade page will have their Actions column button disabled, which disallows editing of the trades in the old Physical Trade page.

a. Input Basic Physical Trades Data in New Physical Trade (Trade Tab)

i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,

and you will be directed to the TRADES page.

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 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.

To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.

ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to the definitions below for more information.

For auto-fill fields, please note that only empty fields will be autofilled, if the fields have values, it will not auto-update.

• 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. This is non-editable and will automatically be displayed once it has been input in the Settlement tab (will be hidden by default, user can use the filter column function to display this column)

• Phy Pricing ID: Input is not required, once you settled your trade, the ID will be generated automatically. (will be hidden by default, user can use the filter column function to display this column)

• 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.

• Main Contract No.: Main contract number of individual contract number, you may input as necessary

• 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 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

  • Entrepot - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate

  • Offshore-Cross Ccy - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and 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

If an offshore company imports/exports, there are 3 trades contracts involved:

1. Offshore companies purchase from suppliers - Offshore

2. Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export

3. 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. For this to be green, Phy Pricing ID must be filled.

• Qty*：Contract quantity. Quantity will follow this order of priority when calculating P/L, PS Ledger and Stock Management: Settlement Qty > Contract Actual Qty > Qty.

• Contract Actual Qty: The actual quantity stipulated in the contract, if the Settlement Qty is different from the Contract Actual Qty, it will be displayed in green here. For this to be green, Phy Pricing ID must be filled. Quantity will follow this order of priority when calculating P/L, PS Ledger 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, if the Settlement Tax Rate is different from the Contract Tax Rate, it will be displayed in green here. For this to be green, Phy Pricing ID must be filled.

• 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 > Contract Actual Price > Provisional Price

• Contract Actual Price: 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: Settlement Price > Estimated Price > Contract Actual Price > Provisional Price. For this to be green, Phy Pricing ID must be filled.

• Contract Amount : Quantity * Price

  • 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 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 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 Stock Management Function

• WH Name & Status: Name of warehouse, each warehouse’s quantity balance and Stock Type recorded in Stock Management Function 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 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)

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,

and click on SETTLEMENT to access the page.

All the basic trades data input in Step a (Trades tab) above will be reflected automatically in the table.

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.

To reset the filter, click on the Reset Filter button or 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 note that if AUTO P&Q is ticked, Settlement Qty and Settlement Price cannot be edited.

Please fill in the settlement data as necessary, only fields in red in the table are compulsory to be filled.

For auto-fill fields, please note that only empty fields will be autofilled, if the fields have values, it will not auto-update.

• 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*：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*：Input 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 page is 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*：Quantity, 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 Settlement Price. Settlement Price will be empty if you select Benchmark Pricing. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab. Please note that you can set the currency for both BM Pricing and Settlement Price in Fixed Pricing Ccy.

• Premium: Premium of your benchmark pricing index

• Settlement Price*: Final settlement price of trade. If empty, it will be auto filled according to Contract Actual Price, you may edit as necessary. Please note that to set the pricing for each trade, you can only choose either 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 > Contract Actual Price> Provisional Price. Please note that you can set the currency for both BM Pricing and Settlement Price in Fixed Pricing Ccy.

• Fixed Pricing Ccy*: Currency of Settlement Price or BM Pricing

• Settlement Tax Rate (%): Tax rate for trade with settlement price. 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. Quantity will follow this order of priority when calculating P/L, PS Ledger and Stock Management: Settlement Qty > Contract Actual Qty > 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: Settlement Price > Estimated Price > Contract Actual Price> Provisional Price

  • If there is no Contract Actual Price, Estimated Price will be auto filled with Provisional Price. If there is Contract Actual Price, Estimated Price will be empty for user to fill in

• 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:

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

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

• 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

• SETTLEMENT AMT 结算金额:

  • SETTLEMENT AMT = SETTLEMENT QTY* SETTLEMENT PRICE/ESTED.PRICE (Same logic as PRICE BEFORE TAX)

• SETTLEMENT AMT BEFORE TAX 不含税结算金额:

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

  • SETTLEMENT AMT BEFORE TAX = PRICE BEFORE TAX * SETTLEMENT QTY

Once done, please tick the checkbox of the trades you want to save and click on Save Changes to save your data. If you do not tick the checkbox of the rows before clicking Save Changes, no data will be saved.

All saved data will be transferred to the Updated Settlement table, please refer to Step c.

c. Update Pricing Data in New Physical Trade (Updated Settlement Tab)

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

All the settlement data updated and saved in Step b (Settlement tab) above will be reflected automatically in the table.

Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,

and click on UPDATED SETTLEMENT to access the page.

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.

To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.

Please fill in the settlement data as necessary, only fields in red in the table are compulsory to be filled.

For auto-fill fields, please note that only empty fields will be autofilled, if the fields have values, it will not auto-update.

• Trade ID：Input is not required, it will be auto-filled according to your inputs in Trades tab

• Execution ID: 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

• Pricing Mode: Input is not required, it will be auto-filled according to your pricing mode inputs in Settlement tab. It is indicate as WMA, FLOAT or SPOT according to the BM Pricing set up in Step b above. If Settlement Price is used instead, it will indicate as FIX.

• Quantity*：Input is not required, it will be auto-filled according to your inputs in Trades tab

• Cat: Category, input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited

• Title Transfer Date*: Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited. It cannot be earlier than physical trade date and cannot be after today's date

• Contract Actual Qty: Input is not required, it will be auto-filled according to your inputs in Settlement tab

• Contract Actual Price ： Input is not required, it will be auto-filled according to your inputs in Settlement tab

• Contract Ccy： Input is not required, it will be auto-filled according to your inputs in Settlement tab

• Settlement Qty : Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited

• Estd Price: Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited. It 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: Settlement Price > Estimated Price > Provisional Price.

• Settlement Price: Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited. 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: Settlement Price > Estimated Price > Contract Actual Price> Provisional Price

• Fixed Pricing Ccy: Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited.

• Premium: Premium of your benchmark pricing index (WMA, FLOAT or SPOT only). This will not be applicable for pricing mode (FIX). Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited.

• Exchange Rate: Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited.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. Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited.

• Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT. Input is not required, it will be auto-filled according to your inputs in Settlement tab, can be edited.

Once done, please click on Save Changes to save your data.

d. Input Stock/Inventory Data in Stock Management

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

Please refer to Stock Management Function for the user guide.

The system will follow this order of priority : Settlement Qty > Contract Actual Qty > Qty to calculate data.

Once stock data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

• Stock Date: The latest stock in/stock out date recorded in Stock Management Function

• WH Name & Status: Name of warehouse 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

e. Input Payment and Invoice Data in PS Ledger

If this step is not required yet, please proceed to the next step and return to complete this step when necessary.

This section displays the details of your purchase and sale ledgers for all physical trades.

The system will follow this order of priority : Settlement Qty/Price > Estimated Price > Contract Actual Qty/Price > Qty/Provisional Price to calculate data.

Contract No. of trades input in New Physical Trade table can be selected from the Contract No. column in PS Ledger.

To access this section, click on 'Trade', following by 'New Physical Trades' from the navigation sidebar on the left. Click on the 'PS LEDGERS' tab at the top of the page to access this section.

The Start Date is 1 month before today's date by default. Please feel free to change the Start Date and End Date (can be any date beyond today's date) accordingly. The dates will remain according to your settings until you log out.

You can add ledger items by clicking '+ Add Row' button located above the table. Input the details (cells highlighted in red are compulsory fields) in the row and click 'Save' once done. You may select from “Contract No..” to auto fill details in the row according to the trade execution’s details (Company, Counterparty, Quantity [settlement qty>contract actual qty>qty] , Unit, Price [Price will be autofilled according to this, in order of priority settlement price>estimated price>contract actual price>provisional price] and Amount if data is available). CONTRACT NO 合同编号: Key column linked to “PHYSICAL TRADE STATUS” 现货合同状态 app to monitor payment and invoice record.

• If Contract No. has not been selected yet aka these fields are empty, they will be auto-filled: Company, Counterparty, Quantity, Unit, Price and Amount if “Contract No.” is selected

• If Contract No. has been selected previously aka these fields are already filled, only Counterparty will change according to the Contract No. So you will need to adjust the rest of the fields manually

• Main Contract No. column has been added, you may input as necessary

Please refer to below for more information on how to input the fields. Cells highlighted in red in the table are compulsory fields and are thus necessary to input:

Date: Date when invoice or payment is made

PSL TYPE: 账类别:

a. PAYMENT 款项: Payment transaction, the amount will be used for “SETTLED AMT” 已收货款 and “SETTLED QTY” 已交重量 calculation in “PHYSICAL TRADE STATUS” 现货合同状态 app.

b. INVOICE 发票: Invoice for the payment, the amount is used for “INV AMT” 票额 and “INV QTY” 票量 calculation in “PHYSICAL TRADE STATUS” 现货合同状态 app.

Contract No.: Every purchase and sale contract should have its own contract number. You may select Contract No. from the dropdown list and other relevant fields such as Main Contract No., Company, Counterparty, Quantity, Unit, Price, Ratio [default is 100], and Amount [Price * Quantity] will be auto-filled according to the physical trade data input.

Main Contract No.: Main contract number of individual contract number, you may input as necessary. Input is not required as it will be auto-filled if you select Contract No. from the dropdown list

Company: Entity of contract, Name of your company (can be input in Settings>Company>Company Profile page). Input is not required as it will be auto-filled if you select Contract No. from the dropdown list

Counterparty: Name of counterparty. Input is not required as it will be auto-filled if you select Contract No. from the dropdown list

LEDGER TYPE:

1. RECEIVED 收款: It means the payment is received from your counterparty, it is also applied to “INVOICE” 发票 type row.

2. PAID 付款: It means the payment is paid to your counterparties, it is also applied to “INVOICE” 发票 type row.

3. AMOUNT 总额: Always positive number which is used for amount calculations in “PHYSICAL TRADE STATUS” 现货合同状态 app.

There are 2 methods:

1. Method 1:

Select RECEIVED if amount is received from counterparty

Select PAID if amount is paid to counterparty

Amount will always be positive value (+)

选择收款如果收到的金额来自于客户

选择付款如果金额是支付给客户

金额必须是正值 (+)

1. Method 2:

• If “PSL Type” is “Payment”:

Purchase, + Amount = PAID
Purchase, - Amount = RECEIVED
Sale, + Amount = RECEIVED
Sale, - Amount = PAID

• If “PSL Type” is “Invoice”: If the invoice is paid, “Ledger Type” will be PAID

• 如果“账类别”是“款项”：

采购, 正数量 = 付款
采购, 负数量 = 收款
销售, 正数量= 收款
销售, 负数量 = 付款

• 如果“账类别”是“发票”：如果发票已付款了，”分类账种类”是 PAID

DES: Description
QTY: Quantity of the contract. Once you select an existing Contract No. from the drop-down list, Quantity will be auto-filled based on your records for your convenience, you are free to adjust the quantity to balance the stock in and stock out quantity. Input is not required as it will be auto-filled if you select Contract No. from the dropdown list. Quantity will follow this order of priority when calculating P/L, PS Ledger and Stock Management: Settlement Qty > Contract Actual Qty > Qty.

UNIT: Unit of stock in/stock out transaction. Input is not required as it will be auto-filled if you select Contract No. from the dropdown list. Input is not required as it will be auto-filled if you select Contract No. from the dropdown list

PRICE: Input is not required as it will be auto-filled if you select Contract No. from the dropdown list . Order of priority: Actual Price > Estimated Price > Contract Actual Price > Provisional Price

PRICE UNIT: Price unit will be auto filled according to PRICE/UNIT

RATIO: 100% (1) by default, you may edit as necessary

AMOUNT: The system will perform auto calculations for AMOUNT if QTY, PRICE and RATIO are filled:

Formula = AMOUNT = QTY * PRICE * RATIO for most of the cases, but there is a special case where the unit is US CENT etc but CCY is USD, so AMOUNT = QTY * PRICE / 100

Ratio is in the form of % eg 100%, 5% and the system will do calculation accordingly.
CCY: Currency of PS Ledger item

REMARKS: Remarks
INVOICE NO.: Invoice number

To delete a row, tick the checkbox of the row and click on the 'Delete Row' button located above the table. You may also select multiple rows to delete. 

Several functions are available to assist in the selection of data: 

• Search bar: Search for keywords in the search bar for relevant data to be displayed

• Table Headers: 'Sort' and 'Filter' data using the functions in the table headers (Please refer to Table Settings for table functionalities).

Note:

• Validation - If any row in PS Ledger is linked to deleted trade execution, an error will be raised as trade Execution cannot be deleted until its corresponding PS Ledger item is deleted

• Validation date column cannot be bigger than today

Updates:

• After selecting Contract No., certain fields will be auto filled accordingly. If Actual Qty has been input, Quantity will be auto filled with Actual Qty, otherwise Contract Qty will be filled instead

• After selecting Contract No., certain fields will be auto filled accordingly. If Actual Price has been input, Price will be auto filled with Actual Price otherwise it will be empty instead

• In Contract No. dropdown list, add these 2 items:

  • Qty: map to qty

  • Price: map to price

• When add new row, Ratio will be 100 by default

• After selecting Contract No., Counterparty should not be in red bug fixed

• Price decimal point will follow user’s setting bug fixed

• Filter will remain in cache until user logs out or click on Reset Filter

Once PS Ledger data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

• 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 Amount: 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

3. Create/Manage Quantitative Models & Reports

Dashboard - Individual

a. After allocating paper trades (and physical trades) into the portfolio, you may create quantitative models and reports to determine the performance of your portfolios/trades. Please click on Dashboard>Individual from the navigation sidebar on the left to access the Dashboard page.

b. Various quantitative models/reports can be created and displayed in the dashboard. If you need to customise any models/reports, please notify us at support@mafint.com. You can select a model/report in the drop-down list and click 'Create' to create a new model/report.

The model/report you have just created will be displayed as empty at the beginning, which requires you to set up the details by clicking on the Settings (gear icon) button at the top right corner of the app.

c. Most Dashboard Models/Reports have similar steps. You may choose to select individual or multiple portfolios to be calculated and displayed. Please confirm other details in the Settings page before clicking Submit to proceed. You may edit the details anytime as necessary.

You may filter, arrange and categorise the rows, columns and groups according to your preferences, and may also enlarge the window accordingly.

Public/Proprietary:

PUB (PUBLIC) MARKET PRICE: If selected, the system will use the public market/settlement price obtained from various Exchange sources to perform calculations

PTY (PRIVATE/PROPRIETARY) MARKET PRICE: If selected, the system will use the proprietary market/settlement price that you have input/uploaded in Proprietary Market Data

Auto-Update：

Tick: Resets the dates to default once you leave the ‘Dashboard’ page.

Untick: Dates according to your settings remain unchanged once you leave the ‘Dashboard’ page.

 Historical GPPL (related to Historical Group P/L app)：

The Historical check box in Settings page is used to determine if you want the Compare Date to use Existing Calculated Data or Historical Saved Data for P/L comparison. This means that if you have saved the historical data for the specific End Date, you may:

• tick the Historical check box to compare End Date data against Compare Date (use historical saved data) - Compare with historical Group P/L data - Historical Group P/L data will be stored in database on a daily basis and once stored, it will not be updated. (MAF will only update for yesterday data so once user reload the Group P/L app, MAF will insert or update data if the end date is yesterday).

• untick the Historical check box to compare End Date data against Compare Date (use existing calculated data) - Compare with Group P/L from open position calculation - Daily change of open position result will always use the latest position data to do calculations

• If historical data is not available (no data is saved for the specific End Date), the respective CHG will remain as empty or 0 or the app will display a message (NO VALID OPEN POSITIONS).

For more information, please refer to Guide to Dashboard.

Physical Trades App/Reports Lists

• Counterparty Position Risk Summary

• Daily Pricing Position Change

• FX Exposure

• Group P/L

• Hedge Ratio

• Historical Group P/L

• Open Position Details

• Outstanding Physical Trade Deals

• Portfolio Grid

• Position Matrix

• Portfolio Performance Chart

• Portfolio P/L Details

• Portfolio Total P/L by Instrument Contract

• Value-at-Risk Model

Physical Trade Inventory App/Reports Lists

• Inventory Summary

• Physical Trade Inventory

• Physical Trade Status

• Inventory Stock Type Details

Please refer to Physical Trades - Dashboard Models/Reports Summary to learn more.