Mehrwertsteueränderung 2021 Steueranapassung JTL

VAT changeover 2021: what to do now!

In early summer, the German government decided to temporarily reduce VAT rates from 19 to 16 percent and from 7 to 5 percent from July 1 to December 31, 2020 in order to stimulate the economy during the coronavirus crisis. This required far-reaching adjustments to JTL’s products, about which we have provided information in a detailed blog post.

However, these changes must now be reversed as of January 1, 2021. We’ll tell you here how to do this without having to sit at your computer on New Year’s Eve:

As a retailer, do I have to raise VAT again?

As an entrepreneur, you should ensure that you show the old VAT rates on all your items and invoices as of January 1, 2021. Although a transitional period is being discussed, there are currently no plans to introduce one. Incorrectly displaying VAT rates can result in warnings or tax penalties.

In which JTL solutions can changes occur?

The central adjustments are made in the ERP system JTL-Wawi. This is where you set your tax settings, create invoices, invoice templates and invoice corrections, export data for DATEV and much more. However, your sales channels must also output the old VAT rates on January 1. You may also have to make changes to JTL-eazyAuction, JTL-Shop, JTL-Connector or JTL-POS.

What settings do you need to make in JTL-Wawi?

For all orders that are not shipped on New Year’s Eve, you should increase the VAT from 16 to 19 percent or from 5 to 7 percent on December 31, 2020 after close of business. This is because the decisive factor for the tax office is the day of delivery, not the day of the order!

Then please follow the following video instructions on how to change the VAT rates in JTL-Wawi again.

This will ensure that you automatically receive all sales orders with the back-adjusted VAT, so that you can enjoy the holiday in peace and quiet and then process the orders in the new year with the correct data.

The video tutorial covers the following topics:

  • Exit JTL-Worker & save database – 2:43
  • VAT change – “Global settings“ – 3:39
  • VAT change – Tax administration Simple: “Adjust tax rates“ – 4:07
  • VAT change – Tax key “Check posting accounts“ – 6:47
  • VAT change – Amazon and eBay listings – 7:11
  • VAT change “JTL-Shop“ – 8:26
  • VAT change – “JTL-Connector“ – 8:50
  • VAT change – “JTL-POS“ 10:09
  • Explanation ant: “Keep gross prices“ – 10:49
  • Export gross prices – 11:19
  • Import gross prices – 12:33
  • RRP – Special prices – Configurator – 14:00
  • Supplier article export: “Customize supplier article“ – 14:29
  • Manually convert sales orders – 15:58
  • Change sales orders with workflow – 16:41
  • Taxing partial deliveries correctly – 18:59
  • Change subscriptions – 20:16
  • FAQ – Output service date on the invoice – 20:47
  • FAQ – Change shipping methods: “FBA orders“ – 22:46
  • FAQ Invoice corrections – 23:34
  • FAQ Amazon VCS – 23:53

Your questions about the VAT changeover 2021 answered in the JTL forum

If you have individual questions about the VAT changeover in 2021, the JTL forum is your first port of call. Our Product Owner JTL-Wawi, Manuel Pietzsch, already created his own thread here during the first changeover, in which he answered all your questions.

VAT discussion in the JTL forum

Guide with step-by-step instructions

Our documentation team has created a detailed guide for you with the help of our support team. There you can read how to make the necessary settings in JTL-Wawi, JTL-eazyAuction, JTL-Shop, JTL-Connector and JTL-POS.

Settings in the ERP system

  1. Create a backup of your database: Please follow the instructions in the JTL-Guide.
  2. Disables the JTL-Worker (menu Admin > Automation: JTL-Worker > Uncheck “enable for this client” > OK)
  3. Closes the JTL-Worker program.
  4. Do not make any manual adjustments in JTL-Wawi while you are making the adjustments for the VAT reduction.
Step 1: Export gross prices with JTL-DataTransfer
  1. Open the export in JTL-DataTransfer and select the option “Item data” under “Export from” under “Items”.
  1. In the “Field in database” area in the “ID columns” section, add the “SKU” field to the “These fields are exported” list by double-clicking on it.
