cancel
Showing results for 
Search instead for 
Did you mean: 
belrica-ma
Level 2

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount

How can I deduct the sold inventory amount from the Inventory Asset account which is from the payables?

Example I encoded 5000 Php as Inventory Asset, AR.
Next, I uploaded the current inventory of
Item A- 200 pcs x 2 php = 400 php
Item B- 100 pcs x 4 php = 400 php
Item C- 640 pcs x 5 php = 3200 php
= 4000

because of this, my Inventory Asset account totaled to 9000. and my cost of sales of 1000 is not yet recorded. Thanks in advance for the help.
5 Comments 5
Rasa-LilaM
QuickBooks Team

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount


Welcome aboard to the Online Community, belrica-ma.


To rectify the issue, let’s open the bill created for the item and then run the Transaction Journal Report. This is to check the accounts used to track the product.

 

  1. Go to Expenses on the left panel and choose Expenses to access the list of entries.
    expenses.png
  2. From there, mark the box for the bill you’re working on and then click the View/Edit link under the Action column.
    expenses1.png
  3. On the Bill page, scroll down and hit the More menu to select Transaction Journal.
    expenses2.png
  4. These actions will display the transaction's details.
    expenses5.png
  5. If the account is incorrect, hit the Bill to access the Category/Item details and then enter the appropriate information.
  6. Tap the Save button to keep the changes.


You can also open the Product and Services page to review the category for the inventory. Here’s how:

 

  1. Tap the Gear icon at the top and choose Product and Services under Lists.
  2. On the All Lists page, choose the product and then click the Edit link under the Action Column.
  3. In the Product/Service information window, go to the Income account or Expense account section to see the specific category for the product.
    expenses4.png
  4. If the information entered is inaccurate, simply input the correct one and then hit Save and close.

The following articles provide an overview on how to update the product/service types as well as changing the account.

 

If you have any questions while working in QBO, post a comment below. I’ll get back and help you. Have a great rest of the day.

belrica-ma
Level 2

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount

Hi, what I did to make the Bill upload faster is to record it as a general inventory account. Is there another way to correct the Inventory Account via journal entry? Thanks. 

JasroV
QuickBooks Team

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount

Hi there, @belrica-ma.

 

If you've created the inventory item and entered the quantity, you'll want to create only one. QuickBooks Online (QBO) will automatically calculate the asset based on the cost of the item.

 

Since you've created a Bill, you'll want to delete you've recorded as a general inventory account. As this will double the amount recorded in the bill.
 
Before doing so, I'd recommend consulting with your accountant for more advice on how to better record this.

 

You'll also want to check this article in case you want to learn how to track your inventory in QBO.

 

Let me know in the comment section below if you have other concerns with your QBO. I'll be around to help.

belrica-ma
Level 2

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount

I'm afraid this is not possible for me to delete the Bill or the item. When I uploaded the Bill, it contains the whole amount of the inventory. Due to the inventory not being counted at once, we already had some transactions before I could upload the inventory that's already been deducted from the sales.  So now, the customer accounts and invoice amounts are balanced as well as the inventory count. Hope someone can help me just update the the Inventory Account for the balance sheet. Thanks in advance.

Candice C
QuickBooks Team

I added my inventory account payables in QB and added my current inventory. However, I noticed that this caused the Inventory Asset Account to almost double in amount

Welcome back to the Community, @belrica-ma

 

Let's get some clarification on your inventory issue. 

 

To better assist you with this matter, I recommend contacting our QuickBooks Online Support Team so that we can get a handle on the subject. Here's how:

 

1. Go to the Help icon.

2. Select Contact Us.

3. Enter your question and choose Let's Talk.

4. Scroll down and request a Callback.

 

Afterward, it will give you an estimated time of when they will contact you. 

 

Our Support Team will be able to explain and show you how to resolve your problem by using a screen share to walk you through some steps. 

 

I'm always here if you have any further questions. Have a great day!

Need to get in touch?

Contact us