Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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.
@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?
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:
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.
@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.
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:
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.
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...
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.
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.
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:
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!
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
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
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
Yes, please share the video. Appreciate you!
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!
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!
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.
I can't find the video either. Are you able to leave one?
@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.
@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
Thank you!
This is great
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here