Setting Stock on Hand in VentryHub

Setting stock on hand is a crucial step when first setting up your VentryHub account. This ensures your inventory levels and stock valuations are accurate before processing any purchases or sales.

Important: Only use this method once during your initial setup. Updating stock on hand again using this method will create new product instances rather than updating existing quantities.

For ongoing changes to stock levels, use the Stock Adjustments or Stocktakes features.

Prerequisites

Before uploading stock on hand, make sure you have:

• Created your Products and Services

• Created Locations for storing inventory

Uploading Stock on Hand Quantities

Step 1: Export Stock on Hand Template

1. Go to Inventory > Products

2. Click Export > Stock on hand

3. This downloads a CSV file containing all products in your inventory

Step 2: Fill in the Template

Enter stock on hand information into the downloaded file. Required fields:

• Product Code: Pre-filled in the export

• Quantity: Enter the number of units in stock

• Average Cost: Average purchase cost per unit; used to calculate stock value

• Location: Storage location for the product

• Received Date: Date the stock was received into inventory

  • Tip: If migrating from another system, enter the day after your closing date in the previous system

Step 3: Import Stock on Hand

1. Save the completed CSV file

2. In VentryHub, go to Inventory > Products

3. Click Import > Stock on hand

4. Upload your saved CSV file

This process initializes your inventory data in VentryHub and should be completed carefully to ensure accuracy across your system from day one.