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 bank statement hereTap to upload your statement

or click to browse — PDF, JPG or PNG

Free·No signup·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

Step 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.

Step 2

AI extracts every transaction

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

Step 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.

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.

Open Bank Reconciliation

Go to Banking → Bank Reconciliation → select your bank ledger (e.g. HDFC Bank Current A/C)

Open the Import dialog

Press Alt+O or click the Import button in the toolbar at the top of the Bank Reconciliation screen

Select the CSV file

Browse to the CSV file you downloaded from this tool. Tally will auto-detect the column structure

Map the columns

Confirm the column mapping: Date → Date, Narration → Description, Withdrawal → Debit, Deposit → Credit

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.

Open Bank Reconciliation

Gateway of Tally → Banking → Bank Reconciliation → select the bank account ledger

Press Alt+O to import

This opens the bank statement import dialog. Set the date range matching your CSV file

Browse and select CSV

Navigate to the CSV file downloaded from this tool. Tally ERP 9 reads the same column structure as Tally Prime

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

Your first 3 pages are free — no account required. A typical monthly statement is 2–3 pages, so one month is usually free to process completely.

Pricing

Simple, transparent pricing

Free

Try it out

3 PDF pages / month
AI transaction categorization
Sankey money-flow chart
AI insights & savings tips
Financial health score
Spending calendar
CSV export

Start Free

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?+−

Free tier: 3 PDF pages/month. A typical Indian bank statement for one month is 2–4 pages. For bulk processing (quarterly or annual statements, multiple accounts), paid plans start at $9/month for 500 pages.

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. Free for your first 3 pages.

Upload PDF & Export for Tally →

✓ 3 pages free · ✓ No signup · ✓ Works with Tally Prime & ERP 9