How do I calculate Net Sales from an exported orders .csv file to match a Sales Report?

New Member
1 0 0

I am currently working on a project where it is necessary to duplicate the data from the Sales Report from the exported .csv from the Orders tab in the Shopify Web Client.

I have tried using the calculations found here:

They are not matching correctly.

I need to know which columns to use from the orders .csv to match Gross Sales, Discounts, and Returns in order to accomplish this.

I would appreciate any advice or tutorials on how to accomplish this.