LinkyFlow — autonomous agents and live business data in Excel or on the webLinkyFlow
Runs of the Shopify + Stripe reconciliation agent in the LinkyFlow web app, sales processed and reconciled each hour (demo data)

Reconcile Shopify with Stripe, transaction by transaction, read-only

Connect Shopify and Stripe to LinkyFlow and add the Shopify + Stripe Reconciliation agent. Once an hour it takes every Shopify transaction paid through Stripe, finds the Stripe payment by an identifier, checks its amount, currency and status, records the fee Stripe actually took and the net, and opens a case for each sale that does not reconcile. It is read-only: it never refunds, captures or edits anything at Shopify or Stripe.

One condition comes first: your sales must go through the Stripe payment app for Shopify. Shopify Payments runs on Stripe but is paid out by Shopify, into no Stripe account you can connect, so the agent counts those transactions and skips them — as it does PayPal or a manual payment.

The example below is an illustrative data set, not a run on a real store. The screenshots show the LinkyFlow web app on demo data.

Why transactions, not order totals

One Shopify order can carry an authorization and a later capture, two partial payments, or a sale and a refund. Its total says nothing about which of them reached Stripe, which is why lining up order totals against a Stripe export looks right and is not. The agent reconciles each transaction that moved money — a sale, a capture, a refund — and leaves out authorizations, voids and test transactions.

1. Check which gateway your sales use

In LinkyFlow, load Shopify's Order table with the Gateway filter set to stripe. Orders come back: they are this agent's. Nothing comes back: your sales go through another gateway, and this agent will report them as skipped, with the gateway's name.

2. Connect both accounts

You can add the agent before connecting either one: it waits, and starts within the hour once both connections are there. A connection that exists but cannot be used — switched off, never verified, its key revoked — is named as such, with the fix.

3. Add the agent

In the web app: Agents, Add agent, Shopify + Stripe Reconciliation. Pick the Shopify and Stripe connections, name the agent, add it. Then Run now on its page, or wait for the hour.

The first run reads as far back as Shopify lets your connection read, catching up over several runs on a large store. That is 60 days of orders unless your store has given LinkyFlow access to all its orders: asked at install, and asked of a store installed earlier on its next visit to the app. The agent records how far back it could see rather than implying the rest reconciled. After that, an hourly run only looks at the Shopify sales created or changed since the last run, the new Stripe records and the cases due another look — so an order from January refunded this morning is found, because it changed.

Runs of a reconciliation agent in the LinkyFlow web app: a first backfill run, then one incremental run per hour with the sales processed and reconciled (demo data)

The agent runs on a paid plan: Starter runs one active agent, with a 15-day free trial.

4. Read the verdicts

Here is what a run concludes on our illustrative data set, in euros:

OrderWhat Shopify recordedWhat Stripe holdsVerdict
#1041€149.90 sale through stripe, the Stripe payment's id on the transactionthat payment, succeeded, €149.90; fee €3.72, net €146.18RECONCILED, fee and net recorded
#1042€89.00 salethe payment exists, not settled yetPENDING, checked again next run
#1043€129.90 sale, a Stripe id on the transactionno payment with that id on the connected accountNOT_FOUND
#1044€149.90 salethe payment is for €144.90AMOUNT_MISMATCH, difference €5.00
#1045€59.00 sale, then a €59.00 refund; order refundedthe refund of that payment, settled, €59.00sale and refund both reconciled
#1046€75.00 sale, order still paidStripe refunded €75.00REFUND_MISMATCH
#1047€42.00 sale, no Stripe id, no order referencetwo €42.00 payments within two hoursNEEDS_INVESTIGATION: candidates, never a match
#1048paid with Shopify Payments—counted and skipped

What each verdict means for you:

  • RECONCILED needs proof: the Stripe identifier Shopify recorded on the transaction, or a reference in the Stripe payment naming the order. A payment of the right amount at the right time is only a candidate — #1047 stays open however likely one of the two looks.
  • NOT_FOUND is often a payment on another Stripe account, or a live payment looked up with a test key. A payment captured later closes the case by itself.
  • REFUND_MISMATCH means Stripe gave the money back while the store still shows the order as paid. Record the refund in Shopify and the next run closes the case.
  • CURRENCY_MISMATCH and PAYMENT_FAILED complete the list: a payment in another currency, which cannot be compared, and a payment that did not go through. A sale Shopify declined is never reconciled, even if a Stripe charge for it succeeded.

Money is handled as exact decimals, never rounded on the way, and totals are kept per currency. Fees are summed in the currency Stripe settled them in, which is not always the charge's.

5. Where you read it, and work the cases

On the agent's page, Results has four views (WHAT):

  • Current reconciliations: where every sale stands — Shopify order, expected and actual amount, currency, gross, Stripe fee, net, status and match rule. Add a field brings the Stripe payment, charge and balance transaction IDs.
  • Open exceptions: the cases that need you. A case is one problem with a count, not one alert per hour; it closes by itself when a later run finds what was missing.
  • Runs: one row per run, with what it read, what it concluded and what it paid in Stripe fees.
  • Historical run detail: the rows of one run, exactly as that run concluded them, however often you refresh. Kept 30 days.

Export turns any view into an Excel workbook that refreshes to today's numbers. An unresolved case is rechecked every hour for two days, every six hours until it is a week old, then once a day; once a day the agent also re-reads the last week in case a provider reported something late.

With LinkyFlow connected to ChatGPT or Claude, ask: "Why did Shopify order #1044 not reconcile?" or "How much did I pay in Stripe fees?". A model is used only to annotate the ambiguous cases (NEEDS_INVESTIGATION); it never turns a case into a reconciled sale, and a run over clean sales calls no model at all.

6. From a Stripe payout to its orders

Payouts are not this agent's job, but the Stripe connection reads them. In the Query panel, FROM your Stripe account, WHAT Payout Reconciliation, pick the Payout, Load: one row per charge, refund and fee in that payout, with Gross, Fee and Net. Stripe's own tables give amounts in the currency's smallest unit — 14990 is €149.90 — as in this charges table, whose descriptions name the orders:

Stripe charges loaded in the LinkyFlow web app: each description names a Shopify order, amounts in cents, status succeeded, pending or failed (demo data)

In Excel, put the payout's rows next to Current reconciliations and look up each row's ID in the Stripe balance transaction ID column: each charge the agent reconciled finds its Shopify order, and a charge that finds none is one the agent never paired.

What it does not do

  • Stripe only. Shopify Payments, PayPal and manual payments are counted and skipped.
  • Hourly, not real time. There is no webhook: a sale made at 10:05 is reconciled during the 11:00 run, or when you click Run now.
  • Read-only. It never refunds, captures, edits an order or changes anything at Shopify or Stripe.
  • No bank reconciliation. Payouts against your bank account are not part of this agent.
  • Detailed run data is kept 30 days. Run summaries and the current reconciliations stay.

FAQ

Does the agent change anything in Shopify or Stripe? No. It holds no write access to either: it reads, reconciles and reports.

My store uses Shopify Payments. Can I reconcile it? Not with this agent: those payments are paid out by Shopify, not into a Stripe account. The Shopify Finance Sync agent keeps a read-only copy of the store's orders, transactions, refunds and Shopify Payments payouts, with gross, tax, fee and net apart.

How is a sale paired with a payment? By the Stripe identifier on the Shopify transaction, or by a Stripe payment that names the order. Never by amount and date alone.

What does it cost in AI? An ordinary run calls no model. Only an ambiguous case is investigated, and the same case is not investigated twice unless its evidence changes.

Go further