UMRECON - TRADE/Stocks reconciliation
This is a very specialised procedure to view movements between 2 FREEZE data sources i.e. a format of daily movement but at trade and bulk inventory unit level
The report shows a legend with the content below and other anotations
Purchases and Sales
Value Movement
Diff. Qty Closing Quantity - Opening Quantity
Diff. P&L Closing P&L - Opening P&L
Diff. Con. Value Closing Contract Value - Opening Contract Value
Diff. Adj. Value Difference between Closing Full Value - Con. Value and Opening Full Value - Con. Value
Diff. Valuation Closing Market Value - Opening Market Value
Quantity Movement
New Ctr. New Contracts since Opening Period
Spot Ctr. New Spot Contracts since Opening Period
Adj. Plus Increase in existing Contract since Opening Period
Adj. Minus Decrease in existing Contract since Opening Period
Stock Intake Intake from Purchase to Stock since Opening Period
B2B Sales Back to Back Sales Invoice since Opening Period
Stock Sale Sales Invoice from Stock since Opening Period
Closure Closed Contract since Opening Period
Stock
Value Movement
Diff. Qty Closing Quantity - Opening Quantity
Diff. P&L Closing P&L - Opening P&L
Diff. Reval Opening Stock valued at Closing Market Price - Opening Stock valued at Opening Market Price
Diff. Stock Adj Difference between Market Value of Stock Movement and Actual Value of Stock Movement since Opening Period that are neither Intakes nor Deliveries
Diff. Intakes Difference between Market Value of Stock Movement and Actual Value of Stock Movement since Opening Period that are Intakes
Diff. Deliveries Difference between Market Value of Stock Movement and Actual Value of Stock Movement since Opening Period that are Deliveries
Quantity Movement
Adj. Plus Increase in Stock Quantity since Opening Period that are neither Intakes nor Overpumpings
Adj. Minus Decrease in Stock Quantity that are neither Overpumings nor Loadings
Stock Intake Intake from Purchase to Stock since Opening Peirod
Overpump Overpumings since Opening Period
Stock Loading Deliveries out since Opening Period
Sales Analysis
Sales Invoiced since Opening Period
Valuation Market Value of Sale
Difference Closing Valuation - Opening Valuation
Invoice Value Invoice Value of Sale as seen in TRADE
Cost of Sales Cost of Sales as seen in TRADE
Margin Difference between Invoice Value and Cost of Sales
Margin - Value Difference Margin and Valuation Movement