Supported bank statement file formats
Home Budget Analytics reads bank statements in eight file types: CSV, TXT, XLS, XLSX, PDF, OFX, QFX, CAMT.053 (XML) and QIF. Three of these - OFX/QFX, CAMT.053 and QIF - are standardized formats used by many banks worldwide, not tied to any one bank, and are recognized automatically the moment you upload them.
All supported file types
| File type | Extension | Recognized automatically? |
|---|---|---|
| Comma-separated values | .csv, .txt | Automatically for a growing list of banks; any other bank's CSV can be mapped once - see the CSV import guide |
| Excel spreadsheet | .xls, .xlsx | Automatically for supported banks |
| PDF statement | Automatically for supported banks | |
| Open Financial Exchange | .ofx, .qfx | Always - a standardized format, not tied to one bank |
| ISO 20022 camt.053 | .xml | Always - a standardized format, not tied to one bank |
| Quicken Interchange Format | .qif | Always - a standardized format, not tied to one bank |
OFX and QFX
Open Financial Exchange (OFX) is the file format originally built for Quicken and Microsoft Money, and it's still one of the most common statement export options offered by online banking portals across the United States, Canada and the United Kingdom - look for an export option literally labeled "OFX" or "QFX" (Quicken's own variant of the same format) on your bank's transaction history or statements page. If your bank offers it, it's usually the cleanest option: dates, amounts and descriptions are all structured fields, so there's nothing to map.
CAMT.053
camt.053 ("Customer Statement") is part of the ISO 20022 messaging standard that European banks use for account statements, and it's increasingly the standard export option at banks across the EU and UK, usually offered as an XML download alongside CSV. Because it's a strict, well-defined standard rather than a bank-specific layout, Home Budget Analytics reads it the same way regardless of which bank issued it.
QIF
Quicken Interchange Format (QIF) is an older, simpler standard than OFX - plain text, one transaction per block. It's less common on modern banking portals than it used to be, but it's still offered by some banks and by other finance tools as an export option, and Home Budget Analytics reads it directly.
Don't see your bank's format here?
If your bank only offers a plain CSV export with its own column layout, that's still fully supported - map it once and it's remembered for every future statement from that bank.
See the CSV import guide