What Is QIF Format?
QIF (Quicken Interchange Format) is a text-based file format for importing financial transaction data into personal finance and accounting software. Developed by Intuit (makers of Quicken and QuickBooks), QIF has become a widely supported standard that works across dozens of financial applications.
A QIF file looks like this:
!Type:Bank
D04/28/2026
T-250.00
PStarbucks #1234 Broadway
MCoffee and snacks
^
D04/29/2026
T1500.00
PSalary - ABC Company Ltd
MMonthly salary credit
^
D04/30/2026
T-89.99
PAmazon.com
^
D05/01/2026
T-45.00
PElectricity Bill - National Grid
MApril utility payment
^
D = Date, T = Amount (negative = debit/withdrawal), P = Payee/Description, M = Memo, ^ = End of record
Apps That Import QIF Files
📊
QuickBooks Desktop
File → Import → QIF File → select account → import
💰
Quicken
File → Import → QIF → choose account → import
🐧
GnuCash
File → Import → Import QIF → map accounts
💵
Moneydance
File → Import → select QIF file
🏦
KMyMoney
File → Import → QIF → select file
🏠
HomeBank
File → Import → QIF → map fields
How to Convert Bank Statement PDF to QIF — 3 Steps
1
Upload PDFSelect your bank statement PDF from any bank — US, UK, India, Australia, global
2
Download QIFClick "Download QIF" — get a correctly formatted .qif file in seconds
3
Import to AppFile → Import → QIF in QuickBooks, Quicken, GnuCash or your app
Step-by-Step: Import QIF into QuickBooks Desktop
1
Convert your bank statement PDF to QIFDownload the bank statement PDF from your bank's online banking. Upload it here and click "Download QIF" to get the QIF file.
2
Open QuickBooks DesktopOpen your company file in QuickBooks Desktop (Pro, Premier, or Enterprise). Ensure you are in the correct fiscal year.
3
File → Import → QIF FileFrom the QuickBooks menu: File → Import → QIF File. Browse to select the downloaded .qif file. Click Open.
4
Select the bank accountQuickBooks asks which account to import into. Select your bank account (e.g., "Chase Checking" or "Business Current Account"). Click Import.
5
Review imported transactionsQuickBooks shows a summary of imported transactions. Check the count matches your bank statement. Transactions appear in the account register and can be matched to existing entries or categorised as new expenses/income.
Step-by-Step: Import QIF into Quicken
1
Convert PDF and download QIFUpload your bank statement PDF here, download the QIF file.
2
File → Import → QIF FileIn Quicken (Windows or Mac): File → Import → QIF File. Select the downloaded .qif file.
3
Choose account and formatQuicken asks which account to import into and the QIF format variant. Select "Quicken for Windows" (or Mac). Choose your bank account. Click Import.
4
Review and categoriseQuicken imports all transactions. Review for any duplicates (if you had some transactions already in Quicken), accept the new transactions, and assign categories. Quicken's auto-categorisation may assign categories based on payee names.
QIF vs OFX vs QBO — Which Format Do You Need?
| Format | Full Name | Best For | We Support |
|---|
| QIF | Quicken Interchange Format | Quicken Desktop, QuickBooks Desktop, GnuCash, Moneydance | ✅ This page |
| OFX | Open Financial Exchange | Quicken, MS Money, many apps | ✅ Download as CSV |
| QBO | QuickBooks Online format | QuickBooks Online (QBO) | ✅ /bank-statement-to-qbo-converter |
| CSV | Comma-Separated Values | QuickBooks Online, Xero, FreshBooks, spreadsheets | ✅ All plans |
| Excel | .xlsx spreadsheet | Manual review, any spreadsheet app | ✅ All plans |
Supported Banks for QIF Conversion
United States
Chase
Bank of America
Wells Fargo
Citi
Capital One
US Bank
TD Bank
PNC Bank
Truist
Ally Bank
United Kingdom
Barclays
Lloyds
HSBC UK
NatWest
Santander UK
Halifax
Nationwide
Monzo
Starling Bank
Metro Bank
Australia
CommBank
ANZ
Westpac
NAB
Macquarie
ING Australia
India
HDFC Bank
SBI
ICICI Bank
Axis Bank
Kotak Mahindra
IndusInd Bank
Frequently Asked Questions
What is QIF format and which apps use it?
QIF (Quicken Interchange Format) is a text file format for importing financial transactions. Apps that support QIF import: Quicken (all versions), QuickBooks Desktop, GnuCash, Moneydance, KMyMoney, HomeBank, and many other personal finance apps.
How do I convert a bank statement PDF to QIF?
Upload your bank statement PDF here → click "Download QIF" → open QuickBooks or Quicken → File → Import → QIF File → select the file → choose the account → import. Done in under 3 minutes.
Can I import the QIF file into QuickBooks Online?
QuickBooks Online does not support QIF import — it uses OFX/QBO format or CSV. QIF import is supported in QuickBooks Desktop. For QuickBooks Online, use our CSV download and import via QBO's bank feed upload feature, or see our
QBO converter.
What is the difference between QIF and OFX/QBO format?
QIF is an older, simpler text format (date, amount, payee, memo). OFX and QBO are newer XML-based standards with more fields. QuickBooks Online prefers QBO/OFX. QuickBooks Desktop and Quicken support QIF. Use QIF for desktop apps, CSV for QuickBooks Online.
Is the bank statement to QIF converter free?
Yes, completely free. No signup, no subscription, unlimited conversions. Convert any bank statement PDF to QIF at no cost.
How do I import a QIF file into Quicken?
File → Import → QIF File → select .qif file → choose "Quicken for Windows" format → select the account → Import. Review imported transactions and assign categories as needed.
Which banks are supported for bank statement to QIF conversion?
100+ banks worldwide: US (Chase, Bank of America, Wells Fargo, Citi, Capital One), UK (Barclays, Lloyds, HSBC, NatWest, Santander, Monzo), Australia (CommBank, ANZ, Westpac, NAB), India (HDFC, SBI, ICICI, Axis), Canada (TD, RBC, Scotiabank), UAE (Emirates NBD), and African banks.
Related Converters & Tools
Convert Your Bank Statement to QIF — Free
100+ banks worldwide · QuickBooks & Quicken compatible · No signup · Instant
Convert PDF to QIF Free →