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
Templates |
LaTeX
Templates |
Chart of
Accounts |
|---|
| 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
Switzerland
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.
|
COPYRIGHT:
Licensed under the terms of the GNU License
REQUIREMENTS:
- Web server (Apache,
thttpd,
....)
- Perl 5+
- SQL Server (
PostgreSQL 7+,
Oracle
)
- Database Independant Interface
DBI
- Database Driver for SQL server
DBD
(
DBD-Pg,
DBD-Oracle
)
- LaTeX (optional)
The required software packages are available in packaged format
on any modern distribution, if not compile from source.
Revised: Dec. 7, 2002