CSV & .QBO to QuickBooks Desktop .IIF Converter

Bypass the 3-year Web Connect sunset on older QuickBooks Desktop editions (2018–2023). Convert .QBO, CSV, Excel, or QIF statements into balanced TRNS/SPL .IIF files locally.

1. SOURCE FILE

bank_webconnect_oct2026.qbo

Sample

11 ready / 11 source rows · Parsed locally in RAM (0 uploads)

Drop .qbo, .csv, .xlsx, .qfx, .ofx, .qif or test:

2. COLUMN MAPPING

Auto-matched

Posted Date

Payee / Memo

Amount Mode

Amount Col

Check # Col

Flip +/- signs (Credit card fix)

3. QUICKBOOKS REGISTER (.IIF)

QuickBooks Account Name (exact match)

Offset Split Account (double-entry SPL)

4 format checks passed

✓IIF account and output settings checked
✓11 transactions ready from 11 source rows
✓Transaction dates checked
✓Transaction IDs preserved or generated from transaction details

Transaction preview

11 ready from 11 source rows · Only export is limited (first 10 rows free)

QuickBooks Desktop .IIF Note: .IIF imports post directly to Business Checking balanced against Ask My Accountant. Always back up your .QBW company file and test the free 10-row .IIF first.

Transactions

Money out (debits)

-$4,168.74

Money in (credits)

+$20,550.00

Statement period

Oct 2 – 31, 2026

#	Date	Payee / description	Amount (USD)
1	2026-10-02	STRIPE TRANSFER PAYOUT #8841 - INV 2026-10A	+$4,280.00
2	2026-10-03	AMAZON WEB SERVICES INC & CLOUDFRONT EGRESS	-$312.45
3	2026-10-10	CHECK 1042 - PACIFIC OFFICE LEASE OCTCheck #1042	-$2,450.00
4	2026-10-18	STRIPE TRANSFER PAYOUT #8899 - INV 2026-10B	+$6,120.00
5	2026-10-20	HOME DEPOT #4012 COMMERCIAL SUPPLY	-$189.90
•••	Rows 6–10	(5 more transactions included in free 10-row export — expand rows)
11	2026-10-31	FEDEX FREIGHT & PACKAGING SERVICESPro export	-$84.60

All 11 rows available to preview

First, test 10 transactions in QuickBooks.

Download a real .IIF file with the first 10 transactions from this statement to verify clean import in your QuickBooks version before unlocking all 11 rows.

Activation checks your key online; statement data stays local.

Test the free file in your QuickBooks version before subscribing.

Safe QuickBooks Desktop .IIF import checklist (Read before importing)

1. Back up your QuickBooks Company File (.QBW) first

Unlike Web Connect (.QBO), .IIF imports write directly into your QuickBooks Desktop register without a Bank Feeds staging screen. Always run File → Back Up Company → Create Local Backup first.

2. Match your exact QuickBooks Bank or Credit Card Account Name

Enter the exact spelling of your register from your Chart of Accounts (e.g., "Chase Checking") in step 3 on the left. Keep the offset account as "Ask My Accountant" (or Suspense) so every transaction is 100% double-entry balanced and easy to reclassify.

3. Import in Single-User Mode: File → Utilities → Import → IIF Files

Test with the free 10-row .IIF export first! In QuickBooks Desktop 2019+, click "Import it for me. I'll fix it later" if prompted, then verify the 10 entries in your register before unlocking the full file.

How BankFilePro prevents out-of-balance .IIF errors in QuickBooks Desktop

Import Error / Symptom	Technical Root Cause	How BankFilePro Resolves It Locally
"Transaction is not in balance" error during .IIF import	Every IIF TRNS row requires at least one SPL (split) row whose amount is the exact mathematical opposite so TRNS + SPL = 0.00.	Generates strict paired TRNS + SPL + ENDTRNS blocks verified to sum to 0.00 to the cent on every single row.
Unintended new accounts created in Chart of Accounts	A typo in the IIF ACCNT column causes QuickBooks Desktop to create a new bank account instead of posting to your existing one.	Dedicated QuickBooks Account Name & Offset Account fields plus a free 10-row test file let you confirm exact Chart of Accounts matching first.
Credit card charges vs Checking checks use different IIF TRNSTYPE keywords	Posting CHECK/DEPOSIT into a Credit Card register corrupts QuickBooks register types.	Automatically emits CHECK / DEPOSIT for Bank accounts and CREDIT CARD / CCARD REFUND for Credit Card accounts.

Frequently Asked Questions

Why does QuickBooks Desktop block my .QBO file after 3 years?

Intuit enforces a 3-year service sunset policy on QuickBooks Desktop editions, disabling online services including Web Connect (.QBO) Bank Feeds imports. However, File → Utilities → Import → IIF Files remains a built-in offline Desktop feature that continues working indefinitely.

Can I convert a bank CSV or Excel statement directly to .IIF on this page?

Yes! Even though this tab is titled .QBO → IIF, you can drop a bank CSV, Excel (.xlsx), .QBO, .QFX, .OFX, or .QIF file directly onto this converter and output a balanced .IIF file.

Why does the split (SPL) row default to "Ask My Accountant"?

Because .IIF posts directly to the register without Bank Feeds, routing the offset split to "Ask My Accountant" keeps your bank balance 100% accurate immediately while gathering all uncategorized items in one clean account for batch reclassification.