TRADEQ - Trading Position analysis/reporting
What is TRADEQ
This procedure has many different styles of report from the TRADE database, primarily to assist in position monitoring although the ReportWriter will allow for the construction of any report content.
The styles include:
1. Simple selections and simple factory built report layout which is easily modified by use of mouse right-click. The contents of the IDD (TRADE/phys01) can be included/excluded by mouse click or drag and drop, see Grid navigation for more detail.
2. The Open position report lists tonnages that have not been marked as Sales Invoiced. This is a fixed layout ordered by commodity/shipment period with a selection of TRADE information mainly pertaining to weight, price, costs and financial market value. The ‘open position tonnage’ is determined as the %quantity that has not been Sales Invoiced which is viewed on the report and in TRADE ‘invoice marking’. There is a company consolidation mode for this style whereby the user selects the companies to be included. The consolidation mode will exclude any Positions that are recognized as inter-company i.e. their counter-party is setup in CLI as a Group account.
3. Purchase and summary which will show allocated trades side-by-side with their (Gross or Net) estimated P&L.
This report can be manipulated by the user to list specific IDD nominated TRADE fields (use mouse right-click when the grid is displayed). This is a powerful tool but be careful with content because of the complexity of side-by-side and Margin calculations
4. Trade Net Position, this report complements GENENQ/TradeNet whereby similar presentation but allows for different sequencing/grouping of trade information. As per TradeNet, open futures trades are also included
6. List outstanding Broker/agent Commissions payable/receivable. In TRADE, you can view the individual contract's status as regards commissions marked as paid/received. This report, with your filters, will list the Agent's details that remain as less than 100% actualised.
7. Consolidation of contract parts into a single line of details per contract/commodity, useful for reviewing shipped tonnage versus contracted tonnage. Can drill down to the component sub records
8. List missing/unused contract references. If the operating company is using it's own register of references and manually entering those trade references, it is useful to view if there are any missed items. Use filter on Contract Ref and type 'between 100000.000 and 120000.000'
9. List TRADE costs in columns per contract, useful for review prior to any Management P&L reporting
10. N/A
11. Freight Fixings, report will list tonnage that are due to be shipped and have an estimated cost for freight and they have not been assigned to a Charter/WIP account .
12. List contracts where a Registration price has not yet been entered
13. Registration Price Risk, report will locate TRADE Price Fixing contracts where the Registration Price is maintained and compare that price with current price. A risk calculation in contract/settlement currency and target currency will be included.
14. Report contracts that have a Registration Price and require a Final Invoice.
15. FX cover status, will report (according to user selections) the to-cover requirement of TRADE tonnage and the detail status of FX covered TRADE tonnage.
16. Commissions Performance Report; the report is produced in Country/Broker sequence and will report items outstanding for pay/receive and will also list 100% marked items that are dated in this fiscal year (according to ITAS menu date).
17. Invoiced Status, reports Goods and Costs that have been invoiced and there is a variance between expected and invoiced that is within a tolerance entered by the user. E.g. if tolerance is 10% then items that are at variance between 1 à 90% will be reported. The variance for ‘Goods’ is calculated using the current contract value and what has been marked as invoiced. The ‘Costs’ reporting is strictly on what has been maintained in INVOICING as being the actualized %, i.e. the % that is viewed in the TRADE/Costs grid.
18. Transfer Price Differences, reports where a TRADE tonnage has been transferred into STOCKS, into a Tolling or a Mix and the transfer (accounting) value is different to the current TRADE pricing (tolerance +/- 1 monetary unit). Situations occur where an intake is made at a provisional price and later price fixing on TRADE requires a retrospective adjustment of the transferred value (in both TRADE and the accounting). The data field phys01_stockref must have been setup with the accounting document reference so that this procedure can operate.
19. TRADE costs and variances. Performance analysis of estimated costs and their actualised values, indicating where there are over/under values. This report is very useful for managing the unrealized P&L whereby the performance can be viewed with the intention of adjusting the overall actualized percentage on the individual TRADE/Cost rows. There is a feature report to list variances between the TRADE actualised records and the actual accounting details, i.e. where manual processes have been actioned on either TRADE or accounting records.
20. Status report of purchase tonnage that has been paid for but no sales proceeds (cash) have yet been received. Write-off and weight-loss tonnages will be excluded. This is a useful bank report for situations where a financial institution is funding the purchases. The Purchase value reported is the contract value (with no additional costs/commissions) and the Sales value is the net proceeds i.e. sale contract value less any costs and commissions. The Bank account & Reference listed are fields maintained in TRADE/Traffic/Warehoused.
21. TRADE position summary in format sectioned by Dept with sub-sections of Allocated and Unallocated tonnages. There is no unseen filtering, i.e. user will need to apply exclusion parameters to restrict report content. The rows of the report are per Dept/shipment period (as entered in TRADE). The columns of the report are position period which is selectable as either use the Valuation Period or the TRADE Position Period parameters.
22. Compare individual TRADE Costs between current database and any user selected TRADE database. This is a useful tool for Management Accounting reconciling where movements need to be analysed.
23. Commodity Position reports. Very specific presentation style, sequence and totaling. Uses the primary commodity code and Position Period to organise the data. It applies logic when the main commodity code = ‘WHT’ to determine High or Low quality. If the commodity part 2 is numeric and less than, or equal to "45", or it is the code "EEC1" or "EEC2", then it is counted as high quality, else it is low quality. The style SEPARATE II works in a similar manner to SEPARATE whereby it will group contracts using their commodity code alternative Code (cmy03_cmynum) instead of the hard coded High and Low quality grouping.
24. Traffic style. Sequence/group by shipment period i.e. start month of TRADE record with prior today being grouped as SPOT. No allocated purchase TRADE are listed.
25. FAS, a US Cotton trading specific report.
26. Survey Instructions. Driven by selected purchase trades, with their allocation shown immediately below. The detail on the Purchase row is oriented to loading data and the Sale data is more delivery oriented. Broker Ref is from the first broker row, the Voyage ref is from the WIP/CHARTER. If the allocation is to Stock, there is a restricted display on the Sale row.
27. Consignment Report. Specialist Cotton Grid presentation.
28. Warehouse Audit Report. Specialist Cotton Grid presentation.
29. Registration Price Risk style 2, report will locate Trade Price Fixing contracts where the Provisional Price is setup and will compare that price with the current price. A risk calculation in contract/settlement currency and target currency will be included. Additionally the CLI Market Risk value will be shown to compare the Risk and recognise a Breach.
30. Outstanding Liens Report, specialist report for company operating Liens (ctrl30_liens=Y) whereby for Purchase TRADES, the counter Party has borrowed monies from other sources and the Operating Company needs to monitor repaymnet of these loans.
31. Invoiced Goods & Costs Report. Includes invoiced contracts and invoiced costs and show the contract/invoice values Vs the costs/Cost Invoiced Values
32. Novations, simple listing of Sales that have been novated i.e. sold inter company [specialist S01 setting]
33. Inventory Overs and Unders Report which compares Purchase Contract Quantity with Delivered Quantity (Inventory Take-up) by 6 digit Contract [Chinese Domestic Cotton Only]
34. 20% Pricing Report. Lists Inventory Value (Conditioned Weight x adjusted Price) and 20% Holding Amount (Value less Invoiced amount) by Counterpart within Agent [Chinese Domestic Cotton Only]
35. CD110 Report. Simple listing of Purchase Split Quantity and Total Contract Weights. [Chinese Domestic Cotton Only]
36. Listing under weight Containers i.e. where inventory applied to Export Sales in Containers outside parameters i.e. 97% of 44,090 lbs (basis 20mt containers) [US Cotton]