clate®

Navigation

Good things need room to grow.

Shopify and Exact Online

Shopify orders into Exact Online: what moves and what to check

This guide is for e-commerce managers and bookkeepers who want Shopify orders to end up in Exact Online as sales invoices. After reading, you will know what moves and what does not, what to prepare in Exact first, how to test without touching your live books, and what to do when an order stops. We use Integrator by CLATE, currently in beta, as the worked example, but the checklist applies to any way of connecting the two.

What moves from Shopify to Exact Online

In Integrator, each Shopify order becomes one open sales invoice in one Exact Online administration. An administration is a single company's set of books in Exact. Integrator checks for new orders every 15 minutes, and also when you press Run now. This integration is an opt-in beta, so validate it in an Exact test administration before you use it on your live books.

The sales invoice carries the customer, the sales journal, a reference, the date, the items, VAT per line, discounts and shipping. Each product line uses an existing Exact sales item, matched to the Shopify product by SKU. Discounts that Shopify allocates to a line are taken off that line, so the invoice shows net line amounts after discount. Shopify prices that include VAT and prices that exclude VAT are both supported.

Shipping is booked as its own line, on a sales item you choose in Exact. VAT is set per product line and per shipping line, so an order with mixed VAT rates is booked with the right rate on each line. Integrator matches each line to one of the administration's own sales VAT codes by rate, transaction type, blocked state and country. A foreign order does not get a domestic VAT code just because the percentage happens to be the same.

You choose how customers are handled: book every order on one fixed existing customer, use an existing customer whose email matches exactly, or allow Integrator to create a new customer with name, email and country. If more than one customer matches, or the match is blocked in Exact, the order stops before anything is written.

Refunds and payments

Every Shopify refund becomes its own credit invoice in Exact. It carries the refund reference, the date, the refunded items, VAT per line and any refunded shipping. Partial, full and later refunds each get a separate credit invoice.

Sending an order again does not create a second invoice, and sending a refund again does not create a second credit invoice. This also holds when you replay records after fixing a problem.

Payments do not move. Invoices and credit invoices are created as open documents and are not marked paid, so matching them with Shopify payouts and your bank happens in Exact. Agree with your bookkeeper who does that reconciliation before you switch on.

Integrator does not finalise, email or delete invoices in Exact. Invoices that already exist are left unchanged.

What does not move, or stops for review

When an order cannot be booked without guessing, it stops for review instead. It then appears as an issue with an explanation, and the other orders carry on. These are the main reasons an order is held or left out:

Changes to an order after it has been booked are not followed. Refunds are the exception, because they arrive as separate credit invoices. Other corrections to an already booked order need to be made in Exact by hand.

Avoid rewriting the lines of a booked invoice in Exact while refunds may still follow. The check on existing documents compares totals, customer, reference and document type. A line change that keeps those the same is not detected, so a later automatic credit invoice may no longer match what is in Exact.

  • Orders in a currency other than euro.
  • Products without a matching sales item in Exact, or charged shipping when no shipping item is set.
  • Missing, ambiguous or incomplete VAT information, including shipping tax that cannot be allocated clearly.
  • Refunds that are still pending in Shopify, refunds with duties or adjustments, and refunds with incomplete amounts.
  • Orders for which Shopify did not return a complete, settled financial picture.
  • Customers that match more than one Exact customer, or a blocked customer.
  • An existing Exact invoice or credit that cannot be safely matched to the Shopify order.

Prepare Exact Online first

Integrator uses the sales items and VAT codes that already exist in your Exact administration. It does not invent item codes or VAT codes, so check that the ones you need exist before you connect.

Zero VAT and VAT codes that could fit more than one way need a deliberate choice in the settings rather than a guess. Advanced settings let you pick a VAT code per rate, a zero-VAT code and a specific item for adjustments.

  • Choose one administration. One connection uses one administration. The division number is in Exact under your company name at the top left, then Administraties, or in the URL after ?_Division_=.
  • Make sure the user you connect with has access to that administration.
  • Create a sales item for every product you sell, with an item code equal to the Shopify SKU. Give each Shopify variant its own SKU.
  • Create a sales item for shipping if you charge shipping.
  • Check that these items have revenue accounts.
  • Decide which sales journal the invoices go into.
  • Add a VAT code for every rate you charge, including zero VAT and any codes you need for sales to other EU countries. VAT codes are under Stamgegevens, then Btw-codes.
  • Decide your customer policy: one fixed customer, match by email, or create new customers.

Test it safely before turning it on

Connect Shopify by signing in through Shopify and approving the permissions it shows. Connect Exact by signing in and selecting the administration. For testing, select your Exact test administration, not your live books.

Start with a dry run. It reads up to 20 recent orders with real data and shows, for each one, what would be written to Exact: a new invoice, or one Exact already has. A dry run writes nothing and does not create customers or invoices.

Then let the integration run against the test administration and open the results in Exact. Go through orders that reflect how you really sell, and check each invoice and credit invoice line by line, including the signs of the amounts and VAT on credit invoices.

Decide from which date orders should move. If orders are already booked in Exact some other way, start after them so nothing is booked twice. Orders older than 60 days can only be read once Shopify-approved access to older orders is enabled and the store is reconnected. Outside development stores, Shopify also requires approval before customer fields can be read.

  • An order with one VAT rate and one with mixed rates.
  • A line discount and a discount on shipping.
  • A zero-VAT order and an order to another EU country.
  • A partial refund, a later second refund and a refund that includes shipping.
  • Running the same orders again, and checking that no customer, invoice or credit invoice appears twice.

When an order stops

A failed order does not stop the others. It appears as an issue with an explanation the CLATE team wrote and approved. An error without an approved explanation is shown as not yet explained, rather than guessed. Every order can be traced: when it was found, how it was prepared and what Exact answered.

Fix the cause in Shopify or Exact, then send the order again. Sending again does not create a duplicate. If Exact or Shopify refuses the login itself, the whole run stops until you reconnect the app under Connections.

If you connect Shopify and Exact another way, the same list is still a useful place to start looking.

  • A VAT code is missing in Exact Online: add the code under Stamgegevens, then Btw-codes, or change the VAT mapping, and retry.
  • Check the Exact accounting settings, or Check this item in Exact: a customer, item, journal or VAT code does not fit the order. Correct it in Exact and preview again.
  • This order needs review before accounting: wait until pending refunds or Shopify changes are finished, then retry. Unsupported shipping taxes, duties or refund adjustments need review before the order is imported.
  • Check this product in Shopify: the SKU matches more than one variant. Give each variant its own SKU, then try again.
  • Exact has not confirmed this write: the invoice or credit may already exist. Look in Exact before you allow a retry.
  • Review the existing Exact document: compare the Shopify order with the document in Exact before retrying. Existing documents are not overwritten.
  • The Exact Online login expired: reconnect Exact Online in Connections.