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

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.

Detailed walkthrough

How to import CSV to Tally Prime step-by-step

Nine screens, every keystroke. Follow this exact sequence after downloading your CSV from the converter above — no Tally configuration or TDL customization required.

Open the Gateway of Tally

Launch Tally Prime and select the company file you want to import the bank statement into. The Gateway of Tally is the main menu you land on after opening a company.

⌨ Press G or click "Gateway of Tally"

Tally Prime · Release 4.0

Gateway of Tally

Masters
Transactions
Utilities
Reports
> Banking
Display More Reports
Quit

F1: HelpBankingEsc: Quit

Navigate to Banking → Bank Reconciliation

From Gateway of Tally, choose Banking. From the Banking submenu, pick Bank Reconciliation. This opens the screen where you select which bank ledger to reconcile.

⌨ Banking → Bank Reconciliation (or press B then R)

Tally Prime · Release 4.0

Banking

Cheque Register
Cheque Printing
> Bank Reconciliation
Deposit Slip
Payment Advice
Auto Reconciliation

F1: HelpBank ReconciliationEsc: Quit

Select your bank ledger

Tally lists every bank ledger in your company file. Pick the one matching your statement — for example, "HDFC Bank Current A/C 50100123456" or "ICICI Savings 003001234567". The ledger name and account number must match the statement you are importing.

⌨ Use ↑↓ arrow keys, then press Enter

Tally Prime · Release 4.0

List of Ledgers

Axis Bank Current
> HDFC Bank Current A/C
ICICI Bank Savings
Kotak Mahindra Bank
SBI Current Account

F1: HelpHDFC Bank Current A/CEsc: Quit

Press Alt+O to open Import

On the Bank Reconciliation screen, press Alt+O — this is the Tally shortcut for "Import" and opens the file picker. Alternatively, click the "Import" button in the right-side button panel.

⌨ Alt + O

Tally Prime · Release 4.0

Bank Reconciliation — HDFC Bank Current A/C

F2: Period
F3: Company
F4: Bank
F5: Reconcile
F6: Show Voucher
> Alt+O: Import Statement
F12: Configure

F1: HelpO: ImportEsc: Quit

Browse to your downloaded CSV

The Import Bank Statement dialog asks for the file path. Click Browse and navigate to the CSV you downloaded from mybankstatementanalysis. By default, browser downloads land in C:\Users\YourName\Downloads on Windows or ~/Downloads on Mac.

⌨ Browse → select bank_statement_tally.csv

Tally Prime · Release 4.0

Import Bank Statement

File Format: CSV (Comma Separated)
File Path:
> C:\Users\...\Downloads\bank_statement_tally.csv
From Date: 01-Apr-2025
To Date: 30-Apr-2025
[Browse]   [Open]   [Cancel]

F1: HelpC:\Users\...\Downloads\bank_st…Esc: Quit

Confirm column mapping

Tally previews the first few rows and asks you to map columns. Our export already uses Tally's expected names, so the mapping is one-to-one: Date → Date, Narration → Particulars, Withdrawal → Debit, Deposit → Credit, Closing Balance → Balance. Confirm and continue.

⌨ Verify mapping → press Enter

Tally Prime · Release 4.0

Column Mapping

CSV Column         →  Tally Field
──────────────────────────────
Date               →  Date ✓
Narration          →  Particulars ✓
Withdrawal (Dr)    →  Debit ✓
Deposit (Cr)       →  Credit ✓
Closing Balance    →  Balance ✓

F1: HelpAll columns auto-mapped ✓Esc: Quit

Review the import preview

Tally shows every row from the CSV with a status: Matched (an existing voucher already covers this row), Unmatched (no voucher yet — Tally will create one on import), or Conflict (date/amount close to a voucher but not exact). Scroll through and verify.

⌨ Scroll, verify amounts, then Ctrl+A to accept

Tally Prime · Release 4.0

Import Preview — 47 rows

Date         Particulars                Dr        Cr      Status
01-04-2025   UPI/AMAZON INDIA           1,250.00  -       Unmatched
02-04-2025   SALARY-ACME CORP           -         85,000  Matched
03-04-2025   ATM-KORAMANGALA            15,000    -       Unmatched
04-04-2025   NEFT-HDFC HOME LOAN EMI    42,500    -       Unmatched
05-04-2025   UPI-SWIGGY ORDER           485       -       Conflict

F1: HelpMatched: 12  ·  Unmatched: 33 …Esc: Quit

Click Import to finalise

Press Ctrl+A or click Accept to commit the import. Tally creates Bank Receipt and Bank Payment vouchers for every Unmatched row, links Matched rows to their existing vouchers, and stages Conflicts for your manual review on the next screen.

⌨ Ctrl + A (Accept) or click "Yes"

Tally Prime · Release 4.0

Confirm Import

Import 47 transactions into HDFC Bank Current A/C?
   33 vouchers will be created
   12 vouchers will be linked
   2 rows flagged for manual review
   [> Yes ]    [ No ]

F1: HelpYesEsc: Quit

Resolve conflicts on the reconciliation screen

Tally returns you to the Bank Reconciliation screen with the imported transactions visible. Conflict rows appear at the top — for each one, choose to link it to an existing voucher, create a new one, or skip. Once everything is linked, the Closing Balance at the bottom should match your statement's closing balance exactly.

⌨ Press F5 (Reconcile) on each conflict row

Tally Prime · Release 4.0

Bank Reconciliation — Final

Status: Reconciled
Total Debits:    61,235.00
Total Credits:   85,000.00
Net Movement:    +23,765.00
Opening Balance: 1,27,600.75
Closing Balance: 1,51,365.75

F1: HelpClosing Balance: 1,51,365.75 ✓…Esc: Quit

End result

All transactions from your bank statement PDF are now live in Tally Prime as Bank Receipt and Bank Payment vouchers, linked to the right ledger, with the closing balance reconciled. The whole process — PDF upload to reconciled Tally — typically takes under 4 minutes for a one-month statement and under 8 minutes for a quarterly statement.

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

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.

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