Re: [SQL-Ledger-users] German Chart of accounts?

[<ke...@dk...>]

On Fri, Feb 16, 2001 at 12:59:50PM +0100, Mitterwald, Holger wrote:
> 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össchmälerung               |     9 |
>  Aufwandsschmälerung            |     9 |
>  Saldovortrag                   |    17 |
>  Finanzkonto                    |    29 |
>  Einkauf                        |    47 | L
>  Eigenkapital                   |    58 | Q
>  Neutrale Aufwendungen          |    71 |
>  Statistikkonto (Bestandsgröße) |    73 |
>  Neutrale Erlöse                |    80 |
>  Verkauf                        |    94 | I
>  Fremdkapital                   |    96 | L
>  Anlagevermögen                 |   100 | A
>  Sonstiges Bilanzkonto          |   108 |
>  Umlaufvermögen                 |   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(=Gewinn)?)
>   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.

We are doing a similar work in denmark, to generate one or
more standard charts of accounts. These are different from country
to country, given different legislations, and also different
between different types of organizations. 
As sql-ledger is typically good for the lower end of the market,
we are looking into different account plans for smaller associations, 
like linux user groups, and smaller firms like a software company or
service consultant.

I think Dieter is looking into localization support for this
in one of the forthcoming revisions.

Keld