Bruttopreise beibehalten Schritt 2
  1. Under “Prices / Tax”, double-click to add the field “Gross hourly sales”.
  2. Now add all other relevant gross prices from the following sections:
    – Wawi customer group prices
    – Wawi graduated prices
    – Wawi special prices
    SPECIAL PRICES: For special prices, you must include the start date in the export list, otherwise you will not be able to re-import the special prices.
    STAFFED PRICES: For graduated prices, you must include the “Quantity from” field in the export list, otherwise you will not be able to re-import the graduated prices.
  3. Once you have transferred all the relevant gross prices to the export list, click on “Start export”.
  4. The “Export process – Client: (your client name)” window opens. Click on Start export again.
  5. Select the storage location for the export file and click on “Save”.
  6. Waits until the export has been successfully executed and returns to JTL-DataTransfer via the “Back” button.
Step 2: Export customer-specific gross prices with JTL-DataTransfer (if available, if not, continue with step 3)
  1. If you are working with customer-specific prices, select the option “Customer-specific prices” under “Customers” in the “Export from” area on the left.
  2. Double-click on all relevant gross prices and click on “Start export”.
  3. The “Export process – Client: (your client name)” window opens. Click on “Start export” again.
  4. Select the storage location for the export file and click on “Save”.
  5. Waits until the export has been successfully executed and returns to JTL-DataTransfer via the “Back” button.
Step 3: Change tax rates in JTL-Wawi
  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  1. Double-click on the “Normal tax rate” entry to open the tax rate settings.
Normaler Steuersatz
  1. In the “Tax rate in %” field, change the tax rate from 16 to 19 and click on “Save”.
Steuersatz ändern
  1. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  2. In the “Tax rate in %” field, change the tax rate from 5 to 7 and click on “Save”.
  3. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.
Step 4: Import gross prices with JTL-DataTransfer
  1. Open the import in JTL-DataTransfer and select the option “Item data” under “Import from” under “Items”.
  2. Now use the “Select” button to select the previously exported file with the gross prices and click on “Open”.
  3. Click on the “Load file” button at the top left in JTL-DataTransfer.
  4. The gross prices are automatically recognized and assigned.
  5. If you use customer group prices, now select the “Customer group prices” tab and assign the prices there manually (from JTL-Wawi version 1.5.24.0 JTL-DataTransfer can assign customer group prices automatically). If you do not use customer group prices, continue with point 9.
  6. To assign a customer group price, double-click on the light red “not assigned” field to activate the drop-down menu and right-click again to open it.
  7. Selects the price to be adopted for the customer group on the specified platform.
  8. Then change the value “Net” to “Gross” in the right-hand column. To do this, double-click the drop-down menu again and open it with a right-click.
  9. Repeat points 6-8 until you have assigned all customer group prices.
  10. If you use graduated prices, select the “Graduated prices” tab and assign the prices manually (from JTL-Wawi version 1.5.24.0 JTL-DataTransfer can assign graduated prices automatically). If you do not use graduated prices, continue with point 15.
  11. To assign a scale price, double-click on the light red “not assigned” field to activate the drop-down menu and right-click again to open it.
  1. Selects the scale price to be used for the customer group on the specified platform.
Bruttopreis Mit Ameise Importieren Schritt 12
  1. Manually assigns the “Scale (X) from quantity” column.
  1. In the right-hand column, change the value “Net” to “Gross”. To do this, double-click the drop-down menu again and right-click to open it.
Bruttopreis Mit Ameise Importieren Schritt 13
  1. Repeat points 11-13 until you have assigned all scale prices.
    You can find detailed instructions on importing scale prices in the JTL-Guide under Importing scale prices with JTL-DataTransfer.
  2. Click on “Start import”. The “Import process – client (your client name)” dialogue box opens.
  3. Click on “Start import process”. The old gross prices are imported.
  4. Waits until the export has been successfully executed and returns to JTL-DataTransfer via the “Back” button.

In JTL-Wawi, the imported gross prices are now displayed with the correspondingly adjusted net prices in your items.

Step 5: Import customer-specific gross prices with JTL-DataTransfer (if available)
  1. Open the import in JTL-DataTransfer and select the option “Customer-specific prices” under “Import from” under “Customers”.
  2. Carry out points 1-4 and, if graduated prices exist, points 10-17 from step 4.

In JTL-Wawi, the imported customer-specific gross prices are now displayed with the correspondingly adjusted net prices in your items.

In this case, you must adjust the VAT manually in JTL-Wawi. To do this, you can set up a workflow that ensures that these sales orders are automatically set to “On hold” status. Optionally, you can then be informed by email about the affected sales orders so that you don’t forget to adjust them.

Preparation

If you are not yet working with workflows, you must first uncheck “Disable all workflows” in the window at the bottom left in the menu “Admin > Global settings > Tab: Debug”.

Create workflow
  1. Opens the “Create/edit workflows” dialogue box in JTL-Workflows via the “Admin > Workflows” menu.
  2. Select the “Sales orders” area and mark “Created” on the left-hand side under Orders.
  1. Click on the “Create workflow” button
Kauf Vor Steuersenkung Workflow Schritt 3
  1. Click on “New condition” and select “Date/Now” > “Greater than or equal to” > “Wednesday, January 1, 2021” from the drop-down menu that now appears. This condition checks for sales orders whose purchase took place before 01.01.2020.
Kauf Vor Steuersenkung Workflow Schritt 4
  1. Click on “New condition” again and select “Order\Master data\Creation date” > “Less than” > “Wednesday, July 1, 2020”.
    These conditions now check for sales orders whose purchase took place before 01.07.2020, but which were only created in JTL-Wawi after 01.01.2021.
Kauf Vor Steuersenkung Workflow Schritt 5
  1. Now click on “New action” in the lower area and select “Hold/share” in the drop-down menu and “Check required” under Operation so that the affected sales orders are automatically set to “Held” status.
Kauf Vor Steuersenkung Workflow Schritt 6
  1. Optional: Add another action via “New action” and select “Send email” from the drop-down menu. Enter the email address of the employee who is to check the sales orders and write a meaningful subject and text. You can add the variable for the sales order ID via the drop-down menu for faster assignment. As soon as an affected sales order has been set to “On hold” status by the workflow, the stored recipient is informed by email.
Kauf Vor Steuersenkung Workflow Schritt 7
  1. Finally, click on “Save” to activate the workflow.

    Thanks to the workflow, the affected sales orders are automatically set to “On hold” status and you or one of your employees will receive an email as information. You can find the orders in the order overview in the “Sales” area in the “On hold” folder and can manually adjust the VAT for each order there.
Kauf Vor Steuersenkung Workflow Schritt 8

A change to the invoice is not possible according to GoBD, so the invoice must be written off with an invoice correction.

Follow the instructions in the JTL-Guide: Create invoice correction

You can then create a new sales order with the correct VAT rates and reissue the invoice.

Initial situation: You have already adjusted your tax rates to the reduced VAT. After January 1, 2021, you would like to subsequently export booking data with JTL-DataTransfer for the period up to the end of December 2020. In this case, you must reduce your tax rates for the duration of the export back to the 16% or 5% applicable in the second half of 2020.

Step 1: Change tax rates in JTL-Wawi to 16% or 5%
  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  3. Double-click on the “Normal tax rate” entry to open the tax rate settings.
  4. In the Tax rate in % field, change the tax rate from 19 to 16 and click on “Save”.

  5. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  6. In the Tax rate in % field, change the tax rate from 7 to 5 and click on “Save”.

  7. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.
Step 2: Export booking data with JTL-DataTransfer
  1. Select your usual booking data export in JTL-DataTransfer.
  2. In the invoice filter, select the setting “Observe invoice date (TARGET)”.
  3. Set your settings for the booking data export as agreed with your tax advisor.
  4. Executes the export.
Step 3: Change tax rates in JTL-Wawi to 19 % or 7 %
  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  3. Double-click on the “Normal tax rate” entry to open the tax rate settings.
  4. In the Tax rate in % field, change the tax rate from 16 to 19 and click on “Save”.

  5. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  6. In the Tax rate in % field, change the tax rate from 5 to 7 and click on “Save”.

  7. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.

Initial situation: You export your accounting data according to actual taxation. Your aim is to show if invoices were created before 1.1.2021 and payment was only received after 1.1.2021. In order for the booking data export to work for the tax rates of 19% and 7% as well as the previous tax rates of 16% and 5%, you must store the old and new tax rates in the tax administration of JTL-Wawi.

Step 1: Create new 19% and 7% tax keys
  1. Opens the “Control key” dialogue box via the menu “Admin > Taxes > Control key”.
  2. Click on “Add” to create a new tax key for “VAT 19%”. Enter the details for this tax key.
  3. Click on “Add” to create a new tax key for “VAT 7%”. Enter the details for this tax key.
  4. Click on “Save”.
Step 2: Change tax rates and tax keys for standard tax rates in the tax administration
  1. In the “Admin” menu, open the item “Taxes > Tax administration”. The “Tax administration” dialogue box opens.
  2. Select “Zone-EU” under “Control settings”.
  3. Double-click to open the “Normal tax rate” tax class. The “Define tax rates and tax keys for tax class Normal tax rate in tax zone Zone-EU” dialogue box opens.
  4. Increases the value for “Tax rate in %” from 16 to 19.
  5. Under “Tax key”, replace the entry “VAT 16 %” with “VAT 19 %”.
  6. Click on “Save”.
  7. Double-click to open the “Reduced tax rate” tax class. The “Define tax rates and tax key for reduced tax rate tax class in tax zone Zone-EU” dialogue box opens.
  8. Increases the value for “Tax rate in %” from 5 to 7.
  9. Under “Tax key”, replace the entry “VAT 5%” with “VAT 7%”.
  10. Click on “Save”.
  11. Close the tax administration by clicking on “Save”.
Step 3: Change tax rates and tax codes for the transitional tax brackets in the tax administration
  1. In the “Admin” menu, open the item “Taxes > Tax administration”. The “Tax administration” dialogue box opens.
  2. Select “Zone-EU” under “Control settings”.
  3. Select your transitional tax rate for 19% VAT and click on “Edit”.
  4. The “Define tax rates and tax key for tax class in tax zone Zone-EU” dialogue box opens.
  5. Enter the value 16 for “Tax rate in %”.
  6. Under “Tax key”, select the entry “VAT 16 %”.
  7. Click on “Save”.
  8. Select your transitional tax rate for 7% VAT and click on “Edit”.
  9. The “Define tax rates and tax key for tax class in tax zone Zone-EU” dialogue box opens.
  10. Enter the value 5 for “Tax rate in %”.
  11. Under “Tax key”, select the entry “VAT 5%”.
  12. Click on “Save”.
  13. Close the tax administration by clicking on “Save”.
Step 4: Export booking data with JTL-DataTransfer
  1. Select your usual booking data export in JTL-DataTransfer.
  2. In the invoice filter, select the setting “Observe payment date (ACTUAL)”.
  3. Set your settings for the booking data export as agreed with your tax advisor.
  4. Executes the export.
  1. Marks all items in the item overview whose prices are to be smoothed.
  1. Left-click to open the context menu and select “Calculate prices”. The “Calculate/adjust prices” dialogue box opens.
Preise glätten Schritt 2
  1. Opens the “Price smoothing” tab.
Preise glätten Schritt 3
  1. Make the appropriate settings for your prices.
  1. Click on the “Calculation preview” button to check your adjustments.
Preise glätten Schritt 5
  1. If all settings are correct, click on “Save” to smooth the prices according to your settings.
  1. Activates the JTL-Worker (menu Admin > Automation: JTL-Worker > Check “activate for this client” > OK).
  2. Once you have completed your adjustments for the VAT reduction, you can also carry out manual adjustments again.

Settings for the sales channels

