![]() The Compare Balance Sheet and Inventory Valuation tool within CDR determines whether the inventory account on the Balance Sheet and the Inventory Valuation Summary match. To correct this problem, re-activate the inventory item, create an inventory adjustment (as discussed below) to zero out that item’s quantity, and then inactivate the item again. Unfortunately, there is no warning to stop or at least slow down someone entering transactions directly to the inventory account when they should be using inventory items and quantities.Īdditionally, inactive inventory items with Quantity On Hand (and a corresponding asset value) will also cause a discrepancy between the Inventory Valuation Summary report and the totals for the inventory asset account on the Balance Sheet or Trial Balance. If journal entries or deposits (or other transactions using the Expenses tab rather than the Items tab) have been posted directly to the inventory account, the Inventory Valuation Summary will not agree with the Inventory Asset balance on your Balance Sheet. The total asset value on this report should match with the Balance Sheet value for Inventory just ensure these two reports were created with the same time/date settings if other users are entering data in QuickBooks at the same time. An Inventory Valuation Summary Report summarizes the quantity, average cost, and extended value of each of the inventory quantities and provides a total inventory valuation. The method used in QuickBooks for inventory valuation is weighted average costing (the exception is QuickBooks Enterprise, which, if Advanced Inventory is used, can be set for FIFO costing). Average cost and/or quantity on hand appear incorrectĬDR tool – Compare balance sheet and inventory valuation.Inventory Valuation Summary does not agree to General Ledger.Inventory Valuation Summary report shows negative quantities.Review the Inventory Valuation Summary for negative quantities and inaccurate average costs.įor the purposes of this article, all future mentions of QuickBooks will refer to QuickBooks Desktop.Ĭommon error: Incorrect and/or inconsistent inventory procedures. ![]() The Client Data Review (CDR) tool, available to your clients’ External Accountant users, as well as those of you using QuickBooks Accountant Desktop and QuickBooks Enterprise (all editions), can assist with this problem. Disagreement between these two reports can be caused by several factors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |