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

Inventory expense question

I am new to quickbooks and having some trouble figuring out inventory so figured I'll ask you for some help. I have inventory, however, I only pay my vendor cost price as I sell my inventory he "lent" me. What would be the best way to do the following. Customer places an order for inventory Items and I need to pay for the items I am taking out of inventory (cost of goods sold) and invoice my customer. In addition, when you invoice a customer and quickbooks deducts it from inventory does it get marked as a cost of goods sold expense? and if yeah how do I avoid this expense being recorded double... Any help appreciated!

Solved
Best answer May 30, 2022

Best Answers
Rainflurry
Level 13

Inventory expense question

@FP98 

 

The reason it is not COGS is because you do not own the inventory.  COGS has a specific way of being calculated (beginning inventory + purchases - ending inventory = COGS) - see Part III of Schedule C for Form 1040.  Both you and your vendor cannot claim to own the same inventory.

 

Again, from the IRS:

Do not include merchandise you receive on consignment in your inventory

View solution in original post

9 Comments 9
Kevin_C
QuickBooks Team

Inventory expense question

Hello there, @FP98.

 

I'm here to help you with your inventory concerns in QuickBooks Online (QBO).

 

Based on your scenario above, you can record this as a billable expense transaction since you want to pay for the items while creating an invoice for a particular customer. Also, please note that this feature is available in QBO Plus and Advanced versions. To do this, you can follow the steps below.

 

First, let's make sure to enable billable expense tracking in QBO:

 

  1. Go to Gear ⚙ icon, then select Account and settings.
  2. Select the Expenses tab, then select Edit ✎ from the Bills and expenses section.
  3. Turn on the Show Items table on expense and purchase formsTrack expenses and items by customerMake expenses and items billable.
  4. Set up the other necessary options.
  5. Click Save and Done.
    Billable 1.PNG

 

Then, we can now proceed to enter a billable expense. Here's how:

 

  1. Click the + New button, then select Bill.
  2. Choose the payee.
  3. From the Item details column, select the product/service item.
  4. Enter the description and amount of the expense. Then, select the Billable checkbox.
  5. In the Customer column, choose the customer you want to bill for this expense.
  6. Fill in the other needed fields.
  7. Click Save and close.
    billable 2.PNG

 

Lastly, we can now link the billable expense to your customer's invoice:

 

  1. Click the + New button, then select Invoice.
  2. In the Customer ▼ dropdown menu, select the customer you created a billable expense for. This opens the Add to invoice window.
  3. Select Add on the billable expense you want to charge to your customer.
  4. Click Save and close.
    Billable 3.PNG

 

For your next query, you're right that it will be posted to your Cost of Goods Sold (COGS) account. To review the account posting, you can just click the More button at the bottom of the sales transaction page, and then select Transaction journal.
Billable 4.PNG

 

For your last concern, normally this won't create a double posting if you have just recorded the billable expense correctly.

 

Additionally, I'm including this reference that is helpful in checking the best sellers, what’s on hand, the cost of goods, and more among all of your items: Use reports to see your sales and inventory status.

 

Feel free to leave a comment below if you have any other questions about QuickBooks. We're always here to make sure everything is sorted out. Take care and have a great day!

Rainflurry
Level 13

Inventory expense question

@FP98 

 

This sounds like consignment inventory.

 

You do not record inventory consigned to you as inventory at all.  Consigned inventory stays on the books of the consignor (vendor) since they own it.  And, since you do not record it in your inventory, you do not post the sale of consigned inventory to COGS.  COGS is only used when you have beginning and ending inventory which you don't have - the consignor does.  When you sell the consigned inventory, pay the vendor using an expense account called "Consigned inventory sold" or "Cost of sales" or something similar.  

 

Here is what the IRS says (Publication 334):

Do not include merchandise you receive on consignment in your inventory. Include your profit or commission on merchandise consigned to you in your income when you sell the merchandise or when you receive your profit or commission, depending upon the method of accounting you use.

FP98
Level 2

Inventory expense question

I never heard of consignment inventory - but it definitely sounds correct to my scenario. - Although I pay the vendor the same price he paid the manufacture. - does that make a difference that the vendor does not make any profit?

 

In addition, I already added all the inventory into my quickbooks inventory since I need to keep track of how much inventory there is. I guess that was a mistake that I did that. - how would I rectify that and how do you suggest to keep track of the inventory?

Rainflurry
Level 13

Inventory expense question

@FP98 

 

What matters is who owns the inventory.  Only the party that owns the inventory records it as an inventory asset on their books and then expenses the sale of inventory to COGS when sold. 

 

However, it is not wrong for you to have it recorded as inventory in QuickBooks as long as you don't file your taxes using inventory and COGS.  I would suggest that you rename your inventory asset account "Consignment inventory".  Assuming you're a sole proprietorship, when you file your tax return, report the cost of the consigned inventory as "consignment inventory expense" of "cost of sales" on Schedule C - do not complete Part III - Cost of Goods Sold.    

FP98
Level 2

Inventory expense question

Got you. You are being very helpful! So now with all the new and helpful information- How should I record a sale that quickbooks does not deduct the expense twice of my cost of goods? simplest way... Like is there a way for quickbooks to deduct from inventory without taking off the cost of it as an "expense"? Since if I create a bill to my vendor and pay it out of that account ("Consigned inventory sold") And then invoice my customer. quickbooks will take it report expense twice (from bill paid + taking out of inventory) and my profit and loss reports will be messed up then - no?


Thank you!!

Rainflurry
Level 13

Inventory expense question

@FP98 

 

Like is there a way for quickbooks to deduct from inventory without taking off the cost of it as an "expense"?

 

Oops, yes, I should have been more clear on that point.  When you enter the bill from your vendor, assign it to the "Consignment inventory" account.  That will add the cost to the consignment inventory account and not book any expense at that time.  Then, when you sell the item, QB will reduce the consignment inventory by that amount and book the expense to COGS.  So, you will only have the expense booked one time - to COGS when you create an invoice/sales receipt.  But, remember, technically, it is not COGS, it should be reported as "Consignment inventory expense" or "Cost of sales" on your tax return.  

FP98
Level 2

Inventory expense question

Thank you! Got my answer.

One thing I am unclear about is why this cannot be cost of goods sold and cost of sales? It is goods being sold and the expense of them to the vender - but it "happens" to be it is being help by you... At the time of sale you have the inventory from beginning (you pay vendor) to end...

Rainflurry
Level 13

Inventory expense question

@FP98 

 

The reason it is not COGS is because you do not own the inventory.  COGS has a specific way of being calculated (beginning inventory + purchases - ending inventory = COGS) - see Part III of Schedule C for Form 1040.  Both you and your vendor cannot claim to own the same inventory.

 

Again, from the IRS:

Do not include merchandise you receive on consignment in your inventory

FritzF
Moderator

Inventory expense question

Hi there, Rainflurry.

 

I appreciate you for always sharing your knowledge about QuickBooks. This will definitely help other users as well in the future.

 

Keep safe and have a great rest of the day.

Need to get in touch?

Contact us