What Is Tally TDL and Why Does It Matter for Bank Imports?
TDL — Tally Definition Language — is the built-in customisation language of Tally ERP 9 and Tally Prime. Accountants and developers use TDL to extend Tally's features, including creating custom bank statement import routines that read external files and automatically create bank payment and receipt vouchers.
When people search for "bank statement to Tally TDL," they are looking for either:
- A TDL-based import script that reads a CSV or Excel file and creates vouchers inside Tally — popular among CA firms and developers who customise Tally for clients.
- A converter tool that produces a CSV in the specific column format that TDL import scripts and Tally's own bank reconciliation module can read without modification.
Our converter solves the second problem: it turns your PDF bank statement into a clean CSV with Date (DD-MM-YYYY), Narration, Debit, Credit, and Balance columns — the exact structure that virtually all Tally TDL bank import scripts expect.
Before & After: PDF Bank Statement → Tally-Ready Data
❌ Before — Raw PDF
28/04/2026 NEFT-AXIS-RAHUL SHARMA
CR 45,000.00 1,23,456.78
29/04/2026 UPI/PAYTM/9876543210
DR 12,500.00 1,10,956.78
30/04/2026 SALARY CREDIT ABC LTD
CR 1,50,000.00 2,60,956.78
✅ After — Tally TDL Format
Date,Narration,Debit,Credit,Balance
28-04-2026,NEFT-AXIS-RAHUL SHARMA,,45000.00,123456.78
29-04-2026,UPI/PAYTM/9876543210,12500.00,,110956.78
30-04-2026,SALARY CREDIT ABC LTD,,150000.00,260956.78
How to Convert Bank Statement PDF to Tally TDL Format — 3 Steps
1
Upload PDF
Upload your bank statement PDF from HDFC, SBI, ICICI, Axis or any Indian bank
2
Download Tally CSV
Click "Download Tally" — get a CSV in Date, Narration, Debit, Credit, Balance format
3
Import into Tally
Use Tally's bank reconciliation import or your TDL import script to load transactions
Step-by-Step: Import Bank Statement CSV into Tally ERP 9 / Tally Prime
1
Download your bank statement PDFLog into your bank's net banking portal (HDFC NetBanking, SBI YONO, ICICI iMobile, Axis Mobile) and download the PDF statement for the period you need. Most banks provide 6-month and 12-month PDF statements.
2
Convert at bankstatementengine.comUpload the PDF here. If your bank statement is password-protected (common for HDFC, Axis Bank and ICICI statements), enter the password when prompted. Our converter extracts all transactions, separates debits from credits, and produces a clean Tally-compatible CSV file.
3
Open Tally ERP 9 or Tally PrimeOpen your company in Tally. Go to Banking → Bank Reconciliation or use your installed TDL import script. Navigate to the bank ledger account you want to reconcile.
4
Import the CSV using TDL or built-in importIf using Tally's built-in import: Go to Banking → Bank Reconciliation → press Alt+O (Import) → select the CSV file → map the columns to Date, Narration, Debit, Credit, Balance → confirm import. If using a TDL import script: load the TDL definition in Tally configuration and use the TDL-defined import menu option.
5
Verify and reconcileTally will show imported bank transactions alongside existing ledger entries. Match them row by row — Tally highlights unmatched transactions. Once all entries match, complete the reconciliation and save.
Tally TDL vs Tally XML vs Manual Entry — Comparison
| Method | Speed | Accuracy | Setup Required | Cost |
|---|
| TDL CSV Import (our tool) | ⚡ Seconds | ✅ 99%+ | None | Free |
| Tally XML Direct Import | ⚡ Fast | ✅ High | Developer needed | ₹5,000–₹20,000 |
| Manual voucher entry | 🐢 Hours | ⚠️ Error-prone | None | Staff time |
| Third-party Tally connector | ✅ Fast | ✅ High | Monthly subscription | ₹999–₹2,999/mo |
Supported Indian Banks
Our converter works with all major Indian public sector banks, private sector banks, small finance banks, and payments banks:
Private Sector Banks
HDFC Bank
ICICI Bank
Axis Bank
Kotak Mahindra
Yes Bank
IndusInd Bank
RBL Bank
Federal Bank
IDFC First Bank
Bandhan Bank
Public Sector Banks
SBI
Bank of Baroda
Punjab National Bank
Canara Bank
Union Bank
Bank of India
Central Bank
Indian Bank
Bank of Maharashtra
UCO Bank
International Banks (with Indian Tally Users)
Emirates NBD
Standard Chartered
HSBC India
Citibank India
DBS India
Who Uses Bank Statement to Tally TDL Conversion?
CA Firms (Chartered Accountants)
CA offices across Mumbai, Delhi, Bangalore, Hyderabad, Chennai, Pune, Ahmedabad and Kolkata process hundreds of client bank statements monthly. Manual entry into Tally is a major time drain. Our free converter eliminates the data entry step — the Tally TDL-compatible CSV is ready to import in seconds, regardless of whether the original PDF is from SBI, HDFC, or any other bank.
Small and Medium Businesses
SMEs in India using Tally for their accounting often receive bank statements as PDF files from their relationship manager or download them from net banking. The TDL-compatible CSV from our converter lets business owners or their accountants reconcile Tally ledgers with actual bank transactions quickly — no data entry errors, no missing transactions.
GST-Registered Businesses
For businesses filing monthly or quarterly GST returns, reconciling bank receipts and payments in Tally is essential. Converting bank statement PDFs to Tally TDL format ensures all inward and outward supplies are accurately recorded in Tally before filing GSTR-1, GSTR-3B, or GSTR-9.
Frequently Asked Questions
What is Tally TDL and how does it relate to bank statement import?
TDL (Tally Definition Language) is the programming language used to customise and extend Tally ERP. For bank statement import, TDL-based solutions create custom import definitions that tell Tally how to read your bank data. Our converter produces a CSV in the specific column format that Tally's bank reconciliation module and TDL-based import scripts expect — Date (DD-MM-YYYY), Narration, Debit, Credit, and Balance.
Which Tally versions support bank statement TDL import?
TDL-based bank statement import works with Tally ERP 9 (all releases), Tally Prime 1.x, 2.x, and 3.x. The CSV format our converter produces is compatible with all versions. For Tally Prime, the built-in bank reconciliation import also accepts this column structure.
Can I import an HDFC bank statement into Tally using TDL?
Yes. Download your HDFC bank statement PDF, convert it here to get a Tally-compatible CSV, then use Tally's bank reconciliation import or a TDL import script. Our converter handles HDFC's multi-page format, password protection, and correctly identifies debit and credit amounts in separate columns.
What column format does Tally TDL bank import expect?
Most TDL import scripts expect: Date (DD-MM-YYYY), Narration/Description, Debit amount (blank if credit transaction), Credit amount (blank if debit transaction), and optionally Balance. Our Tally CSV download provides exactly these five columns.
What is the difference between Tally XML import and TDL import?
Tally XML import uses Tally's native XML envelope format to push data directly into Tally's database via the Tally gateway port (typically port 9000). TDL import uses custom TDL definitions to read CSV or Excel files and create vouchers. Both achieve the same result. Our converter produces CSV output compatible with both TDL-based import scripts and Tally's built-in reconciliation import.
Is this free for CA firms processing multiple client bank statements?
Yes, 100% free with no usage limits. CA firms processing multiple client statements can use our
bulk converter to process many PDFs at once. No subscription, no per-page charges, no signup required.
Can I use this for UAE or Singapore-based Indian businesses running Tally?
Yes. Many Indian businesses in Dubai, Abu Dhabi, Singapore, and Malaysia use Tally for their accounts. Our converter works with bank statements from Emirates NBD, FAB, Mashreq, DBS, OCBC, Maybank and all other international banks, producing the same Tally TDL-compatible CSV format.
Related Tally Tools & Guides