How to Connect Shopify to Xero: Setup and Payout Reconciliation

Important US sales-tax limitation

US sellers should be particularly careful with sales-tax assumptions.

Xero's current App Store listing describes tax syncing and flexible tax mapping, but Xero's US Shopify page separately states that sales tax is not supported in the Xero-Shopify integration in the US and that sales-tax data must be obtained from Shopify for reporting and filing.

Because those official descriptions conflict, do not treat this integration as your US sales-tax reporting or filing system without confirming the current behavior for your account. Tax filing, nexus, remittance, and tax-treatment decisions should remain with the appropriate tax professional.

Confirm the correct Shopify store and Xero organization

Make sure you are connecting the intended Shopify store to the intended Xero organization, especially if your login has access to several businesses or test stores.

Also check which Shopify periods are already represented in Xero. If the same activity has previously been entered manually or through another connector, syncing those dates again can create duplicate records.

Choose your level of transaction detail

The current integration lets you use either:

Xero describes the same distinction: daily summaries keep the accounting file lighter, while per-sale syncing provides customer and line-item detail.

Neither method is inherently more accurate. Choose the amount of accounting detail you need and can reasonably review.

Check historical periods before importing them

As of August 12, 2026, Xero's App Store says the integration can sync up to 90 days of historical Shopify data.

Before using that option, establish a cutoff date. Compare it with manual entries, previous connectors, journals, Shopify summaries, and earlier payout reconciliations already present in Xero.

If July is already recorded correctly, for example, importing July again simply because the connector allows it can create overlapping transactions.

Step 1: Open the Shopify integration in the Xero App Store

Find the Shopify integration published by Xero and select Get this app. Xero currently lists the app as “By Xero.”

Use the current listing rather than relying on an old screenshot tutorial because the integration has changed over time.

Step 2: Sign in to Xero

Sign in with the Xero account that can access the organization you want to connect.

If your login has access to more than one Xero organization, confirm the correct one before continuing.

Step 3: Connect the relevant Shopify account

Continue through Xero's authorization flow and connect the appropriate Shopify and Xero accounts. Xero's current setup sequence starts from the App Store, redirects you to connect the two accounts, and then takes you through configuration.

Use the platforms' approved user-access and authorization controls rather than sharing passwords with a bookkeeper or other third party.

Step 4: Choose daily summary or per-sale syncing

Select the level of transaction detail you decided on earlier.

For a store that already uses Shopify for customer and order analysis, a daily accounting summary may be enough. A business that genuinely needs customer or line-item information inside Xero may prefer per-sale syncing.

Step 5: Review the accounting mappings and settings

Check where the integration will place sales, payment activity, fees, refunds, and other relevant records.

Do not copy a chart-of-accounts structure from a tutorial without considering your own bookkeeping setup.

For US sales tax, do not assume that the integration will provide the records needed for filing. Xero's US page specifically says sales-tax reporting is not supported by the integration.

Step 6: Set a historical-sync cutoff if needed

If historical importing is necessary, confirm the last date that is already complete in Xero before choosing the period to sync.

Avoid deliberately overlapping previously recorded periods unless you understand how the connector will handle them and have a duplicate-review process.

Step 7: Complete setup and test the first relevant payout

After the first activity syncs, do not stop at “something appeared in Xero.”

Test whether you can trace:

Shopify activity → Xero records → actual bank deposit.

That validation is what tells you whether the bookkeeping workflow works, not merely whether the software connection succeeded.

Setup screenshots placeholder

1. Check the Shopify payout

Start with the underlying Shopify Payments activity.

Shopify's payout reconciliation report can show transactions, fees, refunds, chargebacks, adjustments, reserves or holds, and payouts. Shopify also explains that payout totals can differ from sales reports because the payout report represents balance activity and movement of funds rather than an accounting statement of revenue.

That distinction is central to payout reconciliation.

2. Check the Xero records

Next, confirm that the relevant Shopify activity reached the accounts or records you expected in Xero.

Look for practical exceptions such as sales appearing twice, missing fees, refunds that are not represented as expected, activity appearing in an unexpected account, or a payout that cannot be traced to the related settlement activity.

If the first batch is wrong, investigate before allowing the same setup to repeat for weeks.

3. Check the bank deposit

Finally, compare the payout with the corresponding bank activity.

Xero's reconciliation workflow uses imported bank statement lines and matches them with transactions recorded in Xero.

A clean workflow should make the relationship between Shopify activity, Xero, and the bank deposit understandable.

