Import GL Transactions

You can import GL transactions from a CSV file in our enhanced sql-ledger. This allows you to import general ledger double entry transactions in debit/credit format into sql-ledger. This is an important feature and you can import data from any legacy system which will allow you to export data in a similar way. Step 1 […]

Import Receipts and Payments

You can import payments and match them to invoices using ‘Import–Payments’. Following points should be kept in mind. Payments are matched first on Invoice DCN column and then, if no match is found, on payment amount. Both AR and AP invoices are matched with payments. The amount matched is calculated as debit minus credit. Follow […]

Data Import

Sql-Ledger allows you to import sale invoices and payments from CSV files. In the next few weeks we will be exploring these built-in features. To see how import sales invoices feature works visit the following page on our wiki. > We will also build our own import scripts which will allow you to import […]

Payment Difference

Payment Difference (+/-) column on AR and AP transactions report often causes confusion to new users of sql-ledger. This column displays the number of days between due date and last payment date for an invoice. This column can be displayed by checking the ‘Payment Difference’ checkbox on the report search screen.

Git repository updated to Sql-Ledger 2.8.18

Our git repository has been updated to the latest sql-ledger release which is 2.8.18. Click here to see the code changes in this version. ‘master‘ branch tracks sql-ledger with our changes while ‘sql-ledger‘ branch tracks changes made by the sql-ledger author. We have also merged these code changes into ‘master’ which brings our patches and […]