Convert bank statement PDFs into clean, Tally-ready Excel and import straight into Tally Prime. Separated debit/credit columns, clean dates and narrations — free, no signup.
Every accountant in India knows this workflow: the client sends a bank statement PDF, the data needs to reach Tally, and the path between the two is painful. Raw bank PDFs have merged narration lines, page headers and footers mixed into the data, combined debit/credit columns, and date formats Tally won't accept. Cleaning a single statement by hand takes 30–60 minutes.
The fix is to get the data into a clean, Tally-compatible Excel structure first — and that's what our converter automates. Upload the bank statement PDF, and the output Excel has exactly what Tally's import needs: one transaction per row, separated debit and credit columns, clean DD-MM-YYYY dates, and complete narrations.
| Column | Format | Notes |
|---|---|---|
| Date | DD-MM-YYYY | Must be a real date value, not text mixed with other data |
| Particulars / Narration | Single-line text | Multi-line narrations from PDFs must be joined into one cell |
| Debit | Number only | Withdrawals — no currency symbols or commas as text |
| Credit | Number only | Deposits — separated from debit, never combined |
| Instrument No. | Optional | Cheque numbers if present in the statement |
Our converter produces this structure automatically from any Indian bank's PDF — SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara and 80+ more formats.
Tally Prime 3.0+ handles Excel import natively — no XML conversion or third-party TDL utility needed for standard bank statement imports.
Tally ERP 9 has no direct Excel import for transactions. Your options are: (a) upgrade to Tally Prime 3.0+, which is the cleanest path; (b) use a TDL-based import utility that reads Excel; or (c) convert the Excel data to Tally XML format and import via Gateway of Tally > Import Data. In all three cases, you still need clean source data first — which is what our converter provides.
Any Indian bank — scanned or digital statements both work
Clean columns: date, narration, debit, credit — balance verified
Tally Prime's built-in import maps the columns and creates vouchers
A single wrong amount in your import means your Tally bank ledger won't reconcile — and finding which of 400 transactions is wrong takes hours. Our converter checks every transaction against the statement's running balance during extraction. If the math doesn't add up on any row, it's flagged before you download. The Excel you import into Tally is arithmetically consistent with the bank's own balance column.