Bank Statement to QIF — Free Converter

Upload your bank statement PDF and download a QIF file ready to import into Quicken, QuickBooks Desktop, or any QIF-compatible accounting software. Every transaction extracted and categorized by AI.

Drop your bank statements hereUpload your bank statements
or click to browsePDF, JPG or PNG · multiple files supported
Free·No signup·PDF deleted after analysis
... statements analyzed
|See a live example →

How it works

1

Upload your PDF

Drop your bank statement PDF — scanned or digital. JPG and PNG images of statements are also supported.

2

AI extracts every transaction

Our AI reads each transaction and structures it: date, payee name, amount, and spending category — ready for QIF formatting.

3

Download QIF & import

Download the .qif file and import it into Quicken, QuickBooks Desktop, Moneydance, GnuCash, or any QIF-compatible software.

What's in the QIF file

Every transaction is structured with the standard QIF fields your software expects.

QIF Field
Example
Notes
D (Date)
10/15/2025
Transaction date in MM/DD/YYYY format — the standard QIF date format recognized by all QIF-compatible software.
T (Amount)
-67.42
Transaction amount. Negative for expenses and withdrawals, positive for deposits. Debit/credit columns are merged into one signed value.
P (Payee)
WHOLEFDS MKT #10247
Merchant or payee name as it appears on your statement. Quicken and QuickBooks use this to auto-match memorized payees.
L (Category)
Groceries
AI-assigned category. Maps to your Quicken/QuickBooks category list — you can remap during import if needed.
N (Number)
1247
Check number, when present. Extracted from check transactions so Quicken can match them to your check register.

Sample QIF output

This is what the generated .qif file looks like — plain text that any compatible software reads instantly.

!Type:Bank
D10/15/2025
T-67.42
PWHOLEFDS MKT #10247
LGroceries
^
D10/15/2025
T-4.75
PSTARBUCKS #8291
LDining Out
^
D10/14/2025
T-1,850.00
PZELLE TO LANDLORD
LHousing
^
D10/14/2025
T2,847.63
PPAYROLL - ACME CORP
LIncome
^
Each transaction block starts with the fields (D, T, P, L) and ends with ^ as a record separator. The header !Type:Bank tells your software this is a bank account (vs. credit card or investment).

When you need a bank statement to QIF converter

PDF is what your bank gives you. QIF is what your accounting software needs. Here's when the gap matters most.

Your bank stopped supporting QIF downloads
Many banks have dropped QIF/QFX exports in favor of OFX or pushing you toward their own apps. If your bank no longer offers QIF downloads, upload the PDF statement here and get the QIF file you need.
Importing old statements into Quicken
Digitizing years of paper statements? Scan them to PDF (or snap a photo), upload here, and import the QIF into Quicken. Build a complete transaction history going back as far as you have statements.
Switching banks without losing history
Moving from Chase to a credit union? Your old bank's PDF statements are your only record. Convert them to QIF and import into your accounting software so your financial history stays unbroken.
QuickBooks Desktop won't connect to your bank
QuickBooks Desktop's direct bank feeds break regularly. When they do, download your statement as PDF from your bank's website, convert it here, and import the QIF manually.
Accountant needs your data in Quicken format
Some accountants and bookkeepers specifically request QIF files. Instead of paying them to manually enter transactions from your PDF, hand them a clean QIF file.
Processing statements from multiple banks
If you have accounts at different banks, each with different export formats, converting all PDFs to QIF gives you one consistent format to import everywhere.

Compatible software & import instructions

Step-by-step import for every major QIF-compatible tool.

Quicken

Quicken Classic, Quicken Simplifi, Quicken Deluxe, Quicken Premier
How to import: File → Import → QIF File. Select the account, map categories if prompted, and click Import.
Quicken has native QIF support across all versions. It will auto-match payees to your memorized payee list.

QuickBooks Desktop

QuickBooks Pro, Premier, Enterprise
How to import: File → Utilities → Import → QIF Files. Select the .qif file and assign the target bank account.
QuickBooks Desktop imports QIF natively. QuickBooks Online does not support QIF — use our CSV export instead.

GnuCash

