Skip to main content
September 8, 2023
Solved

Inventory Asset Value Adjustment

  • September 8, 2023
  • 1 reply
  • 0 views

I would like to clean up our inventory asset value of Qty 0.00 (Zero) but they have small asset value.

Could you please teach me the way how can I clean up them?

 

We have negative and positive both small asset values like below examples.

 

<Item A>

QTY      0.00

Asset Value  -0.01 (Negative)

 

<Item B>

QTY      0.00

Asset Value  +0.03 (Positive)

 

Thank you so much for your help in advance.

Best regards.

 

Best answer by Carneil_C

Hi, @Japan2023. I'm here to ensure you'll be able to adjust the inventory asset value to zero.

 

Incorrect costs and initial quantities entered during setup lead to incorrect inventory asset account values. Here's how you can fix it:

 

  1. Go to Settings ⚙ and select Products and Services.
  2. Highlight the item, then select Edit from the Action column.
  3. Select Starting Value.
  4. Select Got it.
  5. Enter the item's correct date and cost.
  6. Select Save and Close.

 

Then, you can record a Journal Entry to balance your books. But before that, I'd recommend consulting with your accountant to get guidance on handling your accounts accurately. If you don't have one, please visit this link: Find an accountant.

 

See this article to understand more about the concept used by businesses in tracking inventory: FIFO and how is it used for inventory cost accounting.

 

Also, you can utilize this guide to track your inventory items, such as your best sellers, what's on hand, and the cost of goods in the future: Use reports to see your sales and inventory status.

 

Please don't hesitate to reply on this thread if you've got more queries about handling items in QuickBooks Online. I'll be here to assist you further.

1 reply

Carneil_CAnswer
September 8, 2023

Hi, @Japan2023. I'm here to ensure you'll be able to adjust the inventory asset value to zero.

 

Incorrect costs and initial quantities entered during setup lead to incorrect inventory asset account values. Here's how you can fix it:

 

  1. Go to Settings ⚙ and select Products and Services.
  2. Highlight the item, then select Edit from the Action column.
  3. Select Starting Value.
  4. Select Got it.
  5. Enter the item's correct date and cost.
  6. Select Save and Close.

 

Then, you can record a Journal Entry to balance your books. But before that, I'd recommend consulting with your accountant to get guidance on handling your accounts accurately. If you don't have one, please visit this link: Find an accountant.

 

See this article to understand more about the concept used by businesses in tracking inventory: FIFO and how is it used for inventory cost accounting.

 

Also, you can utilize this guide to track your inventory items, such as your best sellers, what's on hand, and the cost of goods in the future: Use reports to see your sales and inventory status.

 

Please don't hesitate to reply on this thread if you've got more queries about handling items in QuickBooks Online. I'll be here to assist you further.

Japan2023Author
September 8, 2023

 

Hi, Carneil.

 

Thank you for your quick help.

It seems better to leave the small difference for my situation.

But it was good to learn the way.

 

Please have a nice day.

 

Kind regards,

September 8, 2023

You’re always welcome, @Japan2023.

Just let us know if you need more assistance with inventory adjustment in QuickBooks Online (QBO). Rest assured that every concern posted in this forum is addressed accordingly.

Please don’t hesitate to come back if you have any QuickBooks-related concerns. Have a good one!