Split it out. Found that my refund rate on a clothes category, which accounted for the majority of the gap, was 11 percent.
Which means that the gateway wasn't the primary issue.
So you were right that the refunds were polluting the payment column.
My main concern about using the reconciliation report to price items and look for issues is it just confirms that there are things to be improved upon with it.