ERPNext Insight – Service Items & Gross Profit Reporting
I’ve always noticed a gap in ERPNext’s Gross Profit reports when it comes to service items:
-
Currently, if we use a service item ID for purchase and sales, the valuation rate is picked from the last purchase rate, which skews the gross profit calculation.
-
This approach is incorrect, because service items should either:
Show 100% margin by default, or
Have a proper expense entry system tied to invoicing to reflect accurate gross profit.
Lemme know if there is a possible workaround for this.
Hi @TalhaButt2508
Service items do not go under valuation process and contribute nothing as far as COGS is concern.
This is not versioning issue as service item handling remain same conceptually over the years for all versions including V16 serving accounting purposes effectivley.
The table may help you get better idea of how service item being handled in ERPNext.
| Factor |
Service Item (Is Stock Item = No) |
Impact on COGS |
Explanation |
| Is Stock Item |
No |
No COGS generated |
COGS requires stock movement |
| Stock Ledger Entry |
Not created |
No |
No quantity reduction means no valuation impact |
| Valuation Rate |
Not applicable |
No |
COGS depends on valuation rate |
| Stock Asset Account |
Not used |
No |
Nothing to credit from inventory |
| Delivery Note |
Optional |
No |
Even if delivered, no stock movement |
| Sales Invoice Update Stock |
Not applicable |
No |
Update stock works only for stock items |
| Perpetual Inventory |
Irrelevant |
No |
Works only with stock items |
| Purchase Cost |
Expensed directly |
Indirect |
Cost hits expense account at purchase time |
| Gross Profit Report |
Revenue only |
Margin looks 100% |
Because no COGS is deducted |
| Project Costing |
Can track separately |
Yes, indirectly |
Costs captured via Timesheets or Expenses |
