Full inventory counts are usually performed at the end of the year to provide an exact value of your inventory.
A full inventory count comprises all items in your store(s) (including back rooms and warehouses) and should be done when the business is closed to get the most accurate value of your stock.
It is recommended to perform a full inventory count at the end of the year and sometimes at mid year.
They can also be done around holidays where an accurate inventory can be very important.
Before you perform a full inventory count, you will want to make sure that you are prepared for the task which includes like those listed below.
- Make sure that your barcode scanners are fully charged and operating properly.
- Cleaning areas where you will be performing the count to make everything easily accessible.
- Making sure that all products have printed labels or manufacturer UPCs for scanning purposes.
This article is separated into 3 sections listed below.
Once the above has been done, we can proceed with starting a full inventory count.
Performing Full Inventory Count
- Log into your Lightspeed Retail X Series account via Google Chrome .
- In the left hand window pane, click "Inventory".
- In the sub window pane, click "Inventory counts".
- In the main window pane, click "Add inventory count".
- Set both the "Start Date" and "Start Time" for the count. Please note that it will automatically default to the current date and can't be before today) but you can schedule counts in the future.
- Now choose the outlet that you will be performing the count for. Once the outlet has been chosen, the "Count name" will automatically be generated. Please note that you can manually change the "Count name" if you want to.
- Under the section named "Choose products to count", click "Full count".
- Click "Start count".
- The inventory count has been created and you are ready to start counting.
- You can manually search for products and enter their counts or you can scan their barcodes using a barcode scanner.
- If you enable "Quick scan mode", each time you either scan a barcode for a product or manually search for a product it will automatically add 1 to the count for that product.
- In the below example, we manually searched for a product while "Quick scan mode" is enabled and each time it was entered a count of 1 was added for that product. For this product, we searched 4 times for the same product and it increased the count for the product to 4.
- If you do not not enable "Quick scan mode", each time you either manually search for a product or scan a barcode, it will allow you to manually enter the count for the product. In this example, we manually entered 4 for the product.
- When a product has been counted in the count, it will be displayed at the top in the upper right hand corner.
- If you made a mistake with a counted item, you can click the "Trash" icon to the right of the counted listing to delete it from the count.
- Every time you count an item, the information about the items in the count will be automatically updated as shown below for the sections named "All", "Counted", and "Uncounted".
- Every time your count is updated, it will be automatically saved and it will be displayed to the left of the "Pause" and "Review" buttons in the upper right hand corner.
- At any point in the count, you can click "Pause" in the upper right hand corner to put the count on hold and come back to it at a later time if needed.
Reviewing Full Inventory Count Data
- Once you have counted all of your items in the full inventory count, you can review the count by clicking "Review" in the upper right hand corner.
- There are five tabs of data for the count for you to go through and they are shown below.
- They are "Uncounted", "Unmatched", "Matched", "Excluded", and "All".
- Uncounted: Lists all items where the total counted is 0. This includes items with an expected count of 0.
- Unmatched: Lists all items that had a count greater than or less than what is expected. For example: This includes items where you expected that negative or positive amount and counted 0.
- Matched: Lists all items that you have counted where the counted amount equals the expected amount in Lightspeed Retail X Series.
- Excluded: Any items that you have manually excluded from your full inventory count.
- All: All items from each tab totaled into one.
- Go through the items in your count to look for and address any issues by either recounting an item or excluding an item from the count.
- Click the checkbox to the left of an item that you wish to make changes to.
- Click the drop down section named "Choose an action (X selected)".
- You will then have two options and they are "Recount items" and "Exclude items in count".
- If you click "Recount items", you will reset the count for the item back to zero so that you can count the item again by clicking "Continue".
- If you click "Exclude items in count", it will remove the item from the count.
- You can also discard an inventory count should you need to do so by clicking "Discard" in the upper right hand corner.
- Once you discard an inventory count, it will then be displayed on the tab named "Cancelled" on the "Inventory counts" page.
- If any changes to your stock are made during a full inventory count for whatever reason, you will need to make any final adjustments so that the data is accurate.
Completing Full Inventory Count
- After you have reviewed and confirmed your full inventory count and that you are sure that all counts are correct, click "Complete" in the upper right hand corner.
- Once you have confirmed that you have verified that the data in the full inventory count is correct, click "Complete".
- After you have completed the full inventory count, the data will be processed and it could take a little bit of time to go through the count and apply the changes.
- After the full inventory count has been applied, will be displayed as shown below.
- There will be three tabs named "Unmatched", "Matched", and "All".
- All of the items in the full inventory count will be shown with all of their associated data and you can see the total changes in both units and costs at the bottom of the results.
- Once the full inventory count has been completed, you can export the data to either a PDF report or a CSV report by clicking the appropriate button as shown below.
- If you choose a PDF report, it will be formatted so that it includes the expected and final count, change in cost, and total value of each item's inventory after the count for each product. It will also give you a summary with total changes for the full inventory count.
- If you choose a CSV report, it will prepare a CSV file with a line for each product count. It will also provide you with columns for SKU, supplier code, expected stock, and actual quantity, as well as stock count difference, difference cost, and inventory value of each product's inventory after the full inventory count was completed. This is usually used to import into another software system or platform or for generating your own reports.
- You can review your historical inventory counts by going into "Inventory" and then "Inventory counts" from the main menu bar and then click on the "Completed" tab and then select the name of the full inventory count that you want to go through.
Comments
0 comments
Article is closed for comments.