Skip to main content
Solved

COGS Breakdown Report

  • March 10, 2023
  • 1 reply
  • 260 views

Hi,

 

Do we have a standard or customized report do generate from Acumatica, where we can see the breakdown of the Cost of Goods sold (COGS)?

 

This report needs to have the direct costs (PO cost) and the indirect costs (Freight, Customer duty, SST, Demurrage, etc) separately?

Example : 

 

Or else, is there a way to record the indirect costs (From landed costs) to a separate GL account without including it in the Inventory account?

 

Thanks in advance

 

Best answer by umeshramaswamy82

Hi @Firazfaisal164 ,

 

You can explore following options:

  1. If are using non stock items for indirect costs (Freight, Customer duty, SST, Demurrage) on a PO then you can drive those costs as expenses to separate G/L accounts defined on those non stock items.
  2. Or you can define separate Landed Cost codes for each of those indirect costs and define a landed cost account separately for each of them. You can use the same Landed cost G/L account but use different Subaccounts too, as shown below -
  3. You may have to create a GI to get to details of COGS expenses/costs breakdown.

 

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img

Hi @Firazfaisal164 ,

 

You can explore following options:

  1. If are using non stock items for indirect costs (Freight, Customer duty, SST, Demurrage) on a PO then you can drive those costs as expenses to separate G/L accounts defined on those non stock items.
  2. Or you can define separate Landed Cost codes for each of those indirect costs and define a landed cost account separately for each of them. You can use the same Landed cost G/L account but use different Subaccounts too, as shown below -
  3. You may have to create a GI to get to details of COGS expenses/costs breakdown.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings