How to build a daily ecommerce margin report that catches bad data

A daily ecommerce margin report can be more dangerous than no report if the data is wrong. I have seen teams celebrate a strong sales day while refunds, marketplace fees, shipping adjustments, and ad spend were sitting in separate tabs. The dashboard looked clean, but the real margin was already leaking. I build the report around orders, not just products. Each order should carry channel, order…