Tracking profitability metrics

Hey everyone,

I'm curious how you track profitability metrics like net margin and revenue. Currently I'm using a fairly cumbersome spreadsheet that takes my ad spend and other variable costs to see which products perform well from a net margin perspective. This includes pulling in shopify and supplier orders constantly. How are you all tracking your metrics?