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

Inventory Costed to a Project

I am trying to find the correct way to cost stock inventory to a project. The stock inventory items have been created in QB. I created a PO to the vendor and listed them under the Item Details section and assigned them to the project. When the items arrived I converted the PO to a bill, left the inventory items under Items Detail and assigned each to the project. The items then were the in our inventory system, but the bill was not showing up as costed against the profit margin for the project. I thought at first that this was because it wasn't paid, but after paying the bill the cost does not reflect in the profit margin of the project. 

 

Under the project Transactions, everything is showing up that is assigned to the project(PO's, expenses, bills, etc.) but it seems that only "expenses" are going against the profit margin of the project. Under the bill, if I add a arbitrary line item under Category Details with an amount and assign it to a project it adds to value to the aggregate of the bill, which throws the chart of account out of sink, but that added line now shows up going against the project while the rest of the costs in the Item Details remains invisible to the project profit margin. 

 

I can move the actual inventory quantities to COGS via the inventory qty adjustment, but during that step you can't assign it to a specific project. This is okay since the chart of accounts will be correct, but the problem still remains of how to reflect those costs itemized in the bill to the project. 

 

 

21 Comments 21
AbegailS_
QuickBooks Team

Inventory Costed to a Project

I understand that being able to allocate costs to a project is an essential feature for your business needs, @1treed. Currently, the option to allocate inventory costs directly to a project is unavailable in our system. 

 

While we currently offer the ability to track hourly labor costs and profitability by project, we recognize the importance of expanding our features to better accommodate the needs of our users. I would recommend submitting your feedback directly to our development team. Your input is valuable, and expressing your specific need for this feature may help us understand its importance to our users. This feedback can potentially influence future updates or improvements to our system, ensuring that it better meets the needs of our customers.


Here's how:

 

  1. Click the Gear icon.
  2. Select Feedback under the Profile column.
  3. Enter your product suggestions.
  4. Click Next to submit.

You can track feature requests here: QBO Feature Requests.

 

I have articles here about inventory tracking and report status:

 

 

I'm just a reply away if you need anything else with managing your inventory. I'm always here to help.

1treed
Level 2

Inventory Costed to a Project

@AbegailS_  thank you for your feedback and response. This is a huge bummer since allocating stock inventory to any project is important for tracking its profitability. 

 

Going back to the Bill feature specifically, if the items on the Bill are listed under the Category Details those items seem to then cost against the project, but if they are listed on the Bill under Item Details the seem to disappear even though they are assigned to the project. 

 

To me this seems like a bug in the application. If not, what is the purpose of the Item Details and subsequent Customer/Project assignment if it doesn't actually move any costs against the profitability of the project?

AbegailS_
QuickBooks Team

Inventory Costed to a Project

I appreciate you for getting back to the thread, @1treed.

 

The purpose of assigning items to a project within the Item Details section should ideally be to accurately track and allocate costs to the profitability of the project. If this functionality is not working as expected I recommend  reaching out to the support team of the application to report this issue. Providing specific details about the problem you've encountered can help the development team investigate and address this potential bug. 

 

Here's how you can reach them:

 

  1. Click the Help tab in the upper-right corner.
  2. Go to the Assistant tab.
  3. Click Get help from a human.
  4. Choose Chat with us or Have us call you.

I've added these articles for more tips while working on your inventory entries and vendor bills:

 

 

If you have any further feedback or questions, please feel free to reach out to us. I'm always here to help. Have a great day.

1treed
Level 2

Inventory Costed to a Project

@AbegailS_ thank you for your response. Is there a alternate route for getting support? I went this route yesterday which inspired me to post in the community. After spending 2+ hours on the phone with a QB rep there wasn't much progress nor grasp of the underlying issue with inventory movements and cost accounting. 

 

 

MarkAngeloG
QuickBooks Team

Inventory Costed to a Project

Hello there, @1treed.

 

I appreciate your quick response. However, the only route for contacting our support is the same as what my colleague provided. I'd still recommend contacting our support again, as they have the suitable tools to help you fix the issue. I assure you that our support will take your case seriously, and we always strive to provide solutions.

 

Here's how:

 

  1. Click the Help button in the upper-right corner.
  2. Select the Assistant tab.
  3. Click Get help from a human.
  4. Choose Chat with us or Have us call you.

 

You may also want to consider entering and managing bills and bill payments in QuickBooks Online.

 

As always, the Community space is here to help everyone. Feel free to reply below if you have further concerns. I'd gladly help you anytime.

amanda-pindropav
Level 2

Inventory Costed to a Project

I seem to be having this exact same problem. There is one project that for some reason won't reflect in the project cost that the product has been paid for even though the bill is linked correctly. It, however, does reflect the other line items I have for shipping in the same PO/bill. When I check my inventory, it says that I still have all 12 of that product in stock when I clearly shouldn't...

treed1
Level 2

Inventory Costed to a Project

So I have been around the QB world on this issue and the final response I got from the support crew was that this "should" work and that this is a "feature limitation" which I thought was a creative way to rename a bug in the platform. There are no plans to correct this issue and my communications ended there. 

 

This guy made a helpful video on a work around in QB for this issue: https://www.youtube.com/watch?v=yBQnZyzds8U&t=6s

 

It is a little tedious, but allows you to move the inventory to a temporary account and then cost it to a project thru a separate journal transaction. It's important to note that either way you have to use to inventory qty. adjustment function to move the inventory, but it would be nice if the cost to the project could be done at the time of that transaction or through the bill function. 

 

We have implemented to process outlined in the video above and it will get you what you're looking for. Just extra steps and time. 

 

I've used the full range of accounting systems over the years from SAP to QB and it always surprises me how much it seems inventory in QB is an afterthought. Something so important and simple is always more brutal than it should be. 

treed1
Level 2

Inventory Costed to a Project

So I have been around the QB world on this issue and the final response I got from the support crew was that this "should" work and that this is a "feature limitation" which I thought was a creative way to rename a bug in the platform. There are no plans to correct this issue and my communications ended there. 

 

This guy made a helpful video on a work around in QB for this issue: https://www.youtube.com/watch?v=yBQnZyzds8U&t=6s

 

It is a little tedious, but allows you to move the inventory to a temporary account and then cost it to a project thru a separate journal transaction. It's important to note that either way you have to use to inventory qty. adjustment function to move the inventory, but it would be nice if the cost to the project could be done at the time of that transaction or through the bill function. 

 

We have implemented to process outlined in the video above and it will get you what you're looking for. Just extra steps and time. 

 

I've used the full range of accounting systems over the years from SAP to QB and it always surprises me how much it seems inventory in QB is an afterthought. Something so important and simple is always more brutal than it should be. 

MJoy_D
Moderator

Inventory Costed to a Project

Thank you for posting, @amanda-pindropav

 

To help you with checking your inventory, I suggest reaching out to our Customer Support team. They can check your account in a secure environment and help you with resolving them. 

 

Follow the steps below: 

 

  1. Go to the Help icon to connect to a live support agent. 
  2. Select the Search tab and click on the Contact Us button.
  3.  Select a topic for your concern in the What can we help you with? section.
  4. You'll now be provided options on how to connect to our Customer Support.

 

You can check this article for more information about the different types of support we offer and their availability: QuickBooks Online Support.

 

Here's more information about adjusting inventory quantity on hand in QuickBooks Online

 

Let me know if you need more help with your account. I'm always here to answer them for you. Have a great rest of the day!

Hannah81
Level 1

Inventory Costed to a Project

Hello there, is there anyway to share your video again?  I'm having the same issue with inventory costing to the project, while also deducting it from inventory.  Thanks, Hannah

treed1
Level 2

Inventory Costed to a Project

Hannah, 

  Looks like the video was taken down. If you still need this I can make one showing how we do it and post it. Just lmk. -Thomas

CabochonIT
Level 1

Inventory Costed to a Project

Hello, @treed1 

 

We just migrated to QBO, and we're running up against the same thing. I'm just trying to iron out a good process for allocating inventory adjustments to a project - could you explain your process?

thanks,

dan

Hannah81
Level 1

Inventory Costed to a Project

Yes, please share the video.  Appreciate you!

LianneW
Level 1

Inventory Costed to a Project

Hello. 

We are also experiencing the same frustrating issue.
I've left feedback on QuickBooks but they don't seem to realize how valuable this feature would be to so many.

Please post a video showing the workaround using Journal Entries - it would be extremely helpful to us.

Thank you!

LianneW
Level 1

Inventory Costed to a Project

Hi

We are experiencing the same frustrating issue. I've left feedback on QuickBooks but they clearly don't realize how valuable this would be to so many clients.

Please post the link for a video explaining the workaround for this using Journal Entries. It would be a big help

Thank you!

CynthiaH2023
Level 2

Inventory Costed to a Project

We are running into this as well.  We also use the bundles and allocate inventory items to the bundles.  I sent feedback to QBO, but I'm thinking this is something that's been an issue for a long time, lots of complaints and nothing being done about it.  I miss QB Desktop actually and don't understand why they just couldn't take that exact concept and make in online.  So many extra steps in QBO.  There are good features as well, but I really miss Desktop.

CynthiaH2023
Level 2

Inventory Costed to a Project

I can't find the video either.  Are you able to leave one?

treed1
Level 2

Inventory Costed to a Project

@CynthiaH2023 @LianneW @Hannah81 @CabochonIT 

 

Video link: https://youtu.be/EcMsQ-GYYp0

 

I'm not a pro at making content videos, so feel free to let me know if there is any information missing. 

Short video on how to move items tracked in QB online inventory and assign it to a cost of goods sold account and have the value tracked in the QB Project feature. Prerequisites: 1) Know how to create inventory items in QB 2) Know how to create a new "Temporary - Cost of Good Sold" account in the
treed1
Level 2

Inventory Costed to a Project

@CynthiaH2023 @LianneW @Hannah81 @CabochonIT 

 

Video Link: https://youtu.be/EcMsQ-GYYp0

 

I'm not a pro at making content videos, so please let me know if any information is missing. 

 

Thank you, -TR

Short video on how to move items tracked in QB online inventory and assign it to a cost of goods sold account and have the value tracked in the QB Project feature. Prerequisites: 1) Know how to create inventory items in QB 2) Know how to create a new "Temporary - Cost of Good Sold" account in the
LianneW
Level 1

Inventory Costed to a Project

Thank you!

This is great

Hannah81
Level 1

Inventory Costed to a Project

Thank you for taking the time to make this.  So unfortunate we have to jump through so many hoops though!  I hope QB fixed this soon!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us