Accounting mailing list archives

accounting@odoo-community.org

Avatar

[13970] German Audit Standards and Export Functionality

by
InitOS GmbH, Frederik Kramer
- 25/10/2016 00:36:06
Dear Odoo accounting experts, dear German Odoo community, 

now, after having scrolled through a couple of hundred printed pages on 
the audit requirements and taxation standards imposed by 
German tax authorities and specifically the following legislations

Grundsätze ordnungsmäßiger Buchführung (GoB)
Grund­sät­ze zur ord­nungs­mä­ßi­gen Füh­rung und Auf­be­wah­rung von
Bü­chern, Auf­zeich­nun­gen und Un­ter­la­gen in elek­tro­ni­scher Form
so­wie zum Da­ten­zu­griff (GoBD)
Abgabenordnung (AO)
Grundsätze zum Datenzugriff und zur Prüfbarkeit digitaler Unterlagen
(GDPdU)

i wonder if any of you (also coming from the other European member
states, the U.S. or any other country with similar law) have ever tried
to export all the relevant accounting information using the
"Beschreibungsstandard für die Datenträgerüberlassung Version 1.1 vom
1.August 2002" published by Audicon or any similar / comparable
standard.

The standard itself allows to export structural data (such as foreign
key relationships, variable length, variable type, field names, etc.) in
an XML format and the data itself in either length-delimited or
length-variable ASCII format using the attached document type definition
(DTD) (see attached files for details).

This dataset can be produced by well known German factura, accounting
and ERP software solutions such as Datev, Lexware and SAP just to name a
few. It can than be imported and analyzed using the IDEA 2002 software
solution which is used by the German tax authorities and distributed by
Audicon in Germany (although the original vendor is the Canadian
CaseWare IDEA Inc.). Tax authorities use this tools to do their
compliance and statistical checks based on the Z3 Prüfverfahren
(Verfahren mit Datenüberlassung).

We have a client in Germany that will most probably be officially
audited starting from next year, but the aforementioned law applies to
all commercial entities in Germany (even much smaller ones). I wonder if
a similar data export routine (with target software systems similar to
IDEA) exists in any other EU member state or even outside Europe and /
or if anybody of you has heard of similar attempts to make Odoo export
that information.

All kinds of answer / hints on modules on the matter such as (but not
limited to):

- XML-export of accounting data (even if not the same format)
- data formats used to import to IDEA
- similar taxation laws inside or outside Europe
- concrete German localizations for that problem
- similar requirements from customers
- willingness to contribute to a project solving that problem
- anything else that relates to it

are pretty much appreciated. Hope i receive lots of feedback. I'd really
try to avoid inventing the wheel twice here trying to establish a very
generic solution.

Thanks a lot in advance for any feedback

KR Frederik
-- 
Dipl.-Wirt.-Inf. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dipl.-Wirt.-Inf. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/205/21518
USt-IdNr.: DE815580155