cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
sajid1110
Level 1

Invoices created appears as a cost of goods sold

Invoice created with inventory item details.

 

Appears as a cost of goods sold.

 

Actually, from profit and loss, COGS is double clicked for details. List appears. Double clicking it reveals that Invoice with inventory item appears as COGS.

 

7 Comments 7
Alex M
QuickBooks Team

Invoices created appears as a cost of goods sold

Hi there sajid1110,

 

Knowing your inventory is an important part of the bookkeeping process. QuickBooks Online makes it easy to track your items in stock with inventory tracking. I can assist you with that.

 

When you make a sale of an Inventory item, the cost of the item is recorded in Cost of goods sold at the moment of the sale. This offsets the decrease in your Inventory asset account, and the other accounts affected will be an income account as well as the Accounts receivable account. If the sale were to be done using a Non-inventory item, only the last two account types will be affected in the sale as the inventory is not tracked. You can further read about this in this article that explains Impacts of inventory tracking on balance sheet and profit & loss reports.

 

Another good source of information regarding the accounting principle behind inventory tracking would be your accountant. Their knowledge of inventory management as well as best business practices will be able to explain the movement of money when making a sale of an inventory item. You can invite them to your QuickBooks Online account by clicking My Accountant and adding their contact info to send them an invitation by email. You can also find an accountant near you with experience with QuickBooks Online by clicking the Find a pro to help button. 

 

I hope this helps you understand the movement of inventory value in QuickBooks Online. If you need any more information, feel free to reach out here.

sajid1110
Level 1

Invoices created appears as a cost of goods sold

Sorry. I understand everything about inventory and its valuation.

 

May be the second part of my original post would give you a better idea of a question.

 

I am in profit and loss account report. I click the cost of goods sold in order to get the details. There appears an invoice for the product sold as a cost of goods sold. How can it be possible? Sales invoice - has it been converted to cost at cost price and taken as a COGS automatically?

 

 

sajid1110
Level 1

Invoices created appears as a cost of goods sold

Also, when this COGS is entered automatically, if yes, how do I enter the purchase of an inventory item as in the form of the bill received from the supplier? Entering that bill wouldn't that double my purchase price. And what happens to the accounts payable portion as well?

Rebecca R
QuickBooks Team

Invoices created appears as a cost of goods sold

Hello @sajid1110 and thanks for providing some clarification on your original question. Understanding the way that your inventory is tracked in QuickBooks specifically, will ensure that you know what money movement to expect between accounts. I want to give you a hand with this.

 

I ran a test in my test account and created a new Inventory item. I set the item cost at $0.25 and the sales price at $0.99. My Expense account is set to Cost of Goods Sold, and my Income account is set to Sales of Product Income. These are the default accounts. I created a new Invoice, selling 1 of my new items. I then ran the Profit and Loss report as you indicated, and clicked on the amount under Cost of Goods Sold. My Invoice appears within that Transaction report, reflecting the Cost of the item, rather than the Rate or Sales Price. This is how this feature is intended to work. 

 

When you're purchasing your Inventory items, you can start by entering Purchase Orders, or skip straight to entering a Bill. When you enter the Purchase Order or Bill, you'll enter the Item details for each Inventory item you're repurchasing. For example, if you order 100 more of an item, the rate you're paying and the total amount will be reflective of what you've saved. If you navigate to the Products/Services tab after entering the Bill, you'll see the amount of Inventory that you've purchased has been added to your Quantity on Hand. Your purchase price won't be doubled if you've entered the correct Rate and Cost within the Product/Service details. 

 

When you've entered the Bill for these inventory items, the total amount will appear in the Accounts Payable, and once you've recorded the Bill payment, it'll clear out your Accounts Payable, leaving you with a $0.00 balance. QuickBooks Online works with a concept called FIFO (First In, First Out). This means that the first units you purchased are the first to be sold. If your cost or rate changes, the items purchased at the previous cost will be sold first. You can learn more about this concept, as well as how the Inventory feature works, within the articles below:

 

 

If you still have questions after reviewing this information, don't hesitate to reply to this thread again. I'm happy to assist you further if you need it! Take care.

Adega
Level 2

Invoices created appears as a cost of goods sold

I'm having the exact same issue, I understand what you have explained above, but I still don't understand why my P&L report is showing the 'invoices' as well as 'expenses' in the 'Cost of Goods Sold' section. Why aren't they separated with 'income' in Sales and 'expenses' in COGS?

 

I've already paid for my products in previous month's expenses, so this is making it look like I'm paying again and am spending more in the month than I actually did. I've been using QB for a year without tracking stock and never had this issue, recently I started tracking stock and this is the first month I'm running our 'End of Month reports' and am getting confused. Any help would be greatly appreciated...

 

Why is it reflecting the cost again when it has already previously been paid for? I don't understand the point of this feature or how to turn it off?

 

** UPDATE ** I don't mean to solve my own query but I've been learning about the 'accrual' vs. 'cash' view of the P&L report, where 'accrual' takes into account all pending money moving in/out, where as 'cash' only shows transactions when the money has actually moved. So I think if I change my view from 'accrual' to 'cash' then this will solve my issue? I'd still appreciate any advice anyone has please :) 

Amanda-B
QuickBooks Team

Invoices created appears as a cost of goods sold

Hey there Adega,

 

Thanks for reaching out to us here. It's vital that all your transactions be entered properly and that you know how the transactions should appear in your books. QuickBooks Online is a great tool able to help you keep track of the money movement created within transactions in order to see the financials of your business. I can point you in the right direction for further information about accounting.

 

In order for you to get the best assistance, I recommend reaching out to your accountant. They'll be able to make sure you're recording your transactions properly in QuickBooks Online and to ensure accuracy in your books. They'll be able to further elaborate on the accounting principles of cost of goods sold so that you can best understand how it's affecting your transactions. You can add your accountant to your books by going to the My Accountant tab of your QuickBooks account. If you're not in contact with a professional, don't worry. You can also find an accountant that has experience using QuickBooks near you by clicking on the Find a pro to help option in that section.

 

If you have any other questions, feel free to reach out here.

mmterm
Level 1

Invoices created appears as a cost of goods sold

Did you ever figure this out? I'm banging my head against a wall very confused. We have hundreds of sales a month and I've never noticed this issue, but maybe only noticing this because it's a bigger sale and I was expecting it to show up on the P+L. My total income is still "correct" because instead of my sales being increased, my COGs is decreased, and it's a wash... but I have no idea why this particular sale/invoice is showing up this way. Doesn't seem to be an issue of accrual vs cash either. 

Need to get in touch?

Contact us