Why doesn't my Shopify payout match my sales?

Shopify payouts often don't match sales due to refunds, chargebacks, processing fees, or timing differences. Fincile automatically reconciles every order against your Stripe and PayPal payouts to find exactly where the discrepancy is.

How do I reconcile Shopify payouts with Stripe?

Fincile connects to your Shopify orders, Stripe payouts, and PayPal transactions and automatically matches every transaction line by line, flagging any mismatches, missing payments, or duplicate charges.

What causes Shopify payout discrepancies?

Common causes include missing payments, duplicate charges from retry logic, refund mismatches, processor fee errors, and settlement timing gaps. Fincile detects all of these automatically.

Shopify Klarna & Afterpay Reconciliation: Why Payouts Don't Match

Buy-now-pay-later providers like Klarna and Afterpay solve a real conversion problem for Shopify merchants — but they introduce a reconciliation problem most merchants aren't prepared for. Unlike a card charge or a PayPal payment, the store gets paid upfront in full, while the BNPL provider collects from the customer over several installments. That mismatch between "when the order shows as paid" and "when the money actually settles" is where most BNPL reconciliation errors hide.

Why Klarna and Afterpay payouts are hard to reconcile

Batched, delayed payouts: Both Klarna and Afterpay typically pay merchants on a rolling schedule (often 2–3 business days after the order, sometimes longer), bundling multiple orders into a single payout. One payout deposit can represent dozens of separate Shopify orders, each with its own fee deducted individually.
Merchant fees are higher and variable: BNPL merchant fees typically run higher than standard card processing (often in the 4–6% range depending on volume and plan), and the fee structure can change based on installment plan or promotional period — making a flat fee assumption in your reconciliation wrong.
Order cancellations after settlement: If a customer cancels or the order is fraudulent, the BNPL provider handles the customer-facing refund and repayment schedule directly — the deduction from your next payout can arrive weeks after the original order, disconnected from the original transaction date in your books.
Partial installment defaults: If a customer misses installment payments to Klarna or Afterpay, that's the provider's credit risk, not yours — you were already paid in full. But some merchants mistakenly try to reconcile installment-level detail against their own books, when only the original lump-sum payout matters.

How to reconcile BNPL payouts correctly

Export the BNPL provider's settlement report, not just the payout total

Klarna and Afterpay both provide a merchant portal report breaking each payout down into individual order-level line items. The single deposit amount in your bank account isn't enough to reconcile against — you need the per-order breakdown.

Match each Shopify order to its line item

Use the order reference or Klarna/Afterpay transaction ID (both pass this back to Shopify at checkout) to match each order to its corresponding line in the settlement report.

Verify the fee deducted matches your agreed rate

Compare the net amount received per order against gross order value minus your contracted merchant fee. Rate discrepancies are common when merchants are moved between pricing tiers without notice.

Track cancellation deductions separately

When a BNPL order is cancelled or refunded, the deduction shows up in a later payout, not the original one. Keep a running log linking these deductions back to the original order so your books stay accurate across payout periods.

Why BNPL reconciliation gets skipped

BNPL usually represents a smaller share of total order volume than cards or PayPal, so it's the reconciliation work merchants deprioritize first — understandably, but it's also the gateway with the least transparent payout structure of the three, which makes it the one most likely to be hiding real fee or cancellation discrepancies.

Treating Klarna, Afterpay, and every other gateway the same way — order matched automatically to its actual settlement, with any variance flagged — closes that gap without adding a separate manual process just for BNPL.

Built for this problem

Fincile reconciles Klarna and Afterpay too

Fincile reconciles Shopify orders across Klarna, Afterpay, Stripe, PayPal, and Shopify Payments — one audit, every gateway, exceptions flagged automatically.

Try Free — Up to 100 Orders →Learn more

No credit card required · Read-only access · Results in minutes