Watch Video    

QL or Query Ledger is where you can see all details about a particular Ledger. QL Navigation

You can access the Query ledger by clicking on the QL tab in the top navigation bar.

When you enter QL, the bank is selected by default.

QL Landing

If you wish to view details of another ledger, you can do so using the smart text field.

  QL Ledger1

QL Ledger2
  • When you start entering in the name, on entering the third alphabet, the software will give you predictions of which ledger you might want to view. Select the desired ledger and click on GO.

  • The other way is to click on the ledger list button   QL L.   A list will appear with search fields.

  • You can then search using name, using alphabetical order, or even LedCode and choose the desired ledger.

  • You can also scroll between ledgers using the arrow keys. “First – Last – Next – Prev”.  QL Prev Next


Once the user enters QL, they can choose between a detailed view and a summarized view.


As the name suggests, this will give a condensed view of a particular ledger. These can be seen in the following views:

    QL Summary

    By Type – Segregates by Voucher Type

    By Ledger – Segregates using the opposite ledger and also displays the transaction details

    By Group – Gives a Group-wise listing of all the ledgers and the transactions associated with the selected ledger.

QL Detail

You can also choose to view your Ledgers yearly, monthly, daily or even transaction-wise. To do so, use the TDMY buttons.  QL Prev Next

You can toggle between views by double clicking on records. For example, double clicking on the year in Y view will take you to the month view of that particular year.

Further double clicking on a particular month will show you all the records created for that month. This drilldown goes all the way up to transactions where you can click on the voucher ID and view individual vouchers and even update/edit them.

There is a persistent top bar on the RHS that displays the Opening and Closing balance and also the transaction amount.


You choose the date range you wish to work in, after you login in the landing page.

In Query Ledger, suppose you wish to see data for a particular year/month/week, you can do so using the date controls.

You can either type in the date: for example, If you type 6-11-16, the system will automatically take 6th November 2016 as the date. Press TAB, to enter the ‘to date’.

Or, you can use the date control, and choose the desired dates. Please note the dates are recognized in the DD-MM-YY format.

  • STANDARD: This option is chosen by default. Displays the basic set of columns like type, opp ledger, amount, etc.

  • SHOW RUNNING BALANCE: Choosing this option will show the closing balance after each transaction.

  • SHOW LINKED VOUCHERS: Will show vouchers that have been linked to this particular voucher. For eg: will show a payment voucher that has been linked to a purchase voucher.

  • ALL/MULTIPLE ROWS PER VOUCHER: This will show second level of any vouchers that have 3 ledgers involved. For example TDS deducted for salary will show along with the salary ledger.

QL Format
QL Go To
  • View Documents: This will show all the documents related to the selected ledger. Please note, user will be redirected to the DOC GRID when this option is selected.

  • Ledger View: This option displays a summary of the selected ledger. Details like ledger name, ID, Parent group, Statutory details, address and contact details are displayed. You can choose to print the details as well. Please note: for the details to be displayed here, user needs to make sure to enter content in M1 while creating the Ledger. For details on how to create a ledger click here

  • Ledger Print: Read File on Ledger Print