Bank statementto Tally

Upload any bank statement PDF and get a clean CSV ready to import into Tally Prime or Tally ERP 9 via Bank Reconciliation.

Tally-ready CSVAI extractionAll Indian banks
Drop your file hereTap to upload
PDF, JPG or PNG · Free converter for everyone
Convert to CSV — Free
Files deleted after conversion
See how it works
Works withSBIHDFC BankICICI BankAxis BankKotak BankPNBBank of BarodaCanara BankYes BankIndusInd& all other banks

How it works

PDF to Tally in three steps

1.Upload your bank statement PDF

Drop any bank statement PDF — downloaded from net banking or scanned from paper. SBI, HDFC, ICICI, Axis, and any other bank.

2.AI extracts every transaction

Our AI reads each transaction: date, narration, debit, credit, and closing balance — structured into Tally-ready columns.

3.Download CSV & import into Tally

Download the CSV and import it directly into Tally Prime or ERP 9 via Banking → Bank Reconciliation → Alt+O.

Step-by-step guide

How to import bank statement into Tally Prime

Tally Prime has a built-in bank statement import feature under Banking → Bank Reconciliation. Here is the exact process.

1
Open Bank Reconciliation
Go to Banking → Bank Reconciliation → select your bank ledger (e.g. HDFC Bank Current A/C)
2
Open the Import dialog
Press Alt+O or click the Import button in the toolbar at the top of the Bank Reconciliation screen
3
Select the CSV file
Browse to the CSV file you downloaded from this tool. Tally will auto-detect the column structure
4
Map the columns
Confirm the column mapping: Date → Date, Narration → Description, Withdrawal → Debit, Deposit → Credit
5
Import & reconcile
Click Import. Tally matches each row against existing vouchers. Unmatched rows are highlighted for manual reconciliation
Tip: After import, Tally Prime shows each transaction with a status — Auto (matched automatically), Manual (needs your confirmation), or Unlinked (no matching voucher found). Use the reconciliation screen to link unmatched transactions to the correct ledger entries.

Importing into Tally ERP 9

The process in Tally ERP 9 is nearly identical to Tally Prime. The Bank Reconciliation module accepts the same CSV format.

1
Open Bank Reconciliation
Gateway of Tally → Banking → Bank Reconciliation → select the bank account ledger
2
Press Alt+O to import
This opens the bank statement import dialog. Set the date range matching your CSV file
3
Browse and select CSV
Navigate to the CSV file downloaded from this tool. Tally ERP 9 reads the same column structure as Tally Prime
4
Verify & import
Review the preview, confirm column mapping, and click Import. All transactions are loaded into the reconciliation screen
Tally ERP 9 vs Tally Prime: Both versions support CSV bank statement import via Bank Reconciliation. Tally Prime adds automatic matching and a more visual reconciliation interface. The CSV format our tool produces is compatible with both versions.

CSV format

What the Tally-ready CSV looks like

Our export produces columns in the exact structure Tally Prime and ERP 9 expect — no manual reformatting required before import.

bank_statement_tally.csv
Date,Narration,Withdrawal (Dr),Deposit (Cr),Closing Balance
01-04-2025,UPI/NEFT-AMAZON INDIA PVT LTD,1250.00,,1,24,350.75
02-04-2025,SALARY CREDIT-ACME CORP,,85000.00,2,09,350.75
03-04-2025,ATM WITHDRAWAL-KORAMANGALA,,15000.00,,1,94,350.75
04-04-2025,NEFT-HDFC HOME LOAN EMI,42500.00,,1,51,850.75
05-04-2025,UPI-SWIGGY ORDER #8291,485.00,,1,51,365.75
Column
Example value
What Tally does with it
Date
01-04-2025
DD-MM-YYYY or DD/MM/YYYY — Tally accepts both. Our export uses the format your bank statement uses.
Narration
UPI/NEFT-AMAZON INDIA
Transaction description as it appears on your statement. Used by Tally to auto-match against existing vouchers.
Withdrawal (Dr)
12500.00
Debit amounts only. Credit column is left blank. Tally uses separate debit/credit columns for accurate ledger mapping.
Deposit (Cr)
50000.00
Credit amounts only. Debit column is left blank. Salary credits, transfers in, interest income.
Closing Balance
1,24,350.75
Running balance after each transaction. Tally uses this to verify the import matches your actual bank balance.

Why use this

vs. manual data entry or bank portal exports

Bank portals export in wrong format
Many Indian banks export CSV with headers that don't match Tally's expected columns. Our tool outputs the exact structure Tally needs — no reformatting.
Scanned statements work too
Got a paper statement or a scanned PDF? Our OCR engine reads it accurately and produces the same clean CSV output as a digital statement.
Saves hours of manual entry
Entering 3 months of transactions manually into Tally takes hours. Upload the PDF here and import everything into Tally in under 2 minutes.
Works across all banks
SBI, HDFC, ICICI, Axis, PNB, Kotak — every Indian bank formats PDFs differently. Our AI adapts to any statement layout and produces consistent output.
No Tally connector needed
Some tools require installing a Tally connector or enabling ODBC. Our CSV works with the native Bank Reconciliation import built into every version of Tally.
Free to start
This converter is free for everyone with no page limit and no account required.