Do not create a balancing transaction until you understand the difference

If the numbers do not match, first find the cause.

Possible explanations include fees, refunds, timing differences, adjustments, another payment gateway, duplicate historical activity, currency differences, or transactions falling into another settlement period.

Shopify specifically recommends investigating payout details when a payout differs from expectations and documents several of these causes in its payout-reconciliation guidance.

Illustrative first-payout example

Suppose a simplified Shopify Payments settlement contains:

If there are no other holds, reserves, adjustments, timing differences, or currency effects in this example, the settlement trail should explain a $7,380 bank deposit.

The bookkeeping objective is not to label the entire $7,380 deposit “sales.” It is to retain enough information to explain the sales activity, refunds, fees, and movement of cash while reconciling the settlement.

This example is illustrative only. It is not a NenoBooks customer result and is not a recommendation for how a particular business should classify revenue, sales tax, or other transactions.

First-sync checklist placeholder

The bank deposit does not match Shopify sales

That difference is not automatically an error.

Shopify specifically warns that payout activity and sales reports can differ because of deductions, holds, adjustments, currency effects, timing, and other balance activity.

Compare the bank deposit with the specific payout and settlement activity rather than trying to match it directly to a headline sales figure.

Fees or refunds are missing

A bank balance can appear reasonable even when the profit and loss statement is incomplete.

For example, recording only a net payout can hide the distinction between sales and processing costs.

Trace the underlying payout activity before deciding how to correct the books.

Transactions were imported twice

Duplicates commonly arise when two bookkeeping processes cover the same period—for example, manual Shopify summaries followed by a historical connector import.

Identify the exact overlap before deleting or reversing anything.

If previous periods already contain duplicate or incomplete records, catch-up and cleanup bookkeeping may be more appropriate than adding another automation layer.

Historical syncing overlaps existing records

Define a cutoff date before importing historical activity.

Compare it against previous manual entries, connector data, accountant or bookkeeper journals, Shopify summaries, and existing payout reconciliations.

A different payment gateway settles separately

Shopify's payout reconciliation report covers Shopify Payments. Shopify states that it does not include third-party payment processors or some third-party payment methods.

If PayPal or another processor settles separately, trace that processor's settlement separately and check that the same underlying sale is not being counted twice.

Stores with several sales channels and processors may need a wider ecommerce bookkeeping workflow rather than a Shopify-only process. NenoBooks' ecommerce service covers records from sales channels, payment processors, banks, and cards.

Refund or chargeback timing creates a difference

A refund or dispute does not have to affect the same payout period as the original transaction.

Compare dates and settlement batches before assuming that the integration has posted something incorrectly. Shopify's payout reporting explicitly treats refunds, disputes, adjustments, reserves, and other activity as components of the Shopify Payments balance.

Does Shopify connect directly to Xero?

Yes. Xero currently provides a Shopify integration in its App Store, with daily-summary and individual-sale options.

Is the Shopify integration by Xero free?

Xero's App Store currently describes the Shopify integration as free for Xero subscribers and says it is available on all Xero plans. However, Xero's US Shopify page also contains “30-day free trial” wording for the integration. Because those two official pages are not completely consistent, confirm the current terms during installation before relying on a pricing assumption.

Should I use daily summaries or individual Shopify sales?

Use daily summaries when you mainly need Xero for accounting, reconciliation, and reporting and do not need every order represented individually.

Use per-sale transactions when customer or line-item detail in Xero is genuinely useful enough to justify the additional volume. Xero currently supports both approaches.

Does the Shopify-Xero integration handle US sales tax?

Do not rely on it as a US sales-tax reporting or filing solution. Although Xero's App Store mentions tax syncing and mapping, Xero's US Shopify page explicitly states that sales tax is not supported in the integration in the US and that the relevant data needs to come from Shopify for reporting and filing.

Why doesn't my Shopify payout match gross sales?

Because a payout represents settlement activity rather than simply gross revenue. Refunds, disputes, fees, adjustments, reserves, holds, currency effects, and timing can all change the amount transferred to the bank.

Do I still need a bookkeeper after connecting Shopify and Xero?

Not necessarily. But connecting the platforms does not eliminate reconciliation, exception review, duplicate detection, or the monthly close.

If those tasks are taking substantial time or prior periods are already difficult to reconcile, professional bookkeeping support may be useful.

NenoBooks provides Shopify bookkeeping for US Shopify and DTC sellers, including payout reconciliation, transaction categorization, bank/card reconciliation, and monthly reporting.