AvT Report | Actual vs Theoretical Report

Generate a PDF report comparing actual quantities on hand, based on what is manually entered, and theoretical inventory, based on sales and purchases.

The Actual vs Theoretical (AvT) report is generated in PDF format after each manual inventory process is completed. The AvT report shows a comparison of the actual quantities on hand, and theoretical inventory.

Actual inventory is based on the date when physical inventory counts were completed, which generates the AvT report. Theoretical inventory is based on sales and purchases that happen in-between physical inventory counts. This report can only be found in the Inventory Records section under the Completed option. Use the arrows at the bottom to scroll through the full report in the app. This report can also be emailed, downloaded, or printed from the AVT page.

Note:

• If a product is removed from a shelf in the Manual Inventory section, it will not change the data in previous reports.
• When receiving a purchase by using either the desktop version of SmartBar or the Invoice Capture feature on the mobile app, this will update the inventory in the first instance in the shelf inventory.
• After an order is received, the inventory in your shelves will need to be updated to match the actual bars and shelves where those products are physically placed, or moved to. This can be done without starting a new inventory by finding the Bar and Shelf where this inventory was physically placed, add the quantities, and save.
• Any manual adjustments made to products is shown under the Manual Adjustment column in the Brand Activity Report in SmartOrders (desktop).

How to save a copy of the AvT Report:

Once you complete capturing your inventory in the mobile app, an AvT report is automatically generated and can be found under the Inventories tab, then under the Completed section

• This report can be viewed in app - pagination can be found at the bottom
• Click the arrow in the upper right-hand corner to download the report to your device
• Click the envelope icon to email a report to yourself and others, if needed
• Click the printer icon to send this report to printers that are connected to your mobile device

Fields in the AvT Report:

• Sales:
  • Sold data between the previous and current inventory processes
• Purchases:
  • Purchases made in SmartOrders between the previous and current inventory processes
• Beginning inventory:
  • Beginning values for report are captured from the latest inventory values for that location
• Ending:
  • Inventory from completed inventory process for which report is generated
• Theoretical:
  • Beginning inventory + purchases - sales = Theoretical Inventory
• Difference:  
  • Ending inventory - theoretical = difference
• Cost Variance: 
  • Unit variance * unit cost = variance
    ie. If a unit is a 12oz btl and the unit cost is $1/btl and I am short 5 bottles then:
    Variance of 5 bottles x $1 = -$5
    $5 lost

Sample Report