Identify Activity as Cost of Goods Sold (COGS)

There is a client-level option within Martus that makes use of the account 'subtype.'

When that option is turned on by Martus Support, activity for accounts designated with the 'CostOfGoods' (COGS) subtype is summarized separately on Martus financial and budget reports.

Contact Martus Support if you would like to have this feature activated.

Reporting on Cost of Goods Within Martus

Activity for COGS accounts is segregated and summarized on Martus reports, as illustrated with this example from the Income Statement.

Note that the Gross Profit line and the Gross Profit Percent is not calculated if you filter the report in a way that includes no Cost of Goods lines

Sage Intacct Integrations 

The 'Chart of Accounts' sync sets the subtype to 'CostOfGoods' if the account category in Intacct starts with "Cost of ..." and ends with 'Sold' or 'Revenue', or if the category is 'Manpower Costs'.

QuickBooks Integrations

The account sync sets the subtype to 'CostOfGoods' if the account type within QuickBooks is 'Cost of Goods'.

For Financial Edge NXT integrations

The Chart of Accounts sync does not set the account subtype in any way.

Manually Change Accounts in Martus to 'Cost of Goods' 

If there are some other accounts that you’d like to see treated as 'Cost of Goods' on Martus reports, an Admin user can use Setup > Accounts to manually set the account Subtype to 'CostofGoods', then lock the account Type. 

The account Type must be locked to prevent the next sync from updating the Subtype to mirror the accounting system.

Clients with File-Based Integrations can manually set the Subtype to' CostOfGoods'.