Skip to main content
J
Juneflower
July 19, 2022
Solved

Manufacturing: WIP to Finished Goods:

  • July 19, 2022
  • 2 replies
  • 0 views

We are a manufacturing company and currently we are using QB 2018 Enterprise. At the end of the day/month there is WIP and finished goods. We already account for Raw Materials and finished goods, but how do we (1) account for and show WIP at day end and (2) next day, how do we move this WIP into finished product (3) how can we generate the necessary reports to show our WIP and Finished Goods? I have not been able to find this at all in any of the queries. Thanks in Advance.

Best answer by Rustler

You said
" We already account for Raw Materials ..."
Raw materials are inventory items. In Enterprise you can set up an additional inventory site and title it WIP. Move the items being used out of inventory and into the WIP site.

 

When the production floor is done making what ever it is, issue a build command for the assembly item (and if necessary any sub assembly items which are required) which uses the items from the WIP site. Then you sell the assembly item.

 

No expenses are incurred during this process.

2 replies

Rustler
RustlerAnswer
July 20, 2022

You said
" We already account for Raw Materials ..."
Raw materials are inventory items. In Enterprise you can set up an additional inventory site and title it WIP. Move the items being used out of inventory and into the WIP site.

 

When the production floor is done making what ever it is, issue a build command for the assembly item (and if necessary any sub assembly items which are required) which uses the items from the WIP site. Then you sell the assembly item.

 

No expenses are incurred during this process.

    J
    JuneflowerAuthor
    July 21, 2022

    Super! Thanks for responding.

    C
    Clarkipinc
    September 19, 2023

    How do you manage manufacturing with QB?  We have use it for years and you cannot run production of a product.  You can only do assembly.  I have called QB many times and they can only suggest to make an inventory adjustment to get my product into inventory.  We have done a two step process of issuing a P.O. to ourselves with the item and quantity at zero cost and then receive the product.

     

    Any clues?   It is not a manufacturing software is assembly software.

     

    Rick

    R
    rvrfrf
    September 19, 2023

    Thanks for joining the Community and getting involved with this thread, Clarkipinc.

     

    With a Premier, Enterprise, or Accountant subscription, you can track products that you manufacture. QuickBooks allows you to combine inventory parts and other items to build a product.

     

    Initially, you'll want to turn on inventory tracking.

     

    Here's how:
     

    1. In your top menu bar, go to Edit, then Preferences.
    2. Access the Items & Inventory screen.
    3. Open your Company Preferences tab.
    4. Turn on the Inventory and purchase orders are active and Warn if not enough inventory to sell options.
    5. Choose which type of warning you want to see.
    6. If you're using Enterprise, you'll also have a Don’t allow negative inventory quantities option you can turn on if you'd like to.
    7. In the event you use a unit of measure to track products, hit Enable in your UNIT OF MEASURE section.
    8. Select OK.

     

    Once the settings are in order, you can set up each part you use to build a product:
     

     

    Next, you'll need to add your product's bill of materials and proceed with the steps in our Track the products you manufacture article.

     

    I've also included a detailed resource about assembling and tracking manufactured products which may come in handy moving forward: Combine your inventory items to build finished goods

     

    Please don't hesitate to send a reply if there's any additional questions. Have an awesome Tuesday!

    Terms & ConditionsAccessibility statement