StoreCheck Reconcile

Payment reconciliation · iyzico

How to reconcile Shopify payouts with iyzico

Export the iyzico Transactions report as CSV from your merchant panel, then match it against Shopify orders by order reference, amount, currency and date. Rows where collection − commission − fixed fee ≠ merchant payout are genuine discrepancies. StoreCheck Reconcile checks this equation automatically for every row.

Which report do you need?

In the iyzico merchant panel, open Transactions (or Reports → Transaction Report), pick a date range and export the CSV. Each row carries paymentId, paymentTxId, conversationId, amounts, commission and the net merchantPayoutAmount.

On the Shopify side, the order name (#1001) and order total are enough — the app pulls orders read-only via the API, no manual export needed.

How are matches made?

The strongest key is the order reference: iyzico's conversationId or basketId usually carries the Shopify order number (integration-dependent). When references don't line up, matching falls back to amount + currency + a date window — if several orders share the amount, the result is flagged ambiguous rather than guessed.

Which differences are real money leaks?

  • Fee equation fails: collection − commission − fixed fee ≠ payout. Traceable per row; mismatching rows should be queried with the provider.
  • Zero payout: a collection exists but merchant payout is 0 — block, refund or manual hold.
  • Reverse direction: a Shopify order pending payment with no iyzico row at all — failed/abandoned checkout.
  • FX conversion: iyziConversionRateAmount on foreign-currency collections — often explains order-total vs. collection gaps.

FAQ

How often should I export the report?

Monthly is enough for month-end close; high-volume stores should run weekly so differences are caught before they pile up.

Why are refunds and cancels separate rows?

iyzico writes refund/cancel as distinct transaction types under the same paymentId; reconciliation groups them into one payment and shows the net effect.

Skip the manual matching: StoreCheck Reconcile parses your report in the browser and matches every row to order evidence. Start free · All guides

More guides: iyzico commission rates and reading the settlement reportCash-on-delivery reconciliation — matching carrier collections to ordersReconciling Shopify with the PayTR transaction report