QuickBooks Import Guide: All File Formats Explained
Everything you need to know about importing CSV, IIF, QBO, OFX, QFX, and QIF files into QuickBooks Online and Desktop — step by step.
Overview of Import File Formats
QuickBooks supports several file formats for transaction import. Each format has different capabilities, compatibility, and ideal use cases. Here is a quick comparison.
| Format | Full Name | QBO | QBD | Double-Entry | Bank Feed | Best For |
|---|---|---|---|---|---|---|
| CSV | Comma-Separated Values | ✓ | ✓ | ✗ | ✗ | Universal compatibility, spreadsheet editing |
| IIF | Intuit Interchange Format | ✗ | ✓ | ✓ | ✗ | Full journal entries, Desktop batch import |
| QBO | QuickBooks Web Connect | ✓ | ✓ | ✗ | ✓ | Bank feed upload, fastest QBO import |
| OFX | Open Financial Exchange | ✓ | ✓ | ✗ | ✓ | Bank/credit card statement imports |
| QFX | Quicken Financial Exchange | ✗ | ✓ | ✗ | ✓ | Quicken exports, Desktop Web Connect |
| QIF | Quicken Interchange Format | ✗ | ✗ | ✗ | ✗ | Legacy Quicken data (requires conversion) |
QBO = QuickBooks Online | QBD = QuickBooks Desktop | Bank Feed = imports via Web Connect bank feed
When to Use Each Format
Choosing the right format depends on your QuickBooks version, what data you need to import, and how automated you want the process to be.
Use CSV when...
- -You need to review or edit transactions in Excel before import
- -You use QuickBooks Online and want manual control over categorization
- -Your source data is a spreadsheet or generic bank export
Use IIF when...
- -You use QuickBooks Desktop (Pro, Premier, or Enterprise)
- -You need full double-entry journal entries with account mapping
- -You want to batch-import transactions with classes and memos
Use QBO when...
- -You want the fastest possible import into QuickBooks Online
- -Your data represents bank or credit card transactions
- -You want transactions to appear in the bank feed for review
Use OFX/QFX when...
- -Your bank provides OFX/QFX downloads directly
- -You use QuickBooks Desktop and want Web Connect import
- -You need a standardized format that works across accounting software
Note on QIF: Quicken Interchange Format is a legacy format that modern QuickBooks versions no longer support natively. If you have QIF files, convert them to CSV or QBO first using PrimeConnect's QIF to CSV or QIF to QBO converters.
QuickBooks Online Import Steps
QuickBooks Online supports two import methods: CSV upload via the Banking tab and QBO/OFX Web Connect upload. Here is the step-by-step process for each.
Method A: CSV Upload (Banking Tab)
- 1
Navigate to Banking
Go to Banking (or Transactions > Bank Transactions) in the left sidebar. Click the "Upload transactions" button or select "File upload" from the dropdown.
- 2
Select your bank account
Choose which QuickBooks bank or credit card account should receive the imported transactions. If the account doesn't exist yet, create it first under Chart of Accounts.
- 3
Upload your CSV file
Click "Browse" and select your CSV file. QuickBooks accepts files up to 350KB. The file must have headers in the first row.
- 4
Map your columns
QuickBooks will display a column mapping screen. Map your Date, Description, and Amount columns. If your file has separate Debit/Credit columns, use the two-column mapping option.
- 5
Select the date range
QuickBooks shows a preview of detected transactions. Confirm the date range and review a few rows for accuracy. Deselect any rows you do not want to import.
- 6
Import and categorize
Click "Import" to load transactions into the bank feed. They appear in the "For Review" tab. Categorize each transaction (manually or with bank rules) then click "Accept" to post them.
Method B: QBO/OFX Web Connect Upload
- 1
Download or convert your QBO file
Either download the QBO file from your bank, or use a PrimeConnect converter (e.g., CSV-to-QBO) to create one from your transaction data.
- 2
Double-click the QBO file
On most systems, double-clicking a .qbo file will launch QuickBooks Online in your browser and trigger the Web Connect import dialog.
- 3
Alternative: Upload via Banking tab
Go to Banking > Upload transactions and select your .qbo or .ofx file. QuickBooks auto-detects the format.
- 4
Map to a bank account
QuickBooks prompts you to select or create a bank account. If the QBO file contains a bank ID (INTU.BID), QuickBooks may auto-match it.
- 5
Review and accept
Transactions appear in the "For Review" tab. QuickBooks applies bank rules automatically if configured. Accept each transaction to post it to the ledger.
QuickBooks Desktop Import Steps
QuickBooks Desktop supports more import formats than Online, including the powerful IIF format for full double-entry transactions.
Method A: IIF Import (File > Utilities)
- 1
Open QuickBooks Desktop
Launch QuickBooks Desktop (Pro, Premier, or Enterprise) and open your company file. Make sure you are in single-user mode — IIF import is not available in multi-user mode.
- 2
Navigate to Import
Go to File > Utilities > Import > IIF Files. QuickBooks opens a file browser dialog.
- 3
Select your IIF file
Browse to and select the .iif file. You can only import one IIF file at a time. For batch imports, repeat this process for each file.
- 4
Confirm the import
QuickBooks displays a confirmation dialog showing how many transactions were imported. If any rows fail, it shows an error count — check the QBWin.log file for details.
- 5
Verify in registers
Open the affected account registers (bank, expense, etc.) to verify the imported transactions. Check dates, amounts, and account assignments.
Method B: Web Connect (QBO/OFX/QFX)
- 1
Navigate to Web Connect
Go to File > Utilities > Import > Web Connect Files. Or simply double-click a .qbo/.ofx/.qfx file with QuickBooks Desktop installed.
- 2
Select the file
Browse to your QBO, OFX, or QFX file. QuickBooks detects the format automatically based on the file header.
- 3
Map to an account
QuickBooks asks which bank account should receive the transactions. Select an existing account or create a new one.
- 4
Review in bank feeds
Transactions appear in the Bank Feeds window. Match, categorize, and accept each transaction. QuickBooks Desktop's matching algorithm is more aggressive than Online's.
QuickBooks Self-Employed Limitations
QuickBooks Self-Employed (QBSE) is a stripped-down product designed for freelancers and sole proprietors. It has significant limitations compared to QuickBooks Online.
No File Import
QBSE does not support CSV, IIF, QBO, OFX, or any file-based import. The only way to add transactions is via direct bank connection or manual entry.
No Bank Feed Upload
Unlike QuickBooks Online, there is no "Upload transactions" option in QBSE. You cannot drag-and-drop files or use Web Connect.
No Chart of Accounts
QBSE uses simplified tax categories instead of a full chart of accounts. You cannot create custom accounts or track inventory.
No Journal Entries
QBSE does not support journal entries, manual adjustments, or opening balances. All transactions must flow through the bank connection.
No Multi-Currency
QBSE only supports a single currency. International sellers must upgrade to QuickBooks Online Essentials or Plus.
Upgrade Path
If you need file import capability, upgrade to QuickBooks Online Simple Start ($30/mo) or higher. You can migrate your QBSE data during the upgrade.
Bank Feed vs File Import
QuickBooks offers two ways to get transactions into your books: automatic bank feeds (direct connection) and manual file import. Each has distinct advantages.
Direct Bank Feed
Advantages
- +Fully automatic — transactions sync daily
- +No file handling — zero manual steps
- +Built-in duplicate prevention
Disadvantages
- -Not all banks/platforms are supported
- -Connections can break (requires re-authentication)
- -Limited to 90 days of historical data for most banks
- -No control over transaction formatting
Manual File Import
Advantages
- +Works with any platform (convert to CSV/QBO/IIF)
- +Full control over data formatting and mapping
- +Can import years of historical data at once
- +No OAuth or bank credentials required
Disadvantages
- -Manual process — must export, convert, and import
- -Risk of duplicates if date ranges overlap
- -Requires format knowledge (or a converter tool)
Recommendation: Use direct bank feeds for your primary bank and credit card accounts. Use file import for ecommerce platforms (Stripe, PayPal, Amazon, Shopify, etc.) that do not offer direct QuickBooks bank feed integration. PrimeConnect's converter tools make the file import path nearly as fast as a direct connection.
Common Import Errors and Fixes
These are the most frequently encountered errors when importing files into QuickBooks, along with their root causes and step-by-step solutions.
Date format not recognized
Amount column not found
File exceeds maximum size
Duplicate transactions detected
IIF import failed — invalid header
Bank not recognized (QBO/OFX)
Encoding error — special characters
Transaction type not supported
Having trouble? Use PrimeConnect's free Import Troubleshooter to automatically diagnose and fix common import errors.
Handling Duplicates
Duplicate transactions are the number one data quality issue when importing files into QuickBooks. Here are strategies to detect, prevent, and resolve them.
Prevention Strategies
- 1Track imported date ranges: Maintain a log of which date ranges you have already imported for each account. Never overlap.
- 2Disconnect bank feeds first: If importing historical data, temporarily disconnect the automatic bank feed to prevent double-entry.
- 3Use the Duplicate Detector: Run your file through PrimeConnect's Duplicate Detector before importing to catch internal duplicates within the file itself.
- 4Import into a test company first: QuickBooks Desktop lets you create a test company file. Import there first, verify the data, then import into your production file.
Detection Methods
- 1Exact match: Same date, same amount, same description. These are almost certainly duplicates.
- 2Near match: Same amount with dates within 1-2 days (common when bank processing dates differ from transaction dates).
- 3Fuzzy match: Similar amounts with similar descriptions but different dates. Useful for catching recurring transaction duplicates.
After-the-Fact Resolution
If duplicates have already been imported into QuickBooks:
- -Run a Transaction Detail report filtered by date range and sort by amount to spot identical entries.
- -In QuickBooks Online, use the "Exclude" option in the bank feed to remove duplicates before accepting.
- -In QuickBooks Desktop, manually delete duplicate transactions from the register. Back up your file first.
- -For large-scale cleanup, export all transactions, deduplicate in Excel, and re-import.
Detailed Format Comparison
A comprehensive feature matrix covering every aspect of each import format to help you make the optimal choice.
| Feature | CSV | IIF | QBO | OFX | QFX | QIF |
|---|---|---|---|---|---|---|
| QuickBooks Online | ✓ | ✗ | ✓ | ✓ | ✗ | ✗ |
| QuickBooks Desktop | ✓ | ✓ | ✓ | ✓ | ✓ | ✗ |
| Double-Entry Support | ✗ | ✓ | ✗ | ✗ | ✗ | ✗ |
| Bank Feed Integration | ✗ | ✗ | ✓ | ✓ | ✓ | ✗ |
| Account Mapping | ✗ | ✓ | ✗ | ✗ | ✗ | ✗ |
| Class/Category Tags | ✗ | ✓ | ✗ | ✗ | ✗ | ✗ |
| Memo/Description | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Check Numbers | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Human-Readable | ✓ | ✗ | ✗ | ✗ | ✗ | ✓ |
| Editable in Excel | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Max Transactions | ~2K | 10K+ | ~5K | ~5K | ~5K | N/A |
| Error Feedback | Minimal | Log file | None | None | None | N/A |
PrimeConnect Converter Tools
Free browser-based tools to convert between all QuickBooks-compatible formats. Your data never leaves your device.
Format Converters
CSV to IIF
Convert CSV files to QuickBooks Desktop IIF format
CSV to QBO
Convert CSV files to QuickBooks Web Connect format
CSV to OFX
Convert CSV to Open Financial Exchange format
IIF to CSV
Convert IIF files to universal CSV format
IIF to QBO
Convert Desktop IIF to Web Connect QBO
QBO to CSV
Extract QBO transactions to spreadsheet CSV
QBO to IIF
Convert QBO files to Desktop IIF format
OFX to CSV
Convert OFX bank files to CSV format
OFX to QBO
Convert OFX to QuickBooks Web Connect
OFX to IIF
Convert OFX files to Desktop IIF format
QIF to CSV
Convert legacy QIF files to CSV
QIF to QBO
Convert QIF to QuickBooks Web Connect
QFX to QBO
Convert Quicken QFX to QuickBooks QBO
XLSX to QBO
Convert Excel spreadsheets to QBO format
PDF to QBO
Extract PDF bank statements to QBO
Utility Tools
IIF Viewer
Inspect and validate IIF files visually
QBO Viewer
Inspect QBO file contents before import
OFX Viewer
View OFX transaction data in a readable table
Duplicate Detector
Find and remove duplicate transactions
File Format Detector
Auto-detect file type and suggest tools
Import Troubleshooter
Diagnose and fix import errors
Frequently Asked Questions
What file formats can QuickBooks import?
What is the difference between QBO and OFX files?
Can I import IIF files into QuickBooks Online?
How do I fix "Date format not recognized" errors?
Why are my imported transactions showing as duplicates?
What is the maximum file size QuickBooks can import?
Can I import transactions with categories already assigned?
Is QuickBooks Self-Employed different from QuickBooks Online?
Ready to Import Your Data?
Convert any file format to QuickBooks-ready CSV, IIF, or QBO with PrimeConnect's free browser-based tools. No upload fees, no installation required.
Browse All Free Tools