clate®

Navigation

Good things need room to grow.

WooCommerce and Exact Online

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

This guide is for e-commerce managers and bookkeepers who want WooCommerce orders to end up in Exact Online as sales invoices. After reading, you will know which parts of an order move, which orders stop for review, what to prepare in both systems, and how to test with real data before anything is booked in your live administration. Integrator by CLATE is used as the example throughout. It is in beta, and this integration is opt-in.

What moves from WooCommerce to Exact Online

Integrator turns each WooCommerce order into a sales invoice in Exact Online. One order is one record. It checks for new and changed orders every 15 minutes, and when you press Run now.

The sales invoice gets the customer, the sales journal you choose, a reference to the order, the date, the product lines with VAT per line, discounts and shipping. Coupon discounts are allocated to the lines, so each line carries its value after discount. Shipping is booked as its own sales item. Shops that show prices including VAT and shops that show them excluding VAT are both supported.

Each refund becomes a separate credit invoice with the refund reference, the date, the refunded items, VAT per line and any refunded shipping. Partial, full and later refunds each get their own credit invoice. Sending an order again does not create a second invoice or credit invoice.

For the customer, you choose a policy: book every order on one fixed existing customer, match an existing customer by exact email address, or allow Integrator to create a customer with name, email and country. A match that is ambiguous or blocked stops the order before anything is written.

Integrator reads the WooCommerce order status as the payment status. Processing and Completed count as paid. Pending payment and On hold count as pending, and a status added by a plugin is treated as unknown, not as paid. Invoices and credit invoices stay open in Exact and are not marked paid: you reconcile payments in Exact, as you do today.

  • Sales invoice: customer, journal, reference, date, items, VAT per line, discounts, shipping
  • Credit invoice: refund reference, date, refunded items, VAT per line, shipping
  • Customer, only when your policy allows creating one: name, email, country

What stops for review and what does not move

When an order cannot be booked without guessing, Integrator stops that order for review and explains why. The other orders in the run go on. This is deliberate: a stopped order is easier to fix than a wrong invoice in your books.

Some things do not move at all. Changes to an order after it is booked, other than refunds, are not followed, and an existing invoice in Exact is left unchanged. Integrator does not finalise, email or delete invoices. Changes made in WooCommerce in the last minute before a run are read on the next run.

  • Orders in a currency other than euro
  • Orders with fees (WooCommerce fee lines, for example a payment surcharge), compound taxes, or more than one tax rate on one line
  • Orders with missing, ambiguous or incomplete VAT information, such as a VAT rate for which Exact has no clear VAT code
  • Line discounts that do not add up to the order discount, or a line price that is not a whole-cent amount
  • Refunds that do not fit the order: a refunded line or shipping that is not on the order, refunded lines worth more than the refund, or refunds that changed while the order was being read
  • Products without a matching sales item in Exact, or shipping charged without a shipping item
  • Orders that are still pending, such as Pending payment or On hold

Check WooCommerce before connecting

Integrator only reads orders from WooCommerce, so a read-only API key is enough. An API key is a login made for software: a consumer key and a consumer secret. WooCommerce shows the secret only once, so copy it straight away.

Look at your recent orders with the stop list above in mind. If your shop adds payment fees or uses compound taxes, those orders will stop and need to be booked another way.

  • WooCommerce 8 or later
  • The shop runs on an https:// address. Enter the address the shop ends up on in a browser, with or without www, because redirects are not followed
  • In WordPress, Settings > Permalinks is set to anything other than Plain
  • Create the key under WooCommerce > Settings > Advanced > REST API, for a user with the Administrator or Shop manager role, with Read permission
  • If you use a security plugin, allow /wp-json/wc/v3
  • Your shop sells in euro

Set up Exact Online first

Integrator uses the sales items and VAT codes that already exist in the Exact administration you connect. It does not invent them. Prepare these before your first test, ideally in an Exact test administration. One connection uses one administration.

VAT needs the most care. VAT codes are matched by rate, transaction type, blocked state and country. If you sell to consumers in other EU countries under OSS, the one-stop shop scheme for EU VAT, set up OSS VAT codes with the right country. A foreign order does not get a domestic VAT code just because the percentage is the same. Zero-rate and ambiguous VAT codes need a deliberate choice in the mapping.

Once invoices are booked, do not change their lines by hand in Exact. When a later refund arrives, Integrator checks the invoice's totals, customer, reference and type, but a manual line change that keeps those the same is not detected.

  • A login with access to the administration you want to use
  • A sales journal for webshop invoices
  • A sales item for each product, with a revenue account, whose code matches the product's SKU in WooCommerce
  • A sales item for shipping when you charge shipping
  • VAT codes for every rate you sell at, a code for zero VAT if you need one, and OSS codes with the right country if they apply
  • A decision on the customer policy: one fixed customer, match by email, or create new customers

Test safely before turning it on

Start with an Exact test administration, not your live books. Then run a dry run: Integrator reads up to 20 recent orders from WooCommerce and shows, for each one, what it would write to Exact. A dry run writes nothing and opens no problems, so you can repeat it as often as you like.

Because a dry run uses the most recent orders, create the test orders you want to see first. Compare each preview with the WooCommerce order totals line by line.

When the previews look right, turn the integration on against the test administration and check the documents in Exact. Compare credit invoices with their original invoice and check that the amounts and VAT have the signs and totals you expect. Press Run now again and confirm no second invoice or credit invoice appears. Only then connect your live administration and check a dry run there before turning it on.

  • Orders with prices including and excluding VAT, if your shop has used both
  • An order with a coupon
  • An order with shipping
  • An order with products at 21% and 9% VAT
  • A partial refund, a full refund and a refund made days after the order
  • A refund for an amount only, without products, if your team does those
  • An order to a customer in another EU country, if you sell abroad

When an order stops

Open the stopped order in Integrator. Each record shows when it was found, how it was prepared and what Exact answered. The explanation names the cause and the fix. These explanations are written and approved by the CLATE team. An error without an approved explanation is shown as not yet explained, rather than guessed.

Fix the cause in WooCommerce, in Exact or in the mapping, then send the order again. Sending again does not create a duplicate. If you book an order by hand instead, note that in your own records so nobody sends it again later. If Exact or WooCommerce refuses the login itself, the whole run stops until you reconnect the app. If every order stops with the same message, check your settings before fixing orders one by one.

  • This order needs review before accounting: the order has fees or compound taxes, or changed while it was read. Book it by hand, or retry after the change in WooCommerce is finished
  • A VAT code is missing in Exact Online: add the VAT code in Exact under Stamgegevens > Btw-codes or change the VAT mapping, then retry
  • Check the Exact accounting settings: a customer, item, journal or VAT code does not match the order. Correct the reference data in Exact and preview again
  • Review the order amounts: lines, VAT, discounts, shipping or refunds could not be reconciled. Correct the order or the mapping and preview again
  • Exact has not confirmed this write: an invoice, credit or customer may already exist. Check Exact before you retry
  • The Exact Online login expired: reconnect Exact Online in Connections
  • WooCommerce does not accept the API key: add a new Read key and update the connection. If that fails too, ask your web host to pass the Authorization header to WordPress