Thanks for those details, @vssc
I do apologize for all the trouble you’re having with our support and this issue at hand.
I’m afraid that at this time, some gateways that integrate with Shopify (such as Razorpay) do not currently offer support for refunds in our admin. This means that despite refunding an order within the gateway, the analytics (and orders) within your admin will not reflect the refund.
I completely understand that this is not ideal, and our developers are aware of this as well.
I will continue to advocate for all gateways to provide support for refunds. For now, the best workaround I can offer is to export your orders, and manually adjust totals for cancelled orders within a spreadsheet. Of course, you can utilize another gateway that supports refunds inside of the admin.
If you have any other gateways in mind, I can confirm for you whether or not they support refunds.