Frequently asked questions
Everything you need to know about PDF to IIF conversion.
What is an IIF file?
+
IIF (Intuit Interchange Format) is a file format used by QuickBooks Desktop to import transactions in bulk. Instead of entering transactions one by one manually, you can import hundreds at once using an IIF file. It's a massive time saver for anyone reconciling bank or credit card statements.
How do I export my chart of accounts from QuickBooks Desktop?
+
You can export directly from the Chart of Accounts to get your full accounts list.
1. Press Ctrl + A to open your Chart of Accounts.
2. Click the Reports button at the bottom and select Account Listing.
3. A report will open. Click the Excel button at the top and select Create New Worksheet.
4. In the export window, click Export.
5. Copy and paste the account numbers and names into Step 2.
Optional: to remove balances before exporting, click Customize Report → Columns and uncheck "Balance." But remember we don't store your data and we aren't looking at your balances anyway.
Why does my chart of accounts need to match exactly?
+
This is critical. When QuickBooks imports an IIF file it matches each transaction to an account by name — character for character. If the account name in your IIF doesn't match exactly what's in your QuickBooks chart of accounts, QuickBooks will silently create a brand new account instead of posting to the right one. You won't get an error, the transactions will just end up somewhere wrong.
This is especially tricky because QuickBooks displays accounts differently depending on how they were set up. If the account number is in the Number field, QuickBooks displays it as 1040 · Credit Card Clearing Account using a middle dot. If the number was typed directly into the Name field, it shows as 1040 - Credit Card Clearing Account with a hyphen. Those are two different strings as far as IIF matching is concerned.
The safest approach: export your Chart of Accounts directly from QuickBooks as a CSV or Excel file and upload it in Step 3. This guarantees the account names in your IIF are byte-for-byte identical to what QuickBooks expects. Screenshots work in a pinch but OCR can misread characters like · vs -, which will cause mismatches.
Why is QuickBooks creating new accounts when I import my IIF?
+
There are two common causes. First, the IIF import engine in QuickBooks Desktop enforces a strict 31-character maximum for account names. If your account name is longer than 31 characters, QuickBooks silently truncates it during import and treats it as a new account. For example, "1040 · Credit Card Clearing Account" is 36 characters and will be truncated to "1040 · Credit Card Clearing Acc" — which doesn't match your existing account, so a new one gets created.
The fix is to shorten any account names over 31 characters directly in QuickBooks before importing. Go to Lists → Chart of Accounts, double-click the account, and shorten the name. pdftoiif.com also automatically truncates account names to 31 characters when generating your IIF to match what QuickBooks expects.
The second cause is a character mismatch, most commonly the middle dot separator (·) or a misspelling. See the FAQ above about chart of accounts accuracy for more detail.
Which banks and card issuers are supported?
+
We support PDF statements from all major US banks and card issuers including Chase, American Express, Bank of America, Capital One, Wells Fargo, Citibank, and most others. If your statement is a readable PDF (not a scanned image), it will work.
Can I process multiple statements at once?
+
Up to 6 statements at once — two fiscal quarters per batch. Perfect for catching up on reconciliation or doing quarterly or even yearly imports in one shot. If you are an accounting procrastinator you are going to love us.
Is my financial data stored anywhere?
+
No. Your statements are processed and discarded instantly. We never store your financial data, we're not interested. Really. Everything happens in your browser session and is gone the moment you close the tab so this tool is 100% secure and private.
How do I import the IIF file into QuickBooks Desktop?
+
In QuickBooks Desktop go to File → Utilities → Import → IIF Files, then select your downloaded file. QuickBooks will import all transactions instantly. We recommend reviewing the imported transactions in your register afterwards to confirm everything looks correct.
Does this work with QuickBooks Online?
+
No — IIF import is a QuickBooks Desktop feature only. QuickBooks Online uses a different import format. If you need a CSV export, use our CSV download option which can be used with a variety of import tools.
What if I make a mistake after I import the IIF?
+
Importing IIF files or data in QuickBooks Desktop is an irreversible process. Sucks right? But with that said you can manually delete the transactions, reclassify them or change them as needed. It's just time consuming. So make sure you have your mapping right before you import.