Bank Statement to TallyPrime
Convert a text-based bank statement PDF, or the CSV or Excel download, into an Excel sheet with Date, Narration, Withdrawal, Deposit and Balance columns for TallyPrime work: recording receipt and payment vouchers and reconciling the bank ledger. The conversion runs in your browser and checks every row against the running balance first.
Your statement stays on your device. The PDF or spreadsheet is read by your browser and is never uploaded to ERPPlugs or anyone else. No account is needed, and nothing is stored after you close the page.
Choose your statement
A text-based PDF downloaded from net banking, or the CSV / Excel (.xlsx) download. Password-protected PDFs are fine: you will be asked for the password, and it never leaves your browser.
How It Works with TallyPrime
The TallyPrime output is a single Excel sheet with real Excel dates and numeric amounts in five columns: Date, Narration (with the cheque or reference number appended), Withdrawal, Deposit and Balance. Whether TallyPrime can import that sheet directly depends on your release and bank, so check what your version supports; otherwise use it as the reference list while you record or match vouchers. This is a one-off conversion tool. For bank data that reaches TallyPrime every day without files, ERPPlugs offers banking connectors.
Need this every day?
The converter handles one-off files. For data that syncs into TallyPrime without downloading statements, see the related ERPPlugs connector.
View the TallyPrime connectorStep 1: Convert the Statement
The TallyPrime download is Excel (.xlsx) with these columns: Date, Narration, Withdrawal, Deposit, Balance.
- 1
Choose the statement
Pick a text-based bank statement PDF (enter the password if it is protected) or the CSV or Excel download. The file is read in your browser and never uploaded.
- 2
Check the rows
The converter finds the table from its column headers, then checks every row against the running balance and the totals against the closing balance. Flagged rows can be edited or deleted in the preview.
- 3
Download
Download the TallyPrime (Excel (.xlsx)) file. Downloads use the rows exactly as they appear in the preview, including your edits.
Step 2: Import Into TallyPrime
- Convert the statement above, check the flagged rows, then download the TallyPrime file.
- Open the bank ledger in TallyPrime and go to its bank reconciliation screen.
- If your TallyPrime release can import the statement for your bank, load the file there; otherwise keep the sheet open as the reference while you record receipt and payment vouchers.
- Match each line against your vouchers using the narration and amount, then reconcile what is left.
Menu names can differ between TallyPrimeversions; check your version's help if an option is labelled differently.
Checks Before You Import
A converted statement is only useful if it agrees with the bank's own balances. The converter runs the first two checks for you; do the last two by eye before you import the Excel (.xlsx) file.
Running balance, row by row
For every row, the previous balance minus the withdrawal plus the deposit must equal the balance printed on the bank statement, within one paisa. A row that fails usually means a misread amount, a missed row or a junk line.
Opening to closing balance
The opening balance plus total deposits minus total withdrawals should equal the closing balance. For example, an opening balance of ₹1,00,000 with ₹2,50,000 of deposits and ₹1,80,000 of withdrawals should close at ₹1,70,000.
Date range
The first and last dates shown should match the statement period you downloaded, with no pages missing in between.
References intact
Spot-check a few UPI, NEFT and cheque rows to confirm the full narration came through, because that text is what you match against ledger entries.
If a check fails, fix or delete the row in the converter's preview table before downloading rather than editing the file afterwards, so the export and the statement stay in step.
Bank Statement Pages
Notes on common statement layouts. The converter is not limited to these banks: any text-based statement with a recognisable header row can be tried.
Frequently Asked Questions
Excel (.xlsx) with the columns Date, Narration, Withdrawal, Deposit, Balance. Dates are written as dd/mm/yyyy (real Excel dates in .xlsx files), and amounts are plain numbers without thousands separators.
It has no per-bank templates. It reads text-based statements whose table has a recognisable header row, using common Indian bank column names such as Narration, Particulars, Withdrawal Amt., Deposit Amt., Debit, Credit and Closing Balance. Bank pages for HDFC Bank, SBI, ICICI Bank, Axis Bank and others are linked on this page; statements from other banks can be tried the same way.
Each row is checked against the running balance (previous balance minus withdrawal plus deposit must equal the printed balance), and the opening balance plus deposits minus withdrawals is compared with the closing balance. Failed rows are flagged in the preview, where you can edit or delete them before downloading.
No. The browser tool reads the text layer of a PDF and does not do OCR. If a PDF has no text layer, as with a scanned or photographed statement, the tool says so. Download the statement again from internet banking as a PDF, CSV or Excel file instead.
No. The converter runs entirely in your browser. The PDF or spreadsheet is read on your device, nothing is uploaded to ERPPlugs or anyone else, and nothing is kept after you close the page. A PDF password is used only to open the file in that browser tab.
Yes. The converter is for one-off files. For bank data that reaches TallyPrime without downloading and converting statements, ERPPlugs offers connectors; see the connector link on this page.
Other Output Formats
Bank statements, ready for TallyPrime
- Free consultation
- No commitment
- Tailored to your team