cancel
Showing results for 
Search instead for 
Did you mean: 
s4-mintess-com
Level 1

When I export my products to excel, several products have an absurdly smaller amount than shown in quickbooks online, what could be happening?

when I export my products to excel, several products have an absurdly smaller amount than shown in quickbooks online, what could be happening? example: the product XX appears with 100 qty on hand when I search, but when I export it appears with -30
3 Comments 3
MaryLandT
Moderator

When I export my products to excel, several products have an absurdly smaller amount than shown in quickbooks online, what could be happening?

I can provide the steps on how to correct the number of products after importing them to QuickBooks Online (QBO), s4-mintess-coms4-mintess-com.

 

Sometimes you might discover that you have either more or fewer of an item than QuickBooks shows. You can manually adjust an item's quantity when you track inventory. Doing this will match what you actually have in stock.

 

Let me show you how:

 

  1. Click + New.
  2. Select Inventory Qty Adjustment.
  3. Enter the Adjustment Date.
  4. In the Inventory adjustment account drop-down, select the appropriate account.
  5. Select the products in the Product field. The description and current quantity on hand auto-populate.
  6. For each item, enter either a new quantity or a change in quantity.
  7. In the Memo field, enter the details about the adjustment.
  8. When you're done, click Save and close.

When you save the inventory adjustment, QBO automatically records appropriate adjustments to your stock Asset and Cost of Goods Sold (under stock Shrinkage) accounts.

 

If you need to edit or delete the inventory quantity adjustment, check out this article: Edit an inventory quantity adjustment

 

Be very careful editing inventory adjustment entries. This can greatly impact your accounting. If you're not sure if you should do this, reach out to your accountant.

 

Additionally, you can browse this link to help import your item correctly: Import products and services into QuickBooks Online.

 

Stay in touch with me if there's anything else you need about importing your products in QuickBooks. I'll be around to help you.

s4-mintess-com
Level 1

When I export my products to excel, several products have an absurdly smaller amount than shown in quickbooks online, what could be happening?

AbegailS_
QuickBooks Team

When I export my products to excel, several products have an absurdly smaller amount than shown in quickbooks online, what could be happening?

Thank you for posting your concern here, s4-mintess-com. 

 

This is not the impression we want you to have with QuickBooks Online.

 

I suggest you reach QuickBooks Online Support to investigate the issue that you're experiencing. I'll be glad to provide you the steps.

 

Here's how:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Select either tab to get started:
    • Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
    • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
      • Start a chat with a support expert.
      • Get a callback from the next available expert.
      • Ask the community to get help from businesses like yours.

 

You can also find step-by-step tutorials here

 

I'll be right here to continue helping if you have questions exporting your file. Assistance is just a post away. Have a great day ahead.

 

 

Need to get in touch?

Contact us