How to Connect Shopify to Your Accounting Software
For an online store, every sale creates accounting work. Orders need to be recorded as revenue, taxes need to be reported correctly, refunds and chargebacks reduce income, payment processors deduct fees, and payouts arrive in the bank account days later as a single amount that matches none of the individual orders. When this is handled manually, month-end reconciliation becomes a long and error-prone exercise. Connecting Shopify to your accounting software, whether Xero, QuickBooks, or Zoho Books, automates this flow. Done well, the books stay accurate every day and bank reconciliation becomes a matter of matching payouts. Done poorly, it creates duplicate invoices, missing fees, and balances that never quite add up.
Why Shopify Accounting Is Harder Than It Looks
The core challenge is that sales and deposits are not the same thing. A single payout from Shopify Payments can include dozens of orders, minus processing fees, minus refunds issued during the period, adjusted for chargebacks, and sometimes held back as a reserve. Orders paid through other gateways, such as PayPal or buy-now-pay-later providers, arrive in separate payouts on their own schedules.
On top of that come details that affect how revenue is recorded: discounts, shipping charges, gift cards, which are a liability until redeemed rather than revenue, multiple currencies, and tax rules that differ by region, from UK VAT to the 5 percent VAT in the UAE and 15 percent in Saudi Arabia. An integration that simply copies each order as an invoice ignores most of this, which is why the books often fail to match the bank.
Per-Order Sync or Summary Sync?
There are two main approaches to recording Shopify sales in accounting software. Per-order sync creates an invoice or sales receipt for every order, along with matching payments and credit notes for refunds. It provides full detail in the accounting system, which can be useful for B2B stores, lower order volumes, or when customer-level records matter.
Summary sync records totals instead, typically per payout or per day, broken down by sales, taxes, shipping, discounts, refunds, and fees. Detailed order information stays in Shopify, while the accounting system receives clean entries that reconcile directly against each bank deposit. For stores with high order volumes, many accountants prefer this approach, because it keeps the ledger readable and makes reconciliation far easier. The right choice depends on volume, reporting needs, and how your accountant prefers to work, so it is worth agreeing on it before any integration is built.
Ready-Made Apps or a Custom Integration?
Xero, QuickBooks, and Zoho Books all list Shopify connectors in their app marketplaces, and specialist apps such as A2X and Synder focus specifically on e-commerce accounting, including payout-based summaries. For a standard store with one sales channel and a common accounting setup, these tools are usually the fastest and most cost-effective route.
A custom integration makes sense when the business does not fit a standard pattern. Typical examples include combining Shopify with other sales channels or a wholesale system, syncing inventory and cost of goods with an ERP or warehouse, applying specific rules for multiple entities or currencies, handling complex tax situations across several countries, or connecting Shopify to an accounting setup that off-the-shelf apps do not support well. In these cases, an integration built around your actual processes avoids months of manual corrections.
How a Custom Shopify Integration Works
A custom integration typically starts with a custom app created for the store, which grants API access with only the permissions the integration needs. Shopify's Admin GraphQL API is the primary interface for reading orders, refunds, transactions, and payout data. Shopify has marked its REST Admin API as legacy, and new public apps submitted to the Shopify App Store since 1 April 2025 must use GraphQL, so new integrations should be built on GraphQL from the start.
Webhooks let the integration react as events happen, such as an order being created or paid, or a refund being issued. Every webhook should be verified using the HMAC signature Shopify sends in the X-Shopify-Hmac-Sha256 header, and processed idempotently, because the same event can be delivered more than once. Webhooks alone are not enough for financial data, so a scheduled reconciliation job should regularly compare Shopify records with what has reached the accounting system and fill any gaps. On the accounting side, the integration connects to Xero, QuickBooks, or Zoho Books through OAuth 2.0 and respects their API rate limits.
Mapping the Data Correctly
The quality of a Shopify accounting integration depends on how each element is mapped. A sound setup usually covers:
- Sales and products: revenue mapped to the right income accounts, optionally split by product type or sales channel.
- Taxes: each Shopify tax line mapped to the corresponding tax rate in the accounting system, per country or region.
- Shipping and discounts: recorded separately so margins and promotions can be analyzed.
- Gift cards: recorded as a liability when sold and as revenue when redeemed.
- Refunds and chargebacks: recorded as credit notes or negative entries linked to the original sale.
- Fees: payment processing and app fees recorded as expenses rather than netted against revenue.
- Payouts: moved through a clearing account so each bank deposit matches exactly.
- Currencies: converted consistently, with exchange differences recorded correctly.
Best Practices for a Reliable Integration
Build and test against a Shopify development store and a test organization in your accounting system before touching real data. Agree on the chart of accounts and mapping rules with your accountant first, since changing them later means reprocessing historical data. Design every step to be idempotent so a retried request never creates a duplicate, log every sync, and set up alerts for failures. Finally, reconcile regularly: a monthly check that Shopify reports, accounting entries, and bank deposits all agree catches problems while they are still small.
Frequently Asked Questions
Can Shopify connect directly to Xero, QuickBooks, or Zoho Books?
Yes. All three accounting platforms offer Shopify connectors through their app marketplaces, and specialist e-commerce accounting apps are also available. For more complex requirements, a custom integration can connect Shopify to any of them through their APIs.
Why doesn't my Shopify payout match my sales?
Payouts are net amounts. They combine many orders and subtract payment processing fees, refunds, chargebacks, and sometimes reserves, and orders paid through other gateways are paid out separately. A good integration records each of these components so every payout can be reconciled.
Should I sync every Shopify order to my accounting software?
It depends. Per-order sync gives full detail and suits lower volumes or B2B stores, while summary sync per payout or per day keeps the ledger clean for high-volume stores and simplifies reconciliation. Agree on the approach with your accountant.
How should gift cards be recorded?
Gift card sales should be recorded as a liability, because the store owes goods or services to the holder. Revenue is recognized when the gift card is redeemed against an order.
When is a custom Shopify integration worth it?
When the business has multiple sales channels, needs inventory and cost data synced with an ERP, operates several entities or currencies, has complex tax requirements, or finds that ready-made apps require constant manual corrections.
Does Shopify still support its REST API?
Shopify has marked the REST Admin API as legacy and focuses new development on the GraphQL Admin API. New public apps submitted to the Shopify App Store since 1 April 2025 must use GraphQL, so new integrations should be built on GraphQL.
Conclusion
Connecting Shopify to Xero, QuickBooks, or Zoho Books turns a constant stream of orders, refunds, fees, and payouts into accurate, reconciled books. The key decisions are choosing between per-order and summary sync, deciding whether a ready-made app fits or a custom integration is needed, and mapping taxes, gift cards, refunds, fees, and payouts correctly. If your store has outgrown standard connectors or needs Shopify to work with other systems, our team builds Shopify accounting integrations tailored to how your business and your accountant actually work.