Level 7

Solved

Cost of goods sold issues in Profit and Loss Statement

Forum|Forum|7 years ago
October 16, 2018
28 replies
105 views

Hello , I manage a service station quick books is used as the method of choice for book keeping and tracking inventory . One of the issues I am having is with the Cost of goods sold section in my Profit & Loss sheet . When gas and diesel is purchased from the supplier should thos be showing as a debit or credit entry under the cost of goods sold section ? My second question is similar as i relates to purchasing snacks(i.e sodas, chips) for resale in the station should this be showing as a debit or credit ? Lastly, when the company actually sells the diesel and gas to various clients how should this be reflected under cost of goods sold ( debit entry i assume) ? Ultimately , it is believed the cost of goods sold is reflecting inaccurately because there is about a 10% difference between the figure and total sales .Thanking you in advance for your assistance.

QuickBooks Online

Best answer by Rustler

sales post to income - always

If you use QB inventory items, then when you purchase you do not use an expense account like COGS

you use the item details part of the purchase, and list each item, qty and total cost - that stocks inventory as an asset, and when sold moves the cost from inventory asset to COGS

if you do not see the item detail part of the purchase screen, in company settings>expenses>bills & expenses turn on the items table and purchase orders

If you are not using inventory items in QBO, let me know and I can explain periodic inventory

RustlerAnswer

Level 15

sales post to income - always

If you use QB inventory items, then when you purchase you do not use an expense account like COGS

you use the item details part of the purchase, and list each item, qty and total cost - that stocks inventory as an asset, and when sold moves the cost from inventory asset to COGS

if you do not see the item detail part of the purchase screen, in company settings>expenses>bills & expenses turn on the items table and purchase orders

If you are not using inventory items in QBO, let me know and I can explain periodic inventory

C

Carlaleeanne

Please help. I was on the phone with QB for over an hour and did not get my issue solved. I have just recently started tracking my inventory. I have all Product set up as "inventory item"like to "inventory asset" account "Income account is "Sales of Product Income" and the expense account is "Cost of Goods Sold". I have a an amount in the "Sale Price" and an amount in the "Cost". Yet when I run a P&L and look at the list of items in "Cost of Goods Sold" all of the items cost is 0.00. How do I get QB to track COGS? Thank you so much for your time.

A

Anonymous

Hello HoneyLynn, it would be helpful if you could explain what do to rather than referring us to an existing help article. I have been on phone with QB support for over an hour and they are telling me that it is not possible to show the $0. This makes no sense, since COGS and Inventory Value are showing up on the Transaction Detail of any given Invoice. Help would be greatly appreciated!!

Hello, @acgoggin.

I appreciate you reaching out to this thread to search for answers about the zero value for COGS. I'd be glad to help clarify the COGS and Inventory Value showing up on the Transaction Detail report.

When setting up an inventory item with no sales price and cost, it'll also show a zero amount on the Transaction Detail for Inventory Asset and COGS. So even if you try editing the cost and sales price, QuickBooks will still analyze it as zero COGS and Inventory Asset not unless the quantity for that item is zeroed out.

If you want to show the COGS on the report for this item, you'll need to adjust the quantity and recreate the inventory item. To know more about inventory adjustment, you can check out this article: How to adjust inventory quantity on hand.

I've attached some sample screenshots below about the differences between an item with and without cost and sales price. Also, how it would look like in the Transaction Detail By Account.

This should help guide you in the right direction. If you need other helpful references, you can always visit our site: Help articles for QuickBooks Online.

Should you have other questions about COGS and Inventory, please don't hesitate to hit the Reply button. I'm always here to help.

Rustler

Level 15

On the P&L the number in COGS should be positive ( debit) the P&L does not show debits and credits unless you drill down

see the pic for how an inventory item should be set up

Sales is income, that is a credit to an income account, you do not post both sales and costs to one account if that is what you asking abount

L

lindak1119Author

Level 7

I use the items tab when I purchase my inventory . Initially I would create a purchase order for instance if I was to purchase 1000 gallons of diesel oil, then receive items and enter , and then pay the bill . In the bill I put in the item specifics under the item tab and under the expenses tab I account for VAT tax . Hypothetically, the total cost of the diesel is $2719.75 , where it is purchased at $2.64 per gallon and vat totals $79.75 .When I go into the cost of goods sold tab in my profit & loss this is being shown as a credit entry of $60.05 . When I go into other monthly reports some of the purchases in cost of goods sold is reflected on the credit side and some on the debit and all are understated . Something is wrong I don't know what .

Sign up

Login with SSO

Let's get you signed in

Login with SSO