QuickBooks Desktop Import — IIF Files

If your church is migrating from QuickBooks Desktop, Wired Church can import your chart of accounts, transactions, and vendor records directly from IIF (Intuit Interchange Format) files. This guide walks through the full export-and-import process, from generating the IIF file in QuickBooks to reviewing and confirming the import inside Wired Church.

---

What Is an IIF File?

IIF is a tab-delimited text format created by Intuit for moving data in and out of QuickBooks Desktop. A single IIF file can contain multiple data types:

• Chart of accounts — Every account in your QuickBooks file, including type, description, and account number.
• Transactions — General journal entries, checks, deposits, invoices, and other transaction records.
• Vendor records — Names, addresses, and terms for vendors your church pays.

IIF files use the .iif extension and can be opened in any text editor, though the tab-delimited format is not particularly human-readable. Wired Church parses the format automatically — you do not need to modify the file before uploading.

---

Step 1: Export IIF from QuickBooks Desktop

The export process varies slightly depending on which data you need to bring into Wired Church. Below are the three most common exports.

Exporting Your Chart of Accounts

1. Open QuickBooks Desktop and navigate to File > Utilities > Export > Lists to IIF Files.
2. In the export dialog, check Chart of Accounts.
3. Click OK and choose a save location. QuickBooks will create a file with a name like ChartOfAccounts.iif.
4. Save the file somewhere you can easily find it — your Desktop or a dedicated migration folder.

Exporting Transactions

1. Navigate to File > Utilities > Export > Lists to IIF Files.
2. If a transaction export option is not available under Lists, go to Reports > Custom Transaction Detail Report.
3. Set the date range to cover the period you want to import (e.g., the full current fiscal year or the last three years).
4. Click Export and select IIF File from the format options.
5. Save the file.

Exporting Vendor Records

1. Navigate to File > Utilities > Export > Lists to IIF Files.
2. Check Vendor List.
3. Click OK and save the file.
4. Vendor records import as payee names in Wired Church, which can be used for check writing, expense tracking, and 1099 reporting.

---

Step 2: Upload the IIF File to Wired Church

1. Open the admin sidebar and click Finance.
2. Click Imports in the sub-navigation.
3. Select the QuickBooks IIF import type from the list of available import options.

4. The upload dialog appears. Drag and drop your .iif file onto the upload area, or click Browse to select the file from your computer.
5. Wired Church validates the file format immediately. If the file is a valid IIF file, you will see a green confirmation with a summary of what the file contains (e.g., "Found: 47 accounts, 312 transactions, 15 vendors").
6. If validation fails, see the troubleshooting section at the bottom of this article.

---

Step 3: The Mapping Wizard

After uploading, Wired Church launches the mapping wizard. This is where you connect your QuickBooks accounts to the corresponding accounts in your Wired Church chart of accounts.

How the Mapping Interface Works

The mapping wizard displays a two-column layout:

• Left column — Source accounts from the IIF file, showing the QuickBooks account name, type, and number.
• Right column — A dropdown selector for each source account, listing your Wired Church chart of accounts.

Auto-Match Suggestions

Wired Church attempts to auto-match accounts based on name similarity. When a match confidence is high (names are identical or nearly identical), the mapping is pre-filled and highlighted in green. When no confident match is found, the dropdown shows "— Select Account —" and the row is highlighted in amber.

1. Review each auto-matched row. Confirm that the suggested mapping is correct or change it using the dropdown.
2. For unmatched rows, click the dropdown and select the appropriate Wired Church account.
3. If the correct target account does not exist yet, click the + Create Account button next to the dropdown. A quick-create panel opens where you can enter the account name, type, and number without leaving the wizard.

Saving Mapping Templates

If you plan to import additional IIF files in the future (for example, monthly transaction exports during a phased migration), you can save your mapping as a template:

1. After completing all mappings, click Save as Template at the bottom of the wizard.
2. Give the template a name (e.g., "QuickBooks Desktop — Full Migration").
3. The next time you upload an IIF file, Wired Church will offer to apply the saved template, pre-filling all mappings that match.

---

Step 4: Preview the Import

Before any data is written to your Wired Church ledger, the wizard shows a full preview of what will be imported.

Preview Tabs

The preview is organized into tabs based on data type:

