Banks › IOB

IOB statement to Excel, CSV and Tally-compatible XML

Convert a Indian Overseas Bank account statement PDF in your browser. The file and its password never leave your device, and every row is checked against IOB's running balance.

Recognised from the IOB letterhead or IFSC code and read by our general table reader. We have not tested this exact layout yet, so the balance check is your guide.

Statement converter

Processed on this device

Drop bank statement PDFs here

Net-banking PDFs from SBI, HDFC, ICICI, Axis, Kotak and most other banks. Password-protected files are fine. Select several to convert a whole month at once.

Read on this device. Your file is not uploaded.

Or (HDFC + SBI of one business, with a transfer between them).

Load the client's ledgers from Tally to pick only real ledgers and clear Suspense faster.

Send us this statement?

So far this file has stayed on your device. If you choose to send it, we'll use it to fix this bank format for you and everyone else.

What is sent
This one PDF, the bank format and the check result shown here, plus the optional e-mail and note below.
Why
Only to find out why it didn't convert correctly and fix our parser. Nothing else.
Who sees it
Only the KhataSheet team. It's stored privately in our Cloudflare account, never shared, sold or used to train AI.
How long
Deleted automatically after 30 days, or sooner if you ask us with the reference number.

Prefer not to? Send a redacted page instead.

Client ledgers

Load the ledger list from the client's Tally company, so every row is mapped to a ledger that really exists. The file is read on this device and saved only in this browser.

Load ledgers from Tally

Tally XML (Masters or List of Accounts), Excel (.xlsx) or CSV with ledger names and groups.

No Tally file handy? (synthetic "Sharma Traders", exported from TallyPrime) and try it with the HDFC and SBI business samples.

How to export the ledger list from TallyPrime
  1. Open the client's company in TallyPrime.
  2. Press Alt+E (Export) and choose Masters.
  3. Press C (Configure). Set Type of Masters to Accounting Masters (or All Masters) and File Format to XML (Data Interchange). Note the folder path.
  4. Press Esc, then E (Send). Choose the .xml file here.

Prefer Excel? Open Display More Reports → List of Accounts, press Alt+E → Current and pick Excel, or use any sheet with a Name column and an Under (group) column. Tally.ERP 9: Display → List of Accounts → E: Export. Only names and groups are read; balances and addresses are ignored.

A profile file holds this client's ledger names, rules and remembered choices (no statements or amounts). Use it to move the client to another computer or share it with staff.

Saved in this browser only.

Download your IOB statement

  1. Log in to IOB internet banking (or the mobile app).
  2. Open your account, then Account Statement (sometimes under Enquiries or e-Statement).
  3. Choose the period, select PDF and download.
  4. Drop the PDF above. KhataSheet detects the IOB layout automatically.

Menu names change from time to time; look for "Account Statement" in net banking.

What we read

IOB column (typical)KhataSheet output
DateDate
Particulars / NarrationDescription
Cheque / Ref No.Ref
Withdrawals (Debit)Debit
Deposits (Credit)Credit
BalanceBalance

Dates: day-first dates such as 01/04/2024, 01-04-2024 or 01 Apr 2024. Output dates are dd/mm/yyyy in CSV and real dates in Excel.

IOB format details we handle

  • IOB statements are recognised from the letterhead or IFSC code and read by the general table reader.
  • We have not yet tested a sample of this exact layout, so check the balance summary: if every running balance matches, the conversion is complete.
  • If no rows are found, use "Map columns yourself" in the converter, or send us a redacted sample through the contact page.

Password-protected IOB PDFs

Check the covering email from the bank: it states the password format, which is usually built from details such as your customer ID, name, date of birth or registered mobile number. Enter it when KhataSheet asks; it is used only in your browser. If you want an unlocked copy for your records, use the PDF password remover (for your own files).

Questions

Is my IOB statement uploaded?

No. The PDF is read by code running in your browser and never leaves your device. That includes the password if the file is protected.

What is the password of my IOB statement PDF?

Check the covering email from the bank: it states the password format, which is usually built from details such as your customer ID, name, date of birth or registered mobile number. KhataSheet cannot recover or guess passwords.

Which IOB statement layout is supported?

Net-banking PDFs with the usual columns Date, Particulars / Narration, Cheque / Ref No., Withdrawals (Debit), Deposits (Credit), Balance. Dates in the format day-first dates such as 01/04/2024, 01-04-2024 or 01 Apr 2024 are read. If your layout differs, try "Other bank (generic)" in the format menu, or map the columns yourself.

What if a row does not match the balance?

It is flagged in red with the expected and printed balance. Compare it with the PDF and fix the cell; the check re-runs instantly. We never change amounts on our own.

Can I import my IOB statement into Tally?

Yes. Download the Tally-compatible XML: debits become Payment vouchers and credits become Receipt vouchers against your "IOB Bank A/c" ledger (you can rename it), with the counter ledger set by your rules or a suspense ledger.

Other banks

Guides

KhataSheet is not affiliated with Indian Overseas Bank. The bank's name is used only to describe the statement format we read. Sample statements on this page are synthetic.