I can help clarify why your inventory valuation is off by $14, Boxwood.
When you import items from QBDT to QBPOS, they will be inactivated. Then a quantity adjustment is created for both programs to transfer On-hand Quantity to Point of Sale. The Inventory Valuation Report on the desktop will be zeroed out because of the adjustment that happened during the import process.
Aside from the information mentioned above, there are other factors causing the reports not to match. Check all the details below:
- Incorrect Inventory setup. For example, items were tagged as inventory when they should have been a non-inventory.
- Incorrect Inventory management process. The On-hand Quantity of an item is manually edited instead of receiving it.
- There's an adjustment entered in QuickBooks Desktop and Point of Sale.
- You have transactions under Inventory Asset that do not have inventory items.
- Active inventory items in QuickBooks Desktop.
The Inventory Valuation Report in Point of Sale gives you more accurate data since this is where you manage and track your inventory. To fix the issue, perform the recommended steps in this article and go directly to the Compare the reports section: Inventory valuation amounts in Point of Sale and QuickBooks Desktop do not match.
I’m also adding articles that can help resolve common inventory issues:
Keep me posted if you need help with the product. I’ll make sure you’re taken care of. Have a great day ahead.