|
|
SQL-Ledger is distributed under GPL. It’s a double entry accounting
system for business.
Accounting data is stored in a SQL Server, for the display any text or
GUI browser can be used. The entire system is linked through a chart of
accounts. Each item in inventory is linked to revenue, expense,
inventory and tax accounts. When you sell and purchase goods and
services the accounts are automatically updated.
With the assembly feature you can build manufactured goods from parts,
services and assemblies. When you sell assemblies all the accounts
linked to the individual parts, services and assemblies are updated and
stock levels adjusted accordingly. If any item belonging to an assembly
is changed all assemblies are updated as well.
Invoices, Packing List, Income Statement, Balance Sheet, Sales and
Purchase Order, Statements, Receipts and Checks are generated from
templates and may be changed to suit your needs. Templates are provided
in html and tex format. The tex templates are processed with latex to
produce postscript and PDF documents and can be sent to a printer,
displayed in a PDF viewer or sent out via email.
SQL-Ledger can be used on any UNIX, Mac OS X and Windows computer. The
application is written in Perl, developed on FreeBSD? and Linux with
Galeon, Konqueror, Netscape, Lynx, Links, W3M, Voyager, Explorer to
render the display, Apache to communicate between the server and the
browser, and PostgreSQL? or Oracle to store accounting data.
SQL-Ledger’s chart of accounts has the following features:
- Organize chart of accounts into headings and accounts
- Available account types: Asset, Liability, Equity, Income, Expense
- Set accounts to a summary account for: Accounts Receivables, Accounts Payables, Inventory
- Include account in selection menus on AR, AP, parts and service item screens
- Set account as a tax account
- Include account in customer / vendor screen as tax account
- Change account numbers anytime
- Setup your own master chart of accounts for setting up new companies
- List chart of accounts with Debit and Credit columns
- Drill down into account number for a list of transactions
- Limit transactions to a date range
- Include subtotals in ledgers
- Sort ledgers by date, source and description
SQL-Ledger’s general ledger has the following features:
- Selection list for accounts
- Record source, description, dates
- Customizable reports for all accounts or asset, liability, equity, income or expense accounts source, a range of dates, description
- Select fields to include and subtotals
- Sort reports by date, source, description and account
- Subtotals for sorted column
- Reports include all transactions posted by any module
- Links to original transactions
- Drill down into accounts to generate ledgers
- Create sales journal purchase journals or tax reports
|
|
Edit menu
