Toolzy
Finance and document tools
ToolsBank statementsAI AgentsPricingInsightsHelp CenterContact Us
Home/Bank statement converter/Loan & visa applications

Convert bank statement PDF to Excel for loan and visa applications

Lenders, mortgage underwriters, and visa consulates frequently request 6 to 12 months of bank statements to verify steady income, calculate average monthly balance (AMB), and evaluate financial solvency. Toolzy converts multi-page digital PDF statements into clean Excel spreadsheets so you can easily sort transactions, run formulas, and build clear financial summaries. Toolzy does not evaluate creditworthiness or issue financial certificates; it converts your statements into editable spreadsheets. Preview page 1 without signing in. Files are deleted within 24 hours.

Open the bank statement converter10 free pages · 1 credit per page
  • SBI
  • HDFC
  • ICICI
  • Axis
  • Kotak
  • Bank of Baroda
  • PNB
  • Canara
  • Union Bank
  • IDFC FIRST
  • YES Bank
  • IndusInd
  • Bank of India
  • Indian Bank
  • Central Bank of India
  • IDBI Bank
  • Federal Bank
  • Indian Overseas Bank
  • UCO Bank
  • AU Small Finance Bank
  • RBL Bank
  • Bandhan Bank
  • South Indian Bank

Five steps to summarise bank statements in Excel

  1. Download official e-statements: Download detailed 6-month or 12-month PDF e-statements from your bank's net banking portal (e.g. SBI, HDFC, ICICI, Axis, Kotak).
  2. Upload and unlock: Upload the PDF statement to Toolzy. If the PDF was password-protected by your bank, enter the password to decrypt it safely in memory.
  3. Preview and download Excel: Inspect the first-page table preview, then download the complete statement in Excel (.xlsx) format.
  4. Calculate salary credits and AMB: Use Excel formulas (such as SUMIFS and AVERAGE) on the Credit and Balance columns to tally recurring salary deposits and average monthly balance.
  5. Prepare summary working paper: Highlight recurring EMI debits, rent, and investments to present an organized financial overview alongside your original PDF statements.

Key financial metrics you can calculate

Average Monthly Balance (AMB)

Use the exported Balance column with Excel AVERAGE formulas to compute daily or monthly average balances required for visa proof of funds.

Salary and Income Verification

Filter the Credit column by salary, bonus, dividend, or freelance receipts to prove consistent monthly cash inflows to underwriters.

Existing Debt Obligations (EMI)

Isolate recurring loan EMIs, credit card debits, and insurance premiums in the Debit column to calculate your debt-to-income (DTI) ratio.

Account Header Verification

Toolzy's Account sheet preserves account holder name, account number, bank branch, and period dates matching your official KYC documents.

Converting statements for business clients?

Explore bulk conversion workflows for chartered accountants and loan consultants.

View CA firm workflows →

Frequently asked questions

Does Toolzy issue financial certificates or visa sponsorship letters?

No. Toolzy is an independent software tool that converts your existing digital bank-statement PDF into an Excel spreadsheet. Financial decisions and visa approvals rest entirely with lenders and consular authorities.

How do I calculate Average Monthly Balance (AMB) in Excel?

Toolzy exports daily running balances into the Balance column of the Transactions sheet. In Excel, use the AVERAGE formula across statement dates to calculate your average balance for each month.

Are multi-month statements supported?

Yes. Statements spanning 6, 12, or more months can be converted up to 50 MB per file, with each transaction extracted chronologically into a single spreadsheet.

Are password-protected statement PDFs supported?

Yes. Indian bank statement passwords are used in memory to unlock the file and are never stored or logged. Uploads and converted files are deleted within 24 hours.

Can I upload scanned statements or passbook photos?

No. Toolzy accepts only digital PDF e-statements downloaded from net banking with a text layer. Scanned images and passbook photographs are detected and rejected.

How much does it cost?

New accounts get 10 free pages on signup. Additional conversion credits start from $3 for 100 pages ($0.03 per page). Credits never expire.

Indian banks covered

Upload any digital account-statement PDF downloaded from net banking:

  • State Bank of India
  • HDFC Bank
  • ICICI Bank
  • Axis Bank
  • Kotak Mahindra Bank
  • Bank of Baroda
  • Punjab National Bank
  • Canara Bank
  • Union Bank of India
  • IDFC FIRST Bank
  • YES Bank
  • IndusInd Bank
  • Bank of India
  • Indian Bank
  • Central Bank of India
  • IDBI Bank
  • Federal Bank
  • Indian Overseas Bank
  • UCO Bank
  • AU Small Finance Bank
  • RBL Bank
  • Bandhan Bank
  • South Indian Bank

Convert your bank statement to Excel

Preview the first page of your statement without signing in. New accounts get 10 free pages. Files are deleted within 24 hours.

Open the bank statement converter10 free pages · 1 credit per page
For CAs and bookkeepers·For CA firms (multi-client)·Tally XML converter·Password-protected PDFs·ITR & GST working papers·Zoho Books (CSV)·QuickBooks (CSV)·GST reconciliation (Excel)·Loan & visa applications·Toolzy vs generic converters·SBI statement·HDFC statement·ICICI statement·Axis statement·Kotak statement·Bank of Baroda statement·PNB statement·Canara statement·Union Bank statement·IDFC FIRST statement·YES Bank statement·IndusInd statement·Bank of India statement·Indian Bank statement·Central Bank of India statement·IDBI Bank statement·Federal Bank statement·Indian Overseas Bank statement·UCO Bank statement·AU Small Finance Bank statement·RBL Bank statement·Bandhan Bank statement·South Indian Bank statement
Privacy Policy•Terms & Conditions•Contact
Toolzy © 2026 — finance, document, and developer toolsOwned and operated by Toolzy Team