Generator/Guides/Importing to QuickBooks®

Importing to QuickBooks®

Step-by-step instructions for importing your Chart of Accounts into QuickBooks® Desktop and QuickBooks® Online.

QuickBooks® Desktop (IIF)

Pro, Premier, Enterprise

Back Up Your Company File

Before any import, create a backup: File → Create Backup → Create Local Backup

Open the Import Menu

Navigate to File → Utilities → Import → IIF Files

Select Your IIF File

Browse to the downloaded chart-of-accounts.iif file and click Open.

Confirm Import

QuickBooks® will display a confirmation message. Click OK to complete the import.

Verify Accounts

Go to Lists → Chart of Accounts to verify all accounts were imported correctly.

💡 Desktop Tips

• Enable account numbers: Edit → Preferences → Accounting → Company Preferences
• Duplicate account names will cause import errors
• Close all other QuickBooks® windows before importing

QuickBooks® Online (CSV)

Simple Start, Essentials, Plus, Advanced

Open Import Settings

Click the Settings (⚙️) gear icon, then select Import Data

Select Chart of Accounts

From the import options, choose Chart of Accounts

Upload Your CSV File

Click Browse and select your downloaded chart-of-accounts.csv file.

Map the Columns

QuickBooks® will auto-detect columns. Verify that Account Name, Type, and Detail Type are correctly mapped.

Review and Import

Review the preview, check for any warnings, then click Import to complete.

💡 Online Tips

• Best to import when first setting up your company
• QuickBooks® Online has a 250 account limit (Simple Start/Essentials/Plus)
• After import, add opening balances via journal entry

Troubleshooting Common Issues

❌ "Duplicate account name" Error

An account with that name already exists. Either rename the account in your file or delete the existing account in QuickBooks® first.

❌ "Invalid account type" Error

The account type code is not recognized. Make sure you're using the correct format (IIF for Desktop, CSV for Online).

❌ Accounts Not Showing After Import

Check if accounts are marked as inactive. Go to Chart of Accounts and enable "Include inactive" to view them.

❌ "Column mapping failed" in QBO

Ensure your CSV has the required columns: Account Name, Type, and Detail Type. Our generator includes all required columns.

Need to Generate a Chart of Accounts?

Use our free generator with industry templates to create your file.

Start Generator

Loading tool...