Bank Statement & File Conversion Glossary
Plain-English definitions of the formats and terms behind our bank statement and accounting-file converters — PDF, CSV, Excel, OFX, QFX, QBO, QIF, IIF, and Tally XML.
PDF Bank Statement
A bank-issued PDF listing account transactions, balances, and account details for a statement period.
CSV (Comma-Separated Values)
A plain-text spreadsheet format where each line is a row and columns are separated by commas.
XLSX (Microsoft Excel Workbook)
The default Microsoft Excel workbook format, based on Open XML.
OFX (Open Financial Exchange)
An open XML-based standard for exchanging financial data between banks and personal-finance software.
QFX (Quicken Financial Exchange)
Intuit's Quicken-branded variant of OFX used for Quicken Web Connect imports.
QBO (QuickBooks Web Connect)
Intuit's QuickBooks Web Connect file format for importing bank transactions into QuickBooks.
QIF (Quicken Interchange Format)
The legacy Quicken text-based format for exchanging accounts, categories, and transactions.
IIF (Intuit Interchange Format)
Intuit's tab-delimited text format used by QuickBooks Desktop to import lists and transactions.
Tally XML
The XML voucher format used by Tally ERP 9 and TallyPrime to import transactions.
OCR (Optical Character Recognition)
Technology that extracts text from images or scanned documents.
Bank Reconciliation
The process of matching a company's ledger transactions to the bank's official statement.
Web Connect
Intuit's method for downloading bank transactions as QFX or QBO files.