sawwiapp
Start free

Shopify reconciliation

Check that every paid Shopify order was settled by your gateway, every cash-on-delivery order was remitted by the courier, and every BNPL order was paid out, in full.

Start free

Connect Shopify, or upload the orders export

Read-only connector: Shopify

Sawwi's Shopify connector reads your orders through the Shopify Admin API with an access token from a custom app: status, gateway, totals and refunds, one row per order. It only reads.

The connector is new. The orders CSV from the Shopify admin works just as well, and so do refund exports for the refunds-vs-returns check.

5 Shopify reconciliations

Matching is done by Sawwi's own rules engine on keys, amounts and dates, never by AI, so the same files always give the same report.

Orders vs. payment gateway settlements

Match paid webstore orders to gateway settlements. Separate out MDR fees, refunds and chargebacks.

Files you need

  • Webstore order export: Orders exported from your store admin for the period.For example: Shopify orders CSV, Magento 1 order grid export, Magento 2 / Adobe Commerce order export, WooCommerce orders.
  • Gateway settlement report: Transaction-level settlement from your payment gateway.For example: Checkout.com settlement, Tap payouts, PayTabs transactions, Telr statement.

The Shopify connector can fill: Webstore order export. The Magento 2 / Adobe Commerce connector can fill: Webstore order export.

What Sawwi checks

  • Paid, not settled: The order is marked paid but there's no gateway capture for it.
  • Settled without an order: Gateway capture with no matching order in the webstore export.
  • Amount mismatch: Captured amount differs from the order total.
  • Chargebacks: Disputed transactions and their status.

Listed for you to review (not calculated automatically yet): refund mismatch; gateway fee above agreed rate.

COD delivered vs. courier remittance

Make sure every cash-on-delivery order the courier delivered was remitted to you, in full and on time.

Files you need

  • Webstore order export: Orders exported from your store admin for the period.For example: Shopify orders CSV, Magento 1 order grid export, Magento 2 / Adobe Commerce order export, WooCommerce orders.
  • Courier delivery status report: Shipment-level delivery status from your courier.For example: Aramex shipment report, SMSA delivery report, iMile status export.
  • COD remittance statement: What the courier paid you, with deductions.For example: Aramex COD remittance, SMSA COD statement.

The Shopify connector can fill: Webstore order export. The Magento 2 / Adobe Commerce connector can fill: Webstore order export.

What Sawwi checks

  • Delivered, not remitted: Courier shows delivered but no remittance after the agreed cycle.
  • Collected short: Courier collected less than the COD amount.
  • Status conflict: Order is RTO or cancelled in your store, but the courier marked it delivered.

Listed for you to review (not calculated automatically yet): cod fee above contract.

BNPL settlements vs. orders

Reconcile Tabby / Tamara-style settlements: orders captured, refunds, merchant fees and payout batches.

Files you need

  • Webstore order export: Orders exported from your store admin for the period.For example: Shopify orders CSV, Magento 1 order grid export, Magento 2 / Adobe Commerce order export, WooCommerce orders.
  • BNPL settlement report: Order-level settlement report from your BNPL provider.For example: Tabby settlement report, Tamara payout report.

The Shopify connector can fill: Webstore order export. The Magento 2 / Adobe Commerce connector can fill: Webstore order export.

What Sawwi checks

  • Shipped, not captured: Order was fulfilled but the BNPL capture is missing, so you won't be paid.
  • Refund mismatch: Refund in the store differs from the BNPL refund.

Listed for you to review (not calculated automatically yet): merchant fee above agreed rate.

Refunds issued vs. returns received

Make sure every refund you paid out has a returned item, or an approved reason to have none.

Files you need

  • Refunds issued: Refunds or credit memos from your store admin.For example: Shopify refunds export, Magento 1 / Magento 2 credit memos, WooCommerce refunds.
  • Returns received: Items physically received back in your warehouse.For example: WMS returns inward, Returns app export.

The Magento 2 / Adobe Commerce connector can fill: Refunds issued.

What Sawwi checks

  • Refund without a return: Refund paid but the item wasn't received back.
  • Return without a refund: Item received but no refund issued, so the customer may be waiting.
  • Quantity mismatch: Refunded quantity differs from the quantity received.

Bank statement vs. expected payouts

Match every payout you expect from marketplaces, gateways, BNPL providers and couriers to actual bank credits, including FX differences.

Files you need

  • Expected payouts: Payout batches from one or more providers (marketplace, gateway, BNPL, courier).For example: Marketplace disbursement summary, Gateway payouts list, Courier remittance summary.
  • Bank statement: Bank statement for the account that receives payouts.For example: Emirates NBD / ADCB / Al Rajhi / SNB statement (CSV or Excel), MT940 converted to CSV.

What Sawwi checks

  • Payout not credited: Provider says paid, but the bank shows no credit.
  • Unidentified bank credit: Bank credit not linked to any payout.
  • FX / bank charge difference: The amount differs because of currency conversion or bank charges.

How it works

  1. 1

    Pick the reconciliation

    Each one knows which files it needs and what to check.

  2. 2

    Add the files

    Upload exports as they are, or pull them from a connection. Columns are mapped for you and remembered.

  3. 3

    Work the exceptions

    Every exception with its value, ranked by what it costs you, and every table downloads to Excel.

Questions

Can I reconcile Shopify Payments payouts?
Yes, as a gateway report: download the payout transactions from Shopify and use them in the orders vs payment gateway reconciliation, then match payouts to your bank statement.
What about cash on delivery orders?
COD orders are reconciled against the courier's delivery status report and COD remittance statement, for example from Aramex or SMSA, so you can see delivered orders that were never remitted or were remitted short.
Do I need a Shopify app from the app store?
No. The connector uses an access token from a custom app you create in your Shopify admin with read access to orders. Or skip it and upload the orders CSV.

Related reconciliations

Bring last month's exports and see what's missing.

Setup takes two minutes. Or try the demo store with invented data first, no sign-up.

Create your workspace