SQL-Ledger Accounting - Source Code

Latest release is SQL-Ledger 2.0.0 (632 k)

Installation instructions are in the README file.

setup.pl; setup and download script for SQL-Ledger. Save as setup.pl in a directory where you want to install SQL-Ledger (i.e. /usr/local/sql-ledger, /opt/sql-ledger) and run from the command line as root or as ordinary user who belongs to the same group as your web server. This utility will download the latest code, check your system, setup the proper permissions, write a conf file to disk and reload your webserver with the new configuration.

Quickbooks 6.0 conversion: This is a small perl script to import customers, vendors and parts from Quickbooks. In Quickbooks you print the customers, vendors and parts to a tab delimited file, save the customers in customers.txt, vendors in vendors.txt and parts in parts.txt. Create a dataset in SQL-Ledger, then check which account numbers to use for inventory, income and expense. Change the account numbers in the script and run it. Then populate the tables for SQL-Ledger.
 $ psql dbname < customers.sql
 $ psql dbname < vendors.sql
 $ psql dbname < parts.sql
To download you probably have to hold down the shift key and click on the link.
DATEV SKR03 for Germany. Copy the files into the sql directory.
custom_admin.pl Customized admin script to fill in the database administrator. copy the file into the bin/mozilla directory and create a symlink in bin/lynx.

The following languages are supported. User contributed foreign language templates are now part of the distribution. The list below shows what is included.

Language Translation HTML
Chart of
Brazilian Portuguese 100% - - -
Catalan 94% - - -
Czech 99% - - Czech Republic
Danish 99% x A4 Danish Default
Dutch 100% x x Dutch Default
Dutch Standard
English 100% x Letter Default
Canada General - GIFI
US General
Estonian 100% x x -
Finnish 100% - - -
French 100% x A4 France
German 100% x A4 Austria - Einheitskontenrahmen
Germany - SKR03
Italian 92% - - Italy
Norwegian 99% - - -
Polish 100% - - -
Portuguese 100% - - -
Russian 100% - - -
Spanish 100% x A4 / Letter Spain
Swedish 98% - - -
Simplified Chinese 98% - - Default
Traditional Chinese 98% - - Default
Turkish 83% - - -
The templates were provided by users and may or may not contain all the features. Use the English version to compare and edit to suit to your needs.

The included Default Chart of Accounts are samples only! You can modify and add your own chart of accounts. Just copy one of the .sql files in the sql directory. Nameing convention is Description-chart.sql (-chart.sql must be part of the filename)

The GIFI (if it exists) is named Description-gifi.sql It is a cross-reference to a standardized chart of accounts issued by your Government. It can also be used to consolidate sub-accounts.

Adding a new language

  • Add a country code in locale
  • create the file LANGUAGE and enter the long form for the language i.e German
  • create a symlink to ../de/locales.pl
  • run ./locales.pl
  • edit the file all
  • rerun ./locales.pl

    If you would like to make changes to the translations, or submit new templates or chart of accounts contact us.


    Licensed under the terms of the GNU License


    1. Web server (Apache, thttpd, ....)
    2. Perl 5+
    3. SQL Server ( PostgreSQL 7+, Oracle )
    4. Database Independant Interface DBI
    5. Database Driver for SQL server DBD ( DBD-Pg, DBD-Oracle )
    6. LaTeX (optional)
    The required software packages are available in packaged format on any modern distribution, if not compile from source.
    Revised: Dec. 7, 2002