Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowI have done a physical inventory check and have realized that all my inventory entered on quickbooks does not match my physical inventory significantly. I need to fix this issue immediately so I don't continue to sell products that aren't in stock on the website.
The inventory shows:
How do I change these inventory quantities to the correct quantities that I have in-stock without QB documenting the changes as bad debt or inventory shrinkages? The numbers are simply wrong and I would like to change them without it showing that I have lost money. I haven't lost any money, my inventory was just entered incorrectly.
Hello there, UserLE.
Sometimes you might see that you have either more or fewer of an item than QuickBooks shows. If you track inventory in QuickBooks Online Plus and Advanced, we can manually adjust an item's quantity without recording a purchase or sale, to match what you actually have in stock.
However, when you save the inventory adjustment, we automatically record appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts for our reports to be accurate. You can check this article for more details: Adjust inventory quantity on hand in QuickBooks Online.
On the other hand, we have the option to delete and recreate the items entering the correct quantity on hand. Set up and track your inventory in QuickBooks Online.
I'm here if you have other questions. Take care!
in the chart of accounts, open the register for inventory asset
each line that has a START notation is the starting stockage entry for that item, edit them as needed
There are a number of reasons for inventory shrinkage. Inventory shrinkage can take place when items, such as expired produce, are naturally no longer sellable. Or, shrinkage might be due to damaged items.
Inventory shrinkage may also be the result of errors. You or one of your employees might miscount items. Your vendor might also make errors when they supply you with inventory items.
In some cases, you might have inventory shrinkage because of malicious actions, such as theft, shoplifting, or fraud. Vendors may commit fraud and give you less inventory than what you purchased. Or, employees might steal inventory. Shrinkage is also common when customers shoplift from your business.
A shrinkage expense account will be recorded under the Cost of Goods Sold (COGS) It includes material cost, direct labor cost, and direct factory overheads, and is directly proportional to revenue. As revenue increases, more resources are required to produce goods or services. COGS is often an account.
I'm experiencing something similar. I entered the same inventory item twice (for $1600 in print purchases that I'll sell individually) in Feb of 2017 but just NOW (2/25) caught that mistake.
How do I manually correct this "extra" inventory? If I use the COGS account, where I carefully track my prints sold, doesn't that shift my taxes due this year? I'm not sure how to record that -$1600 in inventory. Thanks for your help!
To correct the extra inventory valued at $1600, you can make a manual adjustment using Journal Entry. Let's work together to correct this and ensure everything is aligned accurately in your records.
First, let's locate the duplicate transaction and open its transaction journal, to know what accounts are affected. This way, we'll know what to enter in your journal entry:
Once done, create a journal entry for this. However, before making any adjustments, I strongly recommend discussing this matter with your accountant or a tax advisor. They can provide specific guidance tailored to your financial situation and ensure that the journal entry is correctly structured to avoid any unintended implications on your tax obligations.
Additionally, if you're looking for ongoing, real-time assistance, you might find our QuickBooks Live Expert Assisted service helpful. It connects you with certified bookkeeping professionals who can provide direct support and ensure that your accounting tasks are managed proficiently. This service could be particularly useful for ensuring that similar issues are addressed promptly in the future.
I can see how challenging managing this transaction is. If you need further assistance with using specific features in your accounting software or have more questions about this process, please don’t hesitate to reach out. I’m here to help ensure your records are accurate and your financial insights remain clear.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here