/ Guides
Bank statements, files and imports, explained.
Plain answers to the questions that come up between a bank statement and your books. Every guide lists its sources and the date they were last checked.
01 / Import guides
Into your accounting software.
The exact clicks to get bank transactions into QuickBooks and Xero, which file each one wants, and what to do when an import fails.
- How to import a bank statement into QuickBooks OnlineUpload QBO, QFX, CSV or PDF files, with the limits and the fixes.
- How to import a bank statement into QuickBooks DesktopWeb Connect (.qbo) or IIF: which to use, and the steps for each.
- How to import a bank statement into XeroOFX, QIF, CSV or PDF: Xero’s rules and the exact clicks.
02 / File types
What these files are.
Banks and accounting apps hand out QBO, QFX, OFX, QIF and IIF files. What each one holds, what opens it, and how to read it without the software.
- What is a QBO file?QuickBooks’ bank download format: what is inside, what opens it, and common import errors.
- What is a QFX file?Quicken’s bank download format, and why Quicken sometimes refuses one.
- What is an OFX file?The open bank-download format, and the apps that import it.
- What is a QIF file?The old plain-text format Quicken made popular, and where it still works.
- What is an IIF file?QuickBooks Desktop’s import file, and how to use it without damaging your books.
03 / Statements in Excel
Statements in Excel.
Getting a bank statement PDF into a spreadsheet, checking it adds up, and reconciling it against your own records.
04 / Indian bank passwords
Locked Indian bank statements.
The statement PDF password for 13 Indian banks, from SBI and HDFC to IDFC FIRST and Yes Bank, taken from the banks or tested on real statements.
- Indian bank statement passwords, checked bank by bankEvery rule, from the bank or tested by us, side by side, with sources.
- HDFC Bank statement passwordYour numeric Customer ID, and where to find it.
- SBI statement passwordFour formats, depending on how you got the statement.
- ICICI Bank statement passwordICICI’s two credit card rules, in its own words.
- Axis Bank statement passwordName letters plus birth date, or plus your Customer ID.
- Federal Bank statement passwordFour capital letters and your birth date, with Federal Bank’s example.
- Union Bank of India statement passwordFour capital letters and your birth date, tested on a real statement.
- PNB statement passwordYour account number or your customer ID, tested on a real statement.
- Kotak Mahindra Bank statement passwordName letters plus birth date, or your CRN, tested on a real statement.
- IndusInd Bank statement passwordFour capital letters and your birth date, tested on a real statement.
- IDBI Bank statement passwordYour customer ID, nothing else, tested on a real statement.
- Bank of Baroda statement passwordName letters plus birth date, or your customer ID, tested on a real statement.
- IDFC FIRST Bank statement passwordDate of birth, PAN or customer ID: always one of the three.
- Yes Bank statement passwordCustomer ID plus DDMMYYYY, or one of the two alone.