OdooWiki OCA HUB

Account Move CSV Import DTVF

datev_import_csv_dtvf folder_open OCA/l10n-germany open_in_new
Accounting License: AGPL-3

DATEV Format .csv Import

The module "datev_import_csv_dtvf" enables the import of DATEV journal entries into Odoo. Possible use cases include:

  • DATEV journal entries from payroll and salary accounting
  • DATEV journal entries in the context of annual financial statements
  • DATEV journal entries in the context of reallocations by the tax consultant
  • DATEV journal entries in the context of depreciation (AfA) bookings by the tax consultant
  • DATEV journal entries in the context of loans

Currently, the following limitations exist:

  • DATEV journal entries containing tax-related booking keys require adjustments in Odoo
  • Under certain circumstances, DATEV journal entries on creditor and debtor accounts may also be affected.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Import DATEV-format CSV journal entries into Odoo as draft or posted journal entries. The import wizard lets you force a journal, date, reference and label, and it checks that accounts, journals and analytic accounts exist before creating the entries.

This module adds a wizard to import journal entries from a DATEV-format CSV file, typically produced by German accounting or payroll software. You open it from the Accounting menu under Journal Entries, choose the file, and optionally set a journal, a forced date, a forced reference and a forced label. You can also tick 'Post Journal Entry' to post the created entries immediately.

The import reads the file, detects its encoding and separator, and builds journal entries. Each CSV line becomes two journal entry lines: the account and the contra account. The Soll/Haben indicator (S or H) decides which side is debit and which is credit. Lines with the same date are grouped into one journal entry, and the import stops with an error if an entry is not balanced or has only one line.

Before creating anything, the wizard checks that every account code, contra account code, journal code and analytic account code exists in Odoo; if not, it shows a list of the missing codes and the line numbers. It also flags missing labels, missing or badly formatted dates, and invalid amounts. Imported lines are tagged with an import reference and an indicator, and analytic accounts are applied to income and expense lines. The wizard warns that taxes are not handled.

Depends on

accountl10n_de

Menus it adds

account_move_import_menu
Models and fields (2)
  • account.move.line · extends an existing modelindicator, import_external_id
  • account.move.import · new modelfilename, post_move (Post Journal Entry), date_format, file_to_import (File to Import), force_move_ref (Reference), force_move_date (Force Date), force_journal_id (Journal), force_move_line_name (Force Label)

Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. The module is very large and only part of the code was read. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 4 confirmed, 5 with no information of 9 versions.

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.0 of OCA/l10n-germany.

terminal Installation and usage

OCA documentation · Odoo 19.0

Usage

Source · Odoo 19.0

Import from DATEV into Odoo

Requirements

  • Make sure your user has group 'Full accounting features'
  • Check if the file you want to import into Odoo is DATEV format .csv (move lines start is line 3)
  • Check the description in order to check if your use case is supported
  • Take care of the limitation to import account moves with taxes

DATEV Import

  • Go to Accounting/Actions/DATEV Import
  • Upload your DATEV format .csv file from your tax advisor
  • Take care the file format is "DATEV Format .csv" (old version: Generic CSV)
  • Take care your file encoding fits to the provided file (usually "Western (Windows-1252)"), if it is the original file from your tax advisor
  • Optionally you may activate "Post Journal Entry" in order to immidiately confirm the created Journal Entry
  • Select the mandatory journal (f.e. "Payroll Account Moves"), usually the journal type will be "Miscellaneous"
  • Enter optionally the "Force Date" field ((will be the field "Date" in your Journal Entry)
  • Enter the mandatory field "Reference" (will be the field "Reference" in your Journal Entry)
  • Enter optionally the field "Force Label" (will be the field "Name" in your Journal Items)
  • Finally click on "Run Import"

If everyting works fine, you should now see your created Journal Entry in draft (execept you activated "Post Journal Entry")

Typical issue

If accounts doesen't exist in Odoo the wizard may interrupt and show you potential missing accounts.

In this case you have to ensure to create the missing accounts in Odoo.

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.