
Accounting
Learn more about settings in plentymarkets that are relevant for your accounting. These settings include VAT rates, currencies, exchange rates, the calculation of your prices, booking keys, revenue accounts, debtor accounts and just as well your document templates. Most of the settings that are relevant for accounting purposes can be defined per accounting location. Only the setting that defines how your prices are calculated applies to your entire system.
How to set up document templates is described on a different page of this manual.
1. Basic information about price calculation in plentymarkets
The calculation of prices is based on the gross prices of your variations. In other words, the net price of a variation in an order is calculated based on the gross price. To get the sum of an order item the individual price of one variation is multiplied with purchased number of the variation. This means, that the purchased number of a variation is multiplied with the individual gross price of an order item to get the order item’s gross sum. To get the net sum of an order item the previously calculated net price of a single variation is multiplied by the number of variations purchased. The number of decimal places of the single net price is defined by your accounting settings. To get the VAT amount for an order item the net sum must be substracted from the gross sum.
Your settings define when the price will be rounded to decimal places. Calculations that are carried out after the prices are rounded will be carried out with 2 decimal places. The settings in plentymarkets can lead to the following results:
-
Rounded single variation price
-
Rounded order item sums
-
Rounded totals
2. Setting up how prices are saved and rounded
The path to the menu that contains the settings plus explanations of the settings. The settings applied to an order are the settings that were active in the moment that the order was created. This means that if you change the settings the changes will not affect existing orders.
Setting up how prices are saved and rounded:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
The Basic settings tab will open. -
Carry out the settings as desired. Pay attention to the information given in Table 1.
-
Save the settings.
Setting | Explanation |
---|---|
Number of decimal places for prices |
Select 2 or 4 decimal places |
Round totals only |
Activate by placing a check mark if you want that only the totals of an order are rounded. The sums of order items are no longer rounded by default if the setting is active. Totals refers to the total value of an order. When you look at the settings of the document template for invoices the settings that will be affected are the ones that are listed unter the sums heading. |
2.1. Example calculations
The following section compares the different calculation methods and the results.
In our example fabrics were sold. Several panels of the same fabric were bought, but with different widths. The widths are 50 cm and 30 cm. The 50 cm panel was boungt 8 times and the 30 cm panel 7 times. 30 centimetres cost € 2.187 and 50 centimetres cost € 3.645. The prices are calculated based on a price of € 7.29 per metre. The settings that must be carried out to get one of the results are also listed in the table.

