Perimattic
Free Tool

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.
Hand on a laptop displaying a data spreadsheet on a wooden desk

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.

1

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

  1. Convert the statement above and check any flagged rows in the preview.
  2. Download the Excel workbook (or the CSV). Dates are real Excel dates and amounts are numbers.
  3. Use filters, SUMIFS or a pivot table to total spending by payee, month or category.
  4. 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.

FAQ

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.

ERPPlugs

Bank statements, ready for Excel

Convert a statement now: free, no account, and your statement never leaves your browser. Want bank entries posted to your ERP automatically? Talk to us.
  • Free consultation
  • No commitment
  • Tailored to your team