The prices on Amazon and eBay are not automatically changed when the tax rate is changed. You can adjust the prices for Amazon and eBay with JTL-DataTransfer.

Customize prices for Amazon with JTL-DataTransfer

Step 1: Export prices
  1. Opens the “Export” dialog in JTL-DataTransfer.
  2. Under “Export from”, select the entry “Amazon offer update”.
  3. Under “Field in database”, double-click at least the fields “Marketplace”, “Account”, “Amazon SKU” and “New price”.
  4. Click on “Start export”.
Amazon Preise aktualisieren Schritt 1
Step 2: Calculate prices
  1. Open the exported file with a calculation program and calculate your new prices in the “New price” column.
Step 3: Import prices
  1. Opens the “Import” dialog in JTL-DataTransfer.
  2. Under “Import from”, select the entry “Change Amazon listings”.
  3. Check whether the columns “Marketplace”, “Account”, “Amazon SKU” and “Price New” have been assigned automatically and make the assignment manually if necessary.
  4. Click on “Start import”.
Amazon Preise Aktualisieren Schritt 3
Step 4: Carry out an Amazon comparison
  1. Starts the Amazon comparison in JTL-Wawi to transfer the new prices to Amazon.

Further information can be found in the JTL-Guide: Edit Amazon listings with JTL-DataTransfer

Customize prices for eBay with JTL-DataTransfer

Step 1: Export prices
  1. Opens the “Export” dialog in JTL-DataTransfer.
  2. Under “Export from”, select the entry “eBay listing update”.
  3. Under “Field in database”, double-click at least the fields “Listing ID” and “Purchase price”.
  4. Only if you work with variation combinations (Varkombis): Under “Field in database”, also select the fields “Assigned SKU combination” and “SKU combination price”.
  5. Only if you are working with variation combinations (Varkombis): Select the “Variation data” entry in the “Other export data” drop-down menu.
  6. Click on “Start export”.
eBay Preise aktualisieren Schritt 1
Step 2: Calculate prices
  1. Open the exported file with a calculation program and calculate your prices in the “Purchase price” and “Varkombi price” columns.
Step 3: Import prices
  1. Opens the “Import” dialog in JTL-DataTransfer.
  2. Under “Import from”, select the entry “Change eBay listings”.
  3. Check whether the columns “Listing ID”, “Purchase price” and, if using Varkombis, also the columns “Assigned Varkombi SKU” and “Varkombi price” have been assigned automatically and, if necessary, make the assignment manually.
  4. Click on “Start import”.
Ebay Preise Aktualisieren Schritt 3
Step 4: Perform eBay comparison
  1. Starts the eBay synchronization in JTL-Wawi to transfer the new prices to eBay.

The VAT increase has no effect on Amazon. The tax rate is applied when the order is created, so the net prices are automatically higher. If you want to pass on the VAT increase to your customers, you can update the Amazon prices via JTL-DataTransfer.

Please note that Amazon Business prices apply to the B2B customer group.

You can read how to do this in the instructions Adjust prices on Amazon with JTL-DataTransfer.

Tax rates and prices in JTL-Shop are controlled via JTL-Wawi. However, simply changing the tax rates is not enough.

In the following, we will show you three methods on how you can proceed to customize tax rates in JTL-Shop in the best possible way.

Method 1: Standard procedure

Suitable and recommended for: JTL-Shops of all versions whose synchronization of all items (no categories, images etc.) is run through in a time acceptable to you.

  1. Stops the adjustment.
  2. Adjust the tax rates in JTL-Wawi (and item prices if you want to keep the gross prices).
  3. In the complete synchronisation settings, check the Global data and items box.
  4. Activates the maintenance mode in JTL-Shop at the latest now or at the deadline.
  5. To be on the safe side, carry out a JTL-Shop database backup or have it carried out (see also our guide article on this. JTL hosting customers can follow step 2, option 2).
  6. Starts the adjustment.
  7. Wait for the end of the adjustment.
  8. Checks the items (and clears the item cache if necessary).
  9. Exits maintenance mode.
Optional method 2: Directly via the JTL-Shop database

