cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Visit our new QuickBooks News section for news, updates, and opportunities to give feedback.
Highlighted
Level 1

Tracking the inventory and POs costs related to project on QB Enterprise

We are using QB Enterprise with an advanced inventory module.

Is there a way we can trace the material cost (PO and inventory) spent on a project; for example building a piece of machinery?

 

How should we set up a project to get the best financial picture of the project?

 

Thank you!

 

 

5 Comments
Highlighted
QuickBooks Team

Tracking the inventory and POs costs related to project on QB Enterprise

Hello GWINKLER,

 

Thanks for being a part of the QuickBooks Enterprise family! Enterprise is a powerful version of QuickBooks and with add-ons like Advanced Inventory, you can do even more with your books. I appreciate you taking the time to share what you'd like to accomplish in the program and I'm here to help.

 

From what you've described, it sounds to me like exploring job costing in QuickBooks would be a great option for you. When you set up your customers, vendors, and transactions to track job costs, you can then easily use reports and other features in the program to see things like material costs and even time tracking. We have a great help article about this right here in Community. Check it out: Tracking job costs in QuickBooks Desktop

 

To have an agent work with you or if you have more detailed questions, I recommend reaching out to our QuickBooks Desktop support team. At this time, Desktop support is offered through chat or social media. While the Desktop team normally has a phone team, due to the COVID-19 outbreak, there is reduced staffing. It's important to us that we're able to help you get back on track though, which is why we offer the following options.

 

QuickBooks Desktop Canada chat supporthttps://intuit.me/cachat

Social MediaFacebookTwitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

 

You can learn more about QuickBooks Desktop support here: Intuit QuickBooks Desktop software support policies

 

I hope that helps! Feel free to stop by again. :)

Highlighted
Level 1

Tracking the inventory and POs costs related to project on QB Enterprise

Good afternoon Laura;

Thank you very much for your help.

I realize that I can set up customers and jobs and I can assign jobs to individual POs or transactions.

My main challenge is as follows;

1. I purchased inventory part 'A" from a vendor and it went to inventory. PO and invoice were received and vendor was paid.

2. At later date it is decided that part "A" will be used in a project (job). Is there a way that we can transfer inventory to a job, bill of material or something similar?

Is there a way I could determine a different price for let's call it "internal bills of materials"?

 

Looking forward to hearing from you!

Highlighted
QuickBooks Team

Tracking the inventory and POs costs related to project on QB Enterprise

I'm glad my last post was at least a bit helpful to your, GWinkler64. I appreciate the follow up with more information about your situation. I see how navigating transactions that are already in place and making them a part of a job afterward could be tricky. I want to make sure you know your options moving forward.

 

To add existing transactions to the job should be as simple as assigning the customer to the transaction. For instance, regarding the bill, you can reopen that transaction (from the vendor's Transaction List may be easiest) and then add the Customer:Job in the column for the line items. This can also be done with purchase orders. This ensures allocation of all costs to the job and marks them as billable to the customer.

 

It sounds like we could use a few more details about what you're trying to do since I'm not quite sure what you're looking for when you talk about determining a different price. It's important to me that you get this sorted out, so I encourage you to get in touch with our QuickBooks Desktop support team in one of the following two ways.

 

QuickBooks Desktop Canada chat supporthttps://intuit.me/cachat

Social MediaFacebookTwitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

 

The chat is in place for QuickBooks Desktop Canada customers instead of the phone team right now due to the reduced staffing for COVID-19. I want to assure you our trained staff is still at the ready to help you, but this avenue of support is helping with the support flow at this time. The social media team is a staple in support, also ready to help you out.

 

Give us a shout and we'll help you get back on track.

Highlighted
Level 1

Tracking the inventory and POs costs related to project on QB Enterprise

Hi Laura

First thank you very much for your investigative questions. I appreciate it.

This time I will be more descriptive. I will even attach some files.

First, I understand the solution to my challenge when the intention is known at the time when the PO is issued.

I assign the job and on my PO at the time of placing PO. I receive the bill a post it. Problem solved.

There are the challenges I am facing.

Company I work for builds robotic equipment.

The same item may be used in different robots and some of these items are not needed at the moment.

It is common for us to purchase more parts than required, since we will get better price.

We keep them in inventory and they are often used at later date in different projects.

So here it is. There is PO for from “Canadian Vendor”. I received items; I matched the bill and paid for it.

100 pieces of P004203A were allocated to “Robot A” project.

Since P004203A is an inventory item, it is not reflected in job cost, since it is inventory.

How do I expense it to the job? It appears on my “Unbilled Costs by job”

Few moths later it was decided that 200 items will be used in job “Robot B”.

How will assign these items to “Robot B”?

Highlighted
Level 7

Tracking the inventory and POs costs related to project on QB Enterprise

Hey GWinkler64;

 

Thank you for following up. I think I understand how you hope to have this recorded, and I believe it would be beneficial to connect with an agent for some real-time assistance. This would make it easier for us to work as a team, while actively researching for a solution. Here's how you can get in touch with support. 

 

QuickBooks Desktop Canada chat supporthttps://intuit.me/cachat

Social MediaFacebookTwitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

 

The chat is currently being offered to supplement the reduced staffing for QuickBooks Desktop as our team adapts to the impacts of COVID-19. Support is handled by the same great experts you're used to on the phones, and they'll be happy to assist you. The social media team largely consists of the same agents who provide assistance here on community, such as Laura and me. If you reach out, feel free to send a link to this page so you don't need to re-explain the situation.

 

We're here for you, so don't hesitate to reach out.