KPL-1705

Keep Shopify and Exact Online updated automatically.

Exact Online runs on journals, ledger accounts, VAT codes and relations, and expects every webshop sale to slot exactly into them. Shopify hands over orders, refunds, Shopify Payments payouts and a per-country VAT setting through Shopify Markets. Schakel reads your Shopify orders and turns them into sales invoices in the Exact sales journal, with the customer as a relation and a VAT code per line.

InvoicesContactsVAT
The link

What travels across the link

Everything this connector moves between Shopify and Exact Online, and how often.

  1. Sales invoices in the sales journal

    Every Shopify order becomes a sales invoice in the sales journal you choose, with a line per product and the Shopify order number as reference. Your webshop sales sit in one place in Exact.

  2. Customers as relations

    The buyer is looked up in Exact as a relation by email or name, or created as a new relation. Business customers with a VAT number are recorded as a debtor relation with that number, ready for reverse charge.

  3. VAT codes per line and OSS

    Each line gets the right Exact VAT code for standard, reduced, 0% or reverse charge. If Shopify Markets sells to other EU countries, the destination country VAT code is used, so your OSS return in Exact lines up.

  4. Refunds as credit notes

    A refund in Shopify becomes a credit note on the same relation in the sales journal, for the amount actually refunded, so your receivables in Exact stay correct without correction entries.

What you get out of it

What Shopify to Exact Online saves you

  • Webshop sales sit as invoices in the right journal, not loose in an export.
  • Customers arrive as relations in Exact, business buyers with their VAT number.
  • VAT codes and OSS are correct per line, including sales through Shopify Markets.
  • Your accountant keeps working in Exact, everything is already booked in the journal.
In four steps

Setting it up

  1. 01

    Connect Shopify

    You install Schakel on your Shopify store and grant access to orders and refunds. Schakel only reads what has already sold, your checkout stays untouched.

  2. 02

    Grant access to Exact Online

    You authorise Schakel through Exact Online and pick the administration the invoices should land in. Your password is never asked for or stored.

  3. 03

    Set journal, ledger and codes

    You assign the sales journal, the revenue ledger account and the VAT codes, so the entries match how you or the accountant work in Exact today.

  4. 04

    Check and let it run

    You see the first entries in an overview before they are final. Once it looks right, new orders and refunds flow in by themselves and everything sits in the log.

What you need

  • A Shopify store you own or where you may install apps. The connector runs as an app inside your admin, so you sign in through Shopify and need no separate account.
  • An Exact Online account with rights on the administration you want linked. You grant Schakel access once through Exact itself.

Not sure how to get those keys? Step by step:

Where it runs

Inside your Shopify admin, as an app. You sign in through Shopify, no separate account.

Request this connector: tell us what you need and we reply within 24 hours.

Another pair

Connect a different pair

Shopify and Exact Online is one of many. Pick two systems and see what travels between them.

Systems · 183
From
To

Common questions

Is the Shopify to Exact Online connector available?

Request this connector and get access. You let us know you want to link Shopify to Exact Online, and we make sure you can get started. You hear from us within 24 hours.

Which journal do the Shopify invoices land on?

On the sales journal you assign. To keep webshop revenue on its own revenue account or invoice series, you set that per ledger account, so your overview stays sharp.

Does this work with Exact Online for accountants?

Yes. Schakel books into the client administration you grant access to as an accountant. Several Shopify stores from different clients can each feed their own administration.

How are VAT codes set per destination country?

Schakel reads the destination country and the VAT Shopify put on the order, and picks the matching Exact VAT code per line. Your OSS sales arrive under the right code.

Does the Shopify Payments payout reconcile in Exact?

The payout is matched against the invoices on the ledger you link to Shopify Payments, with transaction fees on their own account, so your bank entry in Exact lines up.

Can you connect Shopify to Exact Online?

Yes. Schakel connects through the official APIs of Shopify and Exact Online, so you install nothing on your own server and nothing travels outside those two parties.

Which VAT rate do my sales get in Exact Online?

The rate is set per line: 21%, 9% or 0%. Sales to Belgium and other EU countries get the rate of the destination country, ready for your OSS return.

Are commission and fees booked separately in Exact Online?

Yes. Commission, shipping and other fee types each land on their own ledger account in Exact Online, rather than in one lump sum, so your margin stays readable.

Missing something you need?

Tell us what Shopify and Exact Online should do for you. If it is not in here yet, that is usually because nobody has asked. We build on request and we reply within 24 hours.