Suitable for: JTL-Shops of all versions whose synchronization of all items (no categories, images etc.) would mean too long a downtime for you. Tax rates taken into account: 16 % → 19 % and 5 % → 7 %

IMPORTANT: Only suitable for JTL-Shop with standard tax settings (tax headquarters in Germany).

IMPORTANT: Item, scale and special prices for all customer groups (who have not activated net price display) are taken into account. Two special cases are NOT taken into account:

  • Different configurator prices: If you use fee-based configurator components that are not linked to items or linked components with different item prices, these will not be adjusted by the snippet. After you have changed the prices via Ant, they are synchronized via the global data (online store > Complete synchronisation settings column “Global data”). This should be relatively quick.
  • Surcharges for the old variations (variation combinations are normal item prices and are therefore taken into account)
  1. Stops the adjustment.
  2. Adjust the tax rates in JTL-Wawi (and item prices if you want to keep the gross prices; use QuickSync in JTL-DataTransfer).
  3. Activates the maintenance mode in JTL-Shop at the latest now or at the deadline.
  4. To be on the safe side, carry out a JTL-Shop database backup or have it carried out (see also our guide article on this. In this case, JTL hosting customers can follow step 2, option 2).
  5. Sends the SQL commands from the following snippet directly to the JTL-Shop database. (Recommendation: send commands directly via the console).
    IMPORTANT: Everything from line 9 in the snippet only if you want to keep the gross prices.
    Note: All customer groups for which the net price display is activated in JTL-Wawi will not receive adjusted net prices! https://gitlab.com/jtl-software/jtl-shop/core/snippets/1987972
  6. Start the adjustment. (If you have not adjusted any prices in JTL-Wawi, the adjustment should only take a few seconds).
  7. Checks the items (and clears the item cache if necessary).
  8. Exits maintenance mode.
  9. If you have adjusted prices in JTL-Wawi, let the adjustment run in peace while the shop is already finished.
Optional method 3: We provide a small plugin - JTL-USt-Changer

Suitable for: JTL-Shop (only version 4.06.x and PHP version at least 7.0), whose synchronization of all items (no categories, images etc.) would mean too long a downtime for you.

IMPORTANT: Only suitable for JTL-Shop with standard tax settings (tax headquarters in Germany)

IMPORTANT: Item, scale and special prices for all customer groups (who have not activated net price display) are taken into account. Two special cases are NOT taken into account:

  • Different configurator prices: If you use fee-based configurator components that are not linked to items or linked components with different item prices, these will not be adjusted by the plugin. After you have changed the prices via Ameise, they are synchronized via the global data (online store > Complete synchronisation settings column “Global data”). This should be relatively quick.
  • Surcharges for the old variations (variation combinations are normal item prices and are therefore taken into account)

Note: If you want to keep the gross prices, this is possible with the plugin, but all customer groups for which the net price display is activated in JTL-Wawi will not get adjusted net prices with the plugin!

  1. Preparation: Download the plugin and install it in the JTL-Shop, but do not do anything yet.
  2. Stops the adjustment.
  3. Adjust the tax rates in JTL-Wawi (and item prices if you want to keep the gross prices; use QuickSync with JTL-DataTransfer).
  4. Activates the maintenance mode in the JTL-Shop at the latest now or at the deadline.
  5. For security reasons, carry out a JTL-Shop database backup or have it carried out (see also our guide article on this. JTL hosting customers can follow step 2, option 2).
  6. Make the corresponding changes in the plugin for all your affected tax rates:
    To do this, enter the old VAT rate and the new VAT rate one after the other for all used and affected tax rates under “Old VAT” and “New VAT” without the % sign (of course, only use the “Keep gross prices” option if you have also adjusted your prices in JTL-Wawi accordingly! Note regarding net price display!) and click on “Perform update” (button only functional if maintenance mode is active).
  7. Start the adjustment. (If you have not adjusted any prices in JTL-Wawi, the adjustment should only take a few seconds).
  8. Checks the items (and clears the item cache if necessary).
  9. Exits maintenance mode.
  10. If you have adjusted prices in JTL-Wawi, let the adjustment run in peace while the shop is already finished.
