With files in the current EXTF format, you can export your bookings and account labelling with just a few clicks.
Select Organisation > OpenScope > Import & Export > Manage Datev imports/exports > Export Datev booking records.
Settings for DATEV
The following values 1 - 3 (consultant number, client number, accounting number) do not necessarily have to be correct for the export. However, they help your tax consultant to allocate your data. Better data will help you to avoid problems in advance.
Ask your consultant for the consultant number and enter it. The value can be stored in the company settings to be filled in automatically in future.
Your company is listed under the client number with the DATEV consultant, who can give you the number. This value can also be stored in the company settings .
Enter the accounting number. You can find further information on the accounting number below in the excursus on the accounting number.
You can extend the G/L account length of the transfer file if the number of digits in DATEV is greater than in Scopevisio. In this case, zeros are added to the Scopevisio number at the end. The 4-digit account 0027 becomes account 002700 with a 6-digit length.
The digit length of the G/L accounts in DATEV is the G/L account length +1. In the example, the customer 10000 would become 1000000.G/L account length DATEV receiving programme tbd
Selection of the data to be exported
Under Settings, first select the period from which you want to export postings. The usual posting period is years.
If you have already exported data but had to make subsequent postings, you can limit this using the creation period. This way, your consultant will only receive the new postings with the newly created file.
Number of postings: Please note that the number of postings per export run is currently limited to 50,000. If you would like to export more bookings, you should create several period-separated exports. You can view the number of bookings for a year in advance in the overall statistics.
Further export settings
Determine which Scopevisio fields are transferred to which DATEV fields.
Set the radio button to Account labelling to export the account labelling in separate runs. The export creates a separate file for each of the three account types. This is usually an added value for the consultant.
Specify file format, preview and export
Use the EXTF data format, the other formats are obsolete and are only listed for historical reasons.
The fixing of the posting batch is a function within DATEV. The recommendation is YES.
The service date is an additional field in the export.
The file name customisation is useful to be able to automatically read the creation date of the file, for example. This is helpful for separating subsequent postings (see above). However, the department number can also be taken into account. The customisation can only be applied to an export in EXTF format.
Finally, you should first use the preview . Here you also have the option of editing the allocations and applying the account mapping. Further information at the end of the text.
Use Export to create a file (postings or one of the three account labels).
Specify where on your computer the data should be exported.If necessary, create a separate folder, as files with the same name will be overwritten without further enquiry. Confirm your selection.
Excursus: DATEV billing number
The accounting number indicates how the data exported from Scopevisio is to be processed in the DATEV programme.
The billing number has the format nnnnJJ and consists of 2 parts.
The first part nnnn represents the type of file content (postings, labelling), the second YY, the financial year to which the file content belongs. The calendar year in which the financial year ends is specified. If your financial year runs from 01.04.2023 to 31.03.2024, YY = 24.
If postings are to be transferred, use the values 1 - 69 as nnnn values in the accounting number. These numbers can be freely assigned. If the available values are exhausted in one year, you can start again from the beginning.
If, on the other hand, you transfer account labelling, DATEV specifies the accounting number 99 for G/L accounts and the number 189 for debtors and creditors.
Example: The accounting number for the postings from the February 2013 posting period is 000213 (the zeros in front are automatically filled by Scopevisio and therefore do not need to be entered).
Example: The accounting number for the accounts receivable labelling is 018913, as this data is imported in DATEV in the accounting year 2013.
Account labelling: In Scopevisio, the G/L and personal accounts are not historicised, so a master data set is valid for all financial years. For DATEV, however, a separation between the financial years is important, which is why the financial year must also be specified when exporting the account labels of G/L accounts, debtors and creditors.
DATEV export preview and account mapping
After clicking on Preview , you will see the postings in table form.
First sort by the Note column to be able to correct discrepancies before exporting. It is always helpful if you point out possible problems to your consultant. Select the rows with a note and initiate the Easy Export.
The warning level indicates the severity of the problem.
Also check the conversion of the Scopevisio tax keys to DATEV BU keys (see tax matrix and DATEV automatic account setting in the G/L account master).
The assignment means the creation or application of a so-called account mapping. The scope value of an account (posted account) is replaced by another account (exported account). The target account is a simple entry field and does not reference the G/L account master.
You can then export the data via Export (see above).
Mapping example 1: Summarise similar postings in a generic account. Perhaps you have created a separate account for running costs for each of your vehicles (4530 - 4535). The mapping allows you to transfer all the postings to account 4530.
Mapping example 2: Your tax consultant uses a different G/L chart of accounts. You can therefore assign all your accounts to the tax consultant's G/L chart of accounts. Caution: The amount of work involved is not small.