cancel
Showing results for 
Search instead for 
Did you mean: 
SR6109
Level 2

Credit against a vendor account

I am using QuickBooks Desktop Premier Contractor.  I create a purchase order for 3 items.  We receive the 3 items, and we pay the vendor's invoice.  We discover item #2 is the incorrect part.  We return the part, and the vendor sends us a credit on our account.  I understand how to apply the credit to our account.  However, it leaves the returned part in our inventory.  How do I remove the item from our inventory?

3 Comments 3
AnneMariee
QuickBooks Team

Credit against a vendor account

It seems you're managing your inventory and vendor credits correctly, SR6109. Let's resolve that incorrect part with an inventory adjustment in QuickBooks Desktop (QBDT).

 

QBDT automatically updates inventory quantities and values as you track each purchase and sale. However, adjustments may be necessary to ensure your inventory status in QuickBooks remains accurate and up-to-date.

 

First, decide which kind of adjustment you need.

 

  • Quantity on hand - This is how you track any decrease or increase in product quantity, not because of a sale or purchase. This is what we're adjusting today.
  • Total value - Things like seasonal demand or spoilage can affect this value.

 

Then, set up your inventory adjustment account in your chart of accounts. Follow the steps below to do this.

 

  1. On the top menu, go to Company and then Chart of Accounts. You can also use the keyboard shortcut Ctrl + A.
  2. Navigate to the Account dropdown, then click New.
  3. From the Other Account Types dropdown, select Cost of Goods Sold.
  4. Name this account "Inventory Adjustments."
  5. Hit Save and Close.

 

New Inventory Adjustment Account.png

 

Once you've set that up, you can adjust a product's quantity or value. Here's how:

 

  1. On the top menu, go to Vendors and then Inventory Activities.
  2. Select Adjust Quantity/Value on Hand.
  3. Fill out the form by picking the appropriate adjustment type and account. Also, enter the adjustment date and reference number in their respective fields.
  4. Click Find & Select Items to choose the items you want to adjust. You can also use the Find field to search for products.
  5. Press Add Selected Items. 3ff4bcff-a609-43aa-b337-26655e3ab217.png
  6. Add a new quantity for each item.
  7. Hit Save and Close.Adjust Quantity 2.png

     

To dive deeper into adjusting your inventory, browse this article: Adjust your inventory quantity or value.

 

Moving forward, view your inventory status reports to ensure everything looks good. Here's how:

 

  1. Go to Reports and then Inventory.
  2. Check these reports:
    • Inventory Valuation Summary - to check your product's value
    • Inventory Stock Status by Item - to check your product's quantity
  3. Review the reports and ensure everything is correct.

 

Inventory Reports.png

 

If you have any other inventory concerns in QBDT, please don't hesitate to leave a comment below. Adjusting your inventory is crucial for maintaining accurate financial records, and I'm here to help you achieve that.

SR6109
Level 2

Credit against a vendor account

This solution does work; however, I have to be in single user mode to make adjustments.  Is there any way around this?

GenmarieM
QuickBooks Team

Credit against a vendor account

In QuickBooks Desktop (QBDT), making inventory adjustments using multi-user mode is unavailable, @SR6109. I'd be glad to share with you the details.

 

To maintain data integrity, inventory adjustments must be made in single-user mode due to product limitations. This prevents conflicts from multiple users modifying inventory records simultaneously. Once adjustments are complete, you can switch back to multi-user mode, allowing your team to resume normal operations and collaborate efficiently.

 

For detailed information about what features are available in single and multi-user mode in QBDT, browse this article: Features available and tasks you can perform in single or multi-user mode in QuickBooks Desktop.

 

Should you require further assistance about making inventory adjustments in QBDT, please don't hesitate to reply. The Community is always here to lend a hand.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us