What causes Inventory Shrinkage anyway?
A foundation for understanding how QuickBooks and DataNinja work together.
This article will help you understand why transactions hit inventory shrinkage while QuickBooks Online and DataNinja are connected.
What is Inventory Shrinkage?
Inventory Shrinkage is the default offset account QuickBooks Online assigns to balance inventory changes that are not caused by a posting purchase or sales transaction.
The Inventory Shrinkage account is one of QuickBooks' pre-created accounts. QuickBooks automatically creates an inventory shrinkage account when the first inventory item is adjusted.
In other words: When QuickBooks gets news about a change in inventory quantity, and that change is not caused by an Invoice, Sales Receipt, Bill, Expense, or Check. Then the dollar affects of the change to the inventory asset account MUST be balanced by an equal and opposite change somewhere else. That somewhere else is by default the Inventory Shrinkage Account.
When will QuickBooks create inventory shrink?
QuickBooks will generate an inventory shrink entry (represented in dollars) any time it needs to align its QUANTITY of inventory items with the inventory counts you have in DataNinja. Please note that this can be UP or DOWN in dollars depending on if QuickBooks is artificially HIGH or LOW relative to your inventory system of record DataNinja.
When will QuickBooks Online balance?
DataNinja is your source of truth for inventory transactions. The chart below shows how a transaction in DataNinja affects inventory asset and offsetting accounts.
| DataNinja | QuickBooks Inventory Asset Change | QuickBooks Offset to Inventory Asset Change |
|---|---|---|
| Receive against Purchase Order | UP | Cash DOWN or Payables UP |
| Qty Adjustment Increase | UP | Shrinkage DOWN |
| Qty Adjustment Decrease, Scrap, or Zero Out | DOWN | Shrinkage UP |
| Consume | DOWN | Shrinkage UP |
| Produce | UP | Shrinkage DOWN |
| Ship against Sales Order (Estimate) | DOWN | Cash/Receivables, UP, Revenue UP, COGS UP |
Manufacturing Consumption and Yield Entries
When recording production in DataNinja; there will be a positive entry in Inventory Shrinkage for each raw material utilized. Once yield is recorded, and the production record is completed, DataNinja will generate a net zero purchase entry with a equal and negative offset to shrinkage. This zero-dollar expense transfers the value of materials consumed (from shrink) to the inventory asset value of the yield.
Manufacturing - Inventory value transfer from inputs to the output.
For a manufacturing run, the sum of each consumption transaction ( decreasing inventory asset and increasing shrinkage) is completely offset by the production transactions (Increasing inventory asset and decreasing shrinkage).
Updated 6 months ago