RONREP - Financial Report
What is RONREP
This is a financial summary using accounting and trading data.
The selections enable reporting target currency (with user selected exchange rates) and what ITAS companies/entities to include in the process.
There are 4 major presentation screens:-
a) Consolidated Summary view of 5 categories for all Departments i.e. Bank Allocated, Pre-Finance, Market Risk, Back-to-Back risk and Receivables
b) Department Summary to illustrate the same summary view as (a) but with rows per primary product code
c) Summary view of all Department/Counter Party for Pre Financing
d) Summary view of all Department/Counter Party for Receivables
e) Summary View of Pre-Financing known as ‘Committed Cash ‘ – right click from any RONREP form
The user starts the viewing with the consolidated summary (a) :-
1. If user clicks/drilldown on left side Dept name, the same view will be presented for each Commodity for that department (b).
2. If the user clicks from consolidated summary (a) on any of the 5 individual sections the view will report the detail transactions for Market Risk and Back-to-Back with specific presentation styles for Pre-Finance (c) and Receivables (d)
Market Risk.
Locates all unallocated TRADE which are Open status, not brokerage, not 3rd party/consignment, not Spot designated, not internal trades.
There are several columns reported i.e. MT, Average price PMT, net contract value, Open P&L and M2M PMT
column ‘MT’ is sum of trades with sales as +ve and purchases as -ve
column ‘Av Price’ is sum of all contract values / column ‘MT’
column ‘Value’ is sum of Purchase + Sale contract values , sale value as +ve, purchase as –ve
column ‘Open P&L’ is the M2M of all trades included
column ‘M2M’ is column ‘Open P&L’ / column ‘MT’
column ‘Limit’ will report INSCODES/Limit according of whether Dept or Product. If column ‘Value’ is +ve then will report Positive Limit else Neg limit
column ‘% (+/-)’ correlates column ‘Value’ and ‘Open P&L’
column ‘% limit’ will report INSCODES/Limit % according of whether Dept or Product. If column ‘% (+/-)’ is +ve then will report Positive Limit else Neg limit
The detail drill down will show Commodity, Counterparty, Contract No, Quantity(MT), Contract Value and Market Value
Back-to-Back Risk.
Locates TRADE sales that are allocated but are NOT Sales Invoiced which are Open status, not brokerage, not 3rd party/consignment, not Spot designated, not internal trades
The replacement value is a computation of the market price and purchase price.
The drill down on the DEPT summary will show Commodity, Counterparty, Contract No, Quantity (MT) and Market value
Receivables.
The process locates all unmatched accounting Receivables posted to any Client accounts i.e. not matched at cutoff date/period
Transactions that have a payment code indicating LC type will be accumulated into their column ‘LC Secured’.
Transactions that have a payment code indicating CAD type will be accumulated into their column ‘CAD Secured’.
If a CLI has a current Insurance limit maintained i.e. CLI/Limits page/Ins Co setup and amount /limit is setup with appropriate Start and expiry dates. This limit will be applied with any remaining receivables and the usage of that limit will be reported in their column ‘Insured’.
Any remaining receivables will be accumulated into their column ‘Unsecured’
The product code will only be located IF the accounting transaction references a Contract No (txx_contractno) that can be found on the company TRADE data, else the product code will be blank.
There is no subsequent drill down on DEPT summary, because the d) summary provides that analysis
Pre Financing.
This process will use the TRADE pre finance data source (phys18).
There are 4 sections Committed, BL secured, Warehouse secured and Unsecured.
The ‘committed’ balance is where TRADE Purchases have a Finance Bank assigned but no Pre payment has been made.
The ‘paid out’ secured are separated according to TRADE content into Warehoused or BL i.e. if marked as Warehoused then column ‘FCR secured’. If marked a BL date then include in ‘BL secured’. The value to be shown is the unapplied amounts on the TRADE/Pre Finance records.
The Paid out unsecured value is the sum of unapplied TRADE/pre finance values that are not classified as Secure.
There is no subsequent drill down on DEPT summary, because the c) summary provides that analysis