cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your business taxes done right with unlimited expert help. Check out QuickBooks Live Expert Tax
Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

We purchase our inventory in bulk, via PO's in QBO. Historically I created an estimate and turned it into an invoice to apply the inventory used on the project. This would populate my COGS as an expense line item and add it to the actual cost of the project.

About a year ago QB updated and screwed my P&L system up for projects. Now that COGS sold only shows up as an estimated cost, not an actual cost for each project.

I have spent countless hours on the phone with QBO support (Case #'s 15101672653, 15101996773, 15105420633) trying to get the issue addressed with no avail. I'm hoping I can get a resolution by posting here again. 

To summarize:

  • Inventory is purchased in bulk via PO from my QBO account directly to my vendor, therefor I cannot create a new expense or bill under the specific project.
  • Estimate and Invoice are created for the client with all items used in the project. This invoice has a markdown of -100% because I bill my clients for the service of installing those items, I do not sell each individual item to the client. The intention of the estimate/invoice is to apply the materials from inventory to the project that they are used on.
  • Total of all line items should be and were historically applied as a COGS expense.

When the update rolled out not only did it stop working on new projects but retroactively removed the data from previous projects.

All items are set up as COGS expenses, with the correct purchase price and no sale price.

 

Please help!

Solved
Best answer September 26, 2023

Best Answers
Rainflurry
Level 14

COGS sold shows up as estimated cost not actual cost

@Derrick Roberts 

 

Ahh, ok, got it.  Are you on cash basis?  If so, that will cause the issue because COGS does not post when an invoice is created on cash basis.

 

If you're on accrual, did you run a Transaction journal report on the invoice(s)?  Do you see COGS posted on the report?  If the project is selected as the customer and the expense account that is assigned to the inventory items (these are inventory items, yes?) is COGS, it should work.

View solution in original post

9 Comments 9
Nicole_N
QuickBooks Team

COGS sold shows up as estimated cost not actual cost

I completely understand your frustration Derrick, and the countless hours you've spent on the phone with QuickBooks Online support, desperately seeking a resolution for your issue. It can be incredibly disheartening when you invest so much time and effort into finding a solution, only to be left without progress.

 

Don't worry, I'm here to help and ensure your concerns are addressed promptly and effectively. However, in order for me to assist you better, I need additional details about the specific issue you're facing. 

 

Following the concern you've shared above, the COGS is a realized cost after selling an item to the customer. Therefore, if you don't sell the (individual) item to the customer, QuickBooks cannot determine the COGS as an expense. If you want to use COGS for the actual cost, which includes the service fees, you need to use that account in your expense transactions. However, it's best to consult an accounting expert on this matter.

 

I would really appreciate it if you could give us more details on the transaction process and the accounts you want to affect. Also, can you clarify the part that you don't sell the items but bill the customer for the services they render? By providing us with more information, such as a detailed description of the problem, or any steps you've already taken to resolve the issue, we can better understand the situation and work towards finding a resolution that meets your needs.

 

Please feel free to share any additional details or questions you may have, and we'll be more than happy to assist you further.

Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

I appreciate you response Nicole! 

 

Below are pics of what I am experiencing.

 

QBO Pics is a snip of the estimate I created for the materials used on the project. I am creating an estimate because that is the only current way that I can get QBO to calculate the COGS at all.

 

It will not let me attach more than 1 file so I will continue this in another reply.

 

Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

The next step in my process is to create an invoice from the estimate. This is where historically QBO would apply my COGS as an expense for the project. I invoice for each item sold with a zero cost to the client, since I charge for the service and not the individual items installed. 

Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

The next snip is of the project overview showing that my  COGS is an estimated expense instead of an actual expense.

Any help in resolving this matter would be greatly appreciated.

Rainflurry
Level 14

COGS sold shows up as estimated cost not actual cost

@Derrick Roberts 

 

Sorry to jump in here but I'm confused by your issue.  The Estimates vs Actuals graph posted shows $4,343.46 in costs from your estimates, $7,612.83 in actual expenses assigned to that project (that includes COGS and all other expenses assigned to it), and $17,745.42 in actual income.  Where do you think QBO is estimating COGS? 

 

Below and to the right of that graph it shows your actual costs which should break out COGS for the project.  That should match the Transaction journal report from the invoices created for the project.  To see the COGS posted from an invoice, go to the invoice, click More, click Transaction journal.  That will show COGS for the inventory items from the estimate when they were added to the invoice.  QBO will post this using FIFO inventory costing. 

Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

Thanks for the response and I apologize for the confusion. I should have showed more in the snip. That attached image shows the expense is actually my hourly cost that QB pulls from Tsheets. The estimated cost that will not change to an actual cost is the total purchase price for all of the line items in the invoice. 

Any help would be greatly appreciated!

Rainflurry
Level 14

COGS sold shows up as estimated cost not actual cost

@Derrick Roberts 

 

Ahh, ok, got it.  Are you on cash basis?  If so, that will cause the issue because COGS does not post when an invoice is created on cash basis.

 

If you're on accrual, did you run a Transaction journal report on the invoice(s)?  Do you see COGS posted on the report?  If the project is selected as the customer and the expense account that is assigned to the inventory items (these are inventory items, yes?) is COGS, it should work.

Derrick Roberts
Level 2

COGS sold shows up as estimated cost not actual cost

Yep, that did it. I am baffled that over all of the phone calls with support that NO ONE suggested that.

 

Thank you for your assistance!

AlcaeusF
Moderator

COGS sold shows up as estimated cost not actual cost

Hello Rainflurry,

 

Thank you for sharing your input to help address the issue. We love to see members supporting one another! Have a great day.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Expert help for your business tax return

Susan, Business Tax Expert since 2010

File your business taxes with confidence thanks to our 100% accurate guarantee.

Explore QuickBooks Live Tax

QuickBooks Live Tax, powered by TurboTax

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up