Bank Statement to Excel
Convert a text-based bank statement PDF into an Excel workbook with real Excel dates, the full narration, separate withdrawal and deposit columns and the balance, plus a summary sheet showing whether every row agrees with the running balance. It runs in your browser, so the statement is never uploaded.
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 Excel
The Excel download is a real .xlsx workbook. The Transactions sheet has Date, Value Date, Narration, Chq / Ref No, Withdrawal (Dr), Deposit (Cr), Balance and the result of the balance check for that row. The Summary sheet lists the date range, opening and closing balances, totals and how many rows passed or failed the check. A plain CSV with the same columns is also available.
Step 1: Convert the Statement
The Excel download is Excel (.xlsx) or CSV with these columns: Date, Value Date, Narration, Chq / Ref No, Withdrawal (Dr), Deposit (Cr), 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 Excel (Excel (.xlsx) or CSV) file. Downloads use the rows exactly as they appear in the preview, including your edits.
Step 2: Import Into Excel
- Convert the statement above and check any flagged rows in the preview.
- Download the Excel workbook (or the CSV). Dates are real Excel dates and amounts are numbers.
- Use filters, SUMIFS or a pivot table to total spending by payee, month or category.
- Import the same file into your accounting software when you are ready to reconcile.
Menu names can differ between Excelversions; 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) or CSV 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) or CSV with the columns Date, Value Date, Narration, Chq / Ref No, Withdrawal (Dr), Deposit (Cr), 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.
Bank statements, ready for Excel
- Free consultation
- No commitment
- Tailored to your team