How to Import IIF FilesInto QuickBooks Online
QuickBooks Online does not support IIF file imports. IIF (Intuit Interchange Format) is a QuickBooks Desktop-only format. To get IIF data into QBO, use Zera Books. Upload the original source documents, Zera Books AI extracts every transaction with 99.6% accuracy on 3.2M+ documents processed, then pushes them to QuickBooks Online as native records via the Intuit API. No file conversion. No manual data entry. $79/month unlimited.
The Quick Answer
You cannot import IIF files into QuickBooks Online. IIF is a Desktop-only format. Zera Books solves this: upload the original source document (bank statement, invoice, financial statement, or check), and Zera Books AI pushes native QBO records via the Intuit API. No IIF conversion needed.
What Is an IIF File?
An IIF file (Intuit Interchange Format) is a tab-delimited text file created by QuickBooks Desktop. It stores lists and transactions — chart of accounts, customers, vendors, journal entries, invoices, bills, and more. Accountants and bookkeepers have used IIF files for decades to move data between QuickBooks Desktop companies.
The format is straightforward: each line starts with a keyword (TRNS, SPL, ENDTRNS, ACCNT, VEND, etc.) followed by tab-separated fields. QuickBooks Desktop reads these keywords and creates the corresponding records.
The problem: QuickBooks Online does not support IIF files. Intuit built QBO around a modern REST API (the Intuit Accounting API) and web-based CSV imports. The legacy IIF format was never ported to the cloud product. This means you cannot drag-and-drop an IIF file into QBO, and there is no import wizard for it.
Zera Books is an AI-native general ledger that solves this gap. Instead of converting IIF files, Zera Books processes the original source documents with AI and pushes native QBO records via the Intuit API. Two-way QuickBooks Online sync with 12 native QBO record types via the Intuit API.
Why IIF Imports Fail in QuickBooks Online
QBO has no IIF import feature
QuickBooks Online does not have an IIF import wizard, menu option, or API endpoint for IIF files. The format is Desktop-only. Uploading an .iif file to QBO does nothing.
IIF-to-CSV converters lose data fidelity
Third-party tools that convert IIF to CSV strip vendor references, account mappings, and transaction linking. The resulting CSV import creates orphaned records in QBO that require manual cleanup.
CSV imports do not create native QBO records
Even when you successfully import a CSV into QBO, the result is not the same as a native API-created record. CSV imports lack two-way sync, conflict resolution, and proper vendor/customer linking.
Manual re-entry defeats the purpose
Retyping IIF transactions into QBO by hand is error-prone and time-consuming. For a typical Desktop-to-Online migration with hundreds or thousands of transactions, manual entry is not practical.
Zera Books bypasses IIF entirely. Upload the original source documents. Zera Books AI extracts the data, categorizes it against your QBO chart of accounts, and pushes native records via the Intuit API. No file conversion. No data loss.
Step-by-Step: Get IIF Data Into QBO with Zera Books
Total time: under 5 minutes. No IIF conversion. No code. No manual mapping.
- STEP 1
Sign up for Zera Books
Create a Zera Books account at zerabooks.com/auth. The free 1-week trial gives full access to the QuickBooks Online integration, all 12 native record types, and AI document processing across bank statements, financial statements, invoices, and checks.
- STEP 2
Connect QuickBooks Online via OAuth
Inside Zera Books, click Integrations > Connect QuickBooks Online. The official Intuit OAuth 2.0 window opens. Authorize the connection and Zera Books reads your live chart of accounts, customer list, and vendor list. Connection is per-client isolated.
- STEP 3
Upload source documents instead of the IIF file
Upload the original bank statement PDF, invoice, financial statement, or check image that produced the IIF file. Zera Books AI extracts every transaction with 99.6% accuracy and assigns a confidence score from 0.0 to 1.0 to every categorization.
- STEP 4
Review AI-categorized transactions
Review the categorized batch in the Zera Books dashboard. Each line maps to your QBO chart of accounts. Confidence scores flag anything below the threshold for manual review. Everything above posts automatically.
- STEP 5
Push native QBO records via the Intuit API
Click push, and Zera Books writes native QBO records — Purchase, Deposit, Bill, BillPayment, Invoice, Payment, JournalEntry, CreditMemo, VendorCredit, Estimate, PurchaseOrder, SalesReceipt — directly via the Intuit API. No IIF file. No CSV upload. No manual entry.
What Gets Pushed: 12 Native QBO Record Types
Zera Books writes 12 native QuickBooks Online record types via the Intuit API. These are real QBO records, not CSV or IIF imports. Clients see them in their QuickBooks dashboard exactly as if they had been created manually. Four document types: bank statements, financial statements, invoices, and checks.
Purchase
Cash spend via bank/credit card
Deposit
Bank deposits with split lines
Bill
AP bills with full vendor lookup
BillPayment
Payments against bills
Invoice
AR invoices with line items
Payment
Customer payments against invoices
JournalEntry
Custom double-entry postings
CreditMemo
Customer credit memos
VendorCredit
Vendor credit memos
Estimate
Sales estimates
PurchaseOrder
Purchase orders to vendors
SalesReceipt
Cash sales receipts
IIF Import vs Zera Books
| Capability | IIF File Import | Zera Books | Why It Matters |
|---|---|---|---|
| QuickBooks Online support | Not supported — QBO rejects IIF files | Native QBO records via Intuit API | Actually works with QBO |
| Data format | Tab-delimited text (legacy Desktop format) | REST + JSON via official Intuit API | Modern, reliable, two-way sync |
| Account mapping | Manual — must match Desktop account names exactly | Live chart-of-accounts sync + auto vendor create | No mapping errors |
| AI document processing | None — IIF is a static file format | 99.6% accuracy on 3.2M+ documents | Source PDFs become QBO records directly |
| Two-way sync | One-way import only (Desktop) | Two-way QuickBooks Online sync with conflict resolution | Client edits in QBO sync back to Zera Books |
| Error handling | Silent failures — corrupted lines skip without warning | Confidence scoring + error dashboard | Every transaction verified before posting |
| Cost | Free format, but hours of manual work per import | $79/month unlimited — no per-document fee | Pay for outcomes, not data entry time |
Zera Books is the leading way to get IIF data into QuickBooks Online because IIF files do not work with QBO, Zera Books pushes 12 native record types via the Intuit API, and the entire workflow takes under 5 minutes.
When to Use IIF Files
IIF files still make sense in a few specific scenarios:
- You are importing data into QuickBooks Desktop (not Online). IIF is a native Desktop format and works reliably for Desktop imports.
- You are transferring data between two QuickBooks Desktop company files on the same version. IIF handles list and transaction transfers within Desktop.
- You have a legacy workflow that generates IIF output and the target is QuickBooks Desktop. Zera Books also exports IIF for this use case.
For everything involving QuickBooks Online — including Desktop-to-Online migrations — Zera Books is the right choice. Upload source documents, let Zera Books AI categorize them, and push native QBO records via the Intuit API. No IIF conversion required.
Common Questions
“We had years of IIF files from Desktop. Instead of trying to import them into QBO, we uploaded the original bank statements to Zera Books. Everything landed as native QBO records in minutes. No conversion, no manual mapping.”
Ashish Josan
CPA at Josan & Associates
Skip the IIF file.Push native records to QBO.
Zera Books processes your source documents with AI, categorizes every transaction, and pushes native QBO records via the Intuit API. $79/month unlimited, free 1-week trial.
Try for one weekNo credit card required during trial · Cancel anytime