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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Bank of India statement into Excel
-
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.
-
Upload it here
Scans and phone photos work too.
-
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.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | 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.
-
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?
Does the converter read a scanned Bank of India passbook page?
What if my Bank of India e-statement is password protected?
Can I import converted Bank of India rows into QuickBooks or Xero?
Convert your Bank of India statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Bank of India.