Inventory Deep Dive – Reconciliation Tool
What is Inventory Deep Dive?
Have you ever tried to reconcile your Inventory Balance Report to the General Ledger but had trouble finding the cause of the imbalance? Do you find there are lots of things to do to keep your inventory in line? Well, you are not alone. Inventory Reconciliations can be complex and sometimes time consuming. So, we have developed an easier and faster solution.
The Inventory Deep Dive Reconciliation application dives into the Visual database to find what has caused differences between the General Ledger and the Inventory Balance Report. Is there a problem in your general ledger? Or is it a problem with your costing layers? Not only will it create the reconciliation within seconds, it can find the records creating the imbalance quickly.
Have you ever wanted to take the postings to the General Ledger by Part ID and compare the postings to the Inventory Balance Report? Click one button in the Inventory Rollforward and you will see which parts are causing the inconsistences. From there you can dive into the actual transactions for those parts to see the exact transactions that are causing the differences. Just imagine. Not only will it find the differences but it will also provide you a button to fix them.
The tool provides options to find:
One button to show General Ledger and Layer problems.
Comparison of the Inventory Valuation to the Inventory Balance Report. You can even run it after month-end. Again, Deep Dive will find the part and the transaction differences.
Inventory Transactions that don’t contain the final costs.
Mismatches between the postings and the inventory transactions for all 5 journal types.
Instances where the Product Code has been changed, thus putting costs in the wrong inventory buckets.
Data problems and inconsistencies.
Advantages of Using Inventory Deep Dive
- Focused reports to show inventory differences by specific part ID.
- You will save time because you can focus on the problems parts. It will no longer be necessary to run the Visual audit tools on your entire database (i.e. Cost Distribution and Cost Analysis Tools).
- Detailed help guides for each window.
- Drill down capabilities to WO, CO, PO and transactional details.
Ability to send the information to Excel.
Investment in Inventory Deep Dive (one time)
- Inventory Deep Dive is compatible from Visual Version 6 to 10
- There is no annual maintenance fee
- The tool can be used on all sites within a database
- Compatible with all versions of Microsoft Windows
“Can I just say how much I love Deep Dive!!! I haven’t even been able to dive that deep yet with month end/year end duties, but it has already been a tremendous help. By far favorite so far is Rollback and Inventory Balance vs G/L. Oh, and the Product Code Changes! Saved me so much time. I can’t even express the words. So, thank you:) Very happy Customer!”
Diane McMillin, Controller, Abrasive Technology
“Firstly, DeepDive is simply wonderful. I’ve been working through inventory reconciliation on all 3 businesses and I would never have been able to get to the point where I am at. It’s amazing at identifying the needles in the haystack.”
Brendan Thompson, Phoenix Electrotek
“With the reconciliation tool, I was able to find my lost inventory from earlier this year and it’s helping me keep the inventory on track. As of my last posting, I’m off by $11.86, and I know why!”
Vicky Turgeon, Controller, Mitotec Precision