Reconcile inventory

← Inventory
During a full-store inventory (or cycle count) the first thing you need to do is scan your products, and then move that data from the scanner onto your computer.  

Once you've imported those files into Ascend, it's time to analyze the results and fix any discrepancies.

Once everything is done, you can reconcile.

Before you reconcile


Look back over everything and make sure you're comfortable with the results (namely, the New qty column). Once you hit that reconcile button, it can not be undone!

Then click Analyze. This updates and saves any changes you've made. Your Discrepancies should clear up at this point.

Let's reconcile your inventory!


1. Once you're done and feeling good about what's on your screen, you can select Reconcile. 
2. Select Yes on the pop-up to confirm you want to reconcile the inventory. 
3. You'll be prompted to print the Inventory by Category summary report, which you can use for comparison between your "pre-inventory" and "post-inventory" values. 
4. Create a database backup by selecting File > Backup on the Ascend desktop.
5. Download the post-inventory shrink adjustments query (here or from our website).
6. Open the document and copy all available text.
7. Select Reports > SQL Query in Ascend.
8. Paste the text in the upper portion of the screen.
9. Select Execute.
10. You'll get a date prompt. These dates should correspond with the date of your last full-store inventory and the current full-store inventory.
11. Then click OK.

The results will display. You can export the results to Excel by selecting the Export icon, if needed. 

If you want to know your total shrink value for this full-store inventory, export the report to Excel and then add up the Monetary Change column to get the total value.

Additional Resources


Video: (physical inventory video #7): Finalize and reconcile

Inventory

  1. Use the Category Mapper
  2. Prepare for a full-store physical inventory
  3. User permissions for a cycle count or full-store inventory
  4. Walking through the full-store inventory scanning process
  5. Import scan files from my inventory scanner
  6. Analyze inventory scan results
  7. Resolve discrepancies in inventory counts
  8. Reconcile inventory
  9. How does a label audit work?
  10. In-Store Products vs. Vendor Products
  11. Add a product
  12. Set “off” season product Mins and Maxs
  13. Selling products that come in bulk
  14. Import a large number of vendor products into Ascend
  15. I messed up an order. How do I undo it?
  16. Serialization
  17. Receive Vendor Orders
  18. Create a Vendor Order
  19. Trek integration in Vendor Orders
  20. Create a new Product Category
  21. Prepare for cycle counts
  22. Transfer products between multi-store locations

Feedback and Knowledge Base

(thinking…)