Home Budget
Analytics

Resources

Supported bank statement file formats

Home Budget Analytics reads bank statements in these 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 typeExtensionRecognized automatically?
Comma-separated values.csv, .txtAutomatically for some banks; for any other bank's CSV you match the columns once and save the mapping - see the CSV import guide
Excel spreadsheet.xls, .xlsxAutomatically for Santander, Monobank and PrivatBank. Other banks' Excel files aren't supported yet - export CSV instead
PDF statement.pdfAutomatically for Santander, Monobank, Sparkasse and Scotiabank
Open Financial Exchange.ofx, .qfxAlways - a standardized format, not tied to one bank
ISO 20022 camt.053.xmlAlways - a standardized format, not tied to one bank
Quicken Interchange Format.qifAlways - 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 supported - match the columns once, save the mapping, and pick it from your saved mappings for every future statement from that bank.

See the CSV import guide