Skip to main content
H
hideawaymelon-gm
December 4, 2023
Question

Importing a list of items to adjust out the Inventory Quantity

  • December 4, 2023
  • 1 reply
  • 0 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?

1 reply

4
4Gal
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.

 

L
LeizylM
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!

H
hideawaymelon-gmAuthor
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?

Terms & ConditionsAccessibility statement