Page Comparison

• N.B. This Report uses the End Date you have set in Report Dates.
  • It does not take notice of the Start Date you have set.
    
    
• It will not include any Stock owned by a Reserve Customer. 
  

This Report will show your Stock Valuation grouped by Product/Rotation.

Image Added

• Click the Export to CSV button Image Addedto generate a .csv file of the data shown in your report.
  
  
• Click the Export to Excel buttonImage Added to generate an .xlsx file of the data shown in your report.
  
  
• Click the Export to Adobe button Image Addedto generate a .pdf file of the data shown in your report.
  
  
• Click the Refresh button to regenerate the report on the screen with the latest data in your system.
  
  

• Physical Stock is the amount of Stock you physically hold up to the Report End Date currently set.
  
  
• Actual Stock Value is the sum of your Undbond Value + Duty Paid Value less the En Primeur Value.
  
  
• RH&D is the total of any Receipt, Handling and Despatch Charges.
  

• Is the Stock Value In-Bond or Duty Paid?

• • The Report will show both. Because

• • the Stock Value changes depending on it'

• • s Duty state the system

• • shows Duty separately.
  • This means that if you have

• • 50 Cases Underbond and

• • 10 Duty Paid

• • the Report will show

• • a Value of £x and Duty of £y.
  • The

• • true Product Valuation is £x+£y.

• • 
    
    
• If you Only Hold Stock Under Bond but Duty is showing.
  • Depending on

• • your Warehouse it may be that

• • an Order has been

• • Returned/Rejected.
    • In this

• • • case Duty will be shown as

• • • the Goods can only be brought back

• • • in Duty Paid.
  • It is

• • now correct that

• • the Product Value is the 'Stock'

• •  Cost + Duty Paid.
  • If you Only Hold Stock Duty Paid.
    • If this is the case then you will need

• • • the Cost column from the Report and

• • • the Duty Column to get

• • • the Stock Valuation.

• • • The Duty Per Single on

• • • this Report is calculated by taking

• • • the Singles Per Unit, Litres Per Unit,

• • •  Country and the Duty Code from

• • • the Product and calculated

• • • the Duty from the Excise Duty Rate Values set up against

• • • that Duty Rate that was valid at the time of the transaction.

• • • If the Country against the Product is

• • • a NON-EC Country it then takes the

• • • same Values as above, but instead of running them just against

• • • the Excise Duty Rate it will run them against the Customs Duty Rate as well and combine the results into what is displayed on

• • • the Report.

• • • The Duty Paid Price Per Case/Bottle is taken from the

• • • standard Selling Price on the Product, and

• • • the Underbond Price Per Case/Bottle is

• • • this Duty Paid Value minus either

• • • the Excise Duty (i.e

• • • the Duty Rate x Litres of Liquid or Alcohol as specific on

• • • the Product and Duty Code) or

• • • the Excise and Customs Duty if the Product has a NON-EC

• • • Country of origin.
      • These columns are related to the Product Prices whereas

• • • • the Duty Paid and Underbond Value columns are taken from

• • • • the Value of the Stock on the Stock Record, which will have been set when

• • • • the Stock was Landed or Stock Adjusted. They may not be the same. 

• You can filter down the results

• on the report by entering value on any of the columns and choosing a filter type.
  • Remove the filter values to see all the original results again.