Bank of India Statement to Excel and CSV

Bank of India's mobile app has quick links to download a statement for the last month, three months, six months or a year, by calendar or financial year, and it covers savings, current, overdraft, PPF, term deposit and loan accounts. That's a lot of PDFs with different jobs. Any of them can be uploaded here and turned into an Excel, CSV or JSON file of transactions.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Bank of India statement into Excel

  1. Download the PDF statement from Bank of India online banking

    • Sign in to Bank of India online banking or the Bank of India app.
    • Open the account and go to its statements or transaction history.
    • Choose the statement period and download the statement as a PDF.
    • Save the statement for the period you need as a PDF.
    Go to Bank of India Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Bank of India statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · INR
Sample bank statement rows with made-up data, amounts in INR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Bank of India statements

Pick the financial-year download

For ITR or audit work, the app's financial-year option gives you April to March in one file. One file per year means one opening and one closing balance to reconcile, and the running-balance check covers the whole year in a single pass.

One year of history in the app

The app shows statements and transaction history for up to the past year. For older periods you'll be working from PDFs saved earlier or copies from your branch. Both convert the same way, and any gap between them shows up when the files are compared.

Loan and PPF accounts are separate ledgers

A loan or PPF statement has its own balance, so convert it separately from the savings or current account; mixing them in one sheet makes the balance check meaningless. TDS and interest certificates, also available in the app, are certificates rather than statements and belong with your tax papers.

Narrations kept in one piece

A UPI or IMPS narration on a long statement line can spill onto a second or third line. Excel then sees extra rows with text but no amount. The conversion stitches those lines into one description, so filtering by payee or reference returns whole transactions.

Output and review

From Bank of India PDF to your books

Accounting tip

TallyPrime can import transactions from any Excel layout once you save a mapping template (Alt+O > Manage > Mapping Templates > Transactions). Build one from a converted Bank of India file and reuse it each month; Tally's bank statement import itself expects files downloaded from the bank.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Bank of India statement questions

Can I get more than a year of Bank of India statements?
The app's own history view goes back up to a year. For longer periods, use statements you saved at the time or ask your branch. Convert each PDF here and the files are checked for overlaps and missing months, so a multi-year set lines up before you combine it.
Does the converter read a scanned Bank of India passbook page?
If the passbook page is scanned to PDF, yes: scanned documents are read as well as digital ones. Passbook prints are often faint or slightly skewed, so compare the review screen with the page, especially amounts and balances, before exporting.
What if my Bank of India e-statement is password protected?
Upload it anyway. You'll be asked for the password the bank told you to use, and once you type it the statement converts like any other Bank of India file, with balances checked. The password opens the PDF for this upload and is not saved.
Can I import converted Bank of India rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Bank of India statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Bank of India.