Revenue discrepancy between Shopify Admin Dashboard and API results — how to ensure accurate totals

What API are you using to fetch revenue/ return data?

The most accurate approach may be to use ShopifyQL: https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/shopifyql-editor#shopifyql-syntax