cancel
Showing results for 
Search instead for 
Did you mean: 
Mavors19
Level 1

Manufacturing Accounting for Internal Orders/Jobs (Inventory, PPE)

I run a manufacturing company that buys raw materials and produces finished goods for sale.  Each order/sale is done by a job number.  How do I account for internal jobs/orders?  For example, I bought and used raw materials to manufacture a desk that is being used by my company and is being depreciated as a fixed asset as it's furniture.  Is there a better way to account for the desk other than making a manual inventory adjustment and general journal entries?  I cannot make a job order as that's under customers as I cannot sell to myself.  I cannot touch the P&L.  I can only impact the BS by reducing inventory and increasing fixed assets.  Additionally, I need to account for labor costs (manufacturing the desk), installation costs, etc. which needs additional journal entries to properly value the desk in fixed assets.  I'm hoping there is a way to create a job in Quickbooks that will let me track all the job costs related to producing the desk (including raw materials, labor costs, etc.).  Is there a way to do this? Or do I have to manually account for everything?  Thank you for your help on this matter.

Solved
Best answer January 08, 2019

Best Answers
Rustler
Level 15

Manufacturing Accounting for Internal Orders/Jobs (Inventory, PPE)


@Mavors19 wrote:

I run a manufacturing company that buys raw materials and produces finished goods for sale.  Each order/sale is done by a job number.  How do I account for internal jobs/orders?  For example, I bought and used raw materials to manufacture a desk that is being used by my company and is being depreciated as a fixed asset as it's furniture.  Is there a better way to account for the desk other than making a manual inventory adjustment and general journal entries? 

 

Never ever use inventory asset in a transaction, an adjustment, or a journal entry.  You will mess up the balance sheet inventory valuation vs actual value.

 

No an adjustment is the only way to do it.  And adjustment lowers the inventory items used and move those costs to the adjusting account, which in this scenario would be the fixed asset account. 

 

 

  Additionally, I need to account for labor costs (manufacturing the desk), installation costs, etc. which needs additional journal entries to properly value the desk in fixed assets. 

 

Labor costs are already accounted for in payroll expense, but if you want to then yes that has to be done with a journal entry.  Debit fixed asset and credit payroll expense

 

I'm hoping there is a way to create a job in Quickbooks that will let me track all the job costs related to producing the desk (including raw materials, labor costs, etc.).  Is there a way to do this? Or do I have to manually account for everything?  Thank you for your help on this matter.

 

You could use an estimate to track things, but do not copy the estimate to an invoice, when done just make the estimate inactive.  But other than that, no there is really no process for this in QB, there are some workarounds, but in truth they add more time and work to the problem.  It is just easier to use inventory adjust.  QB is accounting, with very very little work flow control.


 

View solution in original post

3 Comments 3
Rustler
Level 15

Manufacturing Accounting for Internal Orders/Jobs (Inventory, PPE)


@Mavors19 wrote:

I run a manufacturing company that buys raw materials and produces finished goods for sale.  Each order/sale is done by a job number.  How do I account for internal jobs/orders?  For example, I bought and used raw materials to manufacture a desk that is being used by my company and is being depreciated as a fixed asset as it's furniture.  Is there a better way to account for the desk other than making a manual inventory adjustment and general journal entries? 

 

Never ever use inventory asset in a transaction, an adjustment, or a journal entry.  You will mess up the balance sheet inventory valuation vs actual value.

 

No an adjustment is the only way to do it.  And adjustment lowers the inventory items used and move those costs to the adjusting account, which in this scenario would be the fixed asset account. 

 

 

  Additionally, I need to account for labor costs (manufacturing the desk), installation costs, etc. which needs additional journal entries to properly value the desk in fixed assets. 

 

Labor costs are already accounted for in payroll expense, but if you want to then yes that has to be done with a journal entry.  Debit fixed asset and credit payroll expense

 

I'm hoping there is a way to create a job in Quickbooks that will let me track all the job costs related to producing the desk (including raw materials, labor costs, etc.).  Is there a way to do this? Or do I have to manually account for everything?  Thank you for your help on this matter.

 

You could use an estimate to track things, but do not copy the estimate to an invoice, when done just make the estimate inactive.  But other than that, no there is really no process for this in QB, there are some workarounds, but in truth they add more time and work to the problem.  It is just easier to use inventory adjust.  QB is accounting, with very very little work flow control.


 

qbteachmt
Level 15

Manufacturing Accounting for Internal Orders/Jobs (Inventory, PPE)

I can help with this part: "I'm hoping there is a way to create a job in Quickbooks that will let me track all the job costs related to producing the desk (including raw materials, labor costs, etc.)"

 

Yes, make a Customer name for this, or perhaps Customer = House, and Job = this project. Now you Job Track everything you asked, such as the inventory adjustment screen, top part = job track the adjustments; Job Track payroll so that the Service Item is assigned, starting from Timesheets and setting the employees to be paid from time data. That makes the Payroll cost part of the Job Cost reporting.

 

You don't need to use Estimates for this. You would do that for comparison reporting. What you need is to Job Track it, for it to be available for any reporting at all.

Simon_MRPeasy
Level 3

Manufacturing Accounting for Internal Orders/Jobs (Inventory, PPE)

For manufacturing, there are really only external apps that can do this - manufacture item, consume parts, track labor costs, operations, etc. - , which connect with QuickBooks Online.

 

Moving the item from current assets, from inventory, to fixed assets is a manual adjustment in any case. This is a formal decision, that should be documented.

 

In the QuickBooks App Store, there are several manufacturing apps for manufacturing, e.g. like MRPeasy.

 

Need to get in touch?

Contact us