ChequeManager – Seamless Integration with Tally ERP / TallyPrime

In many businesses, Tally ERP / TallyPrime is used for accounting, while cheque printing is often handled manually. This separation creates extra work: accountants enter payment vouchers in Tally and then manually write cheques or type details again into another software.

This process is slow, error-prone, and inefficient.

ChequeManager the Cheque Printing Software solves this problem through ODBC-based integration with Tally, allowing businesses to automatically import payment voucher data and print cheques instantly.

This integration eliminates duplicate data entry, reduces errors, and significantly speeds up the payment process.

Why Integrate ChequeManager with Tally?

Most companies already record payments in Tally using Payment Vouchers. These vouchers contain all the information required to issue a cheque:

• Payee Name
• Payment Amount
• Voucher Number
• Payment Date
• Narration / Remarks
• Bank Ledger

With ChequeManager’s ODBC connectivity, this information can be directly retrieved from Tally and used to generate cheques automatically.

How the Integration Works

The integration uses ODBC (Open Database Connectivity).

When a payment voucher is created in Tally, ChequeManager can read that data through ODBC and prepare the cheque automatically.

Step 1 – Enable ODBC Server in Tally

Before ChequeManager can read data from Tally, the ODBC server inside Tally must be enabled.

1. Open Tally ERP 9 or TallyPrime
2. Press F12 – Advanced Configuration
3. Enable the following option: Enable ODBC Server : Yes
4. Set the port number: ODBC Port : 9000
5. Restart Tally.

Step 2 – Configure ChequeManager ODBC Connection

Next, configure the connection inside ChequeManager.

Server : localhost
Port   : 9000

If Tally is installed on another computer in the network, enter that system’s IP address. (e.g., 192.168.1.10)

Step 3 – Fetch Payment Voucher Data

ChequeManager retrieves payment vouchers using an ODBC query.

SELECT $Date, $VoucherNumber, $PartyLedgerName, $Amount, $Narration
FROM Voucher WHERE $VoucherTypeName='Payment'

This query extracts payment voucher information required to print a cheque.

Step 4 – Map Tally Fields to ChequeManager

Step 5 – Import Voucher Data

Users can preview the voucher data before importing. Typical workflow:

1. Open ChequeManager
2. Click Import from Tally
3. Retrieve payment vouchers
4. Preview voucher list and select required entries
5. Click Import

Step 6 – Print Cheques Instantly

After importing, ChequeManager can print cheques using preconfigured layouts. Features include:

• Bank-specific cheque formats
• Alignment adjustments
• Multi-bank support
• Cheque register records

Best Practices for Tally Integration

Conclusion

Integrating ChequeManager with Tally ERP / TallyPrime through ODBC creates a powerful workflow for businesses that rely on cheque payments.

By eliminating manual entry and automating cheque preparation, businesses gain faster operations, better accuracy, professional cheque printing, and improved financial control. ChequeManager acts as the perfect bridge between accounting data and cheque printing, making payment processing simpler, faster, and more reliable.