All versions (free, open-source)
How to import: File → Import → Import QIF. Select the file, map accounts, and click Forward through the wizard.
GnuCash has one of the best QIF importers — it handles multi-account QIF files and duplicate detection automatically.

Moneydance

All versions
How to import: File → Import → QIF File. Select the account and import.
Moneydance supports QIF with automatic payee matching and duplicate transaction detection.

Microsoft Money (Sunset)

Microsoft Money Plus Sunset Deluxe (free)
How to import: File → Import → QIF. Select the file and target account.
Microsoft Money was discontinued but the Sunset edition still works and accepts QIF imports.

QIF vs CSV — which format do you need?

We generate both. Here's how to pick the right one.

FeatureCSVQIF
Quicken importRequires column mappingNative — one click
QuickBooks DesktopSupported with setupNative — one click
QuickBooks OnlineSupportedNot supported
Excel / Google SheetsOpens directlyNot a spreadsheet format
GnuCashNeeds configurationNative import wizard
Category dataColumn in fileL field — maps to software categories
Payee matchingManualAuto-matches memorized payees
Check numbersOptional columnN field — auto-populates register
Rule of thumb: If you use Quicken, QuickBooks Desktop, GnuCash, or Moneydance — download QIF. If you use Excel, Google Sheets, or QuickBooks Online — download CSV. We provide both formats from every upload.

Works with any bank

Any PDF bank statement from any bank worldwide converts to QIF. Popular ones include:

ChaseBarclaysHSBCDeutsche BankBNP ParibasINGBank of AmericaSantanderHDFC BankTD Bank+ 10,000 banks worldwide

Frequently asked questions

What is a QIF file?+
QIF (Quicken Interchange Format) is a plain-text file format created by Intuit for importing and exporting financial data. Each transaction includes the date, amount, payee, and category. QIF has been around since the 1990s and is still supported by Quicken, QuickBooks Desktop, GnuCash, Moneydance, and dozens of other personal finance tools.
Is this converter really free?+
Yes. You can convert up to 3 pages per month completely free — no account required, no credit card. Most single-month bank statements fit in 1–3 pages. For longer statements or bulk processing, paid plans start at $9/month.
Which banks are supported?+
Any bank worldwide that provides PDF statements — Chase, Barclays, HSBC, Deutsche Bank, BNP Paribas, ING, Santander, HDFC Bank, and thousands more worldwide. Scanned paper statements and photographed statements work too.
Can I import the QIF into QuickBooks Online?+
No — QuickBooks Online dropped QIF support. For QBO, use our CSV export instead, which QuickBooks Online accepts via Banking → Upload transactions. QuickBooks Desktop still fully supports QIF import.
Will duplicate transactions be created if I import a QIF for a period I already have?+
Most software (Quicken, GnuCash, Moneydance) has built-in duplicate detection during QIF import — it matches by date, amount, and payee. QuickBooks Desktop may create duplicates, so import only the date range you're missing.
Does the QIF include check numbers?+
Yes, when your bank statement includes check numbers, our AI extracts them and populates the N (Number) field in the QIF. This lets Quicken match checks to your check register automatically.
Can I convert multiple months into one QIF file?+
Upload each statement separately — each generates its own QIF file. Most accounting software handles importing multiple QIF files in sequence without issues. On paid plans, you can process many statements quickly.
How accurate is the extraction from scanned statements?+
For clear scans at 200+ DPI, accuracy is typically 98%+. For digital PDFs downloaded directly from your bank, accuracy is 99%+. Our AI flags any transaction it's uncertain about rather than guessing.
Is my bank statement data kept private?+
Your PDF is processed in memory and immediately discarded — never stored on disk, never shared. Only the structured transaction data is saved temporarily to generate your download.

Convert your bank statement to QIF — free

No account. No credit card. Up to 3 pages free every month.

Drop your bank statements hereUpload your bank statements
or click to browsePDF, JPG or PNG · multiple files supported
Free·No signup·PDF deleted after analysis
... statements analyzed
|See a live example →
Related tools & guides
Bank Statement to CSV →Bank Statement Converter →Convert to Excel →Extraction Software →AI Analysis →