Rental income looks simple until tax time, when every repair, insurance payment, and rent deposit needs its own line. If your rental cash flows through Bank of India, the move that changes everything is to convert Bank of India statement PDF to Excel: one conversion per month, and the year's property finances separate themselves into income and deductible expenses with pivot-table ease. Schedule E stops being a guessing game.
The core problem for most landlords is commingling — rent arrives in the same account that pays for groceries. A converted spreadsheet does not require you to open a separate account retroactively; it lets you tag and filter, which achieves the same separation on paper. This guide shows the full workflow.
Separating rental cash flow from personal spending
Start with the year's converted statements in one workbook. Add two columns to each monthly tab: Property (which unit or address, if you own more than one) and Category (Rent received, Repairs, Insurance, Property tax, Utilities, Mortgage interest, Personal). Then work through the descriptions: rent deposits are usually the largest regular credits, and property expenses tend to repeat with the same payees.
The payoff is immediate. Filter Category to exclude Personal and you have the property's true cash flow — the number that tells you whether the rental actually made money this year. Filter further by Property and multi-unit owners get per-unit profit and loss without a separate bookkeeping system. Lenders and partners accept this format readily because every figure traces back to a bank line.
Convert your Bank of India statement in 3 steps
Step 1 — Download the PDF from Bank of India. Log in to Bank of India's internet banking or mobile app, open the account, and download each month's e-statement for the tax year. Save them in one folder per property if you own several.
Step 2 — Upload to a statement converter. Convert Statement accepts Bank of India PDFs directly in the browser. Files are processed in memory and deleted the moment conversion finishes — balances and account numbers are never stored. Enter the PDF password once at upload if the file is protected.
Step 3 — Download the Excel file. Dates land as real dates, amounts as numbers, and every transaction keeps its original description. Twelve months convert in minutes; combine them into one workbook and add your Property and Category columns.
Building a Schedule E worksheet from your statement
Schedule E wants rental income and expenses in fixed buckets: rents received, repairs, insurance, taxes, utilities, mortgage interest, depreciation, and other. Your Category column already maps to these — a pivot table with Category as rows and SUM of amounts as values produces the return's expense section almost verbatim. Rents received total from the credit side; everything else is deductible expense.
Two categories need extra care. Repairs versus improvements: a repair keeps the property in working order and is deducted this year; an improvement adds value and is depreciated over years. Tag them separately (RPR vs IMP) so your preparer can treat them correctly. Security deposits: deposits you hold are not income until forfeited — tag them DEP and exclude them from the rent total, or you will overstate income. For the conversion mechanics in general, see how PDF-to-Excel conversion works, and for NRI landlords the reporting rules in NRI bank account statements in India.
Security deposits, repairs, and your paper trail
The IRS cares about substantiation, and your workbook is most of it: every expense line ties to a dated bank transaction. Staple the discipline together by keeping the original PDFs alongside the workbook — the spreadsheet is the working copy, the PDFs are the source documents. For big repairs, keep the contractor invoice in the same folder; the bank line proves payment, the invoice proves purpose.
Run the same workflow every quarter and estimated taxes get easier too: year-to-date rental profit is a filtered SUM, which is the number quarterly payments are based on. For the deduction side beyond rentals, using bank statements for income tax returns covers the full checklist, and the Bank of India converter page has the bank-specific details.
Frequently asked questions
Is it free to convert a Bank of India statement to Excel?
Yes — your first 8 pages are free on Convert Statement with no credit card required, enough for most one-to-three-month statements.
Can I track multiple rental properties in one workbook?
Yes. Add a Property column tagging each row with the unit or address, then filter or pivot by it for per-property profit and loss.
How do I handle security deposits?
Tag deposit receipts separately and exclude them from rental income — deposits you hold are not income until forfeited. Only count them as income if you keep part of one.
Repairs or improvements — does it matter?
A great deal. Repairs are deducted in the year paid; improvements are depreciated over years. Tag them separately in your Category column so your preparer classifies them correctly.
Is uploading my statement safe?
Files are processed in memory and deleted immediately after conversion, never stored on disk or in a database, under GDPR and CCPA standards.
Turn this year's rental records into next year's easiest return. Convert your Bank of India statement to Excel free and build the Schedule E worksheet from real data. Managing several properties or a full year at once? See plans for higher volumes.