cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
Wright
Level 2

Stock. How do I add used stock to a project.

Hi All

 

I have watched the how to set up stock etc.

 

We dont actually sell stock (screws, silicone, etc) but they are used on the building projects. 

 

Currently we use spreadsheets to do costings of each project.  So all the items purchased go on them.

 

Now Purchases from suppliers that are for each project is easy they are in the customer/project.

 

But I want to set up stock of items like screws etc.  But we dont sell them to the project.  So how can I get them on the project profitability report. Without creating an invoice that will never get paid.  We get paid via valuations each month.

 

I hope I have explained this ok. 

Solved
Best answer February 26, 2019

Accepted Solutions
TaliaI
QuickBooks Team

Stock. How do I add used stock to a project.

Hello Wright,

 

We apologise if this will not be suitable for your business. Please use our feedback tool within the cog wheel menu to submit this as an option for future updates - hopefully it will be implemented if possible.

 

Thanks,

Talia

View solution in original post

7 REPLIES 7
TaliaI
QuickBooks Team

Stock. How do I add used stock to a project.

Hello Wright,

 

When recording purchasing the items, you would enter the project name in the 'Customer/Project' box within Item Details. This will post the amount of that transaction line to the project.

 

Thank you,

Talia

Wright
Level 2

Stock. How do I add used stock to a project.

Hi

 

But the problem is we dont buy for just the one project.  We buy a stock say 100 boxes of each, and they take what they need each day for different sites.

 

So on the supplier bill/invoice I cant allocate how many for each project as I dont know, at that time.

TaliaI
QuickBooks Team

Stock. How do I add used stock to a project.

Hello Wright,

 

In that case, you will need to go back into the bill once you know how much of the product you have used and create a separate line so this amount posts to the project - this will be the only way for it to appear on the project profitability report.

 

Thank you,

Talia

Wright
Level 2

Stock. How do I add used stock to a project.

Ok thats a bit poor then. Smiley Sad

 

As that would take way to long to do that.

 

 

Dont look like we will be using the stock part of Quickbooks then.

TaliaI
QuickBooks Team

Stock. How do I add used stock to a project.

Hello Wright,

 

We apologise if this will not be suitable for your business. Please use our feedback tool within the cog wheel menu to submit this as an option for future updates - hopefully it will be implemented if possible.

 

Thanks,

Talia

View solution in original post

alex-b
Level 3

Stock. How do I add used stock to a project.

Hi, I may be wrong on this, but I think that if you add a stock item to an invoice, it then decreases your stock amount by what you've added to the invoice. Isn't this what Wright was after?

 

I think it's what we need, and it sounds similar - we keep a certain number of items in stock as spares, and when we need to supply them to a customer, or use them in a repair job, we add them to that customers invoice. Sadly, what that doesn't do is add the cost of the stock item to the customer's project - that would be my feature request please!

 

When we get down to a certain level, we simply order more from our supplier, and put that cost against general Project Costs rather than any specific customer project.

 

I hope that helps Wright, although it's been some time I know, as I think that'll help you keep track of your stock, even if not your specific project costs.

 

Alex

Kavco
Level 1

Stock. How do I add used stock to a project.

I had a similar problem and my work-around is to created a "Delayed Charge" invoice.  The shop would give me a list of material used on the job FROM INVENTORY throughout the project.  In order to keep inventory up to date and not forget to charge the customer I could add items to the delayed charge and then, when it came time to bill the job I had a choice:
1.  If I want to bill the customer line by line the items come up as billable when I create an invoice

2.  If I want them to be billed to the job but NOT show up as details then I create a ZERO invoice on this project that the customer never sees - but my inventory is correct and the project cost is correct.