Convert Bank Statement PDF to IIF for QuickBooks Desktop
Your bank feed stopped working or you only have PDF statements. AI reads the PDF, extracts every transaction, and builds a balanced IIF file QuickBooks Desktop imports directly.
For QuickBooks Desktop Pro, Premier, and Enterprise. The bank feed replacement you didn't know you needed. Free online.
How It Works
Upload Bank Statement PDF
Any bank, any layout — Chase, BofA, Wells Fargo, HSBC, or international. Digital and scanned PDFs both supported via built-in OCR.
AI Extracts Transactions
Date, description, amount, and balance parsed from the PDF layout automatically. No templates, no column mapping, no manual intervention.
Download IIF
Tab-delimited IIF with balanced TRNS/SPL entries, correct transaction types, and unique IDs. Import via File > Utilities > Import > IIF Files.
IIF or QBO — Which Format for QuickBooks Desktop?
QuickBooks Desktop accepts both formats, but they import differently and serve different purposes.
IIF (This Tool)
- Imports as completed transactions
- You control account assignments
- Supports journal entries, custom types
- No bank feed matching step
- Best for historical imports & bulk entry
QBO (Bank Feed Style)
- Imports into bank feed for review
- QuickBooks applies matching rules
- Preserves check numbers & metadata
- Requires accept/match step
- Use PDF to QBO instead
Works With Every Bank Statement
Every bank formats PDFs differently. Our AI reads the visual layout — not a fixed template — so it works with any bank, any country, any statement design.
What is PDF?
Portable Document Format
Bank statements come as PDFs — fixed layouts with no machine-readable structure. QuickBooks Desktop cannot read PDFs at all. The transactions need to be extracted by AI and restructured into a format QuickBooks understands.
What is IIF?
Intuit Interchange Format
QuickBooks Desktop's native tab-delimited import format. Each transaction is a balanced TRNS + SPL + ENDTRNS entry with account assignments, transaction types, and memos. Imports directly via File > Utilities > Import — no bank feed matching required.
Why This Tool
AI Reads Any Bank Layout
Chase, BofA, Wells Fargo, HSBC, HDFC, or any bank worldwide. No templates or per-bank configuration — the AI figures out the table structure automatically.
Scanned PDF & OCR
Built-in OCR handles scanned statements, faxed copies, and photos of printed pages. Replaces the need for separate Tesseract or Adobe OCR processing.
Balanced TRNS/SPL Entries
Every transaction outputs as a balanced debit/credit pair. No "Transaction Amounts Are Out of Balance" errors on import.
Tab-Delimited for QB 2019+
Comma-delimited IIF broke in QuickBooks 2019. Our output is always tab-separated — compatible with QB Desktop 2007 through 2024.
Multi-Page Extraction
A 40-page statement becomes one IIF file. Transactions spanning page breaks are stitched correctly — no gaps, no duplicates.
Bank & Credit Card Statements
Checking accounts, savings, and credit card statements all supported. Credit card PDFs output as CREDIT CARD transaction types automatically.
When to Use This
Bank Feed Discontinued
QB Desktop 2022 lost bank feeds May 2025. QB 2023 loses them May 2026. Download your PDF statement and convert it here — same transactions, manual import.
Historical Statement Import
Importing 6-12 months of old PDF statements for catch-up bookkeeping, year-end reconciliation, or tax preparation in QuickBooks Desktop.
Client PDF Statements
Bookkeepers receiving PDF statements from clients via email. Convert each one to IIF and bulk-import into the client's QuickBooks Desktop company file.
QuickBooks Desktop Bank Feed Sunset Timeline
Intuit is ending bank feed support version by version. When your version loses feeds, PDF-to-IIF becomes your import method.
QB Desktop 2022
Bank feeds ended May 31, 2025. No updates, no payroll, no security patches. IIF import is the only way in.
QB Desktop 2023
Bank feeds end May 31, 2026. Start planning your manual import workflow now.
QB Desktop 2024
Bank feeds active until Sep 30, 2027. The last non-Enterprise Desktop version — no 2025 release planned.
How to Import IIF Into QuickBooks Desktop
Import Steps
- Back up your company file first
- Go to File > Utilities > Import > IIF Files
- Select your downloaded .iif file
- Click OK — transactions import immediately
- Check the bank register to verify entries
Before You Import
- Create all referenced accounts in Chart of Accounts — names must match exactly
- Test with one month first before importing a full year
- IIF has no undo — mistakes require manual deletion or backup restore
- Close all QuickBooks windows during import
PDF-to-IIF Pitfalls to Watch For
QuickBooks says "Account Name does not exist" [11110]
Every account in the IIF must match your Chart of Accounts exactly — spelling, capitalization, parent:child hierarchy. Create the bank account and all offset accounts in QuickBooks before importing.
"Transaction Amounts Are Out of Balance" on import
TRNS and SPL lines must sum to zero. This error appears when the AI misreads an amount (e.g., reads 1,234 as 1234 but the offset is 1,234.00). Review the IIF in a text editor to verify amounts match.
Scanned PDF extracts garbled or missing transactions
Low-resolution scans (under 200 DPI) or heavily compressed PDFs reduce OCR accuracy. Re-scan at 300 DPI or higher. Faded text and handwritten annotations also reduce accuracy.
Transactions from page breaks are duplicated or missing
Some banks repeat the last transaction as a running balance on the next page. Our AI detects these page-break artifacts and deduplicates. If you notice duplicates, verify against your original statement.
IIF imports but amounts appear wrong (debit/credit swapped)
Different banks represent debits and credits differently — some use +/- signs, others use separate columns, some use parentheses. If amounts look inverted, verify the PDF's debit/credit format against the IIF output.
Frequently Asked Questions
Why IIF instead of QBO for QuickBooks Desktop?
QBO imports into bank feeds and requires matching. IIF imports directly as completed transactions with specific account assignments — ideal for journal entries, custom account mapping, and historical bookkeeping where bank feed matching isn't needed.
Can it read scanned or photographed bank statements?
Yes. Built-in OCR handles scanned PDFs, fax copies, and photos of printed statements. Digital-native PDFs process even faster.
My bank feed stopped working after QB Desktop 2022 lost support. Does this replace it?
Yes. Download your bank's PDF statement and convert it here. The IIF file imports the same transactions your bank feed would have — just manually instead of automatically.
Does IIF work with QuickBooks Online?
No. IIF is QuickBooks Desktop only (Pro, Premier, Enterprise). For QuickBooks Online, use our PDF to QBO converter instead.
What transaction types does the IIF contain?
CHECK for payments/expenses, DEPOSIT for income/receipts, CREDIT CARD for card charges. Auto-detected from the PDF data based on debit/credit amounts.
Do I need to create accounts in QuickBooks before importing?
Yes. Every account name referenced in the IIF — the bank account and the offset accounts — must exist in your Chart of Accounts. Names must match exactly.
Can it handle multi-page statements?
Yes. A 30-page annual statement becomes one IIF file with every transaction extracted across all pages — no gaps at page breaks.
DocuClipper charges $39/month and MoneyThumb $25/month. Is this free?
Yes. Free conversions with no signup. Paid plans from $15/month for high-volume users who need more pages per month.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your bank statement is deleted immediately after conversion.
Related Tools
PDF to QBO
Import bank statement PDFs into QuickBooks as QBO files. AI auto-maps dates, debits, and credits. Works with QuickBooks Desktop and Online. Free, no signup.
Convert now →CSV to IIF
Convert CSV financial files to IIF for QuickBooks Desktop. Auto-detects columns and creates properly formatted IIF entries. Free, instant, no signup required.
Convert now →PDF to CSV
Extract transactions from bank statement PDFs to CSV. AI-powered, works with any bank in any language. Accurate date and amount extraction. Free, no signup.
Convert now →PDF to Excel
Turn bank statement PDFs into formatted Excel spreadsheets. Keeps all columns, headers, and transaction details. Any bank, any language. Free, no signup.
Convert now →