What is GPLREP

GPLREP is a series of reports supporting the Company TRADING environment i.e. does not  use the fiscal records, except for comparison purposes.

1. Position Report

The position report show Physicals, Inventory, Futures and Options by Category and Department rows with period/month columns.

For Physicals the month column is ascertained by the TRADE x Position Month (phys01_position). Past position months are reported together as late shipment/delivery.

When the Entity is operating the F&O subsystem, an option is enabled to report Physicals by their Valuation Period. When using the Price Matrix as the source of M2M, only trades where linked to Futures differential will be able to use the valuation month; where not available the TRADE x Position Month will be used..

Physicals are analysed by priced physicals, un-fixed premium, un-priced physicals, pricing to come and deferred price physicals.

Futures may be reported as Secondary Futures if an F&O code is nominated  (optional) for the department (cmy102_termcmy)

F&O trades that are marked with a code = 'TDR' are excluded automatically i.e. they are in Futures position in order to monitor the Broker Position (when delivery to/from the Market)

Physicals and inventory are excluded when they are sold and transfer of risk to the customer has occurred (i.e. Sales Title date is present  = phys01_salettd is completed)

F&O exclusion is on settlement completed.

The position may be based on the current database or a frozen database.

A comparison database may be selected whereby it shows the movement between the 2 dates.

Report style may be:

i) Standard; Showing actual commodity code and quantities as entered in TRADE

ii) IFRS Asset Position shows bonded commodities by their expected outturns and yields (Bonded commodities are those with a Processing Scenario set up in PHYSCODES/Commodity Codes)

iii) Trading Asset Position shows  bonded commodities as per the IFRS position and in addition shows contracts with a nominated Processing Scenario by their expected outturns and yields

Output may be a standard grid or excel or pivot table.

2. P&L

This shows Physicals, Inventory, Futures and Options, FX, Revalued transactions (Reval Tx), Pre Payment Interest and Storage.

The report is sectioned  by Category/Department with fixed columns of.

Previous year realised P&L

This column shows a change in P&L on contracts realised in the previous financial year; which would otherwise be excluded. It achieves this by looking at the realised P&L as at the end of the previous financial year e.g. Realised value on the Dec12 database with Sale Title date 01Jan12 to 01Dec12 and compares the Realised value on the current/selected database with a Sale Title date 01Jan12 to 01Dec12.  These dates are examples assuming Company fiscal setup is Jan-Dec.

Reverse Previous year P&L

M2M of open positions as at the end of the previous financial year

Open P&L

M2M of TRADE open positions (i.e. No Sales Title date  = phys01_salettd is NOT completed). The TRADE Title Transfer Date is the key element in locating the correct FXR rates for Currency Equivalence.

Realised P&L

The values of trades realised in the current financial year  (i.e. Sales Title date (phys01_salettd) is completed )

YTD Total

Sum of all other columns.

Report can be operated for the current database or a frozen database.

Output may be to a standard grid or to excel or a pivot table.

Adjustments may be created on the front screen by right-click…Maintain P&L Adjustments

3. Daily P&L Movement

The Daily P&L Movement Report is a similar methodology to the P&L report but shows movement between FREEZE positions by comparing the results of the P&L on various databases i.e. selected day, prior day, end of month and end of year thus giving P&L movements.  Alternatively a comparison database may be selected whereby it shows the movement between the 2 dates, together with their positions.

When selecting a Month End database there is an option to run a PLR Reconciliation i.e. trading result calculations versus their fiscal records.

The FREEZE process secures a snapshot of the trading data at that point in time, usually COB date, EOM, EOY. At the time of the FREEZE, all transactional data is expected to be complete for that cut-off date/time, i.e. F&O prices entered, FX rates entered, Physicals and Hedge trading has been completed for that date. Thereafter the P&L Movement reporting is using a fixed source of data. IF there is a need to make some adjustments to the FREEZE data e.g. missing/incorrect prices/rates, TRADEV, TERMV updates have been applied then the authorised user must apply RECALC on that FREEZE data. RECALC will secure the summary values needed for M2M calculations etc for the P&L Movement and standard P&L procedures.

4. Estimates Vs Actuals

Uses invoice marking to compare TRADE estimates with their final invoice values. It also shows the current payment status

5. Stock Summary Report

Shows current stock levels in PROMAN, together with outstanding Purchase and Sale Call-offs and incomplete Deliveries-out

6. Valuation Report

Shows M2M of open Physicals with options to include Futures and FX.

7. Inter Company Reconciliation

Highlights differences between inter-company contracts in the different companies.  This is to ensure that the same goods in each company are the same e.g. quantities, fixing status, BL dates

8. PrePayments Report

Reports on the status of prepayments

9. Cash Usage/Flow

Combines unpaid invoices and uninvoiced TRADE data to predict cash flow. Columns are expected date. Expected date is Value date for  Invoices and estimated maturity for Physicals. Bank balances are also shown

There are options to select the columns (e.g. weekly, monthly) and to include costs, FX and F&O and prepayments.

It may run on a frozen database in which case the date columns drive from the database date.

A comparison database may be selected, in which case it reports cash flow movement between the 2 dates.

Transfer of Risk

There are 2 ITAS features for ascertaining Title has transferred. S01 (ctrl02_titletransfer) determines whether by Invoice or BL date. When operating by Invoice, there is a manual override (TRADE/Miscellaneous)  to enable marking as Title transferred before Invoice; this feature is available for both Purchase (phys01_ttd)  and Sale (phys01_salettd).   When operation is by BL date, the processes for entry of BL date on both Purchase and Sale will also maintain the override/control fields.

The position and P&L reports use the Transfer of Risk Formula for differentiating positions and P&L. Physical Positions move between Open, Inventory in Transit, Inventory and Realised as follows:.

1. Create Purchase Contract – Open Position

2. Purchase Contract Title date entered – Inventory in Transit

3. Purchase Delivery date entered/Stock Intake in PROMAN  – Inventory

4. Create Sales Contract – Open Position

5. Sale Delivery date entered/Stock Release in PROMAN  – Sale Open, Purchase Inventory in Transit

6. Sale Title Date entered – Realised (Purchase & Sale)

Definition of trades analysed by position type (technical)

Inventory (Fact06)

Purchase Title Date	Purchase Delivery Date	Sale Delivery Date	Sale Title Date	Status
N/A	N/A	No	No	Inventory
N/A	N/A	Yes	No	Inventory in Transit
N/A	N/A	N/A	Yes	Realised

Physicals (Phys01)

Title Date	Delivery Date	Sale Delivery Date	Sale Title Date	Allocated	P/S	Status
No	No	No	No	N/A	N/A	Open
Yes	No	No	No	N/A	P	Inventory in Transit
N/A	Yes	No	No	N/A	P	Inventory
N/A	N/A	Yes	No	Yes	P	Inventory in Transit
N/A	N/A	Yes	No	N/A	S	Open
N/A	N/A	N/A	Yes	Yes	N/A	Realised

Purchase Title Date	{phys01_ttd}
Purchase Delivery Date	{phys01_deliverydate}
Sale Delivery Date	{phys01_saledd/fact06_saledd}
Sale Title Date	{phys01_salettd/fact06_salebld}
Allocated	{phys01_allocation}
P/S	{phys01_contype}