Accounting
Guided tour available
The guided tour Accounting-UI is available for the Setup » Settings » Client » [Select client] » Locations » [Select location] » Accounting menu. The tours shows you the most important functions step by step. |
Learn more about settings in PlentyONE that are relevant for your accounting. These settings include among others VAT rates, rounding settings, booking keys, revenue accounts, debtor accounts but also taric numbers.
1. Basic information about price calculation in PlentyONE
The calculation of prices is based on the gross prices of variations. Based on this gross price, the net price of a variation is calculated for the order. To get the sums of the order items, the individual price of a variation is multiplied by the purchased quantity of the variation. This means that the gross sum of an order item is calculated by multiplying the individual gross price of an item by the quantity. The net sum of an order item is calculated from the determined net price rounded to 4 or 2 decimal places, multiplied by the purchased quantity of an item. 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 subtracted from the gross sum.
Your settings determine when the price is rounded to 2 decimal places. Subsequent calculations are based on these rounded values. The settings in PlentyONE can lead to the following results:
-
Rounded individual prices
-
Rounded order item sums
-
Rounded totals
2. Setting up how prices are saved and rounded
You carry out settings for saving and rounding prices in the Setup » Client » [Select client] » Locations » [Select location] » Accounting menu. These settings are dependent on the client and the location. For the calculation of prices in orders, the settings configured at the time of order creation are applied. This means that adaptations to the settings for saving and rounding prices are not applied to already existing orders.
Setting up how prices are saved and rounded:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Basic settings section, you can find the rounding setting under Calculation method for order amounts.
-
Carry out the settings according to the information provided in Table 1.
-
Save () the settings.
Setting | Explanation |
---|---|
Two decimals |
The prices in an order are saved with only 2 decimal places. The indirect result of this setting is that the price of a single variation is rounded. The sums and totals of an order are then calculated based on the rounded individual prices of a variation. |
Four decimals |
The prices in an order are saved with only 4 decimal places. Selecting 4 decimal places has the effect that the sum of an order item is rounded by default. However, in the background the sums are saved with 4 decimal places without rounding to ensure that it is still possible to only round the totals later. |
Two decimals, round totals only |
Activate this option if you want that only the totals of an order are rounded. The sums of order items are no longer rounded by default if this setting is active. Totals refer to the total value of an order. When you look at the settings of the document template for invoices the settings that are affected are the ones that are listed under the sums heading. |
Four decimals, round totals only |
Activate this option if you want that only the totals of an order are rounded. The sums of order items are no longer rounded by default if this setting is active. Totals refer to the total value of an order. When you look at the settings of the document template for invoices the settings that are affected are the ones that are listed under the sums heading. |
2.1. Example calculations
The following section compares the different calculation methods and the results with the help of an example.
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 bought 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 have be carried out to get one of the results are also listed in the table.

