Do Shopify Payments reports/exports support card brand/type splits (Visa/MC/Amex/Discover) and itemized fee detail at a level suitable for separate GL postings? If Shopify provides only lump-sum fees, what’s Shopify’s best-practice pattern for merchants who must post/reconcile by card type and separately track fees, refunds, and chargebacks in their ERP?
We’re actually working on a payout reconciliation report. That should let you break down payment processing fees by card brand/volume in Analytics. Please share your shop url and I’ll include you in the early access.
Here it is: https://admin.shopify.com/store/q55840-0i
Do you have an ETA on general availability of this feature?
targeting end of q2, thanks will include you and email when we’re ready to test
@S.T In practice, Shopify gives you enough detail to post and reconcile separately for charges, refunds, fees, and chargebacks/disputes, but not usually as a native Visa vs Mastercard vs Amex vs Discover payout split in the standard payout/export view. The payout side is mainly organized by transaction category, while card-brand detail lives lower down on the payment transaction itself.
So the usual ERP pattern is to treat Shopify Payments as a clearing account, import the transaction-level data for gross/fee/net/refund/dispute activity, and if you need card-brand GL segmentation, derive that from the transaction payment details rather than from the payout summary alone.
In other words, Shopify is good for settlement reconciliation, but merchants that require brand-level accounting usually add an ERP connector, middleware layer, or custom API pull to combine payout transactions + order transaction card metadata into the final journal entries.