Alex, I've been able to find out a bit more about the eBilanz format from this site http://www.fractalexperience.com/xbrl/web/?h=be50b430c57f45244ba9e9a5.c8e28feef1a872188bcc479a The bs.eqLiab.accruals descriptor appears to apply to accounts in equity for Provisions for future liabilities where the liability accrues on a periodic basis, e.g. pensions which accrue with length of service.
Similarly the bs.eqLiab.equity represents similar accounts in equity which are intended to cover certain other contingencies, retained earnings , profit and loss etc. The bs.eqLiab.liab class applies to the general class of liabilities which the eBilanz seems to report as a general class under equity which is OK as both liabilities and Equity have the same deit/credit meanings. The classes all appear to be subclasses of either Equity and/or Liabilities and not specific classes of accounts in their own right. I tried to have a look at the eBilanz online submission site ( https://www.ebilanzonline.de/digitaler-finanzbericht/#c424) to see if I could find out what the required input was and how to present it but that is not possible without registration. It would appear their site (see FAQs on it) can import data from an Excel spreadsheet interface and the mapping of your accounts onto the classes can similarly be constructed in an Excel spreadsheet and imported in that format. Since LibreOffice can export spreadsheets in the Excel 2003 format so it should be possible to get data in even if you are not a Microsoft user. I went through a similar effort with the Australian system when they introduced digital business reporting and found it equally confusing. I gave up there as it has not yet been applied to individuals tax reporting and I am no longer operating a business, but that will no doubt happen in the future. David Cousens On Wed, 2022-04-13 at 07:58 +0200, Alex Ritzer wrote: > Hello, > > I'm currently using GnuCash 4.1. on Windows with a mysql Backend > > Every year I have to create a so called "e-Bilanz" for the german finance > department after the annual statement of accounts . > > Due to the mandatory Taxonomie I have to use among other things the > following acoounts: > > Activ: > (Fixed Assets) de-gaap-ci:bs.ass.fixAss > (Current Assets) de-gaap-ci:bs.ass.currAss > > Passiv: > (Equity) de-gaap-ci:bs.eqLiab.equity > (Accurals)de-gaap-ci:bs.eqLiab.accruals > (Liability) de-gaap-ci:bs.eqLiab.liab > > [image: image.png] > > Currently I programmed a workaround in python to get all the liabilities > from the db. > Still it would be nicer, if we would have an account_type "accurals" or > another field in the table accounts to distinguish between liability and > accurals. > > > From a short check on the db model I would estimate that there would be no > harm on the db > Scheme, if a new account type or another field would be added. > > Regards > _______________________________________________ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