1. Accounts — Lists every account that will be created or updated in your chart of accounts. New accounts are marked with a blue "New" badge. Existing accounts that match are marked with a gray "Existing" badge and will not be duplicated.
2. Transactions — Lists every transaction with date, description, accounts affected, and amounts. Debits and credits are shown side by side for each journal entry.
3. Vendors — Lists every vendor record that will be created. Existing vendors with matching names are flagged and will not be duplicated.

Duplicate Detection

Wired Church checks for duplicates using the following criteria:

• Accounts — Matched by account number and name. If an account with the same number already exists, it will not be re-created.
• Transactions — Matched by date, amount, and memo. Potential duplicates are flagged with an orange warning badge. You can choose to include or exclude each flagged transaction.
• Vendors — Matched by exact name. Duplicate vendors are skipped automatically.

---

Step 5: Confirm and Execute the Import

Once you have reviewed the preview and resolved any duplicate flags:

1. Click Confirm Import at the bottom of the preview screen.
2. A confirmation dialog summarizes the import: number of accounts, transactions, and vendors to be created.
3. Click Import Now to execute.

The import runs in the background. A progress bar shows the status. For large imports (thousands of transactions), this may take a few minutes. You can navigate away — the import will continue, and a notification will appear when it completes.

---

What Gets Imported

Here is a detailed breakdown of what each data type includes:

What Is NOT Imported

• Customer/donor records — QuickBooks customers do not map to the church member model. Use the Members import for donor data.
• Invoices and estimates — Churches rarely use these; they are skipped during IIF parsing.
• Payroll details — Use the dedicated SurePayroll Import for payroll data.
• Budget data — Budgets are configured separately in Wired Church under Finance > Budgets.

---

Rolling Back an Import

If something went wrong — wrong mappings, duplicate data, or an incorrect date range — you can roll back the entire import:

1. Navigate to Finance > Imports and click the Import History tab.
2. Find the IIF import you want to reverse. Each import is listed with its date, file name, and record counts.
3. Click the Rollback button on the import row.
4. A confirmation dialog warns that all records created by this import will be deleted. Transactions, newly created accounts (if they have no other activity), and vendor records from this import will be removed.
5. Click Confirm Rollback.

---

Common IIF Format Issues and Fixes

"Invalid IIF format" Error on Upload

• Cause: The file was saved with the wrong encoding or was modified in Excel. Excel often converts tab-delimited files to CSV when saving.
• Fix: Re-export the file from QuickBooks Desktop. Do not open it in Excel before uploading. If you must inspect the file, use a plain text editor like Notepad or TextEdit.

"Unrecognized header row" Error

• Cause: The IIF file has been truncated or corrupted during download or email transfer.
• Fix: Re-export from QuickBooks. Transfer the file using a USB drive or cloud storage rather than email, which can sometimes strip or modify file contents.

Transactions Show Wrong Amounts

• Cause: QuickBooks may export amounts with inconsistent decimal formatting based on your regional settings.
• Fix: Check that your QuickBooks Desktop regional settings match US currency formatting (period as decimal separator, comma as thousands separator). Re-export after correcting.

Missing Accounts in the Mapping Wizard

• Cause: Some accounts in the IIF file may use types that Wired Church does not recognize (e.g., non-standard account types from QuickBooks Enterprise).
• Fix: These accounts appear in an "Unrecognized" section at the bottom of the mapping wizard. Manually assign each one to the correct account type and map it to an existing or new account.

File Contains HTML or XML Content

• Cause: You may have accidentally exported from QuickBooks Online (which produces HTML reports) instead of QuickBooks Desktop.
• Fix: IIF is a QuickBooks Desktop format only. For QuickBooks Online data, export as CSV and use the QuickBooks CSV Import instead.

---

Frequently Asked Questions

Can I import multiple IIF files? Yes. You can upload and import as many IIF files as needed. Each import is tracked separately in the Import History, and each can be rolled back independently.

Does importing overwrite existing data? No. Imports only create new records. Existing accounts, transactions, and vendors are never modified by an import. Duplicates are detected and flagged for your review.

How long does an import take? Small files (under 500 transactions) complete in seconds. Larger files (5,000+ transactions) may take 2-5 minutes. The import runs in the background, so you can continue using Wired Church while it processes.

Can I import data from multiple QuickBooks company files? Yes. If your church maintained separate QuickBooks files for different campuses or funds, import each file separately. Use unique mapping templates for each file if their chart of accounts differ.

---

Related Articles

• QuickBooks Desktop Import — CSV Files
• Mapping Accounts During Import
• SurePayroll Import
• Understanding Your Chart of Accounts
• Setting Up Funds