LedgerCart: Online orders and customer portal

LedgerCart instantly converts your SQL-Ledger/LedgerSMB installation into a fully function web-based order system and customer portal.


  1. All products and prices are shown from your SQL-Ledger/LedgerSMB database. No need to sync your products/customers between your online order system and accounting software.
  2. Products are categorized using parts groups in your ledger.
  3. Customers can login and view their orders and invoices.
  4. Existing customers can login using remind password feature. New customers can register when during checkout.
  5. Easy to customize. All pages are html templates.

LedgerCart is a new product and a number of features are under active development. For details and price information send email to [email protected].

LedgerSMB support

We are pleased to announce our support for LedgerSMB. LedgerSMB is an sql-ledger fork with focus on security and stability. Currently we are support LedgerSMB 1.2 which is the latest stable branch.

To subscribe to support, just signup for our standard support package which now covers LedgerSMB as well as SQL-Ledger.

Clarification regarding sql-ledger development

Dieter Simader, the creator of sql-ledger, in an email has asked me to clarify my position regarding sql-ledger development. He has specifically referenced my this (http://bit.ly/aR7XM1) mailing list posting.

I am sorry for any confusion caused and would clarify that Dieter is *the* developer of sql-ledger and any new official version as well as updates are developed and released by him.

I have built my business (www.ledger123.com) around sql-ledger services (hosting, development, docs, support) but I am not associated with DWS Systems Inc.

SQL-Ledger enhancements and bug fixes

The enhancements and bug fixes I offer at github.com/ledger123 are not official. These enhancements and bug fixes have been sponsored by sql-ledger users and are available freely to anyone.

As a side note, it seems that new sql-ledger versions from Dieter are not open source. I shall however keep releasing new features and enhancements for sql-ledger which will be free/open source. (And as usual you can always sponsor a particular feature or enhancement)

Mailing list

I have created (and maintaining) this mailing list as a free resource for helping sql-ledger users. This is not official mailing list.

The official mailing list which was functioning for the last 10 years has been terminated by Dieter for unknown reasons.

I am also banned from joining and contributing to the Dieter’s support forum. This list is however open for everyone to join and contribute.

With the help of a kind user I was able to restore old mailing list archives at http://www.ledger123.com/archives/

Hope this clarifies any doubts.


Armaghan Saqib

New sql-ledger users list is active now

I am glad to let you know that sql-ledger users mailing list is active now. Almost all the great users and contributes from the old list are on board.

If you have not joined yet, here is the detail:

List web page:
> http://lists.ledger123.com/mailman/listinfo/sql-ledger

List archives:
> http://lists.ledger123.com/pipermail/sql-ledger

The old list archives:
> http://archives.ledger123.com/

Thank you for joining. Keep sharing your issues and experiences.

Our new enhancements

We are slowly adding new features to our enhanced sql-ledger release. In the past few weeks, we have made following changes:

1. You can display account description on GL reports.
2. COGS re-posting script has been added which will help to correct accounting errors in your data due to editing of sale invoices.

The COGS re-posting script is still under-development and should be considered as beta quality code at this time. Please test it and report any bugs to [email protected]

We also have planned to add a number of major enhancements in the coming weeks. Stay in touch.

Mailing list archives

Sql-Ledger mailing list archives from Dec 2004 to July 2009 are available at http://archives.ledger123.com/. In addition to small index files (by thread and date), I have also created a one big index file which links to all postings. This will help you to quickly search the mailing list using your browser find button.

Special thanks to mailing list user ‘ziggy’ for providing the mbox source which I converted to html using mhonarc.

Sourceforge archives are also available here but seem to be censored by the Moderator. I was unable to find any posting by me.

Bank reconciliation patch

We have released an sql-ledger 2.8.24 patch which corrects the following bank reconciliation issues:

  1. When there are multiple receipts for a single invoice/date or same
    amount/date, only one is shown. This happens when
    * When source column is blank for both payments
    * When source column contains same value for both payments.
  2. Marking one receipt of *same* invoice as reconciled will
    incorrectly mark the other receipt as reconciled as well.
  3. Reconciled transactions are displayed on reconciliation screen
    forever making it inconvenient and error prone to do the

Patch can be viewed here.