What is a CAMT.053 file? The ISO 20022 statement explained
CAMT.053 is the ISO 20022 bank-to-customer statement format used by many European banks. Learn its structure, versions such as camt.053.001.08, and how to convert it to CSV or Excel.
CAMT.053 vs MT940: What’s the difference?
CAMT.053 and MT940 are both bank statement formats, but they differ in structure and detail. Compare the two and see which converters Bankfile supports.
How to open an MT940 file and view it in Excel
MT940 (.sta) files open in any text editor, but the :61: and :86: tags are hard to read. Learn what they mean and how to view the statement in Excel or CSV.
How to open a QBO file without QuickBooks
A .qbo bank download is an OFX-based file, not a QuickBooks company file. Here's how to inspect its transactions without installing or logging into QuickBooks.
QFX vs OFX: What’s the difference?
What is a QFX file? QFX is Quicken's variant of the OFX format. Learn how the two file formats relate, why they look alike, and how to convert either to Excel or CSV.
How to convert a bank statement to Excel
A practical guide to converting bank statement exports — CAMT.053, MT940, OFX, QFX, QBO and QIF — into Excel, and what to check before relying on the result.
What is a QIF file? Quicken Interchange Format explained
QIF (Quicken Interchange Format) is a line-based text format for financial transactions. Learn the QIF file format, its limitations, and how to convert it to CSV or Excel.
How to open an OFX file and import it into Excel
Open .ofx bank and credit-card files in Excel: how the SGML and XML styles differ, what's inside, and how to turn OFX transactions into a spreadsheet.
What is an OFX file? The OFX format explained
OFX (Open Financial Exchange) is the file format many banks use for transaction downloads. Learn how an OFX file is structured, how versions differ, and how to open one.
What is a QBO file? QuickBooks Web Connect explained
A QBO file is a QuickBooks Web Connect bank download based on the OFX format. Learn what's inside, how QuickBooks uses it, and how to open it without QuickBooks.