Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 4, 2023
Question

Importing a list of items to adjust out the Inventory Quantity

  • December 4, 2023
  • 2 replies
  • 15 views

A bit of context: I go to tradeshows every few weeks and need to adjust out the quantity of sold hundreds of sold products after every tradeshow. I want the quantity and the COGS to be affected by the adjustment, but I only see a way to manually add items on the "Inventory Quantity Adjustment" page. Is there another way, such as creating an order or something, where I can just import an excel sheet of SKUs and qtys?

2 replies

Level 5
December 4, 2023

How do you record your sales? You can prepare Sales Receipt data and import it in bulk to also adjust your inventory quantities.

 

QuickBooks Team
December 4, 2023

Hello there, hideaway. Let me make it up to you by ensuring you'll be able to adjust out of the Inventory Quantity in QuickBooks Online (QBO).


We can create a sales receipt and entering all the items sold at the tradeshow. This is to ensure that the quantity and COGS are adjusted correctly. 

 

Here's how:

 

  1. Go to + New, then choose Sales receipt.
  2. Select a Customer from the dropdown. 
    Note: If you haven’t set up your customer yet, select + Add new.
  3. Choose the product/service you sold from the Select a product/service dropdown.
  4. (Optional) You can edit your line item’s quantity or rate in the Qty and Rate field.
  5. Fill out the other necessary fields in the sales receipt, then select Save.

 

You can check this article to learn more on how to create a single and import multiple sales receipt in QBO: Create sales receipt. 

 

I suggest consulting an accountant. They'll be able to provide you with suggestions on how to properly handle the transactions, especially with the COGS. 


I'm adding this article for information and understand inventory assets and COGS tracking: Understand inventory assets and cost of goods sold tracking.

 

Let me know if you have additional questions about running reports and tracking COGS. I'm always here to help. Have a great day!

December 6, 2023

Thank you so much for the guide! Regarding the total amount on the Sales Receipt, I would not want this to post on an income account because we receive a separate deposit from Square for the actual income. Should we be okay adjusting out the total to $0 on the Sales Receipt?

Rainflurry
Level 11
November 20, 2025
This post has been deleted.

@Clara Cleverence 

 

Please refrain from promoting products you sell, as it violates the Community Guidelines.  Here is what the Community Guidelines say:   

 

Don't do this:

  • Promote your business: We hope you’ll include a link to your business website and social media pages on your profile page. However, your QB Community profile is the only place for you to promote your business. Please don’t market your products or services - no matter how great they are - in any public posts.