3. Carrying out VAT settings
The VAT settings are specifically for one location. You can have different settings for each location. Locations are required for your registered business addresses or countries that you ship from. There are two locations per default in your system. These locations are Germany and United Kingdom. You need your own locations for the productive mode of your system.
Your system behaves a little differently for countries that are members of the European Union and non-EU countries. For a location in an non-EU country every delivery to another country will be treated as export shipping. For shippings from EU member state locations the system differs between intra-community shipping and export shipping.
The basic VAT relevant settings include settings that define how the system reacts for export shipping and how the VAT amount for shipping costs will be displayed. For EU locations you can also define how the system reacts if a VAT ID is given in the order.
If you are about to or already have passed a delivery threshold you need to open your existing location and set up a new VAT configuration for that country within the location. Do not create a new location if for countries where you pass the delivery threshold.
Do not use the example locations for real orders
The two locations, Germany and United Kingdom, are examples and are not meant for use in productive mode. It is best if you set up our own locations or at least edit the existing locations. When editing the existing locations you need to add at least a new VAT configuration with your correct VAT number and the correct VAT rates. |
3.1. Creating a new location
Proceed as described below to create a new location. Furthermore you need to set one location as your Default location. Your default location is so to say your head office.
Creating a new location:
-
Go to System » Client » Select client » POS.
-
Move your cursor over the menu item Locations.
→ An arrow will be displayed on the right. -
Click on the Arrow.
→ The option New location will appear. -
Click on New Location.
→ An editing window will open. -
Enter the name of the new location.
-
Select the new location’s Country from the drop-down list. → Only active countries of delivery can be selected.
-
Save the settings. → The location is added to the list of locations.
Each location has the following 3 submenus: * Settings * Accounting and * Documents
The settings submenu contains the ID, the name and the country of a location. The accounting submenu is devided into several tabs and the settings in those tabs ared described in detail on this page starting with the Using the German small business owner regulation. In the documents submenu you can set up documents per accounting location e.g. the delivery note or invoice.
3.2. Deleting a location:
You must always have one location. You can only delete a location if there is at least one other location in this menu as well. It is not possible to delete the Default location.
Deleting a location:
-
Go to System » Client » Select client » POS.
-
Open the location that you want to delete and click on the Settings submenu.
-
Click on Delete.
→ Confirm the security question to delete the location.
3.3. Using the German small business owner regulation
If you are a small business owner in Germany and you do not want that VAT is applied to your invoices, then activating the setting in your location settings is all you need to do. However, even though you the VAT is not applied, you still need to save the correct VAT rates in your settings. They will not be applied.
Small business owner setting only for systems with Germany as system country
The small business owner setting is only available if your system was set up with Germany as system country. The system country is a setting that you can not access and that is selected based on the information that you provide when you order your plentymarkets system. |
Using the German small business owner regulation:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Place a check mark next to the option Small business owners (Germany only).
-
Save the settings.
Displaying small business owner information on invoices
As a small business owner you need to place information on your invoice why there was no VAT applied. You can use the note field on your invoice template for this information. The setting for small business owners does not automatically place a note on your invoice. |
3.4. Setting up how invoices are issued for deliveries within the EU
You can choose whether customers that are within the European Union and that have a VAT number will receive a net invoice or a gross invoice. In many cases the information of the delivery’s recipient are of higher priority than the ones of the invoice’s recipient. The delivery address must be in another country within the EU if you want the invoice to be net. For deliveries within the same member state of the EU the setting will be ignored and VAT will always be applied. However, there is one option that will allow a different result. You need to add an entry certificate to your delivery and you need to choose the entry certificate option for the delivery address within the data set of an order. If the customer does not have a VAT number, this means that it is a private purchase and that VAT will be applied anyway. The only time VAT will not be applied for private purchases is if you are a small business owner as described above.
Setting up gross or net invoices for deliveries within the EU:
-
Select a location under System » Client (store) » Select store » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Select one option from the VAT number drop-down list. Pay attention to the information given in Table 2.
-
Save the settings.
Setting |
Explanation |
VAT number |
Only applies to deliveries within the EU. |
3.4.1. Examples with the settings' effect
In the following section 6 possible setting combinations and the effects are described.
What is the result if the sender, the delivery’s recipient and the invoice recipient are in the same member state of the European Union and if the setting net invoice is selected?
The invoice will always be gross despite the selected setting.
What is the result if the sender and the delivery’s recipient are in the same member state of the European Union, but the invoice recipient is in a different member state and if the setting net invoice is selected?
The invoice will be gross despite the selected setting. However, in this case a net invoice is actually allowed if the invoice recipient has a VAT number. An additional setting must be carried out to issue a net invoice. The entry certificate must be activated in the delivery adress data of the order. The invoice will be gross as long as the entry certificate setting is not activate. The entry certificate is an individual delivery address setting.
What is the result if the sender and the invoice recipient are in the same member state of the European Union, but the delivery’s recipient is in a different member state and if the setting net invoice is selected?
The invoice will be net if the recipient of the delivery has a VAT number. The invoice recipient does not play a role in this scenario.
What is the result if the sender is in one member state of the European Union, but the invoice recipient and the delivery’s recipient are in a different member state and if the setting net invoice is selected?
The invoice will be net as soon as either the recipient of the delivery or the recipient of the invoice has a VAT number. The invoice will be gross if neither the recipient of the delivery nor the recipient of the invoice has a VAT number.
What is the result if the sender is in one member state of the European Union, but the delivery’s recipient is in a different member state and the invoice recipient is in a country outside of the EU and if the setting net invoice is selected?
The invoice will be net as soon as either the recipient of the delivery or the recipient of the invoice has a VAT number. The invoice will be gross if neither the recipient of the delivery nor the recipient of the invoice has a VAT number.
What is the result if the sender is in one member state of the European Union, but the invoice recipient is in a different member state and the delivery’s recipient is in a country outside of the EU and if the setting net invoice is selected?
In this case the delivery is an export shipment and the setting setting for export shipping will be applied. The settings for export shippings will be explained in the next section on this page.
3.5. Issuing an invoice for export shipments
For each accounting location you can individually define, whether the invoice for export shipments will be net or gross. The core assumption is that your business is based in the European Union. The setting will be applied if the delivery is sent to a country outside the European Union. Your customers receive an invoice without VAT if the invoice is net.
Setting up gross or net invoices for export shipping:
-
. Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Select one option from the export shipping drop-down list. Pay attention to the information given in Table 3.
-
Save the settings.
Setting |
Explanation |
Export shipping |
Net invoice = Invoices for export shipping will be issued without VAT. |
3.6. Setting up VAT rates
You need to differ between your accounting locations and countries of deliveries that you need to pay tax to. An accounting location is a registered business address. 2 accounting locations exist per default in plentymarkets. The default locations are Germany and United Kingdom. You need one location at the very least and you can add further locations for each of your subsidiaries. The 2 default locations include default VAT configurations with VAT rates etc. However, do not use these configurations for the productive mode of your system. Add your own configurations and delete the default ones. You need to set up at least one configuration. You can use this configuration to ship worldwide. However, you need to add further configurations for other countries if you exceed the delivery theshold for a country. Otherwise the system can not calculate the correct VAT amounts. You need to set up a location for your registered business address and then you need to set up the country that the business is in with a VAT configuration. Once you become liable for taxation in other countries because you exceeded the delivery threshold, you need to add futher countries with VAT configurations within the same location.
Information from the German Federal Central Tax Office
For Germany, the Federal Central Tax Office provides tax information about the European countries of delivery as well as the USA and Japan. |