Download the plugin in the forum
Empty item cache:Cache leeren im JTL-Shop

We recommend that you check all texts in your online shop (general terms and conditions, item descriptions, etc.) to ensure that the correct VAT rates and percentages are entered everywhere.

Step 1: Adjust tax rate in the JTL-Customer Centre
  1. Log in to the JTL-Customer Centre.
  1. Opens the settings for Shopify under Licenses > JTL-Connector
Mehrwertsteuer für Shopify-Connector im Kundencenter einstellen
  1. Changes the tax rates in the “VAT rates comma-separated” field.
Mehrwertsteuer beim Shopify-Connector senken
  1. Click on the “Test connection/activate license” button.
Step 2: Change tax rates in JTL-WawiOption 1: Maintain gross prices

Carry out steps 1-5 from “Question 1 – How do I keep my gross prices?” as described.

Option 2: Pass on tax savings to your customers:

In this case, you only need to adjust your tax rates.

  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  1. Double-click on the “Normal tax rate” entry to open the tax rate settings.
Normaler Steuersatz
  1. In the “Tax rate in %” field, change the tax rate from 16 to 19 and click on “Save”.
Steuersatz ändern
  1. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  2. In the “Tax rate in %” field, change the tax rate from 5 to 7 and click on “Save”.
  3. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.

The net prices are now calculated using the new tax rates.

Step 3: Transfer tax rates and prices to the connector online store

Carry out a complete synchronisation for your items via the online store synchronization (menu online store > Complete synchronisation > Check “Items”).

Step 1: Customize the tax rate in the connector online store
  1. Adjust your tax rates in the back end of your online store.
  2. Opens the dialogue box “Overview of your online stores” in the menu “Online store > Online shop connection” in JTL-Wawi.
  3. Select your online store in the list and click on the “Edit” button. The “Online store integration” dialogue box opens.
  1. Click on the “Test connection/activate license” button.
Verbindung Testen | Lizenz Aktivieren
Option 1: Maintain gross pricesStep 2: Change tax rates in JTL-Wawi

Carry out steps 1-5 from “Question 1 – How do I keep my gross prices?” as described.

Option 2: Pass on the tax increase to your customers:

In this case, you only need to adjust your tax rates.

  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  1. Double-click on the “Normal tax rate” entry to open the tax rate settings.
Normaler Steuersatz
  1. In the “Tax rate in %” field, change the tax rate from 16 to 19 and click on “Save”.
Steuersatz ändern
  1. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  2. In the “Tax rate in %” field, change the tax rate from 5 to 7 and click on “Save”.
  3. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.

The net prices are now calculated using the new tax rates.

Step 3: Transfer tax rates and prices to the connector online store

Carry out a complete synchronisation for your items via the online store synchronization (menu online store > Complete synchronisation > Check “Items”).

JTL-POS ERPConnected

Preparation
  1. Create a backup of your database: https: //guide.jtl-software.com/jtl-wawi/datenbank/datenbank-backup-erstellen/
  2. Create a backup of your JTL-POS database: https: //guide.jtl-software.com/jtl-pos/import-export/datenbank-sichern/
  3. Disables the JTL-Worker (menu Admin > Automation: JTL-Worker > Uncheck “enable for this client” > OK).
  4. Closes the JTL-Worker program.
  5. Closes the JTL POS server.
  6. Do not make any manual adjustments in JTL-Wawi while you are making the adjustments for the VAT reduction.
How do I change my tax rates and keep my gross prices?
  1. Carry out steps 1-5 from “Question 1 – How do I keep my gross prices?” as described.

In JTL-Wawi, the imported gross prices are now displayed with the correspondingly adjusted net prices in the items and transferred to JTL-POS with the next reconciliation.

How do I change my tax rates and pass on the tax savings to my customers?Step 1: Change tax rates in JTL-Wawi
  1. Opens the “Tax administration” dialogue box in JTL-Wawi via the menu “Admin > Taxes > Tax administration”.
  2. Mark “Zone EU” on the left under the tax settings.
  1. Double-click on the “Normal tax rate” entry to open the tax rate settings.
