Quickbooks Negative Quantity on Hand (QOH) Repair

 

Quickbooks Negative Inventory is caused when sales transactions are entered before entering the corresponding purchase transactions, i.e., you sell inventory that you do not have in stock. 


 

Why do files have Negative Inventory?

Basically, you are entering an invoice transaction before entering a transaction to add stock such as a bill, item recipt, etc.

  • The basic reason for Negative QOH is inventory control takes time and effort. Also, a lot of businesses are online/drop-ship and it is normal to sell items before receiving them.
  • Another reason is that Non-Inventory items are marked as Inventory items in Quickbooks. If this is the case, you will need to convert the inventory items back to Non-Inventory items. Contact us for details.

What are the effects of Negative Inventory?

Negative Inventory can cause on or more of the issues listed below. Continued use of data files with negative inventory will render them unusable at some point.

  • Inventory Items have Incorrect Cost
  • Profit and Loss & Cost of Goods Sold (COGS) amounts will be incorrect
  • Cash-basis Balance Sheet out of balance
  • Balance Sheet inventory amount is incorrect
  • Errors in A/P reports
  • Bills for inventory purchases showing up on income and expense reports
  • Inventory Assemblies show incorrect COGS on job costing reports
  • Recurring data damage

How to find if your file has Negative Inventory?

Inventory Valuation Detail (IVD) report

The Inventory Valuation Detail Repaort is the ONLY report that you can use to check if your data file has negative inventory. Negative inventory shows with negative numbers in the Quantity on Hand (QOH) column.

How to run the IVD?

  1. Go to the Reports menu.
  2. Select Inventory then click Inventory Valuation. 
     

How to Fix Negative Inventory?

Essentially, do not sell inventory items until you have purchased them and entered the purchases into QuickBooks.

If your file has multiple instances of negative inventory, we offer a service to repair the data file and remove all instances of negative QOH. Please contact us to learn more about the service.

Comments

Post a Comment

Popular posts from this blog

DacEasy to Quickbooks

  Sage, the manufacturer of DacEasy, has decided to continue to support existing Sage DacEasy customers in 2016 but has not planned a new release to DacEasy. Converting from Sage DacEasy to QuickBooks does not have to be a formidable task if you select the right channels for the switch. With professional help, you can easily shift from Sage DacEasy to QuickBooks. Having the right tools, experience and technical staff specialized in QuickBooks data conversions will make all the difference toward a successful project. Converting from DacEasy to Quickbooks Online, Premier, Pro, or Enterprise, has never been easier when you work with professionals who are designated to assist you with your business and are carefully tending to a plan to find the most suited QuickBooks product that would benefit your needs. Transferring files from your current List Data and Transaction records out of your existing accounting application, running a full set of data cleanup procedures on the da
Read more

Quickbooks Online File Preparation Service

  Quickbooks Online File Preparation Service Does your Quickbooks data file have too many years of data which in turn is causing the file size to be too big to export to Quickbooks Online? Did you clear your Audit Trail to bring down the file size? The Quickbooks Online File Preparation Service will prepare your data file to be under the file size limit of QBO so it can be converted without any problems. QBO Export File Size Limit According to Intuit "While QuickBooks Desktop Enterprise and QuickBooks Online (QBO) do not have list limits, a size limit exists when you convert from QB Desktop to QBO. To convert a desktop data file to QuickBooks Online, your Desktop company file must have less than 350,000 targets." The size limit to export your Quickbooks Desktop file to Quickbooks Online is 350K targets. To find the size and number of targets in your Quickbooks file, press the F2 key after opening the data file. If you are over the limits, the desktop file wi
Read more