Build or Buy Payout Reconciliation Across Gateways on Shopify?
Payout reconciliation across payment gateways is a BUY for Shopify merchants running PayPal or a BNPL provider beside Shopify Payments. A2X runs $29–$115/month and Synder $65–$599/month (verified Sep 2026), and both post each gateway's payouts, fees and refunds into QuickBooks or Xero. Shopify's native payout reconciliation report covers Shopify Payments only and excludes third-party processors. Build only when your ledger is an ERP without a gateway-level connector.
Your profile — see how the verdict shifts
- Confidence
- High — Read Shopify's payout reconciliation report help page: the report breaks down Shopify Payments balance activity (transactions, fees, refunds, chargebacks, adjustments, payouts) and states it doesn't include third-party payment processors or third-party payment methods such as Authorize.net or Afterpay (verified Sep 2026). Checked three live App Store listings with published tiers and a stated payout-reconciliation feature: A2X (5.0★, 342 reviews), Synder (4.8★, 207 reviews) and Webgility x QuickBooks Desktop (4.9★, 503 reviews). The older 'QuickBooks Sync: Webgility Lite' listing is no longer available. Gateway-by-gateway coverage inside each app was not tested; confirm your BNPL provider on the current listing.
- Reference scenario
- $20M–$100M revenue · Shopify Payments plus PayPal plus one BNPL provider · QuickBooks Online or Xero ledger · a controller closing monthly · agency dev bench
- As of
- September 2026
Decision at a Glance
| Your profile | Verdict | Why |
|---|---|---|
| Shopify Payments only | WAIT | Shopify's native payout reconciliation report already breaks every Shopify Payments payout into transactions, fees, refunds, chargebacks and adjustments (verified Sep 2026). There is nothing to buy until a second gateway starts paying into the bank. |
| Shopify Payments + PayPal, QuickBooks or Xero ledger | BUY | The reference scenario. A2X at $29–$115/month or Synder at $65–$599/month (verified Sep 2026) posts each gateway's payouts and fees as summaries that tie to the bank feed, and the controller stops rebuilding PayPal deposits by hand. |
| Three or more gateways including BNPL, multi-currency | BUY | Same lane, higher tier. Confirm your BNPL provider and every settlement currency are on the app's supported list during the trial, because each gateway the app skips stays a manual match at month-end. |
| ERP ledger (NetSuite or similar) or an unsupported gateway | CUSTOMIZE | The QuickBooks and Xero apps end at the ledger boundary. Keep the ERP connector for orders and build the settlement match for the gateways it skips, $25,000–$60,000 (Deploi estimate, illustrative). |
What Payout reconciliation across payment gateways Actually Drives
| Outcome | Impact | How it works |
|---|---|---|
| Operational efficiency | High | A controller who rebuilds PayPal and BNPL deposits by hand loses days of each close to it; a sync app posts each payout as a summary that ties to the bank line the same day. |
| Data & insight | Medium | Fees, refunds and chargebacks by gateway become ledger lines instead of one blended merchant-fees number, so finance sees which provider's rate moved and when. |
| Revenue — indirect | Low | Reconciliation changes nothing about what customers buy; the upside is catching unreturned chargeback fees and settlement errors that quietly leak margin. |
| Customer experience | Low | Customers never see reconciliation; the only touchpoint is a faster, correct refund when the ledger and the gateway agree on the original charge. |
Spend ceiling: Spend against controller hours. A close that burns 3 days a month on gateway deposits is roughly $10,000–$20,000 a year of finance time (illustrative). A2X at $29–$115/month or Synder at $65–$599/month (verified Sep 2026) is a rounding error against that, and a $25,000–$60,000 build (Deploi estimate, illustrative) clears the bar only when an ERP blocks the app lane.
What buying enables (top apps)
- + Each gateway's payouts, fees, taxes and refunds posted as summaries that reconcile to the bank deposit, in QuickBooks Online, Xero or QuickBooks Desktop
- + Multi-channel and multi-currency coverage across 30+ sales channels on Synder's listing (verified Sep 2026)
- + Vendor-maintained gateway feeds: when PayPal or a BNPL provider changes a settlement format, the app absorbs it
- + A 15–30 day trial long enough to close one month in parallel before committing
What building additionally unlocks
- + Posting into an ERP chart of accounts or multi-entity structure the QuickBooks and Xero apps cannot reach
- + Settlement lines kept as rows you own, so fee-rate drift by gateway and by month is a query, not a support ticket
- + A match for a gateway no vendor supports, on the same exception queue as the rest
Find Your Verdict in 3 Questions
Is Shopify Payments the only gateway paying into your bank account?
Yes: Your verdict: WAIT — Shopify's native payout reconciliation report already breaks every Shopify Payments payout into transactions, fees, refunds and chargebacks (verified Sep 2026).
No: Go to question 2.
Is your ledger QuickBooks Online, QuickBooks Desktop or Xero?
Yes: Your verdict: BUY — A2X ($29–$115/month) or Synder ($65–$599/month) for QuickBooks Online and Xero, Webgility x QuickBooks Desktop ($139–$749/month) for Desktop (verified Sep 2026).
No: Go to question 3.
Does your ERP's Shopify connector post gateway payouts, fees and refunds, not just orders?
Yes: Your verdict: WAIT — the connector is doing the job; keep a manual match only for any gateway it skips.
No: Your verdict: CUSTOMIZE — keep the connector for orders and build the settlement match for the gateways it skips, $25,000–$60,000 (Deploi estimate, illustrative).
The TCC Scorecard — 12 Dimensions
TCC — Total Cost of Capability: what it actually costs to have this capability over three years, whichever way you get it. Each dimension is scored 0–5 for both paths. How we score →
| Dimension | Buy | Build | Why |
|---|---|---|---|
| Cost | |||
| Acquisition & implementation | An app connects a gateway and a ledger in an afternoon and the accountant maps accounts in a day; a multi-gateway settlement engine is an 8–14 week build (Deploi estimate, illustrative). | ||
| Recurring fees | A2X runs $29–$115/month, Synder $65–$599/month and Webgility $139–$749/month by order volume (verified Sep 2026); the build's recurring line is upkeep plus whoever watches the exception queue. | ||
| Maintenance & upgrades | Vendors absorb every gateway's settlement-format change; a build owns three or more settlement feeds, and PayPal or a BNPL provider changing a report column breaks your match, not theirs. | ||
| Switching & exit | Posted journals stay in QuickBooks or Xero when you leave an app; only the mappings and the unposted queue go. A build's match tables are yours, but each gateway feed is a bespoke integration to re-home. | ||
| Risk | |||
| Vendor risk | Three listings with 207–503 reviews each and multi-year track records; the Webgility Lite listing is already gone, a reminder that product lines get consolidated even at healthy vendors. | ||
| Security & compliance surface | The app holds read access to every gateway and write access to the ledger; a build keeps settlement data in your own warehouse, but you own credential rotation for three gateways. | ||
| Platform-deprecation exposure | Vendors track the Shopify Payments payout data, PayPal reporting and each BNPL settlement format; a build inherits every version bump on every side of the match. | ||
| Value | |||
| Fit to requirement | Apps fit a QuickBooks or Xero close and reconcile to the bank deposit by design; a build fits an ERP chart of accounts, a multi-entity structure or a gateway no vendor supports. | ||
| Time to market | This week versus a quarter; the first month-end after install is usually the one the controller closes without the deposit spreadsheet. | ||
| Performance & scale | Webgility tiers by order volume from 500 to 5,000 orders a month (verified Sep 2026), so scale is a tier change; a build scales with your warehouse, not with a price list. | ||
| Data ownership & AI-readiness | Apps post summaries; a build keeps every settlement line, fee and FX delta as rows you can query for fee-rate drift by gateway, which no summary journal exposes. | ||
| Focus & opportunity cost | A reconciliation engine is finance plumbing with no customer-facing upside; at $29–$115/month (verified Sep 2026) the app wins the dev bench's quarter back. | ||
The App Landscape
| App | Status | Pricing | Best for |
|---|---|---|---|
| Shopify payout reconciliation report | Native — First-party report: a detailed breakdown of your Shopify Payments balance activity, including transactions, fees, refunds, chargebacks, adjustments and payouts. Shopify's own docs state the report doesn't include Shopify billing fees, third-party payment processors, or third-party payment methods such as Authorize.net or Afterpay. PayPal and BNPL deposits get no native reconciliation. | Included with Shopify Payments | The Shopify Payments share of each day's deposit, already done |
| A2X Sync for QuickBooks & Xero | Live — 5.0★, 342 reviews; 30-day free trial. A general accounting sync that posts sales, fees and COGS to QuickBooks or Xero; it allocates nothing, so the COGS it posts is only as true as the cost-per-item you feed it. | Mini $29/month; Basic $45/month; Professional $79/month; Advanced $115/month (verified Sep 2026) | A QuickBooks Online or Xero close that ties each payout to one summary journal |
| Synder for QuickBooks & Xero | Live — 4.8★, 207 reviews; 15-day free trial. Despite the name, the listing syncs Shopify sales data to NetSuite and Sage Intacct as well as Xero and QuickBooks, with multi-currency support; the practical route into Sage Intacct, which has no listing of its own | Basic $65/mo · Essential $129/mo · Pro $299/mo · Pro Max $599/mo, 20% off billed yearly (verified Sep 2026) | Multi-channel, multi-currency stores on QuickBooks Online or Xero |
| Webgility x QuickBooks Desktop | Live — 4.9★, 503 reviews; Built for Shopify. Matches Shopify payouts to QuickBooks automatically and syncs orders, inventory, payouts, fees, taxes and reconciliation; 15-day free trial. The older 'QuickBooks Sync: Webgility Lite' listing is no longer available on the App Store; this is the live product. | Plus $139 (500 orders/month) / Advanced $249 (1,000) / Premium $499 (3,000) / Complete $749 (5,000 orders/month) (verified Sep 2026) | QuickBooks Desktop shops that want orders and inventory synced alongside payouts |
The Build Path
- Settlement-line normalization: Pull Shopify Payments payouts and balance transactions from the Admin API, PayPal settlement reports and each BNPL provider's settlement file into one table with a common schema: gross, fee, refund, chargeback, FX delta, payout date and bank reference.
- Bank-feed match and exception queue: Match each payout to the bank line by amount, date window and reference. Anything unmatched lands in a queue with the candidate orders attached, so the controller resolves exceptions instead of rebuilding deposits.
- Ledger posting: Post one summary journal per payout to the ERP with fees, refunds and FX on their own accounts, keyed to the payout ID so a reversal is traceable months later.
- Optional: fee-rate monitoring: Because every settlement line is a row you own, a monthly fee-rate-by-gateway report falls out for free. That report is how merchants catch a BNPL rate change nobody announced.
- Effort band
- $25,000–$60,000 build — Deploi estimate (illustrative); lands in the $25–75K contact-form band. Each additional gateway or settlement currency adds a feed
- Typical timeline
- 8–14 weeks (Deploi estimate, illustrative); the first month-end close on the new engine is the acceptance test
- Maintenance, honestly
- ~15–20% of build cost per year (Deploi estimate): roughly $4,000–$12,000/yr (Deploi estimate, illustrative) for gateway report-format changes, API version bumps and new gateways. There is no subscription line.
- What you own — and what you take on
- You own: every settlement line, the match rules, the exception queue and the fee history by gateway. You take on: three or more gateway integrations that each change on their own schedule, and the credentials for all of them.
3-Year Total Cost of Capability
| Buy (app path) | Build (custom path) | |
|---|---|---|
| Year 0 (setup) | $500–$2,000 (mapping and trial) | $25,000–$60,000 |
| Years 1–3 (recurring) | $2,800–$4,700 | $12,000–$36,000 (maintenance) |
| 3-year total | ≈$3,300–$6,700 | ≈$37,000–$96,000 |
- † All figures illustrative samples for the reference scenario — not quotes, not verified pricing.
- † Buy path: an A2X or Synder mid-tier at $79–$129/month held flat across three years, plus a day of accountant mapping at setup; Webgility's order-volume tiers would price higher.
- † Build path: three gateway feeds, bank match, exception queue and ERP posting; three-year horizon with upkeep at 15–20% of build cost.
What the Sticker Price Hides
On the buy path
- — Order-volume tiers: Webgility steps from 500 to 5,000 orders a month across $139–$749 (verified Sep 2026); one peak-season month can push you up a tier
- — A gateway the app does not support stays a manual match; check the supported list for your BNPL provider during the trial, not after
- — Summary-level posting hides fee-rate drift by gateway; you see the total fee, not that one provider's rate moved
- — Re-mapping after a chart-of-accounts change is where duplicate entries come from (app-store 1–2★ review theme)
On the build path
- — Each gateway's settlement report is its own integration with its own format changes; three feeds means three things that break independently
- — The bank-feed match needs a date window and a tolerance per gateway, and tuning them is finance work, not dev work
- — Multi-currency adds an FX delta on every payout that has to land on its own ledger account
- — ~$4,000–$12,000/yr upkeep (Deploi estimate, illustrative)
What Merchants Say
Finance leads describe the same month: the Shopify Payments payout ties out in minutes from the native report, and the PayPal and BNPL deposits eat the rest of the close because nothing breaks them into orders, fees and refunds.
The recurring accounting-sync complaint is duplicate or mis-mapped entries after a settings or plan change, which then take longer to unwind in the ledger than the manual match ever did.
If You Change Your Mind Later
If you bought and outgrow it
Every journal the app posted stays in QuickBooks or Xero; what leaves is the mapping, the unposted queue and the vendor's record of how each payout was split. Export the settlement summaries before you cancel, and expect a month of parallel running if you move to another sync app.
If you built and want out
The settlement tables, match rules and fee history sit in your own warehouse, so nothing strands. The gateway feeds are the liability: each one is code someone has to keep alive, and retreating to an app later means re-mapping three years of history into the vendor's summary format.
When This Answer Changes
We're watching for:
- ▸ Shopify extending the payout reconciliation report beyond Shopify Payments (third-party processors excluded as of September 2026, per Shopify's help page)
- ▸ Your ledger moving from QuickBooks or Xero to an ERP, where the sync-app lane ends and the ERP connector's gateway coverage decides the residual build
- ▸ A new BNPL provider or settlement currency going live that your app's supported-gateway list does not cover
Verdict change log:
No changes since first publication (September 2026).
Common Questions
Does Shopify reconcile PayPal or BNPL payouts natively?
No. Shopify's payout reconciliation report covers Shopify Payments only: transactions, fees, refunds, chargebacks, adjustments and payouts for that one balance. Shopify's own documentation states the report doesn't include third-party payment processors or third-party payment methods such as Authorize.net or Afterpay (verified Sep 2026). A merchant on Shopify Payments plus PayPal plus 1 BNPL provider gets native help with one deposit in three; the other two need an app or a manual match.
Which app reconciles Shopify Payments, PayPal and BNPL payouts to QuickBooks or Xero?
A2X and Synder are the two purpose-built listings for QuickBooks Online and Xero. A2X runs $29–$115/month across four tiers with a 30-day trial and 5.0★ on 342 reviews; Synder runs $65–$599/month with a 15-day trial and 4.8★ on 207 reviews (verified Sep 2026). Webgility x QuickBooks Desktop, at $139–$749/month by order volume, is the QuickBooks Desktop lane. Confirm your BNPL provider is on the app's supported list before the trial ends.
When is building payout reconciliation worth it?
Building payout reconciliation is worth it in one case: your ledger is an ERP with no gateway-level connector, or one gateway has no app support at all. The build normalizes every gateway's settlement lines, matches them to the bank feed and posts one journal per payout, at $25,000–$60,000 (Deploi estimate, illustrative) plus 15–20% a year in upkeep. Against A2X at $29–$115/month (verified Sep 2026), a QuickBooks or Xero shop never recovers that spend.
Your Next Steps
If you're going with BUY(matches your selected profile)
- List every gateway paying into the bank: Shopify Payments, PayPal, each BNPL provider, and every currency they settle in
- Trial A2X or Synder against last month's deposits and confirm every gateway on that list is supported
- Have the controller map fee, refund and chargeback accounts once, then lock the mapping
- Close one month-end in parallel with the old spreadsheet before switching off the manual match
- Diary a re-check when order volume crosses a tier boundary or a new gateway goes live
If you're going with CUSTOMIZE
- Confirm what your ERP connector already posts: orders only, or payouts and fees too
- Scope one settlement schema across all gateways before writing code: gross, fee, refund, chargeback, FX, payout date, reference
- Build the bank match with an exception queue first; the posting step is the easy half
- Run the first month-end close on the engine in parallel with the manual match
Official Docs & Sources
- Payout reconciliation report (Shopify Payments) — Shopify Help Center
- GraphQL Admin API reference — shopify.dev
- Perform bulk operations with the GraphQL Admin API — shopify.dev
Official documentation linked for verification — our verdicts and estimates are our own.
Related Decisions
Build or Buy Receivables Aging and Collections on Shopify?
No Shopify app produces an AR aging report, and the specialist collections platforms sync from your ledger rather than from Shopify.
Build or Buy BOM and Production Scheduling on Shopify?
No Shopify app does BOMs or production runs. The decision is which MRP platform to connect, and how tightly to sync inventory truth.
Build or Buy Economic Nexus Threshold Monitoring on Shopify?
Shopify Tax already flags states at 80% of their nexus threshold. Nobody needs a monitoring app; what you pay for is registration and filing in each new state.
Build or Buy FX Exposure and Treasury Hedging on Shopify?
No Shopify app hedges currency risk, and Shopify Payments converts at checkout without ever measuring the exposure underneath.
Should You Build or Buy a PIM on Shopify?
PIM on Shopify is a scale decision: metafields cover most catalogs, PIM apps win at multi-channel breadth, custom pipelines at ERP-grade complexity.
Ready to close the month without a deposit spreadsheet?
For a QuickBooks or Xero ledger, the app wins and we'll tell you which one. When your ledger is an ERP and the connector skips gateway payouts, we build the settlement match that ties every deposit back to its orders, fees and refunds.
Contact us todayVerdict scored for the reference scenario above. Estimates are not quotes; app pricing carries its verification date and gets re-verified quarterly. Full scoring anchors: see the TCC methodology.
Read how we score these decisions (the TCC Framework). No affiliate links, no paid placement — no app vendor pays to appear here.