We have the same scenario, but fwiw, you will want to add a where condition that checks reversed_date = 0 to exclude refunded transactions.
E.g.
SELECT FROM_UNIXTIME(completed_date,'%Y-%m-%d') as "ORDER DATE",business_title as "CUSTOMER",country_code as "COUNTRY",sales_tax_id as "TAX...