Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 30, 2022
Solved

Inventory expense question

  • May 30, 2022
  • 2 replies
  • 9 views

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!

Best answer by Rainflurry

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...


@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

2 replies

Moderator
May 30, 2022

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.

 

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.

 

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.

 

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.

 

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 11
May 30, 2022

@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.

FP98Author
May 30, 2022

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 11
May 30, 2022

@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.