Replacing the default VAT rates and locations
The VAT configurations shown in Figure 2 is a default configuration and contains a fantasy VAT number. This VAT number is not yours and is not correct and that is why you need to set up your own configuration with a correct VAT number. You can delete the default configuration. |
Setting up VAT rates:
-
Select a location under System » Client (store) » Select store » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the VAT rates tab.
-
Click on New configuration.
-
Please select a Country.
-
Enter the highest VAT rate as VAT rate A.
→ Enter furhter VAT rates in descending order. -
Enter your VAT number.
-
Select a starting date when the rates will become valid.
-
Pay attention to the explanations on the settings given in table 4.
-
Save the settings.
→ The new configuration will open and additionally a setting for margin scheme will be displayed.
Setting |
Explanation |
Country |
Select the country that you have become liable for taxation in. |
Tax rate A in % |
Enter tax rates. Start with the highest rate and continue in descending order. |
Valid from |
Select the date in the calendar. The VAT rates will go into effect on this date. |
Invalid from |
Select the date in the calendar. The VAT rates will no longer be applied from this date on. |
For digital items only |
Activate if the VAT rate should only apply to digital items. For further information, refer to chapter VAT for digital items. |
Margin scheme |
Specify which tax rate is to be used for stock units to which the margin scheme applies. If no tax rate is selected, then stock units that the margin scheme applies to can not be displayed on invoices (= basic setting). |
3.7. VAT for digital items
The buyer’s VAT rate must be used for digital items. An EU regulation puts these VAT rates into effect starting January 1st, 2015. If a VAT rate is already available for a country of delivery, e.g. because the delivery threshold was exceeded, then it is not necessary to create an additional VAT rate for digital items only. The existing VAT rate will be used. If no VAT rate is set up for one or more countries of delivery, then set up your accounting procedures in plentymarkets as described below. The EU regulation applies to B2C revenues.
This regulation applies to B2C revenues. B2B revenues without VAT are not affected.
Identifying the VAT for digital items:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the VAT rates tab.
-
Create a VAT configuration for every country of delivery where digital items are sold.
-
Open the VAT configuration and activate the option For digital items only.
-
Create a property for digital items and give it a name, e.g. Digital. The property may not be an order property.
-
Go to System » Item » Settings and select the property for the option Item property for identifying digital items.
-
Open every item that should be sold as digital media and save the property in the Properties tab.
4. Setting up posting keys, revenue and debtor accounts
Posting keys are only relevant for DATEV exports. You can ignore the posting key settings if you do not work with DATEV. You can set up revenue accounts to book your revenues. You can set up debtor accounts to book your pending amounts.
4.1. Setting up posting keys
Posting keys are relevant for DATEV exports. Continue with the next chapter on this page if you do not work with DATEV. Posting keys are called tax key in DATEV and are required for the correct transfer of posting information. There are some standard tax keys in DATEV. The standard tax key from the two standard charts of accounts 03 and 04 for 19 % VAT in Germany is 3. plentymarkets automatically determines whether it is dealing with a debit (D) or credit © posting. This information is included in the export. The information is displayed in a separate column in the export.
Setting up posting keys:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the Accounts tab.
→ The Posting key tab will open. -
Enter a posting key for each tax rate.
-
Save the settings.
4.2. Setting up debtor accounts
You can set up debtor accounts to keep an overview on your pending amounts. You can choose a criteria that will be used to book pending amounts on debtor accounts. As a criteria you can e.g. use the names of the debtors or the country of delivery. Choose a criteria first and then enter the actual accounts.
Setting up deptor accounts:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the Accounts tab.
→ The Posting key tab will open. -
Click on the Debtor accounts tab.
-
Carry out the settings. Pay attention to the information given in Table 5.
-
Save the settings.
Setting |
Explanation |
Standard debtor account |
Enter a debtor account that will be used if no other debtor account is saved or no other account applies. |
Save debtor account in the customer master data record |
Place a check mark to save a debtor account in the customer’s master data. This will only be carried out if no debtor account already exists in the customer data. The debtor account will be saved according to the option that is selected for the automatic assignment of debtor accounts. |
Automatic assignment of debtor accounts based on |
Select a criteria from the drop-down list that will be used to assign the debtor accounts. |
Initial letters (A - Z or 0 - 9 Debtor account) |
Enter debtor accounts depending on the initial letter. Do not enter debtor accounts here if you have selected anhother criteria. |
Countries of delivery |
Save debtor accounts for the countries of delivery activated in your system. Do not enter debtor accounts here if you have selected anhother criteria. |
Payment methods |
Save debtor accounts for the payment methods saved in your system. Do not enter debtor accounts here if you have selected another criteria. |
4.3. Setting up revenue accounts
You can set up revenue accounts to book your revenues and to assign them to accounts. You can enter accounts for revenues that are liable to VAT and for revenues that are exempt from VAT.
Setting up revenue accounts for revenues that are liable to VAT:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the Accounts tab.
→ The Posting key tab will open. -
Click on the Revenue accounts tab.
-
Enter an account for each VAT rate that you use.
-
Save the settings.
Setting up revenue accounts for revenues that are exempt from VAT:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
→ The Basic settings tab will open. -
Click on the Accounts tab.
→ The Posting key tab will open. -
Click on the Revenue exempt from VAT tab.
-
Enter an account for revenues that are sold within the EU and that are exempt from VAT into the Revenue from EU field.
-
Enter an account for revenues that are sold to countries outside the EU and that are exempt from VAT into the Revenue from export field.
-
Save the settings.
4.4. Saving booking accounts for POS events (plentymarkets App version 1.7.3 and higher)
Orders generated in plentymarkets POS are assigned to the revenue accounts saved in plentymarkets. Because deposits, withdrawals and till count discrepancies are not orders, you can save booking accounts for these POS events. For further information on how to save booking accounts for POS events, refer to the Integrating POS page of the manual.
4.5. Copying settings to other locations
Use the Copy settings function to copy the settings of the current location and apply these settings to one or more other locations. You can copy all of the settings or only specific settings.
The following settings can be copied:
-
Basic settings
-
VAT rates
-
Accounts
Proceed as described below to copy settings to one or more locations:
Copying settings to one or more locations:
-
Go to System » Client » Select client » Locations » Select location » Accounting.
-
Click on the Copy settings to another location.
-
Under Location, select one or more locations that the settings should be applied to.
-
Place check marks next to the Options that you wish to copy.
-
Click on Copy.
→ The settings will be applied to the locations.
5. Exporting accounting data
plentymarkets allows you to export accounting data. You can use the export to transfer the data to your accounting software. When you export your accounting data the system will automatically assign debtor accounts, revenue accounts and posting keys according to the settings that you have set up prior to the export.
Go to Data » Data export and select the data format that you want to export. Set up the format and export the data.