3. Carrying out VAT settings
The VAT settings are location-based. This means that you set different settings for each location. Locations are required for your registered business addresses or for countries that you ship from. There are two locations per default in your system. These locations are Germany and United Kingdom. However, for the productive mode of your system, you need your own locations.
Your system differentiates between countries that are members of the European Union and non-EU countries. If you set up a location which is not within the EU, every delivery to another country is treated as export shipping. If your location is within the EU, it is differentiated 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 are displayed. For EU locations you can also define how the system reacts if a VAT ID is given in the order.
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 your head office, so to speak.
Creating a new location:
-
Go to Setup » Client » [Select client] » Locations.
-
Select the menu entry New location.
→ An editing window will open. -
Enter the Name of the new location.
-
Select the Country of the new location. You can only choose from countries that are already defined as delivery countries in the PlentyONE.
-
Save () the settings.
→ The location is added to the list of locations.
Each location is divided into the following 3 submenus:
-
Settings
-
Accounting
-
Documents
The submenu Settings contains the ID, the name and the country of the location. The Accounting submenu contains several sections. In the Documents submenu, you can find the old menu for setting up location-specific documents such as invoices and delivery notes. The DocumentBuilder is now the main menu for document creation. Fur further information, refer to the Order documents page of the manual.
3.2. Deleting a location
You can only delete a location if another location exists. It is not possible to delete the default location.
Deleting a location:
-
Go to Setup » Client » [Select client] » Locations.
-
Open the submenu Settings of the location you want to delete.
-
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 VAT to be applied to your invoices, then activating a setting in your basic settings is all you need to do. However, even though the VAT is not applied, you still need to save the correct VAT rates in your settings for a correctly functioning system. .
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 cannot access and that is selected based on the information that you provide when you order a PlentyONE. |
Using the German small business owner regulation:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Basic settings section, you can find the small business setting under Business VAT management.
-
Activate the VAT exemption for small businesses option by selecting Yes .
-
Save () the settings.
Displaying small business owner information on invoices
As a small business owner you need to place information on your invoice why no VAT has been 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
For deliveries within the EU, you can choose whether customers with a VAT number should 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 has to be in another EU country if you want to issue a net invoice. For deliveries within the same member state of the EU the VAT is always applied regardless of the selected setting. To prevent this, you have to enclose an entry certificate in the delivery and have to select this option in the order within the delivery address. If the customer does not have a VAT number, this means that it is a private purchase and that VAT is applied anyway. The only time VAT is not 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:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Basic settings section, you can find the sales tax settings under VAT Settings.
-
Select an option for the Amounts in orders where a VAT ID is specified (intra-Community deliveries). Pay attention to the explanations given in Table 2.
-
Save () the settings.
Setting | Explanation |
---|---|
Net |
Invoices are issued without VAT for customers who have a VAT number. |
Gross |
All invoices for deliveries within the EU are issued as gross. |
3.4.1. Examples with the settings’ effect
In the following section, 6 possible setting combinations and the effects are described.
In this case, the invoice is always provided as gross, even if the setting Net has been selected.
In this case, the invoice is provided as gross, even if the setting *Net* has been selected. However, a net invoice is actually allowed if the invoice recipient has a VAT number. An additional setting has be carried out to issue a net invoice. The entry certificate must be activated in the delivery address data of the order. The invoice is gross as long as the entry certificate setting is not activate. The entry certificate is an individual delivery address setting.
The invoice is net if the recipient of the delivery has a VAT number. The invoice recipient does not play a role in this scenario.
The invoice is net as soon as either the recipient of the delivery or the recipient of the invoice has a VAT number. The invoice is gross if neither the recipient of the delivery nor the recipient of the invoice has a VAT number.
The invoice is net as soon as either the recipient of the delivery or the recipient of the invoice has a VAT number. The invoice is gross if neither the recipient of the delivery nor the recipient of the invoice has a VAT number.
In this case the delivery is an export shipment and the setting for an export shipping is applied. The settings for export shippings are 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 should be net or gross. The basic assumption is that your business is based in the European Union. The setting is applied if the delivery is sent to a country outside the European Union. If the invoice is a net invoice, your customers receive an invoice without VAT.
Setting up gross or net invoices for export shipping:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Basic settings section, you can find the sales tax settings under VAT Settings.
-
Select an option for Amounts in orders for export deliveries (delivery from the EU to Non-EU countries). Pay attention to the explanations given in Table 3.
-
Save () the settings.
Setting | Explanation |
---|---|
Net |
Invoices for export shipping are issued without VAT. |
Gross |
Invoices for export shipping are issued with VAT. |
3.6. Applying the Reverse charge procedure
The Reverse charge procedure, also known as the Deduction procedure, is a special sales tax regulation. If the procedure is applied, the recipients (= your customers) are liable for the VAT and not the merchant or company providing the service (= you as a merchant or your company). The reverse charge procedure is only applicable to B2B deliveries. If it is applied, it is necessary that
-
the VAT ID of the customer is added in the order.
-
a net invoice is issued for this customer.
-
a note stating that the reverse charge procedure is applied is displayed on this net invoice.
This setting is dependent on location, which means that you can decide separately for each location if the procedure is to be applied. The Reverse charge procedure is deactivated by default, i.e. No is selected for every location. If you want to activate this option, go to the Setup » Client » [Select client] » Locations » [Select location] » Accounting menu. In the Basic settings section under Business VAT management » Reverse charge procedure, select the option Yes. Also consider the explanations in Table 4.
Setting | Explanation |
---|---|
No (default) |
The reverse charge mechanism isn’t applied. |
Yes |
The reverse charge mechanism is applied. The prerequisite is that it is a B2B order and the customer’s VAT number is stated in the order. If you select Yes, the system automatically determines whether the requirements are met. The invoice will then be issued as a net invoice and the tax note that the reverse charge procedure is applied will be displayed on the invoice. |
3.7. Delivery threshold and OSS
From the 01/07/2021 on, there are no more different delivery thresholds within the EU. Instead, a common delivery threshold of € 10.000 for all B2C deliveries applies.
If you sell to other EU countries and exceed this delivery threshold, you are liable for VAT in other countries. How much VAT you have to pay in which countries depends on the individual transactions. The settlement of VAT for B2C deliveries can be handled centrally via the One-Stop-Shop (OSS) procedure and is then no longer carried out individually for each EU country. The reporting period here is always per quarter and the payment period ends 30 days after the end of the reporting period.
In Germany, the Federal Central Tax Office is responsible for the OSS procedure. You can also register for OSS directly with them. You can find all information about OSS here . Participating in the OSS is not compolsory. We recommend to discuss with your tac office whether participation makes sense for you.
To represent all this in PlentyONE, you need to implement two things in particular:
-
Set up VAT rates for your delivery countries. This is not to be confused with creating a new location. You can create VAT rates as described in the following chapter or you can use the VAT rate assistant.
Either way, it is very important that you make sure to enter the correct data. Otherwise, wrong VAT rates and incorrect configurations could be created which cannot be reversed. -
Enter and maintain taric codes, as these are central for mapping the different taxation of items. Add the taric codes on the variations and then link these with the corresponding VAT rates of the individual EU countries in the taric code table.
In the forum post Deadline 01/07/2021: FAQ on EU VAT, harmonisation of delivery thresholds, OSS & Co you will find further information and a combined thread with FAQs, which is constantly being expanded.
3.8. Setting up VAT rates
In PlentyONE, the disctinction between locations and delivery countries in which you are liable to pay tax is important. An accounting location is a registered business address. 2 accounting locations exist per default in PlentyONE. 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 your delivery countries within the EU as soon as you exceed the delivery threshold for a EU country. You add locations for company headquarters and the country of the location with VAT configurations for correct accounting.
Official tax information
For Germany, the Federal Central Tax Office provides tax information about the European countries of delivery as well as information about VAT. |
Setting up VAT rates:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Country-specific VAT rates section, you can find the country-specific sales tax settings.
-
Click on Add new entry (add).
-
Select a Country.
-
Enter your VAT number.
-
Select a starting date from which on the rates will be valid.
-
Pay attention to the explanations given in Table 5.
-
Enter the VAT rates for the selected country in the table. You can also enter a name for each set.
→ With the Apply default VAT (auto_fix_high) function, you can instruct the system to apply the standard VAT rates of the respective country.
→ Regarding this, especially note the table entry about entering tax rates. -
Save () the settings.
→ The new configuration is displayed in the table together with all other existing configurations.
In the table, all active configurations are displayed with a green dot. This means that this configuration is currently active. If a grey dot is displayed, the configuration is inactive. This is the case when the invalid from date has been reached.
Changing VAT configurations afterwards not possible
As soon as a VAT configuration is active, only the Invalid from date is editable. Therefore, make sure to enter the correct data when you create VAT configurations. |
Setting | Explanation |
---|---|
Country |
Select the country in which you have become liable for taxation. |
VAT number |
Enter your VAT number. |
Valid from |
Select the date from the calendar. The VAT rates will go into effect on this date. |
Invalid from |
Select the date from the calendar. The VAT rates will no longer be applied from this date on. |
Economic identification number |
Enter your economic identification number (EIN). |
For digital items only |
Activate if the VAT rate should only apply to digital items. For further information, refer to the chapter VAT for digital items. |
Tax rate A in % |
Enter the tax rates for the country selected in the field Country. Use the same structure of entering tax rates for every country. For example: Note: Use (auto_fix_high) for the VAT rates to be automatically entered by the system. |
Revenue account (optional) |
This is an optional field that can also be filled later. Only enter a revenue account for a tax rate if the tax rate differs from the one assigned to an account under revenue accounts, but the differing one is the valid tax rate. |
3.9. VAT for digital items
The buyer’s VAT rate must be used for digital items. An EU regulation put these VAT rates into effect on 01/01/2015\. If a VAT rate is already available for a country of delivery it is not necessary to create an additional VAT rate for digital items only. The existing VAT rate is used. If no VAT rate is set up for one or more countries of delivery, then set up your accounting procedures in PlentyONE as described below.
The EU regulation applies to B2C revenues. B2B revenues without VAT are not affected
Identifying the VAT for digital items:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Country-specific VAT rates section, you can find the country-specific sales tax settings and the setting for digital items.
-
Click on Add new entry (add).
-
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.
-
Save () the settings.
→ The new configuration is displayed in the table together with all other existing configurations.
4. Taric codes
Taric codes, also called taric numbers, are used in EU-wide trading. These are unique and fixed numbers which are assigned to a specific commodity and have to be included in tax relevant documents.
Taric codes are relevant for you if you are trading EU-wide and have exceeded the delivery threshold of 10.000 EUR for B2C sales. In this case you should enter the taric codes in good time. We recommend to clarify all details regarding the taxation of your goods in other EU countries with your tax consultant.
Goods are charged with different taxes in different EU countries. In order to take this into account and thus also have a correct basis for the calculation of orders, the taric codes have to be entered into the system and also checked against the VAT rates which are set for different countries. Thus, as a first step, you have to maintain the taric codes in your system. The taric codes are entered in the variations of an item. Moreover, you need to set VAT rates for the required countries. These VAT rates can also be entered later, but we recommend setting these up in the system in time.
The table in the Setup » Client » Setting » Taric code menu then enables the linking of taric code, VAT rate and country. Thus, this taric code table is a basis for the calculation of orders and has to be maintained as well. It is important to note that no tax rates are directly entered here. Instead, you select the ID (A, B, C, etc.) of the tax rate of the corresponding tax rate configuration. Therefore, it is essential to be careful in the maintenance of the VAT settings.
Imagine that an order with the delivery country France enters the system. VAT rate A is set for the variation of the order item in the order. But in France, this item is taxed with the VAT rate B. That is why there is an entry in the taric code table with the same taric code as the one entered in the variation. The difference is that in the table, this taric code is linked with France and the VAT rate B. The order logic recognises these cases and uses the VAT rate set in the taric code table.
In case there is no taric code entered in the variation or in the table, no differing VAT rate is used for the calculation. This means that you only have to enter the corresponding taric codes in the table if a variation is taxed differently in other countries.
You can use the import tool to import customs tariff numbers. You can also enter the numbers manually. We recommend to the import tool and to enter only single taric codes or carry out small adaptations manually. Note that only numbers up to 14 characters are allowed. Entering special or blank characters is not allowed.
The sync type Assignment taric codes is available for importing taric codes. You can find general information about imports via the import tool on the manual page Using the import tool.
To fill the table manually, proceed as follows.
Filling the taric code table manually:
-
Go to Setup » Client » Settings » Taric codes.
-
Click on New assignment ().
→ A new row is added to the table. -
Enter the taric code.
-
Select the corresponding country.
-
Select the corresponding VAT rate.
-
Click on Save () at the end of the row.
→ The changes are saved.
In the table, found variation links are marked with a green dot. This means that this taric code is currently in use in a variation. If a red dot is displayed, no variation link was found. This taric code is not in use in any variation
More editing options are available. For this, pay attention to the information given in the following table.
Function | Explanation |
---|---|
Search |
You can search () for assignments. For this, the filters taric code and country are available to you. |
Editing an assignment |
To edit an existing assignment, click on the appropriate row and carry out the necessary adaptations. Afterwards, click on save () to update them. |
Deleting an assignment |
To delete an existing assignment, click on delete () in the column Actions at the end of the row. Confirm the deletion in order to delete the assignment. |
5. 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 set up revenue accounts to book your revenues. You set up debtor accounts to book your pending amounts.
5.1. Setting up posting keys
Posting keys are relevant for DATEV exports. If you do not work with DATEV, you can skip this chapter. Posting keys are called tax key in DATEV and are required for the correct transfer of posting information. here are some standard tax keys in DATEV. he standard tax key from the two standard charts of accounts 03 and 04 for 19 % VAT in Germany is 3. PlentyONE 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 Setup » Client » [Select client] » Locations » [Select location] » Accounting.
In the Posting key section, you can find the settings for the posting keys. -
Enter a posting key for each tax rate.
-
Save () the settings.
5.2. Setting up debtor accounts
You set up debtor accounts to book your pending amounts. You can choose a criterion that is used to book pending amounts on debtor accounts. As a criterion you can for example use the names of the debtors or the country of delivery. Choose a criterion first and then enter the actual accounts.
Setting up debtor accounts:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Debtor accounts section, you can find the settings for the debtor accounts.
-
Carry out the settings according to the information provided in Table 7.
-
Save () the settings.
Setting | Explanation |
---|---|
Standard debtor account |
Enter a standard debtor account that is used if no other debtor account is set up or no other account applies. |
Save debtor account in the customer master data record |
Activate this option to save a debtor account in the customer’s master data if no debtor account has been saved yet. The debtor account is saved according to the option that is selected for the Automatic assignment based on. |
Automatic assignment based on |
Select a criterion from the drop-down list that should be used to assign the debtor accounts. |
Order |
Allows you to select the sequence of the data. If no company name was entered, then the last name is used and so on. |
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 another criterion. |
5.3. Setting up revenue accounts
You 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 Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Revenue accounts section, you can find the settings for the revenue accounts.
-
Select a Country.
-
Enter an account for each VAT rate that you use.
-
Save () the settings.
With this configuration for revenue accounts for revenues liable to VAT, selected VAT rates are assigned to a specific revenue account. But what do you do if a VAT rate temporarily differs or changes, as was the case for the temporarily lowered VAT rates in Germany in 2020, for example? In this case, you enter the corresponding revenue account directly in the VAT rate configuration which displays the differing VAT rate. In the system, these then have priority in the determination of revenue accounts. For this, pay attention to the table entry Revenue account (optional) in the chapter about setting up VAT rates.
Setting up revenue accounts for revenues that are exempt from VAT:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
In the Revenue exempt from VAT section, you can find the settings for the VAT-free accounts.
-
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 Non-EU field.
-
Save () the settings.
5.4. Saving booking accounts for POS events (only if using PlentyONE POS)
Orders generated in PlentyONE POS are assigned to the revenue accounts saved in PlentyONE. 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 PlentyONE POS page of the manual.
6. Copying settings to other locations
Use the Transfer settings to function to copy the settings of the current location and apply these settings to another location. You can copy all of the settings or only specific settings.
The following settings can be copied:
-
Basic settings
-
Country-specific VAT rates
-
Debtor accounts
Proceed as described below to copy settings to one or more locations.
Copying settings to one or more locations:
-
Go to Setup » Client » [Select client] » Locations » [Select location] » Accounting.
-
Click on () Transfer settings to.
-
Under Location, select a location that the settings should be applied to.
-
Select the Options you want to copy.
-
Tick the checkbox to confirm the transfer of the settings.
-
Click on Save.
→ The settings are applied to the locations.
7. Exporting accounting data
PlentyONE 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 automatically assigns debtor accounts, revenue accounts and posting keys according to the settings that you have set up prior to the export.
The Data » Custom export menu contains predefined export formats which can be used to export accounting data. The data fields that are exported are predefined for those export formats. Nevertheless, there are a few settings that you need to carry out. These settings have an effect on the export’s data volume.
Go to Data » Data export and select the data format that you want to export.
Table 9 explains the predefined data formats that are available in the Data » Custom export menu. Below the table you can find the steps that are required to export a predefined data format. The settings that require additional information are not listed for every data format, but summarised in Table 9.
Data format | Explanation |
---|---|
Order data for customs |
The exported CSV file contains order data relating to exportation, e.g. shipping costs. |
BMECat |
BMECat is a standardised, XML-based exchange format for catalogue data and product classification systems in the B2B field. |
Collmex accounting |
The export is optimised for the ERP solution Collmex and exports sales or customer data. You can export data of one or multiple locations in order to import this data in Collmex. When you export sales data, Collmex uses payment condition IDs for the correct assignment. Note that the Collmex website is only available in German. |
Financial accounting |
The CSV file may either only contain the data from outgoing item invoices or from the PlentyONE POS receipts or it may contain data from both sources. The export is DATEV compliant. You can export data of one or multiple locations. Select UTF-8 as the import character set and select the semicolon as separator. |
Manufacturer commissions |
The exported CSV file contains commissions that are saved in the manufacturer data. |
Price list |
The exported CSV file contains item data and the corresponding prices. |
Invoice book |
The exported CSV file contains a list of all invoices and credit notes that were generated on the selected date or within a month. Select Latin as the import character set and semicolon as separator. |
Revenue by order date |
The exported CSV file contains sales data by the date the order was received. |
VAT number check |
The exported CSV file contains customer data of checked customers as well as their VAT number. The entry in the valid column of the exported CSV file tells you whether or not the customer has a valid VAT number. The entry 0 stands for invalid and 1 stands for valid. |
Sold quantities of items |
The exported CSV file contains a list of all sold items and of the sold quantity within a certain time period. You choose the information that you want to include in the export. |
Outgoing item invoices |
The exported CSV file contains a list of invoice data that was generated on the selected date or within a month. A memo is saved for every invoice according to the VAT rate. In addition, the memo that belongs to the order will be exported. Select Latin as the import character set and semicolon as separator. |
Xero |
The exported CSV file contains sales data from UK orders for the data exchange with the accounting software Xero. You can export data of one or multiple locations. |
Payment documents |
The exported CSV file contains incoming payments that are assigned to an order. The invoice data is retrieved according to the payment method. |
Next, you will learn how to export the data formats mentioned above.
Exporting a predefined data format:
-
Go to Data » Custom export.
-
Select a data format from the drop-down list. Pay attention to the explanations given in Table 9.
-
Click on Add ().
→ The export format is created and added to the list. -
Carry out the settings. Pay attention to the information given in Table 9. The table only lists settings that require additional explanation.
-
Save () the settings.
-
Click on the gear-wheel icon Export data.
→ The export file is created. -
Save the file on your computer so that you can use it later.
Column header names
If you change the names of the column headers after the export, then the data cannot be correctly assigned when importing the file. This is because PlentyONE uses the column header names for assignment. When you import your data into other external systems, it might be necessary to adapt the column header names to ensure a correct assignment. |
Setting | Explanation |
---|---|
Name |
Use the default name or enter another name. |
Company No. |
The company number is only relevant if you use the Collmex data format. In case you manage the data of several companies, select a number. Number 1 is selected by default. |
Free text field |
The free text field is only relevant for the data format Financial accounting. It refers to the free text fields linked with the item and their content. If you selected a free text field here, select the option One data record per stock unit (standard) for the format. This option is described below. |
Format |
The format is only relevant for the data format Financial accounting. |
Item category to the level |
The item category to the level is only relevant for the data format Price list. Select a level to define up to which level items should be exported. |
Date; |
Select the day, month and year to only export data of this specific date. Instead of a specific date, you can also export data of an entire month. |
AccountCode |
The AccountCode is only relevant for the data format Xero. Enter the AccountCode as saved in Xero. |
Company location |
The Company location is only relevant for the data format Xero. Select the country where the company is located, as saved in Xero. This setting defines how prices and dates will be formatted and thus fulfils the import requirements for Xero. |
Additionally retrieve and include the interim transaction report |
This setting is only relevant for the data format Payment documents. Activate the setting to retrieve and export interim transaction reports. |