Based on which status should orders be synced to Exact Online?
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.

Export existing orders
Do you want to export existing orders from Shopify

Fullfillment date
Should the fulfillment date be used as the order date?

Add discount order lines
Do you want the discount on a separate order line?

Select product identifier
Which product identifier should be used to match? If you choose barcode, make sure the barcode is filled for every product variant.

Do you want to add prefixes and suffixes to order numbers?
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.

Export existing refunds
Do you also want to export refunds from Shopify. Note: Cancelled orders are not considered refunds.

Sync Shopify Payments transactions?
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.

Export existing Shopify Payments transactions
Do you want to export existing Shopify Payments transactions?

Select Exact Online administration
The administration the entries will be booked in

Select journal
Select the journal in which the sales entries should be booked

Order insertion type
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.

Create items
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.

Sending costs item
Enter the article code of the item to book the shipping costs on

Costs item
Enter the article code of the item to book the costs on

Discounts item
Enter the article code of the item to book the discounts on

Tip item
Enter the article code of the item to book the tips on

Desired invoice status, and preference for sending the invoice
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.

Use item ledger accounts
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.

Gift card item
Select the ledger account for gift cards

Exact Online VAT mapping
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.

How do you want to handle VAT for orders to individuals in other EU countries?
Do you ship to individuals in other EU countries? Then you can pick one of the VAT arrangements below. If you want to keep using the rules of before July 1, 2021, select "Charge VAT based on the webshop's country", then the regular VAT of your country will be charged.
​
For more information, please see this Exact article.

Default sales revenue account for 'Unieregeling (OSS)'
Select the default ledger account to book your revenue on in case you make use of the 'Unieregeling (OSS)'.

Country-specific general ledger accounts for OSS?
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)'.

Book revenue
How would you like the revenue to be booked?

Exact Online general ledger mapping
Connect the countries of Shopify to your Exact Online general ledger

Exact Online general ledger mapping
Connect the VAT categories of Shopify to your Exact Online general ledger

Ledger account revenue
Select the default ledger account for sales revenue

Default debtor
If you want to book your orders on a default debtor in Exact Online, enter the code of that default debtor here

Shipping costs ledger account
Select the ledger account for shipping costs

Gift card ledger account
Selecteer de grootboekrekening voor cadeaubonnen

Debtor number for Point of Sale orders
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.

Ledger account POS revenue
Select the default ledger account for POS sales revenue

Service level
Pick a Service level matching your needs. You can always change the it at a later time, and the price will be adjusted accordingly.

Bank journal for payments
Select the bank journal where Shopify Payments transactions should be recorded.<br/
​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.

Ledger account debtors
Select the ledger account for debtors

Ledger account Payment Service Provider costs
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.

General ledger account for payouts
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.

General ledger account for outgoing payments
Select the ledger account for outgoing payments

Book currency differences
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.

Currency difference journal
Select the journal in which currency difference entries should be booked

Ledger account currency differences
Select the ledger account on which to book the currency difference between the sales entry and the payout