Import Bank Statement CSV in Tally Without TDL Add-on

Bank reconciliation is a key routine for accountants. Historically, users purchased third-party TDL add-ons or Excel utilities to import bank statements into Tally. With modern Tally Prime (Release 4.0 and later), Tally includes native Excel/CSV bank statement import functionality directly in the application.

Quick Answer: How to Import Bank Statements in Tally Prime Without Add-ons?

In Tally Prime, go to Alt+O (Import) > Bank Statement. Select your Bank Ledger, locate the downloaded CSV/Excel statement file, review the mapping preview, and press 'I' to import. Then navigate to Banking > Bank Reconciliation to auto-match transactions.

Native CSV/Excel bank statement import is built into Tally Prime (Release 4.0+).
Access via: Alt+O (Import) > Bank Statement > Select Bank Ledger.
TrulyInvoice automates purchase invoice entry to eliminate manual supplier bill typing.

1. Step-by-Step SOP to Import Bank Statements

Download the CSV or Excel bank statement from your net banking portal.
Open Tally Prime and press Alt+O (Import) > Bank Statement.
Select the specific Bank Ledger.
Specify the file path and select the CSV statement file.
Review the Bank Statement Preview screen and press I (Import).

2. Auto-Reconcile Inward and Outward Payments

After importing, navigate to Banking > Bank Reconciliation to auto-match bank entries against ledgers.

3. Automate Purchase Invoice Entry with TrulyInvoice

While bank imports automate cash flows, TrulyInvoice automates vendor purchase bills by parsing PDFs and syncing F9 purchase vouchers to Tally Prime in 15 seconds.

Automate Tally F9 Purchase Entry Today

Upload supplier bills and post verified purchase vouchers directly into Tally Prime in 15 seconds.

Explore Purchase Automation Engine →

How to Import Bank Statement CSV/Excel Files in Tally Prime Without Any TDL Add-on