QIF is the legacy interchange format that older Quicken versions and many other finance programs read, and a PDF statement is not something any of them import. BankXLSX reads the statement and writes every transaction to a QIF file with a date, a signed amount, a payee and a memo. The same upload also downloads as QFX for current Quicken, or as CSV and Excel. No retyping, no jammed columns.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
To convert a bank statement to QIF, upload the PDF to BankXLSX, review the date, description and amount rows it reads, and download the QIF file on the Plus plan. The file has a Bank header for checking and savings or a CCard header for credit cards, with one dated, signed record per transaction. For current Quicken a QFX download from the same upload is usually the better choice because Quicken can skip duplicates. CSV and Excel are available on every plan.
Quicken imports transactions through QFX (Web Connect) and QIF, plus a transaction CSV on Quicken for Mac. A PDF is none of those, and bank feeds do not reach everything, so the data has to be reshaped first. Here is where it usually breaks.
Quicken imports QFX and QIF, and a CSV on the Mac version. A PDF bank statement has nowhere to go until you convert it into structured rows first.
Direct Connect and Web Connect cover recent activity for supported banks, but fail for closed accounts, old periods, and many smaller institutions, so you fall back to the PDF.
QIF uses tagged lines (D for date, T for amount, P for payee, M for memo) under a !Type header. One malformed record and the import skips transactions or posts them wrong.
Pasting a PDF table into a sheet jams date, payee, and amount into one cell, and both QIF and Quicken CSV need them cleanly separated before import.
Amounts copied from a PDF carry dollar signs and commas as text, but the import needs plain signed numbers (money out negative, money in positive) or the register will not balance.
Typing hundreds of lines into a template by hand is slow, and one mistyped amount throws off the Quicken reconciliation for hours.
Upload the PDF and the converter reads the transaction table directly, then writes clean, structured rows you import into Quicken or turn into a QIF file.
Every statement lands as date, description, debit, credit, and running balance, the exact fields a QIF record or a Quicken CSV needs.
Download QIF or QFX on the Plus plan and CSV or XLSX on every plan, all from the same upload. Use the spreadsheet to check the rows before you import the QIF.
The Mint-layout CSV that Quicken for Mac reads can carry a category column, so your coding lands with the transactions instead of starting from a blank register.
OCR pulls transactions from scanned PDFs and phone photos in JPG, PNG, HEIC, and TIFF, not just digital PDFs.
Upload a full statement or a year of them and the converter stitches every page into one continuous transaction list.
Templates tuned to how Chase, Bank of America, Wells Fargo, and dozens of other US banks print their statements.
No software to install and no credit card to start.
Drag your PDF, scanned statement, or photo into the box above. Password-protected PDFs work too.
Tip: Multi-page and multi-month files are fine.
The AI reads every transaction into clean date, description, and amount columns you can export.
Tip: Most statements finish in under a minute.
Download the QIF file and import it in Quicken for Windows under File, File Import, QIF file. If your version refuses QIF for a bank account, import the QFX download as a Web Connect file instead.
Tip: Create the account in Quicken first so lines post correctly.
Long-time Quicken users, rental owners, and bookkeepers all hit the same wall: the account they need is a PDF, not a feed.
Tracking a property account in Quicken when the bank feed drops or the account is at a small institution that never connected.
Bringing years of history into Quicken from statements the online feed will not backfill.
Catching up a client on Quicken from a stack of monthly PDFs instead of a live connection.
Keeping a business account in Quicken clean for tax time without retyping every transaction.
BankXLSX writes a native .qif file on the Plus plan. Each transaction becomes a record with a D line for the date, a T line for the signed amount, a P line for the payee and an M line for the memo, closed by a caret, under a Bank or CCard type header. The hard part was never the QIF syntax. It is getting accurate dates, payees and amounts out of a PDF, including scans and multi page statements, and that is what the converter does before it writes the file. Starting from a bank CSV instead of a PDF works the same way, as the CSV to QFX converter page explains.
QIF (Quicken Interchange Format) is a plain-text format that Intuit created for moving transactions between financial programs. Each transaction is a set of tagged lines under a type header: D for the date, T for the amount, P for the payee, M for a memo, and a caret to end the record. It is old and loosely specified, which is why imports fail on small formatting differences, and why Quicken itself has steered users toward QFX and CSV. It still shows up because a lot of legacy software and some banks only speak QIF.
The right target depends on your Quicken version. The table lays out the trade-offs.
| Format | Best for | Watch out for |
|---|---|---|
| CSV | Quicken for Mac (2015+), which imports a Mint-layout transaction CSV directly | Quicken for Windows CSV import only updates security prices, not transactions |
| QFX | Quicken for Windows register imports (Web Connect) that skip duplicates | Quicken wants the Intuit-branded QFX flavor; BankXLSX writes it on the Plus plan |
| QIF | Legacy software and Quicken for Windows; can carry categories and tags | Quicken for Windows limits QIF import to cash, asset, and liability accounts, not bank accounts |
The practical read: for current Quicken on Windows or Mac, download the QFX file, because Quicken treats it like a bank download and skips transactions it already has. Reach for QIF when the destination requires it or when you are on an older Quicken version. Keep in mind that a Quicken support article still lists QIF import as unavailable for checking, savings and credit card accounts, while newer Quicken documentation says that limit is gone, so if your copy refuses a QIF into a bank account, use the QFX download. If you are still choosing a tool, our CSV to QIF converter software comparison sets the desktop options and their prices side by side.
Quicken for Mac reads a CSV in the Mint layout, using the transaction date, a payee, and a signed amount with MM/DD/YYYY dates and plain numbers, no dollar signs or commas, money out negative and money in positive. BankXLSX exports in that clean shape, so on a Mac the file is close to import-ready. On Quicken for Windows you import the QIF or QFX download instead, since Windows does not import a transaction CSV. For a step-by-step walkthrough, see how to import bank statements into Quicken, and the Quicken bank statement converter covers the whole workflow. Importing into QuickBooks instead? Use the QuickBooks bank statement converter or the desktop IIF converter.
To be precise: BankXLSX converts the statement and keeps the numbers exact. It gives you CSV and Excel, not a finished .qif or .qfx, and it does not decide which account a line belongs to or how to categorize it. Those are yours. What it removes is the part with no judgment in it, which is turning a stack of PDF pages into accurate rows ready for a Quicken import.
Yes. BankXLSX writes a native .qif file on the Plus plan, alongside QFX for Quicken Web Connect, IIF for QuickBooks Desktop and QBO. Excel and CSV are available on every plan. The QIF file uses a Bank header for checking and savings accounts and a CCard header for credit cards.
Upload the PDF to BankXLSX, which reads every transaction into date, description and amount rows, then download the QIF file on the Plus plan and import it under File, File Import, QIF file in Quicken for Windows. There is no retyping and no second utility, and the converter handles scanned statements and password-protected PDFs as well as digital ones.
Not as a PDF. Quicken imports QFX (Web Connect) and QIF, plus a transaction CSV on the Mac version, but it cannot read a PDF statement. For accounts the bank feed will not reach, such as closed accounts or older periods, you convert the PDF to a clean CSV first, then import that on Mac or turn it into QIF or QFX for Windows.
It depends on your version. Quicken for Mac imports a Mint-layout transaction CSV directly, so use the CSV there. Quicken for Windows will not import a transaction CSV (its CSV import only updates security prices), so on Windows you need QIF or QFX. Keep in mind Quicken for Windows also limits QIF import to cash, asset, and liability accounts rather than bank accounts.
QIF (Quicken Interchange Format) is a plain-text format Intuit created for moving transactions between financial programs. Each transaction is a set of tagged lines under a type header, using D for date, T for amount, P for payee, and M for memo. It is loosely specified, which is why imports fail on small formatting differences, and why newer software prefers QFX and CSV.
Yes. Every converted row carries the running balance printed on the statement, alongside the date, description, and amount. That makes it easy to confirm nothing was dropped in conversion before you import, even though the balance column itself is not part of a QIF or Quicken transaction import.
The full workflow for converting statements for Quicken.
Export OFX for other accounting software.
The CSV Quicken for Mac imports directly.
Importing into QuickBooks instead of Quicken.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
