Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 16, 2021
Question

Inventory / Roofing Company

  • March 16, 2021
  • 5 replies
  • 54 views

I have a question about setting up inventory - we just switched to QB Enterprise (previously on QB Premier) in hopes of using the inventory feature.  We are a roofing company.  We purchase materials in bulk to use on projects, and sometimes return items to our warehouse that we over-ordered, and use them on future jobs.  But after watching the initial training videos for QB Enterprise, it sounds like setting up these items as inventory would be a mistake, because we are not directly reselling them.  

 

I want to be able to do the following:

- Purchase items in bulk from our vendor and track the cost and count

- "Pull" from these items and allocate the job costs to several jobs

- Return items from jobs to our inventory and re-allocate to other jobs

 

Is this something that can be done via QB Enterprise Advanced Inventory?

5 replies

Moderator
March 16, 2021

Glad to have you here in the Community, @accontractors.

 

Let's set up your inventory in QuickBooks Desktop so you can get back to working order.

 

To track the cost and count of the items you purchase in bulk, you can turn on the Unit of Measure feature. Then, create a bill for the materials you want to purchase from your vendor. Here's how to turn on the feature:

 

  1. Go to the Edit menu, then select Preferences.
  2. Select Items & Inventory from the left menu and choose Company Preferences.
  3. In the Unit of Measure section, select Multiple U/M Per Item from the drop-down.
  4. Click OK to save the changes.
  5. Once done, enter a bill for the items you'll purchase.

 

On the other hand, you can allocate the items to the job costs by creating an invoice. This way, the Cost of Good Sold (COGS) will be allocated to the job. Then, if the items were returned, you'll want to enter a refund to add back the items to your inventory. And create an invoice again to re-allocate the items to other jobs.

 

However, if you don't want to process this with invoicing, you have the option to adjust inventory to allocate which job it gets assigned to for relieving it from stock on hand. Here's how:

 

  1. Go to the Inventory menu, then select Adjust Quantity/Value on Hand.
  2. From the Customer:Job drop-down, choose the job.
  3. Select the items you want to allocate.
  4. Click Save & Close.

You might want to read these articles to learn more about the Advanced Inventory feature in QuickBooks Desktop:

 

 

Please let me know if you need clarification about this, or there's anything else I can do for you. I'll be standing by for your response. Have a great day.

March 17, 2021

Mark, thank you for the reply.  With either of these options (recording the inventory via invoice/refund or by adjusting Inventory manually) is there a way to use the barcode scanner feature?  Our Production Team wants to be able to scan items in/out of our warehouse area.  I watched the demo videos and it seemed like this was only available via Purchase Orders.

Fiat Lux - ASIA
Level 14
March 17, 2021

@accontractors 

The Advanced Inventory feature is fit for a wholesale/trading or a manufacturing company. I would recommend to use a construction management app for your business. It is possible you only need a one time license of QBD Premier + a construction management app.