| 
      
      
      From: Mitterwald, H. <mit...@co...> - 2001-02-16 11:59:44
      
     | 
| Once upon a time....
ok, I like to get sql-ledger really usable in germany. There are some
chart of accounts (Kontenrahmen) around here that rather everybody
should use.
I up to now know the "Industriekontenrahmen" and saw
the one from Datev.
As Datev is rather commonly used I like to convert it to the sql-ledger
structure.
The datev chart of accounts has a "kontoart" that I think equals to
the category in sql-ledger.
I sorted and counted them (well, my database did it :-) )
These are the categories up to now:
              art               | count | ledger-category
--------------------------------+-------+-----------------
 Kursaufwand                    |     1 |
 Kursertrag                     |     1 |
 Summenvortrag                  |     1 |
 Kassenkonto                    |     3 | Q
 Erl=F6sschm=E4lerung               |     9 |
 Aufwandsschm=E4lerung            |     9 |
 Saldovortrag                   |    17 |
 Finanzkonto                    |    29 |
 Einkauf                        |    47 | L
 Eigenkapital                   |    58 | Q
 Neutrale Aufwendungen          |    71 |
 Statistikkonto (Bestandsgr=F6=DFe) |    73 |
 Neutrale Erl=F6se                |    80 |
 Verkauf                        |    94 | I
 Fremdkapital                   |    96 | L
 Anlageverm=F6gen                 |   100 | A
 Sonstiges Bilanzkonto          |   108 |
 Umlaufverm=F6gen                 |   137 | A? (if A means "Bestand")
 Kosten                         |   146 | E
categories in sql-ledger
  A ... Asset        (Anlage, Bestand?)
  L ... Liability    (Verpflichtungen)
  Q ... Equity       (Eigenkapital)
  I ... Income       (Einkommen?, Ertrag(=3DGewinn)?)
  E ... Expense      (Kosten)
Comments, extensions, etc?
I am not really shure if I have to assign the categories to each konto
individually.
But as I still remember the "Kontenarten" are of the same Type here.
Best regards,
   Holger
 |