Skip to main content
B
bglynn58
December 19, 2018
Solved

Inventory transactions show in ledger without a value

  • December 19, 2018
  • 1 reply
  • 0 views

I set-up inventory tracking and created "inventory" items in Products and Services.  I put a cost on the inventory but read an earlier thread that the cost comes from the acquisition of inventory.  I have since processed vendor bills with these same items and cost.  When I run an inventory valuation report it shows the values of these items.  When I look at the ledger in Cost of Goods Sold or inventory transactions it shows as zero value.  I have processed transactions after the date of the vendor billing and still no value.  I also tried to change the value of the COGS entry by editing the transaction register but it will not allow me to do that.  Am I missing something in the set-up?   Is there another way to fix the transactions already processed with zero COGS?

Thank you. 

    Best answer by Malcolm Ziman
    @bglynn58 wrote:

    Yes these transactions were generated from the sales transaction (the same is true if I make an inventory quantity adjustment).  We operate on an accrual basis.  The sales booked ok against AR and have subsequently been paid.

     

    I have attached a copy of the GL Inventory account.  The bill from the vendor was processed previously and is reflected in the balance at the top.  As you can see from the transactions (I entered an inventory adjustment today to show this) they still do not pick up a value.  If I run the inventory valuation report the values reflect properly in that report.  The purchase date is before the sale date for most transactions, however the purchase (vendor invoice) is in AP but has not been paid (terms are 60 plus days). I have attached the GL for AP showing this.

    It does not matter if bills or invoices are paid or not for inventory valuation

     

    Some questions that come to mind:

    - In the Bill on 9/24 did you use the same item as you used in the invoices?

    - When you set up the inventory item did you enter a quantity, but zero cost?

    - Did you leave the default linked accounts (for COGS and Inventory) in the inventory item set-up screen?

    A screen shot of the Inventory Detail report for this item would be useful

    1 reply

    M
    Malcolm Ziman
    December 19, 2018
    @bglynn58 wrote:

    When I look at the ledger in Cost of Goods Sold or inventory transactions it shows as zero value.   I have processed transactions after the date of the vendor billing and still no value. 

    Are these sales transactions? There is no COGS until there are sales. 

    There should be a value in the inventory register. Make sure the linked account is right.

    Also make sure the purchase date is before the sale date

    B
    bglynn58Author
    December 19, 2018

    Yes these transactions were generated from the sales transaction (the same is true if I make an inventory quantity adjustment).  We operate on an accrual basis.  The sales booked ok against AR and have subsequently been paid.

     

    I have attached a copy of the GL Inventory account.  The bill from the vendor was processed previously and is reflected in the balance at the top.  As you can see from the transactions (I entered an inventory adjustment today to show this) they still do not pick up a value.  If I run the inventory valuation report the values reflect properly in that report.  The purchase date is before the sale date for most transactions, however the purchase (vendor invoice) is in AP but has not been paid (terms are 60 plus days). I have attached the GL for AP showing this.

    Rose-A
    Rose-A
    December 19, 2018

    Thanks for reaching out to us, bglynn58.

    I appreciate the screenshot that you've provided. Allow me to provide a little information concerning inventory in QuickBooks Online.

     

    There should be a value or cost when you first set up the inventory item. COGS will be reported from invoice if the reporting method is in Accrual Basis, COGS will be shown zero if the P&S setup has 0 cost.

     

    COGS will be reported from Bill/Purchase if reporting method is on Cash Basis. If you wish to show COGS on Accrual, make sure that the initial setup of product COST is entered. If already entered a zero cost. Product must be deleted and recreated

     

    You may find this article helpful: How to set up Inventory and tracking.

     

    Feel free to get back to me if you have any other concerns about inventory. I'll be here to help you out. Have a nice day.

    Terms & ConditionsAccessibility statement