Mehrwertsteuer für Shopify-Connector im Kundencenter einstellen
  1. In the “Tax rate in %” field, change the tax rate from 16 to 19 and click on “Save”.
Steuersatz ändern
  1. Double-click on the “Reduced tax rate” entry to open the settings for the reduced tax rate.
  2. In the “Tax rate in %” field, change the tax rate from 5 to 7 and click on “Save”.
  3. Click on “Save” in the “Tax management” dialogue box that is still open to apply the changes.

The net prices are now calculated using the new tax rates.

Step 2: Recalculate prices for JTL-POS

To have the prices recalculated according to the new tax rate, you must disable and re-enable all items in JTL-POS once.

  1. Opens the “Items” area in JTL-Wawi.
  1. If you manage your JTL-POS items in your own categories or in a root category, you can disable these category(ies) for JTL-POS (Edit category > “General” tab > In the “Online shops/JTL-POS” area, uncheck the box for your JTL-POS branch(es) > Save).
    If you need to disable your items individually for JTL-POS, you can find the settings in the item master data in the “Online shops/JTL-POS” tab.
Preise für JTL-POS neu berechnen Schritt 2.1Preise Fuer Jtl Pos Neu Berechnen Schritt 2 2
  1. Activate your POS server.
  2. Wait for the next synchronization. Your items must all disappear from JTL-POS once.
  3. Then reactivate your items/categories for JTL-POS (don’t forget to save!).

With the next synchronization, the items with the updated prices are transferred back to JTL-POS.

JTL-POS StandAlone

In JTL-POS you have to change the tax rates manually under “Settings > Tax rates”. The tax rates in your items will be automatically adjusted after saving. This will not change your gross prices. If you use DATEV, discuss any necessary changes to your DATEV accounts stored under “Settings > Tax rates” with your tax advisor.

JTL-POS Standalone Steuersatz ändern
How do I keep my gross prices?

Since JTL-POS works on the basis of gross prices, your gross prices remain the same even if you change your tax rates as described above.

How do I pass on the tax increase to my customers?

If you want to pass on the tax increase to the customer in the form of higher prices, you must adjust your prices manually after changing the tax rates. The quickest way to do this is via CSV import/export. If you only have very few items, you can also adjust the prices manually. To change the prices via CSV import/export, proceed as follows:

  1. First export a CSV file with your item data (Import/Export (CSV) menu >Data export Data category: Items > Select folder > Start data export).
  2. Opens the CSV file and changes the tax rates in column M (Tax Rate).
  3. Change your gross price in column 0 (Price).
    Attention! Please do not make any further changes to the column names or their order, otherwise the file cannot be re-imported!
  4. Now import your file back into JTL-POS (Import/Export (CSV) menu >Data import > Data category: Items > Select folder > Select file > Start data import). Your adjusted prices will be imported into JTL-POS.

JTL-POS General

What happens if a customer buys something before the changeover and returns it after the changeover?

The tax rate at which the customer made the purchase is permanently stored in the closed receipt. Changes to the tax settings no longer have any effect on closed receipts. So if the customer purchased something at 16% VAT before the tax rate changeover and returns the goods on 02.01.2021 after the changeover, for example, they will be refunded the 16% VAT applicable to the purchase, even if the tax rate has been changed in the settings.

This article does not replace tax or legal advice and is only intended to provide you with initial guidance. If you are unsure, we recommend that you seek independent specialist advice to ensure compliance with the applicable laws and regulations.

Published on:
16. December 2020
Category
Interesting facts
Topics
Manuel Pietzsch
Manuel

Product Owner JTL-Wawi

Categories
Topics
Marketing (28)JTL-DataTransfer (3)JTL-Wawi (128)Support (10)JTL-POS (21)JTL-WMS (24)countX (7)Shipment tracking (7)JTL-Workbench (4)
All Topics
Blog Archive Previous posts
Social Media