FORMAT LIBRARY

Financial file format guides

Understand the formats used by banks, spreadsheets, QuickBooks, Quicken and Tally before you convert or import financial data.

Bank Statement

A bank statement is an official account activity record that may be delivered as a native PDF, scanned PDF, spreadsheet, or bank-specific export.

View format guide →
CSV

CSV is a plain-text table format in which records are separated by lines and fields by delimiters such as commas.

View format guide →
Excel

Excel workbooks store structured rows in XLSX sheets with formatting, filters, formulas, and typed cells.

View format guide →
IIF

IIF is a tab-delimited import and export format associated with QuickBooks Desktop.

View format guide →
OFX

Open Financial Exchange is a structured financial data specification used to exchange account and transaction information.

View format guide →
QBO

QBO is a QuickBooks Web Connect file based on the OFX family and tailored for importing bank activity into QuickBooks.

View format guide →
QFX

QFX is Quicken's Web Connect financial transaction format and is closely related to OFX.

View format guide →
QIF

Quicken Interchange Format is a line-oriented legacy format used to move account, category, and transaction data.

View format guide →
PDF

PDF is a fixed-layout document format intended for reliable reading, sharing, printing, and archiving.

View format guide →
Google Sheets

Google Sheets is a browser-based spreadsheet that opens CSV and XLSX files and keeps them in Google Drive for sharing and collaboration.

View format guide →
Tally

Tally workflows import structured vouchers and ledger entries into Tally accounting products.

View format guide →