Description
At the end of the month/year businesses with inventory want to verify that the amount they have in inventory aligns with what is in the accounting system.
Someone will physically count the items in a warehouse. Then they will upload these counts to the system inspect the variance from their count to the system, then book stock adjustments for the variance in count to ensure the system is up to date
Upload Counts
Users can upload a list of item counts for one warehouse at a time.
The upload fields are
Item.number - SoftLedger Item.number (required)
Quantity - Amount the user has counted in physical inventory (required, > 0)
Unit Cost - If there are more in physical inventory, this will be used as the variance stock adjustment unit price. (optional, > 0).
Manage Draft Stock Counts
Viewing draft counts
The following columns are visible
Item
Warehouse
System Job - Uploaded file name and reference
Quantity - Physical inventory counted (supplied in upload)
Current Quantity - Amount SoftLedger has in inventory
Variance - (Quantity) - (Current Quantity)
Unit Cost - Unit cost supplied in upload
Item Purchase Price - Item’s Purchase Price in SoftLedger
Editing Stock Counts
After uploading users can edit the quantity or unit cost of that count
Deleting Stock Counts
Stock counts can be deleted one at a time or in bulk
Approving Stock Counts
Stock counts can be approved one at a time or in bulk
Approving a stock count will create a new stock adjustment
Adjustments with a positive variance
If the variance is positive we will create a positive stock adjustment using this data
Type - Adjustment
Description - Count Adjustment
Warehouse
Item
Transaction Date - Input from form
Posted Date - Input from form
Adjustment Ledger Account - Input from form
Price - Unit Cost from upload if set, if not it will use the Item’s purchase price, if neither, it will error.
Quantity - Variance
Adjustments with a negative variance
If the variance is negative we will create a negative stock adjustment using this data
Type - Adjustment
Description - Count Adjustment
Warehouse
Item
Transaction Date - Input from form
Posted Date - Input from form
Adjustment Ledger Account - Input from form
Quantity - Variance