Shopify Exact Online integration without the headache

This integration synchronizes automatically every 120 minutes by default. You don't need to do anything for this. If a synchronization fails, the integration will retry it in the next run. If the issues persist, we will notify you by email.

In Exact Online, you need to have the appropriate permissions for Sales entry, Sales invoice, or Sales order. You can coordinate this with your accountant or with Exact Online. You can find the settings in your Exact Online account.

No, unfortunately, technically the PDF cannot be read and therefore cannot be included when sending it to Exact Online.

Certainly. For this, you need to install the integration separately for each webshop.

Items are not necessary for Sales bookings. Only when you choose to create Sales invoices or Sales orders in Exact Online, a match is made based on the item code. To create an invoice or order, the items need to exist or be created in Exact Online. Make sure you have filled in the item codes in Shopify as well. NOTE: if you already have items in Exact Online, make sure that the VAT codes match what you have set in the integration settings.

Inventory is only updated in Exact Online for Sales invoices and Sales orders. Shopify is considered the leading source of inventory information. Manual inventory adjustments made in Shopify are not reflected in Exact Online. Additionally, inventory changes made in Exact Online do not sync back to Shopify.

Yes, the integration also syncs refunds. As soon as you refund a Shopify order, a credit note (invoice with a negative amount) of that order will be created in Exact Online. NOTE: canceled orders will not be processed. So don't cancel an order when it still needs to be synchronized as a credit order.

Absolutely 😀! If you don't have the time or find the setup too complicated, no problem! We can handle the installation of this integration for you. There will be a one-time installation fee for this service. If you later decide not to use the integration, we'll refund the installation fee to you.

Make sure that you have activated the VAT rates used in both Shopify and Exact Online. In that case, the integration will always apply the correct VAT rates. If a rate is missing in Exact Online, we will fallback to a default rate. Also, take a look at our knowledge center and search for 'VAT' for more information.

• Indicate what status the sales invoice should have in Exact Online. You can also choose to have Exact Online send the invoice.
  
  Note! We only do the actual sending for invoices that are not part of the initial export of invoices.
• Below, indicate whether you want to use the general ledger account of the item/item group from Exact Online if available or the general ledger account from the configuration of the integration.
• Do you want to book currency differences between payouts and sales entries on the ledger account for currency differences? The difference will only be booked if it is less than 2% of the sales entry amount.
• Should the fulfillment date be used as the order date?
• Enter the article code of the item to book the shipping costs on
• Do you want to export existing Shopify Payments transactions?
• Select the ledger account for debtors
• Select the journal in which the sales entries should be booked
• The administration the entries will be booked in
• Connect the VAT categories of Shopify to your Exact Online general ledger
• Do you make use of a Point of Sale in Shopify and do you want to book these orders in Exact Online as well? Then please enter the debtor number of the debtor on which these orders should be booked.
• Are you using Shopify Payments as your payment service provider (PSP)? If so, you can indicate here whether you want received payments to be automatically processed in your accounting.
  
  Choose "Yes" if you want the payouts from Shopify Payments to be automatically matched to the corresponding open entries in your accounting after settlement. Additionally, the associated transaction fees will be posted automatically. This automates the reconciliation process within your accounting.
  
  Choose "No" if you are not using Shopify Payments, or if you prefer to track the payments manually in your accounting software.
• Which product identifier should be used to match? If you choose barcode, make sure the barcode is filled for every product variant.
• Select the ledger account for gift cards
• Select the expense account where the transaction fees of Shopify Payments should be booked.
  
  Note: Only accounts of type Other Expenses are shown. If your account is not listed, change its type or create a new account with this type.
• Please indicate below for which order status(es) the app should synchronize the order. Please note: once an order has been synchronized to Exact Online, any subsequent changes in Shopify will no longer be updated in Exact Online.
  
  Are you using a Payment Service Provider (PSP)? Please note that the order must be in Exact Online before the payment, otherwise the payment cannot be matched with the outstanding item.
• Do you also want to export refunds from Shopify. Note: Cancelled orders are not considered refunds.
• Enter the article code of the item to book the costs on
• Select the default ledger account for POS sales revenue
• Select the ledger account on which to book the currency difference between the sales entry and the payout
• Do you want to export existing orders from Shopify
• Do you want the discount on a separate order line?
• Do you ship to private individuals in other EU countries and do you use the OSS scheme? Then select "Yes, I use the One Stop Shop (OSS)". The integration will then automatically look up the correct OSS VAT code in Exact Online based on the customer's delivery address. Make sure the OSS VAT codes are correctly set up in Exact Online.
  
  If you do not use OSS, please select "No"; the VAT of the webshop's country will then be applied.
  
  More information about OSS and how to configure this in Exact Online
• Select the ledger account for shipping costs
• Specify how the orders should be inserted into Exact Online.
  
  Choose 'Yes' at the 'Create items' step when you choose 'Sales invoice' or 'Sales order' and don't manage items in Exact Online.
  
  This article explains the difference between a sales booking, sales invoice, and sales order.
  
  If you choose 'Direct sales invoice', you might require the Plus, Professional, or Premium edition of Exact Online.
• Select the journal in which currency difference entries should be booked
• Do you want the default customer to be used only for consumer (B2C) customers? If enabled, business (B2B) customers will be looked up or created as separate accounts in Exact Online, ensuring that the ICP declaration is processed correctly.
• If you choose 'No' order numbers will be transferred as-is. If you choose 'Yes' the prefix and suffix that you have configured in Shopify (at Settings > Store details > Order ID format) is added to the order number. Note: existing orders won't be adjusted. Read this article (Dutch) for more information on prefixes and suffixes in Shopify.
  
  Choose 'Yes' when you connect multiple Shopify stores to the same bookkeeping administration.
• Indicate if you want to create items in Exact Online if they don't exist. Only articles used in an order will be created. Articles in Shopify should have article codes.
• Do you want to book the revenue from OSS orders to a separate general ledger account per country? If you choose 'Yes', then under the question 'Book revenue', select the option 'Per country' and link each country to the appropriate general ledger account. If you choose 'No', the revenue from OSS orders will be booked on the default revenue general ledger account for 'Unieregeling (OSS)'.
• Select the default ledger account for sales revenue
• Your Shopify store has multiple business entities (legal entities), each with its own Shopify Payments account and its own payouts. Select which entity this integration should retrieve payouts for.
• Enter the article code of the item to book the tips on
• Select the bank journal where Shopify Payments transactions should be recorded.
  Tip: Create a separate bank journal in Exact Online for these payouts. This keeps your bookings organized and prevents them from mixing with your regular bank transactions.
• Select a suspense account to post the payout amount. The integration will record the payout as a negative entry on this account. Ideally, also link the corresponding bank transaction to this account to ensure proper reconciliation.
  
  Note: Shopify Payments payouts are made by Stripe Technologies, which is the description you will see on your bank statement.
• Enter the article code of the item to book the discounts on
• Select the default ledger account to book your revenue on in case you make use of the 'Unieregeling (OSS)'.
• Connect the countries of Shopify to your Exact Online general ledger
• How would you like the revenue to be booked?
• Pick a Service level matching your needs. You can always change it at a later time, and the price will be adjusted accordingly.
• Select the correct VAT codes for each category to ensure that the appropriate rates are accurately applied to your Shopify orders in Exact Online. For business-to-business (B2B) sales within the EU, make sure to link the 'VAT inside EU' category. Read the following article to learn more about processing B2B orders.
• If you want to book your orders on a default debtor in Exact Online, enter the code of that default debtor here
• Select the warehouse to use when creating the sales order in Exact Online. Leave empty to use the default (main) warehouse.