Notice something different in your Management Console? We're rolling out our latest/greatest software version, so click here to see what's new!

Inventory Import/Export Spreadsheet

Follow

Explanation of the column headers in each section for the Product Inventory Sheet:

 

Receive Columns

 

Receive Qty

Receive Unit

Cost per Unit

Receive Remarks

 

Receive Qty - Enter the amount of the Quantity received.

Receive Unit - A dropdown box with the options defined by the Unit of Measurement and the Reorder Unit.

Cost per Unit - Enter the cost per unit received. This amount will adjust the cost per unit if it is different than the existing cost.

Receive Remarks - Any notes that need to be entered for reporting purposes. Not Required.

 

 

Waste Columns

 

Waste Qty

Waste Unit

Waste Cost Update

Waste Remarks

 

Waste Qty – Enter the amount of the items to be removed as waste.

Waste Unit – Dropdown box with the options defined by the Unit of Measurement and the Reorder Unit.

Waste Cost Update – Yes/No drop down box. Selecting Yes will change the cost per unit increasing the cost of the remaining units.

Waste Remarks – Required field. Input the reason for the items being marked as waste.

 

Actual Columns

 

Actual Qty

Actual Unit

Actual Cost Update

Actual Remarks

 

Actual Qty – Enter the amount of inventory actually on hand.

Actual Unit - Dropdown box with the options defined by the Unit of Measurement and the Reorder Unit.

Actual Cost Update - Yes/No drop down box. Selecting Yes will change the cost per unit increasing or decreasing cost depending on if the quantity was higher or lower than the current amount.

Actual Remarks - Any notes that need to be entered for reporting purposes. Not Required.

 

 

Reset Cost

Reset Cost

Reset Cost Qty

Reset Cost Unit

Reset Cost Remarks

 

Reset Cost – Enter the new cost.

Reset Cost Qty – If left blank it will change the cost to the amount entered in reset cost. If an amount is entered it will calculate cost based on the amount of items have their cost changed.

Reset Cost Unit - Dropdown box with the options defined by the Unit of Measurement and the Reorder Unit.

Reset Cost Remarks - Any notes that need to be entered for reporting purposes. Not Required.

 

 

Reset 

 

Reset

Reset Remarks

 

Reset - Yes/No drop down box. Using this will reset inventory information for the product to zero and clear historical inventory information. It will not impact sales reporting.

Reset Remarks - Required field. Input the reason for the product being reset.

 

 

Update Low Stock Threshold

 

Update Threshold

New Threshold

 

Update Threshold - Yes/No drop down box.

New Threshold – Enter the value that will trigger reorder notification for the product.


Was this article helpful?
2 out of 4 found this helpful
Have more questions? Submit a request
Still have questions? Contact our friendly Support team