Best way to capture labor for non-stock items but use sales order for rev & cogs matching

Here is the issue I'm trying to solve for. We use production management, work tickets, BOMS etc. For the most part, this works because we are typically manufacturing something and in combination with Sales Orders, I can drive Rev and COGS. I have a similar scenario where we are paid for R&D, these agreements usually have milestones and we will bid for labor and sometimes materials for each milestone. 

I'm trying to capture labor and materials for each milestone and when we are ready to "ship" (i.e. close the sales order) the item (the item here can simply be a report, doesn't have to be an inventory item), and costs gathered would drop into COGS the same way it would if we were selling an inventory item.

I would like to use the work ticket for this because I like the functionality that comes with it. My engineers could book time and materials to the WT, and Sage would capitalize (WIP) this cost and create the entries against labor until we are ready to bill as if it was an inventory item. There are other ways of course. I could manually capitalize labor when running payroll but that would require me to indicate the milestone being capitalized, track on the BS, and then manually JE it back to the income statement when we bill for a milestone. 

Is there a way to do this using sales orders and work tickets without creating inventory when we close the work ticket?

Thanks

  • 0

    Why not create a product line / item code specifically for the intellectual property?  The separate PL allows you to have different GL accounts for the IP value, while the inventory item code allows the full benefits of normal WT's.  Use Lot/Serial valuation to track project specific costs...

  • 0 in reply to Kevin M

    Thanks for the response Kevin. If I went the route of Product line, would this mean I have to blow out my COA with new accounts for each product? For instance, if I have revenue account 4000 and I have 4 Product lines, will I need to create 4000-1, 4000-2, 4000-3, 4000-4?

  • 0 in reply to Bryce Schuske

    You can use the same GL accounts in multiple product lines where you want... so if you don't want separate revenue accounts, there is no need to create new ones for each PL.  Where you would probably want a dedicated Inventory control account for the non-physical inventory (IP), to make balancing IM to the GL easier.  Example:

    • 1150-0 = normal inventory
    • 1151-0 = intellectual property inventory

    Of course, consult with your CPA for the accounting requirements, and do examples all the necessary transactions in a test company to ensure the idea would work for your business processes.