Spesenfuchs Support

Welcome
Login

DATEV export interface

  • General
  • Accounting
  • LODAS
  • DATEV Lohn und Gehalt

General

For the DATEV export you need the advisor number and the client number

Please note that the client number must be between 1001 and 99999 and the advisor number between 1 and 99999.

Accounting

Via the selection Posting text you specify which information the posting text in the DATEV export files should contain. 

If you use a different fiscal year, store the start month. If the fiscal year is the same as the calendar year, then set the start to January. The information will be used in the DATEV export file and specifies the basic period for the export.

If you set the option DATEV fixed entry indicator, you give the DATEV exports the information that the entry is to be fixed in Kanzlei Rechnungswesen. This means that a change is no longer possible.

How the individual DATEV export files are structured is explained in this blog post.

LODAS

Enter the wage types that you use in DATEV LODAS. As a rule, the stored wage types do not need to be changed. The standards are as follows:

Lump sum/reduction tax-free9979Posting key 3
Flat rate 25% taxable202 or own wage typePosting key 2
Lump sum fully taxable202 or own wage typePosting key 2
Kilometer, taxable852Posting key 3
Kilometer, tax free9978Posting key 3
Non-cash benefit235 or own wage typePosting key 2
Payment200Posting key 2
Travel expenses, deduction

9010

Posting key 3


Payment via LODAS

If the option is activated, the payment to the employee takes place via LODAS and the above mentioned wage types are used.
Deactivate this option if travel expenses and meal allowances must be accounted for on the wage tax statement, but no longer paid out. In this case, Spesenfuchs creates an additional posting with a net deduction and negative sign for each wage type during export. If the net deduction is to be made to a different wage type, please enter the additional wage type separated by a "/", e.g. 9978/99781. Only one wage type can be stored for the "Payment" and "Travel expenses, deduction" wage types.

Lump sum/reduction tax-free9979Posting key 3
Flat rate 25% taxable202 or own wage typePosting key 2
Lump sum fully taxable202 or own wage typePosting key 2
Kilometer, tax free9978Posting key 3
Kilometer, taxable852Posting key 3

When the export is done, you will receive a ZIP file. Download the file and unzip it. You can now import the contained text file into DATEV LODAS according to the following DATEV instructions.

If you have used DATEV Reisekosten classic so far and have the problem that no travel expenses are to be paid out when importing into LODAS, please check whether you had stored a subsequent deduction. You may have to remove this.

Further information, in particular on wage types and posting keys, can also be found in the DATEV help under the following links on travel expenses, additional expenses for meals and overnight stays and on meals.

LODAS billing month

The LODAS billing month determines which date is output in the export file. Use the dates during export to specify which trips should be included in the export.

The options explained by example:

Last month
We are in August. In the export file, July is listed as the month. Thus, the data goes into the July payroll.

Current month
We are in August. In the export file, August is listed as the month. Thus, the data goes into the August payroll.

Following month
We are in August. In the export file, September is listed as the month. Thus, the data goes into the September payroll.

Travel month
We are in August. In the export file, the month in which the trip started is listed. Please note that LODAS accepts only one month within a file. I.e. in the period selection you must commit to one month

DATEV Lohn und Gehalt

The export for DATEV Lohn und Gehalt (DATEV payroll software) transfers the reimbursable travel expenses from Spesenfuchs into your payroll accounting. You can find detailed instructions here

Did you find it helpful? Yes No