How to Connect Shopify to Your Accounting Software

Why Shopify and accounts are harder than they look

An order total is not what lands in your bank. Shopify Payments, PayPal and other gateways pay out in batches, net of fees, refunds and chargebacks, sometimes days later. If you only post orders, your bank feed will never match. A good integration models the full journey: the sale, the fee, the refund and the payout, so the bank reconciliation in Xero, QuickBooks Online or Sage is one click.

Per-order invoices or daily summaries?

There are two common approaches, and your accountant should choose:

• Per-order posting. Every order becomes an invoice with its own contact. It gives detail, but creates thousands of contacts and transactions, and can hit API limits on busy days.
• Summary posting. One journal or invoice per day or per payout, split by sales, VAT rate, shipping, discounts, fees and gift cards. It is tidy, fast to reconcile and the approach used by settlement tools such as A2X.

Businesses that sell to trade customers on account often mix the two: retail sales summarised, trade orders posted individually so credit control works.

Things that trip integrations up

• VAT. Different rates for different products, zero-rated exports, and how Shopify reports tax on shipping and discounts.
• Gift cards. Selling one is a liability, not income. Income is recognised when it is spent.
• Refunds and partial refunds. These should become credit notes or negative lines, linked to the original sale.
• Multi-currency. Orders in euros paid out in sterling need exchange rates handled consistently.
• Marketplace and POS sales. Shopify POS, Amazon or eBay channels may need their own clearing accounts.
• Fees. Payment and app fees should post to their own expense accounts.

How a custom integration is built

A custom build typically uses the Shopify Admin GraphQL API to read orders, transactions, refunds and Shopify Payments payouts. Shopify declared the REST Admin API legacy on 1 October 2024 and requires GraphQL for new public apps, so new work should start there. Webhooks such as orders/paid and refunds/create trigger the sync, and each request's X-Shopify-Hmac-Sha256 header is verified before anything is trusted. On the accounting side, the integration calls the Xero API, QuickBooks Online API or Sage Business Cloud Accounting API, with queued jobs, retries and a log your finance team can read. See our Xero guide for the accounting side in more detail.

Questions to agree with your accountant first

Most problems with Shopify accounting integrations are not technical. They come from nobody deciding how the numbers should land in the ledger. Agree these before choosing an app or briefing a developer:

• Posting method: per order, daily summary or per payout?
• Clearing accounts: which account holds Shopify Payments, PayPal and other gateway money until the payout reaches the bank?
• Revenue accounts: one sales account, or split by channel, product category or country?
• VAT: how should shipping, discounts and zero-rated or exempt items be coded? Are any sales outside the UK, and how are they treated?
• Fees: payment fees, app subscriptions and Shopify plan fees, which expense accounts?
• Gift cards and store credit: which liability account?
• Refunds: credit notes against the original sale, or negative lines in the day's summary?
• Stock: does Shopify, your accounting package or a warehouse system own stock quantities and cost?
• Historic data: from which date does the integration start, and how is the opening position handled?

Write the answers down as a one-page posting specification. It becomes the brief for whichever route you choose, and the test plan afterwards: run a week of real orders, including a refund, a discount code, a gift card sale and a multi-currency order, and check each one lands exactly where the specification says.

When to talk to dijitul

If an off-the-shelf connector does what your accountant wants, use it. If you need trade accounts, stock or price sync with an ERP, multiple stores feeding one ledger, or posting rules no app supports, a custom Shopify integration is worth it. dijitul has built ecommerce-to-accounts integrations since the KashFlow and OpenCart days, including stock control, price sync and credit notes for cancelled orders. Start with a free chat, then get a fixed-price quote.

Related