Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
P
paulc4
June 4, 2021
Solved

Inventory adjustment question

  • June 4, 2021
  • 2 replies
  • 2 views

Hello,

 

Hopefully someone can point me in the right direction.

We routinely count our inventory.


I understand that I should do an inventory adjustment but my questions are:

 

If we find we have more on hand then QBO shows, and that hasn’t been sold yet, which account should we post the inventory adjustment to?

 

Similarly, if we find we have less on hand which account should the adjustment be posted to?

 

Thanks,

Best answer by Rochelley

Hello @paulc4 ,

 

Perpetual inventory system adjustments are done as follows:

 

1.  If the physical inventory count shows a higher balance than the inventory system, you must DR Inventory (Asset) account, and CR COGS (this can be a COGS type account named something like Inventory Adjustments).

2.  If the physical inventory count shows a lower balance than the inventory system, you must DR COGS Inventory Adjustment account and CR Inventory (Asset).

 

Because of the way QBO does inventory adjustments, you simply need to go to Sales-->Products and Services-->Inventory item you want to adjust-->drop down Edit in the Action column-->Adjust quantity-->Choose your Inventory adjustment account-->Enter discrepancy in Change in Qty column.  Depending on whether your total QTY goes up or down, QBO will make the accounting entries correctly in each account; you don't have to determine the DR or the CR - it is done for you.

 

Good luck!

 

 

 

2 replies

N
Nick K
June 4, 2021

Hi paulc4,

 

Having the correct inventory is definitely a necessity but just as important is making sure you track any adjustments to the correct account. I can help point you in the right direction for this.

 

QuickBooks Online makes adjusting your inventory a breeze so you can focus on other parts of your business. In order to do an inventory adjustment you just need to follow these steps:

 

  1. Select + 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. Note: 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, select Save and close.

In order to make sure you're using the correct accounts it's recommend that you reach out to your accountant as they're trained for just this type of situation. If you currently don't have an accountant no need to worry, we got this. In your QuickBooks Online account you just need to go to: My Accountant>Find a pro to help to find an accountant in your area.

 

If you have any questions let us know and we'll be happy to help!

R
RochelleyAnswer
Level 2
June 4, 2021

Hello @paulc4 ,

 

Perpetual inventory system adjustments are done as follows:

 

1.  If the physical inventory count shows a higher balance than the inventory system, you must DR Inventory (Asset) account, and CR COGS (this can be a COGS type account named something like Inventory Adjustments).

2.  If the physical inventory count shows a lower balance than the inventory system, you must DR COGS Inventory Adjustment account and CR Inventory (Asset).

 

Because of the way QBO does inventory adjustments, you simply need to go to Sales-->Products and Services-->Inventory item you want to adjust-->drop down Edit in the Action column-->Adjust quantity-->Choose your Inventory adjustment account-->Enter discrepancy in Change in Qty column.  Depending on whether your total QTY goes up or down, QBO will make the accounting entries correctly in each account; you don't have to determine the DR or the CR - it is done for you.

 

Good luck!

 

 

 

P
paulc4Author
June 4, 2021

Got it! Thank you!

Last question, do I need to allocate a cost under the product cost box? Or will QuickBooks take the average cost of the product and apply it to the accounts?

R
Rochelley
Level 2
June 4, 2021

Hello @paulc4 ,

 

It appears that QBO uses the FIFO (First-In First-Out) method of tracking inventory.  So the adjustments will be made accordingly; the cost associated with the inventory that was purchased first is the cost expensed first.

 

Example:

If I buy 10 items at $5 each on 05/01/21 and then I buy 10 of the SAME items for $10 on 06/04/21, the first 10 items sold (or adjusted) will be costed at $5 each and the next 10 at $10 each.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement