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

Download Template


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).

Untitled


Untitled

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

Untitled

Editing Stock Counts

After uploading users can edit the quantity or unit cost of that count

Untitled

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

Untitled

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