How to do Costing in ERPNext of inderect Expenses

ERPNext
1

Hello Everyone,

I am implementing an ERP solution for Signage manufacturing company. I am not an accountant and having some doubts regarding the requirement, hope this community can help out.

For the manufacturing process of a sign board, we wont be using BOMs as each time different type and quantity of raw materials will be used so we will be creating stock entries manually.

Now they want to include all the costs related to the sign board (direct or indirect) with that item manufactured.

I have two ways to do it:

  • Either I include as additional costs in stock entry.
  • or Pass journal entries and purchase invoices and combine everything under one project.

Both the methods I tried I am facing some issues

But the main issue is how to charge the indirect expenses to the product:

suppose they are charged 1000 rs for electricity and allocated 200 rs to this particular item, if I write it in additional cost then it comes as credit amount under an expense account. I know the amount will be reflected in the cost of goods sold once DN is created but still one more entry or something else is missing as accounting wise it doesnt seem correct.

What I want to achieve is that they could write the expense during stock entry if it is known and later via journal entries if occured at a later stage and every record will be having the project mentioned.

So in Profit and Loss and other reports when I apply the filter it should get the correct income and expense.

Currently in P&L, it shows the credit amount also so the expense gets deducted as total.

2

Hi @moizsami,

yes, accounting could be quite a challenge at times. Well, allocation of indirect manufacturing cost is always a struggle. You need to come up with an approach that reflects what could be true, never knowing if it is true.

Therefore, make it easy for yourself. From my point of view, you could open a project for every item produced. The project will get all direct expenses as well as hourly rates from the people working on the project.

Now, to get the indirect expenses into the project, you could post the actual total expenses to the projects as soon as you receive the invoice. In this scenario, you need to split the purchase invoice item into as many pieces as you had projects in the related period. I assume this shouldn’t be rocket science to get it done.

Any other approach might be more complicated. Remember, you will never know exactly what the indirect expense percentage is per project or item manufactured. Though, there is always a bit of guess work in there. Most importantly, with the approach outlined above, you get a sense of the Gross Margin the manufactured products are generating. That’s all you need.

In case the number of projects would get too big, it might only be possible to allocate the indirect expenses in a Profit Center Report of the overall business later. There, you might allocate these expenses according to their revenue percentage.

From my experience, it is not worth driving yourself crazy about this allocation. In the past, I had been with businesses which had $1 million+ in annual indirect manufacturing expenses. The business just needs to know, that it is earning money.

Though, the above two approaches are relative simple and easily implemented.

All the Best!
[a former Finance & Accounting Manager]