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