Connect Shopify to Xero: sales, stock and refunds
Connect Shopify to Xero with clear rules for sales, tax and refunds. Map payouts and stock ownership, then check the records before relying on the sync.
- Published
- Last updated
Yes, you can connect Shopify to Xero through the official Shopify integration by Xero or a separate connector. Choose how sales reach Xero, map the payment accounts and reconcile one complete payout before importing older records. Assign stock ownership separately so an accounting adjustment can’t unexpectedly change what customers can buy.
Choose the Shopify to Xero connection method
The official Shopify integration by Xero sends Shopify financial data into Xero, with daily summaries or individual sales. Xero identifies Amaka as its integration partner. An official marketplace listing identifies the app and publisher. It doesn’t mean every Shopify object has a two-way connection.
Xero’s Australian App Store listing says its integration is free for Xero subscribers on all Xero plans. Shopify and Xero subscriptions remain separate. The listing includes online and point-of-sale sales, tax mapping and up to 90 days of historical data.
Choose daily summaries when Shopify retains the order detail and Xero needs totals for accounting and payment reconciliation. Choose individual sales when staff need customer and product-line detail within Xero. A summary must still retain enough breakdown to explain each gateway balance and tax category.
Other connection methods have different responsibilities:
- A third-party accounting connector supplies its own posting rules, scheduling and recovery tools. Compare its supported objects and subscription terms against the records you need.
- An automation workflow connects a trigger to an action, such as creating an invoice after payment. Refund handling and duplicate prevention need their own steps.
- A custom application programming interface (API) connection gives developers control over mappings. The developer also owns authentication, retries and reconciliation.
- A manual export and import moves a selected batch. Staff must record the imported range and prevent the same transactions entering through an automated connection.
Use one method to post each class of transaction. Running a trial connector beside an existing connector against the same Xero organisation can create duplicate sales.
Map sales, taxes, refunds and payouts
Map the order’s sales detail separately from the payment processor’s settlement. A payout is the cash transferred after the processor applies fees and other balance movements. It can include transactions from several sales periods.
Use a clearing account to track money moving through each payment gateway. Sales and refunds affect that balance. A payout transfers the settled amount from clearing to the bank account. The matching bank-feed deposit then reconciles that transfer.
Illustrative sale and payout
Assume one customer pays $110 for goods after a discount, plus $11 shipping. Both amounts include goods and services tax (GST) at 10% in this fictional example. Assume the processor deducts a $3 fee and pays out $118. The example excludes tax on the fee and all other balance movements.
| Record | Illustrative amount | What the mapping must preserve |
|---|---|---|
| Goods before discount | $120 | Original product amount |
| Discount | $10 | Reduction to the goods amount |
| Goods after discount | $110 | $100 sales plus $10 GST |
| Shipping collected | $11 | $10 shipping income plus $1 GST |
| Customer payment | $121 | Increase in gateway clearing |
| Processing fee | $3 | Fee expense and reduction in clearing |
| Bank payout | $118 | Transfer from clearing to bank |
An incorrect import records the $118 deposit as another sale after posting the order. The correct mapping records $110 of income and $11 of GST from the order, then accounts for the fee and transfer separately. The clearing balance for these isolated transactions returns to zero.
Your bookkeeper owns the tax-code decisions for your actual products and shipping charges. The integration administrator applies those decisions to the connector’s mappings. Keep discounts allocated to the affected sales lines so the taxable amounts follow the order.
A partial refund needs the refunded goods amount and its tax treatment, plus any shipping refunded. Match it to the original order and the actual payment refund. Don’t assume the processing fee comes back with the refund.
Keep gift-card issuance and redemption distinct. Map the outstanding gift-card obligation to a liability account and reduce it on redemption. Separate the payment method from the sale’s product lines so redemption doesn’t create a second gift-card sale.
Use the Shopify Payments payout details to inspect the transactions within a settlement. Compare its fees and adjustments with the connector’s entries before matching the bank deposit.
Assign inventory and order-data ownership
Keep Shopify’s sellable stock quantities under one operational owner, even when Xero contains product lines and inventory values. A financial posting alone doesn’t establish a stock quantity for a particular Shopify location.
Amaka’s Shopify-to-Xero setup guide describes daily summary invoices or individual order invoices. It also documents a cost of goods sold (COGS) sync that generates a manual journal adjusting inventory value. That journal is an accounting entry. Don’t use it as evidence that the integration writes sellable quantities back to Shopify.
For the selected configuration, record whether it transfers product identifiers, invoice lines, item costs or inventory values. Assign quantity updates to a documented stock workflow. If you need location-level availability, use the Shopify inventory sync guide to define that workflow.
Shopify’s inventory object documentation separates product variants from inventory items and inventory levels at locations. Match the variant and location identifiers in your stock connection. A product code alone doesn’t identify where stock is available.
A refund and a restock also need separate decisions. Shopify’s refund API documentation supports refunds with optional restocking. A credit recorded in Xero doesn’t by itself prove an item is available again.
For example, a customer receives a refund for a damaged shirt that cannot be resold. Record the financial refund, then keep the damaged unit out of available stock. A returned, inspected shirt can re-enter stock at its receiving location through the operational return workflow.
Customer-service staff must use the payment refund record for refund status and the stock owner for availability. Otherwise, an accounting credit can lead staff to promise stock that has never returned to the shelf.
Place Xero within the wider integration map
Give each data type one system that decides its value and one approved route to each destination. If an enterprise resource planning (ERP) system handles stock and fulfilment, Xero can receive the accounting results without becoming another stock controller.
An ERP integration can send Shopify orders into the operations system and return fulfilment status or available quantities. A separate finance connection can send the resulting financial records to Xero. Alternatively, one integration can handle the accounting directly. Document which route applies before enabling either.
This proposed ownership map assigns responsibilities across Shopify, an ERP and Xero. Adapt the design to the objects your connectors support.
| Data | Proposed owner | Permitted handoff |
|---|---|---|
| Catalogue descriptions and images | Shopify merchandising team | Publish to sales channels without accounting overwrites |
| Warehouse stock and allocation | ERP or warehouse system | Send sellable quantity to Shopify by location |
| Customer order and checkout totals | Shopify | Send order once to the operations system |
| Payment settlement and fees | Payment processor | Send financial detail once to Xero through the chosen connector |
| General ledger and tax mappings | Xero and the accounting team | Receive approved sales and adjustment postings |
| Return inspection and restock | Warehouse workflow | Update stock once and send the financial outcome separately |
If NetSuite is already your ERP and accounting ledger, first establish why Xero also needs a copy of sales. Define the entity or reporting purpose and the exact transactions it receives. Avoid two connectors independently posting the same Shopify order into Xero.
Xero Central explicitly warns against connecting its Shopify integration alongside Xero Inventory Plus when both would record order finances. Apply the same duplicate-path check to any existing ERP or stock connector.
If your accounting destination is MYOB, use the Shopify MYOB integration guide for its sales and stock handoffs.
Connect and reconcile a sample period
Start with a small closed period that includes a sale, a refund and a completed payout. Keep automatic backfilling paused until the records agree.
- Record the current connections and the final transaction each has already posted. Save their configuration and identify the accounting owner for corrections.
- Open the Shopify integration by Xero in the Xero App Store and choose Get this app. Authenticate the intended Shopify store and Xero organisation. Review the requested access before authorising it.
- Select daily summaries or individual sales. Apply the approved sales, discount, shipping and tax mappings. Give each payment gateway its own agreed clearing treatment.
- Set the scheduling time zone and first sync boundary. Exclude transactions already entered manually or by an older connector. Save the boundary before activation.
- Enable only the sample period or controlled initial range supported by the connector. Amaka’s guide describes daily processing of the previous day’s sales, so allow that scheduled run to complete.
- Compare the posted sale with its Shopify order. Check its discount allocation, shipping amount and tax totals. Match the refund to its source transaction and original order.
- Compare the payout’s gross charges, refunds, fees and adjustments with the clearing movements. Match the net transfer to the bank statement. Explain any remaining clearing balance using unsettled transactions.
- Correct mapping or boundary errors before extending the import. Keep the approved mapping and sample reconciliation together so later changes have a baseline.
Historical access has two separate limits. Xero’s listing advertises a 90-day import window, while Shopify’s Order API gives apps access to 60 days by default. Older order access requires additional permission. For a custom connection, plan both the app’s access and its import boundary using Shopify’s order permissions.
A successful connection screen proves authentication. Your reconciled sample proves that the chosen configuration produces the records your store needs.
Recover failed or duplicate synchronisation
Pause the affected posting path when a sync creates unexplained entries. Keep the source orders and connector logs intact while you identify which records reached Xero.
| Symptom | Compare these records | Correction before replay |
|---|---|---|
| Missing order | Shopify payment status, connector eligibility and sync log | Fix access, mapping or the excluded range after confirming no Xero entry exists |
| Duplicate sale | Shopify order identifier, Xero references and every active connector | Disable the duplicate path and agree the correction with the accounting owner |
| Refund missing | Shopify refund transaction, original sale and connector refund log | Restore the failed refund mapping and confirm the target credit is absent |
| Payout does not balance | Payout transaction export, clearing entries and bank deposit | Identify the missing fee, adjustment or timing difference |
| Stock changes unexpectedly | Inventory event, location identifier and active stock writers | Stop competing quantity updates and restore the agreed stock owner |
A timeout can happen after Xero has accepted an entry. Search for the target record before retrying. Record the source identifier beside the destination identifier so a replay can recognise work already completed.
For duplicates, have the accounting owner correct the specific affected entries using the appropriate accounting procedure. Preserve the audit trail and any reconciled or locked records. Bulk deletion removes the evidence needed to explain what happened.
Resume with one failed record or the smallest supported batch. Compare the result with the source and confirm that a repeated run creates no extra entry. Then release the remaining backlog within the recorded import boundary.
Give your store its own shopping agent
Customers ask in their own words. Your agent finds, compares and checks out from your catalogue, right on your site.