Importing bank statements into Tally Prime and ERP 9

Tally Prime and Tally ERP 9 are the most widely used accounting platforms in India, and bank statement import is one of the most common tasks for any Tally user doing monthly reconciliation. The built-in Bank Reconciliation module accepts CSV files with a specific column structure -- Date, Narration, Withdrawal, Deposit, and optionally Closing Balance. Our converter takes your bank statement PDF and produces a CSV file that matches this structure exactly, so you can import directly without reformatting anything in Excel first.

One of the biggest time-savers is how our AI handles narration matching. Tally uses the Narration field to match imported transactions against existing vouchers in your company file. The cleaner and more consistent the narration text, the better Tally's auto-matching works. Our AI preserves the original transaction description from your bank statement -- UPI references, NEFT details, cheque numbers -- exactly as they appear, giving Tally the best data to work with during reconciliation.

For businesses that use Tally ledger groups to categorize expenses -- Purchase Accounts, Indirect Expenses, Direct Expenses, and so on -- our AI-assigned categories map naturally to the groups you already have configured. When you import the CSV, you can use the category in the Memo field as a reference to post transactions to the correct ledger. This is especially helpful during quarterly or annual catch-up when you need to process several months of statements in one sitting.

The converter works with statements from all Indian banks -- SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara Bank, and every other bank that issues PDF statements through net banking. It handles both native digital PDFs and scanned paper statements through OCR. Whether you are a CA firm processing statements for multiple clients or a small business owner doing your own books, the workflow is the same: upload the PDF, download the CSV, and import into Tally.

Pricing

See where your money goes

Upload a statement and get answers in seconds. No card required.

Free
Free
No card required
  • 1 analysis / month
  • 50 transactions per document
  • Auto-categorized transactions
  • Money flow visualization
  • Export to CSV, Excel, QIF, OFX & QBO
Upload Free
Most popular
Basic
$9/mo
  • 500 pages / month
  • 100 transactions per document
  • Everything in Free
  • AI savings advisor chat
  • Find hidden subscriptions
  • 12 months history
Pro
$19/mo
  • Everything in Basic
  • Unlimited pages
  • Unlimited transactions per document
  • 5 image recaps / month
  • Priority support

Bank statement to Tally FAQ

How do I import a bank statement into Tally Prime?+
In Tally Prime, go to Banking → Bank Reconciliation → select your bank ledger → press Alt+O (Import). Choose the CSV file you downloaded here, map the columns (Date, Narration, Withdrawal, Deposit), and click Import. Tally will create entries for all unmatched transactions automatically.
What CSV format does Tally Prime accept for bank statement import?+
Tally Prime requires a CSV with columns in this order: Date (DD-MM-YYYY or DD/MM/YYYY), Narration/Description, Withdrawal amount, Deposit amount, and optionally Closing Balance. Our export produces exactly this structure — no manual reformatting needed.
Can I import a bank statement into Tally ERP 9?+
Yes. In Tally ERP 9, go to Gateway of Tally → Banking → Bank Reconciliation → select the bank ledger → press Alt+O to import. The process is nearly identical to Tally Prime. Use the CSV download from this tool and map the columns during the import wizard.
Which banks work with this converter?+
Any bank that provides PDF statements — SBI, HDFC, ICICI, Axis Bank, Kotak, PNB, Bank of Baroda, Canara Bank, Yes Bank, IndusInd Bank, and any other bank worldwide. Both digital PDFs and scanned paper statements are supported.
Does the import create duplicate entries in Tally?+
Tally Prime's reconciliation module has built-in duplicate detection — it matches imported transactions against existing vouchers by date and amount and only flags unmatched ones. For safety, always import only the date range that isn't already entered in Tally.
Can I convert a bank statement to Tally XML format?+
Tally's XML import (used in older workflows or custom TDL scripts) requires a specific voucher XML structure. The recommended modern approach is CSV import via Bank Reconciliation, which is simpler, faster, and supported natively in Tally Prime without any TDL customization. Our CSV export works directly with this method.
How many months of statements can I process at once?+
This converter is free for everyone with no page limit, so you can process monthly, quarterly, or annual statements in one go.
Is my bank statement data kept secure?+
Your PDF is processed in memory and never stored on disk. We never share or sell financial data. All connections use TLS 1.3 encryption. You can request deletion of any stored analysis data at any time from the dashboard.

Import your bank statement into Tally — free.

Upload your PDF — AI extracts every transaction in 30 seconds. Download CSV and import into Tally immediately. First page free.

Upload PDF & Export for Tally →
✓ Free for everyone · ✓ No signup · ✓ Works with Tally Prime & ERP 9

Related reading