Whether you're doing a complete physical inventory count of your entire location, or routine cycle counts, is a tradition at most businesses, but it can be easy. Thrive has tools to suit every business and ensure your counts are entered accurately!
Performing your physical inventory count?
Take the 30-second quiz to determine the tool for you to complete your physical inventory count:
Here are our three tools for performing an inventory count. Remember that you might use a combination of these tools, depending on what works best for you and your team.
Perform a Stocktake (or multiple ones):
Stocktakes (watch a quick video here 🎥) are easy to set up and help keep your products organized and counts accurate. For customers on Professional Plans and above, you can scan your counts using an external barcode scanner. You can also manually enter your counts.
Either way, all discrepancies will be noted on the Stocktake Discrepancy Report.
Conducting the count: Products can be added to the Stocktake manually or scanned in (for Professional users and above).
NOTE: Some grandfathered Standard plans allow scanning for Stocktakes.
Entering the count: Stocktakes allow you to scan or count manually. Conduct the counts and enter the quantity counted for approval.
Reporting: Use the Stocktake Discrepancy Report to pinpoint the changes (including cost information) and the Due For Stocktake Report to see what should have been counted. Any discrepancies will also show up on the Inventory Change Report.
Use a bulk upload spreadsheet:
The Spreadsheet Bulk Upload (watch a quick video here 🎥) is excellent for making bulk updates/edits/reconciliations on your products.
You'll want to use the Edit or Reconcile Inventory Quantities OR Edit Variants for an inventory count.
Once the changes are uploaded in Thrive (either through the bulk upload directly or Stocktake), the new counts will automatically sync to enabled sales channels.
NOTE: This feature is only available with Standard Plans and above. Click here for more information on our current plans.
Conducting the count: Generate the Edit or Reconcile Inventory Quantities OR Edit Variants. From there, you can either print off a hard copy to update or make updates directly to the spreadsheet.
Entering the count: If you printed a hard copy, we recommend entering any discrepancies onto Stocktakes (that way, you can use the Stock Discrepancy Report). Otherwise, you can change the spreadsheet and import those counts.
Reporting: If you enter the discrepancies via Stocktake, create a Stocktake Discrepancy Report for that date. Otherwise, the Inventory Change Report will have all your changes under the "Added" and "Removed" columns.
Use a reconciliation worksheet:
Reconciliation Worksheets are great for manual physical inventory counts. This option provides you with a printable worksheet to perform your counts on. When the count is complete, you can enter the discrepancies via a Stocktake or Spreadsheet Bulk Upload.
Conducting the count: Manually count and tally the products. If you have the same product in multiple areas, compile them and only enter the grand total for the entire location. It may be helpful to print out multiple copies!
Entering the count: Write the counts on the worksheet. Any counts that don't match can be entered via one of the following:
Stocktake (highly recommend).
Bulk Upload Spreadsheet (Edit Variants or Edit or Reconcile Inventory Quantities)
Reporting: If you entered the discrepancies via Stocktake, create a Stocktake Discrepancy Report for that date. Otherwise, if you used the Bulk Upload Spreadsheet, the Inventory Change Report will have all your changes under the "Added" and "Removed" columns.
Final Notes on Reporting
If entering your discrepancies via a Stocktake is an option, that is what we recommend. The reason is that when you submit your final quantities, we will automatically calculate the total cost associated with the discrepancies on the Stocktake Discrepancy Report. The report also makes it easier to hone in on the changes made to the inventory count.
NOTE: The quantity changes made on a Stocktake will also appear on the Inventory Change Report under the "Added" and "Removed" columns.
The other option (if the discrepancies are entered via Spreadsheet Bulk Upload) is the Inventory Change Report. In this report, you'll see the differences in the "Added" and "Removed" columns. Please be aware of the time range you are running the report within so as not to include sales deductions.
No matter which option you choose to submit your counts, the logic for adding or subtracting units will remain the same.
If you find additional products during your count, that will add to your total product count. When that happens, we assume the units come in at the previously established Default Cost.
If you are still looking for all the units and come up short on your count, that will subtract from your total product count. When that happens, we assume the units are being deducted from an existing lot. The chosen inventory setting on your Company Info page will determine the lot selected.